方法中的添加参数写法不好，要按照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 /// <summary>
9 ///Employees 的摘要说明
10 /// </summary>
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 //返回所以用户，用泛型List<Employees>
228 public static List<Employees> GetAllEmployees()
229 {
230 List<Employees> allUsers = new List<Employees>();
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 }