方法中的添加参数写法不好，要按照Users类里面的方法来写。这样就不用管参数的顺序了。
返回的DataTable用于作为绑定Repeater控件的数据源
1 using System; 2 using System.Collections.Generic; 3 using System.Linq; 4 using System.Web; 5 using System.Data.SqlClient; 6 using System.Data; 7 8 ///9 ///Employees 的摘要说明 10 /// 11 public class Employees 12 { 13 //声明8个私有字段 14 private int id; 15 private string name; 16 private string password; 17 private string telephone; 18 private string idcardNumber = string.Empty; 19 private string address = string.Empty; 20 private string deliverPoint = string.Empty; 21 private string type; 22 //声明8个公共属性 23 public int ID 24 { 25 get 26 { 27 return this.id; 28 } 29 set { this.id = value; } 30 31 } 32 public string Name 33 { 34 get { return this.name; } 35 set { this.name = value; } 36 } 37 public string Password 38 { 39 get { return this.password; } 40 set { this.password = value; } 41 } 42 public string Telephone 43 { 44 get { return this.telephone; } 45 set { this.telephone = value; } 46 } 47 public string IdcardNumber 48 { 49 get { return this.idcardNumber; } 50 set { this.idcardNumber = value; } 51 } 52 public string Address 53 { 54 get { return this.address; } 55 set { this.address = value; } 56 } 57 public string DeliverPoint 58 { 59 get { return this.deliverPoint; } 60 set { this.deliverPoint = value; } 61 } 62 public string Type 63 { 64 get { return this.type; } 65 set { this.type = value; } 66 } 67 public Employees() 68 { 69 // 70 //TODO: 在此处添加构造函数逻辑 71 // 72 } 73 //重载构造函数 74 public Employees(int UserId, string UserName, string UserPwd,string Telephone,string IdcardNumber, string Address, string DeliverPoint, string type) 75 { 76 this.id = UserId; 77 this.name = UserName; 78 this.password = UserPwd; 79 this.telephone = Telephone; 80 this.idcardNumber = IdcardNumber; 81 this.address = Address; 82 this.deliverPoint = DeliverPoint; 83 this.type = Type; 84 } 85 public Employees(SqlDataReader Dr) 86 { 87 this.id = Convert.ToInt32(Dr["ID"]); 88 this.name = Dr["Name"].ToString(); 89 this.password = Dr["Password"].ToString(); 90 this.telephone = Dr["Telephone"].ToString(); 91 this.idcardNumber = Dr["IdcardNumber"].ToString(); 92 this.address = Dr["Address"].ToString(); 93 this.deliverPoint = Dr["DeliverPoint"].ToString(); 94 this.type = Dr["Type"].ToString(); 95 } 96 97 //添加公共静态方法 98 99 //添加用户 100 public static bool AddEmployee(Employees singleUser) 101 { 102 bool Flage = false; 103 string procname = "dbo.AddEmployee"; 104 SqlParameter[] prams = { new SqlParameter("@name",SqlDbType.NVarChar,50), 105 new SqlParameter("@password",SqlDbType.NVarChar,50), 106 new SqlParameter("@telephone",SqlDbType.NVarChar,50), 107 new SqlParameter("@address",SqlDbType.NVarChar,100), 108 new SqlParameter("@idcardNumber",SqlDbType.NVarChar,100), 109 new SqlParameter("@deliverPoint",SqlDbType.NVarChar,50), 110 new SqlParameter("@type",SqlDbType.NVarChar,50)}; 111 prams[0].Value = singleUser.Name; 112 prams[1].Value = singleUser.Password; 113 prams[2].Value = singleUser.Telephone; 114 prams[3].Value = singleUser.Address; 115 prams[4].Value = singleUser.IdcardNumber; 116 prams[5].Value = singleUser.DeliverPoint; 117 prams[6].Value = singleUser.Type; 118 int intResult = DBHelper.RunExecute(procname, prams); 119 if (intResult > 0) 120 { 121 Flage = true; 122 } 123 return Flage; 124 } 125 //删除用户 126 public static bool DeleteEmployee(Employees singleUser) 127 { 128 bool Flage = false; 129 string procname = "dbo.DeleteEmployee"; 130 SqlParameter[] prams = { new SqlParameter("@ID", SqlDbType.Int) }; 131 prams[0].Value = singleUser.ID; 132 int intResult = DBHelper.RunExecute(procname, prams); 133 if (intResult > 0) 134 { 135 Flage = true; 136 } 137 return Flage; 138 } 139 //更新用户信息 140 public static bool UpdateEmployee(Employees singleUser) 141 { 142 bool Flage = false; 143 string procname = "dbo.UpdateEmployee"; 144 SqlParameter[] prams = { new SqlParameter("@userID",SqlDbType.Int), 145 new SqlParameter("@name",SqlDbType.NVarChar,50), 146 new SqlParameter("@password",SqlDbType.NVarChar,50), 147 new SqlParameter("@telephone",SqlDbType.NVarChar,50), 148 new SqlParameter("@address",SqlDbType.NVarChar,100), 149 new SqlParameter("@idcardNumber",SqlDbType.NVarChar,100), 150 new SqlParameter("@deliverPoint",SqlDbType.NVarChar,50), 151 new SqlParameter("@type",SqlDbType.NVarChar,50)}; 152 prams[0].Value = singleUser.ID; 153 prams[1].Value = singleUser.Name; 154 prams[2].Value = singleUser.Password; 155 prams[3].Value = singleUser.Telephone; 156 prams[4].Value = singleUser.Address; 157 prams[5].Value = singleUser.IdcardNumber; 158 prams[6].Value = singleUser.DeliverPoint; 159 int intResult = DBHelper.RunExecute(procname, prams); 160 if (intResult > 0) 161 { 162 Flage = true; 163 } 164 return Flage; 165 } 166 //修改密码 167 public static bool ChangeEmployeePwd(int UserId, string UserPwd) 168 { 169 bool Flage = false; 170 string procname = "dbo.ChangeEmployeePwd"; 171 SqlParameter[] prams = { new SqlParameter("@ID",SqlDbType.Int), 172 new SqlParameter("@password",SqlDbType.NVarChar,50)}; 173 prams[0].Value = UserId; 174 prams[1].Value = UserPwd; 175 int intResult = DBHelper.RunExecute(procname, prams); 176 if (intResult > 0) 177 { 178 Flage = true; 179 } 180 return Flage; 181 } 182 //验证用户 183 public static bool ValidateAdmin(string UserName, string UserPwd) 184 { 185 bool Flage = false; 186 string procname = "dbo.ValidateAdmin"; 187 SqlParameter[] prams = { new SqlParameter("@name",SqlDbType.NVarChar,50), 188 new SqlParameter("@password",SqlDbType.NVarChar,50)}; 189 prams[0].Value = UserName; 190 prams[1].Value = UserPwd; 191 int intResult = DBHelper.RunExecuteScalar(procname, prams); 192 if (intResult > 0) 193 { 194 Flage = true; 195 } 196 return Flage; 197 } 198 public static bool ValidateBoss(string UserName, string UserPwd) 199 { 200 bool Flage = false; 201 string procname = "dbo.ValidateBoss"; 202 SqlParameter[] prams = { new SqlParameter("@userName",SqlDbType.NVarChar,50), 203 new SqlParameter("@password",SqlDbType.NVarChar,50)}; 204 prams[0].Value = UserName; 205 prams[1].Value = UserPwd; 206 int intResult = DBHelper.RunExecuteScalar(procname, prams); 207 if (intResult > 0) 208 { 209 Flage = true; 210 } 211 return Flage; 212 } 213 //验证用户名是否存在 214 public static bool IsValidateEmployeeName(string UserName) 215 { 216 bool Flage = false; 217 string procname = "dbo.IsValidateEmployeeName"; 218 SqlParameter[] prams = { new SqlParameter("@name", SqlDbType.NVarChar, 50) }; 219 prams[0].Value = UserName; 220 int intResult = DBHelper.RunExecuteScalar(procname, prams); 221 if (intResult > 0) 222 { 223 Flage = true; 224 } 225 return Flage; 226 } 227 //返回所以用户，用泛型List228 public static List GetAllEmployees() 229 { 230 List allUsers = new List (); 231 string procname = "dbo.GetAllEmployees"; 232 SqlDataReader Dr = DBHelper.RunProcGetReader(procname); 233 while (Dr.Read()) 234 { 235 allUsers.Add(new Employees(Dr)); 236 } 237 Dr.Close(); 238 return allUsers; 239 } 240 public static string GetEmployeeNameById(int UserId) 241 { 242 string strUserName = string.Empty; 243 string procname = "dbo.GetEmployeeNameById"; 244 SqlParameter[] prams = { new SqlParameter("@ID", SqlDbType.Int) }; 245 prams[0].Value = UserId; 246 SqlDataReader Dr = DBHelper.RunProcGetReader(procname, prams); 247 while (Dr.Read()) 248 { 249 strUserName = Dr["Name"].ToString(); 250 } 251 Dr.Close(); 252 return strUserName; 253 } 254 public static Employees GetEmployeeById(int UserId) 255 { 256 Employees singleUser = null; 257 string procname = "dbo.GetEmployeeById"; 258 SqlParameter[] prams = { new SqlParameter("@ID", SqlDbType.Int) }; 259 prams[0].Value = UserId; 260 SqlDataReader Dr = DBHelper.RunProcGetReader(procname, prams); 261 while (Dr.Read()) 262 { 263 singleUser = new Employees(Dr); 264 } 265 Dr.Close(); 266 return singleUser; 267 } 268 public static int GetIdByEmployeeName(string UserName) 269 { 270 int intUserId = 0; 271 string procname = "dbo.GetIdByEmployeeName"; 272 SqlParameter[] prams = { new SqlParameter("@name", SqlDbType.NVarChar, 50) }; 273 prams[0].Value = UserName; 274 SqlDataReader Dr = DBHelper.RunProcGetReader(procname, prams); 275 while (Dr.Read()) 276 { 277 intUserId = Convert.ToInt32(Dr["ID"]); 278 } 279 Dr.Close(); 280 return intUserId; 281 } 282 public static string GetDeliverPointByEmployeeID(int employeeID) 283 { 284 string deliverPoint = string.Empty; 285 string procname = "dbo.GetDeliverPointByEmployeeID"; 286 SqlParameter[] prams = { new SqlParameter("@userID", SqlDbType.Int) }; 287 prams[0].Value = employeeID; 288 SqlDataReader Dr = DBHelper.RunProcGetReader(procname, prams); 289 while (Dr.Read()) 290 { 291 deliverPoint = Dr["deliverPoint"].ToString().Trim(); 292 } 293 Dr.Close(); 294 return deliverPoint; 295 } 296 297 public static string GetDeliverPointByEmployeeName(string employeeName) 298 { 299 string deliverPoint = string.Empty; 300 string procname = "dbo.GetDeliverPointByEmployeeName"; 301 SqlParameter[] prams = { new SqlParameter("@name", SqlDbType.NVarChar, 50) }; 302 prams[0].Value = employeeName; 303 SqlDataReader Dr = DBHelper.RunProcGetReader(procname, prams); 304 while (Dr.Read()) 305 { 306 deliverPoint = Dr["deliverPoint"].ToString().Trim(); 307 } 308 Dr.Close(); 309 return deliverPoint; 310 } 311 public static DataTable GetordersByDeliverPoint(string deliverPoint) 312 { 313 string procname = "dbo.GetordersByDeliverPoint"; 314 SqlParameter[] prams = { new SqlParameter("@deliverPoint", SqlDbType.NVarChar, 50) }; 315 prams[0].Value = deliverPoint; 316 DataTable allOrder = DBHelper.RunProcGetTable(procname, prams); 317 return allOrder; 318 } 319 public static DataTable GetEmployeesByAdmin() 320 { 321 322 string procname = "dbo.GetEmployeesByAdmin"; 323 SqlParameter[] prams = { new SqlParameter("@type", SqlDbType.NVarChar,50) }; 324 prams[0].Value = procname; 325 DataTable adminEmployees = DBHelper.RunProcGetTable(procname); 326 327 return adminEmployees; } 328 public static DataTable GetEmployeesByBoss() 329 { 330 331 string procname = "dbo.GetEmployeesByBoss"; 332 SqlParameter[] prams = { new SqlParameter("@type", SqlDbType.NVarChar,50) }; 333 prams[0].Value = procname; 334 DataTable bossEmployees = DBHelper.RunProcGetTable(procname); 335 return bossEmployees; 336 } 337 338 }