user.cs

企业管理系统

			this.groupBox1.Controls.Add(this.textProName);
			this.groupBox1.Controls.Add(this.label10);
			this.groupBox1.Controls.Add(this.textProID);
			this.groupBox1.Controls.Add(this.label7);
			this.groupBox1.Controls.Add(this.textClientID);
			this.groupBox1.Controls.Add(this.label1);
			this.groupBox1.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.groupBox1.Location = new System.Drawing.Point(48, 16);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(232, 144);
			this.groupBox1.TabIndex = 42;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "用户记录";
			// 
			// textProName
			// 
			this.textProName.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.textProName.Cursor = System.Windows.Forms.Cursors.Arrow;
			this.textProName.Location = new System.Drawing.Point(72, 64);
			this.textProName.Name = "textProName";
			this.textProName.Size = new System.Drawing.Size(120, 23);
			this.textProName.TabIndex = 27;
			this.textProName.Text = "";
			// 
			// label10
			// 
			this.label10.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label10.Location = new System.Drawing.Point(8, 72);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(56, 23);
			this.label10.TabIndex = 26;
			this.label10.Text = "用户密码";
			// 
			// textProID
			// 
			this.textProID.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.textProID.Cursor = System.Windows.Forms.Cursors.Arrow;
			this.textProID.Location = new System.Drawing.Point(72, 32);
			this.textProID.Name = "textProID";
			this.textProID.Size = new System.Drawing.Size(120, 23);
			this.textProID.TabIndex = 18;
			this.textProID.Text = "";
			// 
			// label7
			// 
			this.label7.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label7.Location = new System.Drawing.Point(8, 40);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(72, 23);
			this.label7.TabIndex = 17;
			this.label7.Text = "用户ID";
			// 
			// textClientID
			// 
			this.textClientID.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
			this.textClientID.Cursor = System.Windows.Forms.Cursors.Arrow;
			this.textClientID.Location = new System.Drawing.Point(72, 104);
			this.textClientID.Name = "textClientID";
			this.textClientID.Size = new System.Drawing.Size(120, 23);
			this.textClientID.TabIndex = 10;
			this.textClientID.Text = "";
			// 
			// label1
			// 
			this.label1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label1.Location = new System.Drawing.Point(8, 104);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(56, 23);
			this.label1.TabIndex = 0;
			this.label1.Text = "用户类别";
			// 
			// btnExit
			// 
			this.btnExit.Image = ((System.Drawing.Image)(resources.GetObject("btnExit.Image")));
			this.btnExit.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnExit.Location = new System.Drawing.Point(376, 112);
			this.btnExit.Name = "btnExit";
			this.btnExit.Size = new System.Drawing.Size(64, 24);
			this.btnExit.TabIndex = 43;
			this.btnExit.Text = "退出";
			// 
			// btnCancel
			// 
			this.btnCancel.Image = ((System.Drawing.Image)(resources.GetObject("btnCancel.Image")));
			this.btnCancel.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnCancel.Location = new System.Drawing.Point(376, 32);
			this.btnCancel.Name = "btnCancel";
			this.btnCancel.Size = new System.Drawing.Size(64, 24);
			this.btnCancel.TabIndex = 44;
			this.btnCancel.Text = "取消";
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=ANDY;packet size=4096;integrated security=SSPI;data source=ANDY;pe" +
				"rsist security info=False;initial catalog=Sell";
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.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("UserPassword", "UserPassword"),
																																																			  new System.Data.Common.DataColumnMapping("UserSort", "UserSort")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = "DELETE FROM [User] WHERE (UserID = @Original_UserID) AND (UserPassword = @Origina" +
				"l_UserPassword OR @Original_UserPassword IS NULL AND UserPassword IS NULL) AND (" +
				"UserSort = @Original_UserSort OR @Original_UserSort IS NULL AND UserSort IS NULL" +
				")";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			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_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_UserSort", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "UserSort", System.Data.DataRowVersion.Original, null));
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = "INSERT INTO [User] (UserID, UserPassword, UserSort) VALUES (@UserID, @UserPasswor" +
				"d, @UserSort); SELECT UserID, UserPassword, UserSort FROM [User] WHERE (UserID =" +
				" @UserID)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			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("@UserPassword", System.Data.SqlDbType.VarChar, 10, "UserPassword"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserSort", System.Data.SqlDbType.VarChar, 10, "UserSort"));
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT UserID, UserPassword, UserSort FROM [User]";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE [User] SET UserID = @UserID, UserPassword = @UserPassword, UserSort = @UserSort WHERE (UserID = @Original_UserID) AND (UserPassword = @Original_UserPassword OR @Original_UserPassword IS NULL AND UserPassword IS NULL) AND (UserSort = @Original_UserSort OR @Original_UserSort IS NULL AND UserSort IS NULL); SELECT UserID, UserPassword, UserSort FROM [User] WHERE (UserID = @UserID)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			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("@UserPassword", System.Data.SqlDbType.VarChar, 10, "UserPassword"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@UserSort", System.Data.SqlDbType.VarChar, 10, "UserSort"));
			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_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_UserSort", System.Data.SqlDbType.VarChar, 10, 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.ClientSize = new System.Drawing.Size(504, 397);
			this.Controls.Add(this.btnDelete);
			this.Controls.Add(this.btnModify);
			this.Controls.Add(this.btnAdd);
			this.Controls.Add(this.dataGrid1);
			this.Controls.Add(this.btnApply);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.btnCancel);
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
			this.MaximizeBox = false;
			this.MinimizeBox = false;
			this.Name = "User";
			this.Text = "用户管理";
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			this.groupBox1.ResumeLayout(false);
			this.ResumeLayout(false);

		}
		#endregion
	}
}