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

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

OA系统

开发平台：

ASP/ASPX

show_work.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_pos_c_show_work : 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.     protected void Page_Load(object sender, EventArgs e)
  25.     {
  26.         ReportViewer1.Visible = false;
  27.         SqlConnection conn = dbConnection.getConnection();
  28.         conn.Open();
  29.         SqlCommand comm1 = new SqlCommand("select id from OA_DEPARTMENT where name='中山隆成啟航商貿有限公司'", conn);
  30.         no = Convert.ToInt32(comm1.ExecuteScalar());
  31.         SqlCommand sqlcom2 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + no + "'", conn);
  32.         SqlDataReader comm2 = sqlcom2.ExecuteReader();
  33.         while (comm2.Read())
  34.         {
  35.             array1.Add(Convert.ToInt32(comm2["id"]));
  36.         }
  37.         comm2.Close();
  38.         foreach (int i in array1)
  39.         {
  40.             ArrayList array5 = new ArrayList();
  41.             array5.Add(i);
  42.             SqlCommand sqlcom3 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + i + "'and id!='144'and id!='145'and id!='146'and id!='147'and id!='194'and id!='197'", conn);
  43.             SqlDataReader comm3 = sqlcom3.ExecuteReader();
  44.             if (comm3.HasRows)
  45.             {
  46.                 while (comm3.Read())
  47.                 {
  48.                     array5.Add(Convert.ToInt32(comm3["id"]));
  49.                     SqlConnection conn1 = dbConnection.getConnection();
  50.                     conn1.Open();
  51.                     SqlCommand sqlcom4 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + Convert.ToInt32(comm3["id"]) + "'", conn1);
  52.                     SqlDataReader comm4 = sqlcom4.ExecuteReader();
  53.                     if (comm4.HasRows)
  54.                     {
  55.                         while (comm4.Read())
  56.                         {
  57.                             array5.Add(Convert.ToInt32(comm4["id"]));
  58.                         }
  59.                     }
  60.                     comm4.Close();
  61.                     conn1.Close();
  62.                 }
  63.             }
  64.             comm3.Close();
  65.             array2.Add(array5);
  66.         }
  67.         conn.Close();
  68.     }
  69.     public void getnum()
  70.     {
  71.        int k=0;
  72.        string name = "";
  73.        string emp_name = "";
  74.         string nul=" ";
  75.         string department="";
  76.         double sum=0;
  77.         string time1="";
  78.         string time2="";
  79.         string time3 = "";
  80.         string time4 = "";
  81.         ArrayList array_2 = new ArrayList();
  82.         SqlConnection conn1 = dbConnection.getConnection();
  83.         conn1.Open();
  84.         foreach (ArrayList i in array2)
  85.         {
  86.             ArrayList array6 = new ArrayList();
  87.             foreach (int j in i)
  88.             {
  89.                 SqlCommand sqlcom1 = new SqlCommand("select emp_no from OA_EMPLOYEE where department_id='" + j + "'", conn1);
  90.                 SqlDataReader comm1 = sqlcom1.ExecuteReader();
  91.                 if (comm1.HasRows)
  92.                 {
  93.                     while (comm1.Read())
  94.                     {
  95.                         array6.Add(Convert.ToString(comm1["emp_no"]));
  96.                     }
  97.                 }
  98.                 comm1.Close();
  99.             }
  100.             array3.Add(array6);
  101.         }
  102.         foreach (ArrayList i in array3)
  103.         {
  104.             if (k < array1.Count)
  105.             {
  106.                 foreach (string j in i)
  107.                 {
  108.                     SqlConnection conn2 = dbConnection.getConnection();
  109.                     conn2.Open();
  110.                     SqlCommand sqlcom2 = new SqlCommand("select name from OA_DEPARTMENT where id='" + array1[k] + "'", conn2);
  111.                     name = Convert.ToString(sqlcom2.ExecuteScalar());
  112.                     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);
  113.                     department = Convert.ToString(sqlcom4.ExecuteScalar());
  114.                     SqlCommand sqlcom3 = new SqlCommand("select emp_name from OA_EMPLOYEE where emp_no='" + j + "'", conn2);
  115.                     emp_name = Convert.ToString(sqlcom3.ExecuteScalar());
  116.                     SqlCommand sqlcom5 = new SqlCommand("select distinct data from OA_KAOQIN_JL where data between'" + TextBox1.Text + "'and'" + TextBox2.Text + "'order by data", conn2);
  117.                     SqlDataReader comm5 = sqlcom5.ExecuteReader();
  118.                     while (comm5.Read())
  119.                     {
  120.                         array_2.Add(name);
  121.                         array_2.Add(emp_name);
  122.                         array_2.Add(j);
  123.                         array_2.Add(Convert.ToString(comm5["data"]));
  124.                         array_2.Add(getweekday(Convert.ToDateTime(comm5["data"])));
  125.                         SqlConnection conn5 = dbConnection.getConnection();
  126.                         conn5.Open();
  127.                         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);
  128.                         SqlDataReader comm8 = sqlcom8.ExecuteReader();
  129.                         if (comm8.HasRows)
  130.                         {
  131.                             while (comm8.Read())
  132.                             {
  133.                                 time1 = Convert.ToString(comm8["zao"]);
  134.                                 time2 = Convert.ToString(comm8["wan"]);
  135.                                 time3 = Convert.ToString(comm8["wuxia"]);
  136.                                 time4 = Convert.ToString(comm8["wushang"]);
  137.                                 if (time1.Equals(""))
  138.                                 {
  139.                                     array_2.Add(nul);
  140.                                 }
  141.                                 else
  142.                                 {
  143.                                     array_2.Add(time1);
  144.                                 }
  145.                                 if (time3.Equals(""))
  146.                                 {
  147.                                     array_2.Add(nul);
  148.                                 }
  149.                                 else
  150.                                 {
  151.                                     array_2.Add(time3);
  152.                                 }
  153.                                 if (time4.Equals(""))
  154.                                 {
  155.                                     array_2.Add(nul);
  156.                                 }
  157.                                 else
  158.                                 {
  159.                                     array_2.Add(time4);
  160.                                 }
  161.                                 if (time2.Equals(""))
  162.                                 {
  163.                                     array_2.Add(nul);
  164.                                 }
  165.                                 else
  166.                                 {
  167.                                     array_2.Add(nul);
  168.                                 }
  169.                                 if (time1.Length == 5)
  170.                                 {
  171.                                     time1 = "0" + time1;
  172.                                 }
  173.                                 if (time2.Length == 5)
  174.                                 {
  175.                                     time2 = "0" + time2;
  176.                                 }
  177.                                 if (!(time1.Equals("")) && (!time2.Equals("")))
  178.                                 {
  179.                                     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);
  180.                                     sum = Round(sum, 2);
  181.                                     array_2.Add(Convert.ToString(sum));
  182.                                 }
  183.                                 else
  184.                                 {
  185.                                     array_2.Add(nul);
  186.                                 }
  187.                             }
  188.                         }
  189.                         else
  190.                         {
  191.                             array_2.Add(nul);
  192.                             array_2.Add(nul);
  193.                             array_2.Add(nul);
  194.                             array_2.Add(nul);
  195.                             array_2.Add(nul);
  196.                         }
  197.                         comm8.Close();
  198.                         conn5.Close();
  199.                         array_1.Add(array_2);
  200.                     }
  201.                     comm5.Close();
  202.                     conn2.Close();
  203.                 }
  204.                 k++;
  205.             }
  206.         }
  207.         conn1.Close();
  208.     }
  209.     public double Round(double v, int x)
  210.     {
  211.         bool flat = false;
  212.         if (v < 0)
  213.         {
  214.             flat = true;
  215.             v = -v;
  216.         }
  217.         int ivalue = 1;
  218.         for (int i = 1; i <= x; i++)
  219.         {
  220.             ivalue = 10 * ivalue;
  221.         }
  222.         double num = Math.Round(v * ivalue + 0.5, 0);
  223.         v = num / ivalue;
  224.         if (flat)
  225.         {
  226.             v = -v;
  227.         }
  228.         return v;
  229.     }
  230.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  231.     {
  232.         if (Calendar1.Visible == true)
  233.         {
  234.             Calendar1.Visible = false;
  235.             Calendar1.Focus();
  236.         }
  237.         else
  238.         {
  239.             Calendar1.Visible = true;
  240.             Calendar1.Focus();
  241.         }
  242.     }
  243.     protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
  244.     {
  245.         if (Calendar2.Visible == true)
  246.         {
  247.             Calendar2.Visible = false;
  248.             Calendar2.Focus();
  249.         }
  250.         else
  251.         {
  252.             Calendar2.Visible = true;
  253.             Calendar2.Focus();
  254.         }
  255.     }
  256.     protected void Calendar1_SelectionChanged(object sender, EventArgs e)
  257.     {
  258.         Calendar1.Visible = false;
  259.         string year = Calendar1.SelectedDate.Year.ToString();
  260.         string month = Calendar1.SelectedDate.Month.ToString();
  261.         if (month.Length == 1)
  262.         {
  263.             month = "0" + month;
  264.         }
  265.         string day = Calendar1.SelectedDate.Day.ToString();
  266.         if (day.Length == 1)
  267.         {
  268.             day = "0" + day;
  269.         }
  270.         TextBox1.Text = year + "-" + month + "-" + day;
  271.         TextBox1.Focus();
  272.     }
  273.     protected void Calendar2_SelectionChanged(object sender, EventArgs e)
  274.     {
  275.         Calendar2.Visible = false;
  276.         string year = Calendar2.SelectedDate.Year.ToString();
  277.         string month = Calendar2.SelectedDate.Month.ToString();
  278.         if (month.Length == 1)
  279.         {
  280.             month = "0" + month;
  281.         }
  282.         string day = Calendar2.SelectedDate.Day.ToString();
  283.         if (day.Length == 1)
  284.         {
  285.             day = "0" + day;
  286.         }
  287.         TextBox2.Text = year + "-" + month + "-" + day;
  288.         TextBox2.Focus();
  290.     }
  291.     public string getweekday(DateTime data)
  292.     {
  293.         string str = null;
  294.         switch (data.DayOfWeek.ToString())
  295.         {
  296.             case"Monday":
  297.                 str="星期一";
  298.                 break;
  299.             case"Tuesday":
  300.                 str = "星期二";
  301.                 break;
  302.             case"Wednesday":
  303.                 str = "星期三";
  304.                 break;
  305.             case"Thursday":
  306.                 str = "星期四";
  307.                 break;
  308.             case"Friday":
  309.                 str = "星期五";
  310.                 break;
  311.             case"Saturday":
  312.                 str = "星期六";
  313.                 break;
  314.             case"Sunday":
  315.                 str = "星期日";
  316.                 break;
  317.         }
  318.         return str;
  319.     }
  320.     protected void Button1_Click(object sender, EventArgs e)
  321.     {
  322.         getnum();
  323.         foreach (ArrayList i in array_1)
  324.         {
  325.             foreach (string j in i)
  326.             {
  327.                 Response.Write(j);
  328.             }
  329.         }
  330.         /*DataTable dt = GetData();
  332.         ReportDataSource rds = new ReportDataSource("DataSet1_DataTable1", dt);
  333.         ReportViewer1.LocalReport.DataSources.Clear();
  334.         ReportViewer1.LocalReport.DataSources.Add(rds);
  335.         ReportViewer1.LocalReport.Refresh();
  336.         ReportViewer1.Visible = true;*/
  337.     }
  338.     private DataTable GetData()
  339.     {
  340.         DataTable dt = new DataTable("dataname");
  341.         dt.Columns.Add(new DataColumn("所屬部門", typeof(string)));
  342.         dt.Columns.Add(new DataColumn("姓名", typeof(string)));
  343.         dt.Columns.Add(new DataColumn("員工編號", typeof(string)));
  344.         dt.Columns.Add(new DataColumn("日期", typeof(string)));
  345.         dt.Columns.Add(new DataColumn("星期", typeof(string)));
  346.         dt.Columns.Add(new DataColumn("早上上班", typeof(string)));
  347.         dt.Columns.Add(new DataColumn("中午下班", typeof(string)));
  348.         dt.Columns.Add(new DataColumn("下午上班", typeof(string)));
  349.         dt.Columns.Add(new DataColumn("下午下班", typeof(string)));
  350.         dt.Columns.Add(new DataColumn("簽到時數", typeof(string)));
  352.         DataRow row = dt.NewRow();
  353.         foreach (ArrayList i in array_1)
  354.         {
  355.             int n = 0;
  356.             foreach (string j in i)
  357.             {
  358.                 row = dt.NewRow();
  359.                 if (n < 10)
  360.                 {
  361.                     switch (n)
  362.                     {
  363.                         case 0:
  364.                             row["所屬部門"] = j;
  365.                             break;
  366.                         case 1:
  367.                             row["姓名"] = j;
  368.                             break;
  369.                         case 2:
  370.                             row["員工編號"] = j;
  371.                             break;
  372.                         case 3:
  373.                             row["日期"] = j;
  374.                             break;
  375.                         case 4:
  376.                             row["星期"] = j;
  377.                             break;
  378.                         case 5:
  379.                             row["早上上班"] = j;
  380.                             break;
  381.                         case 6:
  382.                             row["中午下班"] = j;
  383.                             break;
  384.                         case 7:
  385.                             row["下午上班"] = j;
  386.                             break;
  387.                         case 8:
  388.                             row["下午下班"] = j;
  389.                             break;
  390.                         case 9:
  391.                             row["簽到時數"] = j;
  392.                             break;
  393.                     }
  394.                     n++;
  395.                 }
  396.                 else
  397.                 {
  398.                     break;
  399.                 }
  400.             }
  401.             dt.Rows.Add(row);
  402.         }
  403.         return dt;
  404.     }
  405.     protected void TextBox1_TextChanged(object sender, EventArgs e)
  406.     {
  408.     }
  409.     protected void TextBox2_TextChanged(object sender, EventArgs e)
  410.     {
  412.     }
  413. }