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/**//// <summary>
12/// department 的摘要说明
13/// </summary>
14//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)
15
16public class department
17...{
18    
19         //先申明一系列常用的对象
20        private string connstr;
21        private SqlConnection Sqlconn;
22        private SqlCommand Sqlcmd;
23        private SqlDataAdapter Sqladpter;
24        private DataSet ds;
25        private SqlDataReader Sqlreader;
26
27    public department()
28    ...{//初始化所有的实例
29            connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
30            Sqlconn = new SqlConnection(connstr);
31            Sqlcmd = new SqlCommand();
32            Sqladpter = new SqlDataAdapter();
33            ds = new DataSet();
34    }
35
36    public SqlDataReader Login(string sql)
37    ...{
38        Sqlcmd.CommandText = sql;
39        Sqlcmd.Connection = Sqlconn;
40        if (Sqlconn.State == ConnectionState.Closed) ...{ Sqlconn.Open(); }
41        Sqlreader = Sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);
42        return Sqlreader;
43    }
44
45    public void Insert(string D_ID, string D_Name,string D_Tel, string D_Address, string D_Chief, string D_Belong)
46    ...{//执行添加动作   (E_ID,E_Name,E_Sex,E_Birth,E_Tel,E_Address) 
47        Sqlcmd.CommandText = "insert into [Tb_department] values('" + D_ID + "','" + D_Name + "','" + D_Tel + "','" + D_Address + "', '" + D_Chief + "','" + D_Belong + "')";
48        //Sqlcmd.Parameters.AddWithValue("@e_id", E_ID);
49        //Sqlcmd.Parameters.AddWithValue("@e_name",E_Name);
50        //Sqlcmd.Parameters.AddWithValue("@e_sex",E_Sex);
51        //Sqlcmd.Parameters.AddWithValue("@e_birth",E_Birth);
52        //Sqlcmd.Parameters.AddWithValue("@e_tel",E_Tel);
53        //Sqlcmd.Parameters.AddWithValue("@e_address",E_Address);
54        //Sqlcmd.Parameters.AddWithValue("@e_intro",E_Intro);
55        //Sqlcmd.Parameters.AddWithValue("@e_picurl",E_Picurl);
56        Sqlcmd.Connection = Sqlconn;
57        Sqlconn.Open();
58        Sqlcmd.ExecuteNonQuery();
59    }
60}
61