当前文件： AssignWorkSystem/App_Code/Dao/ProjectDao.cs[1K，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
11/**//// <summary>
12/// ProjectDao 的摘要说明
13/// </summary>
14public class ProjectDao
15...{
16    public ProjectDao()
17    ...{
18        //
19        // TODO: 在此处添加构造函数逻辑
20        //
21    }
22
23    public static DataSet dsProject()
24    ...{
25        string sql = "select id,ProjectName,ProjectGroup,ProjectLead from  Project  ";
26        return SqlCommon.dsBySql(sql);
27    }
28
29    public static void insertProject(string name1,string name2,string name3)
30    ...{
31        string sql = "insert into Project(ProjectName,ProjectGroup,ProjectLead) values('"+name1+"','"+name2+"','"+name3+"')";
32        SqlCommon.executeNonQuery(sql);
33    }
34    public static void deleteProject(int id)
35    ...{
36        string sql = "delete from Project where id="+id;
37        SqlCommon.executeNonQuery(sql);
38    }
39
40    public static void updateProject(string name1,string name2,string name3,int id)
41    ...{
42        string sql = "update project set ProjectName='"+name1+"',ProjectGroup='"+name2+"',ProjectLead='"+name3+"' where id="+id;
43        SqlCommon.executeNonQuery(sql);
44    }
45}
46