当前文件： AssignWorkSystem/App_Code/Dao/AssignmentDao.cs[2K，2009-6-12 11:32:51]，打开代码结构图

		            
 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//该源码下载自www.51aspx.com(５１aｓｐｘ．ｃｏｍ)
11
12/**//// <summary>
13/// AssignmentDao 的摘要说明
14/// </summary>
15public class AssignmentDao
16...{
17    public AssignmentDao()
18    ...{
19        //
20        // TODO: 在此处添加构造函数逻辑
21        //
22    }
23
24    public static DataSet dsAssignment(string manager)
25    ...{
26        string sql = "select b.id,a.taskname,a.begindate,a.enddate,b.engineer,b.manager,(case b.state when 0 then '未完成' when 1 then '已完成' end) as state,b.description from task a,assignment b where a.id=b.taskid and b.manager='"+manager+"'";
27        return  SqlCommon.dsBySql(sql);
28    }
29    public static DataSet dsAssignment(string engineer,string engineer1)
30    ...{
31        string sql = "select b.id,a.taskname,a.begindate,a.enddate,b.engineer,b.manager,(case b.state when 0 then '未完成' when 1 then '已完成' end) as state,b.description from task a,assignment b where a.id=b.taskid and b.engineer='" + engineer + "'";
32        return SqlCommon.dsBySql(sql);
33    }
34
35    public static DataSet dsAssignment()
36    ...{
37        string sql = "select b.id,a.taskname,a.begindate,a.enddate,b.engineer,b.manager,(case b.state when 0 then '未完成' when 1 then '已完成' end) as state,b.description from task a,assignment b where a.id=b.taskid ";
38        return SqlCommon.dsBySql(sql);
39    }
40    public static void inertAssignment(int taskId,string engineer,string manager,byte state,string description)
41    ...{
42
43        string sql = "insert into assignment (taskid,engineer,manager,state,description) values("+taskId+",'"+engineer+"','"+manager+"',"+state+",'"+description+"')";
44        SqlCommon.executeNonQuery(sql);
45    }
46
47    public static void updateState(int id,byte state)
48    ...{
49        string sql = "update assignment set state="+state+" where id="+id;
50        SqlCommon.executeNonQuery(sql);
51    }
52}
53