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

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

OA系统

开发平台：

ASP/ASPX

report_approvel.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using System.Data.SqlClient;
  12. using Microsoft.Office.Interop.Excel;
  13. using Microsoft.Office.Interop;
  14. using System.Reflection;
  15. using System.IO;
  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_123_report_approvel : System.Web.UI.Page
  21. {
  22.     ArrayList array_1 = new ArrayList();
  23.     ArrayList array_2 = new ArrayList();
  24.     //string str_path = "..\..\oa_upload\temp\";
  25.     string str_path = "~/upload/";
  26.     string str_name = "hello.xls"; 
  27.     protected void Page_Load(object sender, EventArgs e)
  28.     {
  29.         if (!IsPostBack)
  30.         {
  31.             LoginDAO.CheckLogin(Session, Response, "../../", 2);
  32.             if (Table1.Visible = false)
  33.             {
  34.                 Button2.Enabled = false;
  35.             }
  36.             else if(Table1.Visible=true)
  37.             { 
  38.                 Button2.Enabled = true;
  39.             }
  40.         }
  41.     }
  42.     public void getnum()
  43.     {
  44.         if (!TxtBeginTime.Text.ToString().Equals("") && !TxtEndTime.Text.ToString().Equals(""))
  45.         {
  46.             
  47.             array_1 = new ArrayList();
  48.             SqlConnection con = dbConnection.getConnection();
  49.             con.Open();
  50.             SqlCommand cmd = new SqlCommand();
  51.             if (DropDf_type.SelectedValue.ToString().Equals("1"))
  52.             {
  53.                 if (DrpDownType.SelectedValue.ToString().Equals("1"))
  54.                 {
  55.                     cmd.CommandText = "select f.id as f_id,f.form_id ,e.emp_name,d.name,f.vacation_begin,f.vacation_end,f.days,f.off_type from oa_tw_approvel_form" +
  56.                         " as f inner join oa_employee as e on f.emp_id=e.id inner join oa_department as d on e.department_id=d.id " +
  57.                         " where vacation_begin>='" + TxtBeginTime.Text + "' and  vacation_begin<='" + TxtEndTime.Text + "' and off_type<>1 and total_result='同意' order by name,emp_name";
  58.                     cmd.Connection = con;
  59.                     SqlDataReader dr = cmd.ExecuteReader();
  61.                     while (dr.Read())
  62.                     {
  63.                         array_2 = new ArrayList();
  64.                         Table1.Visible = true;
  65.                         TableRow tr = new TableRow();
  66.                         TableCell td = new TableCell();
  67.                         td.BorderWidth = Unit.Pixel(1);
  68.                         td.Text = dr["form_id"].ToString();
  69.                         array_2.Add("'"+Convert.ToString(dr["form_id"]));
  70.                         tr.Cells.Add(td);
  72.                         td = new TableCell();
  73.                         td.BorderWidth = Unit.Pixel(1);
  74.                         td.Text = dr["name"].ToString();
  75.                         array_2.Add(Convert.ToString(dr["name"]));
  76.                         tr.Cells.Add(td);
  78.                         td = new TableCell();
  79.                         td.BorderWidth = Unit.Pixel(1);
  80.                         td.Text = dr["emp_name"].ToString();
  81.                         array_2.Add(Convert.ToString(dr["emp_name"]));
  82.                         tr.Cells.Add(td);
  84.                         td = new TableCell();
  85.                         td.BorderWidth = Unit.Pixel(1);
  86.                         td.Text = dr["vacation_begin"].ToString();
  87.                         array_2.Add("'"+Convert.ToString(dr["vacation_begin"]));
  88.                         tr.Cells.Add(td);
  90.                         td = new TableCell();
  91.                         td.BorderWidth = Unit.Pixel(1);
  92.                         td.Text = dr["vacation_end"].ToString();
  93.                         array_2.Add("'"+Convert.ToString(dr["vacation_end"]));
  94.                         tr.Cells.Add(td);
  96.                         td = new TableCell();
  97.                         td.BorderWidth = Unit.Pixel(1);
  98.                         td.Text = dr["days"].ToString() + "天";
  99.                         array_2.Add(Convert.ToString(td.Text));
  100.                         tr.Cells.Add(td);
  102.                         td = new TableCell();
  103.                         td.BorderWidth = Unit.Pixel(1);
  104.                         HyperLink hl = new HyperLink();
  105.                         hl.Text = "查看";
  106.                         hl.Target = "blank";
  107.                         hl.NavigateUrl = "../../approvel/tw/my_list.aspx?a_id=" + dr["f_id"].ToString()+"&k=1";
  108.                         td.Controls.Add(hl);
  109.                         tr.Cells.Add(td);
  111.                         Table1.Rows.Add(tr);
  112.                         array_1.Add(array_2);
  113.                     }
  114.                     dr.Close();
  115.                 }
  116.                 else if (DrpDownType.SelectedValue.ToString().Equals("4"))
  117.                 {
  118.                     array_1 = new ArrayList();
  119.                     cmd.CommandText = "select f.id,f.form_id,e.emp_name,d.name,f.business_begin,f.business_end,f.days,f.off_type from oa_tw_approvel_form" +
  120.                             " as f inner join oa_employee as e on f.emp_id=e.id inner join oa_department as d on e.department_id=d.id where" +
  121.                             " vacation_begin>='" + TxtBeginTime.Text + "' and  vacation_begin<='" + TxtEndTime.Text + "' and off_type=1 and total_result='同意' order by name,emp_name";
  122.                     cmd.Connection = con;
  123.                     SqlDataReader dr = cmd.ExecuteReader();
  125.                     while (dr.Read())
  126.                     {
  127.                         array_2 = new ArrayList();
  128.                         Table1.Visible = true;
  129.                         TableRow tr = new TableRow();
  130.                         TableCell td = new TableCell();
  131.                         td.BorderWidth = Unit.Pixel(1);
  132.                         td.Text = dr["form_id"].ToString();
  133.                         array_2.Add("'"+Convert.ToString(dr["form_id"]));
  134.                         tr.Cells.Add(td);
  136.                         td = new TableCell();
  137.                         td.BorderWidth = Unit.Pixel(1);
  138.                         td.Text = dr["name"].ToString();
  139.                         array_2.Add(Convert.ToString(dr["name"]));
  140.                         tr.Cells.Add(td);
  142.                         td = new TableCell();
  143.                         td.BorderWidth = Unit.Pixel(1);
  144.                         td.Text = dr["emp_name"].ToString();
  145.                         array_2.Add(Convert.ToString(dr["emp_name"]));
  146.                         tr.Cells.Add(td);
  148.                         td = new TableCell();
  149.                         td.BorderWidth = Unit.Pixel(1);
  150.                         td.Text = dr["'" + "business_begin"].ToString();
  151.                         array_2.Add(Convert.ToString(dr["business_begin"]));
  152.                         tr.Cells.Add(td);
  154.                         td = new TableCell();
  155.                         td.BorderWidth = Unit.Pixel(1);
  156.                         td.Text = dr["'" + "business_end"].ToString();
  157.                         array_2.Add(Convert.ToString(dr["business_end"]));
  158.                         tr.Cells.Add(td);
  160.                         td = new TableCell();
  161.                         td.BorderWidth = Unit.Pixel(1);
  162.                         td.Text = dr["days"].ToString() + "天";
  163.                         array_2.Add(Convert.ToString(td.Text));
  164.                         tr.Cells.Add(td);
  166.                         td = new TableCell();
  167.                         td.BorderWidth = Unit.Pixel(1);
  168.                         HyperLink hl = new HyperLink();
  169.                         hl.Text = "查看";
  170.                         hl.Target = "blank";
  171.                         hl.NavigateUrl = "../../approvel/tw/my_list.aspx?a_id=" + dr["f_id"].ToString()+"&k=1";
  172.                         td.Controls.Add(hl);
  173.                         tr.Cells.Add(td);
  175.                         Table1.Rows.Add(tr);
  176.                         array_1.Add(array_2);
  178.                     }
  179.                     dr.Close();
  180.                 }
  181.                 else
  182.                 {
  183.                     array_1 = new ArrayList();
  184.                     if (DrpDownType.SelectedValue.ToString().Equals("2"))
  185.                     {
  186.                         cmd.CommandText = "select f.id,f.form_id,e.emp_name,d.name,f.begin_time,f.end_time,f.days from oa_ch_business_form " +
  187.                             " as f inner join oa_employee as e on f.emp_id=e.id inner join oa_department as d on e.department_id=d.id where" +
  188.                             " begin_time>='" + TxtBeginTime.Text + "' and  begin_time<='" + TxtEndTime.Text + "' and total_result='同意' order by name,emp_name";
  189.                     }
  190.                     else if (DrpDownType.SelectedValue.ToString().Equals("3"))
  191.                     {
  192.                         cmd.CommandText = "select f.id,f.form_id,e.emp_name,d.name,f.begin_time,f.end_time,f.hours from oa_ch_off_form " +
  193.                             " as f inner join oa_employee as e on f.emp_id=e.id inner join oa_department as d on e.department_id=d.id where" +
  194.                             " begin_time>='" + TxtBeginTime.Text + "' and  begin_time<='" + TxtEndTime.Text + "' and total_result='同意' order by name,emp_name";
  195.                     }
  196.                     cmd.Connection = con;
  197.                     SqlDataReader dr = cmd.ExecuteReader();
  198.                     while (dr.Read())
  199.                     {
  200.                         array_2 = new ArrayList();
  201.                         Table1.Visible = true;
  202.                         TableRow tr = new TableRow();
  203.                         TableCell td = new TableCell();
  204.                         td.BorderWidth = Unit.Pixel(1);
  205.                         td.Text = dr["form_id"].ToString();
  206.                         array_2.Add("'" + Convert.ToString(dr["form_id"]));
  207.                         tr.Cells.Add(td);
  209.                         td = new TableCell();
  210.                         td.BorderWidth = Unit.Pixel(1);
  211.                         td.Text = dr["name"].ToString();
  212.                         array_2.Add(Convert.ToString(dr["name"]));
  213.                         tr.Cells.Add(td);
  215.                         td = new TableCell();
  216.                         td.BorderWidth = Unit.Pixel(1);
  217.                         td.Text = dr["emp_name"].ToString();
  218.                         array_2.Add(Convert.ToString(dr["emp_name"]));
  219.                         tr.Cells.Add(td);
  221.                         td = new TableCell();
  222.                         td.BorderWidth = Unit.Pixel(1);
  223.                         td.Text = dr["begin_time"].ToString();
  224.                         array_2.Add("'" + Convert.ToString(dr["begin_time"]));
  225.                         tr.Cells.Add(td);
  227.                         td = new TableCell();
  228.                         td.BorderWidth = Unit.Pixel(1);
  229.                         td.Text = dr["end_time"].ToString();
  230.                         array_2.Add("'" + Convert.ToString(dr["end_time"]));
  231.                         tr.Cells.Add(td);
  233.                         if (DrpDownType.SelectedValue.ToString().Equals("2"))
  234.                         {
  235.                             td = new TableCell();
  236.                             td.BorderWidth = Unit.Pixel(1);
  237.                             td.Text = dr["days"].ToString() + "天";
  238.                             array_2.Add(Convert.ToString(td.Text));
  239.                         }
  240.                         else if (DrpDownType.SelectedValue.ToString().Equals("3"))
  241.                         {
  242.                             td = new TableCell();
  243.                             td.BorderWidth = Unit.Pixel(1);
  244.                             td.Text = dr["hours"].ToString() + "小時";
  245.                             array_2.Add(Convert.ToString(td.Text));
  246.                         }
  247.                         tr.Cells.Add(td);
  249.                         td = new TableCell();
  250.                         td.BorderWidth = Unit.Pixel(1);
  251.                         HyperLink hl = new HyperLink();
  252.                         hl.Text = "查看";
  253.                         hl.Target = "blank";
  254.                         hl.NavigateUrl = "../../approvel/ch/my_list_d.aspx?a_id=" + dr["id"].ToString();
  255.                         td.Controls.Add(hl);
  256.                         tr.Cells.Add(td);
  258.                         Table1.Rows.Add(tr);
  259.                         array_1.Add(array_2);
  260.                     }
  261.                     dr.Close();
  263.                 }
  265.                 con.Close();
  266.             }
  267.             else
  268.             {
  269.                 int flag = 0;
  271.                 cmd.CommandText = "select f.id as f_id,f.form_id ,e.emp_name,d.name,f.vacation_begin,f.vacation_end,f.days,f.off_type from oa_tw_approvel_form" +
  272.                     " as f inner join oa_employee as e on f.emp_id=e.id inner join oa_department as d on e.department_id=d.id " +
  273.                     " where vacation_begin>='" + TxtBeginTime.Text + "' and  vacation_begin<='" + TxtEndTime.Text + "' and off_type<>1 and emp_no='"+TxtEmp_no.Text+
  274.                     "' and total_result='同意' order by name,emp_name";
  275.                 cmd.Connection = con;
  276.                 SqlDataReader dr = cmd.ExecuteReader();
  278.                 while (dr.Read())
  279.                 {
  280.                     array_2 = new ArrayList();
  281.                     Table1.Visible = true;
  282.                     TableRow tr = new TableRow();
  283.                     TableCell td = new TableCell();
  284.                     td.BorderWidth = Unit.Pixel(1);
  285.                     td.Text = dr["form_id"].ToString();
  286.                     array_2.Add("'" + Convert.ToString(dr["form_id"]));
  287.                     tr.Cells.Add(td);
  289.                     td = new TableCell();
  290.                     td.BorderWidth = Unit.Pixel(1);
  291.                     td.Text = dr["name"].ToString();
  292.                     array_2.Add(Convert.ToString(dr["name"]));
  293.                     tr.Cells.Add(td);
  295.                     td = new TableCell();
  296.                     td.BorderWidth = Unit.Pixel(1);
  297.                     td.Text = dr["emp_name"].ToString();
  298.                     array_2.Add(Convert.ToString(dr["emp_name"]));
  299.                     tr.Cells.Add(td);
  301.                     td = new TableCell();
  302.                     td.BorderWidth = Unit.Pixel(1);
  303.                     td.Text = dr["vacation_begin"].ToString();
  304.                     array_2.Add("'" + Convert.ToString(dr["vacation_begin"]));
  305.                     tr.Cells.Add(td);
  307.                     td = new TableCell();
  308.                     td.BorderWidth = Unit.Pixel(1);
  309.                     td.Text = dr["vacation_end"].ToString();
  310.                     array_2.Add("'" + Convert.ToString(dr["vacation_end"]));
  311.                     tr.Cells.Add(td);
  313.                     td = new TableCell();
  314.                     td.BorderWidth = Unit.Pixel(1);
  315.                     td.Text = dr["days"].ToString() + "天";
  316.                     array_2.Add(Convert.ToString(td.Text));
  317.                     tr.Cells.Add(td);
  319.                     td = new TableCell();
  320.                     td.BorderWidth = Unit.Pixel(1);
  321.                     HyperLink hl = new HyperLink();
  322.                     hl.Text = "查看";
  323.                     hl.Target = "blank";
  324.                     hl.NavigateUrl = "../../approvel/tw/my_list.aspx?a_id=" + dr["f_id"].ToString()+"&k=1";
  325.                     td.Controls.Add(hl);
  326.                     tr.Cells.Add(td);
  328.                     Table1.Rows.Add(tr);
  329.                     array_1.Add(array_2);
  330.                     flag = 1;
  331.                 }
  332.                 dr.Close();
  333.                 if (flag == 0)
  334.                 {
  335.                     array_1 = new ArrayList();
  336.                     cmd.CommandText = "select f.id,f.form_id,e.emp_name,d.name,f.business_begin,f.business_end,f.days,f.off_type from oa_tw_approvel_form" +
  337.                             " as f inner join oa_employee as e on f.emp_id=e.id inner join oa_department as d on e.department_id=d.id where" +
  338.                             " vacation_begin>='" + TxtBeginTime.Text + "' and  vacation_begin<='" + TxtEndTime.Text + "' and off_type=1 and total_result='同意'and emp_no='"+TxtEmp_no.Text+
  339.                             "' order by name,emp_name";
  340.                     cmd.Connection = con;
  341.                     SqlDataReader dr1 = cmd.ExecuteReader();
  343.                     while (dr1.Read())
  344.                     {
  345.                         array_2 = new ArrayList();
  346.                         Table1.Visible = true;
  347.                         TableRow tr = new TableRow();
  348.                         TableCell td = new TableCell();
  349.                         td.BorderWidth = Unit.Pixel(1);
  350.                         td.Text = dr1["form_id"].ToString();
  351.                         array_2.Add("'" + Convert.ToString(dr1["form_id"]));
  352.                         tr.Cells.Add(td);
  354.                         td = new TableCell();
  355.                         td.BorderWidth = Unit.Pixel(1);
  356.                         td.Text = dr1["name"].ToString();
  357.                         array_2.Add(Convert.ToString(dr1["name"]));
  358.                         tr.Cells.Add(td);
  360.                         td = new TableCell();
  361.                         td.BorderWidth = Unit.Pixel(1);
  362.                         td.Text = dr1["emp_name"].ToString();
  363.                         array_2.Add(Convert.ToString(dr1["emp_name"]));
  364.                         tr.Cells.Add(td);
  366.                         td = new TableCell();
  367.                         td.BorderWidth = Unit.Pixel(1);
  368.                         td.Text = dr1["business_begin"].ToString();
  369.                         array_2.Add("'" + Convert.ToString(dr1["business_begin"]));
  370.                         tr.Cells.Add(td);
  372.                         td = new TableCell();
  373.                         td.BorderWidth = Unit.Pixel(1);
  374.                         td.Text = dr1["business_end"].ToString();
  375.                         array_2.Add("'" + Convert.ToString(dr1["business_end"]));
  376.                         tr.Cells.Add(td);
  378.                         td = new TableCell();
  379.                         td.BorderWidth = Unit.Pixel(1);
  380.                         td.Text = dr["days"].ToString() + "天";
  381.                         array_2.Add(Convert.ToString(td.Text));
  382.                         tr.Cells.Add(td);
  384.                         td = new TableCell();
  385.                         td.BorderWidth = Unit.Pixel(1);
  386.                         HyperLink hl = new HyperLink();
  387.                         hl.Text = "查看";
  388.                         hl.Target = "blank";
  389.                         hl.NavigateUrl = "../../approvel/tw/my_list.aspx?a_id=" + dr1["f_id"].ToString()+"&k=1";
  390.                         td.Controls.Add(hl);
  391.                         tr.Cells.Add(td);
  393.                         Table1.Rows.Add(tr);
  394.                         array_1.Add(array_2);
  396.                     }
  397.                     dr1.Close();
  398.                 
  401.                 cmd.CommandText = "select f.id,f.form_id,e.emp_name,d.name,f.begin_time,f.end_time,f.days from oa_ch_business_form " +
  402.                     " as f inner join oa_employee as e on f.emp_id=e.id inner join oa_department as d on e.department_id=d.id where" +
  403.                     " begin_time>='" + TxtBeginTime.Text + "' and  begin_time<='" + TxtEndTime.Text + "'and emp_no='" + TxtEmp_no.Text + "'and total_result='同意' order by name,emp_name";
  406.                 cmd.Connection = con;
  407.                 SqlDataReader dr2 = cmd.ExecuteReader();
  408.                 while (dr2.Read())
  409.                 {
  410.                     array_2 = new ArrayList();
  411.                     Table1.Visible = true;
  412.                     TableRow tr = new TableRow();
  413.                     TableCell td = new TableCell();
  414.                     td.BorderWidth = Unit.Pixel(1);
  415.                     td.Text = dr2["form_id"].ToString();
  416.                     array_2.Add("'" + Convert.ToString(dr2["form_id"]));
  417.                     tr.Cells.Add(td);
  419.                     td = new TableCell();
  420.                     td.BorderWidth = Unit.Pixel(1);
  421.                     td.Text = dr2["name"].ToString();
  422.                     array_2.Add(Convert.ToString(dr2["name"]));
  423.                     tr.Cells.Add(td);
  425.                     td = new TableCell();
  426.                     td.BorderWidth = Unit.Pixel(1);
  427.                     td.Text = dr2["emp_name"].ToString();
  428.                     array_2.Add(Convert.ToString(dr2["emp_name"]));
  429.                     tr.Cells.Add(td);
  431.                     td = new TableCell();
  432.                     td.BorderWidth = Unit.Pixel(1);
  433.                     td.Text = dr2["begin_time"].ToString();
  434.                     array_2.Add("'" + Convert.ToString(dr2["begin_time"]));
  435.                     tr.Cells.Add(td);
  437.                     td = new TableCell();
  438.                     td.BorderWidth = Unit.Pixel(1);
  439.                     td.Text = dr2["end_time"].ToString();
  440.                     array_2.Add("'" + Convert.ToString(dr2["end_time"]));
  441.                     tr.Cells.Add(td);
  443.                     if (DrpDownType.SelectedValue.ToString().Equals("2"))
  444.                     {
  445.                         td = new TableCell();
  446.                         td.BorderWidth = Unit.Pixel(1);
  447.                         td.Text = dr2["days"].ToString() + "天";
  448.                         array_2.Add(Convert.ToString(td.Text));
  449.                     }
  450.                     else if (DrpDownType.SelectedValue.ToString().Equals("3"))
  451.                     {
  452.                         td = new TableCell();
  453.                         td.BorderWidth = Unit.Pixel(1);
  454.                         td.Text = dr2["hours"].ToString() + "小時";
  455.                         array_2.Add(Convert.ToString(td.Text));
  456.                     }
  457.                     tr.Cells.Add(td);
  459.                     td = new TableCell();
  460.                     td.BorderWidth = Unit.Pixel(1);
  461.                     HyperLink hl = new HyperLink();
  462.                     hl.Text = "查看";
  463.                     hl.Target = "blank";
  464.                     hl.NavigateUrl = "../../approvel/ch/my_list_d.aspx?a_id=" + dr2["id"].ToString()+"&k=1";
  465.                     td.Controls.Add(hl);
  466.                     tr.Cells.Add(td);
  468.                     Table1.Rows.Add(tr);
  469.                     array_1.Add(array_2);
  470.                 } dr2.Close();
  471.             }
  472.             }
  473.                    
  474.                     con.Close();
  476.                 }
  478.                 
  479.       else
  480.         {
  481.             Response.Write("<script>alert('日期不能為空！')</script>");
  482.         }
  483.     }
  484.         
  485.       
  486.    
  488.     public void getexcel()
  489.     {
  490.         ExcelApplication exc = new ExcelApplication();
  491.          exc.Visible = false;
  492.         exc.UserControl = false;
  493.         Workbooks workbooks = exc.Workbooks;
  494.         _Workbook workbook = workbooks.Add(true);
  495.         Sheets shs = workbook.Sheets;
  496.         _Worksheet sh = (_Worksheet)shs.get_Item(1);
  497.         Range rang = sh.get_Range(sh.Cells[1, 1], sh.Cells[1, 6]);
  498.         rang.Merge(true);
  499.         rang.Value2 = "差假統計表";
  500.         sh.Cells[2, 1] = "單號";
  501.         sh.Cells[2, 2] = "部門";
  502.         sh.Cells[2, 3] = "姓名";
  503.         sh.Cells[2, 4] = "日期起";
  504.         sh.Cells[2, 5] = "日期迄";
  505.         sh.Cells[2, 6] = "總計";
  506.         rang.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  507.         int n=3;
  508.         int m=1;
  509.         foreach(ArrayList i in array_1)
  510.         {
  511.             m = 1;
  512.             foreach (string j in i)
  513.             {
  514.                 Range rang1 = sh.get_Range(sh.Cells[n,m],sh.Cells[n,m]);
  515.                // rang1.Merge(true);
  516.                 rang1.Value2 = j;
  517.                 m++;
  518.             }
  519.             n++;
  520.         }
  521.         exc.Visible = true;
  522.         exc.UserControl = true;
  523.         exc.Columns.AutoFit();
  524.         exc.Columns.HorizontalAlignment = XlHAlign.xlHAlignCenter;
  525.         string strFilePhysicalPath = Server.MapPath(str_path) + str_name;
  526.         if (File.Exists(strFilePhysicalPath))
  527.         {
  528.             File.Delete(strFilePhysicalPath);
  529.         }
  530.         sh.Name = "hello";
  531.         exc.DisplayAlerts = false;
  532.         exc.AlertBeforeOverwriting = false;
  533.         //exc.Save(strFilePhysicalPath);
  534.         sh.SaveAs(strFilePhysicalPath, Type.Missing, Type.Missing, Type.Missing,
  535.         Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
  536.         workbook.Save();
  538.         ReleaseCom(sh);
  539.         ReleaseCom(shs);
  540.         ReleaseCom(workbook);
  541.         ReleaseCom(workbooks);
  542.         exc.Quit();
  543.         ReleaseCom(exc);
  544.        
  545.     }
  546.   
  547.     protected void Button1_Click(object sender, EventArgs e)
  548.     {
  549.         getnum();
  550.     }
  551.     private void ReleaseCom(object pComObj)
  552.     {
  553.         try
  554.         {
  555.             if (pComObj != null)
  556.             {
  557.                 System.Runtime.InteropServices.Marshal.ReleaseComObject(pComObj);
  558.             }
  559.         }
  560.         catch
  561.         {
  562.         }
  563.         finally
  564.         {
  565.             pComObj = null;
  566.         }
  567.     }
  568.     protected void Button2_Click(object sender, EventArgs e)
  569.     {
  570.         int flag = 0;
  571.         getnum();
  572.         getexcel();
  573.         flag = download(str_name ,str_path);
  574.     }
  575.  
  576.     protected void DropDf_type_SelectedIndexChanged(object sender, EventArgs e)
  577.     {
  578.         if (DropDf_type.SelectedValue.ToString().Equals("1"))
  579.         {
  580.             Label6.Enabled = false;
  581.             TxtEmp_no.Enabled = false;
  582.             DrpDownType.Enabled = true;
  583.             Label2.Enabled = true;
  585.         }
  586.         else
  587.         {
  588.             Label6.Enabled = true;
  589.             TxtEmp_no.Enabled = true;
  590.             DrpDownType.Enabled = false;
  591.             Label2.Enabled = false;
  592.         }
  593.     }
  594.     public int download(string str_name,string str_path)
  595.     {
  596.         try
  597.         {
  598.             string FullFileName = Server.MapPath(str_path) + str_name; 
  599.             FileInfo DownloadFile = new FileInfo(FullFileName);
  600.             Response.Clear();
  601.             Response.ClearHeaders();
  602.             Response.Buffer = false;
  603.             Response.ContentType = "application/octet-stream";
  604.             Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(DownloadFile.FullName, System.Text.Encoding.UTF8));
  605.             Response.AppendHeader("Content-Length", DownloadFile.Length.ToString());
  606.             Response.WriteFile(DownloadFile.FullName);
  607.             Response.Flush();
  608.             Response.End();
  609.             return 1;
  610.         }
  612.         catch (Exception ex)
  613.         {
  614.             Response.Write(ex.Message);
  615.             return 0;
  616.         }
  617.     }
  618.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  619.     {
  620.         if (Calendar1.Visible == true)
  621.         {
  622.             Calendar1.Visible = false;
  623.         }
  624.         else
  625.         {
  626.             Calendar1.Visible = true;
  627.         }
  628.     }
  629.     protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
  630.     {
  631.         if (Calendar2.Visible == true)
  632.         {
  633.             Calendar2.Visible = false;
  634.         }
  635.         else
  636.         {
  637.             Calendar2.Visible = true;
  638.         }
  639.     }
  640.     protected void Calendar1_SelectionChanged(object sender, EventArgs e)
  641.     {
  642.         string year = Calendar1.SelectedDate.Year.ToString();
  643.         string month = Calendar1.SelectedDate.Month.ToString();
  644.         if (month.Length == 1)
  645.         {
  646.             month = "0" + month;
  647.         }
  648.         string day = Calendar1.SelectedDate.Day.ToString();
  649.         if (day.Length == 1)
  650.         {
  651.             day = "0" + day;
  652.         }
  654.         TxtBeginTime.Text = year + "-" + month + "-" + day;
  655.         Calendar1.Visible = false;
  656.     }
  657.     protected void Calendar2_SelectionChanged(object sender, EventArgs e)
  658.     {
  659.         string year = Calendar2.SelectedDate.Year.ToString();
  660.         string month = Calendar2.SelectedDate.Month.ToString();
  661.         if (month.Length == 1)
  662.         {
  663.             month = "0" + month;
  664.         }
  665.         string day = Calendar2.SelectedDate.Day.ToString();
  666.         if (day.Length == 1)
  667.         {
  668.             day = "0" + day;
  669.         }
  671.         TxtEndTime.Text = year + "-" + month + "-" + day;
  672.         Calendar2.Visible = false;
  673.     }
  674.     public void is_ok() 
  675.     {
  676.         if (Table1.Visible = false)
  677.         {
  678.             Button2.Enabled = false;
  679.         }
  680.         else { Button2.Enabled = true; }
  681.     }
  682. }