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

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > Email客户端 > 查看源码
DeptInfo.aspx.cs
资源名称：yjal.rar　[点击查看]
上传用户：shjujing
上传日期：2022-07-28
资源大小：11244k
文件大小：5k
源码类别：

Email客户端

开发平台：

Visual C++

DeptInfo.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;
  12. using System.Data.SqlClient;
  14. public partial class Module_Employee_ProRes_DeptInfo : System.Web.UI.Page
  15. {
  16.     protected void Page_Load(object sender, EventArgs e)
  17.     {
  18.         if (Session["UserName"] != null)
  19.         {
  20.             if (Session["Popedom"].ToString() == "0")
  21.             {
  22.                 this.lnkbtnAdd.Visible = true;
  23.             }
  24.         }
  25.         else
  26.         {
  27.             Response.Write("<script language=javascript>top.location.href='../../Index.aspx'</script>");
  28.         }
  29.         SqlData da = new SqlData();
  30.         string cmdtxt1 = "select * from tb_Department";
  31.         this.GridView1.DataSource = da.ExceDS(cmdtxt1, "tb_Department");
  32.         this.GridView1.DataKeyNames = new string[] { "ID"};
  33.         this.GridView1.DataBind();
  34.         if (!IsPostBack)
  35.         {
  36.             string cmdtxt2 = "select Distinct Name from tb_User";
  37.             SqlDataReader dr = da.ExceDr(cmdtxt2);
  38.             while (dr.Read())
  39.             {
  40.                 this.DropDownList1.Items.Add(dr["Name"].ToString());
  41.             }
  42.             dr.Close();
  43.         }  
  44.     }
  46.     protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
  47.     {
  48.        this.GridView1.PageIndex = e.NewPageIndex;
  49.        SqlData da = new SqlData();
  50.        string search = this.dropClass.SelectedValue;
  51.        switch (search)
  52.        {
  53.            case "部门ID":
  54.                da.BindData(this.GridView1, "Select * From tb_Department Where ID  Like  '%" + this.txtKeyWord.Text + "%'", "tb_Department");
  55.                break;
  56.            case "部门名称":
  57.                da.BindData(this.GridView1, "Select * From tb_Department Where DepName  Like  '%" + this.txtKeyWord.Text + "%'", "tb_Department");
  58.                break;
  59.            case "部门经理":
  60.                da.BindData(this.GridView1, "Select * From tb_Department Where DepManager  Like  '%" + this.txtKeyWord.Text + "%'", "tb_Department");
  61.                break;
  62.            default:
  63.                Response.Write("<script lanuage=javascript>alert('出错拉！');location='javascript:history.go(-1)'</script>");
  64.                break;
  65.        }
  66.    }
  67.     protected void lnkbtnAdd_Click1(object sender, EventArgs e)
  68.     {
  69.         this.Panel3.Visible = false;
  70.         this.Panel1.Visible = true;
  71.     }
  72.     protected void btnOK_Click(object sender, EventArgs e)
  73.     {
  74.         string cmdtxt = "INSERT INTO tb_Department(DepName,DepManager,DepPhone,DepBaseTime,DepPost,DepAddress,DepDescription) VALUES('" + this.txtDeptName.Text + "','" + this.DropDownList1.SelectedValue + "'";
  75.         cmdtxt += ",'" + this.txtDeptPhone.Text + "','" + this.txtBaseTime.Text + "','" + this.txtPostCard.Text + "'";
  76.         cmdtxt += ",'" + this.txtDeptAddress.Text + "','" + this.txtDescript.Text + "')";
  77.         SqlData da = new SqlData();
  78.         if (da.ExceSQL(cmdtxt))
  79.         {
  80.             Response.Write("<script language=javascript>alert('操作成功！');location='DeptInfo.aspx'</script>");
  81.             CommonClass.WriteNote(this.txtDeptName.Text, 0, Session["UserName"].ToString());
  82.         }
  83.         else
  84.         {
  85.             Response.Write("<script language=javascript>alert('操作失败！');location='javascript:history.go(-1)'</script>");
  86.         }
  87.     }
  88.     protected void btnFind_Click(object sender, EventArgs e)
  89.     {
  90.         if (this.txtKeyWord.Text == "")
  91.         {
  92.             Response.Write("<script language=javascript>alert('关键字不能为空！');location='DeptInfo.aspx'</script>");
  93.             return;
  94.         }
  95.         SqlData da = new SqlData();
  96.         string search = this.dropClass.SelectedValue;
  97.         switch (search)
  98.         {
  99.             case "部门ID":
  100.                 da.BindData(this.GridView1, "Select * From tb_Department Where ID  Like  '%" + this.txtKeyWord.Text + "%'", "tb_Department");
  101.                 break;
  102.             case "部门名称":
  103.                 da.BindData(this.GridView1, "Select * From tb_Department Where DepName  Like  '%" + this.txtKeyWord.Text + "%'", "tb_Department");
  104.                 break;
  105.             case "部门经理":
  106.                 da.BindData(this.GridView1, "Select * From tb_Department Where DepManager  Like  '%" + this.txtKeyWord.Text + "%'", "tb_Department");
  107.                 break;
  108.             default:
  109.                 Response.Write("<script lanuage=javascript>alert('出错拉！');location='javascript:history.go(-1)'</script>");
  110.                 break;
  111.         }
  112.     }
  113.     protected void btnBack_Click(object sender, EventArgs e)
  114.     {
  115.         Response.Write("<script>this.parent.rightFrame.location='DeptInfo.aspx'</script>");
  116.     }
  117. }