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

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

OA系统

开发平台：

ASP/ASPX

form_edit.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_new_repair_form_edit : System.Web.UI.Page
  14. {
  15.     int flag = 0;
  16.     protected void Page_Load(object sender, EventArgs e)
  17.     {
  18.         SqlConnection conn = dbConnection.getConnection();
  19.         conn.Open();
  20.         if (!IsPostBack)
  21.         {
  22.             dl_company.Items.Clear();
  23.             dl_company.Items.Add("所有厂商");
  24.             SqlCommand sqlcom1 = new SqlCommand("select company from OA_COMPANY order by id", conn);
  25.             SqlDataReader dr1 = sqlcom1.ExecuteReader();
  26.             if (dr1.HasRows)
  27.             {
  28.                 while (dr1.Read())
  29.                 {
  30.                     dl_company.Items.Add(dr1["company"].ToString());
  31.                 }
  32.             }
  33.             dr1.Close();
  34.             dl_type.Items.Clear();
  35.             dl_type.Items.Add("所有类型");
  36.             SqlCommand sqlcom3 = new SqlCommand("select type from OA_UNIT_TYPE order by id", conn);
  37.             SqlDataReader dr3 = sqlcom3.ExecuteReader();
  38.             if (dr3.HasRows)
  39.             {
  40.                 while (dr3.Read())
  41.                 {
  42.                     dl_type.Items.Add(dr3["type"].ToString());
  43.                 }
  44.             }
  45.             dr3.Close();
  46.             dl_name.Items.Clear();
  47.             dl_name.Items.Add("所有设备");
  48.             SqlCommand sqlcom = new SqlCommand("select eq_name from OA_UNIT_DETAIL order by id", conn);
  49.             SqlDataReader dr = sqlcom.ExecuteReader();
  50.             if (dr.HasRows)
  51.             {
  52.                 while (dr.Read())
  53.                 {
  54.                     dl_name.Items.Add(dr["eq_name"].ToString());
  55.                 }
  56.             }
  57.             dr.Close();
  58.             flag = 2;
  59.             GridView1.DataBind();
  60.             MultiView2.ActiveViewIndex = -1;
  61.             MultiView1.ActiveViewIndex = -1;
  62.             bind4();
  63.         }
  66.         conn.Close();
  67.     }
  68.     protected void Begindate_SelectionChanged(object sender, EventArgs e)
  69.     {
  70.         Begindate.Visible = false;
  71.         string year = Begindate.SelectedDate.Year.ToString();
  72.         string month = Begindate.SelectedDate.Month.ToString();
  73.         if (month.Length == 1)
  74.         {
  75.             month = "0" + month;
  76.         }
  77.         string day = Begindate.SelectedDate.Day.ToString();
  78.         if (day.Length == 1)
  79.         {
  80.             day = "0" + day;
  81.         }
  82.         b_time.Text = year + month + day + "000000";
  83.         b_time.Focus();
  84.     }
  85.     protected void Enddate_SelectionChanged(object sender, EventArgs e)
  86.     {
  87.         Enddate.Visible = false;
  88.         string year = Enddate.SelectedDate.Year.ToString();
  89.         string month = Enddate.SelectedDate.Month.ToString();
  90.         if (month.Length == 1)
  91.         {
  92.             month = "0" + month;
  93.         }
  94.         string day = Enddate.SelectedDate.Day.ToString();
  95.         if (day.Length == 1)
  96.         {
  97.             day = "0" + day;
  98.         }
  99.         e_time.Text = year + month + day + "000000";
  100.         e_time.Focus();
  101.     }
  102.     protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
  103.     {
  104.         if (Enddate.Visible == true)
  105.         {
  106.             Enddate.Visible = false;
  107.             Enddate.Focus();
  108.         }
  109.         else
  110.         {
  111.             Enddate.Visible = true;
  112.             Enddate.Focus();
  113.         }
  114.     }
  115.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  116.     {
  117.         if (Begindate.Visible == true)
  118.         {
  119.             Begindate.Visible = false;
  120.             Begindate.Focus();
  121.         }
  122.         else
  123.         {
  124.             Begindate.Visible = true;
  125.             Begindate.Focus();
  126.         }
  127.     }
  128.     protected void dl_type_SelectedIndexChanged(object sender, EventArgs e)
  129.     {
  130.         SqlConnection conn = dbConnection.getConnection();
  131.         conn.Open();
  133.         if (dl_type.SelectedItem.ToString().Equals("所有类型"))
  134.         {
  135.             dl_name.Items.Clear();
  136.             dl_name.Items.Add("所有设备");
  137.             SqlCommand sqlcom1 = new SqlCommand("select eq_name from OA_UNIT_DETAIL order by id", conn);
  138.             SqlDataReader dr1 = sqlcom1.ExecuteReader();
  139.             if (dr1.HasRows)
  140.             {
  141.                 while (dr1.Read())
  142.                 {
  143.                     dl_name.Items.Add(dr1["eq_name"].ToString());
  144.                 }
  145.             }
  146.             dr1.Close();
  147.         }
  148.         else
  149.         {
  150.             dl_name.Items.Clear();
  151.             dl_name.Items.Add("所有设备");
  152.             SqlCommand sqlcom = new SqlCommand("select eq_name from OA_UNIT_DETAIL where eq_type='" + dl_type.SelectedItem.ToString() + "'", conn);
  153.             SqlDataReader dr = sqlcom.ExecuteReader();
  154.             if (dr.HasRows)
  155.             {
  156.                 while (dr.Read())
  157.                 {
  158.                     dl_name.Items.Add(dr["eq_name"].ToString());
  159.                 }
  160.             }
  161.             dr.Close();
  162.         }
  163.         conn.Close();
  164.     }
  165.     protected void dl_company_SelectedIndexChanged(object sender, EventArgs e)
  166.     {
  167.         SqlConnection conn = dbConnection.getConnection();
  168.         conn.Open();
  169.         dl_type.Items.Clear();
  170.         dl_type.Items.Add("所有类型");
  171.         if (dl_company.SelectedItem.ToString().Equals("所有厂商"))
  172.         {
  173.             SqlCommand sqlcom3 = new SqlCommand("select type from OA_UNIT_TYPE order by id", conn);
  174.             SqlDataReader dr3 = sqlcom3.ExecuteReader();
  175.             if (dr3.HasRows)
  176.             {
  177.                 while (dr3.Read())
  178.                 {
  179.                     dl_type.Items.Add(dr3["type"].ToString());
  180.                 }
  181.             }
  182.             dr3.Close();
  183.         }
  184.         else
  185.         {
  186.             SqlCommand sqlcom = new SqlCommand("select equipment from OA_company where company='" + dl_company.SelectedItem.ToString() + "'", conn);
  187.             SqlDataReader dr = sqlcom.ExecuteReader();
  188.             if (dr.HasRows)
  189.             {
  190.                 while (dr.Read())
  191.                 {
  192.                     dl_type.Items.Add(dr["equipment"].ToString());
  193.                 }
  194.             }
  195.             dr.Close();
  196.         }
  197.         conn.Close();
  198.     }
  199.     protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
  200.     {
  201.         int i;
  202.         //执行循环，保证每条数据都可以更新
  203.         for (i = -1; i < GridView1.Rows.Count; i++)
  204.         {
  205.             //首先判断是否是数据行
  206.             if (e.Row.RowType == DataControlRowType.DataRow)
  207.             {
  208.                 //当鼠标停留时更改背景色
  209.                 e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
  210.                 //当鼠标移开时还原背景色
  211.                 e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
  212.                 e.Row.Attributes.Add("onclick", "javascript:varwin=window.open('select_edit.aspx?form_id=" + GridView1.DataKeys[e.Row.RowIndex].Value.ToString() + "',null,'width=800,height=600')");
  213.                 //e.Row.Attributes.Add("onclick", "location.href='select.aspx?form_id=" + GridView1.DataKeys[e.Row.RowIndex].Value.ToString() + "'");
  214.             }
  215.         }
  216.     }
  217.     protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
  218.     {
  219.         GridView1.PageIndex = e.NewPageIndex;
  220.         if (flag == 0)
  221.         {
  222.             bind2();
  223.         }
  224.         else if (flag == 1)
  225.         {
  226.             bind3();
  227.         }
  228.         else if (flag == 2)
  229.         {
  230.             bind4();
  231.         }
  232.         else if (flag == 3)
  233.         {
  234.             bind1();
  235.         }
  236.         else
  237.         {
  238.         }
  239.     }
  240.     public void bind1()
  241.     {
  242.         MultiView2.ActiveViewIndex = 0;
  243.         User user = (User)Session["user"];
  244.         string department = user.Department.Name;
  245.         ArrayList array = new ArrayList();
  246.         MultiView2.ActiveViewIndex = 0;
  247.         SqlConnection conn = dbConnection.getConnection();
  248.         conn.Open();
  249.         DataSet ds = new DataSet();
  250.         DataTable dt = new DataTable();
  251.         dt.Columns.Add("no", typeof(string));
  252.         dt.Columns.Add("form_id", typeof(string));
  253.         dt.Columns.Add("bxperson", typeof(string));
  254.         dt.Columns.Add("level", typeof(string));
  255.         dt.Columns.Add("department", typeof(string));
  256.         dt.Columns.Add("tel", typeof(string));
  257.         dt.Columns.Add("date", typeof(string));
  258.         dt.Columns.Add("lbperson", typeof(string));
  259.         dt.Columns.Add("type", typeof(string));
  260.         dt.Columns.Add("equipment", typeof(string));
  261.         dt.Columns.Add("comment", typeof(string));
  262.         dt.Columns.Add("company", typeof(string));
  263.         dt.Columns.Add("destine_time", typeof(string));
  264.         dt.Columns.Add("complete_time", typeof(string));
  265.         dt.Columns.Add("confirm", typeof(string));
  266.         dt.Columns.Add("remark", typeof(string));
  267.         string sqlstr = "select  f.area as area,f.level as level,f.bxperson as bxperson,f.form_id as form_id,f.department as department,f.lbperson as lbperson,f.type as type,f.equipment as equipment,f.comment as comment,f.create_time as create_time,g.company as company,g.destine_time as destine_time,g.complete_time as complete_time,g.confirm as confirm,g.remark as remark from oa_repair as f,oa_repair_d as g where g.form_id=f.form_id AND g.destine_time IS NOT NULL  and f.department='" + department.Trim() + "'";
  268.         if (!dl_company.SelectedItem.ToString().Equals("所有厂商"))
  269.         {
  270.             sqlstr = sqlstr + " and g.company='" + dl_company.SelectedItem.ToString() + "'";
  271.         }
  272.         if (!dl_type.SelectedItem.ToString().Equals("所有类型"))
  273.         {
  274.             sqlstr = sqlstr + " and f.type='" + dl_type.SelectedItem.ToString() + "'";
  275.         }
  276.         if (!dl_name.SelectedItem.ToString().Equals("所有设备"))
  277.         {
  278.             sqlstr = sqlstr + " and f.equipment='" + dl_name.SelectedItem.ToString() + "'";
  279.         }
  280.         if ((!b_time.Text.Equals("")) && (!e_time.Text.Equals("")))
  281.         {
  282.             sqlstr = sqlstr + " and f.form_id between '" + b_time.Text.ToString().Trim() + "' and '" + e_time.Text.ToString() + "'";
  283.         }
  284.         sqlstr = sqlstr + " order by form_id desc";
  285.         SqlCommand sqlcom = new SqlCommand(sqlstr, conn);
  286.         SqlDataReader dr = sqlcom.ExecuteReader();
  287.         if (dr.HasRows)
  288.         {
  289.             while (dr.Read())
  290.             {
  291.                 DataRow row = dt.NewRow();
  292.                 row["no"] = dr["area"].ToString().Trim();
  293.                 row["bxperson"] = dr["bxperson"].ToString().Trim();
  294.                 row["level"] = dr["level"].ToString().Trim();
  295.                 row["form_id"] = dr["form_id"].ToString();
  296.                 array.Add(dr["form_id"].ToString());
  297.                 row["department"] = dr["department"].ToString();
  298.                 SqlConnection conn1 = dbConnection.getConnection();
  299.                 conn1.Open();
  300.                 SqlCommand sqlcom2 = new SqlCommand("select tel from oa_department where name='" + dr["department"] + "'", conn1);
  301.                 SqlDataReader dr2 = sqlcom2.ExecuteReader();
  302.                 if (dr2.HasRows)
  303.                 {
  304.                     while (dr2.Read())
  305.                     {
  306.                         row["tel"] = dr2["tel"].ToString();
  307.                     }
  308.                 }
  309.                 dr2.Close();
  310.                 row["date"] = dr["create_time"].ToString();
  311.                 SqlCommand sqlcom1 = new SqlCommand("select emp_name from oa_employee where id='" + dr["lbperson"].ToString().Trim() + "'", conn1);
  312.                 SqlDataReader dr1 = sqlcom1.ExecuteReader();
  313.                 if (dr1.HasRows)
  314.                 {
  315.                     while (dr1.Read())
  316.                     {
  317.                         row["lbperson"] = dr1["emp_name"].ToString();
  318.                     }
  319.                 }
  320.                 dr1.Close();
  321.                 row["type"] = dr["type"].ToString();
  322.                 row["equipment"] = dr["equipment"].ToString();
  323.                 row["comment"] = dr["comment"].ToString();
  324.                 row["company"] = dr["company"].ToString();
  325.                 row["destine_time"] = dr["destine_time"].ToString();
  326.                 row["complete_time"] = dr["complete_time"].ToString();
  327.                 row["confirm"] = dr["confirm"].ToString();
  328.                 row["remark"] = dr["remark"].ToString();
  329.                 dt.Rows.Add(row);
  330.                 conn1.Close();
  331.             }
  332.         }
  333.         dr.Close();
  334.         conn.Close();
  335.         ds.Tables.Add(dt);
  336.         GridView1.DataSource = ds;
  337.         GridView1.DataKeyNames = new string[] { "form_id" };
  338.         GridView1.DataBind();
  339.         Session["s_1"] = array;
  340.     }
  341.     public void bind2()
  342.     {
  343.         MultiView2.ActiveViewIndex = 0;
  344.         User user = (User)Session["user"];
  345.         string department = user.Department.Name;
  346.         ArrayList array = new ArrayList();
  347.         MultiView2.ActiveViewIndex = 0;
  348.         SqlConnection conn = dbConnection.getConnection();
  349.         conn.Open();
  350.         DataSet ds = new DataSet();
  351.         DataTable dt = new DataTable();
  352.         dt.Columns.Add("no", typeof(string));
  353.         dt.Columns.Add("form_id", typeof(string));
  354.         dt.Columns.Add("bxperson", typeof(string));
  355.         dt.Columns.Add("level", typeof(string));
  356.         dt.Columns.Add("department", typeof(string));
  357.         dt.Columns.Add("tel", typeof(string));
  358.         dt.Columns.Add("date", typeof(string));
  359.         dt.Columns.Add("lbperson", typeof(string));
  360.         dt.Columns.Add("type", typeof(string));
  361.         dt.Columns.Add("equipment", typeof(string));
  362.         dt.Columns.Add("comment", typeof(string));
  363.         dt.Columns.Add("company", typeof(string));
  364.         dt.Columns.Add("destine_time", typeof(string));
  365.         dt.Columns.Add("complete_time", typeof(string));
  366.         dt.Columns.Add("confirm", typeof(string));
  367.         dt.Columns.Add("remark", typeof(string));
  368.         string sqlstr = "select  f.area as area,f.level as level,f.bxperson as bxperson,f.form_id as form_id,f.department as department,f.lbperson as lbperson,f.type as type,f.equipment as equipment,f.comment as comment,f.create_time as create_time,g.company as company,g.destine_time as destine_time,g.complete_time as complete_time,g.confirm as confirm,g.remark as remark from oa_repair as f,oa_repair_d as g where g.form_id=f.form_id AND g.destine_time IS NOT NULL  and f.department='" + department.Trim() + "' order by f.form_id desc";
  369.         SqlCommand sqlcom = new SqlCommand(sqlstr, conn);
  370.         SqlDataReader dr = sqlcom.ExecuteReader();
  371.         if (dr.HasRows)
  372.         {
  373.             while (dr.Read())
  374.             {
  375.                 DataRow row = dt.NewRow();
  376.                 row["no"] = dr["area"].ToString().Trim();
  377.                 row["bxperson"] = dr["bxperson"].ToString().Trim();
  378.                 row["level"] = dr["level"].ToString().Trim();
  379.                 row["form_id"] = dr["form_id"].ToString();
  380.                 array.Add(dr["form_id"].ToString());
  381.                 row["department"] = dr["department"].ToString();
  382.                 SqlConnection conn1 = dbConnection.getConnection();
  383.                 conn1.Open();
  384.                 SqlCommand sqlcom2 = new SqlCommand("select tel from oa_department where name='" + dr["department"] + "'", conn1);
  385.                 SqlDataReader dr2 = sqlcom2.ExecuteReader();
  386.                 if (dr2.HasRows)
  387.                 {
  388.                     while (dr2.Read())
  389.                     {
  390.                         row["tel"] = dr2["tel"].ToString();
  391.                     }
  392.                 }
  393.                 dr2.Close();
  394.                 row["date"] = dr["create_time"].ToString();
  395.                 SqlCommand sqlcom1 = new SqlCommand("select emp_name from oa_employee where id='" + dr["lbperson"].ToString().Trim() + "'", conn1);
  396.                 SqlDataReader dr1 = sqlcom1.ExecuteReader();
  397.                 if (dr1.HasRows)
  398.                 {
  399.                     while (dr1.Read())
  400.                     {
  401.                         row["lbperson"] = dr1["emp_name"].ToString();
  402.                     }
  403.                 }
  404.                 dr1.Close();
  405.                 row["type"] = dr["type"].ToString();
  406.                 row["equipment"] = dr["equipment"].ToString();
  407.                 row["comment"] = dr["comment"].ToString();
  408.                 row["company"] = dr["company"].ToString();
  409.                 row["destine_time"] = dr["destine_time"].ToString();
  410.                 row["complete_time"] = dr["complete_time"].ToString();
  411.                 row["confirm"] = dr["confirm"].ToString();
  412.                 row["remark"] = dr["remark"].ToString();
  413.                 dt.Rows.Add(row);
  414.                 conn1.Close();
  415.             }
  416.         }
  417.         dr.Close();
  418.         conn.Close();
  419.         ds.Tables.Add(dt);
  420.         GridView1.DataSource = ds;
  421.         GridView1.DataKeyNames = new string[] { "form_id" };
  422.         GridView1.DataBind();
  423.         Session["s_1"] = array;
  424.     }
  425.     public void bind3()
  426.     {
  427.         MultiView2.ActiveViewIndex = 0;
  428.         User user = (User)Session["user"];
  429.         string department = user.Department.Name;
  430.         ArrayList array = new ArrayList();
  431.         MultiView2.ActiveViewIndex = 0;
  432.         SqlConnection conn = dbConnection.getConnection();
  433.         conn.Open();
  434.         DataSet ds = new DataSet();
  435.         DataTable dt = new DataTable();
  436.         dt.Columns.Add("no", typeof(string));
  437.         dt.Columns.Add("form_id", typeof(string));
  438.         dt.Columns.Add("bxperson", typeof(string));
  439.         dt.Columns.Add("level", typeof(string));
  440.         dt.Columns.Add("department", typeof(string));
  441.         dt.Columns.Add("tel", typeof(string));
  442.         dt.Columns.Add("date", typeof(string));
  443.         dt.Columns.Add("lbperson", typeof(string));
  444.         dt.Columns.Add("type", typeof(string));
  445.         dt.Columns.Add("equipment", typeof(string));
  446.         dt.Columns.Add("comment", typeof(string));
  447.         dt.Columns.Add("company", typeof(string));
  448.         dt.Columns.Add("destine_time", typeof(string));
  449.         dt.Columns.Add("complete_time", typeof(string));
  450.         dt.Columns.Add("confirm", typeof(string));
  451.         dt.Columns.Add("remark", typeof(string));
  452.         string sqlstr = "select  f.area as area,f.level as level,f.bxperson as bxperson,f.form_id as form_id,f.department as department,f.lbperson as lbperson,f.type as type,f.equipment as equipment,f.comment as comment,f.create_time as create_time,g.company as company,g.destine_time as destine_time,g.complete_time as complete_time,g.confirm as confirm,g.remark as remark from oa_repair as f,oa_repair_d as g where g.form_id=f.form_id  AND g.complete_time IS not NULL AND g.destine_time IS NOT NULL  and f.department='" + department.Trim() + "'  order by f.form_id desc";
  453.         SqlCommand sqlcom = new SqlCommand(sqlstr, conn);
  454.         SqlDataReader dr = sqlcom.ExecuteReader();
  455.         if (dr.HasRows)
  456.         {
  457.             while (dr.Read())
  458.             {
  459.                 DataRow row = dt.NewRow();
  460.                 row["no"] = dr["area"].ToString().Trim();
  461.                 row["bxperson"] = dr["bxperson"].ToString().Trim();
  462.                 row["level"] = dr["level"].ToString().Trim();
  463.                 row["form_id"] = dr["form_id"].ToString();
  464.                 array.Add(dr["form_id"].ToString());
  465.                 row["department"] = dr["department"].ToString();
  466.                 SqlConnection conn1 = dbConnection.getConnection();
  467.                 conn1.Open();
  468.                 SqlCommand sqlcom2 = new SqlCommand("select tel from oa_department where name='" + dr["department"] + "'", conn1);
  469.                 SqlDataReader dr2 = sqlcom2.ExecuteReader();
  470.                 if (dr2.HasRows)
  471.                 {
  472.                     while (dr2.Read())
  473.                     {
  474.                         row["tel"] = dr2["tel"].ToString();
  475.                     }
  476.                 }
  477.                 dr2.Close();
  478.                 row["date"] = dr["create_time"].ToString();
  479.                 SqlCommand sqlcom1 = new SqlCommand("select emp_name from oa_employee where id='" + dr["lbperson"].ToString().Trim() + "'", conn1);
  480.                 SqlDataReader dr1 = sqlcom1.ExecuteReader();
  481.                 if (dr1.HasRows)
  482.                 {
  483.                     while (dr1.Read())
  484.                     {
  485.                         row["lbperson"] = dr1["emp_name"].ToString();
  486.                     }
  487.                 }
  488.                 dr1.Close();
  489.                 row["type"] = dr["type"].ToString();
  490.                 row["equipment"] = dr["equipment"].ToString();
  491.                 row["comment"] = dr["comment"].ToString();
  492.                 row["company"] = dr["company"].ToString();
  493.                 row["destine_time"] = dr["destine_time"].ToString();
  494.                 row["complete_time"] = dr["complete_time"].ToString();
  495.                 row["confirm"] = dr["confirm"].ToString();
  496.                 row["remark"] = dr["remark"].ToString();
  497.                 dt.Rows.Add(row);
  498.                 conn1.Close();
  499.             }
  500.         }
  501.         dr.Close();
  502.         conn.Close();
  503.         ds.Tables.Add(dt);
  504.         GridView1.DataSource = ds;
  505.         GridView1.DataKeyNames = new string[] { "form_id" };
  506.         GridView1.DataBind();
  507.         Session["s_1"] = array;
  508.     }
  509.     public void bind4()
  510.     {
  511.         MultiView2.ActiveViewIndex = 0;
  512.         User user = (User)Session["user"];
  513.         string department = user.Department.Name;
  514.         ArrayList array = new ArrayList();
  515.         MultiView2.ActiveViewIndex = 0;
  516.         SqlConnection conn = dbConnection.getConnection();
  517.         conn.Open();
  518.         DataSet ds = new DataSet();
  519.         DataTable dt = new DataTable();
  520.         dt.Columns.Add("no", typeof(string));
  521.         dt.Columns.Add("form_id", typeof(string));
  522.         dt.Columns.Add("bxperson", typeof(string));
  523.         dt.Columns.Add("level", typeof(string));
  524.         dt.Columns.Add("department", typeof(string));
  525.         dt.Columns.Add("tel", typeof(string));
  526.         dt.Columns.Add("date", typeof(string));
  527.         dt.Columns.Add("lbperson", typeof(string));
  528.         dt.Columns.Add("type", typeof(string));
  529.         dt.Columns.Add("equipment", typeof(string));
  530.         dt.Columns.Add("comment", typeof(string));
  531.         dt.Columns.Add("company", typeof(string));
  532.         dt.Columns.Add("destine_time", typeof(string));
  533.         dt.Columns.Add("complete_time", typeof(string));
  534.         dt.Columns.Add("confirm", typeof(string));
  535.         dt.Columns.Add("remark", typeof(string));
  536.         string sqlstr = "select  f.area as area,f.level as level,f.bxperson as bxperson,f.form_id as form_id,f.department as department,f.lbperson as lbperson,f.type as type,f.equipment as equipment,f.comment as comment,f.create_time as create_time,g.company as company,g.destine_time as destine_time,g.complete_time as complete_time,g.confirm as confirm,g.remark as remark from oa_repair as f,oa_repair_d as g where g.form_id=f.form_id AND g.complete_time IS NULL AND g.destine_time IS NOT NULL  and f.department='" + department.Trim() + "' order by f.form_id desc";
  537.         SqlCommand sqlcom = new SqlCommand(sqlstr, conn);
  538.         SqlDataReader dr = sqlcom.ExecuteReader();
  539.         if (dr.HasRows)
  540.         {
  541.             while (dr.Read())
  542.             {
  543.                 DataRow row = dt.NewRow();
  544.                 row["no"] = dr["area"].ToString().Trim();
  545.                 row["bxperson"] = dr["bxperson"].ToString().Trim();
  546.                 row["level"] = dr["level"].ToString().Trim();
  547.                 row["form_id"] = dr["form_id"].ToString();
  548.                 array.Add(dr["form_id"].ToString());
  549.                 row["department"] = dr["department"].ToString();
  550.                 SqlConnection conn1 = dbConnection.getConnection();
  551.                 conn1.Open();
  552.                 SqlCommand sqlcom2 = new SqlCommand("select tel from oa_department where name='" + dr["department"] + "'", conn1);
  553.                 SqlDataReader dr2 = sqlcom2.ExecuteReader();
  554.                 if (dr2.HasRows)
  555.                 {
  556.                     while (dr2.Read())
  557.                     {
  558.                         row["tel"] = dr2["tel"].ToString();
  559.                     }
  560.                 }
  561.                 dr2.Close();
  562.                 row["date"] = dr["create_time"].ToString();
  563.                 SqlCommand sqlcom1 = new SqlCommand("select emp_name from oa_employee where id='" + dr["lbperson"].ToString().Trim() + "'", conn1);
  564.                 SqlDataReader dr1 = sqlcom1.ExecuteReader();
  565.                 if (dr1.HasRows)
  566.                 {
  567.                     while (dr1.Read())
  568.                     {
  569.                         row["lbperson"] = dr1["emp_name"].ToString();
  570.                     }
  571.                 }
  572.                 dr1.Close();
  573.                 row["type"] = dr["type"].ToString();
  574.                 row["equipment"] = dr["equipment"].ToString();
  575.                 row["comment"] = dr["comment"].ToString();
  576.                 row["company"] = dr["company"].ToString();
  577.                 row["destine_time"] = dr["destine_time"].ToString();
  578.                 row["complete_time"] = dr["complete_time"].ToString();
  579.                 row["confirm"] = dr["confirm"].ToString();
  580.                 row["remark"] = dr["remark"].ToString();
  581.                 dt.Rows.Add(row);
  582.                 conn1.Close();
  583.             }
  584.         }
  585.         dr.Close();
  586.         conn.Close();
  587.         ds.Tables.Add(dt);
  588.         GridView1.DataSource = ds;
  589.         GridView1.DataKeyNames = new string[] { "form_id" };
  590.         GridView1.DataBind();
  591.         Session["s_1"] = array;
  592.     }
  593.     protected void Button1_Click(object sender, EventArgs e)
  594.     {
  595.         bind1();
  596.         MultiView1.ActiveViewIndex = -1;
  597.         MultiView1.ActiveViewIndex = -1;
  598.     }
  599.     protected void LinkButton1_Click(object sender, EventArgs e)
  600.     {
  601.         flag = 0;
  602.         GridView1.DataBind();
  603.         MultiView2.ActiveViewIndex = -1;
  604.         MultiView1.ActiveViewIndex = -1;
  605.         bind2();
  606.     }
  607.     protected void LinkButton2_Click(object sender, EventArgs e)
  608.     {
  609.         flag = 1;
  610.         GridView1.DataBind();
  611.         MultiView2.ActiveViewIndex = -1;
  612.         MultiView1.ActiveViewIndex = -1;
  613.         bind3();
  614.     }
  615.     protected void LinkButton3_Click(object sender, EventArgs e)
  616.     {
  617.         flag = 2;
  618.         GridView1.DataBind();
  619.         MultiView2.ActiveViewIndex = -1;
  620.         MultiView1.ActiveViewIndex = -1;
  621.         bind4();
  622.     }
  623.     protected void LinkButton4_Click(object sender, EventArgs e)
  624.     {
  625.         flag = 3;
  626.         MultiView1.ActiveViewIndex = 0;
  627.         MultiView2.ActiveViewIndex = -1;
  628.     }
  629. }