当前文件路径：AjaxMail/App_Code/User.cs

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using Web2ASPNET2.OperateSqlServer;
 11using System.Data.SqlClient;
 12
 13namespace Web2ASPNET2.ASPNET2AjaxMail
 14...{
 15    public class User
 16    ...{
 17        public User()
 18        ...{
 19            /**////
 20        }
 21
 22        public SqlDataReader GetUsers()
 23        ...{
 24            return DataCommon.GetDataByReader("Pr_GetUsers");
 25        }
 26
 27        public DataSet GetUsersByDS()
 28        ...{
 29            return DataCommon.GetDataByDataSet("Pr_GetUsers");
 30        }
 31
 32        public SqlDataReader GetSingleUser(int userID)
 33        ...{
 34            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleUser",userID);
 35        }
 36
 37        public int CheckUser(string userName)
 38        ...{
 39            SqlParameter[] parameters = ...{
 40                OperateDatabase.CreateInParam("@UserName",SqlDbType.VarChar,50,userName)
 41            };
 42            return (OperateDatabase.RunProcScalar("Pr_CheckUser",parameters));
 43        }
 44
 45        public SqlDataReader GetUserLogin(string name,string password)
 46        ...{    /**////定义保存从数据库获取的结果的DataReader
 47            SqlDataReader dr = null;
 48            /**////添加存储过程的参数
 49            SqlParameter[] parameters = ...{
 50                OperateDatabase.CreateInParam("@UserName",SqlDbType.VarChar,50,name),
 51                OperateDatabase.CreateInParam("@Password",SqlDbType.VarChar,255,password)
 52            };
 53            /**////执行存储过程
 54            OperateDatabase.RunProc("Pr_GetUserLogin",out dr,parameters);
 55
 56            /**////返回从数据库获取的结果
 57            return dr;
 58        }
 59
 60        public int AddUser(string userName,string password,int roleID,
 61            string email)
 62        ...{
 63            SqlParameter[] parameters = ...{
 64                OperateDatabase.CreateInParam("@UserName",SqlDbType.VarChar,50,userName),
 65                OperateDatabase.CreateInParam("@Password",SqlDbType.VarChar,255,password),
 66                OperateDatabase.CreateInParam("@RoleID",SqlDbType.Int,4,roleID),
 67                OperateDatabase.CreateInParam("@Email",SqlDbType.VarChar,255,email)
 68            };
 69            return (OperateDatabase.RunProc("Pr_AddUser",parameters));
 70        }
 71
 72        public int UpdateUser(int userID,string email)
 73        ...{
 74            SqlParameter[] parameters = ...{
 75                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,userID),
 76                OperateDatabase.CreateInParam("@Email",SqlDbType.VarChar,255,email)                
 77            };
 78            return (OperateDatabase.RunProc("Pr_UpdateUser",parameters));
 79        }
 80
 81        public int UpdateUserPassword(int userID,string password)
 82        ...{
 83            SqlParameter[] parameters = ...{
 84                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,userID),
 85                OperateDatabase.CreateInParam("@Password",SqlDbType.VarChar,255,password)
 86            };
 87            return (OperateDatabase.RunProc("Pr_UpdateUserPwd",parameters));
 88        }
 89
 90        public int UpdateUserRole(int userID,int roleID)
 91        ...{
 92            SqlParameter[] parameters = ...{
 93                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,userID),
 94                OperateDatabase.CreateInParam("@RoleID",SqlDbType.Int,4,roleID)
 95            };
 96            return (OperateDatabase.RunProc("Pr_UpdateUserRole",parameters));
 97        }
 98
 99        public int DeleteUser(int userID)
100        ...{
101            return DataCommon.QueryDataIDParam("Pr_DeleteUser",userID);
102        }
103    }
104}
105