?? pwdupdate.cs
字號:
this.sure_button.Name = "sure_button";
this.sure_button.Size = new System.Drawing.Size(72, 24);
this.sure_button.TabIndex = 1;
this.sure_button.Text = "確定";
this.sure_button.Click += new System.EventHandler(this.sure_button_Click);
//
// esc_button
//
this.esc_button.DialogResult = System.Windows.Forms.DialogResult.Cancel;
this.esc_button.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.esc_button.Location = new System.Drawing.Point(216, 216);
this.esc_button.Name = "esc_button";
this.esc_button.Size = new System.Drawing.Size(72, 24);
this.esc_button.TabIndex = 2;
this.esc_button.Text = "退出";
this.esc_button.Click += new System.EventHandler(this.esc_button_Click);
//
// PwdAdapter
//
this.PwdAdapter.DeleteCommand = this.sqlDeleteCommand1;
this.PwdAdapter.InsertCommand = this.sqlInsertCommand1;
this.PwdAdapter.SelectCommand = this.sqlSelectCommand1;
this.PwdAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "LonInFrm", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("UserID", "UserID"),
new System.Data.Common.DataColumnMapping("Password", "Password"),
new System.Data.Common.DataColumnMapping("GroupID", "GroupID")})});
this.PwdAdapter.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM LonInFrm WHERE (UserID = @Original_UserID) AND (GroupID = @Original_G" +
"roupID OR @Original_GroupID IS NULL AND GroupID IS NULL) AND (Password = @Origin" +
"al_Password OR @Original_Password IS NULL AND Password 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_GroupID", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "GroupID", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Password", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Password", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=WKX;packet size=4096;user id=sa;data source=\".\";persist security i" +
"nfo=False;initial catalog=storage";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO LonInFrm(UserID, Password, GroupID) VALUES (@UserID, @Password, @Grou" +
"pID); SELECT UserID, Password, GroupID FROM LonInFrm 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("@Password", System.Data.SqlDbType.VarChar, 10, "Password"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@GroupID", System.Data.SqlDbType.VarChar, 10, "GroupID"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT UserID, Password, GroupID FROM LonInFrm";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE LonInFrm SET UserID = @UserID, Password = @Password, GroupID = @GroupID WHERE (UserID = @Original_UserID) AND (GroupID = @Original_GroupID OR @Original_GroupID IS NULL AND GroupID IS NULL) AND (Password = @Original_Password OR @Original_Password IS NULL AND Password IS NULL); SELECT UserID, Password, GroupID FROM LonInFrm 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("@Password", System.Data.SqlDbType.VarChar, 10, "Password"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@GroupID", System.Data.SqlDbType.VarChar, 10, "GroupID"));
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_GroupID", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "GroupID", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Password", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Password", System.Data.DataRowVersion.Original, null));
//
// PwdUpdate
//
this.AcceptButton = this.sure_button;
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.CancelButton = this.esc_button;
this.ClientSize = new System.Drawing.Size(336, 262);
this.Controls.Add(this.esc_button);
this.Controls.Add(this.sure_button);
this.Controls.Add(this.groupBox1);
this.Name = "PwdUpdate";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "修改密碼";
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
private void sure_button_Click(object sender, System.EventArgs e)
{
if(textID.Text.Trim()!=string.Empty)//判斷是否輸入了ID
{
userID=textID.Text.Trim();
}
else
{
MessageBox.Show("此字段不能為空！");
return;
}
if(textPwdOld.Text.Trim()!=string.Empty)//判斷是否輸入了原有密碼
{
passWord=textPwdOld.Text.Trim();
}
else
{
MessageBox.Show("此字段不能為空！");
return;
}
if(textPwdNew1.Text.Trim()!=string.Empty)//判斷是否輸入了新密碼
{
NewPassWord1=textPwdNew1.Text.Trim();
}
else
{
MessageBox.Show("此字段不能為空！");
return;
}
if(textPwdNew2.Text.Trim()!=string.Empty)//判斷是否再次輸入了新密碼
{
NewPassWord2=textPwdNew2.Text.Trim();
}
else
{
MessageBox.Show("此字段不能為空！");
return;
}
SqlConnection myConn = null;
SqlTransaction UserInsertTra = null;
DataSet UserInfoSet = new DataSet();
if(NewPassWord1==NewPassWord2)//強制兩次輸入新密碼必須相同
{
try
{
myConn = new SqlConnection("server=.;Trusted_Connection=yes;user=sa;pwd=1;database=storage");//連接字符串
myConn.Open();
PwdAdapter.SelectCommand.CommandText = "SELECT * FROM LonInFrm WHERE UserID = '" + userID +"'";
PwdAdapter.SelectCommand.Connection = myConn;
PwdAdapter.Fill(UserInfoSet,"UserInfoTab");
if ( UserInfoSet.Tables["UserInfoTab"] == null || UserInfoSet.Tables["UserInfoTab"].Rows.Count == 0 )//判斷用戶是否存在
{
MessageBox.Show("User is not exist");
this.textID.Focus();
this.textID.Select(0,this.textID.Text.Length);
return;
}
if( UserInfoSet.Tables["UserInfoTab"].Rows[0]["PassWord"].ToString().Trim() != passWord )//用戶原有密碼輸入錯誤
{
MessageBox.Show("PassWord Error!");
this.textPwdOld.Focus();
this.textPwdOld.Select(0,this.textPwdOld.Text.Length);
return;
}
UserInfoSet.Tables["UserInfoTab"].Rows[0]["PassWord"] = NewPassWord1;//更新密碼
UserInsertTra = myConn.BeginTransaction();
PwdAdapter.UpdateCommand.Connection = myConn;
PwdAdapter.UpdateCommand.Transaction = UserInsertTra;
PwdAdapter.Update(UserInfoSet.Tables[0]);
UserInsertTra.Commit();
MessageBox.Show("OK");
}
catch( Exception ex )
{
UserInsertTra.Rollback();
MessageBox.Show(ex.Message);
}
finally
{
if( myConn.State != ConnectionState.Closed )//關閉數據庫
{
myConn.Close();
}
}
}
}
private void esc_button_Click(object sender, System.EventArgs e)
{
this.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -