开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
employee_edit.aspx.cs
资源名称：web.rar　[点击查看]
上传用户：xrffrp
上传日期：2022-03-25
资源大小：22155k
文件大小：27k
源码类别：

OA系统

开发平台：

ASP/ASPX

employee_edit.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using System.Data.SqlClient;
  13. public partial class web_mail_employee_edit : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         LoginDAO.CheckLogin(Session, Response, "../../", 2);
  18.         if (!IsPostBack)
  19.         {
  20.             if (Request.QueryString["e_id"] != null)
  21.             {
  22.                 this.SetValue(Request.QueryString["e_id"]);
  23.             }
  24.             TxtNo.Attributes.Add("onchange", "changeEmpNo()");
  25.         }
  26.     }
  28.     protected void SetValue(string id)
  29.     {
  30.         this.SetBasic(id);
  31.         this.SetFamily(id);
  32.         this.SetBackGround(id);
  33.         this.SetEducation(id);
  34.         this.SetWork(id);
  35.         this.SetSkill(id);
  36.     }
  37.     //員工基本信息
  38.     protected void SetBasic(string id)
  39.     {
  40.         SqlConnection conn = dbConnection.getConnection();
  41.         conn.Open();
  42.         SqlCommand cmd = new SqlCommand("select e.emp_no, e.emp_name, e.login_name, e.pwd, e.department_id, d.name department_name,"+
  43.             "e.user_group, e.position, e.nation, e.marriage, e.id_card, e.native, e.stature, e.address, "+
  44.             "e.linkman, e.tel, e.registered_address, e.active_date, e.dimission_date, e.sex, e.birth_date,"+
  45.             " e.email_work, e.email_personal, e.smart_phone, e.tel_extension, e.id_card_expire, e.work_card_no1, e.work_card_no2,"+
  46.             " e.link_man_tel, e.work_place,e.q_manger from OA_EMPLOYEE e inner join OA_DEPARTMENT d on e.department_id=d.id where e.id="+id, conn);
  47.         SqlDataReader dr = cmd.ExecuteReader();
  48.         if (dr.Read())
  49.         {
  50.             TxtNo.Text = dr["emp_no"].ToString();
  51.             TxtName.Text = dr["emp_name"].ToString();
  52.             LblTitle.Text = TxtName.Text + "員工履歷表";
  53.             TxtLoginName.Text = dr["login_name"].ToString();
  54.             TxtPassword.Text = dr["pwd"].ToString();
  55.             DepartmentId.Value = dr["department_id"].ToString();
  56.             TxtDepartment.Text = dr["department_name"].ToString();
  57.             DdlGroup.SelectedValue = dr["user_group"].ToString();
  58.             DdlPosition.SelectedValue = dr["position"].ToString();
  59.             TxtNation.Text = dr["nation"].ToString();
  60.             DdlMarriage.SelectedValue = dr["marriage"].ToString();
  61.             TxtIdCard.Text = dr["id_card"].ToString();
  62.             TxtNative.Text = dr["native"].ToString();
  63.             TxtStature.Text = dr["stature"].ToString();
  64.             TxtAddress.Text = dr["address"].ToString();
  65.             TxtLinkman.Text = dr["linkman"].ToString();
  66.             TxtTel.Text = dr["tel"].ToString();
  67.             TxtRegisteredAdress.Text = dr["registered_address"].ToString();
  68.             TxtActiveDate.Text = dr["active_date"].ToString();
  69.             TxtDimissionDate.Text = dr["dimission_date"].ToString();
  70.             DdlSex.SelectedValue = dr["sex"].ToString();
  71.             TxtBirthDate.Text = dr["birth_date"].ToString();
  72.             TxtMailWork.Text = dr["email_work"].ToString();
  73.             TxtMailPersonal.Text = dr["email_personal"].ToString();
  74.             TxtSmartPhone.Text = dr["smart_phone"].ToString();
  75.             TxtTelExtension.Text = dr["tel_extension"].ToString();
  76.             TxtIdCardExpire.Text = dr["id_card_expire"].ToString();
  77.             TxtWorkCardNo1.Text = dr["work_card_no1"].ToString();
  78.             TxtWorkCardNo2.Text = dr["work_card_no2"].ToString();
  79.             TxtLinkmanTel.Text = dr["link_man_tel"].ToString();
  80.             TxtWorkPlace.Text = dr["work_place"].ToString();
  81.             Ddlmanger.SelectedValue = dr["q_manger"].ToString();
  82.             
  83.         }
  84.         dr.Close();
  85.         conn.Close();
  86.     }
  87.     //家庭情況
  88.     protected void SetFamily(string id)
  89.     {
  90.         SqlConnection conn = dbConnection.getConnection();
  91.         conn.Open();
  92.         SqlCommand cmd = new SqlCommand("select family_name, [relative], age, tel, company from OA_EMPLOYEE_FAMILY where emp_id="+id, conn);
  93.         SqlDataReader dr = cmd.ExecuteReader();
  94.         int index = 1;
  95.         while (dr.Read())
  96.         {
  97.             if (index == 1)
  98.             {
  99.                 TxtFamilyName1.Text = dr["family_name"].ToString();
  100.                 TxtRelative1.Text = dr["relative"].ToString();
  101.                 TxtAge1.Text = dr["age"].ToString();
  102.                 TxtTel1.Text = dr["tel"].ToString();
  103.                 TxtCompany1.Text = dr["company"].ToString();
  104.             }
  105.             if (index == 2)
  106.             {
  107.                 TxtFamilyName2.Text = dr["family_name"].ToString();
  108.                 TxtRelative2.Text = dr["relative"].ToString();
  109.                 TxtAge2.Text = dr["age"].ToString();
  110.                 TxtTel2.Text = dr["tel"].ToString();
  111.                 TxtCompany2.Text = dr["company"].ToString();
  112.             }
  113.             if (index == 3)
  114.             {
  115.                 TxtFamilyName3.Text = dr["family_name"].ToString();
  116.                 TxtRelative3.Text = dr["relative"].ToString();
  117.                 TxtAge3.Text = dr["age"].ToString();
  118.                 TxtTel3.Text = dr["tel"].ToString();
  119.                 TxtCompany3.Text = dr["company"].ToString();
  120.             }
  121.             if (index == 4)
  122.             {
  123.                 TxtFamilyName4.Text = dr["family_name"].ToString();
  124.                 TxtRelative4.Text = dr["relative"].ToString();
  125.                 TxtAge4.Text = dr["age"].ToString();
  126.                 TxtTel4.Text = dr["tel"].ToString();
  127.                 TxtCompany4.Text = dr["company"].ToString();
  128.             }
  129.             index = index + 1;
  130.         }
  131.         dr.Close();
  132.         conn.Close();
  133.     }
  134.     //背景
  135.     protected void SetBackGround(string id)
  136.     {
  137.         SqlConnection conn = dbConnection.getConnection();
  138.         conn.Open();
  139.         SqlCommand cmd = new SqlCommand("select back_name, [relative], job, tel, company from OA_EMPLOYEE_BACKGROUND where emp_id="+id, conn);
  140.         SqlDataReader dr = cmd.ExecuteReader();
  141.         int index = 1;
  142.         while (dr.Read())
  143.         {
  144.             if (index == 1)
  145.             {
  146.                 TxtBackName1.Text = dr["back_name"].ToString();
  147.                 TxtBackRelative1.Text = dr["relative"].ToString();
  148.                 TxtBackJob1.Text = dr["job"].ToString();
  149.                 TxtBackTel1.Text = dr["tel"].ToString();
  150.                 TxtBackCompany1.Text = dr["company"].ToString();
  151.             }
  152.             if (index == 2)
  153.             {
  154.                 TxtBackName2.Text = dr["back_name"].ToString();
  155.                 TxtBackRelative2.Text = dr["relative"].ToString();
  156.                 TxtBackJob2.Text = dr["job"].ToString();
  157.                 TxtBackTel2.Text = dr["tel"].ToString();
  158.                 TxtBackCompany2.Text = dr["company"].ToString();
  159.             }
  160.             index = index + 1;
  161.         }
  162.         dr.Close();
  163.         conn.Close();
  164.     }
  165.     //教育經歷
  166.     protected void SetEducation(string id)
  167.     {
  168.         SqlConnection conn = dbConnection.getConnection();
  169.         conn.Open();
  170.         SqlCommand cmd = new SqlCommand("select begin_year, begin_month, end_year, end_month, school, subject, "+
  171.             "grade from OA_EMPLOYEE_EDUCATION where emp_id=" + id, conn);
  172.         SqlDataReader dr = cmd.ExecuteReader();
  173.         int index = 1;
  174.         while (dr.Read())
  175.         {
  176.             if (index == 1)
  177.             {
  178.                 TxtEdBeginYear1.Text = dr["begin_year"].ToString();
  179.                 TxtEdBeginMonth1.Text = dr["begin_month"].ToString();
  180.                 TxtEdEndYear1.Text = dr["end_year"].ToString();
  181.                 TxtEdEndMonth1.Text = dr["end_month"].ToString();
  182.                 TxtSchoolName1.Text = dr["school"].ToString();
  183.                 TxtSubject1.Text = dr["subject"].ToString();
  184.                 TxtGrade1.Text = dr["grade"].ToString();
  185.             }
  186.             if (index == 2)
  187.             {
  188.                 TxtEdBeginYear2.Text = dr["begin_year"].ToString();
  189.                 TxtEdBeginMonth2.Text = dr["begin_month"].ToString();
  190.                 TxtEdEndYear2.Text = dr["end_year"].ToString();
  191.                 TxtEdEndMonth2.Text = dr["end_month"].ToString();
  192.                 TxtSchoolName2.Text = dr["school"].ToString();
  193.                 TxtSubject2.Text = dr["subject"].ToString();
  194.                 TxtGrade2.Text = dr["grade"].ToString();
  195.             }
  196.             if (index == 3)
  197.             {
  198.                 TxtEdBeginYear3.Text = dr["begin_year"].ToString();
  199.                 TxtEdBeginMonth3.Text = dr["begin_month"].ToString();
  200.                 TxtEdEndYear3.Text = dr["end_year"].ToString();
  201.                 TxtEdEndMonth3.Text = dr["end_month"].ToString();
  202.                 TxtSchoolName3.Text = dr["school"].ToString();
  203.                 TxtSubject3.Text = dr["subject"].ToString();
  204.                 TxtGrade3.Text = dr["grade"].ToString();
  205.             }
  206.             if (index == 4)
  207.             {
  208.                 TxtEdBeginYear4.Text = dr["begin_year"].ToString();
  209.                 TxtEdBeginMonth4.Text = dr["begin_month"].ToString();
  210.                 TxtEdEndYear4.Text = dr["end_year"].ToString();
  211.                 TxtEdEndMonth4.Text = dr["end_month"].ToString();
  212.                 TxtSchoolName4.Text = dr["school"].ToString();
  213.                 TxtSubject4.Text = dr["subject"].ToString();
  214.                 TxtGrade4.Text = dr["grade"].ToString();
  215.             }
  216.             index = index + 1;
  217.         }
  218.         dr.Close();
  219.         conn.Close();
  220.     }
  221.     //工作經歷
  222.     protected void SetWork(string id)
  223.     {
  224.         SqlConnection conn = dbConnection.getConnection();
  225.         conn.Open();
  226.         SqlCommand cmd = new SqlCommand("select begin_year, begin_month, end_year, end_month, company, tel, "+
  227.             "salary, dimission_reason from OA_EMPLOYEE_JOB where emp_id=" + id, conn);
  228.         SqlDataReader dr = cmd.ExecuteReader();
  229.         int index = 1;
  230.         while (dr.Read())
  231.         {
  232.             if (index == 1)
  233.             {
  234.                 TxtWorkBeginYear1.Text = dr["begin_year"].ToString();
  235.                 TxtWorkBeginMonth1.Text = dr["begin_month"].ToString();
  236.                 TxtWorkEndYear1.Text = dr["end_year"].ToString();
  237.                 TxtWorkEndMonth1.Text = dr["end_month"].ToString();
  238.                 TxtWorkCompany1.Text = dr["company"].ToString();
  239.                 TxtWorkTel1.Text = dr["tel"].ToString();
  240.                 TxtWorkSalary1.Text = dr["salary"].ToString();
  241.                 TxtDimissionReason1.Text = dr["dimission_reason"].ToString();
  242.             }
  243.             if (index == 2)
  244.             {
  245.                 TxtWorkBeginYear2.Text = dr["begin_year"].ToString();
  246.                 TxtWorkBeginMonth2.Text = dr["begin_month"].ToString();
  247.                 TxtWorkEndYear2.Text = dr["end_year"].ToString();
  248.                 TxtWorkEndMonth2.Text = dr["end_month"].ToString();
  249.                 TxtWorkCompany2.Text = dr["company"].ToString();
  250.                 TxtWorkTel2.Text = dr["tel"].ToString();
  251.                 TxtWorkSalary2.Text = dr["salary"].ToString();
  252.                 TxtDimissionReason2.Text = dr["dimission_reason"].ToString();
  253.             }
  254.             if (index == 3)
  255.             {
  256.                 TxtWorkBeginYear3.Text = dr["begin_year"].ToString();
  257.                 TxtWorkBeginMonth3.Text = dr["begin_month"].ToString();
  258.                 TxtWorkEndYear3.Text = dr["end_year"].ToString();
  259.                 TxtWorkEndMonth3.Text = dr["end_month"].ToString();
  260.                 TxtWorkCompany3.Text = dr["company"].ToString();
  261.                 TxtWorkTel3.Text = dr["tel"].ToString();
  262.                 TxtWorkSalary3.Text = dr["salary"].ToString();
  263.                 TxtDimissionReason3.Text = dr["dimission_reason"].ToString();
  264.             }
  265.             if (index == 4)
  266.             {
  267.                 TxtWorkBeginYear4.Text = dr["begin_year"].ToString();
  268.                 TxtWorkBeginMonth4.Text = dr["begin_month"].ToString();
  269.                 TxtWorkEndYear4.Text = dr["end_year"].ToString();
  270.                 TxtWorkEndMonth4.Text = dr["end_month"].ToString();
  271.                 TxtWorkCompany4.Text = dr["company"].ToString();
  272.                 TxtWorkTel4.Text = dr["tel"].ToString();
  273.                 TxtWorkSalary4.Text = dr["salary"].ToString();
  274.                 TxtDimissionReason4.Text = dr["dimission_reason"].ToString();
  275.             }
  276.             index = index + 1;
  277.         }
  278.         dr.Close();
  279.         conn.Close();
  280.     }
  281.     //專業技能
  282.     protected void SetSkill(string id)
  283.     {
  284.         SqlConnection conn = dbConnection.getConnection();
  285.         conn.Open();
  286.         SqlCommand cmd = new SqlCommand("select [language],computer_grade,certificate,other from OA_EMPLOYEE_SKILL where emp_id="+id, conn);
  287.         SqlDataReader dr = cmd.ExecuteReader();
  288.         if (dr.Read())
  289.         {
  290.             TxtLanguage.Text = dr["language"].ToString();
  291.             TxtComputerGrade.Text = dr["computer_grade"].ToString();
  292.             TxtCertificate.Text = dr["certificate"].ToString();
  293.             TxtOther.Text = dr["other"].ToString();
  294.         }
  295.         dr.Close();
  296.         conn.Close();
  297.     }
  298.     protected bool CheckValidate()
  299.     {
  300.         int flag = 0;
  301.         if (DepartmentId.Value.Equals(""))
  302.         {
  303.             flag = 1;
  304.             Response.Write("<script language='javascript'>alert('部門不能為空!')</script>");
  305.         }
  306.         if (TxtName.Text.Trim().Equals(""))
  307.         {
  308.             flag = 1;
  309.             Response.Write("<script language='javascript'>alert('員工姓名不能為空!')</script>");
  310.         }
  311.         if (TxtNo.Text.Trim().Equals(""))
  312.         {
  313.             flag = 1;
  314.             Response.Write("<script language='javascript'>alert('員工工號不能為空!')</script>");
  315.         }
  316.         if (TxtMailWork.Text.Trim().Equals(""))
  317.         {
  318.             flag = 1;
  319.             Response.Write("<script language='javascript'>alert('公司郵箱不能為空!')</script>");
  320.         }
  321.         if (flag == 0)
  322.         {
  323.             return true;
  324.         }
  325.         else
  326.         {
  327.             return false;
  328.         }
  329.     }
  330.     protected void BtnOk_Click(object sender, EventArgs e)
  331.     {
  332.         if (this.CheckValidate())
  333.         {
  334.             string emp_id = "0";
  335.             if (Request.QueryString["e_id"] != null)
  336.             {
  337.                 emp_id = Request.QueryString["e_id"];
  338.             }
  339.             SqlConnection conn = dbConnection.getConnection();
  340.             conn.Open();
  342.             //更新基本資料
  343.             string sql = "update OA_EMPLOYEE set emp_no='" + TxtNo.Text + "', emp_name='" + TxtName.Text +
  344.                 "',login_name='" + TxtLoginName.Text + "', pwd='" + TxtPassword.Text + "', department_id='" + DepartmentId.Value + "',user_group='" +
  345.                 DdlGroup.SelectedValue + "',[position]='" + DdlPosition.SelectedValue + "',nation='" +
  346.                 TxtNation.Text + "',marriage='" + DdlMarriage.SelectedValue + "',id_card='" + TxtIdCard.Text +
  347.                 "',native='" + TxtNative.Text + "',stature='" + TxtStature.Text + "',address='" + TxtAddress.Text +
  348.                 "',linkman='" + TxtLinkman.Text + "',tel='" + TxtTel.Text + "',registered_address='" +
  349.                 TxtRegisteredAdress.Text + "',active_date='" + TxtActiveDate.Text + "',dimission_date='" +
  350.                 TxtDimissionDate.Text + "',sex='" + DdlSex.SelectedValue + "',birth_date='" + TxtBirthDate.Text +
  351.                 "', id_card_expire='" + TxtIdCardExpire.Text + "', email_work='" + TxtMailWork.Text + "', email_personal='" +
  352.                 TxtMailPersonal.Text + "', smart_phone='" + TxtSmartPhone.Text + "',tel_extension='" + TxtTelExtension.Text +
  353.                 "', work_card_no1='" + TxtWorkCardNo1.Text + "', work_card_no2='" + TxtWorkCardNo2.Text +
  354.                 "',link_man_tel='" + TxtLinkmanTel.Text + "', work_place='" + TxtWorkPlace.Text + "',q_manger='" + Ddlmanger.SelectedValue + "'  where id=" + emp_id;
  355.             SqlCommand cmd = new SqlCommand(sql, conn);
  356.             cmd.ExecuteNonQuery();
  358.             //更新家庭情況
  359.             cmd = new SqlCommand("delete from OA_EMPLOYEE_FAMILY where emp_id=" + emp_id, conn);
  360.             cmd.ExecuteNonQuery();
  361.             if (!TxtFamilyName1.Text.Trim().Equals(""))
  362.             {
  363.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_FAMILY (emp_id, family_name, [relative], age, " +
  364.                     "tel, company) values (" + emp_id + ", '" + TxtFamilyName1.Text + "', '" + TxtRelative1.Text + "','" +
  365.                     TxtAge1.Text + "','" + TxtTel1.Text + "','" + TxtCompany1.Text + "')", conn);
  366.                 cmd.ExecuteNonQuery();
  367.             }
  368.             if (!TxtFamilyName2.Text.Trim().Equals(""))
  369.             {
  370.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_FAMILY (emp_id, family_name, [relative], age, " +
  371.                     "tel, company) values (" + emp_id + ", '" + TxtFamilyName2.Text + "', '" + TxtRelative2.Text + "','" +
  372.                     TxtAge2.Text + "','" + TxtTel2.Text + "','" + TxtCompany2.Text + "')", conn);
  373.                 cmd.ExecuteNonQuery();
  374.             }
  375.             if (!TxtFamilyName3.Text.Trim().Equals(""))
  376.             {
  377.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_FAMILY (emp_id, family_name, [relative], age, " +
  378.                     "tel, company) values (" + emp_id + ", '" + TxtFamilyName3.Text + "', '" + TxtRelative3.Text + "','" +
  379.                     TxtAge3.Text + "','" + TxtTel3.Text + "','" + TxtCompany3.Text + "')", conn);
  380.                 cmd.ExecuteNonQuery();
  381.             }
  382.             if (!TxtFamilyName4.Text.Trim().Equals(""))
  383.             {
  384.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_FAMILY (emp_id, family_name, [relative], age, " +
  385.                     "tel, company) values (" + emp_id + ", '" + TxtFamilyName4.Text + "', '" + TxtRelative4.Text + "','" +
  386.                     TxtAge4.Text + "','" + TxtTel4.Text + "','" + TxtCompany4.Text + "')", conn);
  387.                 cmd.ExecuteNonQuery();
  388.             }
  391.             //更新背景
  392.             cmd = new SqlCommand("delete from OA_EMPLOYEE_BACKGROUND where emp_id=" + emp_id, conn);
  393.             cmd.ExecuteNonQuery();
  394.             if (!TxtBackName1.Text.Trim().Equals(""))
  395.             {
  396.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_BACKGROUND(emp_id, back_name, [relative], job, " +
  397.                     "tel, company)values(" + emp_id + ",'" + TxtBackName1.Text + "','" + TxtBackRelative1.Text + "','" +
  398.                     TxtBackJob1.Text + "','" + TxtBackTel1.Text + "','" + TxtBackCompany1.Text + "')", conn);
  399.                 cmd.ExecuteNonQuery();
  400.             }
  401.             if (!TxtBackName2.Text.Trim().Equals(""))
  402.             {
  403.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_BACKGROUND(emp_id, back_name, [relative], job, " +
  404.                     "tel, company)values(" + emp_id + ",'" + TxtBackName2.Text + "','" + TxtBackRelative2.Text + "','" +
  405.                     TxtBackJob2.Text + "','" + TxtBackTel2.Text + "','" + TxtBackCompany2.Text + "')", conn);
  406.                 cmd.ExecuteNonQuery();
  407.             }
  409.             //更新教育經歷
  410.             cmd = new SqlCommand("delete from OA_EMPLOYEE_EDUCATION where emp_id=" + emp_id, conn);
  411.             cmd.ExecuteNonQuery();
  412.             if (!TxtSchoolName1.Text.Trim().Equals(""))
  413.             {
  414.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_EDUCATION(emp_id, begin_year, begin_month, " +
  415.                     "end_year, end_month, school, subject, grade)values(" + emp_id + ",'" + TxtEdBeginYear1.Text +
  416.                     "','" + TxtEdBeginMonth1.Text + "','" + TxtEdEndYear1.Text + "','" + TxtEdEndMonth1.Text + "','" +
  417.                     TxtSchoolName1.Text + "','" + TxtSubject1.Text + "','" + TxtGrade1.Text + "')", conn);
  418.                 cmd.ExecuteNonQuery();
  419.             }
  420.             if (!TxtSchoolName2.Text.Trim().Equals(""))
  421.             {
  422.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_EDUCATION(emp_id, begin_year, begin_month, " +
  423.                     "end_year, end_month, school, subject, grade)values(" + emp_id + ",'" + TxtEdBeginYear2.Text +
  424.                     "','" + TxtEdBeginMonth2.Text + "','" + TxtEdEndYear2.Text + "','" + TxtEdEndMonth2.Text + "','" +
  425.                     TxtSchoolName2.Text + "','" + TxtSubject2.Text + "','" + TxtGrade2.Text + "')", conn);
  426.                 cmd.ExecuteNonQuery();
  427.             }
  428.             if (!TxtSchoolName3.Text.Trim().Equals(""))
  429.             {
  430.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_EDUCATION(emp_id, begin_year, begin_month, " +
  431.                     "end_year, end_month, school, subject, grade)values(" + emp_id + ",'" + TxtEdBeginYear3.Text +
  432.                     "','" + TxtEdBeginMonth3.Text + "','" + TxtEdEndYear3.Text + "','" + TxtEdEndMonth3.Text + "','" +
  433.                     TxtSchoolName3.Text + "','" + TxtSubject3.Text + "','" + TxtGrade3.Text + "')", conn);
  434.                 cmd.ExecuteNonQuery();
  435.             }
  436.             if (!TxtSchoolName4.Text.Trim().Equals(""))
  437.             {
  438.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_EDUCATION(emp_id, begin_year, begin_month, " +
  439.                     "end_year, end_month, school, subject, grade)values(" + emp_id + ",'" + TxtEdBeginYear4.Text +
  440.                     "','" + TxtEdBeginMonth4.Text + "','" + TxtEdEndYear4.Text + "','" + TxtEdEndMonth4.Text + "','" +
  441.                     TxtSchoolName4.Text + "','" + TxtSubject4.Text + "','" + TxtGrade4.Text + "')", conn);
  442.                 cmd.ExecuteNonQuery();
  443.             }
  445.             //更新工作經歷
  446.             cmd = new SqlCommand("delete from OA_EMPLOYEE_JOB where emp_id=" + emp_id, conn);
  447.             cmd.ExecuteNonQuery();
  448.             if (!TxtWorkCompany1.Text.Trim().Equals(""))
  449.             {
  450.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_JOB(emp_id, begin_year, begin_month, end_year, " +
  451.                     "end_month, company, tel, salary, dimission_reason)values(" + emp_id + ",'" + TxtWorkBeginYear1.Text +
  452.                     "','" + TxtWorkBeginMonth1.Text + "','" + TxtWorkEndYear1.Text + "','" + TxtWorkEndMonth1.Text + "','" +
  453.                     TxtWorkCompany1.Text + "','" + TxtWorkTel1.Text + "','" + TxtWorkSalary1.Text + "','" +
  454.                     TxtDimissionReason1.Text + "')", conn);
  455.                 cmd.ExecuteNonQuery();
  456.             }
  457.             if (!TxtWorkCompany2.Text.Trim().Equals(""))
  458.             {
  459.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_JOB(emp_id, begin_year, begin_month, end_year, " +
  460.                     "end_month, company, tel, salary, dimission_reason)values(" + emp_id + ",'" + TxtWorkBeginYear2.Text +
  461.                     "','" + TxtWorkBeginMonth2.Text + "','" + TxtWorkEndYear2.Text + "','" + TxtWorkEndMonth2.Text + "','" +
  462.                     TxtWorkCompany2.Text + "','" + TxtWorkTel2.Text + "','" + TxtWorkSalary2.Text + "','" +
  463.                     TxtDimissionReason2.Text + "')", conn);
  464.                 cmd.ExecuteNonQuery();
  465.             }
  466.             if (!TxtWorkCompany3.Text.Trim().Equals(""))
  467.             {
  468.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_JOB(emp_id, begin_year, begin_month, end_year, " +
  469.                     "end_month, company, tel, salary, dimission_reason)values(" + emp_id + ",'" + TxtWorkBeginYear3.Text +
  470.                     "','" + TxtWorkBeginMonth3.Text + "','" + TxtWorkEndYear3.Text + "','" + TxtWorkEndMonth3.Text + "','" +
  471.                     TxtWorkCompany3.Text + "','" + TxtWorkTel3.Text + "','" + TxtWorkSalary3.Text + "','" +
  472.                     TxtDimissionReason3.Text + "')", conn);
  473.                 cmd.ExecuteNonQuery();
  474.             }
  475.             if (!TxtWorkCompany4.Text.Trim().Equals(""))
  476.             {
  477.                 cmd = new SqlCommand("insert into OA_EMPLOYEE_JOB(emp_id, begin_year, begin_month, end_year, " +
  478.                     "end_month, company, tel, salary, dimission_reason)values(" + emp_id + ",'" + TxtWorkBeginYear4.Text +
  479.                     "','" + TxtWorkBeginMonth4.Text + "','" + TxtWorkEndYear4.Text + "','" + TxtWorkEndMonth4.Text + "','" +
  480.                     TxtWorkCompany4.Text + "','" + TxtWorkTel4.Text + "','" + TxtWorkSalary4.Text + "','" +
  481.                     TxtDimissionReason4.Text + "')", conn);
  482.                 cmd.ExecuteNonQuery();
  483.             }
  485.             //更新技能
  486.             sql = "update OA_EMPLOYEE_SKILL set [language]='" + TxtLanguage.Text + "', computer_grade='" +
  487.                 TxtComputerGrade.Text + "', certificate='" + TxtCertificate.Text + "',other='" + TxtOther.Text +
  488.                 "' where emp_id=" + emp_id;
  489.             cmd = new SqlCommand(sql, conn);
  490.             int count = cmd.ExecuteNonQuery();
  491.             if (count == 0)
  492.             {
  493.                 if (!TxtLanguage.Text.Trim().Equals("") || !TxtComputerGrade.Text.Trim().Equals("")
  494.                     || !TxtCertificate.Text.Trim().Equals("") || !TxtOther.Text.Trim().Equals(""))
  495.                 {
  496.                     int skill_id = 1;
  497.                     cmd = new SqlCommand("select max(id) from OA_EMPLOYEE_SKILL", conn);
  498.                     try
  499.                     {
  500.                         skill_id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  501.                     }
  502.                     catch { }
  503.                     cmd = new SqlCommand("insert into OA_EMPLOYEE_SKILL(id, emp_id, language, computer_grade, " +
  504.                         "certificate, other) values(" + skill_id + "," + emp_id + ",'" + TxtLanguage.Text + "','" +
  505.                         TxtComputerGrade.Text + "','" + TxtCertificate.Text + "','" + TxtOther.Text + "')", conn);
  506.                     cmd.ExecuteNonQuery();
  507.                 }
  508.             }
  509.             conn.Close();
  510.             Session["p_department_id"] = DepartmentId.Value;
  511.             Response.Redirect("employee_list_index.aspx");
  512.         }
  513.     }
  514.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  515.     {
  516.         if (Calendar1.Visible == true)
  517.         {
  518.             Calendar1.Visible = false;
  519.         }
  520.         else
  521.         {
  522.             Calendar1.Visible = true;
  523.         }
  524.     }
  525.     protected void Calendar1_SelectionChanged(object sender, EventArgs e)
  526.     {
  527.         string year = Calendar1.SelectedDate.Year.ToString();
  528.         string month = Calendar1.SelectedDate.Month.ToString();
  529.         if (month.Length == 1)
  530.         {
  531.             month = "0" + month;
  532.         }
  533.         string day = Calendar1.SelectedDate.Day.ToString();
  534.         if (day.Length == 1)
  535.         {
  536.             day = "0" + day;
  537.         }
  539.         TxtActiveDate.Text = year + "-" + month + "-" + day;
  540.         Calendar1.Visible = false;
  541.     }
  542.     protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
  543.     {
  544.         if (Calendar2.Visible == true)
  545.         {
  546.             Calendar2.Visible = false;
  547.         }
  548.         else
  549.         {
  550.             Calendar2.Visible = true;
  551.         }
  552.     }
  553.     protected void Calendar2_SelectionChanged(object sender, EventArgs e)
  554.     {
  555.         string year = Calendar2.SelectedDate.Year.ToString();
  556.         string month = Calendar2.SelectedDate.Month.ToString();
  557.         if (month.Length == 1)
  558.         {
  559.             month = "0" + month;
  560.         }
  561.         string day = Calendar2.SelectedDate.Day.ToString();
  562.         if (day.Length == 1)
  563.         {
  564.             day = "0" + day;
  565.         }
  567.         TxtDimissionDate.Text = year + "-" + month + "-" + day;
  568.         Calendar2.Visible = false;
  569.     }
  570. }