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

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

OA系统

开发平台：

ASP/ASPX

deal_list.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_approvel_ch_deal_list : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         if (!IsPostBack)
  18.         {
  19.             LoginDAO.CheckLogin(Session, Response, "../../", 2);
  20.             this.SetMainTable();
  21.             if (Request.QueryString["f_id"] != null)
  22.             {
  23.                
  24.                 PnlApprovel.Visible = true;
  25.                 PnlDeal.Visible = true;
  26.                 this.SetValue(Request.QueryString["f_id"]);
  27.             }
  28.             if (Request.QueryString["o_id"] != null)
  29.             {
  30.               
  31.                 PnlOff.Visible = true;
  32.                 PnlDeal.Visible = true;
  33.                 this.SetOffValue(Request.QueryString["o_id"]);
  34.             }
  35.         }
  36.     }
  37.     protected void SetMainTable()
  38.     {
  39.         SqlConnection conn = dbConnection.getConnection();
  40.         conn.Open();
  42.         string user_id = "0";
  43.         if (Session["user_id"] != null)
  44.         {
  45.             user_id = Session["user_id"].ToString();
  46.         }
  48.         ArrayList ids = new ArrayList();
  49.         ArrayList form_ids = new ArrayList();
  50.         ArrayList is_businesses = new ArrayList();
  51.         ArrayList f_steps = new ArrayList();
  52.         SqlCommand cmd = new SqlCommand("SELECT f.id, f.form_id, f.is_business, f.step FROM dbo.OA_CH_APPROVEL_FORM_FLOW AS f " +
  53.             " left join oa_ch_business_form as b on f.form_id=b.id WHERE (f.operator_id = " + user_id + ") AND (f.is_check = 'N') and state=1", conn);
  55.         SqlDataReader dr = cmd.ExecuteReader();
  56.         while (dr.Read())
  57.         {
  58.             ids.Add(dr["id"].ToString());
  59.             form_ids.Add(dr["form_id"].ToString());
  60.             is_businesses.Add(dr["is_business"].ToString());
  61.             f_steps.Add(dr["step"].ToString());
  62.         }
  63.         dr.Close();
  65.         for (int i = ids.Count - 1; i >= 0; i--)
  66.         {
  67.             int f_step = Convert.ToInt32(f_steps[i]);
  68.             if (is_businesses[i].Equals("Y"))
  69.             {
  70.                 cmd = new SqlCommand("select e.emp_name, b.apply_date, b.step from OA_CH_BUSINESS_FORM b inner join " +
  71.                     "OA_EMPLOYEE e on b.emp_id=e.id where b.id=" + form_ids[i], conn);
  72.                 dr = cmd.ExecuteReader();
  73.                 if (dr.Read())
  74.                 {
  75.                     int b_step = Convert.ToInt32(dr["step"].ToString()) + 1;
  76.                     if (b_step == f_step)
  77.                     {
  78.                         TblFlow.Visible = true;
  79.                         TableRow tr = new TableRow();
  80.                         TableCell td = new TableCell();
  81.                         td.BorderWidth = Unit.Pixel(1);
  82.                         td.Text = dr["emp_name"].ToString();
  83.                         tr.Cells.Add(td);
  85.                         td = new TableCell();
  86.                         td.BorderWidth = Unit.Pixel(1);
  87.                         td.Text = dr["emp_name"].ToString() + "的出差單";
  88.                         tr.Cells.Add(td);
  90.                         td = new TableCell();
  91.                         td.BorderWidth = Unit.Pixel(1);
  92.                         td.Text = dr["apply_date"].ToString();
  93.                         tr.Cells.Add(td);
  95.                         td = new TableCell();
  96.                         td.BorderWidth = Unit.Pixel(1);
  97.                         HyperLink hl = new HyperLink();
  98.                         hl.Text = "查看";
  99.                         hl.NavigateUrl = "deal_list.aspx?f_id=" + ids[i].ToString();
  100.                         td.Controls.Add(hl);
  101.                         tr.Cells.Add(td);
  102.                         TblFlow.Rows.Add(tr);
  103.                     }
  104.                 }
  105.                 dr.Close();
  106.             }
  107.             else
  108.             {
  109.                 cmd = new SqlCommand("select e.emp_name, o.apply_date, t.name off_type, o.step from OA_CH_OFF_FORM o "+
  110.                     "inner join OA_EMPLOYEE e on o.emp_id=e.id inner join OA_CH_OFF_TYPE t on o.off_type=t.id "+
  111.                     "where o.id=" + form_ids[i] + " and state=1", conn);
  112.                 dr = cmd.ExecuteReader();
  113.                 if (dr.Read())
  114.                 {
  115.                     int b_step = Convert.ToInt32(dr["step"].ToString()) + 1;
  116.                     if (f_step == b_step)
  117.                     {
  118.                         TblFlow.Visible = true;
  119.                         TableRow tr = new TableRow();
  120.                         TableCell td = new TableCell();
  121.                         td.BorderWidth = Unit.Pixel(1);
  122.                         td.Text = dr["emp_name"].ToString();
  123.                         tr.Cells.Add(td);
  125.                         td = new TableCell();
  126.                         td.BorderWidth = Unit.Pixel(1);
  127.                         td.Text = dr["emp_name"].ToString() + "的" + dr["off_type"].ToString() + "單";
  128.                         tr.Cells.Add(td);
  130.                         td = new TableCell();
  131.                         td.BorderWidth = Unit.Pixel(1);
  132.                         td.Text = dr["apply_date"].ToString();
  133.                         tr.Cells.Add(td);
  135.                         td = new TableCell();
  136.                         td.BorderWidth = Unit.Pixel(1);
  137.                         HyperLink hl = new HyperLink();
  138.                         hl.Text = "查看";
  139.                         hl.NavigateUrl = "deal_list.aspx?o_id=" + ids[i].ToString();
  140.                         td.Controls.Add(hl);
  141.                         tr.Cells.Add(td);
  142.                         TblFlow.Rows.Add(tr);
  143.                     }
  144.                 }
  145.                 dr.Close();
  146.             }
  147.         }
  148.         conn.Close();
  149.     }
  150.     protected void SetValue(string id)
  151.     {
  152.         SqlConnection conn = dbConnection.getConnection();
  153.         conn.Open();
  154.         int form_id = 0;
  155.         string is_business = "";
  156.         SqlCommand cmd = new SqlCommand("select form_id, is_business from OA_CH_APPROVEL_FORM_FLOW where id="+id, conn);
  157.         SqlDataReader dr = cmd.ExecuteReader();
  158.         if (dr.Read())
  159.         {
  160.             form_id = Convert.ToInt32(dr["form_id"].ToString());
  161.             is_business = dr["is_business"].ToString();
  162.         }
  163.         dr.Close();
  164.         FormId.Value = form_id.ToString();
  166.         if (is_business.Equals("Y"))
  167.         {
  168.             PnlApprovel.Visible = true;
  169.             cmd = new SqlCommand("select a.form_id, e.emp_name, e.emp_no, p.name position, a.apply_date," +
  170.                 "d.name department, a.days, a.begin_time, a.end_time, f1.name depart_place, f2.name arrive_place, " +
  171.                 "a.depart_time, a.arrive_time from OA_CH_BUSINESS_FORM a inner join OA_EMPLOYEE e on a.emp_id=e.id " +
  172.                 "inner join OA_DEPARTMENT d on a.department_id=d.id inner join OA_EMPLOYEE_POSITION p on " +
  173.                 "e.position=p.id inner join OA_FLIGHT_PLACE f1 on a.depart_place=f1.id inner join " +
  174.                 "OA_FLIGHT_PLACE f2 on a.arrive_place=f2.id where a.id=" + form_id, conn);
  175.             dr = cmd.ExecuteReader();
  176.             if (dr.Read())
  177.             {
  178.                 TxtFormId.Text = dr["form_id"].ToString();
  179.                 TxtEmpName.Text = dr["emp_name"].ToString();
  180.                 TxtEmpNo.Text = dr["emp_no"].ToString();
  181.                 TxtPosition.Text = dr["position"].ToString();
  182.                 TxtApplyDate.Text = dr["apply_date"].ToString();
  183.                 TxtDepartment.Text = dr["department"].ToString();
  184.                 TxtDays.Text = dr["days"].ToString();
  185.                 TxtBeginTime.Text = dr["begin_time"].ToString();
  186.                 TxtEndTime.Text = dr["end_time"].ToString();
  187.                 TxtDepartPlace.Text = dr["depart_place"].ToString();
  188.                 TxtArrivePlace.Text = dr["arrive_place"].ToString();
  189.                 TxtDepartTime.Text = dr["depart_time"].ToString();
  190.                 TxtArriveTime.Text = dr["arrive_time"].ToString();
  191.             }
  192.             dr.Close();
  193.         }
  194.         conn.Close();
  196.         this.SetTable(form_id);
  197.     }
  198.     protected void SetOffValue(string id)
  199.     {
  200.         SqlConnection conn = dbConnection.getConnection();
  201.         conn.Open();
  202.         int form_id = 0;
  203.         SqlCommand cmd = new SqlCommand("select form_id from OA_CH_APPROVEL_FORM_FLOW where id="+id, conn);
  204.         form_id = Convert.ToInt32(cmd.ExecuteScalar().ToString());
  206.         cmd = new SqlCommand("select o.form_id, e.emp_no, e.emp_name, d.name department, " +
  207.             "e.emp_name delegate, e.position position, " +
  208.             "t.name off_type, o.begin_time, o.end_time, o.hours, o.apply_date, o.parenthesis, " +
  209.             "o.reason from OA_CH_OFF_FORM o inner join OA_EMPLOYEE e on o.emp_id=e.id inner join " +
  210.             "OA_DEPARTMENT d on o.department_id=d.id inner join OA_CH_OFF_TYPE t on " +
  211.             "o.off_type=t.id where o.id=" + form_id, conn);
  212.         SqlDataReader dr = cmd.ExecuteReader();
  213.         if (dr.Read())
  214.         {
  215.             TxtOffFormId.Text = dr["form_id"].ToString();
  216.             TxtOffEmpName.Text = dr["emp_no"].ToString() + dr["emp_name"].ToString();
  217.             TxtOffDepartment.Text = dr["department"].ToString();
  218.             TxtDelegate.Text = dr["delegate"].ToString();
  219.             TxtOffPosition.Text = dr["position"].ToString();
  220.             TxtOffType2.Text = dr["off_type"].ToString();
  221.             TxtOffBeginTime.Text = dr["begin_time"].ToString();
  222.             TxtOffEndTime.Text = dr["end_time"].ToString();
  223.             TxtHours.Text = dr["hours"].ToString();
  224.             TxtOffApplyDate.Text = dr["apply_date"].ToString();
  225.             TxtParenthesis.Text = dr["parenthesis"].ToString();
  226.             TxtReason.Text = dr["reason"].ToString();
  227.         }
  228.         dr.Close();
  229.         conn.Close();
  230.     }
  232.     protected void SetTable(int form_id)
  233.     {
  235.         SqlConnection conn = dbConnection.getConnection();
  236.         conn.Open();
  237.         int flag = 0;
  238.         SqlCommand cmd = new SqlCommand("select number, company, subject, linkman, tel, place, visa_begin, visa_end, " +
  239.             "flight_go_begin, flight_back_end, is_aboard, remark from OA_CH_BUSINESS_DETAIL where form_id=" + form_id +
  240.             " order by number", conn);
  241.         SqlDataReader dr = cmd.ExecuteReader();
  242.         while (dr.Read())
  243.         {
  244.             flag = 1;
  245.             //動態創建表格行
  246.             TableRow tr1 = new TableRow();
  247.             TableCell td1 = new TableCell();
  248.             td1.BorderWidth = Unit.Pixel(1);
  250.             Label label = new Label();
  251.             label.BorderStyle = BorderStyle.None;
  252.             label.Text = dr["number"].ToString();
  253.             td1.Controls.Add(label);
  254.             tr1.Cells.Add(td1);
  256.             TableCell td2 = new TableCell();
  257.             td2.BorderWidth = Unit.Pixel(1);
  259.             label = new Label();
  260.             label.BorderStyle = BorderStyle.None;
  261.             label.Text = dr["company"].ToString();
  262.             td2.Controls.Add(label);
  263.             tr1.Cells.Add(td2);
  265.             TableCell td3 = new TableCell();
  266.             td3.BorderWidth = Unit.Pixel(1);
  268.             label = new Label();
  269.             label.BorderStyle = BorderStyle.None;
  270.             label.Text = dr["subject"].ToString();
  271.             td3.Controls.Add(label);
  272.             tr1.Cells.Add(td3);
  274.             TableCell td4 = new TableCell();
  275.             td4.BorderWidth = Unit.Pixel(1);
  277.             label = new Label();
  278.             label.BorderStyle = BorderStyle.None;
  279.             label.Text = dr["linkman"].ToString();
  280.             td4.Controls.Add(label);
  281.             tr1.Cells.Add(td4);
  283.             TableCell td5 = new TableCell();
  284.             td5.BorderWidth = Unit.Pixel(1);
  286.             label = new Label();
  287.             label.BorderStyle = BorderStyle.None;
  288.             label.Text = dr["tel"].ToString();
  289.             td5.Controls.Add(label);
  290.             tr1.Cells.Add(td5);
  292.             TableCell td6 = new TableCell();
  293.             td6.BorderWidth = Unit.Pixel(1);
  295.             label = new Label();
  296.             label.BorderStyle = BorderStyle.None;
  297.             label.Text = dr["place"].ToString();
  298.             td6.Controls.Add(label);
  299.             tr1.Cells.Add(td6);
  301.             TableCell td7 = new TableCell();
  302.             td7.BorderWidth = Unit.Pixel(1);
  304.             label = new Label();
  305.             label.BorderStyle = BorderStyle.None;
  306.             label.Text = dr["visa_begin"].ToString();
  307.             td7.Controls.Add(label);
  308.             tr1.Cells.Add(td7);
  310.             TableCell td8 = new TableCell();
  311.             td8.BorderWidth = Unit.Pixel(1);
  313.             label = new Label();
  314.             label.BorderStyle = BorderStyle.None;
  315.             label.Text = dr["visa_end"].ToString();
  316.             td8.Controls.Add(label);
  317.             tr1.Cells.Add(td8);
  319.             TableCell td9 = new TableCell();
  320.             td9.BorderWidth = Unit.Pixel(1);
  322.             label = new Label();
  323.             label.BorderStyle = BorderStyle.None;
  324.             label.Text = dr["flight_go_begin"].ToString();
  325.             td9.Controls.Add(label);
  326.             tr1.Cells.Add(td9);
  328.             TableCell td10 = new TableCell();
  329.             td10.BorderWidth = Unit.Pixel(1);
  331.             label = new Label();
  332.             label.BorderStyle = BorderStyle.None;
  333.             label.Text = dr["flight_back_end"].ToString();
  334.             td10.Controls.Add(label);
  335.             tr1.Cells.Add(td10);
  337.             TableCell td11 = new TableCell();
  338.             td11.BorderWidth = Unit.Pixel(1);
  340.             CheckBox chk = new CheckBox();
  341.             chk.Text = "國外";
  342.             chk.Enabled = false;
  343.             if (dr["is_aboard"].ToString().Equals("Y"))
  344.             {
  345.                 chk.Checked = true;
  346.             }
  347.             else
  348.             {
  349.                 chk.Checked = false;
  350.             }
  351.             td11.Controls.Add(chk);
  352.             tr1.Cells.Add(td11);
  354.             TableCell td12 = new TableCell();
  355.             td12.BorderWidth = Unit.Pixel(1);
  357.             label = new Label();
  358.             label.BorderStyle = BorderStyle.None;
  359.             label.Text = dr["remark"].ToString();
  360.             td12.Controls.Add(label);
  361.             tr1.Cells.Add(td12);
  363.             TblDetail.Rows.Add(tr1);
  364.         }
  365.         dr.Close();
  366.         conn.Close();
  368.         if (flag == 0)
  369.         {
  370.             TblDetail.Visible = false;
  371.         }
  372.     }
  373.    
  375.     protected void RbAgree_SelectedIndexChanged(object sender, EventArgs e)
  376.     {
  377.         if (TxtComment.Text.Equals("已同意") || TxtComment.Text.Equals("不同意"))
  378.         {
  379.             if (RbAgree.SelectedValue.Equals("Y"))
  380.             {
  381.                 TxtComment.Text = "已同意";
  382.             }
  383.             else
  384.             {
  385.                 TxtComment.Text = "不同意";
  386.             }
  387.         }
  388.         this.SetTable(Convert.ToInt32(FormId.Value));
  389.     }
  390.     protected void BtnOk_Click(object sender, EventArgs e)
  391.     {
  392.         SqlConnection conn = dbConnection.getConnection();
  393.         conn.Open();
  394.         SqlTransaction tx = conn.BeginTransaction();
  395.         try
  396.         {
  397.             int flow_id = 0;
  398.             if (Request.QueryString["f_id"] != null)
  399.             {
  400.                 flow_id = Convert.ToInt32(Request.QueryString["f_id"]);
  401.             }
  402.             else if (Request.QueryString["o_id"] != null)
  403.             {
  404.                 flow_id = Convert.ToInt32(Request.QueryString["o_id"]);
  405.             }
  406.             string is_business = "";
  407.             DateMgr mgr = new DateMgr();
  408.             SqlCommand cmd = new SqlCommand("update OA_CH_APPROVEL_FORM_FLOW set is_check='Y', is_agree='" +
  409.                 RbAgree.SelectedValue + "', comment='" + TxtComment.Text.Replace("n", "<br>") + "', check_date='" + mgr.getDateTime() +
  410.                 "' where id=" + flow_id, conn);
  411.             cmd.Transaction = tx;
  412.             cmd.ExecuteNonQuery();
  414.             cmd = new SqlCommand("select form_id, is_business from OA_CH_APPROVEL_FORM_FLOW where id=" + flow_id, conn);
  415.             cmd.Transaction = tx;
  416.             SqlDataReader dr = cmd.ExecuteReader();
  417.             int form_id = 0;
  418.             if (dr.Read())
  419.             {
  420.                 form_id = Convert.ToInt32(dr["form_id"].ToString());
  421.                 is_business = dr["is_business"].ToString();                
  422.             }
  423.             dr.Close();
  426.             if (is_business.Equals("Y"))
  427.             {
  428.                 cmd = new SqlCommand("select max(step) from OA_CH_APPROVEL_FORM_FLOW where form_id=" + form_id + " and is_business='Y'", conn);
  429.                 cmd.Transaction = tx;
  430.                 int max_step = Convert.ToInt32(cmd.ExecuteScalar());
  431.                 cmd = new SqlCommand("select step from OA_CH_BUSINESS_FORM where id=" + form_id, conn);
  432.                 cmd.Transaction = tx;
  433.                 int step = Convert.ToInt32(cmd.ExecuteScalar());
  434.                 string total_result = "跑流程中";
  435.                 string time = "";
  436.                 if (max_step == step + 1)
  437.                 {
  438.                     if (RbAgree.SelectedValue.Equals("N"))
  439.                     {
  440.                         total_result = "不同意";
  441.                     }
  442.                     else
  443.                     {
  444.                         total_result = "同意";
  445.                     }
  446.                     time = mgr.getDateTime();
  447.                 }
  448.                 else
  449.                 {
  450.                     if (RbAgree.SelectedValue.Equals("N"))
  451.                     {
  452.                         total_result = "不同意";
  453.                         time = mgr.getDateTime();
  454.                     }
  455.                 }
  456.                 cmd = new SqlCommand("update OA_CH_BUSINESS_FORM set step=step+1, total_result='" +
  457.                     total_result + "', finish_date='" + time + "' where id=" + form_id, conn);
  458.                 cmd.Transaction = tx;
  459.                 cmd.ExecuteNonQuery();
  460.                 //mail
  461.                 ArrayList name1 = new ArrayList();
  462.                 ArrayList mail1 = new ArrayList();
  463.                 cmd = new SqlCommand("select top 1 a.email_work,a.emp_name from oa_employee as a inner join " +
  464.                    "OA_CH_APPROVEL_FORM_FLOW as b on b.operator_id=a.id left join OA_CH_BUSINESS_FORM as c " +
  465.                      "on b.form_id=c.id where b.step=c.step+1 and c.id=" + form_id + " order by position desc", conn);
  466.                 cmd.Transaction = tx;
  467.                 SqlDataReader dr3 = cmd.ExecuteReader();
  469.                 while (dr3.Read())
  470.                 {
  471.                     name1.Add(dr3["emp_name"].ToString());
  472.                     mail1.Add(dr3["email_work"].ToString());
  473.                     mail.mail_q(mail1[0], name1[0], TxtEmpName.Text, "中幹出差申請單");
  475.                 } dr3.Close();
  476.                 //   
  477.             }
  478.             else
  479.             {
  480.                 cmd = new SqlCommand("select max(step) from OA_CH_APPROVEL_FORM_FLOW where form_id=" + form_id + " and is_business='N'", conn);
  481.                 cmd.Transaction = tx;
  482.                 int max_step = Convert.ToInt32(cmd.ExecuteScalar());
  483.                 cmd = new SqlCommand("select step from OA_CH_OFF_FORM where id=" + form_id, conn);
  484.                 cmd.Transaction = tx;
  485.                 int step = Convert.ToInt32(cmd.ExecuteScalar());
  486.                 string total_result = "跑流程中";
  487.                 string time = "";
  488.                 if (max_step == step + 1)
  489.                 {
  490.                     if (RbAgree.SelectedValue.Equals("N"))
  491.                     {
  492.                         total_result = "不同意";
  493.                     }
  494.                     else
  495.                     {
  496.                         total_result = "同意";
  497.                     }
  498.                     time = mgr.getDateTime();
  499.                 }
  500.                 else
  501.                 {
  502.                     if (RbAgree.SelectedValue.Equals("N"))
  503.                     {
  504.                         total_result = "不同意";
  505.                         time = mgr.getDateTime();
  506.                     }
  507.                 }
  508.                 cmd = new SqlCommand("update OA_CH_OFF_FORM set step=step+1, total_result='" +
  509.                     total_result + "', finish_date='" + time + "' where id=" + form_id, conn);
  510.                 cmd.Transaction = tx;
  511.                 cmd.ExecuteNonQuery();
  512.                 //mail
  513.                 ArrayList name1 = new ArrayList();
  514.                 ArrayList mail1 = new ArrayList();
  515.                 cmd = new SqlCommand("select top 1 a.email_work,a.emp_name from oa_employee as a inner join " +
  516.                    "OA_CH_APPROVEL_FORM_FLOW as b on b.operator_id=a.id left join OA_CH_OFF_FORM as c " +
  517.                      "on b.form_id=c.id where b.step=c.step+1 and c.id=" + form_id + " order by position desc", conn);
  518.                 cmd.Transaction = tx;
  519.                 SqlDataReader dr3 = cmd.ExecuteReader();
  521.                 while (dr3.Read())
  522.                 {
  523.                     name1.Add(dr3["emp_name"].ToString());
  524.                     mail1.Add(dr3["email_work"].ToString());
  525.                     mail.mail_q(mail1[0], name1[0], TxtEmpName.Text, "中幹請假單");
  527.                 } dr3.Close();
  528.                 //   
  529.             }
  531.             tx.Commit();
  532.         }
  533.         catch (Exception ex)
  534.         {
  535.             Response.Write(ex.ToString());
  536.             tx.Rollback();
  537.         }
  538.         conn.Close();
  539.         try
  540.         {
  541.             Response.Redirect("finish_list.aspx");
  542.         }
  543.         catch (Exception ex)
  544.         {
  545.             Response.Write(ex.Message);
  546.         }
  547.     }
  548. }