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

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

OA系统

开发平台：

ASP/ASPX

Default3.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_Default3 : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         string nul = " 256";
  18.         SqlConnection conn1 = dbConnection.getConnection();
  19.         conn1.Open();
  20.         SqlCommand sqlcom5 = new SqlCommand("select banbie from OA_KAOQIN_PBB where data='2009-01-14' and emp_no='08b234'", conn1);
  21.         SqlDataReader comm5 = sqlcom5.ExecuteReader();
  22.         if (comm5 != null)
  23.         {
  24.             while (comm5.Read())
  25.             {
  26.                 TableRow tr4 = new TableRow();
  27.                 TableCell d3 = new TableCell();
  28.                 d3.BorderWidth = Unit.Pixel(1);
  29.                 Label label4 = new Label();
  30.                 label4.BorderStyle = BorderStyle.None;
  31.                 label4.Text = Convert.ToString(comm5["banbie"]);
  32.                 d3.Controls.Add(label4);
  33.                 tr4.Cells.Add(d3);
  35.                 SqlConnection conn2 = dbConnection.getConnection();
  36.                 conn2.Open();
  37.                 SqlCommand sqlcom6 = new SqlCommand("select bengin_time,end_time from oa_pos_type where department='怡豐店' and type='" + Convert.ToString(comm5["banbie"]) + "'", conn2);
  38.                 SqlDataReader comm6 = sqlcom6.ExecuteReader();
  39.                 if (comm6.HasRows)
  40.                 {
  41.                     while (comm6.Read())
  42.                     {
  44.                         TableCell d4 = new TableCell();
  45.                         d4.BorderWidth = Unit.Pixel(2);
  46.                         Table table3 = new Table();
  47.                         table3.BorderWidth = Unit.Pixel(2);
  48.                         TableRow trr1 = new TableRow();
  49.                         TableCell tt1 = new TableCell();
  50.                         tt1.BorderWidth = Unit.Pixel(1);
  51.                         Label label6 = new Label();
  52.                         label6.BorderStyle = BorderStyle.None;
  53.                         label6.Text = Convert.ToString(comm6["bengin_time"]);
  54.                         tt1.Controls.Add(label6);
  55.                         trr1.Cells.Add(tt1);
  57.                         TableCell tt2 = new TableCell();
  58.                         tt2.BorderWidth = Unit.Pixel(1);
  59.                         Label label5 = new Label();
  60.                         label5.BorderStyle = BorderStyle.None;
  61.                         label5.Text = Convert.ToString(comm6["end_time"]);
  62.                         tt2.Controls.Add(label5);
  63.                         trr1.Cells.Add(tt2);
  64.                         table3.Rows.Add(trr1);
  65.                         d4.Controls.Add(table3);
  66.                         tr4.Cells.Add(d4);
  67.                     }
  68.                 }
  69.                 else
  70.                 {
  71.                         TableCell d4 = new TableCell();
  72.                         d4.BorderWidth = Unit.Pixel(2);
  73.                         d4.Visible = true;
  74.                         Table table3 = new Table();
  75.                         table3.BorderWidth = Unit.Pixel(2);
  76.                         TableRow trr1 = new TableRow();
  77.                         TableCell tt1 = new TableCell();
  78.                         Label label6 = new Label();
  79.                         label6.BorderStyle = BorderStyle.None;
  80.                         label6.Text = " ";
  81.                         tt1.Controls.Add(label6);
  82.                         trr1.Cells.Add(tt1);
  84.                         TableCell tt2 = new TableCell();
  85.                         tt2.BorderWidth = Unit.Pixel(1);
  86.                         Label label5 = new Label();
  87.                         label5.BorderStyle = BorderStyle.None;
  88.                         label5.Text = "";
  89.                         tt2.Controls.Add(label5);
  90.                         trr1.Cells.Add(tt2);
  91.                         table3.Rows.Add(trr1);
  92.                         d4.Controls.Add(table3);
  93.                         tr4.Cells.Add(d4);
  94.                 }
  95.                     Table1.Rows.Add(tr4);
  96.                     comm6.Close();
  97.                     conn2.Close();
  98.                 }
  100.             
  101.         }
  102.         comm5.Close();
  103.         conn1.Close();
  104.     }
  105. }