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

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

OA系统

开发平台：

ASP/ASPX

form.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  4. using System.Configuration;
  5. using System.Collections;
  6. using System.Web;
  7. using System.Web.Security;
  8. using System.Web.UI;
  9. using System.Web.UI.WebControls;
  10. using System.Web.UI.WebControls.WebParts;
  11. using System.Web.UI.HtmlControls;
  13. public partial class web_equipment_form : System.Web.UI.Page
  14. {
  15.     string departmentid = "";
  16.     string PositionId = "";
  17.     string userid = "";
  18.     int flow_id = 1;
  19.     protected void Page_Load(object sender, EventArgs e)
  20.     {
  21.         if (!IsPostBack)
  22.         {
  23.             LoginDAO.CheckLogin(Session, Response, "../", 2);
  24.         }
  25.         if (Session["user"] != null)
  26.         {
  27.             DateMgr mgr = new DateMgr();
  28.             User user = (User)Session["user"];
  29.             IFromNo.Text = mgr.getTime();
  30.             txemp_name.Text = user.Emp_name;
  31.             tbdate.Text = mgr.getDate();
  32.             tbdepartment.Text = user.Department.Full_name;
  33.             PositionId = user.PositionId.ToString();
  34.             departmentid = user.Department.Id.ToString();
  35.             userid = user.Id.ToString();
  36.         }
  37.     }
  38.     public void check()
  39.     {
  40.         SqlConnection conn = dbConnection.getConnection();
  41.         conn.Open();
  42.         string sql = "";
  43.         if (!name1.Text.Equals(""))
  44.         {
  45.             try
  46.             {
  47.                 int id = 1;
  48.                 SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form_d", conn);
  49.                 try
  50.                 {
  51.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  52.                 }
  53.                 catch
  54.                 {
  55.                 }
  56.                 string type = "";
  57.                 string charge = "";
  58.                 if (cb_1_1.Checked)
  59.                 {
  60.                     if (type.Equals(""))
  61.                     {
  62.                         type = cb_1_1.Text.ToString();
  63.                         charge = charge1_1.Text.ToString();
  64.                     }
  65.                     else
  66.                     {
  67.                         type = type + "/" + cb_1_1.Text.ToString();
  68.                         charge = charge + "/" + charge1_1.Text.ToString();
  69.                     }
  70.                 }
  71.                 if (cb_2_1.Checked)
  72.                 {
  73.                     if (type.Equals(""))
  74.                     {
  75.                         type = cb_2_1.Text.ToString();
  76.                         charge = charge2_1.Text.ToString();
  77.                     }
  78.                     else
  79.                     {
  80.                         type = type + "/" + cb_2_1.Text.ToString();
  81.                         charge = charge + "/" + charge2_1.Text.ToString();
  82.                     }
  83.                 }
  84.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +id+"','"+
  85.                      IFromNo.Text.ToString() + "','" + name1.Text.ToString() + "','" + standard1.Text + "','" + unit1.Text.ToString() + "','" + num1.Text.ToString() + "','" +
  86.                     cause1.Text.ToString() + "','" + date1.Text.ToString() + "','" + type + "','" + charge + "','" + remark1.Text.ToString() + "')";
  87.                 cmd = new SqlCommand(sql, conn);
  88.                 cmd.ExecuteNonQuery();
  89.             }
  90.             catch (Exception ex)
  91.             {
  92.                 Response.Write(ex.Message);
  93.             }
  94.         }
  95.         if (!name2.Text.Equals(""))
  96.         {
  97.             try
  98.             {
  99.                 int id = 1;
  100.                 SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form_d", conn);
  101.                 try
  102.                 {
  103.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  104.                 }
  105.                 catch
  106.                 {
  107.                 }
  108.                 string type = "";
  109.                 string charge = "";
  110.                 if (cb_1_2.Checked)
  111.                 {
  112.                     if (type.Equals(""))
  113.                     {
  114.                         type = cb_1_2.Text.ToString();
  115.                         charge = charge1_2.Text.ToString();
  116.                     }
  117.                     else
  118.                     {
  119.                         type = type + "/" + cb_1_2.Text.ToString();
  120.                         charge = charge + "/" + charge1_2.Text.ToString();
  121.                     }
  122.                 }
  123.                 if (cb_2_1.Checked)
  124.                 {
  125.                     if (type.Equals(""))
  126.                     {
  127.                         type = cb_2_2.Text.ToString();
  128.                         charge = charge2_2.Text.ToString();
  129.                     }
  130.                     else
  131.                     {
  132.                         type = type + "/" + cb_2_2.Text.ToString();
  133.                         charge = charge + "/" + charge2_2.Text.ToString();
  134.                     }
  135.                 }
  136.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +
  137.                     id + "','" + IFromNo.Text.ToString() + "','" + name2.Text.ToString() + "','" + standard2.Text + "','" + unit2.Text.ToString() + "','" + num2.Text.ToString() + "','" +
  138.                     cause2.Text.ToString() + "','" + date2.Text.ToString() + "','" + type + "','" + charge + "','" + remark2.Text.ToString() + "')";
  139.                 cmd = new SqlCommand(sql, conn);
  140.                 cmd.ExecuteNonQuery();
  141.             }
  142.             catch (Exception ex)
  143.             {
  144.                 Response.Write(ex.Message);
  145.             }
  146.         }
  147.         if (!name3.Text.Equals(""))
  148.         {
  149.             try
  150.             {
  151.                 int id = 1;
  152.                 SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form_d", conn);
  153.                 try
  154.                 {
  155.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  156.                 }
  157.                 catch
  158.                 {
  159.                 }
  160.                 string type = "";
  161.                 string charge = "";
  162.                 if (cb_1_3.Checked)
  163.                 {
  164.                     if (type.Equals(""))
  165.                     {
  166.                         type = cb_1_3.Text.ToString();
  167.                         charge = charge1_3.Text.ToString();
  168.                     }
  169.                     else
  170.                     {
  171.                         type = type + "/" + cb_1_3.Text.ToString();
  172.                         charge = charge + "/" + charge1_3.Text.ToString();
  173.                     }
  174.                 }
  175.                 if (cb_2_3.Checked)
  176.                 {
  177.                     if (type.Equals(""))
  178.                     {
  179.                         type = cb_2_3.Text.ToString();
  180.                         charge = charge2_3.Text.ToString();
  181.                     }
  182.                     else
  183.                     {
  184.                         type = type + "/" + cb_2_3.Text.ToString();
  185.                         charge = charge + "/" + charge2_3.Text.ToString();
  186.                     }
  187.                 }
  188.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +
  189.                     id + "','" + IFromNo.Text.ToString() + "','" + name3.Text.ToString() + "','" + standard3.Text + "','" + unit3.Text.ToString() + "','" + num3.Text.ToString() + "','" +
  190.                     cause3.Text.ToString() + "','" + date3.Text.ToString() + "','" + type + "','" + charge + "','" + remark3.Text.ToString() + "')";
  191.                 cmd = new SqlCommand(sql, conn);
  192.                 cmd.ExecuteNonQuery();
  193.             }
  194.             catch (Exception ex)
  195.             {
  196.                 Response.Write(ex.Message);
  197.             }
  198.         }
  199.         if (!name4.Text.Equals(""))
  200.         {
  201.             try
  202.             {
  203.                 int id = 1;
  204.                 SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form_d", conn);
  205.                 try
  206.                 {
  207.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  208.                 }
  209.                 catch
  210.                 {
  211.                 }
  212.                 string type = "";
  213.                 string charge = "";
  214.                 if (cb_1_4.Checked)
  215.                 {
  216.                     if (type.Equals(""))
  217.                     {
  218.                         type = cb_1_4.Text.ToString();
  219.                         charge = charge1_4.Text.ToString();
  220.                     }
  221.                     else
  222.                     {
  223.                         type = type + "/" + cb_1_4.Text.ToString();
  224.                         charge = charge + "/" + charge1_4.Text.ToString();
  225.                     }
  226.                 }
  227.                 if (cb_2_4.Checked)
  228.                 {
  229.                     if (type.Equals(""))
  230.                     {
  231.                         type = cb_2_4.Text.ToString();
  232.                         charge = charge2_4.Text.ToString();
  233.                     }
  234.                     else
  235.                     {
  236.                         type = type + "/" + cb_2_4.Text.ToString();
  237.                         charge = charge + "/" + charge2_4.Text.ToString();
  238.                     }
  239.                 }
  240.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +
  241.                     id + "','" + IFromNo.Text.ToString() + "','" + name4.Text.ToString() + "','" + standard4.Text + "','" + unit4.Text.ToString() + "','" + num4.Text.ToString() + "','" +
  242.                     cause4.Text.ToString() + "','" + date4.Text.ToString() + "','" + type + "','" + charge + "','" + remark4.Text.ToString() + "')";
  243.                 cmd = new SqlCommand(sql, conn);
  244.                 cmd.ExecuteNonQuery();
  245.             }
  246.             catch (Exception ex)
  247.             {
  248.                 Response.Write(ex.Message);
  249.             }
  250.         }
  251.         if (!name5.Text.Equals(""))
  252.         {
  253.             try
  254.             {
  255.                 int id = 1;
  256.                 SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form_d", conn);
  257.                 try
  258.                 {
  259.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  260.                 }
  261.                 catch
  262.                 {
  263.                 }
  264.                 string type = "";
  265.                 string charge = "";
  266.                 if (cb_1_5.Checked)
  267.                 {
  268.                     if (type.Equals(""))
  269.                     {
  270.                         type = cb_1_5.Text.ToString();
  271.                         charge = charge1_5.Text.ToString();
  272.                     }
  273.                     else
  274.                     {
  275.                         type = type + "/" + cb_1_5.Text.ToString();
  276.                         charge = charge + "/" + charge1_5.Text.ToString();
  277.                     }
  278.                 }
  279.                 if (cb_2_5.Checked)
  280.                 {
  281.                     if (type.Equals(""))
  282.                     {
  283.                         type = cb_2_5.Text.ToString();
  284.                         charge = charge2_5.Text.ToString();
  285.                     }
  286.                     else
  287.                     {
  288.                         type = type + "/" + cb_2_5.Text.ToString();
  289.                         charge = charge + "/" + charge2_5.Text.ToString();
  290.                     }
  291.                 }
  292.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +
  293.                     id + "','" + IFromNo.Text.ToString() + "','" + name5.Text.ToString() + "','" + standard5.Text + "','" + unit5.Text.ToString() + "','" + num5.Text.ToString() + "','" +
  294.                     cause5.Text.ToString() + "','" + date5.Text.ToString() + "','" + type + "','" + charge + "','" + remark5.Text.ToString() + "')";
  295.                 cmd = new SqlCommand(sql, conn);
  296.                 cmd.ExecuteNonQuery();
  297.             }
  298.             catch (Exception ex)
  299.             {
  300.                 Response.Write(ex.Message);
  301.             }
  302.         }
  303.         if (!name6.Text.Equals(""))
  304.         {
  305.             try
  306.             {
  307.                 int id = 1;
  308.                 SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form_d", conn);
  309.                 try
  310.                 {
  311.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  312.                 }
  313.                 catch
  314.                 {
  315.                 }
  316.                 string type = "";
  317.                 string charge = "";
  318.                 if (cb_1_6.Checked)
  319.                 {
  320.                     if (type.Equals(""))
  321.                     {
  322.                         type = cb_1_6.Text.ToString();
  323.                         charge = charge1_6.Text.ToString();
  324.                     }
  325.                     else
  326.                     {
  327.                         type = type + "/" + cb_1_6.Text.ToString();
  328.                         charge = charge + "/" + charge1_6.Text.ToString();
  329.                     }
  330.                 }
  331.                 if (cb_2_6.Checked)
  332.                 {
  333.                     if (type.Equals(""))
  334.                     {
  335.                         type = cb_2_6.Text.ToString();
  336.                         charge = charge2_6.Text.ToString();
  337.                     }
  338.                     else
  339.                     {
  340.                         type = type + "/" + cb_2_6.Text.ToString();
  341.                         charge = charge + "/" + charge2_6.Text.ToString();
  342.                     }
  343.                 }
  344.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +
  345.                     id + "','" + IFromNo.Text.ToString() + "','" + name6.Text.ToString() + "','" + standard6.Text + "','" + unit6.Text.ToString() + "','" + num6.Text.ToString() + "','" +
  346.                     cause6.Text.ToString() + "','" + date6.Text.ToString() + "','" + type + "','" + charge + "','" + remark6.Text.ToString() + "')";
  347.                 cmd = new SqlCommand(sql, conn);
  348.                 cmd.ExecuteNonQuery();
  349.             }
  350.             catch (Exception ex)
  351.             {
  352.                 Response.Write(ex.Message);
  353.             }
  354.         }
  355.         if (!name7.Text.Equals(""))
  356.         {
  357.             try
  358.             {
  359.                 int id = 1;
  360.                 SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form_d", conn);
  361.                 try
  362.                 {
  363.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  364.                 }
  365.                 catch
  366.                 {
  367.                 }
  368.                 string type = "";
  369.                 string charge = "";
  370.                 if (cb_1_7.Checked)
  371.                 {
  372.                     if (type.Equals(""))
  373.                     {
  374.                         type = cb_1_7.Text.ToString();
  375.                         charge = charge1_7.Text.ToString();
  376.                     }
  377.                     else
  378.                     {
  379.                         type = type + "/" + cb_1_7.Text.ToString();
  380.                         charge = charge + "/" + charge1_7.Text.ToString();
  381.                     }
  382.                 }
  383.                 if (cb_2_7.Checked)
  384.                 {
  385.                     if (type.Equals(""))
  386.                     {
  387.                         type = cb_2_7.Text.ToString();
  388.                         charge = charge2_7.Text.ToString();
  389.                     }
  390.                     else
  391.                     {
  392.                         type = type + "/" + cb_2_7.Text.ToString();
  393.                         charge = charge + "/" + charge2_7.Text.ToString();
  394.                     }
  395.                 }
  396.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +
  397.                     id + "','" + IFromNo.Text.ToString() + "','" + name7.Text.ToString() + "','" + standard7.Text + "','" + unit7.Text.ToString() + "','" + num7.Text.ToString() + "','" +
  398.                     cause7.Text.ToString() + "','" + date7.Text.ToString() + "','" + type + "','" + charge + "','" + remark7.Text.ToString() + "')";
  399.                 cmd = new SqlCommand(sql, conn);
  400.                 cmd.ExecuteNonQuery();
  401.             }
  402.             catch (Exception ex)
  403.             {
  404.                 Response.Write(ex.Message);
  405.             }
  406.         }
  407.         if (!name8.Text.Equals(""))
  408.         {
  409.             try
  410.             {
  411.                 int id = 1;
  412.                 SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form_d", conn);
  413.                 try
  414.                 {
  415.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  416.                 }
  417.                 catch
  418.                 {
  419.                 }
  420.                 string type = "";
  421.                 string charge = "";
  422.                 if (cb_1_8.Checked)
  423.                 {
  424.                     if (type.Equals(""))
  425.                     {
  426.                         type = cb_1_8.Text.ToString();
  427.                         charge = charge1_8.Text.ToString();
  428.                     }
  429.                     else
  430.                     {
  431.                         type = type + "/" + cb_1_8.Text.ToString();
  432.                         charge = charge + "/" + charge1_8.Text.ToString();
  433.                     }
  434.                 }
  435.                 if (cb_2_8.Checked)
  436.                 {
  437.                     if (type.Equals(""))
  438.                     {
  439.                         type = cb_2_8.Text.ToString();
  440.                         charge = charge2_8.Text.ToString();
  441.                     }
  442.                     else
  443.                     {
  444.                         type = type + "/" + cb_2_8.Text.ToString();
  445.                         charge = charge + "/" + charge2_8.Text.ToString();
  446.                     }
  447.                 }
  448.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +
  449.                     id + "','" + IFromNo.Text.ToString() + "','" + name8.Text.ToString() + "','" + standard8.Text + "','" + unit1.Text.ToString() + "','" + num8.Text.ToString() + "','" +
  450.                     cause8.Text.ToString() + "','" + date8.Text.ToString() + "','" + type + "','" + charge + "','" + remark8.Text.ToString() + "')";
  451.                 cmd = new SqlCommand(sql, conn);
  452.                 cmd.ExecuteNonQuery();
  453.             }
  454.             catch (Exception ex)
  455.             {
  456.                 Response.Write(ex.Message);
  457.             }
  458.         }
  459.         if (!name9.Text.Equals(""))
  460.         {
  461.             try
  462.             {
  463.                 int id = 1;
  464.                 SqlCommand cmd = new SqlCommand("select max(id) as id from oa_equipment_form_d", conn);
  465.                 try
  466.                 {
  467.                     id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  468.                 }
  469.                 catch
  470.                 {
  471.                 }
  472.                 string type = "";
  473.                 string charge = "";
  474.                 if (cb_1_9.Checked)
  475.                 {
  476.                     if (type.Equals(""))
  477.                     {
  478.                         type = cb_1_9.Text.ToString();
  479.                         charge = charge1_9.Text.ToString();
  480.                     }
  481.                     else
  482.                     {
  483.                         type = type + "/" + cb_1_9.Text.ToString();
  484.                         charge = charge + "/" + charge1_9.Text.ToString();
  485.                     }
  486.                 }
  487.                 if (cb_2_9.Checked)
  488.                 {
  489.                     if (type.Equals(""))
  490.                     {
  491.                         type = cb_2_9.Text.ToString();
  492.                         charge = charge2_9.Text.ToString();
  493.                     }
  494.                     else
  495.                     {
  496.                         type = type + "/" + cb_2_9.Text.ToString();
  497.                         charge = charge + "/" + charge2_9.Text.ToString();
  498.                     }
  499.                 }
  500.                 sql = "insert into oa_equipment_form_d(id,form_id,equipment_name,standard,equipment_unit,equipment_num,cause,apply_date,type,charge,remark)values('" +
  501.                     id + "','" + IFromNo.Text.ToString() + "','" + name9.Text.ToString() + "','" + standard9.Text + "','" + unit9.Text.ToString() + "','" + num9.Text.ToString() + "','" +
  502.                     cause9.Text.ToString() + "','" + date9.Text.ToString() + "','" + type + "','" + charge + "','" + remark9.Text.ToString() + "')";
  503.                 cmd = new SqlCommand(sql, conn);
  504.                 cmd.ExecuteNonQuery();
  505.             }
  506.             catch (Exception ex)
  507.             {
  508.                 Response.Write(ex.Message);
  509.             }
  510.         }
  511.         conn.Close();
  512.     }
  513.     public void save(int state)
  514.     {
  515.         if (cb1.Checked || cb2.Checked || cb3.Checked || cb4.Checked || cb5.Checked || cb6.Checked)
  516.         {
  517.             if (!name1.Text.Equals("") || !name2.Text.Equals("") || !name3.Text.Equals("") || !name4.Text.Equals("") || !name5.Text.Equals("") || !name6.Text.Equals("") || !name7.Text.Equals("") || !name8.Text.Equals("") || !name9.Text.Equals(""))
  518.             {
  519.                 string type = "";
  520.                 if (cb1.Checked)
  521.                 {
  522.                     if (type.Equals(""))
  523.                     {
  524.                         type = cb1.Text.ToString();
  525.                     }
  526.                     else
  527.                     {
  528.                         type = type + "/" + cb1.Text.ToString();
  529.                     }
  530.                 }
  531.                 if (cb2.Checked)
  532.                 {
  533.                     if (type.Equals(""))
  534.                     {
  535.                         type = cb2.Text.ToString();
  536.                     }
  537.                     else
  538.                     {
  539.                         type = type + "/" + cb2.Text.ToString();
  540.                     }
  541.                 }
  542.                 if (cb3.Checked)
  543.                 {
  544.                     if (type.Equals(""))
  545.                     {
  546.                         type = cb3.Text.ToString();
  547.                     }
  548.                     else
  549.                     {
  550.                         type = type + "/" + cb3.Text.ToString();
  551.                     }
  552.                 }
  553.                 if (cb4.Checked)
  554.                 {
  555.                     if (type.Equals(""))
  556.                     {
  557.                         type = cb4.Text.ToString();
  558.                     }
  559.                     else
  560.                     {
  561.                         type = type + "/" + cb4.Text.ToString();
  562.                     }
  563.                 }
  564.                 if (cb5.Checked)
  565.                 {
  566.                     if (type.Equals(""))
  567.                     {
  568.                         type = cb5.Text.ToString();
  569.                     }
  570.                     else
  571.                     {
  572.                         type = type + "/" + cb5.Text.ToString();
  573.                     }
  574.                 }
  575.                 if (cb6.Checked)
  576.                 {
  577.                     if (type.Equals(""))
  578.                     {
  579.                         type = cb6.Text.ToString();
  580.                     }
  581.                     else
  582.                     {
  583.                         type = type + "/" + cb6.Text.ToString();
  584.                     }
  585.                 }
  586.                 SqlConnection conn = dbConnection.getConnection();
  587.                 conn.Open();
  588.                 string sql = "";
  589.                 try
  590.                 {
  591.                     int id = 1;
  592.                     SqlCommand cmd = new SqlCommand("select max(id) from oa_equipment_form", conn);
  593.                     try
  594.                     {
  595.                         id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
  596.                     }
  597.                     catch
  598.                     {
  599.                     }
  600.                     string total_result = "跑流程中";
  601.                     if (state == 2)
  602.                     {
  603.                         total_result = "未送件";
  604.                     }
  605.                     sql = "insert into oa_equipment_form(id,form_id,type,emp_id,apply_date,department_id,step,status,finish_date,total_result)values('" +
  606.                     +id + "','" + IFromNo.Text.ToString() + "','" + type + "','" + Session["user_id"] + "','" + tbdate.Text.ToString() +
  607.                     "','" + departmentid + "','1','" + state + "','','"+total_result+"')";
  608.                     cmd = new SqlCommand(sql, conn);
  609.                     cmd.ExecuteNonQuery();
  610.                     check();
  611.                     cmd = new SqlCommand("select max(id) from oa_equipment_flow", conn);
  612.                     try
  613.                     {
  614.                         flow_id = Convert.ToInt32(cmd.ExecuteScalar()) + 1;
  615.                     }
  616.                     catch (Exception ex)
  617.                     {
  618.                     }
  619.                     if (state == 1)
  620.                     {
  621.                         ArrayList id1 = new ArrayList();
  622.                         ArrayList id2 = new ArrayList();//记录上层节点职级小于登陆者的ID
  623.                         ArrayList name_1 = new ArrayList();//记录上层节点职级小于登陆者的name
  624.                         ArrayList mail_1 = new ArrayList();//记录上层节点职级小于登陆者的mail
  625.                         ArrayList last_id = new ArrayList();//记录上层节点的ID
  626.                         //判断是否为副董办公室
  627.                         if (departmentid.Equals("50"))
  628.                         {
  629.                          Response.Redirect("my_list.aspx", true);
  630.                         }
  631.                         int ceng = 0;
  632.                         cmd = new SqlCommand("select ceng from dbo.OA_DEPARTMENT where id='" + departmentid + "'", conn);
  633.                         ceng = Convert.ToInt32(cmd.ExecuteScalar()) - 3;
  634.                          if (ceng < 0 || ceng == 0)
  635.                          {
  636.                                 ceng = 0;
  637.                          }
  638.                         last_id.Add(departmentid);
  639.                         for (int i = 1; i <=ceng; i++)
  640.                         {
  641.                             cmd = new SqlCommand("select distinct last_id from oa_department where id='" + last_id[i - 1] + "'", conn);
  642.                             SqlDataReader dr1 = cmd.ExecuteReader();
  643.                             while (dr1.Read())
  644.                             {
  645.                                last_id.Add(dr1["last_id"].ToString());
  646.                             }
  647.                             dr1.Close();
  648.                         }
  649.                         for (int i = 0; i < last_id.Count; i++)
  650.                         {
  651.                             cmd = new SqlCommand("select id,email_work,emp_name from oa_employee where department_id='" + last_id[i] + "'and q_manger='1'", conn);
  652.                             SqlDataReader dr2 = cmd.ExecuteReader();
  653.                             while (dr2.Read())
  654.                             {
  655.                                 id1.Add(dr2["id"].ToString());
  656.                                 //name_1.Add(dr2["emp_name"].ToString());
  657.                                 //mail_1.Add(dr2["email_work"].ToString());
  658.                             }
  659.                             dr2.Close();
  660.                         }
  661.                         id1.Add("6");
  662.                         for (int i = 0; i < id1.Count; i++)
  663.                         {
  664.                             if (id1[i].Equals(Session["user_id"]))
  665.                             {
  666.                                 id1.RemoveAt(i);
  667.                                 //name_1.RemoveAt(i);
  668.                                 //mail_1.RemoveAt(i);
  669.                             }
  670.                         }
  671.                         foreach(string i in id1)
  672.                         {
  673.                             string str = check_supply(i);
  674.                             id2.Add(str);
  675.                             cmd = new SqlCommand("select email_work,emp_name from oa_employee where id='" + str + "'", conn);
  676.                             SqlDataReader dr3 = cmd.ExecuteReader();
  677.                             if (dr3.HasRows)
  678.                             {
  679.                                 while (dr3.Read())
  680.                                 {
  681.                                     name_1.Add(dr3["emp_name"].ToString());
  682.                                     mail_1.Add(dr3["email_work"].ToString());
  683.                                 }
  684.                             }
  685.                             dr3.Close();
  686.                         }
  687.                         if (id2.Count != 0)
  688.                         {
  689.                             for (int j = 0; j < id2.Count; j++)
  690.                             {
  691.                                 cmd = new SqlCommand("insert into oa_equipment_flow(id,form_id,operator_id,is_check,is_agree,comment,check_date,step)values('" + flow_id + "','" + IFromNo.Text.ToString() + "','" + id2[j].ToString() + "','N','N','','','" + (j + 1) + "')", conn);
  692.                                 cmd.ExecuteNonQuery();
  693.                                 flow_id = flow_id + 1;
  694.                             }
  695.                             if (state == 1)
  696.                             {
  697.                                 mail.mail_q(mail_1[0], name_1[0], txemp_name.Text, "設備申請單");
  698.                             }
  699.                             Response.Redirect("my_list.aspx");
  700.                         }
  701.                         else
  702.                         {
  703.                             ShowMessageBox("沒有找到相關處理流程, 請與管理員聯繫");
  704.                         }
  705.                     }
  706.                     else
  707.                     {
  708.                         Response.Redirect("my_list.aspx");
  709.                     }
  710.                     ShowMessageBox("申请成功");
  711.                 }
  712.                 catch (Exception ex)
  713.                 {
  714.                     Response.Write(ex.Message);
  715.                     ShowMessageBox("申请失败");
  716.                }
  717.                 conn.Close();
  718.             }
  719.             else
  720.             {
  721.                 ShowMessageBox("請填寫申請品名稱");
  722.             }
  723.         }
  724.         else
  725.         {
  726.             ShowMessageBox("請選擇設備類型");
  727.         }
  728.     }
  729.     public string check_supply(string id)
  730.     {
  731.         string emp_id = id;
  732.         SqlConnection conn = dbConnection.getConnection();
  733.         conn.Open();
  734.         DateTime date = DateTime.Now;
  735.         try
  736.         {
  737.             SqlCommand cmd = new SqlCommand("select d_people,s_date,e_date from OA_DELEGATE where b_d_people='" + id + "'", conn);
  738.             SqlDataReader dr = cmd.ExecuteReader();
  739.             if (dr.HasRows)
  740.             {
  741.                 while (dr.Read())
  742.                 {
  743.                     if ((!dr["s_date"].ToString().Equals("")) && (!dr["e_date"].ToString().Equals("")))
  744.                     {
  745.                         if ((date >= Convert.ToDateTime(dr["s_date"])) && (date <= Convert.ToDateTime(dr["e_date"])))
  746.                         {
  747.                             emp_id = Convert.ToString(dr["d_people"]);
  748.                         }
  749.                         else
  750.                         {
  751.                         }
  752.                     }
  753.                 }
  754.             }
  755.         }
  756.         catch
  757.         {
  758.         }
  759.         return emp_id;
  760.     }
  761.     protected void ShowMessageBox(string strMessage)
  762.     {
  763.         Response.Write(string.Format("<script>alert('{0}')</script>", strMessage));
  764.     }
  765.     protected void Button1_Click(object sender, EventArgs e)
  766.     {
  767.         save(1);
  768.     }
  769.     protected void Button2_Click(object sender, EventArgs e)
  770.     {
  771.         save(2);
  772.     }
  773. }