918博天堂

?#pragma checksum "D:\wwwroot\nuoya\wwwroot\App_Code\AdminManager.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "23A644F0DF0D63614A75C46A15D5357B"

#line 1 "D:\wwwroot\nuoya\wwwroot\App_Code\AdminManager.cs"
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using TMCCache;

/// <summary>
/// AdminManager 的提要注明
/// </summary>
public class AdminManager:IDisposable
{
    private static string conn = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING3"].ConnectionString);
	public AdminManager()
	{
		//
		// TODO: 在此处增长机关函数逻辑
		//
	}

    public  bool CheckUser(string username, string password)
    {
        object pw = OleDbHelper.ExecuteScalar(conn, CommandType.Text, "select pwd from [admin] where loginname='"+StringManager.FunStr(username)+"'");

        if (pw+"" ==password)
        {
            return true;
        }
        else
        {
            return false;
        }
    }


    #region IDisposable 成员

    public void Dispose()
    {
        
    }

    #endregion

    public DataSet getList()
    {
        return OleDbHelper.ExecuteDataset(conn, CommandType.Text, "select id,loginname from [admin] order by id desc");
    }

    public int Delete(string id)
    {
        return OleDbHelper.ExecuteNonQuery(conn, CommandType.Text, "delete from [admin] where id="+id);
    }

    public string getloginname(string id)
    {
        return OleDbHelper.ExecuteScalar(conn, CommandType.Text, "select loginname from [admin] where id="+id)+"";
    }

    public int addAdmin(string name, object pwd)
    {
        return OleDbHelper.ExecuteNonQuery(conn, CommandType.Text, "insert into [admin]([loginname],[pwd]) values('"+name+"','"+pwd+"')");
    }

    public int editAdmin(string ln, object pw, string id)
    {
        return OleDbHelper.ExecuteNonQuery(conn, CommandType.Text, "update [admin] set [loginname]='"+ln+"',[pwd]='"+pw+"' where id="+id);
    }

    public bool Checkpw(string id, object pw)
    {
        string pwd = OleDbHelper.ExecuteScalar(conn,CommandType.Text,"select pwd from [admin] where id="+id)+"";
        if (pwd == pw + "")
            return true;
        else
            return false;
    }

    public int addlinks(string name, string url, string sorts)
    {
        return OleDbHelper.ExecuteNonQuery(conn, CommandType.Text, "insert into t_links([name],[linkurl],[sorts]) values('"+name+"','"+url+"',"+sorts+")");
    }

    public int editlinks(string name, string url, string sorts, string id)
    {
        return OleDbHelper.ExecuteNonQuery(conn, CommandType.Text, "update t_links set [name]='" + name + "',[linkurl]='" + url + "',[sorts]=" + sorts + " where id="+id);
    }

    public int addlinks(string name, string url, string sorts,string tn)
    {
        return OleDbHelper.ExecuteNonQuery(conn, CommandType.Text, "insert into " + tn + "([name],[linkurl],[sorts]) values('" + name + "','" + url + "'," + sorts + ")");
    }

    public int editlinks(string name, string url, string sorts, string id, string tn)
    {
        return OleDbHelper.ExecuteNonQuery(conn, CommandType.Text, "update " + tn + " set [name]='" + name + "',[linkurl]='" + url + "',[sorts]=" + sorts + " where id=" + id);
    }

    public void CheckAdmin()
    {
        string sysadmin = StringHelper.GetCookie("sysadmin");
        string spwd = StringHelper.GetCookie("syspwd");
        DataTable dt = null;
        if (DataCache.GetCache("admin") != null)
            dt = (DataTable)DataCache.GetCache("admin");
        else
        {
            dt = OleDbHelper.ExecuteDataset(conn, CommandType.Text, "select * from [admin]").Tables[0];
            DataCache.SetCache("admin", dt);
        }
        bool flag = false;
        foreach (DataRow dr in dt.Rows)
        {
            string aaa = dr["loginname"].ToString();
            string bbb = dr["pwd"].ToString();
            if (sysadmin.Equals(dr["loginname"].ToString()) && spwd.Equals(dr["pwd"].ToString()))
            {
                flag = true;
                break;
            }
        }
        if(!flag)
        HttpContext.Current.Response.Redirect("login.aspx");
        //return flag;

    }

    public static DataSet getDefaultImageList()
    {
        return OleDbHelper.ExecuteDataset(conn, CommandType.Text, "select * from t_ads where id<4");
    }
}


#line default
#line hidden