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/// user 的摘要说明
13/// </summary>
14public class user
15...{
16    //先申明一系列常用的对象
17    private string connstr;
18    private SqlConnection Sqlconn;
19    private SqlCommand Sqlcmd;
20    private SqlDataAdapter Sqladpter;
21    private DataSet ds;
22    private SqlDataReader Sqlreader;
23
24    public user()
25    ...{//初始化所有的实例
26        connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
27        Sqlconn = new SqlConnection(connstr);
28        Sqlcmd = new SqlCommand();
29        Sqladpter = new SqlDataAdapter();
30        ds = new DataSet();
31    }
32    public SqlDataReader Login(string sql)
33    ...{
34        Sqlcmd.CommandText =sql;
35        Sqlcmd.Connection = Sqlconn;
36        if (Sqlconn.State == ConnectionState.Closed) ...{ Sqlconn.Open(); }
37        Sqlreader=Sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);
38        return Sqlreader;
39    }
40
41    public DataSet Search(string sql)
42    ...{//返回内存数据库
43        Sqladpter.SelectCommand = new SqlCommand(sql, Sqlconn);
44        Sqladpter.Fill(ds, "temp");
45        return ds;
46    }
47
48    public void Update(string ID,string userName,string userPass,string userRole)
49    ...{//执行更新动作 
50        Sqlcmd.CommandText = "update [Tb_User_Login] set [ID]=@e_ID,[userName]=@e_userName,[userPass]=@e_userPass,[userRole]=@e_userRole";
51        Sqlcmd.Parameters.AddWithValue("@e_ID",ID);
52        Sqlcmd.Parameters.AddWithValue("@e_userName",userName);
53        Sqlcmd.Parameters.AddWithValue("@e_userPass",userPass);
54        Sqlcmd.Parameters.AddWithValue("@e_userRole",userRole);
55        Sqlcmd.Connection = Sqlconn;
56        Sqlconn.Open();
57        Sqlcmd.ExecuteNonQuery();
58    }
59    public void Delete(string ID)
60    ...{//执行删除动作
61        Sqlcmd.CommandText = "delete from [Tb_User_Login] where [ID]='" +ID+ "'";
62        Sqlcmd.Connection = Sqlconn;
63        Sqlconn.Open();
64        Sqlcmd.ExecuteNonQuery();
65    }
66    public void Insert(string ID, string userName, string userPass, string userRole)
67    ...{//执行添加动作 
68        Sqlcmd.CommandText = "insert into [Tb_User_Login] values('" + ID + "','" + userName + "','" + userPass + "','" + userRole + "')";
69        Sqlcmd.Connection = Sqlconn;
70        Sqlconn.Open();
71        Sqlcmd.ExecuteNonQuery(); 
72    }
73}
74