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

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

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 System.IO;
  13. using Microsoft.Office.Interop.Excel;
  14. using Microsoft.Office.Interop;
  15. using System.Reflection;
  16. using System.Runtime.InteropServices;
  17. using ExcelApplication = Microsoft.Office.Interop.Excel.Application;
  18. using Label = System.Web.UI.WebControls.Label;
  20. public partial class web_pos_c_show : System.Web.UI.Page
  21. {
  22.     int id = 0;
  23.     ArrayList array1 = new ArrayList();
  24.     ArrayList array2 = new ArrayList();
  25.     ArrayList array3 = new ArrayList();
  26.     ArrayList array_1 = new ArrayList();
  27.     string str_path ="~/";
  28.     string str_name = "";
  29.     protected void Page_Load(object sender, EventArgs e)
  30.     {
  31.         Table1.Visible = true;
  32.         SqlConnection conn = dbConnection.getConnection();
  33.         conn.Open();
  34.         SqlCommand comm1 = new SqlCommand("select id from OA_DEPARTMENT where name='中山隆成啟航商貿有限公司'", conn);
  35.         id = Convert.ToInt32(comm1.ExecuteScalar());
  36.         SqlCommand sqlcom2 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + id + "'", conn);
  37.         SqlDataReader comm2 = sqlcom2.ExecuteReader();
  38.         while (comm2.Read())
  39.         {
  40.             array1.Add(Convert.ToInt32(comm2["id"]));
  41.         }
  42.         comm2.Close();
  43.         foreach (int i in array1)
  44.         {
  45.             ArrayList array5 = new ArrayList();
  46.             array5.Add(i);
  47.             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);
  48.             SqlDataReader comm3 = sqlcom3.ExecuteReader();
  49.             if (comm3.HasRows)
  50.             {
  51.                 while (comm3.Read())
  52.                 {
  53.                     array5.Add(Convert.ToInt32(comm3["id"]));
  54.                     SqlConnection conn1 = dbConnection.getConnection();
  55.                     conn1.Open();
  56.                     SqlCommand sqlcom4 = new SqlCommand("select id from OA_DEPARTMENT where last_id='" + Convert.ToInt32(comm3["id"]) + "'", conn1);
  57.                     SqlDataReader comm4 = sqlcom4.ExecuteReader();
  58.                     if (comm4.HasRows)
  59.                     {
  60.                         while (comm4.Read())
  61.                         {
  62.                             array5.Add(Convert.ToInt32(comm4["id"]));
  63.                         }
  64.                     }
  65.                     comm4.Close();
  66.                     conn1.Close();
  67.                 }
  68.             }
  69.             comm3.Close();
  70.             array2.Add(array5);
  71.         }
  72.         conn.Close();
  73.     }
  74.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  75.     {
  76.         if (Calendar1.Visible == true)
  77.         {
  78.             Calendar1.Visible = false;
  79.             Calendar1.Focus();
  80.         }
  81.         else
  82.         {
  83.             Calendar1.Visible = true;
  84.             Calendar1.Focus();
  85.         }
  86.     }
  87.     protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
  88.     {
  89.         if (Calendar2.Visible == true)
  90.         {
  91.             Calendar2.Visible = false;
  92.             Calendar2.Focus();
  93.         }
  94.         else
  95.         {
  96.             Calendar2.Visible = true;
  97.             Calendar2.Focus();
  98.         }
  99.     }
  100.     protected void Calendar1_SelectionChanged(object sender, EventArgs e)
  101.     {
  102.         Calendar1.Visible = false;
  103.         string year = Calendar1.SelectedDate.Year.ToString();
  104.         string month = Calendar1.SelectedDate.Month.ToString();
  105.         if (month.Length == 1)
  106.         {
  107.             month = "0" + month;
  108.         }
  109.         string day = Calendar1.SelectedDate.Day.ToString();
  110.         if (day.Length == 1)
  111.         {
  112.             day = "0" + day;
  113.         }
  114.         TextBox1.Text = year + "-" + month + "-" + day;
  115.         TextBox1.Focus();
  116.     }
  117.     protected void Calendar2_SelectionChanged(object sender, EventArgs e)
  118.     {
  119.         Calendar2.Visible = false;
  120.         string year = Calendar2.SelectedDate.Year.ToString();
  121.         string month = Calendar2.SelectedDate.Month.ToString();
  122.         if (month.Length == 1)
  123.         {
  124.             month = "0" + month;
  125.         }
  126.         string day = Calendar2.SelectedDate.Day.ToString();
  127.         if (day.Length == 1)
  128.         {
  129.             day = "0" + day;
  130.         }
  131.         TextBox2.Text = year + "-" + month + "-" + day;
  132.         TextBox2.Focus();
  134.     }
  135.     public void getnum()
  136.     {
  137.         int k=0;
  138.         string nul="nbsp";
  139.         string department="";
  140.         double sum=0;
  141.         string time1="";
  142.         string time2="";
  143.         string time3 = "";
  144.         string time4 = "";
  145.         ArrayList array_2 = new ArrayList();
  146.         SqlConnection conn1 = dbConnection.getConnection();
  147.         conn1.Open();
  148.         foreach (ArrayList i in array2)
  149.         {
  150.             ArrayList array6 = new ArrayList();
  151.             foreach (int j in i)
  152.             {
  153.                 SqlCommand sqlcom1 = new SqlCommand("select emp_no from OA_EMPLOYEE where department_id='" + j + "'", conn1);
  154.                 SqlDataReader comm1 = sqlcom1.ExecuteReader();
  155.                 if (comm1.HasRows)
  156.                 {
  157.                     while (comm1.Read())
  158.                     {
  159.                         array6.Add(Convert.ToString(comm1["emp_no"]));
  160.                     }
  161.                 }
  162.                 comm1.Close();
  163.             }
  164.             array3.Add(array6);
  165.         }
  166.         foreach (ArrayList i in array3)
  167.         {
  168.             if (k < array1.Count)
  169.             {
  170.                 SqlCommand sqlcom2 = new SqlCommand("select name from OA_DEPARTMENT where id='" + array1[k] + "'", conn1);
  171.                 array_2.Add(Convert.ToString(sqlcom2.ExecuteScalar()));
  172.                 foreach (string j in i)
  173.                 {
  174.                     array_2.Add("員工編號");
  175.                     array_2.Add(j);
  176.                     array_2.Add("員工姓名");
  177.                     SqlConnection conn2 = dbConnection.getConnection();
  178.                     conn2.Open();
  179.                     SqlCommand sqlcom3 = new SqlCommand("select emp_name from OA_EMPLOYEE where emp_no='" + j + "'", conn2);
  180.                     array_2.Add(Convert.ToString(sqlcom3.ExecuteScalar()));
  181.                     array_2.Add("所屬部門");
  182.                     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);
  183.                     department = Convert.ToString(sqlcom4.ExecuteScalar());
  184.                     array_2.Add(department);
  185.                     array_1.Add(array_2);
  187.                     array_2 = new ArrayList();
  188.                     array_2.Add("日期");
  189.                     array_2.Add("星期");
  190.                     array_2.Add("班別");
  191.                     array_2.Add("排班時間");
  192.                     array_2.Add("排班門店");
  193.                     array_2.Add("簽到退時間");
  194.                     array_2.Add("簽到時數");
  195.                     array_1.Add(array_2);
  197.                     array_2 = new ArrayList();
  198.                     SqlCommand sqlcom5 = new SqlCommand("select distinct data from OA_KAOQIN_JL where data between'" + TextBox1.Text + "'and'" + TextBox2.Text + "'order by data", conn2);
  199.                     SqlDataReader comm5 = sqlcom5.ExecuteReader();
  200.                     while (comm5.Read())
  201.                     {
  202.                         array_2.Add(Convert.ToString(comm5["data"]));
  203.                         array_2.Add(getweekday(Convert.ToDateTime(comm5["data"])));
  204.                         SqlConnection conn3 = dbConnection.getConnection();
  205.                         conn3.Open();
  206.                         SqlCommand sqlcom6 = new SqlCommand("select banbie from OA_KAOQIN_PBB where data='" + Convert.ToString(comm5["data"]) + "'and emp_no='" + j + "'", conn3);
  207.                         SqlDataReader comm6 = sqlcom6.ExecuteReader();
  208.                         if (comm6.HasRows)
  209.                         {
  210.                             while (comm6.Read())
  211.                             {
  212.                                 array_2.Add(Convert.ToString(comm6["banbie"]));
  213.                                 SqlConnection conn4 = dbConnection.getConnection();
  214.                                 conn4.Open();
  215.                                 SqlCommand sqlcom7 = new SqlCommand("select bengin_time,end_time from oa_pos_type where department='" + department + "'and type='" + Convert.ToString(comm6["banbie"]) + "'", conn4);
  216.                                 SqlDataReader comm7 = sqlcom7.ExecuteReader();
  217.                                 if (comm7.HasRows)
  218.                                 {
  219.                                     while (comm7.Read())
  220.                                     {
  221.                                         array_2.Add(Convert.ToString(comm7["bengin_time"]));
  222.                                         array_2.Add(Convert.ToString(comm7["end_time"]));
  223.                                     }
  224.                                 }
  225.                                 else
  226.                                 {
  227.                                     array_2.Add(nul);
  228.                                     array_2.Add(nul);
  229.                                 }
  230.                                 comm7.Close();
  231.                                 conn4.Close();
  232.                             }
  233.                             array_2.Add(department);
  234.                         }
  235.                         else
  236.                         {
  237.                             array_2.Add(nul);
  238.                             array_2.Add(nul);
  239.                             array_2.Add(nul);
  240.                             array_2.Add(nul);
  241.                         }
  242.                         comm6.Close();
  243.                         conn3.Close();
  244.                         SqlConnection conn5 = dbConnection.getConnection();
  245.                         conn5.Open();
  246.                         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);
  247.                         SqlDataReader comm8 = sqlcom8.ExecuteReader();
  248.                         if (comm8.HasRows)
  249.                         {
  250.                             while (comm8.Read())
  251.                             {
  252.                                 time1 = Convert.ToString(comm8["zao"]);
  253.                                 time2 = Convert.ToString(comm8["wan"]);
  254.                                 time3 = Convert.ToString(comm8["wuxia"]);
  255.                                 time4 = Convert.ToString(comm8["wushang"]);
  256.                                 if (time1.Equals(""))
  257.                                 {
  258.                                     array_2.Add(nul);
  259.                                 }
  260.                                 else
  261.                                 {
  262.                                     array_2.Add(time1);
  263.                                 }
  264.                                 if (time3.Equals(""))
  265.                                 {
  266.                                     array_2.Add(nul);
  267.                                 }
  268.                                 else
  269.                                 {
  270.                                     array_2.Add(time3);
  271.                                 }
  272.                                 if (time4.Equals(""))
  273.                                 {
  274.                                     array_2.Add(nul);
  275.                                 }
  276.                                 else
  277.                                 {
  278.                                     array_2.Add(time4);
  279.                                 }
  280.                                 if (time2.Equals(""))
  281.                                 {
  282.                                     array_2.Add(nul);
  283.                                 }
  284.                                 else
  285.                                 {
  286.                                     array_2.Add(nul);
  287.                                 }
  288.                                 if (time1.Length == 5)
  289.                                 {
  290.                                     time1 = "0" + time1;
  291.                                 }
  292.                                 if (time2.Length == 5)
  293.                                 {
  294.                                     time2 = "0" + time2;
  295.                                 }
  296.                                 if (!(time1.Equals("")) && (!time2.Equals("")))
  297.                                 {
  298.                                     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);
  299.                                     sum = Round(sum, 2);
  300.                                     array_2.Add(Convert.ToString(sum));
  301.                                 }
  302.                                 else
  303.                                 {
  304.                                     array_2.Add(nul);
  305.                                 }
  306.                                 array_1.Add(array_2);
  307.                             }
  308.                         }
  309.                         else
  310.                         {
  311.                             array_2.Add(nul);
  312.                             array_2.Add(nul);
  313.                             array_2.Add(nul);
  314.                             array_2.Add(nul);
  315.                             array_2.Add(nul);
  316.                         }
  317.                         comm8.Close();
  318.                         conn5.Close();
  319.                     }
  320.                     comm5.Close();
  321.                     conn2.Close();
  322.                 }
  323.                 k++;
  324.             }
  325.         }
  326.         conn1.Close();
  327.     }
  328.     public double Round(double v, int x)
  329.     {
  330.         bool flat = false;
  331.         if (v < 0)
  332.         {
  333.             flat = true;
  334.             v = -v;
  335.         }
  336.         int ivalue = 1;
  337.         for (int i = 1; i <= x; i++)
  338.         {
  339.             ivalue = 10 * ivalue;
  340.         }
  341.         double num = Math.Round(v*ivalue+0.5,0);
  342.         v = num / ivalue;
  343.         if (flat)
  344.         {
  345.             v = -v;
  346.         }
  347.         return v;
  348.     }
  349.     public string getweekday(DateTime data)
  350.     {
  351.         string str = null;
  352.         switch (data.DayOfWeek.ToString())
  353.         {
  354.             case "Monday":
  355.                 str = "星期一";
  356.                 break;
  357.             case "Tuesday":
  358.                 str = "星期二";
  359.                 break;
  360.             case "Wednesday":
  361.                 str = "星期三";
  362.                 break;
  363.             case "Thursday":
  364.                 str = "星期四";
  365.                 break;
  366.             case "Friday":
  367.                 str = "星期五";
  368.                 break;
  369.             case "Saturday":
  370.                 str = "星期六";
  371.                 break;
  372.             case "Sunday":
  373.                 str = "星期日";
  374.                 break;
  375.         }
  376.         return str;
  377.     }
  378.     protected void Button1_Click(object sender, EventArgs e)
  379.     {
  380.         array_1 = new ArrayList();
  381.         getnum();
  382.         getexcel();
  383.         download(str_path, str_name);
  384.         delete(str_path,str_name);
  385.     }
  386.     public void getexcel()
  387.     {
  388.         int p = 0;
  389.         int q = 0;
  390.         int k = 2;
  391.          ExcelApplication exc = new ExcelApplication();
  392.          exc.ScreenUpdating = false;
  393.          exc.Visible = false;
  394.          exc.UserControl = false;
  395.          Workbooks workbooks = exc.Workbooks;
  396.         _Workbook workbook = workbooks.Add(true);
  397.          Sheets shs =workbook.Sheets;
  398.          _Worksheet sh = (_Worksheet)shs.get_Item(1);
  399.          Range rang = sh.get_Range(sh.Cells[1, 1], sh.Cells[1, 11]);
  400.          rang.Merge(true);
  401.          rang.Value2 = "中山隆成启航商贸有限公司";
  402.          rang.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  403.          foreach(ArrayList i in array_1 )
  404.          {
  405.              q = 0;
  406.              if (p < 65000)
  407.              {
  408.                  foreach (string j in i)
  409.                  {
  410.                      if (!j.Equals("日期"))
  411.                      {
  412.                          if (j == "&nbsp;")
  413.                          {
  414.                              Range rang1 = sh.get_Range(sh.Cells[p+2,q+1],sh.Cells[p+2,q+1]);
  415.                              rang1.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  416.                              rang1.Borders.Weight = XlBorderWeight.xlMedium;
  417.                              rang1.Value2 = "";
  418.                          }
  419.                          else
  420.                          {
  421.                              Range rang1 = sh.get_Range(sh.Cells[p + 2, q + 1], sh.Cells[p + 2, q + 1]);
  422.                              rang1.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  423.                              rang1.Borders.Weight = XlBorderWeight.xlMedium;
  424.                              rang1.Value2 = j;
  425.                          }
  426.                          q++;
  427.                      }
  428.                      else
  429.                      {
  430.                          Range rang3=sh.get_Range(sh.Cells[p+2,q+1],sh.Cells[p+2,q+1]);
  431.                          //rang3.Font.Name = "黑体";
  432.                          rang3.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  433.                          rang3.Borders.LineStyle = XlLineStyle.xlContinuous;
  434.                          rang3.Borders.Weight = XlBorderWeight.xlMedium;
  435.                          rang3.Value2="日期";
  436.                          Range rang4 = sh.get_Range(sh.Cells[p + 2, q + 2], sh.Cells[p + 2, q + 2]);
  437.                          //rang4.Font.Name = "黑体";
  438.                          rang4.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  439.                          rang4.Borders.Weight = XlBorderWeight.xlMedium;
  440.                          rang4.Value2 = "星期";
  441.                          Range rang5 = sh.get_Range(sh.Cells[p + 2, q + 3], sh.Cells[p + 2, q + 3]);
  442.                          //rang5.Font.Name = "黑体";
  443.                          rang5.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  444.                          rang5.Borders.Weight = XlBorderWeight.xlMedium;
  445.                          rang5.Value2 = "班别";
  446.                          Range rang1 = sh.get_Range(sh.Cells[p+2,q+4],sh.Cells[p+2,q+5]);
  447.                          rang1.Merge(true);
  448.                          //rang1.Font.Name = "黑体";
  449.                          rang1.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  450.                          rang1.Borders.Weight = XlBorderWeight.xlMedium;
  451.                          rang1.Value2 = "排班时间";
  452.                          Range rang7 = sh.get_Range(sh.Cells[p + 2, q + 6], sh.Cells[p + 2, q + 6]);
  453.                          //rang7.Font.Name = "黑体";
  454.                          rang7.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  455.                          rang7.Borders.Weight = XlBorderWeight.xlMedium;
  456.                          rang7.Value2 = "排班门店";
  457.                          Range rang2 = sh.get_Range(sh.Cells[p+2,q+7],sh.Cells[p+2,q+10]);
  458.                          rang2.Merge(true);
  459.                          rang2.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  460.                          rang2.Borders.Weight = XlBorderWeight.xlMedium;
  461.                          //rang2.Font.Name = "黑体";
  462.                          rang2.Value2 = "签到退时间";
  463.                          Range rang6 = sh.get_Range(sh.Cells[p + 2, q + 11], sh.Cells[p + 2, q + 11]);
  464.                          //rang6.Font.Name = "黑体";
  465.                          rang6.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  466.                          rang6.Borders.Weight = XlBorderWeight.xlMedium;
  467.                          rang6.Value2 = "签到时数";
  468.                          break;
  469.                      }
  470.                  }
  471.              }
  472.              else
  473.              {
  474.                  p = 0;
  475.                  foreach (string j in i)
  476.                  {
  477.                      if (!j.Equals("日期"))
  478.                      {
  479.                          sh = (_Worksheet)shs.get_Item(k);
  480.                          k = k + 1;
  481.                          if (j == "&nbsp;")
  482.                          {
  483.                              Range rang1 = sh.get_Range(sh.Cells[p + 2, q + 1], sh.Cells[p + 2, q + 1]);
  484.                              rang1.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  485.                              rang1.Borders.Weight = XlBorderWeight.xlMedium;
  486.                              rang1.Value2 = "";
  487.                          }
  488.                          else
  489.                          {
  490.                              Range rang1 = sh.get_Range(sh.Cells[p + 2, q + 1], sh.Cells[p + 2, q + 1]);
  491.                              rang1.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  492.                              rang1.Borders.Weight = XlBorderWeight.xlMedium;
  493.                              rang1.Value2 = j;
  494.                          }
  495.                          q++;
  496.                      }
  497.                      else
  498.                      {
  499.                          Range rang3 = sh.get_Range(sh.Cells[p + 2, q + 1], sh.Cells[p + 2, q + 1]);
  500.                          rang3.Font.Name = "黑体";
  501.                          rang3.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  502.                          rang3.Borders.Weight = XlBorderWeight.xlMedium;
  503.                          rang3.Value2 = "日期";
  504.                          Range rang4 = sh.get_Range(sh.Cells[p + 2, q + 2], sh.Cells[p + 2, q + 2]);
  505.                          rang4.Font.Name = "黑体";
  506.                          rang4.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  507.                          rang4.Borders.Weight = XlBorderWeight.xlMedium;
  508.                          rang4.Value2 = "星期";
  509.                          Range rang5 = sh.get_Range(sh.Cells[p + 2, q + 3], sh.Cells[p + 2, q + 3]);
  510.                          rang5.Font.Name = "黑体";
  511.                          rang5.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  512.                          rang5.Borders.Weight = XlBorderWeight.xlMedium;
  513.                          rang5.Value2 = "班别";
  514.                          Range rang1 = sh.get_Range(sh.Cells[p + 2, q + 4], sh.Cells[p + 2, q + 5]);
  515.                          rang1.Merge(true);
  516.                          rang1.Font.Name = "黑体";
  517.                          rang1.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  518.                          rang1.Borders.Weight = XlBorderWeight.xlMedium;
  519.                          rang1.Value2 = "排班时间";
  520.                          Range rang7 = sh.get_Range(sh.Cells[p + 2, q + 6], sh.Cells[p + 2, q + 6]);
  521.                          rang7.Font.Name = "黑体";
  522.                          rang7.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  523.                          rang7.Borders.Weight = XlBorderWeight.xlMedium;
  524.                          rang7.Value2 = "排班门店";
  525.                          Range rang2 = sh.get_Range(sh.Cells[p + 2, q + 7], sh.Cells[p + 2, q + 10]);
  526.                          rang2.Merge(true);
  527.                          rang2.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  528.                          rang2.Borders.Weight = XlBorderWeight.xlMedium;
  529.                          rang2.Font.Name = "黑体";
  530.                          rang2.Value2 = "签到退时间";
  531.                          Range rang6 = sh.get_Range(sh.Cells[p + 2, q + 11], sh.Cells[p + 2, q + 11]);
  532.                          rang6.Font.Name = "黑体";
  533.                          rang6.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  534.                          rang6.Borders.Weight = XlBorderWeight.xlMedium;
  535.                          rang6.Value2 = "签到时数";
  536.                          break;
  537.                      }
  538.                  }
  539.              }   
  540.              p++;
  541.          }
  542.          exc.UserControl = true;
  543.          exc.ScreenUpdating = true;
  544.          str_name = "考勤记录.xls";
  545.          string strFilePhysicalPath = Server.MapPath(str_path)+ str_name;
  546.          sh.SaveAs(strFilePhysicalPath, Type.Missing, Type.Missing, Type.Missing,
  547.         Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
  548.          ReleaseCom(sh);
  549.          ReleaseCom(shs);
  550.          ReleaseCom(workbook);
  551.          ReleaseCom(workbooks);
  552.          exc.Quit();
  553.          ReleaseCom(exc);
  554.     }
  555.     private void ReleaseCom(object pComObj)
  556.     {
  557.         try
  558.         {
  559.             if (pComObj != null)
  560.             {
  561.                 System.Runtime.InteropServices.Marshal.ReleaseComObject(pComObj);
  562.             }
  563.         }
  564.         catch
  565.         {
  566.         }
  567.         finally
  568.         {
  569.             pComObj = null;
  570.         }
  571.     }
  572.     public void delete(string strFilePath,string strFileName)
  573.     {
  574.         string strFilePhysicalPath = Server.MapPath(strFilePath + "/") + strFileName;
  575.         if (File.Exists(strFilePhysicalPath))
  576.         {
  577.             File.Delete(strFilePhysicalPath);
  578.         }
  579.     }
  580.     public void download(string strFilePath, string strFileName)
  581.     {
  582.         string FullFileName = Server.MapPath(strFilePath + "/") + strFileName;
  584.         FileInfo DownloadFile = new FileInfo(FullFileName);
  585.         Response.Clear();
  586.         Response.ClearHeaders();
  587.         Response.Buffer = false;
  588.         Response.ContentType = "application/octet-stream";
  589.         Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(DownloadFile.FullName, System.Text.Encoding.UTF8));
  590.         Response.AppendHeader("Content-Length", DownloadFile.Length.ToString());
  591.         Response.WriteFile(DownloadFile.FullName);
  592.         Response.Flush();
  593.         Response.End();
  594.     }
  595.      protected void TextBox1_TextChanged(object sender, EventArgs e)
  596.      {
  598.      }
  599.      protected void TextBox2_TextChanged(object sender, EventArgs e)
  600.      {
  602.      }
  603. }