?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_kind : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        if(TxtID.Text.Trim()=="")
        {
            Response.Write("<script>alert('假別編號不能為空!')</script>");
        }
        if(TxtName.Text.Trim()=="")
        {
            Response.Write("<script>alert('假別名稱不能為空!')</script>");
        }

        if ((string)Session["Name"] != "")
        {
            if ((string)Session["role"] == "管理員")
            {
                if (IsSalaryOrNot.Checked)
                {
                    string connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
                    SqlConnection Sqlconn = new SqlConnection(connstr);
                    SqlCommand Sqlcmd = new SqlCommand();
                    Sqlcmd.CommandText = "insert into [Tb_leaver_kind] values('" + TxtID.Text.Trim() + "','" + TxtName.Text.Trim() + "','" + IsSalaryOrNot.Text + "')";
                    Sqlcmd.Connection = Sqlconn;
                    Sqlconn.Open();
                    Sqlcmd.ExecuteNonQuery();
                }
                else
                {
                    string connstr = ConfigurationManager.ConnectionStrings["Mispersonalconn"].ConnectionString;
                    SqlConnection Sqlconn = new SqlConnection(connstr);
                    SqlCommand Sqlcmd = new SqlCommand();
                    Sqlcmd.CommandText = "insert into [Tb_leaver_kind] values('" + TxtID.Text.Trim() + "','" + TxtName.Text.Trim() + "','否 ')";
                    Sqlcmd.Connection = Sqlconn;
                    Sqlconn.Open();
                    Sqlcmd.ExecuteNonQuery();
                    lbMessage.Text = "您已成功添加1條記錄!";
                }
            }
            else
            {
                Response.Write("<script>alert('只有管理員才可以進行此操作!')</script>");
            }
        }
        else
        {
            Response.Redirect("Default.aspx"); ;
        }

    }
}