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

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

OA系统

开发平台：

ASP/ASPX

finish_list.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;
  13. public partial class web_equipment_finish_list : 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.             GridView1.DataKeyNames = new string[] { "form_id" };
  21.         }
  22.         if (Request.QueryString["form_id"] != null)
  23.         {
  24.             this.SetData(Request.QueryString["form_id"]);
  25.             this.SetTable(Request.QueryString["form_id"]);
  26.         }
  27.     }
  28.     public void SetData(string id)
  29.     {
  30.         MultiView2.ActiveViewIndex = 0;
  31.         GridView2.Visible = true;
  32.         Label3.Text = id;
  33.     }
  34.     public void SetTable(string id)
  35.     {
  36.         SqlConnection conn = dbConnection.getConnection();
  37.         conn.Open();
  38.         SqlCommand cmd = new SqlCommand("select operator_id,is_check,is_agree,comment,check_date,step from oa_equipment_flow where form_id='" + id + "'", conn);
  39.         SqlDataReader dr = cmd.ExecuteReader();
  40.         if (dr.HasRows)
  41.         {
  42.             while (dr.Read())
  43.             {
  44.                 TableRow tr = new TableRow();
  45.                 TableCell td = new TableCell();
  46.                 td.BorderWidth = Unit.Pixel(1);
  47.                 td.Text = dr["step"].ToString();
  48.                 tr.Cells.Add(td);
  50.                 td = new TableCell();
  51.                 td.BorderWidth = Unit.Pixel(1);
  52.                 SqlConnection conn1 = dbConnection.getConnection();
  53.                 conn1.Open();
  54.                 SqlCommand sqlcom = new SqlCommand("select emp_name from oa_employee where id='" + dr["operator_id"] + "'", conn1);
  55.                 td.Text = sqlcom.ExecuteScalar().ToString();
  56.                 tr.Cells.Add(td);
  58.                 td = new TableCell();
  59.                 td.BorderWidth = Unit.Pixel(1);
  60.                 td.Text = "審批";
  61.                 tr.Cells.Add(td);
  63.                 td = new TableCell();
  64.                 td.BorderWidth = Unit.Pixel(1);
  65.                 if (dr["is_check"].ToString().Equals("N"))
  66.                 {
  67.                     td.Text = "未處理";
  68.                 }
  69.                 else
  70.                 {
  71.                     td.Text = "已處理";
  72.                 }
  73.                 tr.Cells.Add(td);
  75.                 td = new TableCell();
  76.                 td.BorderWidth = Unit.Pixel(1);
  77.                 if (dr["is_check"].ToString().Equals("Y"))
  78.                 {
  79.                     if (dr["is_agree"].ToString().Equals("Y"))
  80.                     {
  81.                         td.Text = "已同意";
  82.                     }
  83.                     else
  84.                     {
  85.                         td.Text = "不同意";
  86.                     }
  87.                 }
  88.                 else
  89.                 {
  90.                     td.Text = "<br>";
  91.                 }
  92.                 tr.Cells.Add(td);
  94.                 td = new TableCell();
  95.                 td.BorderWidth = Unit.Pixel(1);
  96.                 if (!dr["comment"].ToString().Equals(""))
  97.                 {
  98.                     td.Text = dr["comment"].ToString();
  99.                 }
  100.                 else
  101.                 {
  102.                     td.Text = "<br>";
  103.                 }
  104.                 tr.Cells.Add(td);
  106.                 td = new TableCell();
  107.                 td.BorderWidth = Unit.Pixel(1);
  108.                 if (!dr["check_date"].ToString().Equals(""))
  109.                 {
  110.                     td.Text = dr["check_date"].ToString();
  111.                 }
  112.                 else
  113.                 {
  114.                     td.Text = "<br>";
  115.                 }
  116.                 tr.Cells.Add(td);
  117.                 this.FlowTable.Rows.Add(tr);
  118.             }
  119.         }
  120.     }
  121.         protected void ShowMessageBox(string strMessage)
  122.     {
  123.         Response.Write(string.Format("<script>alert('{0}')</script>", strMessage));
  124.     }
  125.     protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
  126.     {
  127.         int i = 0;
  128.         //执行循环，保证每条数据都可以更新
  129.         for (i = 0; i < GridView1.Rows.Count; i++)
  130.         {
  131.             //首先判断是否是数据行
  132.             if (e.Row.RowType == DataControlRowType.DataRow)
  133.             {
  134.                 //当鼠标停留时更改背景色
  135.                 e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
  136.                 //当鼠标移开时还原背景色
  137.                 e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
  138.             }
  139.         }
  140.         if (e.Row.RowType == DataControlRowType.DataRow)
  141.         {
  142.             e.Row.Attributes.Add("onmouseover", "this.style.cursor='pointer';");
  144.             e.Row.Attributes.Add("onclick", "location.href='finish_list.aspx?form_id=" + GridView1.DataKeys[e.Row.RowIndex].Value.ToString() + "'");
  145.         }
  146.     }
  147. }