当前文件：
Labor/SqlHelper/Helper.cs[16K，2009-6-12 11:46:41]，
打开代码结构图
1
using System;
2using System.Collections.Generic;
3using System.Text;
4using System.Data.SqlClient;
5using System.Configuration;
6using System.Data;
7namespace SqlHelper
8
...{
9
//通用数据库类
10
11 public class Helper
12
...{
13 //多个选择
14
15 static String XZ;
16
17 //定义返回数组
18 static string[] array;
19 //管理员
20 DataSet ds=null;
21
22 //定义连接对象
23 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbuser"].ConnectionString);
24 //1.定义用户登录方法LoginSys();
25 public String LoginSys(String Name, String Pass)
26 ...{
27 String sql = "select * from UserInfo where UserName='" + Name + "' and UserPass='" + Pass + "' ";
28
29 SqlCommand cmd = new SqlCommand(sql, conn);
30
31 try
32 ...{
33 conn.Open();
34
35 SqlDataReader MyReader = cmd.ExecuteReader();
36
37 if (MyReader.Read())
38 ...{
39 return "true";
40
}
41 else
42 ...{
43 return "false";
44 }
45 }
46 catch (Exception ex)
47 ...{
48 return "Exption";
49 }
50 finally
51 ...{
52 conn.Close();
53 }
54 }
55 public bool LoginSys(String Name)
56 ...{
57 String sql = "select * from UserInfo where UserName='" + Name + "' ";
58
59 SqlCommand cmd = new SqlCommand(sql, conn);
60
61 try
62 ...{
63 conn.Open();
64
65 SqlDataReader MyReader = cmd.ExecuteReader();
66
67 if (MyReader.Read())
68 ...{
69 return true;
70 }
71 else
72 ...{
73 return false;
74 }
75 }
76 catch (Exception ex)
77 ...{
78 return false;
79 }
80 finally
81 ...{
82 conn.Close();
83 }
84 }
85 //定义增删改通用方法
86
87 public bool ExecSQL(String sQLstr)
88 ...{
89 conn.Open();
90
91 SqlCommand cmd = new SqlCommand(sQLstr, conn);
92
93 try
94 ...{
95 cmd.ExecuteNonQuery();
96
97 conn.Close();
98 }
99 catch
100 ...{
101 conn.Close();
102
103 return false;
104 }
105 finally
106 ...{
107 conn.Close();
108 }
109 return true;
110 }
111 //定义填充数据库--管理员设置
112 public DataSet BindInfo()
113 ...{
114 String sql = "select * from UserInfo";
115
116 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
117
118 conn.Open();
119
120 ds = new DataSet();
121
122 da.Fill(ds);
123
124 conn.Close();
125
126 return ds;
127 }
128
129 //定义根据用户ID查询名字和密码并返回
130 public String[] GetUserBasicInfo(String UserID)
131 ...{
132 String sql = "select * from UserInfo where UserID='" + UserID + "'";
133 SqlCommand cmd = new SqlCommand(sql, conn);
134 try
135 ...{
136 conn.Open();
137
138 SqlDataReader MyReader = cmd.ExecuteReader();
139
140 if (MyReader.Read())
141 ...{
142 array = new string[] ...{ MyReader.GetString(1), MyReader.GetString(2) };
143 }
144 }
145 catch (Exception ex)
146 ...{
147 throw (ex);
148 }
149 finally
150 ...{
151 conn.Close();
152 }
153 return array;
154 }
155 //判断时候是管理员
156 public bool IsAdmin(String Name)
157 ...{
158 String sql = "select * from UserInfo where IsAdmin=" + 1 + " and UserName='" + Name + "'";
159
160 SqlCommand cmd = new SqlCommand(sql, conn);
161
162 try
163 ...{
164 conn.Open();
165
166 SqlDataReader MyReader = cmd.ExecuteReader();
167
168 if (MyReader.Read())
169 ...{
170 return true;
171 }
172 else
173 ...{
174 return false;
175 }
176 }
177 catch (Exception ex)
178 ...{
179 throw (ex);
180 }
181 finally
182 ...{
183 conn.Close();
184 }
185 }
186 //判断是否存在此部门
187 public bool IsDepartment(String DepartmentName)
188 ...{
189 String sql = "select * from division where DepartmentName='" + DepartmentName + "'";
190
191 SqlCommand cmd = new SqlCommand(sql, conn);
192
193 try
194 ...{
195 conn.Open();
196
197 SqlDataReader MyReader = cmd.ExecuteReader();
198
199 if (MyReader.Read())
200 ...{
201 return true;
202 }
203 else
204 ...{
205 return false;
206 }
207 }
208 catch (Exception ex)
209 ...{
210 throw (ex);
211 }
212 finally
213 ...{
214 conn.Close();
215 }
216 }
217 //填充职员
218 //定义填充数据库--管理员设置
219 public DataSet EmpBindInfo()
220 ...{
221 String sql = "select * from Emp";
222
223 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
224
225 conn.Open();
226
227 ds = new DataSet();
228
229 da.Fill(ds);
230
231 conn.Close();
232
233 return ds;
234 }
235 //定义根据员工ID信息并返回
236 public String[] GetEmpBasicInfo(String EmpID)
237 ...{
238 String sql = "select * from Emp where EmpID='" + EmpID + "'";
239 SqlCommand cmd = new SqlCommand(sql, conn);
240 try
241 ...{
242 conn.Open();
243
244 SqlDataReader MyReader = cmd.ExecuteReader();
245
246 if (MyReader.Read())
247 ...{
248 array = new string[] ...{ MyReader.GetString(1), MyReader.GetString(2), MyReader.GetString(3), MyReader.GetString(4), MyReader.GetString(5) };
249 }
250 }
251 catch (Exception ex)
252 ...{
253 throw (ex);
254 }
255 finally
256 ...{
257 conn.Close();
258 }
259 return array;
260 }
261 //填充部门
262 public DataSet BinddivisionInfo()
263 ...{
264 String sql = "select * from division";
265
266 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
267
268 conn.Open();
269
270 ds = new DataSet();
271
272 da.Fill(ds);
273
274 conn.Close();
275
276 return ds;
277 }
278 //判断是否存在此部门
279 public bool IsDName(String DName)
280 ...{
281 String sql = "select * from division where DepartmentName='" + DName + "'";
282
283 SqlCommand cmd = new SqlCommand(sql, conn);
284
285 try
286 ...{
287 conn.Open();
288
289 SqlDataReader MyReader = cmd.ExecuteReader();
290
291 if (MyReader.Read())
292 ...{
293 return true;
294 }
295 else
296 ...{
297 return false;
298 }
299 }
300 catch (Exception ex)
301 ...{
302 throw (ex);
303 }
304 finally
305 ...{
306 conn.Close();
307 }
308 }
309 //判断部门编号是否存在
310 public bool IsDID(String DID)
311 ...{
312 String sql = "select * from division where DepartmentID='" + DID + "'";
313
314 SqlCommand cmd = new SqlCommand(sql, conn);
315
316 try
317 ...{
318 conn.Open();
319
320 SqlDataReader MyReader = cmd.ExecuteReader();
321
322 if (MyReader.Read())
323 ...{
324 return true;
325 }
326 else
327 ...{
328 return false;
329 }
330 }
331 catch (Exception ex)
332 ...{
333 throw (ex);
334 }
335 finally
336 ...{
337 conn.Close();
338 }
339 }
340 //定义填充数据库--管理员设置
341 public DataSet EmpBindInfo(String YJ,String Info)
342 ...{
343 switch (YJ)
344 ...{
345 case "员工编号":
346 XZ = "select * from Emp where EmpID='" + Info + "'";
347 break;
348
349 case "员工名字":
350 XZ = "select * from Emp where EmpName='" + Info + "'";
351 break;
352
353 case "部门编号":
354 XZ = "select * from Emp where DepartmentID='" + Info + "'";
355 break;
356
357 case "部门名字":
358 XZ = "select * from Emp where DepartmentName='" + Info + "'";
359 break;
360 }
361
362 String sql = XZ;
363
364 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
365
366 conn.Open();
367
368 ds = new DataSet();
369
370 da.Fill(ds);
371
372 conn.Close();
373
374 return ds;
375 }
376 //根据多个选择去查询职员
377 public bool QueryEmp(String YJ, String Info)
378 ...{
379 switch (YJ)
380 ...{
381 case "员工编号":
382 XZ = "select * from Emp where EmpID='" + Info + "'";
383 break;
384
385 case "员工名字":
386 XZ = "select * from Emp where EmpName='" + Info + "'";
387 break;
388
389 case "部门编号":
390 XZ = "select * from Emp where DepartmentID='" + Info + "'";
391 break;
392
393 case "部门名字":
394 XZ = "select * from Emp where DepartmentName='" + Info + "'";
395 break;
396 }
397
398 String sql = XZ;
399 SqlCommand cmd = new SqlCommand(sql, conn);
400 try
401 ...{
402 conn.Open();
403
404 SqlDataReader MyReader = cmd.ExecuteReader();
405
406 if (MyReader.Read())
407 ...{
408 return true;
409 }
410 else
411 ...{
412 return false;
413 }
414 }
415 catch (Exception ex)
416 ...{
417 throw (ex);
418 }
419 finally
420 ...{
421 conn.Close();
422 }
423 }
424 //填充供应商
425 public DataSet BindSuppliersInfo()
426 ...{
427 String sql = "select * from Suppliers";
428
429 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
430
431 conn.Open();
432
433 ds = new DataSet();
434
435 da.Fill(ds);
436
437 conn.Close();
438
439 return ds;
440 }
441 //判断是否存在此供应商编号
442 public bool IsSID(String SID)
443 ...{
444 String sql = "select * from Suppliers where SuppliersID='" + SID + "'";
445
446 SqlCommand cmd = new SqlCommand(sql, conn);
447
448 try
449 ...{
450 conn.Open();
451
452 SqlDataReader MyReader = cmd.ExecuteReader();
453
454 if (MyReader.Read())
455 ...{
456 return true;
457 }
458 else
459 ...{
460 return false;
461 }
462 }
463 catch (Exception ex)
464 ...{
465 throw (ex);
466 }
467 finally
468 ...{
469 conn.Close();
470 }
471 }
472
473 //定义根据供应商ID信息并返回
474 public String[] GetSuppliersInfo(String SuppliersID)
475 ...{
476 String sql = "select * from Suppliers where SuppliersID='" + SuppliersID + "'";
477 SqlCommand cmd = new SqlCommand(sql, conn);
478 try
479 ...{
480 conn.Open();
481
482 SqlDataReader MyReader = cmd.ExecuteReader();
483
484 if (MyReader.Read())
485 ...{
486 array = new string[] ...{ MyReader.GetString(0), MyReader.GetString(1), MyReader.GetString(2), MyReader.GetString(3), MyReader.GetString(4), MyReader.GetString(5), MyReader.GetString(6), MyReader.GetString(7), MyReader.GetString(8), MyReader.GetString(9) };
487 }
488 }
489 catch (Exception ex)
490 ...{
491 throw (ex);
492 }
493 finally
494 ...{
495 conn.Close();
496 }
497 return array;
498 }
499 //填充商品
500 public DataSet BindGoodsInfo()
501 ...{
502 String sql = "select * from Goods";
503
504 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
505
506 conn.Open();
507
508 ds = new DataSet();
509
510 da.Fill(ds);
511
512 conn.Close();
513
514 return ds;
515 }
516 //根据物品编号返回信息
517 public String[] GetGoodsInfo(String GoodsID)
518 ...{
519 String sql = "select * from Goods where GoodsID='" + GoodsID + "'";
520 SqlCommand cmd = new SqlCommand(sql, conn);
521 try
522 ...{
523 conn.Open();
524
525 SqlDataReader MyReader = cmd.ExecuteReader();
526
527 if (MyReader.Read())
528 ...{
529 array = new string[] ...{MyReader.GetString(1), MyReader.GetString(2)};
530 }
531 }
532 catch (Exception ex)
533 ...{
534 throw (ex);
535 }
536 finally
537 ...{
538 conn.Close();
539 }
540 return array;
541 }
542 //判断物品是否重复
543 public bool IsGoodsCF(String GoodsName)
544 ...{
545 String sql = "select * from Goods where GoodsName='" + GoodsName + "'";
546
547 SqlCommand cmd = new SqlCommand(sql, conn);
548
549 try
550 ...{
551 conn.Open();
552
553 SqlDataReader MyReader = cmd.ExecuteReader();
554
555 if (MyReader.Read())
556 ...{
557 return true;
558 }
559 else
560 ...{
561 return false;
562 }
563 }
564 catch (Exception ex)
565 ...{
566 throw (ex);
567 }
568 finally
569 ...{
570 conn.Close();
571 }
572
573 }
574 //判断在物品表里是否存在此供应商编号
575 public bool IsGSID(String SID)
576 ...{
577 String sql = "select * from Goods where SuppliersID='" + SID + "'";
578
579 SqlCommand cmd = new SqlCommand(sql, conn);
580
581 try
582 ...{
583 conn.Open();
584
585 SqlDataReader MyReader = cmd.ExecuteReader();
586
587 if (MyReader.Read())
588 ...{
589 return true;
590 }
591 else
592 ...{
593 return false;
594 }
595 }
596 catch (Exception ex)
597 ...{
598 throw (ex);
599 }
600 finally
601 ...{
602 conn.Close();
603 }
604 }
605 //填充部门发放物品信息
606 public DataSet BindDFFInfo()
607 ...{
608 String sql = "select * from DFF";
609
610 SqlDataAdapter da = new SqlDataAdapter(sql, conn);
611
612 conn.Open();
613
614 ds = new DataSet();
615
616 da.Fill(ds);
617
618 conn.Close();
619
620 return ds;
621 }
622 //根据详单ID返回信息
623 public String[] GetDFFInfo(String XDID)
624 ...{
625 String sql = "select * from DFF where ID='" + XDID + "'";
626 SqlCommand cmd = new SqlCommand(sql, conn);
627 try
628 ...{
629 conn.Open();
630
631 SqlDataReader MyReader = cmd.ExecuteReader();
632
633 if (MyReader.Read())
634 ...{
635 array = new string[] ...{Convert.ToString(MyReader.GetInt32(1)), MyReader.GetString(2), MyReader.GetString(3) };
636 }
637 }
638 catch (Exception ex)
639 ...{
640 throw (ex);
641 }
642 finally
643 ...{
644 conn.Close();
645 }
646 return array;
647 }
648 }
649
}
650
打包下载该项目完整源码：无忧劳保库存系统源码