0.aspx.cs

图档管理系通

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace sys_3
{
	/// <summary>
	/// _0 的摘要说明。
	/// </summary>
	public class _0 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Image Image2;
		protected System.Web.UI.WebControls.Panel Panel3;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Button Button6;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Panel Panel2;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
		
//Session["uA"]="3";
//Session["user"]="sdfsda";
			string uAstr=null;
			switch(Session["uA"].ToString().Trim())
			{
				case "1":uAstr="普通用户";break;
				case "2":uAstr="专业组长";break;
				case "3":uAstr="高级管理者";break;
				case "4":uAstr="档案管理者";break;
			}
			Label1.Text="用户姓名： "+Session["user"].ToString().Trim()+"   用户身份："+uAstr;
				
			
			
			// 在此处放置用户代码以初始化页面

		
			
			
			  // if(Session["uA"].ToString().Trim() =="0")
				//	Response.Redirect("1.aspx");
				if(Session["uA"].ToString().Trim() =="3")
				{
					DataGrid1.Visible=true;
					Display_dgd();
				}
				else
				{
					DataGrid1.Visible=false;
					Response.Redirect("1.aspx");
				}
			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Button2.Click += new System.EventHandler(this.Button2_Click);
			this.Button3.Click += new System.EventHandler(this.Button3_Click);
			this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
			this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
			this.Button5.Click += new System.EventHandler(this.Button5_Click);
			this.Button6.Click += new System.EventHandler(this.Button6_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Display_dgd()
		{
			Load_dgd(DataGrid1,"select * from bpuser ",c.conSTR);
		}
		private void Load_dgd(System.Web.UI.WebControls.DataGrid DataGrid,string cmdTxt,string connStr)
		{
			DataTable data= c.exeQuery(cmdTxt,connStr);
			DataGrid.DataSource=data;
			DataGrid.DataBind();
			DataGrid.Visible=true;
		}
		private void Button2_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("2.aspx");
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("1.aspx");
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("3.aspx");
		}

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemIndex != -1)
			{
				int orderID=e.Item.ItemIndex+1;
				orderID+=DataGrid1.CurrentPageIndex*15;
				e.Item.Cells[0].Text=orderID.ToString();
			}
		}

		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid1.CurrentPageIndex = e.NewPageIndex;
			Display_dgd();
		}

		private void Button5_Click(object sender, System.EventArgs e)
		{
			TextBox1.Visible=true;
			this.DropDownList1.Visible=true;
			this.Button6.Visible=true;
		}

		private void Button6_Click(object sender, System.EventArgs e)
		{
			//添加操作
			if(c.ExecuteSql2("select count(*) from bpuser where uName='"+this.TextBox1.Text.Trim()+"'")>0)
			{
				this.Label2.Text="用户姓名名已经存在，请在姓名后加上简单后缀以示区别！";
				TextBox1.Visible=true;
				this.DropDownList1.Visible=true;
				this.Button6.Visible=true;
			}
			else
			{
				this.Label2.Text="";
				c.ExecuteSql("insert into bpuser(uName,uA,zy) values ('"+this.TextBox1.Text.Trim()+"','"+this.DropDownList1.SelectedValue.ToString().Trim()+"','s')");			
				TextBox1.Visible=false;
				this.DropDownList1.Visible=false;
				this.Button6.Visible=false;
			}
		}
//编辑
		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		    DataGrid1.EditItemIndex = e.Item.ItemIndex;
			Display_dgd();
		}
//删除
		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(DataGrid1.Items.Count==1)
			{
				if(DataGrid1.CurrentPageIndex!=0)
					DataGrid1.CurrentPageIndex = DataGrid1.CurrentPageIndex-1;
			}
			string strSql = "delete from bpuser where uName='"+e.Item.Cells[1].Text+"'";
			c.ExecuteSql(strSql);
			Display_dgd();
		}

		private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			DataGrid1.EditItemIndex = -1;
			Display_dgd();
		}
	}
}