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

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

OA系统

开发平台：

ASP/ASPX

approvel_select.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;
  13. public partial class web_fair_approvel_select : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         if (!IsPostBack)
  18.         {
  19.             this.SetTable();
  20.         }
  21.     }
  22.     protected void SetTable()
  23.     {
  24.         int user_id = 0;
  25.         if (Session["user_id"] != null)
  26.         {
  27.             user_id = Convert.ToInt32(Session["user_id"]);
  28.         }
  30.         if (user_id != 0)
  31.         {
  33.             SqlConnection conn = dbConnection.getConnection();
  34.             conn.Open();
  36.             int flag = 0;
  38.             SqlCommand cmd = new SqlCommand("select f.id, f.form_id, f.vacation_begin, f.vacation_end, " +
  39.                 "f.business_begin, f.business_end, t.name type, f.vacation_place from OA_TW_APPROVEL_FORM f " +
  40.                 "inner join OA_TW_OFF_TYPE t on f.off_type=t.id where emp_id=" + user_id + " order by form_id desc", conn);
  41.             SqlDataReader dr = cmd.ExecuteReader();
  42.             while (dr.Read())
  43.             {
  44.                 flag = 1;
  45.                 TableRow tr = new TableRow();
  46.                 TableCell td = new TableCell();
  47.                 td.BorderWidth = Unit.Pixel(1);
  48.                 CheckBox chk = new CheckBox();
  49.                 chk.ID = dr["id"].ToString() + "-" + dr["form_id"].ToString() + "-" + "OA_TW_APPROVEL_FORM";
  50.                 td.Controls.Add(chk);
  51.                 tr.Cells.Add(td);
  53.                 td = new TableCell();
  54.                 td.BorderWidth = Unit.Pixel(1);
  55.                 td.Text = dr["form_id"].ToString();
  56.                 tr.Cells.Add(td);
  58.                 td = new TableCell();
  59.                 td.BorderWidth = Unit.Pixel(1);
  60.                 td.Text = dr["type"].ToString();
  61.                 tr.Cells.Add(td);
  63.                 if (dr["type"].ToString().Equals("出差"))
  64.                 {
  65.                     td = new TableCell();
  66.                     td.BorderWidth = Unit.Pixel(1);
  67.                     td.Text = dr["business_begin"].ToString();
  68.                     tr.Cells.Add(td);
  70.                     td = new TableCell();
  71.                     td.BorderWidth = Unit.Pixel(1);
  72.                     td.Text = dr["business_end"].ToString();
  73.                     tr.Cells.Add(td);
  74.                 }
  75.                 else
  76.                 {
  77.                     td = new TableCell();
  78.                     td.BorderWidth = Unit.Pixel(1);
  79.                     td.Text = dr["vacation_begin"].ToString();
  80.                     tr.Cells.Add(td);
  82.                     td = new TableCell();
  83.                     td.BorderWidth = Unit.Pixel(1);
  84.                     td.Text = dr["vacation_end"].ToString();
  85.                     tr.Cells.Add(td);
  86.                 }
  87.                 TblForm.Rows.Add(tr);
  88.             }
  89.             dr.Close();
  91.             if (flag == 0)
  92.             {
  93.                 cmd = new SqlCommand("select id, form_id, begin_time, end_time from OA_CH_BUSINESS_FORM " +
  94.                     "where emp_id=" + user_id + " order by form_id desc", conn);
  95.                 dr = cmd.ExecuteReader();
  96.                 while (dr.Read())
  97.                 {
  98.                     flag = 1;
  99.                     TableRow tr = new TableRow();
  101.                     TableCell td = new TableCell(); 
  102.                     td.BorderWidth = Unit.Pixel(1);
  103.                     CheckBox chk = new CheckBox();
  104.                     chk.ID = dr["id"].ToString() + "-" + dr["form_id"].ToString() + "-" + "OA_CH_BUSINESS_FORM";
  105.                     td.Controls.Add(chk);
  106.                     tr.Cells.Add(td);
  108.                     td = new TableCell();
  109.                     td.BorderWidth = Unit.Pixel(1);
  110.                     td.Text = dr["form_id"].ToString();
  111.                     tr.Cells.Add(td);
  113.                     td = new TableCell();
  114.                     td.BorderWidth = Unit.Pixel(1);
  115.                     td.Text = "出差";
  116.                     tr.Cells.Add(td);
  118.                     td = new TableCell();
  119.                     td.BorderWidth = Unit.Pixel(1);
  120.                     td.Text = dr["begin_time"].ToString();
  121.                     tr.Cells.Add(td);
  123.                     td = new TableCell();
  124.                     td.BorderWidth = Unit.Pixel(1);
  125.                     td.Text = dr["end_time"].ToString();
  126.                     tr.Cells.Add(td);
  128.                     TblForm.Rows.Add(tr);
  129.                 }
  130.                 dr.Close();
  132.                 cmd = new SqlCommand("select f.id, f.form_id, t.name type, f.begin_time, f.end_time from " +
  133.                     "OA_CH_OFF_FORM f inner join OA_CH_OFF_TYPE t on f.off_type=t.id where emp_id=" + user_id +
  134.                     " order by f.form_id", conn);
  135.                 dr = cmd.ExecuteReader();
  136.                 while (dr.Read())
  137.                 {
  138.                     flag = 1;
  139.                     TableRow tr = new TableRow();
  141.                     TableCell td = new TableCell();
  142.                     td.BorderWidth = Unit.Pixel(1);
  143.                     CheckBox chk = new CheckBox();
  144.                     chk.ID = dr["id"].ToString() + "-" + dr["form_id"].ToString() + "-" + "OA_CH_OFF_FORM";
  145.                     td.Controls.Add(chk);
  146.                     tr.Cells.Add(td);
  148.                     td = new TableCell();
  149.                     td.BorderWidth = Unit.Pixel(1);
  150.                     td.Text = dr["form_id"].ToString();
  151.                     tr.Cells.Add(td);
  153.                     td = new TableCell();
  154.                     td.BorderWidth = Unit.Pixel(1);
  155.                     td.Text = dr["type"].ToString();
  156.                     tr.Cells.Add(td);
  158.                     td = new TableCell();
  159.                     td.BorderWidth = Unit.Pixel(1);
  160.                     td.Text = dr["begin_time"].ToString();
  161.                     tr.Cells.Add(td);
  163.                     td = new TableCell();
  164.                     td.BorderWidth = Unit.Pixel(1);
  165.                     td.Text = dr["end_time"].ToString();
  166.                     tr.Cells.Add(td);
  167.                     TblForm.Rows.Add(tr);
  168.                 }
  169.                 dr.Close();
  170.             }
  172.             if (flag == 0)
  173.             {
  174.                 TblForm.Visible = false;
  175.             }
  177.             conn.Close();
  178.         }
  179.     }
  180. }