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;
10using System.Data.SqlClient;
11//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
12
13/**//// <summary>
14/// Employ 的摘要说明
15/// </summary>
16/// 
17    public class Employ
18    ...{
19
20        //先申明一系列常用的对象
21        private string connstr;
22        private SqlConnection Sqlconn;
23        private SqlCommand Sqlcmd;
24        private SqlDataAdapter Sqladpter;
25        private DataSet ds;
26        private SqlDataReader Sqlreader;
27
28        public Employ()
29        ...{//初始化所有的实例
30            connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
31            Sqlconn = new SqlConnection(connstr);
32            Sqlcmd = new SqlCommand();
33            Sqladpter = new SqlDataAdapter();
34            ds = new DataSet();
35        }
36
37        public DataSet TdataSet(string sql)
38        ...{//返回内存数据库
39            Sqladpter.SelectCommand = new SqlCommand(sql, Sqlconn);
40            Sqladpter.Fill(ds, "temp");
41            return ds;
42        }
43        public SqlDataReader Employee_list()
44        ...{//返回一个只读,向前的轻量级数据源,注意:它不支持服务端的分页,而且数据连接一直打开
45            Sqlcmd.CommandText = "select * from Tb_employee";
46            Sqlcmd.Connection = Sqlconn;
47            if (Sqlconn.State == ConnectionState.Closed) ...{ Sqlconn.Open(); }
48            Sqlreader = Sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);
49            return Sqlreader;
50        }
51
52        public void Update(string 员工号, string 姓名, string 性别, DateTime 出生日期, string 联系电话, string 联系地址)
53        ...{//执行更新动作 
54            Sqlcmd.CommandText = "update [Tb_employee] set [姓名]=@e_name,[性别]=@e_sex,[出生日期]=@e_birth,[联系电话]=@e_tel,[联系地址]=@e_address where [员工号]=@e_id";
55            Sqlcmd.Parameters.AddWithValue("@e_name", 姓名);
56            Sqlcmd.Parameters.AddWithValue("@e_sex", 性别);
57            Sqlcmd.Parameters.AddWithValue("@e_birth", 出生日期);
58            Sqlcmd.Parameters.AddWithValue("@e_tel", 联系电话);
59            Sqlcmd.Parameters.AddWithValue("@e_address", 联系地址);
60            Sqlcmd.Parameters.AddWithValue("@e_id", 员工号);
61            Sqlcmd.Connection = Sqlconn;
62            Sqlconn.Open();
63            Sqlcmd.ExecuteNonQuery();
64        }
65        //5    1    a    s    p    x.com
66
67        public void Delete(string ID)
68        ...{//执行删除动作
69            Sqlcmd.CommandText = "delete from [Tb_employee] where [员工号]='" + ID+ "'";
70            Sqlcmd.Connection = Sqlconn;
71            Sqlconn.Open();
72            Sqlcmd.ExecuteNonQuery();
73        }
74        public void Insert(string E_ID, string E_Name, string E_Sex, string E_Birth, string E_Tel, string E_Address,string D_Name, string E_Intro, string E_Picurl)
75        ...{//执行添加动作    
76            Sqlcmd.CommandText = "insert into [Tb_employee] values('" + E_ID + "','" + E_Name + "','" + E_Sex + "','" + E_Birth + "','" + E_Tel + "','" + E_Address + "','" +D_Name+ "', '" + E_Intro + "','" + E_Picurl + "')";
77            Sqlcmd.Connection = Sqlconn;
78            Sqlconn.Open();
79            Sqlcmd.ExecuteNonQuery();
80        }
81
82
83
84    }
85