1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12public partial class WebFiles_Leaver_Add_Leaver : System.Web.UI.Page
13...{
14
15    private void Page_Load(object sender, System.EventArgs e)
16    ...{
17        //   在此处放置用户代码以初始化页面   
18        if (!IsPostBack)
19        ...{
20            //this.TxtStartTime.Attributes.Add("onfocus", "javascript:calendar()");
21            //this.TxtEndTime.Attributes.Add("onfocus", "javascript:calendar()");
22            string connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
23            SqlConnection Sqlconn = new SqlConnection(connstr);
24            DataSet ds = new DataSet();
25            string Personstr = "select E_ID,E_Name from Tb_employee order by E_ID desc";
26            string Kindstr = "select L_ID,L_Kind from Tb_leaver_kind order by L_ID desc";
27            string Agreerstr = "select D_ID,D_Chief from Tb_department order by D_ID desc";
28            //读取考勤字段   
29            SqlDataAdapter SqlPerson = new SqlDataAdapter(Personstr, Sqlconn);
30            SqlDataAdapter SqlKind = new SqlDataAdapter(Kindstr, Sqlconn);
31            SqlDataAdapter SqlAgreer = new SqlDataAdapter(Agreerstr, Sqlconn);
32            Sqlconn.Open();
33
34            SqlPerson.Fill(ds, "Person");
35            Person.DataSource = ds.Tables["Person"].DefaultView;
36            Person.DataTextField = "E_Name";
37            Person.DataValueField = "E_ID";
38            Person.DataBind();
39
40            SqlKind.Fill(ds, "Kind");
41            Kind.DataSource = ds.Tables["Kind"].DefaultView;
42            Kind.DataTextField = "L_Kind";
43            Kind.DataValueField = "L_ID";
44            Kind.DataBind();
45
46            SqlAgreer.Fill(ds, "Agreer");
47            Agreer.DataSource = ds.Tables["Agreer"].DefaultView;
48            Agreer.DataTextField = "D_Chief";
49            Agreer.DataValueField = "D_ID";
50            Agreer.DataBind();
51            Sqlconn.Close();
52           
53        }
54
55    }
56
57    protected void BtnOK_Click(object sender, EventArgs e)
58    ...{
59        if ((string)Session["Name"] != "")
60        ...{
61            if ((string)Session["role"] == "管理员")
62            ...{
63
64                string connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
65                SqlConnection Sqlconn = new SqlConnection(connstr);
66                Sqlconn.Open();
67                SqlCommand cmm = new SqlCommand("insert into [Tb_leaver_recordrest] (E_Name,L_Kind,L_Reason,L_Agreer,L_StartTime,L_EndTime) values('" + Person.SelectedValue + "','" + Kind.SelectedValue + "','" + TxtReason.Text.Trim() + "','" + Agreer.SelectedValue + "','" + TxtStartTime.Text.Trim() + "','" + TxtEndTime.Text.Trim() + "')", Sqlconn);
68                cmm.ExecuteNonQuery();
69                Sqlconn.Close();
70                lbMessage.Text = "登记成功!";
71            }
72            else
73            ...{
74                Response.Write("<script>alert('只有管理员才可以进行此操作!')</script>");
75            }
76        }
77        else
78        ...{
79            Response.Redirect("Default.aspx"); ;
80        }
81
82    }
83
84}
85