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

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

OA系统

开发平台：

ASP/ASPX

show_work_2.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.Office.Interop.Excel;
  13. using Microsoft.Office.Interop;
  14. using System.Reflection;
  15. using System.Runtime.InteropServices;
  16. using ExcelApplication = Microsoft.Office.Interop.Excel.Application;
  17. using Label = System.Web.UI.WebControls.Label;
  19. public partial class web_pos_c_show_work : System.Web.UI.Page
  20. {
  21.     int id = 0;
  22.     ArrayList array1 = new ArrayList();
  23.     ArrayList array2 = new ArrayList();
  24.     ArrayList array3 = new ArrayList();
  25.     protected void Page_Load(object sender, EventArgs e)
  26.     {
  27.         SqlConnection conn = dbConnection.getConnection();
  28.         conn.Open();
  29.         SqlCommand comm1 = new SqlCommand("select id from OA_DEPARTMENT where name='中山隆成啟航商貿有限公司'", conn);
  30.         id = Convert.ToInt32(comm1.ExecuteScalar());
  31.         SqlCommand sqlcom2 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + id + "'", 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 + "'", 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.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  70.     {
  71.         if (Calendar1.Visible == true)
  72.         {
  73.             Calendar1.Visible = false;
  74.             Calendar1.Focus();
  75.         }
  76.         else
  77.         {
  78.             Calendar1.Visible = true;
  79.             Calendar1.Focus();
  80.         }
  81.     }
  82.     protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
  83.     {
  84.         if (Calendar2.Visible == true)
  85.         {
  86.             Calendar2.Visible = false;
  87.             Calendar2.Focus();
  88.         }
  89.         else
  90.         {
  91.             Calendar2.Visible = true;
  92.             Calendar2.Focus();
  93.         }
  94.     }
  95.     protected void Calendar1_SelectionChanged(object sender, EventArgs e)
  96.     {
  97.         Calendar1.Visible = false;
  98.         string year = Calendar1.SelectedDate.Year.ToString();
  99.         string month = Calendar1.SelectedDate.Month.ToString();
  100.         if (month.Length == 1)
  101.         {
  102.             month = "0" + month;
  103.         }
  104.         string day = Calendar1.SelectedDate.Day.ToString();
  105.         if (day.Length == 1)
  106.         {
  107.             day = "0" + day;
  108.         }
  109.         TextBox1.Text = year + "-" + month + "-" + day;
  110.         TextBox1.Focus();
  111.     }
  112.     protected void Calendar2_SelectionChanged(object sender, EventArgs e)
  113.     {
  114.         Calendar2.Visible = false;
  115.         string year = Calendar2.SelectedDate.Year.ToString();
  116.         string month = Calendar2.SelectedDate.Month.ToString();
  117.         if (month.Length == 1)
  118.         {
  119.             month = "0" + month;
  120.         }
  121.         string day = Calendar2.SelectedDate.Day.ToString();
  122.         if (day.Length == 1)
  123.         {
  124.             day = "0" + day;
  125.         }
  126.         TextBox2.Text = year + "-" + month + "-" + day;
  127.         TextBox2.Focus();
  129.     }
  130.     public void show_work()
  131.     {
  132.         int k = 0;
  133.         string nul = " ";
  134.         string department = null;
  135.         float sum = 0;
  136.         string time1 = null;
  137.         string time2 = null;
  138.         SqlConnection conn = dbConnection.getConnection();
  139.         conn.Open();
  140.         SqlCommand sqlcom = new SqlCommand();
  141.         foreach (ArrayList i in array2)
  142.         {
  143.             ArrayList array6 = new ArrayList();
  144.             foreach (int j in i)
  145.             {
  146.                 SqlCommand sqlcom1 = new SqlCommand("select emp_no from OA_EMPLOYEE where department_id='" + j + "'", conn);
  147.                 SqlDataReader comm1 = sqlcom1.ExecuteReader();
  148.                 if (comm1.HasRows)
  149.                 {
  150.                     while (comm1.Read())
  151.                     {
  152.                         array6.Add(Convert.ToString(comm1["emp_no"]));
  153.                     }
  154.                 }
  155.                 comm1.Close();
  156.             }
  157.             array3.Add(array6);
  158.         }
  159.         TableRow tr = new TableRow();
  160.         TableCell td = new TableCell();
  161.         td.BorderWidth = Unit.Pixel(1);
  162.         td.Style["Width"] = "90px";
  163.         td.Text = "中山隆成启航商贸有限公司";
  164.         tr.Cells.Add(td);
  165.         Table1.Rows.Add(tr);
  166.         foreach (ArrayList i in array3)
  167.         {
  168.             if (k < array1.Count)
  169.             {
  170.                 SqlConnection conn4 = dbConnection.getConnection();
  171.                 conn4.Open();
  172.                 SqlCommand sqlcom2 = new SqlCommand("select name from OA_DEPARTMENT where id='" + array1[k] + "'", conn4);
  173.                
  174.                 TableRow tr1 = new TableRow();
  175.                 TableCell td1 = new TableCell();
  176.                 td1.BorderWidth = Unit.Pixel(1);
  177.                 td1.Style["Width"] = "90px";
  178.                 d1.Text = Convert.ToString(sqlcom2.ExecuteScalar());
  179.                 tr1.Cells.Add(td1);
  180.                 Table1.Rows.Add(tr1);
  182.                 conn4.Close();
  184.                 foreach (string j in i)
  185.                 {
  186.                     TableRow tr2 = new TableRow();
  187.                     TableCell tdd1 = new TableCell();
  188.                     tdd1.BorderWidth = Unit.Pixel(1);
  189.                     tdd1.Style["Width"] = "90px";
  190.                     tdd1.Text = "员工编号";
  191.                     tr2.Cells.Add(tdd1);
  193.                     TableCell tdd2 = new TableCell();
  194.                     tdd2.BorderWidth = Unit.Pixel(1);
  195.                     tdd2.Style["Width"] = "90px";
  196.                     tdd2.Text = j;
  197.                     tr2.Cells.Add(tdd2);
  199.                     TableCell tdd3 = new TableCell();
  200.                     tdd3.BorderWidth = Unit.Pixel(1);
  201.                     tdd3.Style["Width"] = "90px";
  202.                     tdd3.Text = "员工名称";
  203.                     tr2.Cells.Add(tdd3);
  205.                     SqlCommand sqlcom3 = new SqlCommand("select emp_name from OA_EMPLOYEE where emp_no='" + j + "'", conn);
  206.                     TableCell tdd4 = new TableCell();
  207.                     tdd4.BorderWidth = Unit.Pixel(1);
  208.                     tdd4.Style["Width"] = "90px";
  209.                     tdd4.Text = Convert.ToString(sqlcom3.ExecuteScalar());
  210.                     tr2.Cells.Add(tdd4);
  212.                     TableCell tdd5 = new TableCell();
  213.                     tdd5.BorderWidth = Unit.Pixel(1);
  214.                     tdd5.Style["Width"] = "90px";
  215.                     tdd5.Text = "所属部门";
  216.                     tr2.Cells.Add(tdd5);
  218.                     SqlCommand sqlcom7 = 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 + "'", conn);
  219.                     department = Convert.ToString(sqlcom7.ExecuteScalar());
  220.                     TableCell tdd6 = new TableCell();
  221.                     tdd6.BorderWidth = Unit.Pixel(1);
  222.                     tdd6.Style["Width"] = "90px";
  223.                     tdd6.Text = department;
  224.                     tr2.Cells.Add(tdd6);
  225.                     Table1.Rows.Add(tr2);
  227.                     TableRow tr3 = new TableRow();
  228.                     TableCell t1 = new TableCell();
  229.                     t1.BorderWidth = Unit.Pixel(1);
  230.                     t1.Style["Width"] = "90px";
  231.                     t1.Text = "日期";
  232.                     tr3.Cells.Add(t1);
  234.                     TableCell t2 = new TableCell();
  235.                     t2.BorderWidth = Unit.Pixel(1);
  236.                     t2.Style["Width"] = "90px";
  237.                     t2.Text = "星期";
  238.                     tr3.Cells.Add(t2);
  240.                     TableCell t3 = new TableCell();
  241.                     t3.BorderWidth = Unit.Pixel(1);
  242.                     t3.Style["Width"] = "90px";
  243.                     t3.Text = "班别";
  244.                     tr3.Cells.Add(t3);
  246.                     TableCell t4 = new TableCell();
  247.                     t4.BorderWidth = Unit.Pixel(1);
  248.                     t4.Style["Width"] = "90px";
  249.                     t4.Text = "排班时间";
  250.                     tr3.Cells.Add(t4);
  252.                     TableCell t5 = new TableCell();
  253.                     t5.BorderWidth = Unit.Pixel(1);
  254.                     t5.Style["Width"] = "90px";
  255.                     t5.Text = nul;
  256.                     tr3.Cells.Add(t5);
  258.                     TableCell t6 = new TableCell();
  259.                     t6.BorderWidth = Unit.Pixel(1);
  260.                     t6.Style["Width"] = "90px";
  261.                     t6.Text = "排班门店";
  262.                     tr3.Cells.Add(t6);
  264.                     TableCell t7 = new TableCell();
  265.                     t7.BorderWidth = Unit.Pixel(1);
  266.                     t7.Style["Width"] = "90px";
  267.                     t7.Text = "签到退时间";
  268.                     tr3.Cells.Add(t7);
  270.                     TableCell t8 = new TableCell();
  271.                     t8.BorderWidth = Unit.Pixel(1);
  272.                     t8.Style["Width"] = "90px";
  273.                     t8.Text = nul;
  274.                     tr3.Cells.Add(t8);
  276.                     TableCell t9 = new TableCell();
  277.                     t9.BorderWidth = Unit.Pixel(1);
  278.                     t9.Style["Width"] = "90px";
  279.                     t9.Text = nul;
  280.                     tr3.Cells.Add(t9);
  282.                     TableCell t10 = new TableCell();
  283.                     t10.BorderWidth = Unit.Pixel(1);
  284.                     t10.Style["Width"] = "90px";
  285.                     t10.Text = nul;
  286.                     tr3.Cells.Add(t10);
  288.                     TableCell t11 = new TableCell();
  289.                     t11.BorderWidth = Unit.Pixel(1);
  290.                     t11.Style["Width"] = "90px";
  291.                     t11.Text = "签到时数";
  292.                     tr3.Cells.Add(t11);
  293.                     Table1.Rows.Add(tr3);
  294.                     SqlCommand sqlcom4 = new SqlCommand("select distinct data  from OA_KAOQIN_JL  where  data between '" + TextBox1.Text + "'and '" + TextBox2.Text + "' order by data", conn);
  295.                     SqlDataReader comm4 = sqlcom4.ExecuteReader();
  296.                     while (comm4.Read())
  297.                     {
  298.                         TableRow tr4 = new TableRow();
  299.                         TableCell d1 = new TableCell();
  300.                         d1.BorderWidth = Unit.Pixel(1);
  301.                         d1.Style["Width"] = "90px";
  302.                         d1.Text = Convert.ToString(comm4["data"]);
  303.                         tr4.Cells.Add(d1);
  305.                         TableCell d2 = new TableCell();
  306.                         d2.BorderWidth = Unit.Pixel(1);
  307.                         d2.Style["Width"] = "90px";
  308.                         d2.Text = getweekday(Convert.ToDateTime(comm4["data"]));
  309.                         tr4.Cells.Add(d2);
  311.                         SqlConnection conn1 = dbConnection.getConnection();
  312.                         conn1.Open();
  313.                         SqlCommand sqlcom5 = new SqlCommand("select banbie from OA_KAOQIN_PBB where data='" + Convert.ToString(comm4["data"]) + "' and emp_no='" + j + "'", conn1);
  314.                         SqlDataReader comm5 = sqlcom5.ExecuteReader();
  315.                         if (comm5.HasRows)
  316.                         {
  317.                             while (comm5.Read())
  318.                             {
  319.                                 TableCell d3 = new TableCell();
  320.                                 d3.BorderWidth = Unit.Pixel(1);
  321.                                 d3.Style["Width"] = "90px";
  322.                                 d3.Text = Convert.ToString(comm5["banbie"]);
  323.                                 tr4.Cells.Add(d3);
  325.                                 SqlConnection conn2 = dbConnection.getConnection();
  326.                                 conn2.Open();
  327.                                 SqlCommand sqlcom6 = new SqlCommand("select bengin_time,end_time from oa_pos_type where department='" + department + "' and type='" + Convert.ToString(comm5["banbie"]) + "'", conn2);
  328.                                 SqlDataReader comm6 = sqlcom6.ExecuteReader();
  329.                                 if (comm6.HasRows)
  330.                                 {
  331.                                     while (comm6.Read())
  332.                                     {
  333.                                         TableCell d4 = new TableCell();
  334.                                         d4.BorderWidth = Unit.Pixel(1);
  335.                                         d4.Style["Width"] = "90px";
  336.                                         d4.Text = Convert.ToString(comm6["bengin_time"]);
  337.                                         tr4.Cells.Add(d3);
  339.                                         TableCell d5 = new TableCell();
  340.                                         d5.BorderWidth = Unit.Pixel(1);
  341.                                         d5.Style["Width"] = "90px";
  342.                                         d5.Text = Convert.ToString(comm6["end_time"]);
  343.                                         tr4.Cells.Add(d5);
  344.                                     }
  345.                                 }
  346.                                 else
  347.                                 {
  348.                                     TableCell d4 = new TableCell();
  349.                                     d4.BorderWidth = Unit.Pixel(1);
  350.                                     d4.Style["Width"] = "90px";
  351.                                     d4.Text = nul;
  352.                                     tr4.Cells.Add(d3);
  354.                                     TableCell d5 = new TableCell();
  355.                                     d5.BorderWidth = Unit.Pixel(1);
  356.                                     d5.Style["Width"] = "90px";
  357.                                     d5.Text = nul;
  358.                                     tr4.Cells.Add(d5);
  360.                                 }
  362.                                 comm6.Close();
  363.                                 conn2.Close();
  364.                                 TableCell d6 = new TableCell();
  365.                                 d6.BorderWidth = Unit.Pixel(1);
  366.                                 d6.Style["Width"] = "90px";
  367.                                 d6.Text = department;
  368.                                 tr4.Cells.Add(d6);
  369.                             }
  370.                         }
  371.                         else
  372.                         {
  373.                             TableCell d3 = new TableCell();
  374.                             d3.BorderWidth = Unit.Pixel(1);
  375.                             d3.Style["Width"] = "90px";
  376.                             d3.Visible = true;
  377.                             d3.Text = nul;
  378.                             tr4.Cells.Add(d3);
  380.                             TableCell d4 = new TableCell();
  381.                             d4.BorderWidth = Unit.Pixel(1);
  382.                             d4.Style["Width"] = "90px";
  383.                             d4.Text = nul;
  384.                             tr4.Cells.Add(d3);
  386.                             TableCell d5 = new TableCell();
  387.                             d5.BorderWidth = Unit.Pixel(1);
  388.                             d5.Style["Width"] = "90px";
  389.                             d5.Text = nul;
  390.                             tr4.Cells.Add(d5);
  392.                             TableCell d6 = new TableCell();
  393.                             d6.BorderWidth = Unit.Pixel(1);
  394.                             d6.Style["Width"] = "90px";
  395.                             d6.Text = nul;
  396.                             tr4.Cells.Add(d6);
  397.                             //}
  398.                         }
  399.                         comm5.Close();
  400.                         conn1.Close();
  401.                         SqlConnection conn3 = dbConnection.getConnection();
  402.                         conn3.Open();
  403.                         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(comm4["data"]) + "'", conn3);
  404.                         SqlDataReader comm8 = sqlcom8.ExecuteReader();
  405.                         if (comm8.HasRows)
  406.                         {
  407.                             while (comm8.Read())
  408.                             {
  409.                                 time1 = Convert.ToString(comm8["zao"]);
  410.                                 time2 = Convert.ToString(comm8["wan"]);
  411.                                 TableCell d7 = new TableCell();
  412.                                 d7.BorderWidth = Unit.Pixel(1);
  413.                                 d7.Style["Width"] = "90px";
  414.                                 d7.Text = Convert.ToString(comm8["zao"]);
  415.                                 if (d7.Text.Equals(""))
  416.                                 {
  417.                                     d7.Text = nul;
  418.                                 }
  419.                                 tr4.Cells.Add(d7);
  421.                                 TableCell d8 = new TableCell();
  422.                                 d8.BorderWidth = Unit.Pixel(1);
  423.                                 d8.Style["Width"] = "90px";
  424.                                 d8.Text = Convert.ToString(comm8["wuxia"]);
  425.                                 if (d8.Text.Equals(""))
  426.                                 {
  427.                                     d8.Text = nul;
  428.                                 }
  429.                                 tr4.Cells.Add(d8);
  431.                                 TableCell d9 = new TableCell();
  432.                                 d9.BorderWidth = Unit.Pixel(1);
  433.                                 d9.Style["Width"] = "90px";
  434.                                 d9.Text = Convert.ToString(comm8["wushang"]);
  435.                                 if (d9.Text.Equals(""))
  436.                                 {
  437.                                     d9.Text = nul;
  438.                                 }
  439.                                 tr4.Cells.Add(d9);
  441.                                 TableCell d10 = new TableCell();
  442.                                 d10.BorderWidth = Unit.Pixel(1);
  443.                                 d10.Style["Width"] = "90px";
  444.                                 d10.Text = Convert.ToString(comm8["wan"]);
  445.                                 if (d10.Text.Equals(""))
  446.                                 {
  447.                                     d10.Text = nul;
  448.                                 }
  449.                                 tr4.Controls.Add(d10);
  451.                                 if (time1.Length == 5)
  452.                                 {
  453.                                     time1 = "0" + time1;
  454.                                 }
  455.                                 if (time2.Length == 5)
  456.                                 {
  457.                                     time2 = "0" + time2;
  458.                                 }
  459.                                 TableCell d11 = new TableCell();
  460.                                 d11.BorderWidth = Unit.Pixel(1);
  461.                                 d11.Style["Width"] = "90px";
  462.                                 if (!(time1.Equals("")) && (!time2.Equals("")))
  463.                                 {
  464.                                     sum = (float)(Convert.ToInt32(time2.Substring(0, 2)) - Convert.ToInt32(time1.Substring(0, 2)) - 1.5 + (float)(Convert.ToInt32(time2.Substring(2, 2)) - Convert.ToInt32(time1.Substring(2, 2))) / 60 + (float)(Convert.ToInt32(time2.Substring(4, 2)) - Convert.ToInt32(time1.Substring(4, 2))) / 120);
  466.                                     d11.Text = Convert.ToString(sum);
  467.                                 }
  468.                                 else
  469.                                 {
  470.                                     d11.Text = nul;
  471.                                 }
  472.                                 tr4.Cells.Add(d11);
  473.                                 Table1.Rows.Add(tr4);
  474.                             }
  475.                         }
  477.                         else
  478.                         {
  479.                             TableCell d6 = new TableCell();
  480.                             d6.BorderWidth = Unit.Pixel(1);
  481.                             d6.Style["Width"] = "90px";
  482.                             d6.Text = nul;
  483.                             tr4.Cells.Add(d6);
  485.                             TableCell d7 = new TableCell();
  486.                             d7.BorderWidth = Unit.Pixel(1);
  487.                             d7.Style["Width"] = "90px";
  488.                             d7.Text = nul;
  489.                             tr4.Cells.Add(d7);
  491.                             TableCell d8 = new TableCell();
  492.                             d8.BorderWidth = Unit.Pixel(1);
  493.                             d8.Style["Width"] = "90px";
  494.                             d8.Text = nul;
  495.                             tr4.Cells.Add(d8);
  497.                             TableCell d9 = new TableCell();
  498.                             d9.BorderWidth = Unit.Pixel(1);
  499.                             d9.Style["Width"] = "90px";
  500.                             d9.Text = nul;
  501.                             tr4.Cells.Add(d9);
  503.                             TableCell d10 = new TableCell();
  504.                             d10.BorderWidth = Unit.Pixel(1);
  505.                             d10.Style["Width"] = "90px";
  506.                             d10.Text = nul;
  507.                             tr4.Cells.Add(d10);
  509.                             TableCell d11 = new TableCell();
  510.                             d11.BorderWidth = Unit.Pixel(1);
  511.                             d11.Style["Width"] = "90px";
  512.                             d11.Text = nul;
  513.                             tr4.Cells.Add(d11);
  514.                             Table1.Rows.Add(tr4);
  515.                         }
  518.                         comm8.Close();
  519.                         conn3.Close();
  520.                     }
  521.                     comm4.Close();
  522.                 }
  523.             }
  524.             k++;
  525.         }
  526.         conn.Close();
  527.     }
  528.     public string getweekday(DateTime data)
  529.     {
  530.         string str = null;
  531.         switch (data.DayOfWeek.ToString())
  532.         {
  533.             case "Monday":
  534.                 str = "星期一";
  535.                 break;
  536.             case "Tuesday":
  537.                 str = "星期二";
  538.                 break;
  539.             case "Wednesday":
  540.                 str = "星期三";
  541.                 break;
  542.             case "Thursday":
  543.                 str = "星期四";
  544.                 break;
  545.             case "Friday":
  546.                 str = "星期五";
  547.                 break;
  548.             case "Saturday":
  549.                 str = "星期六";
  550.                 break;
  551.             case "Sunday":
  552.                 str = "星期日";
  553.                 break;
  554.         }
  555.         return str;
  556.     }
  557.     protected void Button1_Click(object sender, EventArgs e)
  558.     {
  559.         show_work();
  560.     }
  561.     protected void TextBox1_TextChanged(object sender, EventArgs e)
  562.     {
  564.     }
  565.     protected void TextBox2_TextChanged(object sender, EventArgs e)
  566.     {
  568.     }
  569.     protected void Button2_Click(object sender, EventArgs e)
  570.     {
  571.     }
  572. }