admin.cs

烟草公司应用网站

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
namespace BLL
{
    public class Admin
    {
        public static void Insert(string InsertCon,Model.Admin admin)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@AdminName",SqlDbType.VarChar,50),
                new SqlParameter("@AdminPassword",SqlDbType.VarChar ,200)
            };
            ps[0].Value = admin.AdminName;
            ps[1].Value = DESEncrypt.Encrypt(admin.AdminPassword, admin.AdminName);
            DbHelper.ExecuteNonQuery(InsertCon, CommandType.StoredProcedure, "AdminInsert", ps);
        }
        public static void Update(string UpdateCon, Model.Admin admin)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@AdminID",SqlDbType .Int),
                new SqlParameter("@AdminName",SqlDbType.VarChar,50),
                new SqlParameter("@AdminPassword",SqlDbType.VarChar ,200)
            };
            ps[0].Value =admin .AdminID;
            ps[1].Value = admin.AdminName;
            ps[2].Value = DESEncrypt.Encrypt(admin.AdminPassword, admin.AdminName);
            DbHelper.ExecuteNonQuery(UpdateCon, CommandType.StoredProcedure, "AdminUpdate", ps);
        }
        public static void Delete(string DeleteCon,string ID)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@AdminID",SqlDbType.Int)
            };
            ps[0].Value = Convert.ToInt32(ID);
            DbHelper.ExecuteNonQuery(DeleteCon, CommandType.StoredProcedure, "AdminDelete", ps);
        }
        public static string Login(string LoginCon, string AdminName)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@AdminName",SqlDbType.VarChar ,50)
            };
            ps[0].Value = AdminName;
            DataSet myDS = DbHelper.ExecuteDataset(LoginCon, CommandType.StoredProcedure, "AdminLogin", ps);
            string password ="";
            try
            {
                password += DESEncrypt.Decrypt(myDS.Tables[0].Rows[0]["AdminPassword"].ToString(), myDS.Tables[0].Rows[0]["AdminName"].ToString());
            }
            catch
            { 
            }
            return password;
        }
        public static char  LoginPower(string LoginCon, string AdminName)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@AdminName",SqlDbType.VarChar ,50)
            };
            ps[0].Value = AdminName;
            DataSet myDS = DbHelper.ExecuteDataset(LoginCon, CommandType.StoredProcedure, "AdminLogin", ps);
            char Power='2';
            try
            {
                Power = Convert.ToChar(myDS.Tables[0].Rows[0]["AdminPower"].ToString());
            }
            catch
            {
            }
            return Power ;
        }
        public static int GetID(string SelectCon, string AdminName)
        {
            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@AdminName",SqlDbType.VarChar ,50)
            };
            ps[0].Value = AdminName;
            DataSet myDS = DbHelper.ExecuteDataset(SelectCon, CommandType.StoredProcedure, "AdminSelectID", ps);
            return Convert.ToInt32(myDS .Tables[0].Rows[0][0].ToString());
        }

        public static DataSet Select(string SelectCon)
        {
            DataSet myDS = DbHelper.ExecuteDataset(SelectCon, CommandType.StoredProcedure, "AdminSelect");
            for (int i = 0; i < myDS.Tables[0].Rows.Count;i++ )
            {
                myDS.Tables[0].Rows[i]["AdminPassword"] = DESEncrypt.Decrypt(myDS.Tables[0].Rows[i]["AdminPassword"].ToString(), myDS.Tables[0].Rows[i]["AdminName"].ToString());
            }
            return myDS;
        }
    }
}