private void butjiesuo_Click(object sender, EventArgs e)
{
string password = txtpwd.Text;
if (txtpwd.Text == "")
{
MessageBox.Show("密码输入不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
//密码处理,经过加密
byte[] result = Encoding.Default.GetBytes(password);//password为输入密码的文本框
MD5 md5 = new MD5CryptoServiceProvider();
byte[] output = md5.ComputeHash(result);
BU_UserInfo bll = new BU_UserInfo();
DataSet ds = bll.ExistsPwd(lbuser.Text.Trim(), BitConverter.ToString(output).Replace("-", ""));
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("解锁成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
else
{
MessageBox.Show("密码输入错误", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
/// <summary>
/// 绑定数据源
/// </summary>
void dataBind()
{
DataSet ds = new BU_UserInfo().SelectAdmin("");//查询管理员
dataGridView1.DataSource = ds.Tables[0].DefaultView;
toolStripStatusLabel2.Text = dataGridView1.Rows.Count.ToString();
}
/// <summary>
/// 获取用户信息
/// </summary>
public void GetUserInfo()
{
BU_UserInfo bll = new BU_UserInfo();
MU_UserInfo user = bll.GetModel(id);
U_Name.Text = user.U_Name; //用户名
U_Name.ReadOnly = true;
U_RelName.Text = user.U_RelName; //用户真实姓名
if (user.U_Sex == true) //女
{
this.radio_women.Checked = true;
}
this.U_Birthday.Value = user.U_Birthday; //出生日期
U_IdCard.Text = user.U_IdCard; //身份证号
U_Position.Text = user.U_NativePlace; //籍贯
U_NativePlace.Text = user.U_Position; //籍贯
U_Address.Text = user.U_Address; //家庭住址
U_Telephone.Text = user.U_Telephone; //电话号码
U_Email.Text = user.U_Email; //邮箱号码
U_PostalId.Text = user.U_DepType.ToString(); //user.U_PostalId;//邮编号码
textBox1.Text = user.U_QQ; //QQ
this.comboBox1.SelectedValue = user.U_DepType.ToString();
//显示用户生活照
if (user.U_Image != null)
{
byte_Image2 = (byte[])(user.U_Image);
MemoryStream ms = new MemoryStream(byte_Image2);
pictureBox1.Image = Image.FromStream(ms);
}
}
/// <summary>
/// 删除指定数据
/// </summary>
/// <param name="ID">要删除的对象 （通过主键）</param>
/// <returns></returns>
public int Delete(BU_UserInfo _bU_UserInfo)
{
return(db.ExecuteNonQuery(deleteByKeyText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.BigInt, 19)
{
Value = _bU_UserInfo.ID
}
}));
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string userName = textBox1.Text.Trim();
if (userName == "")
{
toolStripButton1_Click_1(sender, e);
}
else
{
DataSet ds = new BU_UserInfo().SelectAdmin("U_Name like '%" + userName + "%' ");
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
}
/// <summary>
/// 加载所有问题类型
/// </summary>
public void InitSet()
{
BU_UserInfo bll = new BU_UserInfo();
DataSet ds = bll.GetMP_PasswordType();
if (ds.Tables[0].Rows.Count > 0)
{
this.cmbQuestion.DataSource = ds.Tables[0];
cmbQuestion.DisplayMember = "U_Name";
cmbQuestion.ValueMember = "P_Id";
}
else
{
cmbQuestion.Text = "=暂停访问=";
}
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string pwd = this.txt_pwd.Text.Trim(); //密码1
string pwd2 = this.txt_pwd2.Text.Trim(); //密码2
if (pwd == "")
{
MessageBox.Show("密码不能为空,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (pwd2 == "")
{
MessageBox.Show("确认密码不能为空,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (pwd != pwd2)
{
MessageBox.Show("密码输入不相同,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.txt_pwd2.Text = "";
}
else
{
BU_UserInfo bll = new BU_UserInfo();
int id = LoginRoler.U_Id;
//密码处理,经过加密
byte[] result = Encoding.Default.GetBytes(pwd2);//pwd2为输入密码的文本框
MD5 md5 = new MD5CryptoServiceProvider();
byte[] output = md5.ComputeHash(result);
string NewPwd = BitConverter.ToString(output).Replace("-", "");
bool flag = bll.UpdatePassword(NewPwd, id);
if (flag)
{
MessageBox.Show("密码更改成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("密码更改失败,关闭后请重新更改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
this.Close();
}
}
private void treeView1_NodeMouseClick_1(object sender, TreeNodeMouseClickEventArgs e)
{
string s = e.Node.FullPath;
string[] data = s.Split('\\');
if (data.Length == 2)
{
DataSet ds = null;
if (data[1] == "男")
{
ds = new BU_UserInfo().SelectAdmin("U_Sex=0");//查询普通用户
}
else
{
ds = new BU_UserInfo().SelectAdmin("U_Sex=1");//查询普通用户
}
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
}
/// <summary>
/// 删除指定数据
/// </summary>
/// <param name="ID">要删除的对象 （通过主键）</param>
/// <returns></returns>
public int Delete(BU_UserInfo _bU_UserInfo)
{
return(_dal.Delete(_bU_UserInfo));
}
/// <summary>
/// 更新数据库的一条记录
/// </summary>
/// <param name="_bU_UserInfo">需要更新的对象</param>
/// <returns></returns>
public int Update(BU_UserInfo _bU_UserInfo)
{
return(db.ExecuteNonQuery(updateByKeyText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@UserNO", SqlDbType.VarChar, 32)
{
Value = _bU_UserInfo.UserNO
}
, new SqlParameter("@UserName", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.UserName
}
, new SqlParameter("@LoginName", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.LoginName
}
, new SqlParameter("@Pwd", SqlDbType.NVarChar, 500)
{
Value = _bU_UserInfo.Pwd
}
, new SqlParameter("@ToKen", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.ToKen
}
, new SqlParameter("@Gender", SqlDbType.VarChar, 2)
{
Value = _bU_UserInfo.Gender
}
, new SqlParameter("@BirthDate", SqlDbType.DateTime, 23)
{
Value = _bU_UserInfo.BirthDate
}
, new SqlParameter("@Mobile", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.Mobile
}
, new SqlParameter("@Telephone", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.Telephone
}
, new SqlParameter("@Fax", SqlDbType.NVarChar, 32)
{
Value = _bU_UserInfo.Fax
}
, new SqlParameter("@QQ", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.QQ
}
, new SqlParameter("@Email", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.Email
}
, new SqlParameter("@CreateTime", SqlDbType.DateTime, 23)
{
Value = _bU_UserInfo.CreateTime
}
, new SqlParameter("@UpdateTime", SqlDbType.DateTime, 23)
{
Value = _bU_UserInfo.UpdateTime
}
, new SqlParameter("@ProvinceCode", SqlDbType.NVarChar, 6)
{
Value = _bU_UserInfo.ProvinceCode
}
, new SqlParameter("@Province", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.Province
}
, new SqlParameter("@CityCode", SqlDbType.NVarChar, 6)
{
Value = _bU_UserInfo.CityCode
}
, new SqlParameter("@City", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.City
}
, new SqlParameter("@ID1", SqlDbType.BigInt, 19)
{
Value = _bU_UserInfo.ID
}
}));
}
/// <summary>
/// 注册
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string UserName = this.txt_username.Text.Trim(); //姓名
bool Sex = true; //性别
if (this.radio_women.Checked)
{
Sex = false;
}
string birthday = this.time_Birthday.Text; //出身日期
string pwd = this.txt_pwd.Text.Trim(); //密码1
string pwd2 = this.txt_pwd2.Text.Trim(); //密码2
if (UserName == "")
{
MessageBox.Show("用户名输入不能为空,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (pwd == "")
{
MessageBox.Show("密码不能为空,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (pwd2 == "")
{
MessageBox.Show("确认密码不能为空,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (pwd != pwd2)
{
MessageBox.Show("密码输入不相同,请重新输入", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.txt_pwd2.Text = "";
}
else
{
BU_UserInfo Bll = new BU_UserInfo();
int a = Bll.ExistsName(UserName);
if (a != 0)
{
MessageBox.Show("用户名已经存在,请重新注册", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MU_UserInfo info = new MU_UserInfo();
//密码处理,经过加密
byte[] result = Encoding.Default.GetBytes(pwd2);//pwd2为输入密码的文本框
MD5 md5 = new MD5CryptoServiceProvider();
byte[] output = md5.ComputeHash(result);
info.U_PassWord = BitConverter.ToString(output).Replace("-", "");
info.U_Name = UserName;
info.U_Sex = Sex;
info.U_Birthday = Convert.ToDateTime(birthday);
info.U_LoginTime = DateTime.Now;
if (Pagetype == "AddAdmin")
{
info.U_RoleType = 2;//管理员
}
else
{
info.U_RoleType = 1;//普通用户
}
int Result = Bll.Add(info);
if (Result == 0)
{
MessageBox.Show("注册失败,请重新注册", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("注册成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
getName(UserName);
this.Close();
}
}
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
MU_UserInfo user = new MU_UserInfo();
Common com = new Common();
if (byte_Image == null) //显示用户生活照
{
if (byte_Image2 == null)
{
user.U_Image = null;
}
else
{
user.U_Image = byte_Image2;
}
}
else
{
user.U_Image = byte_Image;
}
user.U_Name = U_Name.Text; //用户名
user.U_RelName = U_RelName.Text; //用户真实姓名
user.U_Sex = false;
if (this.radio_women.Checked == true)//男
{
user.U_Sex = true;
}
user.U_Birthday = this.U_Birthday.Value;//出生日期
if (U_IdCard.Text != "")
{
if (com.RegexcardID(U_IdCard.Text))
{
user.U_IdCard = U_IdCard.Text;//身份证号
}
else
{
MessageBox.Show("身份证号格式输入错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
{
user.U_IdCard = "";
}
user.U_NativePlace = U_Position.Text; //民族
user.U_Address = U_Address.Text; //家庭住址
if (U_Telephone.Text != "")
{
if (com.RegexPhone(U_Telephone.Text))
{
user.U_Telephone = U_Telephone.Text;//电话号码
}
else
{
MessageBox.Show("电话号码格式输入错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
{
user.U_Telephone = "";
}
if (U_Email.Text != "")
{
if (com.RegexEmail(U_Email.Text))
{
user.U_Email = U_Email.Text;//邮箱号码
}
else
{
MessageBox.Show("邮箱号码格式输入错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
{
user.U_Email = "";
}
user.U_PostalId = U_PostalId.Text; //邮编号码
user.U_QQ = textBox1.Text; //QQ
user.U_Id = id;
bool flag = new BU_UserInfo().Update(user);
if (flag)
{
//if (LoginRoler.U_ROlesType == 2)
//{
//getName("随便传的值");
//}
MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
else
{
MessageBox.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
this.button4.Visible = true;
}
/// <summary>
/// 将数据行转换为对象
/// </summary>
/// <param name="dt">要转换的数据行</param>
/// <returns></returns>
public BU_UserInfo DataRowToModel(DataRow dr)
{
BU_UserInfo _bu_userinfo = null;
object _temp = null;
DataColumnCollection dcs = dr.Table.Columns;
_bu_userinfo = new BU_UserInfo();
if (dcs.Contains("id"))
{
_bu_userinfo.ID = Convert.ToInt64(dr["ID"]);
}
if (dcs.Contains("userno"))
{
_bu_userinfo.UserNO = dr["UserNO"].ToString();
}
if (dcs.Contains("username"))
{
_temp = dr["UserName"];
if (!(_temp is DBNull))
{
_bu_userinfo.UserName = _temp.ToString();
}
}
if (dcs.Contains("loginname"))
{
_bu_userinfo.LoginName = dr["LoginName"].ToString();
}
if (dcs.Contains("pwd"))
{
_bu_userinfo.Pwd = dr["Pwd"].ToString();
}
if (dcs.Contains("token"))
{
_bu_userinfo.ToKen = dr["ToKen"].ToString();
}
if (dcs.Contains("gender"))
{
_temp = dr["Gender"];
if (!(_temp is DBNull))
{
_bu_userinfo.Gender = _temp.ToString();
}
}
if (dcs.Contains("birthdate"))
{
_bu_userinfo.BirthDate = Convert.ToDateTime(dr["BirthDate"]);
}
if (dcs.Contains("mobile"))
{
_temp = dr["Mobile"];
if (!(_temp is DBNull))
{
_bu_userinfo.Mobile = _temp.ToString();
}
}
if (dcs.Contains("telephone"))
{
_temp = dr["Telephone"];
if (!(_temp is DBNull))
{
_bu_userinfo.Telephone = _temp.ToString();
}
}
if (dcs.Contains("fax"))
{
_temp = dr["Fax"];
if (!(_temp is DBNull))
{
_bu_userinfo.Fax = _temp.ToString();
}
}
if (dcs.Contains("qq"))
{
_temp = dr["QQ"];
if (!(_temp is DBNull))
{
_bu_userinfo.QQ = _temp.ToString();
}
}
if (dcs.Contains("email"))
{
_temp = dr["Email"];
if (!(_temp is DBNull))
{
_bu_userinfo.Email = _temp.ToString();
}
}
if (dcs.Contains("createtime"))
{
_bu_userinfo.CreateTime = Convert.ToDateTime(dr["CreateTime"]);
}
if (dcs.Contains("updatetime"))
{
_temp = dr["UpdateTime"];
if (!(_temp is DBNull))
{
_bu_userinfo.UpdateTime = Convert.ToDateTime(_temp);
}
}
if (dcs.Contains("provincecode"))
{
_bu_userinfo.ProvinceCode = dr["ProvinceCode"].ToString();
}
if (dcs.Contains("province"))
{
_bu_userinfo.Province = dr["Province"].ToString();
}
if (dcs.Contains("citycode"))
{
_bu_userinfo.CityCode = dr["CityCode"].ToString();
}
if (dcs.Contains("city"))
{
_bu_userinfo.City = dr["City"].ToString();
}
return(_bu_userinfo);
}
/// <summary>
/// 将表转换为对象集合
/// </summary>
/// <param name="dt">要转换的表</param>
/// <returns></returns>
public List <BU_UserInfo> DataTableToList(DataTable dt)
{
List <BU_UserInfo> bu_userinfos = new List <BU_UserInfo>();
BU_UserInfo _bu_userinfo = null;
object _temp = null;
DataColumnCollection dcs = dt.Columns;
foreach (DataRow item in dt.Rows)
{
_bu_userinfo = new BU_UserInfo();
if (dcs.Contains("id"))
{
_bu_userinfo.ID = Convert.ToInt64(item["ID"]);
}
if (dcs.Contains("userno"))
{
_bu_userinfo.UserNO = item["UserNO"].ToString();
}
if (dcs.Contains("username"))
{
_temp = item["UserName"];
if (!(_temp is DBNull))
{
_bu_userinfo.UserName = _temp.ToString();
}
}
if (dcs.Contains("loginname"))
{
_bu_userinfo.LoginName = item["LoginName"].ToString();
}
if (dcs.Contains("pwd"))
{
_bu_userinfo.Pwd = item["Pwd"].ToString();
}
if (dcs.Contains("token"))
{
_bu_userinfo.ToKen = item["ToKen"].ToString();
}
if (dcs.Contains("gender"))
{
_temp = item["Gender"];
if (!(_temp is DBNull))
{
_bu_userinfo.Gender = _temp.ToString();
}
}
if (dcs.Contains("birthdate"))
{
_bu_userinfo.BirthDate = Convert.ToDateTime(item["BirthDate"]);
}
if (dcs.Contains("mobile"))
{
_temp = item["Mobile"];
if (!(_temp is DBNull))
{
_bu_userinfo.Mobile = _temp.ToString();
}
}
if (dcs.Contains("telephone"))
{
_temp = item["Telephone"];
if (!(_temp is DBNull))
{
_bu_userinfo.Telephone = _temp.ToString();
}
}
if (dcs.Contains("fax"))
{
_temp = item["Fax"];
if (!(_temp is DBNull))
{
_bu_userinfo.Fax = _temp.ToString();
}
}
if (dcs.Contains("qq"))
{
_temp = item["QQ"];
if (!(_temp is DBNull))
{
_bu_userinfo.QQ = _temp.ToString();
}
}
if (dcs.Contains("email"))
{
_temp = item["Email"];
if (!(_temp is DBNull))
{
_bu_userinfo.Email = _temp.ToString();
}
}
if (dcs.Contains("createtime"))
{
_bu_userinfo.CreateTime = Convert.ToDateTime(item["CreateTime"]);
}
if (dcs.Contains("updatetime"))
{
_temp = item["UpdateTime"];
if (!(_temp is DBNull))
{
_bu_userinfo.UpdateTime = Convert.ToDateTime(_temp);
}
}
if (dcs.Contains("provincecode"))
{
_bu_userinfo.ProvinceCode = item["ProvinceCode"].ToString();
}
if (dcs.Contains("province"))
{
_bu_userinfo.Province = item["Province"].ToString();
}
if (dcs.Contains("citycode"))
{
_bu_userinfo.CityCode = item["CityCode"].ToString();
}
if (dcs.Contains("city"))
{
_bu_userinfo.City = item["City"].ToString();
}
bu_userinfos.Add(_bu_userinfo);
}
return(bu_userinfos);
}
/// <summary>
/// 向数据库插入一条新数据 返回插入的自增长值
/// </summary>
/// <param name="_bU_UserInfo">需要插入的对象</param>
/// <returns></returns>
public long Add(BU_UserInfo _bU_UserInfo)
{
return(_dal.Add(_bU_UserInfo));
}
private void button1_Click(object sender, EventArgs e)
{
string select = cmbQuestion.SelectedIndex.ToString();
string password = this.txt_anask.Text;
BU_UserInfo Bll = new BU_UserInfo();
if (Pagetype == "false")//完善个人资料
{
if (select == "-1")
{
MessageBox.Show("请选择密保!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (password == "")
{
MessageBox.Show("回答不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
bool flag = Bll.UpdateU_PsdAnswer(Convert.ToInt32(select), password, LoginRoler.U_Id);
if (flag)
{
this.Close();
}
else
{
MessageBox.Show("申请失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
else //登录
{
string username = this.txt_UserName.Text;
if (username == "")
{
MessageBox.Show("用户名不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (select == "-1")
{
MessageBox.Show("请选择密保!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (password == "")
{
MessageBox.Show("回答不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
int a = Bll.ExistsName(username);
if (a != 0)
{
//密码处理,经过加密
DataSet ds = Bll.ShowPwd(username, password.Trim());
string PWD = ds.Tables[0].Rows[0][0].ToString();
if (PWD != "")
{
MessageBox.Show("查询成功!你的密码是:<" + PWD + "> 请牢记", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("密保输入错误,请重新输入密保", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.txt_anask.Text = "";
}
}
else
{
MessageBox.Show("用户名不存在,请重新输入用户名", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.txt_UserName.Text = "";
}
}
}
}
/// <summary>
/// 更新数据库的一条记录
/// </summary>
/// <param name="_bU_UserInfo">需要更新的对象</param>
/// <returns></returns>
public int Update(BU_UserInfo _bU_UserInfo)
{
return(_dal.Update(_bU_UserInfo));
}
/// <summary>
/// 登录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string username = this.txt_username.Text;
string password = this.txt_Pwd.Text;
if (username == "")
{
MessageBox.Show("用户名不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (password == "")
{
MessageBox.Show("密码不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else if (this.textBox1.Text.Trim() == "")
{
MessageBox.Show("验证码不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
if (checkCode.ToLower() != this.textBox1.Text.Trim().ToLower())
{
MessageBox.Show("验证码输入错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
BU_UserInfo Bll = new BU_UserInfo();
int a = Bll.ExistsName(username);
if (a != 0)
{
//密码处理,经过加密
byte[] result = Encoding.Default.GetBytes(password);//password为输入密码的文本框
MD5 md5 = new MD5CryptoServiceProvider();
byte[] output = md5.ComputeHash(result);
DataSet ds = Bll.ExistsPwd(username, BitConverter.ToString(output).Replace("-", ""));
if (ds.Tables[0].Rows.Count > 0)
{
LoginRoler.U_Id = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); //用户主键
LoginRoler.U_Name = username; //获取当前登录的用户名
LoginRoler.U_ROlesType = Convert.ToInt32(ds.Tables[0].Rows[0][1].ToString()); //用户类型
LoginRoler.U_DpaType = Convert.ToInt32(ds.Tables[0].Rows[0][2].ToString()); //
LoginRoler.U_Position = ds.Tables[0].Rows[0][3].ToString(); //
this.Visible = false;
checkCode = "";
Frm登陆成功显示进度 frm = new Frm登陆成功显示进度();
frm.ShowDialog();
}
else
{
MessageBox.Show("密码输入错误,请重新输入密码", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.txt_Pwd.Text = "";
this.txt_username.Text = "";
this.textBox1.Text = "";
pictureBox2_Click(sender, e);//调用刷新验证码方法
}
}
else
{
MessageBox.Show("用户名不存在,请重新输入用户名", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.txt_Pwd.Text = "";
this.txt_username.Text = "";
this.textBox1.Text = "";
pictureBox2_Click(sender, e);//调用刷新验证码方法
}
}
}
}
/// <summary>
/// 向数据库插入一条新数据 返回插入的自增长值
/// </summary>
/// <param name="_bU_UserInfo">需要插入的对象</param>
/// <returns></returns>
public long Add(BU_UserInfo _bU_UserInfo)
{
object obj = db.ExecuteScalar(insertText, CommandType.Text,
new SqlParameter[] {
new SqlParameter("@UserNO", SqlDbType.VarChar, 32)
{
Value = _bU_UserInfo.UserNO
}
, new SqlParameter("@UserName", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.UserName
}
, new SqlParameter("@LoginName", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.LoginName
}
, new SqlParameter("@Pwd", SqlDbType.NVarChar, 500)
{
Value = _bU_UserInfo.Pwd
}
, new SqlParameter("@ToKen", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.ToKen
}
, new SqlParameter("@Gender", SqlDbType.VarChar, 2)
{
Value = _bU_UserInfo.Gender
}
, new SqlParameter("@BirthDate", SqlDbType.DateTime, 23)
{
Value = _bU_UserInfo.BirthDate
}
, new SqlParameter("@Mobile", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.Mobile
}
, new SqlParameter("@Telephone", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.Telephone
}
, new SqlParameter("@Fax", SqlDbType.NVarChar, 32)
{
Value = _bU_UserInfo.Fax
}
, new SqlParameter("@QQ", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.QQ
}
, new SqlParameter("@Email", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.Email
}
, new SqlParameter("@CreateTime", SqlDbType.DateTime, 23)
{
Value = _bU_UserInfo.CreateTime
}
, new SqlParameter("@UpdateTime", SqlDbType.DateTime, 23)
{
Value = _bU_UserInfo.UpdateTime
}
, new SqlParameter("@ProvinceCode", SqlDbType.NVarChar, 6)
{
Value = _bU_UserInfo.ProvinceCode
}
, new SqlParameter("@Province", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.Province
}
, new SqlParameter("@CityCode", SqlDbType.NVarChar, 6)
{
Value = _bU_UserInfo.CityCode
}
, new SqlParameter("@City", SqlDbType.NVarChar, 50)
{
Value = _bU_UserInfo.City
}
});
return(obj is DBNull ? 0 : Convert.ToInt64(obj));
}
