adminda.cs

项目名称eShop

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 System.Data.OleDb;

/// <summary>
/// AdminDA 的摘要说明
/// </summary>
public class AdminDA:DBObject
{
	public AdminDA()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    //添加管理员信息
    public int AddAdmin(AdminVO adminVO)
    {
        //flag用来表示添加状态，返回信息
        int flag = 0;
        //添加管理员信息
        using (connEShop)
        {
            string strSQL = "insert into T_ADMIN(F_USERCODE,F_PASSWORD)"
              + " values(@userCode,@password)";
            using (OleDbCommand cmdAdminAdd = new OleDbCommand(strSQL, connEShop))
            {
                cmdAdminAdd.Parameters.Add(new OleDbParameter("@userCode", adminVO.UserCode));
                cmdAdminAdd.Parameters.Add(new OleDbParameter("@password", adminVO.Password));

                connEShop.Open();
                flag = cmdAdminAdd.ExecuteNonQuery();
            }

        }
        //修改T_USER表中的F_ISADMIN字段,调用userDA的相关方法
        AdminDA adminDA = new AdminDA();
        flag = flag + adminDA.TurnToAdmin(adminVO.UserCode);
        return flag;
    }

    //删除管理员信息
    public int DeleteAdmin(string userCode)
    {
        //flag用来表示添加状态，返回信息
        int flag = 0;
        //删除管理员信息
        using (connEShop)
        {
            string strSQL = "delete from T_ADMIN where F_USERCODE=@userCode";
            using (OleDbCommand cmdDeleteAdmin = new OleDbCommand(strSQL, connEShop))
            {
                cmdDeleteAdmin.Parameters.Add(new OleDbParameter("@userCode",userCode));

                connEShop.Open();
                flag = cmdDeleteAdmin.ExecuteNonQuery();
            }

        }
        //修改T_USER表中的F_ISADMIN字段,调用userDA的相关方法
        AdminDA adminDA = new AdminDA();
        flag = flag + adminDA.TurnToUser(userCode);
        return flag;
    }

    //修改管理员密码
    public int UpdateAdminPassword(AdminVO adminVO)
    {
        //flag用来表示添加状态，返回信息
        int flag = 0;
        //修改管理员密码
        using (connEShop)
        {
            string strSQL = "update T_ADMIN set F_PASSWORD=@password where F_USERCODE=@userCode";

            using (OleDbCommand cmdUpdateAdminPassword = new OleDbCommand(strSQL, connEShop))
            {
                
                cmdUpdateAdminPassword.Parameters.Add(new OleDbParameter("@password", adminVO.Password));
                cmdUpdateAdminPassword.Parameters.Add(new OleDbParameter("@userCode", adminVO.UserCode));
                                

                connEShop.Open();
                flag = cmdUpdateAdminPassword.ExecuteNonQuery();
            }
        }
        return flag;
    }

    //验证用户登录，取出用户的userID
    public int CheckAdmin(string strName, string strPassword)
    {
        int flag = 0;
        string strSql = "select F_USERCODE from T_ADMIN where F_USERCODE=@userCode and F_PASSWORD=@password";
        using (connEShop)
        {
            using (OleDbCommand cmdCheckAdmin = new OleDbCommand(strSql, connEShop))
            {
                OleDbParameter pAdminName = new OleDbParameter("@userCode", OleDbType.Char, 50);
                pAdminName.Value = strName;
                OleDbParameter pAdminPassword = new OleDbParameter("@password", OleDbType.Char, 32);
                pAdminPassword.Value = strPassword;

                cmdCheckAdmin.Parameters.Add(pAdminName);
                cmdCheckAdmin.Parameters.Add(pAdminPassword);

                cmdCheckAdmin.Connection.Open();
                OleDbDataReader dtrAdmin = cmdCheckAdmin.ExecuteReader();
                if (dtrAdmin.Read())
                {
                    flag = 1;
                }
                return flag;
            }
        }
    }


    //当T_ADMIN表添加管理员后，将T_USER表中F_ISADMIN字段修改为是
    public int TurnToAdmin(string userCode)
    {
        //flag用来表示添加状态，返回信息
        int flag = 0;
        //修改信息
        using (connEShop)
        {
            string strSQL = "update T_USER set F_ISADMIN=@isAdmin where F_USERCODE=@userCode";
            using (OleDbCommand cmdTurnToAdmin = new OleDbCommand(strSQL, connEShop))
            {
                cmdTurnToAdmin.Parameters.Add(new OleDbParameter("@isAdmin", "是"));
                cmdTurnToAdmin.Parameters.Add(new OleDbParameter("@userCode", userCode));

                connEShop.Open();
                flag = cmdTurnToAdmin.ExecuteNonQuery();
            }
        }
        return flag;
    }

    //当T_ADMIN表删除管理员后，将T_USER表中F_ISADMIN字段修改为"否"
    public int TurnToUser(string userCode)
    {
        //flag用来表示添加状态，返回信息
        int flag = 0;
        //修改信息
        using (connEShop)
        {
            string strSQL = "update T_USER set F_ISADMIN=@isAdmin where F_USERCODE=@userCode";
            using (OleDbCommand cmdTurnToUser = new OleDbCommand(strSQL, connEShop))
            {
                cmdTurnToUser.Parameters.Add(new OleDbParameter("@isAdmin", "否"));
                cmdTurnToUser.Parameters.Add(new OleDbParameter("@userCode", userCode));

                connEShop.Open();
                flag = cmdTurnToUser.ExecuteNonQuery();
            }
        }
        return flag;
    }
}