employee_where.aspx.cs
上传用户:xrffrp
上传日期:2022-03-25
资源大小:22155k
文件大小:22k
源码类别:

OA系统

开发平台:

ASP/ASPX

  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 System.Drawing;
  13. public partial class web_approvel_employee_where : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         if (!IsPostBack)
  18.         {
  19.             LoginDAO.CheckLogin(Session, Response, "../", 2);
  20.             if (Request.QueryString["e_id"] != null)
  21.             {              
  22.                 string id = Request.QueryString["e_id"];
  23.                 this.SetTable(id);
  24.                 this.SetTable1();
  25.                 WorkTime.DataKeyNames = new string[] { "id" };
  26.                
  27.             } 
  28.             if (Request.QueryString["state_type"] != null && Request["type_id"] != null)
  29.             {
  30.                 string type_id = Request.QueryString["type_id"]; ;
  31.                 int type = Convert.ToInt32(Request.QueryString["state_type"]);
  32.                 if (type == 1)
  33.                 {
  34.                     PnlForm1.Visible = true;
  35.                     this.SetForm1(type_id);
  36.                 }
  37.                 if (type == 2)
  38.                 {
  39.                     PnlForm2.Visible = true;
  40.                     this.SetForm2(type_id);
  41.                 }
  42.                 if (type == 3)
  43.                 {
  44.                     PnlForm3.Visible = true;
  45.                     this.SetForm3(type_id);
  46.                 }
  47.             }
  48.         }
  49.     }
  50.     protected void SetTable(string id)
  51.     {
  52.         SqlConnection conn = dbConnection.getConnection();
  53.         conn.Open();
  54.         SqlCommand cmd = new SqlCommand("select d.name department, e.emp_name,e.emp_no,e.email_work, p.name position, e.tel_extension, e.tel, "+
  55.             "e.smart_phone from OA_EMPLOYEE e inner join OA_EMPLOYEE_POSITION p on p.id=e.position inner join "+
  56.             "OA_DEPARTMENT d on e.department_id=d.id where  e.id="+id, conn);
  57.         SqlDataReader dr = cmd.ExecuteReader();
  58.         TableRow tr = new TableRow();
  59.         TableCell td = new TableCell();
  60.         if (dr.Read())
  61.         {
  62.             
  63.             td.BorderWidth = Unit.Pixel(1);
  64.             td.Text = dr["department"].ToString();
  65.             tr.Cells.Add(td);
  66.             td = new TableCell();
  67.             td.BorderWidth = Unit.Pixel(1);
  68.             td.Text = dr["emp_name"].ToString();
  69.             tr.Cells.Add(td);
  70.             td = new TableCell();
  71.             td.BorderWidth = Unit.Pixel(1);
  72.             td.Text = dr["emp_no"].ToString();
  73.             tr.Cells.Add(td);
  74.             td = new TableCell();
  75.             td.BorderWidth = Unit.Pixel(1);
  76.             td.Text = dr["position"].ToString();
  77.             tr.Cells.Add(td);
  78.             td = new TableCell();
  79.             td.BorderWidth = Unit.Pixel(1);
  80.             td.Text = dr["tel_extension"].ToString();
  81.             if (td.Text.Equals(""))
  82.             {
  83.                 td.Text = " ";
  84.             }
  85.             tr.Cells.Add(td);
  86.             td = new TableCell();
  87.             td.BorderWidth = Unit.Pixel(1);
  88.             td.Text = dr["tel"].ToString();
  89.             if (td.Text.Equals(""))
  90.             {
  91.                 td.Text = " ";
  92.             }
  93.             tr.Cells.Add(td);           
  94.             td = new TableCell();
  95.             td.BorderWidth = Unit.Pixel(1);
  96.             td.Text = dr["smart_phone"].ToString();
  97.             if (td.Text.Equals(""))
  98.             {
  99.                 td.Text = " ";
  100.             }
  101.             tr.Cells.Add(td);
  102.             td = new TableCell();
  103.             td.BorderWidth = Unit.Pixel(1);
  104.             td.Text = dr["email_work"].ToString();
  105.             if (td.Text.Equals(""))
  106.             {
  107.                 td.Text = " ";
  108.             }
  109.             tr.Cells.Add(td);
  110.                 
  111.             //狀態
  112.             
  113.             TblWhere.Rows.Add(tr);
  114.         }
  115.         dr.Close();
  116.        
  117.         conn.Close();
  118.     }
  119.  
  120.     protected void WorkTime_RowCreated(object sender, GridViewRowEventArgs e)
  121.     {
  122.         //行高亮
  123.         if (e.Row.RowType == DataControlRowType.DataRow)
  124.         {
  125.             DateMgr mgr = new DateMgr();
  126.             User user = (User)Session["user"];
  127.             SqlConnection conn = dbConnection.getConnection();
  128.             conn.Open();
  129.             SqlCommand cmd = new SqlCommand("select * from oa_ch_off_type where id=1", conn);
  130.             cmd.ExecuteScalar();
  131.             if (Request.QueryString["date"] != null)
  132.             {
  133.                 cmd = new SqlCommand("select card_id,zao,wan,wuxia,wushang,data,the_day from time_demo as c left join oa_kaoqin_jl  as a on c.the_date=a.data" +
  134.                   " left join" +
  135.                   " oa_employee as b on a.card_id=b.work_card_no1 where b.id=" + Request.QueryString["e_id"] +
  136.                   " and a.id=" + WorkTime.DataKeys[e.Row.RowIndex].Value.ToString() + " and substring(data,0,8)='" + Request.QueryString["date"] +
  137.                   "' order by data desc ", conn);
  138.             }
  139.             else
  140.             {
  141.                 cmd = new SqlCommand("select card_id,zao,wan,wuxia,wushang,data,the_day from time_demo as c left join  oa_kaoqin_jl as a on c.the_date=a.data" +
  142.                        " left join" +
  143.                        " oa_employee as b on  a.card_id=b.work_card_no1 where b.id=" + Request.QueryString["e_id"] +
  144.                        " and a.id=" + WorkTime.DataKeys[e.Row.RowIndex].Value.ToString() + " and substring(data,0,8)='" + mgr.getTime() +
  145.                        "' order by data desc ", conn);
  146.             }
  147.             SqlDataReader dr = cmd.ExecuteReader();
  148.             while (dr.Read())
  149.             {
  150.                 Label label0 = (Label)e.Row.FindControl("Labzao");
  151.                 Label label5 = (Label)e.Row.FindControl("Labwuxia");
  152.                 Label label2 = (Label)e.Row.FindControl("Labwushang");
  153.                 Label label3 = (Label)e.Row.FindControl("Labwan");
  154.                 Label lable4 = (Label)e.Row.FindControl("Labdate");
  155.                 /*if (dr["card_status"].Equals("1"))
  156.                 {
  157.                     label0.Text = "正常";
  158.                 }
  159.                 else if (dr["card_status"].Equals("2"))
  160.                 {
  161.                     label0.Text = "異常";
  162.                     label0.ForeColor = Color.Red;
  163.                 }*/
  164.                 if (!dr["the_day"].ToString().Equals("星期日"))
  165.                 {
  166.                     if (!dr["zao"].ToString().Equals(""))
  167.                     {
  168.                         if (dr["zao"].ToString().Length == 6)
  169.                         {
  170.                             label0.Text = dr["zao"].ToString().Substring(0, 2) + ":" + dr["zao"].ToString().Substring(2, 2) + ":" + dr["zao"].ToString().Substring(4, 2);
  171.                         }
  172.                         else if (dr["zao"].ToString().Length == 5)
  173.                         {
  174.                             label0.Text = "0" + dr["zao"].ToString().Substring(0, 1) + ":" + dr["zao"].ToString().Substring(1, 2) + ":" + dr["zao"].ToString().Substring(3, 2);
  175.                         }
  176.                         //  label0.Text ="0:"+ dr["zao"].ToString().Substring(0, 2) + ":" + dr["zao"].ToString().Substring(2, 2) + ":" + dr["zao"].ToString().Substring(4, 2);
  177.                     }
  178.                     if (!dr["wuxia"].ToString().Equals(""))
  179.                     { label5.Text = dr["wuxia"].ToString().Substring(0, 2) + ":" + dr["wuxia"].ToString().Substring(2, 2) + ":" + dr["wuxia"].ToString().Substring(4, 2); }
  180.                     if (!dr["wushang"].ToString().Equals(""))
  181.                     { label2.Text = dr["wushang"].ToString().Substring(0, 2) + ":" + dr["wushang"].ToString().Substring(2, 2) + ":" + dr["wushang"].ToString().Substring(4, 2); }
  182.                     if (!dr["wan"].ToString().Equals(""))
  183.                     { label3.Text = dr["wan"].ToString().Substring(0, 2) + ":" + dr["wan"].ToString().Substring(2, 2) + ":" + dr["wan"].ToString().Substring(4, 2); }
  184.                     if (!dr["data"].ToString().Equals(""))
  185.                     {
  186.                         lable4.Text = dr["data"].ToString().Substring(8, 2);
  187.                     }
  188.                 }
  189.                else
  190.                {
  191.                    if (!dr["zao"].ToString().Equals(""))
  192.                    {
  193.                        if (dr["zao"].ToString().Length == 6)
  194.                        {
  195.                            label0.Text = dr["zao"].ToString().Substring(0, 2) + ":" + dr["zao"].ToString().Substring(2, 2) + ":" + dr["zao"].ToString().Substring(4, 2);
  196.                            label0.ForeColor = Color.Crimson;
  197.                        }
  198.                        else if (dr["zao"].ToString().Length == 5)
  199.                        {
  200.                            label0.Text = "0" + dr["zao"].ToString().Substring(0, 1) + ":" + dr["zao"].ToString().Substring(1, 2) + ":" + dr["zao"].ToString().Substring(3, 2);
  201.                            label0.ForeColor = Color.Crimson;
  202.                        }
  203.                        //  label0.Text ="0:"+ dr["zao"].ToString().Substring(0, 2) + ":" + dr["zao"].ToString().Substring(2, 2) + ":" + dr["zao"].ToString().Substring(4, 2);
  204.                    }
  205.                    else { label0.Text = "--------------"; label0.ForeColor = Color.Crimson; }
  206.                    if (!dr["wuxia"].ToString().Equals(""))
  207.                    {
  208.                        label5.Text = dr["wuxia"].ToString().Substring(0, 2) + ":" + dr["wuxia"].ToString().Substring(2, 2) + ":" + dr["wuxia"].ToString().Substring(4, 2);
  209.                        label5.ForeColor = Color.Crimson;
  210.                    }
  211.                    else { label5.Text = "--------------"; label5.ForeColor = Color.Crimson; }
  212.                    if (
  213.                        !dr["wushang"].ToString().Equals(""))
  214.                    { 
  215.                        label2.Text = dr["wushang"].ToString().Substring(0, 2) + ":" + dr["wushang"].ToString().Substring(2, 2) + ":" + dr["wushang"].ToString().Substring(4, 2);
  216.                        label2.ForeColor = Color.Crimson;
  217.                    }
  218.                    else { label2.Text = "--------------"; label2.ForeColor = Color.Crimson; }
  219.                    if (
  220.                        !dr["wan"].ToString().Equals(""))
  221.                    { 
  222.                        label3.Text = dr["wan"].ToString().Substring(0, 2) + ":" + dr["wan"].ToString().Substring(2, 2) + ":" + dr["wan"].ToString().Substring(4, 2);
  223.                        label3.ForeColor = Color.Crimson;
  224.                    }
  225.                    else { label3.Text = "--------------"; label3.ForeColor = Color.Crimson; }
  226.                    if (!dr["data"].ToString().Equals(""))
  227.                    {
  228.                        lable4.Text = dr["data"].ToString().Substring(8, 2);
  229.                        lable4.ForeColor = Color.Crimson;
  230.                    }
  231.                    // label0.BackColor = Color.SkyBlue;
  232.                    
  233.                    // label5.BackColor = Color.Red;
  234.                     
  235.                    // label2.BackColor = Color.Red;
  236.                     
  237.                    // label3.BackColor = Color.Red;
  238.                    
  239.                   
  240.                 
  241.                 }
  242.             }
  243.         }
  244.     }
  245.   
  246.     protected void SetTable1()
  247.     {
  248.         SqlConnection conn = dbConnection.getConnection();
  249.         conn.Open();
  250.         int flag = 0;
  251.         SqlCommand cmd = new SqlCommand("select top 12 substring(data,0,8) as a from oa_kaoqin_jl  group by substring(data,0,8) order by a desc", conn);
  252.         SqlDataReader dr = cmd.ExecuteReader();
  253.         while (dr.Read())
  254.         {
  255.             flag = 1;
  256.             //動態創建表格行
  257.             TableRow tr1 = new TableRow();
  258.             TableCell td1 = new TableCell();
  259.             td1.BorderWidth = Unit.Pixel(1);
  260.             HyperLink hl = new HyperLink();
  261.             hl.Text = dr["a"].ToString();
  262.           //  hl.ForeColor = Color.LightBlue;
  263.           //  hl.Attributes.Add("onclick", "location.href=employee_where.aspx?date=" + dr["a"].ToString() + "&e_id=" + Request.QueryString["e_id"].ToString());
  264.             hl.NavigateUrl = "employee_where.aspx?date="+dr["a"].ToString()+"&e_id="+Request.QueryString["e_id"].ToString();
  265.             td1.Controls.Add(hl);
  266.             tr1.Cells.Add(td1);
  267.             Tabdate.Rows.Add(tr1);
  268.         }
  269.         dr.Close();
  270.         conn.Close();
  271.         if (flag == 0)
  272.         {
  273.             TblDetail.Visible = false;
  274.         }
  275.     }
  276.    
  277.     protected void SetForm1(string id)
  278.     {
  279.         SqlConnection conn = dbConnection.getConnection();
  280.         conn.Open();
  281.         SqlCommand cmd = new SqlCommand("select a.form_id, e.emp_name, e.emp_no, p.name position, " +
  282.             "d.name department, e1.emp_name delegate, t.name off_type, a.parenthesis, a.days, a.vacation_begin, " +
  283.             "a.vacation_end, vp.name vacation_place, fp1.name flight_go_depart, fp2.name flight_go_arrive, " +
  284.             "a.flight_go_time, a.flight_back_time, fp3.name flight_back_depart, fp4.name flight_back_arrive, " +
  285.             "a.business_begin, a.business_end, a.reason, a.apply_date from OA_TW_APPROVEL_FORM a " +
  286.             "inner join OA_EMPLOYEE e on a.emp_id=e.id " +
  287.             "inner join OA_EMPLOYEE e1 on a.delegate_id=e1.id " +
  288.             "inner join OA_DEPARTMENT d on e.department_id=d.id " +
  289.             "inner join OA_EMPLOYEE_POSITION p on e.position=p.id " +
  290.             "inner join OA_TW_OFF_TYPE t on a.off_type=t.id " +
  291.             "inner join OA_VACATION_PLACE vp on a.vacation_place=vp.id " +
  292.             "inner join OA_FLIGHT_PLACE fp1 on a.flight_go_depart=fp1.id " +
  293.             "inner join OA_FLIGHT_PLACE fp2 on a.flight_go_arrive=fp2.id " +
  294.             "inner join OA_FLIGHT_PLACE fp3 on a.flight_back_depart=fp3.id " +
  295.             "inner join OA_FLIGHT_PLACE fp4 on a.flight_back_arrive=fp4.id where a.id=" + id, conn);
  296.         SqlDataReader dr = cmd.ExecuteReader();
  297.         if (dr.Read())
  298.         {
  299.             TxtFormNo.Text = dr["form_id"].ToString();
  300.             TxtEmpName.Text = dr["emp_name"].ToString();
  301.             TxtEmpNo.Text = dr["emp_no"].ToString();
  302.             TxtPosition.Text = dr["position"].ToString();
  303.             TxtDepartment.Text = dr["department"].ToString();
  304.             TxtDelegate.Text = dr["delegate"].ToString();
  305.             TxtOffType.Text = dr["off_type"].ToString();
  306.             TxtParenthesis.Text = dr["parenthesis"].ToString();
  307.             TxtDays.Text = dr["days"].ToString();
  308.             TxtVacationBegin.Text = dr["vacation_begin"].ToString();
  309.             TxtVacationEnd.Text = dr["vacation_end"].ToString();
  310.             TxtVacationPlace.Text = dr["vacation_place"].ToString();
  311.             TxtFlightGoDepart.Text = dr["flight_go_depart"].ToString();
  312.             TxtFlightGoArrive.Text = dr["flight_go_arrive"].ToString();
  313.             TxtFlightGoTime.Text = dr["flight_go_time"].ToString();
  314.             TxtFlightBackTime.Text = dr["flight_back_time"].ToString();
  315.             TxtFlightBackDepart.Text = dr["flight_back_depart"].ToString();
  316.             TxtFlightBackArrive.Text = dr["flight_back_arrive"].ToString();
  317.             TxtBusinessBegin.Text = dr["business_begin"].ToString();
  318.             TxtBusinessEnd.Text = dr["business_end"].ToString();
  319.             TxtReason.Text = dr["reason"].ToString();
  320.             TxtApplyDate.Text = dr["apply_date"].ToString();
  321.         }
  322.         dr.Close();
  323.         conn.Close();
  324.     }
  325.     protected void SetForm2(string id)
  326.     {
  327.         SqlConnection conn = dbConnection.getConnection();
  328.         conn.Open();
  329.         SqlCommand cmd = new SqlCommand("select a.form_id, e.emp_name, e.emp_no, p.name position, a.apply_date," +
  330.             "d.name department, a.days, a.begin_time, a.end_time, depart_place,  arrive_place, " +
  331.             "a.depart_time, a.arrive_time from OA_CH_BUSINESS_FORM a inner join OA_EMPLOYEE e on a.emp_id=e.id " +
  332.             "inner join OA_DEPARTMENT d on a.department_id=d.id inner join OA_EMPLOYEE_POSITION p on " +
  333.             "e.position=p.id  where a.id=" + id, conn);
  334.         SqlDataReader dr = cmd.ExecuteReader();
  335.         if (dr.Read())
  336.         {
  337.             TxtBFormId.Text = dr["form_id"].ToString();
  338.             TxtBEmpName.Text = dr["emp_name"].ToString();
  339.             TxtBEmpNo.Text = dr["emp_no"].ToString();
  340.             TxtBPosition.Text = dr["position"].ToString();
  341.             TxtBApplyDate.Text = dr["apply_date"].ToString();
  342.             TxtBDepartment.Text = dr["department"].ToString();
  343.             TxtBDays.Text = dr["days"].ToString();
  344.             TxtBBeginTime.Text = dr["begin_time"].ToString();
  345.             TxtBEndTime.Text = dr["end_time"].ToString();
  346.             TxtBDepartPlace.Text = dr["depart_place"].ToString();
  347.             TxtBArrivePlace.Text = dr["arrive_place"].ToString();
  348.             TxtBDepartTime.Text = dr["depart_time"].ToString();
  349.             TxtBArriveTime.Text = dr["arrive_time"].ToString();
  350.         }
  351.         dr.Close();
  352.         int flag = 0;
  353.         //動態創建表格行
  354.         #region
  355.         cmd = new SqlCommand("select * from OA_CH_BUSINESS_DETAIL where form_id=" + id +
  356.              " order by number", conn);
  357.         dr = cmd.ExecuteReader();
  358.         while (dr.Read())
  359.         {
  360.             flag = 1;
  361.             //動態創建表格行
  362.             TableRow tr1 = new TableRow();
  363.             TableCell td1 = new TableCell();
  364.             td1.BorderWidth = Unit.Pixel(1);
  365.             Label label = new Label();
  366.             label.BorderStyle = BorderStyle.None;
  367.             label.Text = dr["number"].ToString();
  368.             td1.Controls.Add(label);
  369.             tr1.Cells.Add(td1);
  370.             TableCell td2 = new TableCell();
  371.             td2.BorderWidth = Unit.Pixel(1);
  372.             label = new Label();
  373.             label.BorderStyle = BorderStyle.None;
  374.             label.Text = dr["date"].ToString();
  375.             td2.Controls.Add(label);
  376.             tr1.Cells.Add(td2);
  377.             TableCell td3 = new TableCell();
  378.             td3.BorderWidth = Unit.Pixel(1);
  379.             label = new Label();
  380.             label.BorderStyle = BorderStyle.None;
  381.             label.Text = dr["d_start"].ToString();
  382.             td3.Controls.Add(label);
  383.             tr1.Cells.Add(td3);
  384.             TableCell td4 = new TableCell();
  385.             td4.BorderWidth = Unit.Pixel(1);
  386.             label = new Label();
  387.             label.BorderStyle = BorderStyle.None;
  388.             label.Text = dr["d_end"].ToString();
  389.             td4.Controls.Add(label);
  390.             tr1.Cells.Add(td4);
  391.             TableCell td5 = new TableCell();
  392.             td5.BorderWidth = Unit.Pixel(1);
  393.             label = new Label();
  394.             label.BorderStyle = BorderStyle.None;
  395.             label.Text = dr["tool"].ToString();
  396.             td5.Controls.Add(label);
  397.             tr1.Cells.Add(td5);
  398.             TableCell td6 = new TableCell();
  399.             td6.BorderWidth = Unit.Pixel(1);
  400.             label = new Label();
  401.             label.BorderStyle = BorderStyle.None;
  402.             label.Text = dr["content"].ToString();
  403.             td6.Controls.Add(label);
  404.             tr1.Cells.Add(td6);
  405.             TableCell td7 = new TableCell();
  406.             td7.BorderWidth = Unit.Pixel(1);
  407.             label = new Label();
  408.             label.BorderStyle = BorderStyle.None;
  409.             label.Text = dr["remark"].ToString();
  410.             td7.Controls.Add(label);
  411.             tr1.Cells.Add(td7);
  412.             TblDetail.Rows.Add(tr1);
  413.         }
  414.         dr.Close();
  415.         conn.Close();
  416.         if (flag == 0)
  417.         {
  418.             TblDetail.Visible = false;
  419.         }
  420.         #endregion
  421.     }
  422.     protected void SetForm3(string id)
  423.     {
  424.         SqlConnection conn = dbConnection.getConnection();
  425.         conn.Open();
  426.         SqlCommand cmd = new SqlCommand("select o.form_id, e.emp_no, e.emp_name, d.name department, " +
  427.             "e.emp_name delegate, e.position position, " +
  428.             "t.name off_type, o.begin_time, o.end_time, o.hours, o.apply_date, o.parenthesis, " +
  429.             "o.reason from OA_CH_OFF_FORM o inner join OA_EMPLOYEE e on o.emp_id=e.id inner join " +
  430.             "OA_DEPARTMENT d on o.department_id=d.id inner join OA_CH_OFF_TYPE t on " +
  431.             "o.off_type=t.id where o.id=" + id, conn);
  432.         SqlDataReader dr = cmd.ExecuteReader();
  433.         if (dr.Read())
  434.         {
  435.             TxtOFormId.Text = dr["form_id"].ToString();
  436.             TxtOEmpName.Text = dr["emp_no"].ToString() + dr["emp_name"].ToString();
  437.             TxtODepartment.Text = dr["department"].ToString();
  438.             TxtODelegate.Text = dr["delegate"].ToString();
  439.             TxtOPosition.Text = dr["position"].ToString();
  440.             TxtOOffType.Text = dr["off_type"].ToString();
  441.             TxtOBeginTime.Text = dr["begin_time"].ToString();
  442.             TxtOEndTime.Text = dr["end_time"].ToString();
  443.             TxtOHours.Text = dr["hours"].ToString();
  444.             TxtOApplyDate.Text = dr["apply_date"].ToString();
  445.             TxtOParenthesis.Text = dr["parenthesis"].ToString();
  446.             TxtOReason.Text = dr["reason"].ToString();
  447.         }
  448.         dr.Close();
  449.         conn.Close();
  450.     }
  451.     protected void BtnHistory_Click(object sender, EventArgs e)
  452.     {
  453.         if (Request.QueryString["e_id"] != null)
  454.         {
  455.             Response.Redirect("../personnel/curricula_vitae/employee_where.aspx?e_id="+Request.QueryString["e_id"]);
  456.         } 
  457.     }
  458.    /* protected void Button1_Click(object sender, EventArgs e)
  459.     {
  460.         //Work_time.Visible = true;
  461.         GridView1.Visible = false;
  462.     }
  463.     protected void Button2_Click(object sender, EventArgs e)
  464.     {
  465.         //Work_time.Visible = false;
  466.         GridView1.Visible = true;
  467.     }*/
  468. }