当前文件： DutySystem/App_Code/Dao/DepartmentDao.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
11/**//// <summary>
12/// DepartmentDao 的摘要说明
13/// </summary>
14public class DepartmentDao
15...{
16    public DepartmentDao()
17    ...{
18        //
19        // TODO: 在此处添加构造函数逻辑
20        //
21    }
22    public static DataSet dsDepartment()
23    ...{
24
25        string sql = "select  *  from  LHB_Office_ZBB_KS";
26        return ShareCommon.dsBySql(sql);
27
28    }
29    public static void insertDepartment(DepartmentPo dp)
30    ...{
31        string sql = "insert into LHB_Office_ZBB_KS (L_KS_KSMC,L_KS_KSBM) values('"+dp.DepartName+"','"+dp.DepartId+"')";
32        ShareCommon.executeNonQuery(sql);
33    }
34    public static void updateDepartment(DepartmentPo dp,int id)
35    ...{
36        string sql = "update LHB_Office_ZBB_KS set L_KS_KSMC='" + dp.DepartName + "',L_KS_KSBM='"+dp.DepartId+"' where id="+id+"";
37        ShareCommon.executeNonQuery(sql);
38    }
39    public static void deleteDepart(int id)
40    ...{
41        string sql = "delete from LHB_Office_ZBB_KS where id = "+id+"";
42        ShareCommon.executeNonQuery(sql);
43    }
44}
45//该源码下载自www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)
46