private void btnSubmit_Click(object sender, EventArgs e)
{
var sqlstr = "UpdatePwd";
var con = new SqlConnection(MaLogin.WmsCon);
var cmd = new SqlCommand(sqlstr, con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@uName", utxtUser.Text);
cmd.Parameters.AddWithValue("@uPassword", WmsFunction.GetMd5Hash(utxtPassword.Text));
cmd.Parameters.AddWithValue("@uPwd", WmsFunction.GetMd5Hash(utxtPwd.Text));
try
{
con.Open();
}
catch (Exception ex)
{
MessageBox.Show(@"发生异常" + ex.Message, @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (cmd.ExecuteNonQuery() < 1)
{
MessageBox.Show(@"修改失败", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show(@"修改成功", @"Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
}
}
private void uGridUser_ClickCellButton(object sender, CellEventArgs e)
{
var sqlstr = "update BUser set uPassword=@uPwd where uCode=@uName";
var con = new SqlConnection(MaLogin.WmsCon);
var cmd = new SqlCommand(sqlstr, con);
cmd.Parameters.AddWithValue("@uName", e.Cell.Value);
cmd.Parameters.AddWithValue("@uPwd", WmsFunction.GetMd5Hash("123456"));
try
{
con.Open();
}
catch (Exception ex)
{
MessageBox.Show(@"发生异常" + ex.Message, @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (cmd.ExecuteNonQuery() < 1)
{
MessageBox.Show(@"重置失败", @"Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show(@"重置成功", @"Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
}
}
/// <summary>
/// 验证登录
/// </summary>
private void OkLogin()
{
try
{
var ws = new WmsService.BaseConService {
Url = "http://" + utxtServer.Text + "/BaseConService.asmx"
};
WmsCon = ws.GetWmsConstring();
WmsServiceUri = ws.Url;
}
catch (Exception ex)
{
MessageBox.Show(@"服务器填写错误，或者服务器端未配置正确！
" + ex.Message, @"注意", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
lblLogin.Image = Properties.Resources.LoginForm_login_btn_click;
if (string.IsNullOrEmpty(utxtUser.Text.Trim()) || string.IsNullOrEmpty(utxtPassword.Text))
{
MessageBox.Show(@"用户名和密码必填！", @"注意", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//记住账套信息
if (utxtAccount.Value == null || WmsCon == null)
{
MessageBox.Show(@"服务器选择有误！", @"注意", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var strpwd = WmsFunction.GetMd5Hash(utxtPassword.Text);
var cmd = new SqlCommand("select * from BUser where uCode='admin' and uPassword=@uPassword");
cmd.Parameters.AddWithValue("@uPassword", strpwd);
var wf = new WmsFunction(WmsCon);
if (!wf.BoolExistTable(cmd))
{
MessageBox.Show(@"admin密码不正确！", @"注意", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Hide();
var mm = new MaMain();
mm.ShowDialog();
LoginDate = udDate.DateTime.Date;
WmsServer = utxtServer.Text;
Properties.Settings.Default.cServer = utxtServer.Text;
Properties.Settings.Default.Save();
}
