user.cs

Csharp SQL图书馆管理系统 Csharp SQL图书馆管理系统源码

			// 
			this.da.DeleteCommand = this.sqlDeleteCommand1;
			this.da.InsertCommand = this.sqlInsertCommand1;
			this.da.SelectCommand = this.sqlSelectCommand1;
			this.da.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																						 new System.Data.Common.DataTableMapping("Table", "User", new System.Data.Common.DataColumnMapping[] {
																																																 new System.Data.Common.DataColumnMapping("UserID", "UserID"),
																																																 new System.Data.Common.DataColumnMapping("UserName", "UserName"),
																																																 new System.Data.Common.DataColumnMapping("UserPassword", "UserPassword"),
																																																 new System.Data.Common.DataColumnMapping("UserSort", "UserSort"),
																																																 new System.Data.Common.DataColumnMapping("UserDepart", "UserDepart"),
																																																 new System.Data.Common.DataColumnMapping("UserPhone", "UserPhone")})});
			this.da.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM [User] WHERE (UserID = @Original_UserID) AND (UserDepart = @Original_UserDepart OR @Original_UserDepart IS NULL AND UserDepart IS NULL) AND (UserName = @Original_UserName OR @Original_UserName IS NULL AND UserName IS NULL) AND (UserPassword = @Original_UserPassword OR @Original_UserPassword IS NULL AND UserPassword IS NULL) AND (UserPhone = @Original_UserPhone OR @Original_UserPhone IS NULL AND UserPhone IS NULL) AND (UserSort = @Original_UserSort OR @Original_UserSort IS NULL AND UserSort IS NULL)";
			this.sqlDeleteCommand1.Connection = this.conn;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserID", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserID", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserDepart", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserDepart", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserName", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserName", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserPassword", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserPassword", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserPhone", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserPhone", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserSort", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserSort", System.Data.DataRowVersion.Original, null));
			// 
			// conn
			// 
			this.conn.ConnectionString = "workstation id=user05;packet size=4096;integrated security=SSPI;data source=USER0" +
				"5;persist security info=False;initial catalog=LibraryManage";
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = @"INSERT INTO [User] (UserID, UserName, UserPassword, UserSort, UserDepart, UserPhone) VALUES (@UserID, @UserName, @UserPassword, @UserSort, @UserDepart, @UserPhone); SELECT UserID, UserName, UserPassword, UserSort, UserDepart, UserPhone FROM [User] WHERE (UserID = @UserID)";
			this.sqlInsertCommand1.Connection = this.conn;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserID", System.Data.SqlDbType.VarChar, 10, "UserID"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 10, "UserName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserPassword", System.Data.SqlDbType.VarChar, 10, "UserPassword"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserSort", System.Data.SqlDbType.VarChar, 20, "UserSort"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserDepart", System.Data.SqlDbType.VarChar, 10, "UserDepart"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserPhone", System.Data.SqlDbType.VarChar, 10, "UserPhone"));
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT UserID, UserName, UserPassword, UserSort, UserDepart, UserPhone FROM [User" +
				"]";
			this.sqlSelectCommand1.Connection = this.conn;
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE [User] SET UserID = @UserID, UserName = @UserName, UserPassword = @UserPassword, UserSort = @UserSort, UserDepart = @UserDepart, UserPhone = @UserPhone WHERE (UserID = @Original_UserID) AND (UserDepart = @Original_UserDepart OR @Original_UserDepart IS NULL AND UserDepart IS NULL) AND (UserName = @Original_UserName OR @Original_UserName IS NULL AND UserName IS NULL) AND (UserPassword = @Original_UserPassword OR @Original_UserPassword IS NULL AND UserPassword IS NULL) AND (UserPhone = @Original_UserPhone OR @Original_UserPhone IS NULL AND UserPhone IS NULL) AND (UserSort = @Original_UserSort OR @Original_UserSort IS NULL AND UserSort IS NULL); SELECT UserID, UserName, UserPassword, UserSort, UserDepart, UserPhone FROM [User] WHERE (UserID = @UserID)";
			this.sqlUpdateCommand1.Connection = this.conn;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserID", System.Data.SqlDbType.VarChar, 10, "UserID"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserName", System.Data.SqlDbType.VarChar, 10, "UserName"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserPassword", System.Data.SqlDbType.VarChar, 10, "UserPassword"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserSort", System.Data.SqlDbType.VarChar, 20, "UserSort"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserDepart", System.Data.SqlDbType.VarChar, 10, "UserDepart"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserPhone", System.Data.SqlDbType.VarChar, 10, "UserPhone"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserID", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserID", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserDepart", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserDepart", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserName", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserName", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserPassword", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserPassword", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserPhone", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserPhone", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_UserSort", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserSort", System.Data.DataRowVersion.Original, null));
			// 
			// User
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.BackColor = System.Drawing.Color.LightBlue;
			this.ClientSize = new System.Drawing.Size(626, 237);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.groupBox3);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
			this.MaximizeBox = false;
			this.MinimizeBox = false;
			this.Name = "User";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "用户信息维护";
			this.Load += new System.EventHandler(this.User_Load);
			this.groupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.objDataSetUser)).EndInit();
			this.groupBox3.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion

		public void ErrorHandle(System.Exception E)
		{
			MessageBox.Show(E.ToString());
		}		

		

		private void TextEnableControl(bool valid)
		{
			if(valid)
			{
				this.textId.Enabled=true;				
				this.textSort.Enabled=true;
				this.textPassword.Enabled=true;
				//this.chkValid.Enabled=true;
				
			}
			else
			{
				this.textId.Enabled=false;				
				this.textSort.Enabled=false;
				this.textPassword.Enabled=false;
				//this.chkValid.Enabled=false;
			}
		}

		private void ButtonEnableControl(bool valid)
		{
			if(valid)
			{
				this.btnCancel.Enabled=true;
				this.btnApply.Enabled=true;
			}
			else
			{
				this.btnCancel.Enabled=false;
				this.btnApply.Enabled=false;
			}
		}
						
		private void LoadDataSet(string Query)
		{
			DataSetUser objDataSetTemp=new DataSetUser();
			try
			{
				this.FillDataSet(objDataSetTemp,Query);

			}
			catch (System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			try
			{
				this.objDataSetUser.Clear();
				this.objDataSetUser.Merge(objDataSetTemp);
			}
			catch(System.Exception E) 
			{
				// 在此处添加错误处理代码。
				this.ErrorHandle(E);
			}
			
		}
		
		private void FillDataSet(DataSetUser dataset,string sqlQuery)
		{
			dataset.EnforceConstraints=false;
			try
			{
				da.SelectCommand.CommandText=sqlQuery;
				conn.Open();
				da.Fill(dataset);
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
		
			finally
			{
				dataset.EnforceConstraints=true;
				conn.Close();
			}
		}

		private void User_Load(object sender, System.EventArgs e)
		{
		
			if(this.sqlQuery!="")
			{
				this.LoadDataSet(sqlQuery);
				
				this.TextEnableControl(false);
				this.ButtonEnableControl(false);
				this.TextEnableControl(true);
				this.ButtonEnableControl(true);
			}
			else
			{
				addUser();
			
			}
		
		}
		
		private void addUser()
		{
		
		try
			{
				this.BindingContext[this.objDataSetUser,"User"].AddNew();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			
			this.TextEnableControl(true);
			this.ButtonEnableControl(true);
		
		}

		public void UpdateDataSet()
		{
			this.BindingContext[this.objDataSetUser,"User"].EndCurrentEdit();
			DataSetUser objDataSetTemp=new DataSetUser();
			objDataSetTemp=(DataSetUser)(this.objDataSetUser.GetChanges());
			try
			{
				this.UpdateDataSource(objDataSetTemp);
				this.objDataSetUser.Merge(objDataSetTemp);
				this.objDataSetUser.AcceptChanges();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
		}
		

		public void UpdateDataSource(DataSetUser Changerows)
		{
			try
			{
				conn.Open();
				da.Update(Changerows);
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}
			finally
			{
				conn.Close();

			}	
		}

		private void btnApply_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.UpdateDataSet();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}			
			
			this.TextEnableControl(false);
			this.ButtonEnableControl(false);
		}

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			try
			{
				this.BindingContext[this.objDataSetUser,"User"].CancelCurrentEdit();
			}
			catch(System.Exception E)
			{
				this.ErrorHandle(E);
			}			
			
			this.TextEnableControl(false);
			this.TextEnableControl(false);
			this.ButtonEnableControl(false);
			
		}

		private void btnExit_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

				

	}
}