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)); }