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

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

OA系统

开发平台：

ASP/ASPX

show.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;
  12. using Microsoft.Reporting.WebForms;
  13. using System.Reflection;
  14. using System.Runtime.InteropServices;
  15. using DataTable = System.Data.DataTable;
  17. public partial class web_show : System.Web.UI.Page
  18. {
  19.     int no = 0;
  20.     ArrayList array1 = new ArrayList();
  21.     ArrayList array2 = new ArrayList();
  22.     ArrayList array3 = new ArrayList();
  23.     ArrayList array_1 = new ArrayList();
  24.     DataTable dt = new DataTable("dataname");
  25.     protected void Page_Load(object sender, EventArgs e)
  26.     {
  27.         dt.Columns.Add(new DataColumn("所屬部門", typeof(string)));
  28.         dt.Columns.Add(new DataColumn("姓名", typeof(string)));
  29.         dt.Columns.Add(new DataColumn("員工編號", typeof(string)));
  30.         dt.Columns.Add(new DataColumn("日期", typeof(string)));
  31.         dt.Columns.Add(new DataColumn("星期", typeof(string)));
  32.         dt.Columns.Add(new DataColumn("早上上班", typeof(string)));
  33.         dt.Columns.Add(new DataColumn("中午下班", typeof(string)));
  34.         dt.Columns.Add(new DataColumn("下午上班", typeof(string)));
  35.         dt.Columns.Add(new DataColumn("下午下班", typeof(string)));
  36.         dt.Columns.Add(new DataColumn("簽到時數", typeof(string)));
  37.         ReportViewer1.Visible = false;
  38.         DropDownList1.Visible = true;
  39.     }
  40.     public void getid()
  41.     {
  42.         int flag = 0;
  43.         int emp_where = 0;
  44.         string str = "";
  45.         string user_id = "";
  46.         DropDownList1.Items.Clear();
  47.         DropDownList1.Items.Add("所有部門");
  48.         if (Session["user_id"] != null)
  49.         {
  50.             user_id = Session["user_id"].ToString();
  51.         }
  53.         ReportViewer1.Visible = false;
  54.         SqlConnection conn = dbConnection.getConnection();
  55.         conn.Open();
  56.         SqlCommand sqlcom1 = new SqlCommand("select emp_where from OA_EMPLOYEE where id='" + user_id + "'", conn);
  57.         emp_where = Convert.ToInt32(sqlcom1.ExecuteScalar());
  58.         if (emp_where == 1)
  59.         {
  60.             str = "中山隆成啟航商貿有限公司";
  61.         }
  62.         else if (emp_where == 2)
  63.         {
  64.             str = "中山捷盟貿易有限公司";
  65.         }
  66.         else
  67.         {
  68.         }
  69.         SqlCommand comm1 = new SqlCommand("select id from OA_DEPARTMENT where name='" + str + "'", conn);
  70.         no = Convert.ToInt32(comm1.ExecuteScalar());
  71.         SqlCommand sqlcom2 = new SqlCommand("select id,name from OA_DEPARTMENT where last_id='" + no + "'and out='0'", conn);
  72.         SqlDataReader comm2 = sqlcom2.ExecuteReader();
  73.         while (comm2.Read())
  74.         {
  75.             array1.Add(Convert.ToInt32(comm2["id"]));
  76.             for (int i = 0; i < DropDownList1.Items.Count; i++)
  77.             {
  78.                 if (Convert.ToString(comm2["name"]).Equals(DropDownList1.Items[i]))
  79.                 {
  80.                     flag = flag + 1;
  81.                 }
  82.             }
  83.             if (flag == 0)
  84.             {
  85.                 DropDownList1.Items.Add(Convert.ToString(comm2["name"]));
  86.             }
  87.         }
  88.         comm2.Close();
  89.         foreach (int i in array1)
  90.         {
  91.             ArrayList array5 = new ArrayList();
  92.             array5.Add(i);
  93.             SqlCommand sqlcom3 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + i + "'", conn);
  94.             SqlDataReader comm3 = sqlcom3.ExecuteReader();
  95.             if (comm3.HasRows)
  96.             {
  97.                 while (comm3.Read())
  98.                 {
  99.                     array5.Add(Convert.ToInt32(comm3["id"]));
  100.                     SqlConnection conn1 = dbConnection.getConnection();
  101.                     conn1.Open();
  102.                     SqlCommand sqlcom4 = new SqlCommand("select id ,name from OA_DEPARTMENT where last_id='" + Convert.ToInt32(comm3["id"]) + "'", conn1);
  103.                     SqlDataReader comm4 = sqlcom4.ExecuteReader();
  104.                     if (comm4.HasRows)
  105.                     {
  106.                         while (comm4.Read())
  107.                         {
  108.                             array5.Add(Convert.ToInt32(comm4["id"]));
  109.                         }
  110.                     }
  111.                     comm4.Close();
  112.                     conn1.Close();
  113.                 }
  114.             }
  115.             comm3.Close();
  116.             array2.Add(array5);
  117.         }
  118.         conn.Close();
  119.     }
  120.     public void getnum()
  121.     {
  122.         int k = 0;
  123.         string name = "";
  124.         string emp_name = "";
  125.         string nul = " ";
  126.         string department = "";
  127.         double sum = 0;
  128.         string time1 = "";
  129.         string time2 = "";
  130.         string time3 = "";
  131.         string time4 = "";
  132.         DataRow row = dt.NewRow();
  133.         SqlConnection conn1 = dbConnection.getConnection();
  134.         conn1.Open();
  135.         foreach (ArrayList i in array2)
  136.         {
  137.             ArrayList array6 = new ArrayList();
  138.             foreach (int j in i)
  139.             {
  140.                 SqlCommand sqlcom1 = new SqlCommand("select emp_no from OA_EMPLOYEE where department_id='" + j + "'and dimission_date=''", conn1);
  141.                 SqlDataReader comm1 = sqlcom1.ExecuteReader();
  142.                 if (comm1.HasRows)
  143.                 {
  144.                     while (comm1.Read())
  145.                     {
  146.                         array6.Add(Convert.ToString(comm1["emp_no"]));
  147.                     }
  148.                 }
  149.                 comm1.Close();
  150.             }
  151.             array3.Add(array6);
  152.         }
  153.         foreach (ArrayList i in array3)
  154.         {
  155.             if (k < array1.Count)
  156.             {
  157.                 foreach (string j in i)
  158.                 {
  159.                     SqlConnection conn2 = dbConnection.getConnection();
  160.                     conn2.Open();
  161.                     SqlCommand sqlcom2 = new SqlCommand("select name from OA_DEPARTMENT where id='" + array1[k] + "'", conn2);
  162.                     name = Convert.ToString(sqlcom2.ExecuteScalar());
  163.                     SqlCommand sqlcom4 = new SqlCommand("select f.name as name from OA_DEPARTMENT as f , OA_EMPLOYEE as g where f.id=g.department_id and g.emp_no='" + j + "'", conn2);
  164.                     department = Convert.ToString(sqlcom4.ExecuteScalar());
  165.                     SqlCommand sqlcom3 = new SqlCommand("select emp_name from OA_EMPLOYEE where emp_no='" + j + "'", conn2);
  166.                     emp_name = Convert.ToString(sqlcom3.ExecuteScalar());
  167.                     SqlCommand sqlcom5 = new SqlCommand("select distinct data from OA_KAOQIN_JL where data between'" + TextBox1.Text + "'and'" + TextBox2.Text + "'order by data", conn2);
  168.                     SqlDataReader comm5 = sqlcom5.ExecuteReader();
  169.                     while (comm5.Read())
  170.                     {
  171.                         row = dt.NewRow();
  172.                         row["所屬部門"] = name;
  173.                         row["姓名"] = emp_name;
  174.                         row["員工編號"] = j;
  175.                         row["日期"] = Convert.ToString(comm5["data"]);
  176.                         row["星期"] = getweekday(Convert.ToDateTime(comm5["data"]));
  177.                         SqlConnection conn5 = dbConnection.getConnection();
  178.                         conn5.Open();
  179.                         SqlCommand sqlcom8 = new SqlCommand("select f.zao as zao,f.wan as wan,f.wuxia as wuxia,f.wushang as wushang from OA_KAOQIN_JL as f,OA_EMPLOYEE as g where f.card_id=g.work_card_no1 and g.emp_no='" + j + "'and data='" + Convert.ToString(comm5["data"]) + "'", conn5);
  180.                         SqlDataReader comm8 = sqlcom8.ExecuteReader();
  181.                         if (comm8.HasRows)
  182.                         {
  183.                             while (comm8.Read())
  184.                             {
  185.                                 time1 = Convert.ToString(comm8["zao"]);
  186.                                 time2 = Convert.ToString(comm8["wan"]);
  187.                                 time3 = Convert.ToString(comm8["wuxia"]);
  188.                                 time4 = Convert.ToString(comm8["wushang"]);
  189.                                 if (time1.Equals(""))
  190.                                 {
  191.                                     row["早上上班"] = nul;
  192.                                 }
  193.                                 else
  194.                                 {
  195.                                     row["早上上班"] = time1;
  196.                                 }
  197.                                 if (time3.Equals(""))
  198.                                 {
  199.                                     row["中午下班"] = nul; 
  200.                                 }
  201.                                 else
  202.                                 {
  203.                                     row["中午下班"] = time3;
  204.                                 }
  205.                                 if (time4.Equals(""))
  206.                                 {
  207.                                     row["下午上班"] = nul;
  208.                                 }
  209.                                 else
  210.                                 {
  211.                                     row["下午上班"] = time4; 
  212.                                 }
  213.                                 if (time2.Equals(""))
  214.                                 {
  215.                                     row["下午下班"] = nul;
  216.                                 }
  217.                                 else
  218.                                 {
  219.                                     row["下午下班"] = time2; 
  220.                                 }
  221.                                 if (time1.Length == 5)
  222.                                 {
  223.                                     time1 = "0" + time1;
  224.                                 }
  225.                                 if (time2.Length == 5)
  226.                                 {
  227.                                     time2 = "0" + time2;
  228.                                 }
  229.                                 if (!(time1.Equals("")) && (!time2.Equals("")))
  230.                                 {
  231.                                     sum = (double)(Convert.ToInt32(time2.Substring(0, 2)) - Convert.ToInt32(time1.Substring(0, 2)) - 1.5 + (double)(Convert.ToInt32(time2.Substring(2, 2)) - Convert.ToInt32(time1.Substring(2, 2))) / 60);
  232.                                     sum = Round(sum, 2);
  233.                                     row["簽到時數"] = Convert.ToString(sum);
  234.                                 }
  235.                                 else
  236.                                 {
  237.                                     row["簽到時數"] = nul;
  238.                                 }
  239.                             }
  240.                         }
  241.                         else
  242.                         {
  243.                             row["早上上班"] = nul;
  244.                             row["中午下班"] = nul;
  245.                             row["下午上班"] = nul;
  246.                             row["下午下班"] = nul;
  247.                             row["簽到時數"] = nul;
  248.                         }
  249.                         comm8.Close();
  250.                         conn5.Close();
  251.                         dt.Rows.Add(row);
  252.                     }
  253.                     comm5.Close();
  254.                     conn2.Close();
  255.                 }
  256.                 k++;
  257.             }
  258.         }
  259.         conn1.Close();
  260.     }
  261.     public void getnum1()
  262.     {
  263.         int id = 0;
  264.         string name="";
  265.         string department = "";
  266.         string emp_name = "";
  267.         double sum = 0;
  268.         string time1 = "";
  269.         string time2 = "";
  270.         string time3 = "";
  271.         string time4 = "";
  272.         string nul = "";
  273.         int emp_where = 0;
  274.         string str = "";
  275.         string user_id = "";
  276.         int last_id = 0;
  277.         if (Session["user_id"] != null)
  278.         {
  279.             user_id = Session["user_id"].ToString();
  280.         }
  281.         DataRow row = dt.NewRow();
  282.         name = DropDownList1.Text;
  283.         SqlConnection conn1 = dbConnection.getConnection();
  284.         conn1.Open();
  285.         SqlCommand sqlcom8 = new SqlCommand("select emp_where from OA_EMPLOYEE where id='" + user_id + "'", conn1);
  286.         emp_where = Convert.ToInt32(sqlcom8.ExecuteScalar());
  287.         if (emp_where == 1)
  288.         {
  289.             str = "中山隆成啟航商貿有限公司";
  290.         }
  291.         else if (emp_where == 2)
  292.         {
  293.             str = "中山捷盟貿易有限公司";
  294.         }
  295.         else
  296.         {
  297.         }
  298.         SqlCommand comm1 = new SqlCommand("select id from OA_DEPARTMENT where name='" + str + "'", conn1);
  299.         last_id = Convert.ToInt32(comm1.ExecuteScalar());
  300.         SqlCommand sqlcom1 = new SqlCommand("select id from OA_DEPARTMENT where name='" + DropDownList1.Text + "'and last_id='" + last_id + "'and out='0'", conn1);
  301.         id = Convert.ToInt32(sqlcom1.ExecuteScalar());
  302.         array_1.Add(id);
  303.         SqlCommand sqlcom2 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + id + "'and out='0'", conn1);
  304.         SqlDataReader comm2 = sqlcom2.ExecuteReader();
  305.         if (comm2.HasRows)
  306.         {
  307.             while (comm2.Read())
  308.             {
  309.                 array_1.Add(Convert.ToInt32(comm2["id"]));
  310.                 SqlConnection conn2 = dbConnection.getConnection();
  311.                 conn2.Open();
  312.                 SqlCommand sqlcom3 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + Convert.ToInt32(comm2["id"]) + "'", conn2);
  313.                 SqlDataReader comm3 = sqlcom3.ExecuteReader();
  314.                 if (comm3.HasRows)
  315.                 {
  316.                     while (comm3.Read())
  317.                     {
  318.                         array_1.Add(Convert.ToInt32(comm3["id"]));
  319.                     }
  320.                 }
  321.                 comm3.Close();
  322.                 conn2.Close();
  323.             }
  324.         }
  325.         comm2.Close();
  326.         conn1.Close();
  327.         ArrayList array6 = new ArrayList();
  328.         SqlConnection conn3 = dbConnection.getConnection();
  329.         conn3.Open();
  330.         foreach (int i in array_1)
  331.         {
  332.             SqlCommand sqlcom4 = new SqlCommand("select emp_no from OA_EMPLOYEE where department_id='" + i + "'and dimission_date=''", conn3);
  333.             SqlDataReader comm4 = sqlcom4.ExecuteReader();
  334.             if (comm4.HasRows)
  335.             {
  336.                 while (comm4.Read())
  337.                 {
  338.                     array6.Add(Convert.ToString(comm4["emp_no"]));
  339.                 }
  340.             }
  341.             comm4.Close();
  342.         }
  343.         foreach (string i in array6)
  344.         {
  345.             SqlCommand sqlcom5 = new SqlCommand("select emp_name from OA_EMPLOYEE where emp_no='" + i + "'", conn3);
  346.             emp_name = Convert.ToString(sqlcom5.ExecuteScalar());
  347.             SqlCommand sqlcom6 = new SqlCommand("select distinct data from OA_KAOQIN_JL where data between'" + TextBox1.Text + "'and'" + TextBox2.Text + "'order by data", conn3);
  348.             SqlDataReader comm6 = sqlcom6.ExecuteReader();
  349.             while (comm6.Read())
  350.             {
  351.                 row = dt.NewRow();
  352.                 row["所屬部門"] = name;
  353.                 row["姓名"] = emp_name;
  354.                 row["員工編號"] = i;
  355.                 row["日期"] = Convert.ToString(comm6["data"]);
  356.                 row["星期"] = getweekday(Convert.ToDateTime(comm6["data"]));
  357.                 SqlConnection conn4 = dbConnection.getConnection();
  358.                 conn4.Open();
  359.                 SqlCommand sqlcom7 = new SqlCommand("select f.zao as zao,f.wan as wan,f.wuxia as wuxia,f.wushang as wushang from OA_KAOQIN_JL as f,OA_EMPLOYEE as g where f.card_id=g.work_card_no1 and g.emp_no='" + i + "'and data='" + Convert.ToString(comm6["data"]) + "'", conn4);
  360.                 SqlDataReader comm7 = sqlcom7.ExecuteReader();
  361.                 if (comm7.HasRows)
  362.                 {
  363.                     while (comm7.Read())
  364.                     {
  365.                         time1 = Convert.ToString(comm7["zao"]);
  366.                         time2 = Convert.ToString(comm7["wan"]);
  367.                         time3 = Convert.ToString(comm7["wuxia"]);
  368.                         time4 = Convert.ToString(comm7["wushang"]);
  369.                         if (time1.Equals(""))
  370.                         {
  371.                             row["早上上班"] = nul;
  372.                         }
  373.                         else
  374.                         {
  375.                             row["早上上班"] = time1;
  376.                         }
  377.                         if (time3.Equals(""))
  378.                         {
  379.                             row["中午下班"] = nul;
  380.                         }
  381.                         else
  382.                         {
  383.                             row["中午下班"] = time3;
  384.                         }
  385.                         if (time4.Equals(""))
  386.                         {
  387.                             row["下午上班"] = nul;
  388.                         }
  389.                         else
  390.                         {
  391.                             row["下午上班"] = time4;
  392.                         }
  393.                         if (time2.Equals(""))
  394.                         {
  395.                             row["下午下班"] = nul;
  396.                         }
  397.                         else
  398.                         {
  399.                             row["下午下班"] = time2;
  400.                         }
  401.                         if (time1.Length == 5)
  402.                         {
  403.                             time1 = "0" + time1;
  404.                         }
  405.                         if (time2.Length == 5)
  406.                         {
  407.                             time2 = "0" + time2;
  408.                         }
  409.                         if (!(time1.Equals("")) && (!time2.Equals("")))
  410.                         {
  411.                             sum = (double)(Convert.ToInt32(time2.Substring(0, 2)) - Convert.ToInt32(time1.Substring(0, 2)) - 1.5 + (double)(Convert.ToInt32(time2.Substring(2, 2)) - Convert.ToInt32(time1.Substring(2, 2))) / 60);
  412.                             sum = Round(sum, 2);
  413.                             row["簽到時數"] = Convert.ToString(sum);
  414.                         }
  415.                         else
  416.                         {
  417.                             row["簽到時數"] = nul;
  418.                         }
  419.                     }
  420.                 }
  421.                 else
  422.                 {
  423.                     row["早上上班"] = nul;
  424.                     row["中午下班"] = nul;
  425.                     row["下午上班"] = nul;
  426.                     row["下午下班"] = nul;
  427.                     row["簽到時數"] = nul;
  428.                 }
  429.                 comm7.Close();
  430.                 conn4.Close();
  431.                 dt.Rows.Add(row);
  432.             }
  433.             comm6.Close();
  434.         }
  435.         conn3.Close();
  436.     }
  437.     public double Round(double v, int x)
  438.     {
  439.         bool flat = false;
  440.         if (v < 0)
  441.         {
  442.             flat = true;
  443.             v = -v;
  444.         }
  445.         int ivalue = 1;
  446.         for (int i = 1; i <= x; i++)
  447.         {
  448.             ivalue = 10 * ivalue;
  449.         }
  450.         double num = Math.Round(v * ivalue + 0.5, 0);
  451.         v = num / ivalue;
  452.         if (flat)
  453.         {
  454.             v = -v;
  455.         }
  456.         return v;
  457.     }
  458.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  459.     {
  460.         if (Calendar1.Visible == true)
  461.         {
  462.             Calendar1.Visible = false;
  463.             Calendar1.Focus();
  464.         }
  465.         else
  466.         {
  467.             Calendar1.Visible = true;
  468.             Calendar1.Focus();
  469.         }
  470.         getid();
  471.     }
  472.     protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
  473.     {
  474.         if (Calendar2.Visible == true)
  475.         {
  476.             Calendar2.Visible = false;
  477.             Calendar2.Focus();
  478.         }
  479.         else
  480.         {
  481.             Calendar2.Visible = true;
  482.             Calendar2.Focus();
  483.         }
  484.         getid();
  485.     }
  486.     protected void Calendar1_SelectionChanged(object sender, EventArgs e)
  487.     {
  488.         Calendar1.Visible = false;
  489.         string year = Calendar1.SelectedDate.Year.ToString();
  490.         string month = Calendar1.SelectedDate.Month.ToString();
  491.         if (month.Length == 1)
  492.         {
  493.             month = "0" + month;
  494.         }
  495.         string day = Calendar1.SelectedDate.Day.ToString();
  496.         if (day.Length == 1)
  497.         {
  498.             day = "0" + day;
  499.         }
  500.         TextBox1.Text = year + "-" + month + "-" + day;
  501.         TextBox1.Focus();
  502.     }
  503.     protected void Calendar2_SelectionChanged(object sender, EventArgs e)
  504.     {
  505.         Calendar2.Visible = false;
  506.         string year = Calendar2.SelectedDate.Year.ToString();
  507.         string month = Calendar2.SelectedDate.Month.ToString();
  508.         if (month.Length == 1)
  509.         {
  510.             month = "0" + month;
  511.         }
  512.         string day = Calendar2.SelectedDate.Day.ToString();
  513.         if (day.Length == 1)
  514.         {
  515.             day = "0" + day;
  516.         }
  517.         TextBox2.Text = year + "-" + month + "-" + day;
  518.         TextBox2.Focus();
  520.     }
  521.     public string getweekday(DateTime data)
  522.     {
  523.         string str = null;
  524.         switch (data.DayOfWeek.ToString())
  525.         {
  526.             case "Monday":
  527.                 str = "星期一";
  528.                 break;
  529.             case "Tuesday":
  530.                 str = "星期二";
  531.                 break;
  532.             case "Wednesday":
  533.                 str = "星期三";
  534.                 break;
  535.             case "Thursday":
  536.                 str = "星期四";
  537.                 break;
  538.             case "Friday":
  539.                 str = "星期五";
  540.                 break;
  541.             case "Saturday":
  542.                 str = "星期六";
  543.                 break;
  544.             case "Sunday":
  545.                 str = "星期日";
  546.                 break;
  547.         }
  548.         return str;
  549.     }
  550.     protected void Button1_Click(object sender, EventArgs e)
  551.     {
  552.         if (DropDownList1.Text.Equals("所有部門"))
  553.         {
  554.             getid();
  555.             getnum();
  556.         }
  557.         else
  558.         {
  559.             array_1 = new ArrayList();
  560.             getnum1();
  561.         }
  563.         ReportDataSource rds = new ReportDataSource("DataSet1_DataTable1", dt);
  564.         ReportViewer1.LocalReport.DataSources.Clear();
  565.         ReportViewer1.LocalReport.DataSources.Add(rds);
  566.         ReportViewer1.LocalReport.Refresh();
  567.         ReportViewer1.Visible = true;
  568.     }
  569.     protected void TextBox1_TextChanged(object sender, EventArgs e)
  570.     {
  572.     }
  573.     protected void TextBox2_TextChanged(object sender, EventArgs e)
  574.     {
  576.     }
  577. }