?using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
public partial class WebFiles_Leaver_Add_Leaver : System.Web.UI.Page
{

    private void Page_Load(object sender, System.EventArgs e)
    {
        //   在此處放置用戶代碼以初始化頁面   
        if (!IsPostBack)
        {
            //this.TxtStartTime.Attributes.Add("onfocus", "javascript:calendar()");
            //this.TxtEndTime.Attributes.Add("onfocus", "javascript:calendar()");
            string connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
            SqlConnection Sqlconn = new SqlConnection(connstr);
            DataSet ds = new DataSet();
            string Personstr = "select E_ID,E_Name from Tb_employee order by E_ID desc";
            string Kindstr = "select L_ID,L_Kind from Tb_leaver_kind order by L_ID desc";
            string Agreerstr = "select D_ID,D_Chief from Tb_department order by D_ID desc";
            //讀取考勤字段   
            SqlDataAdapter SqlPerson = new SqlDataAdapter(Personstr, Sqlconn);
            SqlDataAdapter SqlKind = new SqlDataAdapter(Kindstr, Sqlconn);
            SqlDataAdapter SqlAgreer = new SqlDataAdapter(Agreerstr, Sqlconn);
            Sqlconn.Open();

            SqlPerson.Fill(ds, "Person");
            Person.DataSource = ds.Tables["Person"].DefaultView;
            Person.DataTextField = "E_Name";
            Person.DataValueField = "E_ID";
            Person.DataBind();

            SqlKind.Fill(ds, "Kind");
            Kind.DataSource = ds.Tables["Kind"].DefaultView;
            Kind.DataTextField = "L_Kind";
            Kind.DataValueField = "L_ID";
            Kind.DataBind();

            SqlAgreer.Fill(ds, "Agreer");
            Agreer.DataSource = ds.Tables["Agreer"].DefaultView;
            Agreer.DataTextField = "D_Chief";
            Agreer.DataValueField = "D_ID";
            Agreer.DataBind();
            Sqlconn.Close();
           
        }

    }

    protected void BtnOK_Click(object sender, EventArgs e)
    {
        if ((string)Session["Name"] != "")
        {
            if ((string)Session["role"] == "管理員")
            {

                string connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
                SqlConnection Sqlconn = new SqlConnection(connstr);
                Sqlconn.Open();
                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);
                cmm.ExecuteNonQuery();
                Sqlconn.Close();
                lbMessage.Text = "登記成功!";
            }
            else
            {
                Response.Write("<script>alert('只有管理員才可以進(jìn)行此操作!')</script>");
            }
        }
        else
        {
            Response.Redirect("Default.aspx"); ;
        }

    }

}