private void btnOK_Click(object sender, EventArgs e)
{
if (this.txtUid.Text.Length == 0)
{
this.errAllInfo.SetError(this.txtUid, "用户名不能为空！");
}
if (this.txtPwd.Text.Length < 6)
{
this.errAllInfo.SetError(this.txtPwd, "密码不能小于6位！");
}
string P_DESDcrypt = G_WinFormClass.DESEncrypt(this.txtPwd.Text);
string cmdtxt = "SELECT UserID,SysLoginName,Pwd,SysUserSort,PopedomID FROM v_UserView WHERE SysLoginName='" + this.txtUid.Text.Trim() + "'";
cmdtxt += "AND Pwd='" + P_DESDcrypt + "' AND SysUserSort='" + this.cbxDegree.SelectedValue.ToString() + "'";
SqlDataReader P_dr = G_SqlExecute.GetReader(cmdtxt);
P_dr.Read();
if (P_dr.HasRows)
{
AppMain AppForm = new AppMain();
this.Hide();
PropertyClass.SendNameValue = this.txtUid.Text;
PropertyClass.SendPopedomValue = P_dr["PopedomID"].ToString();
PropertyClass.SendUserIDValue = P_dr["UserID"].ToString();
PropertyClass.SavePassword = P_dr["Pwd"].ToString();
AppForm.Show();
}
else
{
MessageBox.Show("用户名、密码或身份不正确！", "登录提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
P_dr.Close();
}
P_dr.Close();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (this.txtInitPwd.Text.Length < 6)
{
this.errorProvider1.SetError(this.txtInitPwd, "密码不能小于6位！");
return;
}
if (this.txtAmendPwd.Text.Length < 6)
{
this.errorProvider1.SetError(this.txtAmendPwd, "密码不能小于6位！");
return;
}
if (this.txtOkPwd.Text.Length < 6)
{
this.errorProvider1.SetError(this.txtOkPwd, "密码不能小于6位！");
return;
}
if (this.txtInitPwd.Text.Trim() == G_WinFormClass.DESDecrypt(PropertyClass.SavePassword))
{
if (this.txtAmendPwd.Text == this.txtOkPwd.Text)
{
string P_Str_cmdtxt = "UPDATE tb_User SET Pwd='" + G_WinFormClass.DESEncrypt(this.txtAmendPwd.Text.Trim()) + "' where UserID = '" + PropertyClass.SendUserIDValue + "'";
if (G_SqlClass.GetExecute(P_Str_cmdtxt))
{
MessageBox.Show("密码修改成功，下次登录时修改的密码将生效！", "提示框", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("密码修改失败！", "提示框", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("两次密码输入不一致！", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("输入密码与原始密码不一致！", "提示框", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
if (this.cbxLogin.Text == "")
{
this.errorProvider1.SetError(this.cbxLogin, "登录身份不能为空！");
return;
}
if (this.checkBox1.Checked && this.txtName.Text == "")
{
this.errorProvider1.SetError(this.txtName, "用户名不能为空！");
return;
}
if (this.checkBox2.Checked && this.txtOkPwd.Text != this.txtPwd.Text)
{
this.errorProvider1.SetError(this.txtOkPwd, "两次输入密码不一致！");
return;
}
if (this.checkBox2.Checked && this.txtPwd.Text.Length < 6)
{
this.errorProvider1.SetError(this.txtPwd, "输入密码不能小于6位！");
return;
}
if (this.checkBox2.Checked && this.txtOkPwd.Text.Length < 6)
{
this.errorProvider1.SetError(this.txtOkPwd, "输入密码不能小于6位！");
return;
}
//从树控件中读取设置的值
ArrayList arylst = new ArrayList();
foreach (TreeNode nodes in this.treeView1.Nodes)
{
foreach (TreeNode node in nodes.Nodes)
{
if (node.Checked)
{
arylst.Add("1");
}
else
{
arylst.Add("0");
}
}
}
if (this.labMessage.Text == "该用户已为系统用户")
{
//判断权限表中是否存在要设置权限的用户
string P_Str_select2 = "SELECT * FROM tb_User WHERE Name = '" + this.listBox1.SelectedValue.ToString() + "'";
SqlDataReader P_dr4 = G_SqlClass.GetReader(P_Str_select2);
P_dr4.Read();
string loginame = String.Empty;
if (P_dr4.HasRows)
{
loginame = P_dr4["SysLoginName"].ToString();
}
P_dr4.Close();
if (MessageBox.Show("是否确认修改？", "提示对话框", MessageBoxButtons.OKCancel, MessageBoxIcon.Information)
== DialogResult.OK)
{
string P_Str_cmdtxt = String.Empty;
if (this.checkBox1.Checked)
{
string P_Str_select = "SELECT * FROM tb_User WHERE SysLoginName = '" + this.txtName.Text + "'";
SqlDataReader P_dr2 = G_SqlClass.GetReader(P_Str_select);
P_dr2.Read();
if (P_dr2.HasRows)
{
MessageBox.Show("该用户已存在！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
P_Str_cmdtxt = "UPDATE tb_User SET SysLoginName = '" + this.txtName.Text + "'";
P_Str_cmdtxt += " WHERE SysLoginName = '" + loginame + "'";
if (G_SqlClass.GetExecute(P_Str_cmdtxt))
{
string P_Str_cmdtxt2 = "UPDATE tb_Popedom SET SysUserName='******' WHERE SysUserName = '******'";
G_SqlClass.GetExecute(P_Str_cmdtxt2);
}
else
{
MessageBox.Show("用户修改失败！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
}
if (this.checkBox2.Checked)
{
P_Str_cmdtxt = "UPDATE tb_User SET Pwd = '" + G_WinFormClass.DESEncrypt(this.txtOkPwd.Text) + "'";
P_Str_cmdtxt += " where UserID = '" + PropertyClass.SendUserIDValue + "'";
if (!G_SqlClass.GetExecute(P_Str_cmdtxt))
{
MessageBox.Show("用户修改失败！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
G_SqlClass.GetExecute(P_Str_cmdtxt);
}
}
MessageBox.Show("用户修改成功,系统下次启动后生效！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
string P_Str_cmdtxt = String.Empty;
string P_Str_update = String.Empty;
string P_Str_select = String.Empty;
//执行设置系统用户及权限的语句
P_Str_cmdtxt = "INSERT INTO tb_Popedom(SysUserSort,SysUserName,EmployeeInfo,CompanyInfo,CustomerInfo";
P_Str_cmdtxt += ",GoodsInInfo,GoodsOutInfo,SellGoodsInfo,ReGoodsInfo,StockChangeInfo,StockAlarmInfo";
P_Str_cmdtxt += ",SysUser,PopedomInfo,BakDataInfo,ReBakDataInfo) VALUES('" + this.cbxLogin.Text + "','" + this.listBox1.SelectedValue.ToString() + "'";
P_Str_cmdtxt += "," + arylst[0].ToString() + "," + arylst[1].ToString() + "," + arylst[2].ToString() + "";
P_Str_cmdtxt += "," + arylst[3].ToString() + "," + arylst[4].ToString() + "," + arylst[5].ToString() + "";
P_Str_cmdtxt += "," + arylst[6].ToString() + "," + arylst[7].ToString() + "," + arylst[8].ToString() + "";
P_Str_cmdtxt += "," + arylst[9].ToString() + "," + arylst[10].ToString() + "," + arylst[11].ToString() + "," + arylst[12].ToString() + ")";
if (G_SqlClass.GetExecute(P_Str_cmdtxt))
{
//获取权限表中最后一条记录
P_Str_select = "SELECT PopedomID FROM tb_Popedom WHERE SysUserName = '******'";
DataSet P_ds = G_SqlClass.GetDs(P_Str_select);
string P_Str_Num = P_ds.Tables[0].Rows[0][0].ToString();
P_Str_update = "UPDATE tb_User SET SysLoginName = '" + this.listBox1.SelectedValue.ToString() + "'";
P_Str_update += ",Pwd='" + G_WinFormClass.DESEncrypt(this.txtOkPwd.Text) + "',PopedomID='" + P_Str_Num + "' WHERE Name = '" + this.listBox1.SelectedValue.ToString() + "'";
G_SqlClass.GetExecute(P_Str_update);
MessageBox.Show("权限设置成功,系统下次启动时生效！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("权限设置失败！", "提示对话框", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
