📄 usermanager.aspx.cs

📁 毕业设计时做的,一个管理关于污染管理的, 源代码,呵呵想想当时还真厉害,可以实现污染检测
💻 CS
字号:
using System;   
//mzr 2004.4.26
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;
using System.Configuration;
using  gyit.Data;

namespace itcrm.admin
{
	/// <summary>
	/// UserManager 的摘要说明。
	/// </summary>
	public class UserManager : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox tetNatirePlace;
		protected System.Web.UI.WebControls.TextBox txtJoinWorkDate;
		protected System.Web.UI.WebControls.TextBox textName;
		protected System.Web.UI.WebControls.TextBox textDept;
		protected System.Web.UI.WebControls.TextBox textJob;
		protected System.Web.UI.WebControls.TextBox textBornDate;
		protected System.Web.UI.WebControls.TextBox textHomePhone;
		protected System.Web.UI.WebControls.TextBox textNatirePlace;
		protected System.Web.UI.WebControls.TextBox textMobPhone;
		protected System.Web.UI.WebControls.TextBox textHomeAddress;
		protected System.Web.UI.WebControls.TextBox textFax;
		protected System.Web.UI.WebControls.TextBox textEmail;
		protected System.Web.UI.WebControls.TextBox textMeno;
		protected System.Web.UI.WebControls.TextBox Textbox1;
		protected System.Web.UI.WebControls.TextBox txtUserID;
		protected System.Web.UI.WebControls.TextBox txtDept;
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.TextBox txtFolk;
		protected System.Web.UI.WebControls.TextBox txtBornDate;
		protected System.Web.UI.WebControls.TextBox txtNatirePlace;
		protected System.Web.UI.WebControls.DropDownList selSex;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.TextBox txtHomePhone;
		protected System.Web.UI.WebControls.DropDownList selEdulevl;
		protected System.Web.UI.WebControls.TextBox txtMobPhone;
		protected System.Web.UI.WebControls.TextBox textJoinWorkDate;
		protected System.Web.UI.WebControls.TextBox txtFax;
		protected System.Web.UI.WebControls.DropDownList selPolityVisage;
		protected System.Web.UI.WebControls.TextBox txtEmail;
		protected System.Web.UI.WebControls.TextBox txtHomeAddress;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.TextBox txtMemo;
		protected System.Web.UI.WebControls.Button cmdClear;
		protected System.Web.UI.WebControls.Button cmdSave;
		protected System.Web.UI.WebControls.Button cmdEdit;
		protected System.Web.UI.WebControls.Button cmdAdd;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		public DBOperator db;
		private void Page_Load(object sender, System.EventArgs e)
		{        
			//DataGrid1.DateKeyField="UserId";
			db =DBOperator.CreateObject((string)ConfigurationSettings.AppSettings["DSN"]);
			DataShow();
			//将部门列表框填充
			//DropDwonList1_Conntent();//自定义列表框绑定

		}
		 
			
			
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void cmdAdd_Click(object sender, System.EventArgs e)
		{
			txtUserID.Enabled=true;
			cmdAdd.Enabled=false;	
			cmdSave.Enabled=true;
			cmdEdit.Enabled=false;
		}
		public void DataShow()
		{
			db.Open();
			DataGrid1.DataSource=db.exeSqlForDataSet("select * from [User]");
			DataGrid1.DataBind();
			db.Close();		
		}
		
		public void ClearDate() 
		 { 
			//清屏操作
			txtUserID.Text="";
			txtName.Text="";
			txtBornDate.Text="";
			txtNatirePlace.Text="";
			textJoinWorkDate.Text="";
		
			txtHomeAddress.Text="";
			txtHomePhone.Text="";
			txtFax.Text="";
			txtMobPhone.Text="";
			txtEmail.Text="";
			txtMemo.Text="";
			txtDept.Text="";
			txtFolk.Text="";
	         
		}

		private void DeleRecord(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(DataGrid1.Items.Count==1 && DataGrid1.CurrentPageIndex>0)//删除记录时对分页的处理
			{
				DataGrid1.CurrentPageIndex=DataGrid1.CurrentPageIndex-1;
				DataGrid1.Dispose();
				DataShow();
			}
			db.Open();
			db.exeSql("delete from [user] where UserID='"+DataGrid1.DataKeys[e.Item.ItemIndex]+"'");
			 DataShow();
		}

		private void SeleDo(object sender, System.EventArgs e)
		{
		  cmdEdit.Enabled=true;
		}

		private void cmdEdit_Click(object sender, System.EventArgs e)
		{
		// 修改数据到库。。
			string[] strPara =new string[17];
			object[] strValues=new object[17];
			strPara[0]="@UserID";
			strPara[1]="@UserName";  
			strPara[2]="@BornDate";   
			strPara[3]="@NativePlace";  
			strPara[4]="@EduLevl";   
			strPara[5]="@JoinWorkDate";
			strPara[6]="@Sex";  
			strPara[7]="@PolityVisage"; 
			
			strPara[8]="@HomeAddress";  
			strPara[9]="@HomePhone";  
			strPara[10]="@Fax";  
			strPara[11]="@MobPhone";  
			strPara[12]="@E_mail";  
			strPara[13]="@Note";  
			strPara[14]="@DeptID";  
			strPara[15]="@Folk";
			strPara[16]="@State";
			strValues[0]=txtUserID.Text;
			strValues[1]=txtName.Text;
			strValues[2]=txtBornDate.Text;
			strValues[3]=txtNatirePlace.Text; 
			strValues[4]=selEdulevl.SelectedItem.Selected;
			strValues[5]=textJoinWorkDate.Text; 	
			strValues[6]=selSex.SelectedItem.Text;
			strValues[7]=selPolityVisage.SelectedItem.Text;
		
			strValues[8]=txtHomeAddress.Text; 
			strValues[9]=txtHomePhone.Text; 
			strValues[10]=txtFax.Text; 
			strValues[11]=txtMobPhone.Text;  	
			strValues[12]=txtEmail.Text; 
			strValues[13]=txtMemo.Text;
			strValues[14]=txtDept.Text; 
			strValues[15]=txtFolk.Text;
			strValues[16]=1;
			db.Open();
			db.exeProc("Update_User",strPara,strValues);
			db.Close();
			DataShow();　　




			cmdAdd.Enabled=true;//对控件的状态操作。
		  cmdSave.Enabled=false;
			cmdEdit.Enabled=false;
			ClearDate();
			 
		
		}
    
		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
		 //点击　表格中　编缉按钮响应事件   填充对话框中的相关控件。
			cmdEdit.Enabled=true;
		 cmdAdd.Enabled=false;
			DataSet ds=new DataSet();
			db.Close();
			ds=db.exeSqlForDataSet("select * from [User] where UserID='"+DataGrid1.DataKeys[e.Item.ItemIndex]+"'");
			txtUserID.Text=ds.Tables[0].Rows[0][0].ToString();
			txtName.Text=ds.Tables[0].Rows[0][1].ToString();
			txtBornDate.Text=ds.Tables[0].Rows[0][3].ToString();
			txtNatirePlace.Text=ds.Tables[0].Rows[0][4].ToString(); 
			selEdulevl.SelectedItem.Text=ds.Tables[0].Rows[0][5].ToString();
			textJoinWorkDate.Text=ds.Tables[0].Rows[0][6].ToString(); 	
			selSex.SelectedItem.Text=ds.Tables[0].Rows[0][2].ToString();
			selPolityVisage.SelectedItem.Text=ds.Tables[0].Rows[0][8].ToString();
			//txtJob.Text=ds.Tables[0].Rows[0][8].ToString(); 
			txtHomeAddress.Text=ds.Tables[0].Rows[0][9].ToString(); 
			txtHomePhone.Text=ds.Tables[0].Rows[0][10].ToString(); 
			txtFax.Text=ds.Tables[0].Rows[0][11].ToString();
			txtMobPhone.Text=ds.Tables[0].Rows[0][12].ToString();  	
			txtEmail.Text=ds.Tables[0].Rows[0][13].ToString();
			txtMemo.Text=ds.Tables[0].Rows[0][14].ToString();
			txtDept.Text=ds.Tables[0].Rows[0][15].ToString(); 
			txtFolk.Text=ds.Tables[0].Rows[0][7].ToString();
			txtUserID.Enabled=false;
			db.Close();
          

		}

		private void cmdSave_Click(object sender, System.EventArgs e)
		{
			string[] strPara =new string[17];
			object[] strValues=new object[17];
			strPara[0]="@UserID";
			strPara[1]="@UserName";  
			strPara[2]="@BornDate";   
			strPara[3]="@NativePlace";  
			strPara[4]="@EduLevl";   
			strPara[5]="@JoinWorkDate";
			strPara[6]="@Sex";  
			strPara[7]="@PolityVisage"; 
			
			strPara[8]="@HomeAddress";  
			strPara[9]="@HomePhone";  
			strPara[10]="@Fax";  
			strPara[11]="@MobPhone";  
			strPara[12]="@E_mail";  
			strPara[13]="@Note";  
			strPara[14]="@DeptID";  
			strPara[15]="@Folk";
			strPara[16]="@State";
			strValues[0]=txtUserID.Text;
			strValues[1]=txtName.Text;
			strValues[2]=txtBornDate.Text;
			strValues[3]=txtNatirePlace.Text; 
			strValues[4]=selEdulevl.SelectedItem.Text;
			strValues[5]=textJoinWorkDate.Text; 	
			strValues[6]=selSex.SelectedItem.Text;
			strValues[7]=selPolityVisage.SelectedItem.Text;
			
			strValues[8]=txtHomeAddress.Text; 
			strValues[9]=txtHomePhone.Text; 
			strValues[10]=txtFax.Text; 
			strValues[11]=txtMobPhone.Text;  	
			strValues[12]=txtEmail.Text; 
			strValues[13]=txtMemo.Text;
			strValues[14]=txtDept.Text; 
			strValues[15]=txtFolk.Text;
			strValues[16]=1;
			db.Open();
			db.exeProc("AddUser_Record",strPara,strValues);
			db.Close();
			DataShow();　　
		    cmdAdd.Enabled=true;
		    cmdSave.Enabled=false;
		      txtUserID.Enabled=false;
			ClearDate();
		}

		private void cmdClear_Click(object sender, System.EventArgs e)
		{
		
			ClearDate();	
			 cmdEdit.Enabled=false;
			cmdAdd.Enabled=true;
			cmdSave.Enabled=false;
		}

		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
		  DataGrid1.CurrentPageIndex=e.NewPageIndex; //单击页时
			DataGrid1.DataBind();
             
		}

		private void txtFolk_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txtHomeAddress_TextChanged(object sender, System.EventArgs e)
		{
		
		}
	}

}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -