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//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
 13
 14namespace Web2ASPNET2.WebTags
 15...{
 16    public class User
 17    ...{
 18        public User()
 19        ...{
 20            /**////
 21        }
 22
 23        public SqlDataReader GetUsers()
 24        ...{
 25            return DataCommon.GetDataByReader("Pr_GetUsers");
 26        }
 27
 28        public DataSet GetUsersByDS()
 29        ...{
 30            return DataCommon.GetDataByDataSet("Pr_GetUsers");
 31        }
 32
 33        public SqlDataReader GetSingleUser(int userID)
 34        ...{
 35            return DataCommon.GetDataByReaderIDParam("Pr_GetSingleUser",userID);
 36        }
 37
 38        public int CheckUser(string userName)
 39        ...{
 40            SqlParameter[] parameters = ...{
 41                OperateDatabase.CreateInParam("@UserName",SqlDbType.VarChar,50,userName)
 42            };
 43            return (OperateDatabase.RunProcScalar("Pr_CheckUser",parameters));
 44        }
 45
 46        public SqlDataReader GetUserLogin(string name,string password)
 47        ...{    /**////定义保存从数据库获取的结果的DataReader
 48            SqlDataReader dr = null;
 49            /**////添加存储过程的参数
 50            SqlParameter[] parameters = ...{
 51                OperateDatabase.CreateInParam("@UserName",SqlDbType.VarChar,50,name),
 52                OperateDatabase.CreateInParam("@Password",SqlDbType.VarChar,255,password)
 53            };
 54            /**////执行存储过程
 55            OperateDatabase.RunProc("Pr_GetUserLogin",out dr,parameters);
 56
 57            /**////返回从数据库获取的结果
 58            return dr;
 59        }
 60
 61        public int AddUser(string userName,string password,int roleID,
 62            string email)
 63        ...{
 64            SqlParameter[] parameters = ...{
 65                OperateDatabase.CreateInParam("@UserName",SqlDbType.VarChar,50,userName),
 66                OperateDatabase.CreateInParam("@Password",SqlDbType.VarChar,255,password),
 67                OperateDatabase.CreateInParam("@RoleID",SqlDbType.Int,4,roleID),
 68                OperateDatabase.CreateInParam("@Email",SqlDbType.VarChar,255,email)
 69            };
 70            return (OperateDatabase.RunProc("Pr_AddUser",parameters));
 71        }
 72
 73        public int UpdateUser(int userID,string email)
 74        ...{
 75            SqlParameter[] parameters = ...{
 76                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,userID),
 77                OperateDatabase.CreateInParam("@Email",SqlDbType.VarChar,255,email)                
 78            };
 79            return (OperateDatabase.RunProc("Pr_UpdateUser",parameters));
 80        }
 81
 82        public int UpdateUserPassword(int userID,string password)
 83        ...{
 84            SqlParameter[] parameters = ...{
 85                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,userID),
 86                OperateDatabase.CreateInParam("@Password",SqlDbType.VarChar,255,password)
 87            };
 88            return (OperateDatabase.RunProc("Pr_UpdateUserPwd",parameters));
 89        }
 90
 91        public int UpdateUserRole(int userID,int roleID)
 92        ...{
 93            SqlParameter[] parameters = ...{
 94                OperateDatabase.CreateInParam("@ID",SqlDbType.Int,4,userID),
 95                OperateDatabase.CreateInParam("@RoleID",SqlDbType.Int,4,roleID)
 96            };
 97            return (OperateDatabase.RunProc("Pr_UpdateUserRole",parameters));
 98        }
 99
100        public int DeleteUser(int userID)
101        ...{
102            return DataCommon.QueryDataIDParam("Pr_DeleteUser",userID);
103        }
104    }
105}
106