?using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
//該源碼下載自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

/// <summary>
/// Employ 的摘要說明
/// </summary>
/// 
    public class Employ
    {

        //先申明一系列常用的對象
        private string connstr;
        private SqlConnection Sqlconn;
        private SqlCommand Sqlcmd;
        private SqlDataAdapter Sqladpter;
        private DataSet ds;
        private SqlDataReader Sqlreader;

        public Employ()
        {//初始化所有的實例
            connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
            Sqlconn = new SqlConnection(connstr);
            Sqlcmd = new SqlCommand();
            Sqladpter = new SqlDataAdapter();
            ds = new DataSet();
        }

        public DataSet TdataSet(string sql)
        {//返回內存數據庫
            Sqladpter.SelectCommand = new SqlCommand(sql, Sqlconn);
            Sqladpter.Fill(ds, "temp");
            return ds;
        }
        public SqlDataReader Employee_list()
        {//返回一個只讀,向前的輕量級數據源,注意:它不支持服務端的分頁,而且數據連接一直打開
            Sqlcmd.CommandText = "select * from Tb_employee";
            Sqlcmd.Connection = Sqlconn;
            if (Sqlconn.State == ConnectionState.Closed) { Sqlconn.Open(); }
            Sqlreader = Sqlcmd.ExecuteReader(CommandBehavior.CloseConnection);
            return Sqlreader;
        }

        public void Update(string 員工號, string 姓名, string 性別, DateTime 出生日期, string 聯系電話, string 聯系地址)
        {//執行更新動作 
            Sqlcmd.CommandText = "update [Tb_employee] set [姓名]=@e_name,[性別]=@e_sex,[出生日期]=@e_birth,[聯系電話]=@e_tel,[聯系地址]=@e_address where [員工號]=@e_id";
            Sqlcmd.Parameters.AddWithValue("@e_name", 姓名);
            Sqlcmd.Parameters.AddWithValue("@e_sex", 性別);
            Sqlcmd.Parameters.AddWithValue("@e_birth", 出生日期);
            Sqlcmd.Parameters.AddWithValue("@e_tel", 聯系電話);
            Sqlcmd.Parameters.AddWithValue("@e_address", 聯系地址);
            Sqlcmd.Parameters.AddWithValue("@e_id", 員工號);
            Sqlcmd.Connection = Sqlconn;
            Sqlconn.Open();
            Sqlcmd.ExecuteNonQuery();
        }
        //5	1	a	s	p	x.com

        public void Delete(string ID)
        {//執行刪除動作
            Sqlcmd.CommandText = "delete from [Tb_employee] where [員工號]='" + ID+ "'";
            Sqlcmd.Connection = Sqlconn;
            Sqlconn.Open();
            Sqlcmd.ExecuteNonQuery();
        }
        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)
        {//執行添加動作    
            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 + "')";
            Sqlcmd.Connection = Sqlconn;
            Sqlconn.Open();
            Sqlcmd.ExecuteNonQuery();
        }



    }