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

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

OA系统

开发平台：

ASP/ASPX

weather.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 weather : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         if (!IsPostBack)
  18.         {
  19.             bind1();
  20.             bind2();
  21.         }
  22.     }
  23.     public void bind1()
  24.     {
  25.         string department_id = "";
  26.         DateMgr mgr = new DateMgr();
  27.         string today = mgr.getDate();
  28.         DataSet ds = new DataSet();
  29.         DataTable dt = new DataTable();
  30.         dt.Columns.Add("id", typeof(Int32));
  31.         dt.Columns.Add("subject", typeof(string));
  32.         SqlConnection conn = dbConnection.getConnection();
  33.         conn.Open();
  34.         SqlCommand sqlcom1 = new SqlCommand("select department_id from oa_employee where id='"+Session["user_id"]+"'",conn);
  35.         department_id = sqlcom1.ExecuteScalar().ToString();
  36.         SqlCommand sqlcom = new SqlCommand("select  id,subject,authority from OA_ANNOUNCEMENT  where validate_date >='" + today + "' and is_del='N'", conn);
  37.         SqlDataReader dr = sqlcom.ExecuteReader();
  38.         if (dr.HasRows)
  39.         {
  40.             while (dr.Read())
  41.             {
  42.                 SqlConnection conn1 = dbConnection.getConnection();
  43.                 conn1.Open();
  44.                 if (dr["authority"].ToString().Equals("1"))
  45.                 {
  46.                     DataRow row = dt.NewRow();
  47.                     row["id"] = Convert.ToInt32(dr["id"]);
  48.                     row["subject"] = dr["subject"].ToString();
  49.                     dt.Rows.Add(row);
  50.                 }
  51.                 else
  52.                 {
  53.                     SqlCommand sqlcom2 = new SqlCommand("select * from OA_ANNOUNCEMENT_DEPARTMENT where a_id='" + dr["id"] + "' and department_id='" + department_id + "'", conn1);
  54.                     SqlDataReader dr2 = sqlcom2.ExecuteReader();
  55.                     if (dr2.HasRows)
  56.                     {
  57.                         DataRow row = dt.NewRow();
  58.                         row["id"] = Convert.ToInt32(dr["id"]);
  59.                         row["subject"] = dr["subject"].ToString();
  60.                         dt.Rows.Add(row);
  61.                     }
  62.                     else
  63.                     {
  64.                     }
  65.                 }
  66.             }
  67.         }
  68.         dr.Close();
  69.         ds.Tables.Add(dt);
  70.         GridView1.DataSource = ds;
  71.         GridView1.DataBind();
  72.         GridView1.DataKeyNames = new string[] { "id" };
  73.         conn.Close();
  74.     }
  75.     /*public void bind2()
  76.     {
  77.         User user = (User)Session["user"];
  78.         string department = user.Department.Name;
  79.         SqlConnection conn = dbConnection.getConnection();
  80.         conn.Open();
  81.         DataSet ds_1 = new DataSet();
  82.         DataTable dt_1 = new DataTable();
  83.         dt_1.Columns.Add("form_id", typeof(string));
  84.         dt_1.Columns.Add("subject", typeof(string));
  85.         dt_1.Columns.Add("emp_id", typeof(string));
  86.         SqlCommand sqlcom1 = new SqlCommand("select f.create_time as create_time,f.equipment as equipment,g.destine_time as destine_time from OA_REPAIR as f,OA_REPAIR_D as g where f.form_id=g.form_id and g.destine_time is not null and g.complete_time is null and f.department='" + department.Trim() + "' order by destine_time desc", conn);
  87.         SqlDataReader dr1 = sqlcom1.ExecuteReader();
  88.         if (dr1.HasRows)
  89.         {
  90.             while (dr1.Read())
  91.             {
  92.                 DataRow row = dt_1.NewRow();
  93.                 row["form_id"] = dr1["create_time"].ToString()+"报修的";
  94.                 row["emp_id"] = dr1["equipment"].ToString();
  95.                 row["subject"] = dr1["create_time"].ToString() + "报修的" + dr1["equipment"].ToString() + "问题的预计维修时间∶" + dr1["destine_time"].ToString(); ;
  96.                 dt_1.Rows.Add(row);
  97.             }
  98.         }
  99.         ds_1.Tables.Add(dt_1);
  100.         GridView2.DataSource = ds_1;
  101.         GridView2.DataBind();
  102.         GridView2.DataKeyNames = new string[] { "form_id" };
  103.         dr1.Close();
  104.         conn.Close();
  105.     }*/
  106.     protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
  107.     {
  108.         GridView1.PageIndex = e.NewPageIndex;
  109.         bind1();
  110.     }
  111.    /* protected void GridView2_PageIndexChanging(object sender, GridViewPageEventArgs e)
  112.     {
  113.         GridView2.PageIndex = e.NewPageIndex;
  114.         bind2();
  115.     }*/
  116. }