/// <summary>
/// 用户登录
/// </summary>
/// <param name="LoginName"></param>
/// <param name="LoginPwd"></param>
/// <returns></returns>
public userBean GetLoginBllSql(string LoginName, string LoginPwd)
{
userBean _userBean = null;
DataSet _dsGetLogin = _userD.getLoginBySql(LoginName, LoginPwd);
foreach (DataRow _dr in _dsGetLogin.Tables[0].Rows)
{
_userBean = new userBean();
_userBean.UId = _dr["id"].ToString().Trim();
_userBean.Uname = _dr["name"].ToString().Trim();
_userBean.Uzgbm = _dr["zgbm"].ToString().Trim();
_userBean.Upasswd = _dr["passwd"].ToString();
_userBean.Ugzbz = Convert.ToInt16(_dr["gzbz"]);
_userBean.Ujrsj = _dr["jrsj"].ToString().Trim();
_userBean.Ubdsj = _dr["bdsj"].ToString().Trim();
_userBean.Uszry = _dr["szry"].ToString().Trim();
_userBean.Ugwlx = Convert.ToInt16(_dr["gwlx"]);
_userBean.Uisdl = Convert.ToInt16(_dr["isdl"]);
_userBean.Umemo = _dr["memo"].ToString().Trim();
//return _userBean;
}
return(_userBean);
/*
* int _count = _dsGetLogin.Tables[0].Rows.Count;
* if (_count > 0)
* return true; //表示用户名和密码正确
* return false; //表示用户名或密码不正确
*/
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(lblUserName.Text))
{
MessageBox.Show("用户名不能为空");
return;
}
if (string.IsNullOrEmpty(txtOriginPwd.Text))
{
MessageBox.Show("原密码不能为空");
return;
}
if (string.IsNullOrEmpty(txtNewPwd.Text))
{
MessageBox.Show("新密码不能为空");
return;
}
if (string.IsNullOrEmpty(txtConfirmPwd.Text))
{
MessageBox.Show("确认密码不能为空");
return;
}
if (txtNewPwd.Text != txtConfirmPwd.Text)
{
MessageBox.Show("两次密码不一致");
return;
}
userBll _userbll = new userBll();
userBean _userbean = new userBean();
_userbean = null;
_userbean = _userbll.GetLoginBllProc(Common.UserName, txtOriginPwd.Text.ToString());
//userBean _userbean1 = new userBean();
//_userbean1 = _userbll.(this.txtName.Text.ToString(), this.txtPwd.Text.ToString());
if (_userbean == null)
{
//MessageBox.Show("登录成功！" + this.txtPwd.Text.ToString(), "提示");
MessageBox.Show("原密码不正确");
return;
}
int result = _userbll.UpdateUser(Common.Id, txtUserName.Text.Trim(), txtNewPwd.Text.Trim());
if (result > 0)
{
this.Hide();
MessageBox.Show("更新成功");
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
userBll _userbll = new userBll();
userBean _userbean = new userBean();
_userbean = null;
_userbean = _userbll.GetLoginBllProc(this.txtName.Text.ToString(), this.txtPwd.Text.ToString());
//userBean _userbean1 = new userBean();
//_userbean1 = _userbll.(this.txtName.Text.ToString(), this.txtPwd.Text.ToString());
if (_userbean != null)
{
//MessageBox.Show("登录成功！" + this.txtPwd.Text.ToString(), "提示");
new Main().Show();
this.Hide();
Common.Id = _userbean.UId;
Common.UserName = this.txtName.Text.ToString();
}
else
{
MessageBox.Show("登录失败！" + this.txtPwd.Text.ToString(), "提示");
}
}
/// <summary>
/// 查询所有用户
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public List <userBean> GetAllUsersBll()
{
List <userBean> _lstwuser = new List <userBean>();
DataSet _ds = _userD.getAllUser();
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
userBean _userBean = new userBean();
_userBean.UId = _dr["id"].ToString().Trim();
_userBean.Uname = _dr["name"].ToString().Trim();
_userBean.Uzgbm = _dr["zgbm"].ToString().Trim();
_userBean.Upasswd = _dr["passwd"].ToString().Trim();
_userBean.Ugzbz = Convert.ToInt16(_dr["gzbz"]);
_userBean.Ujrsj = _dr["jrsj"].ToString().Trim();
_userBean.Ubdsj = _dr["bdsj"].ToString().Trim();
_userBean.Uszry = _dr["szry"].ToString().Trim();
_userBean.Ugwlx = Convert.ToInt16(_dr["gwlx"]);
_userBean.Uisdl = Convert.ToInt16(_dr["isdl"]);
_userBean.Umemo = _dr["memo"].ToString().Trim();
_lstwuser.Add(_userBean);
}
return(_lstwuser);
}
