当前文件： DutySystem/App_Code/Dao/StaffDao.cs[1K，2009-6-12 11:41:29]，打开代码结构图

		            
 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;
10/**////51aspx.com
11/// <summary>
12/// StaffDao 的摘要说明
13/// </summary>
14public class StaffDao
15...{
16    public StaffDao()
17    ...{
18        //
19        // TODO: 在此处添加构造函数逻辑
20        //
21    }
22
23    public static DataSet dsStaff()
24    ...{
25        string sql = "select a.id,a.L_user_name,(case a.L_user_sex when 0 then '男' when 1 then '女' end) as L_user_sex ,b.L_KS_KSMC,a.L_user_Number from LHB_Office_ZBB_USER  a ,LHB_Office_ZBB_KS b where a.L_user_KSBM=b.id";
26        return ShareCommon.dsBySql(sql);
27    }
28
29    public static void insertStaff(StaffPo sp)
30    ...{
31        string sql = "insert into LHB_Office_ZBB_USER(L_user_name,L_user_sex,L_user_KSBM,L_user_Number) values('"+sp.UserName+"',"+sp.Sex+","+sp.DepartId+",'"+sp.UserId+"')";
32        ShareCommon.executeNonQuery(sql);
33    }
34
35
36    public static void updateStaff(StaffPo sp,int keyId)
37    ...{
38
39        string sql = "update LHB_Office_ZBB_USER set L_user_name = '" + sp.UserName + "',L_user_Number='"+sp.UserId+"', L_user_sex=" + sp.Sex + ",L_user_KSBM=" + sp.DepartId + " where id=" + keyId + "";
40        ShareCommon.executeNonQuery(sql);
41    }
42
43    public static DataSet dsStaff(int deptId)
44    ...{
45        string sql = "select id,L_user_name from LHB_Office_ZBB_USER where L_user_KSBM=" + deptId + "";
46        return ShareCommon.dsBySql(sql);
47    }
48    public static void deleteStaff(int id)
49    ...{
50        string sql = "delete from LHB_Office_ZBB_USER where id="+id;
51        ShareCommon.executeNonQuery(sql);
52    }
53}
54