/// <summary> /// 添加一个用户 /// 返回 true 表示成功 /// 返回 false 表示该数据已存在 /// </summary> /// <param name="_user"></param> /// <returns></returns> public bool AddData(Renting_Management_System.Models.UserMod _user) { user = new Renting_Management_System.Models.UserMod(); user = SelectByID(_user.UserID); if (user == null) { StringBuilder insertStr = new StringBuilder(); insertStr.Append("Insert Into [User] "); insertStr.Append("(用户编号,用户名称,性别,出生日期,用户密码,用户类代码,证件类代码,证件号码,联系方式,用户地址,用户描述,用户拒绝)"); insertStr.Append(" Values ('"); insertStr.Append(_user.UserID + "','"); insertStr.Append(_user.UserName + "','"); insertStr.Append(_user.Sex + "','"); insertStr.Append(_user.BirthDate.Date.ToShortDateString()+ "','"); insertStr.Append(_user.UserPassword + "','"); insertStr.Append(_user.UserTypeCode + "','"); insertStr.Append(_user.CertificateTypeCode + "','"); insertStr.Append(_user.CertificateNumber + "','"); insertStr.Append(_user.UserContact + "','"); insertStr.Append(_user.UserAddress + "','"); insertStr.Append(_user.UserDescription + "','"); insertStr.Append(_user.UserDeny.ToString()); insertStr.Append("')"); da = new DBConnection(); da.InsertQuery(insertStr.ToString()); return true; } else { return false; } }
/// <summary> /// 登录之后,获取一个用户名称 /// </summary> /// <returns></returns> public string GetUserName() { userDAL = new Renting_Management_System.DAL.UserDAL(); user = new Renting_Management_System.Models.UserMod(); user = userDAL.SelectByID(userID); return user.UserName; }
/// <summary> /// 登录系统,返回 true 表示正确 /// </summary> /// <param name="_user"></param> /// <returns></returns> public bool Login(Renting_Management_System.Models.UserMod _user) { Renting_Management_System.Models.UserMod user = new Renting_Management_System.Models.UserMod(); Renting_Management_System.DAL.UserDAL userDAL = new Renting_Management_System.DAL.UserDAL(); user = userDAL.SelectByID(_user.UserID); if (user != null) { if (user.UserPassword == _user.UserPassword && user.UserTypeCode == _user.UserTypeCode) { return true; } else { return false; } } else { return false; } }
/// <summary> /// 删除一个用户 /// 返回 true 表示删除成功 /// 返回 false 表示数据不存在 /// </summary> /// <param name="_userID"></param> /// <returns></returns> public bool DeleteData(string _userID) { user = new Renting_Management_System.Models.UserMod(); user = SelectByID(_userID); if (user != null) { StringBuilder deleteStr = new StringBuilder(); deleteStr.Append("Delete From [User]"); deleteStr.Append("Where 用户编号 = '"); deleteStr.Append(_userID); deleteStr.Append("'"); da = new DBConnection(); da.DeleteQuery(deleteStr.ToString()); return true; } else { return false; } }
/// <summary> /// 查找按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button_Check_Click(object sender, EventArgs e) { userMod = new Renting_Management_System.Models.UserMod(); userDAL = new Renting_Management_System.DAL.UserDAL(); if (textBox_UserID.Text != "") userMod = userDAL.SelectByID(textBox_UserID.Text.Trim()); else userMod = userDAL.SelectByName(textBox_UserName.Text.Trim()); if (userMod == null) { MessageBox.Show("该用户的编号或名称不存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { textBox_UserID.Text = userMod.UserID; textBox_UserName.Text = userMod.UserName; textBox_UserPassword01.Text = userMod.UserPassword; textBox_UserPassword02.Text = userMod.UserPassword; comboBox_UserType.SelectedValue = userMod.UserTypeCode; if (userMod.UserDeny) radioButton_DenyYes.Checked = true; else radioButton_DenyNo.Checked = true; dateTimePicker_BirthDate.Text = userMod.BirthDate.ToLongDateString(); if (userMod.Sex == 'F') radioButton_SexGirl.Checked = true; else radioButton_SexBoy.Checked = true; comboBox_CertificateType.SelectedValue = userMod.CertificateTypeCode; textBox_CertificateNumber.Text = userMod.CertificateNumber; textBox_Contact.Text = userMod.UserContact; textBox_UserAddress.Text = userMod.UserAddress; textBox_UserDescription.Text = userMod.UserDescription; textBox_UserID.Enabled = false; button_Delete.Enabled = true; button_Modify.Enabled = true; button_Check.Enabled = false; } }
/// <summary> /// 登录按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Loginbutton_Click(object sender, EventArgs e) { bool yes; user = new Renting_Management_System.Models.UserMod(); user.UserID = UserIDtextBox.Text; user.UserPassword = UserPasswordtextBox.Text; if (UserTypecomboBox.SelectedValue == null) { UserTypecomboBox.SelectedIndex = 0; } user.UserTypeCode = UserTypecomboBox.SelectedValue.ToString(); userID = UserIDtextBox.Text.Trim(); userTypeName = UserTypecomboBox.Text; form = new Renting_Management_System.BLL.FormBLL(); yes = form.Login(user); if (yes) { if(form.Deny(user)) { MessageBox.Show("用户已被拒绝,请跟管理员联系!"); return; } else { form.OpenForm(user.UserTypeCode); this.Hide(); } } else { MessageBox.Show("用户编号、用户密码有误,请重试!"); return; } }
private void button_Add_Click(object sender, EventArgs e) { if (textBox_UserID.Text == "" || textBox_UserName.Text == "" || textBox_UserPassword01.Text == "" || textBox_UserPassword02.Text == "") { MessageBox.Show("用户登录信息区有些不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (textBox_UserPassword01.Text != textBox_UserPassword02.Text) { MessageBox.Show("再次输入密码不正确,请重试!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { userDAL = new Renting_Management_System.DAL.UserDAL(); userMod = new Renting_Management_System.Models.UserMod(); userMod.UserID = textBox_UserID.Text.Trim(); userMod.UserName = textBox_UserName.Text.Trim(); userMod.UserPassword = textBox_UserPassword01.Text.Trim(); if (comboBox_UserType.SelectedValue == null) { comboBox_UserType.SelectedIndex = 0; } userMod.UserTypeCode = comboBox_UserType.SelectedValue.ToString().Trim(); if (radioButton_DenyNo.Checked) { userMod.UserDeny = false; } else { userMod.UserDeny = true; } userMod.BirthDate = dateTimePicker_BirthDate.Value; if (radioButton_SexGirl.Checked) { userMod.Sex = 'F'; } else { userMod.Sex = 'M'; } if (comboBox_CertificateType.SelectedValue == null) { comboBox_CertificateType.SelectedIndex = 0; } userMod.CertificateTypeCode = comboBox_CertificateType.SelectedValue.ToString().Trim(); userMod.CertificateNumber = textBox_CertificateNumber.Text.Trim(); userMod.UserContact = textBox_Contact.Text.Trim(); userMod.UserAddress = textBox_UserAddress.Text.Trim(); userMod.UserDescription = textBox_UserDescription.Text.Trim(); if (userDAL.AddData(userMod)) { MessageBox.Show("添加用户成功!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox_UserID.Clear(); textBox_UserName.Clear(); textBox_UserPassword01.Clear(); textBox_UserPassword02.Clear(); textBox_UserDescription.Clear(); textBox_UserAddress.Clear(); textBox_Contact.Clear(); textBox_CertificateNumber.Clear(); comboBox_CertificateType.SelectedIndex = -1; comboBox_UserType.SelectedIndex = -1; dateTimePicker_BirthDate.Value = DateTimePicker.MinimumDateTime; radioButton_DenyNo.Checked = false; radioButton_DenyYes.Checked = false; radioButton_SexBoy.Checked = false; radioButton_SexGirl.Checked = false; button_Add.Enabled = false; return; } else { MessageBox.Show("该编号已存在,请重试!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } }
/// <summary> /// 修改用户按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button_Modify_Click(object sender, EventArgs e) { userDAL = new Renting_Management_System.DAL.UserDAL(); userMod = new Renting_Management_System.Models.UserMod(); userMod.UserID = textBox_UserID.Text.Trim(); userMod.UserName = textBox_UserName.Text.Trim(); userMod.UserPassword = textBox_UserPassword01.Text.Trim(); if (comboBox_UserType.SelectedValue == null) { comboBox_UserType.SelectedIndex = 0; } userMod.UserTypeCode = comboBox_UserType.SelectedValue.ToString().Trim(); if (radioButton_DenyNo.Checked) { userMod.UserDeny = false; } else { userMod.UserDeny = true; } userMod.BirthDate = DateTime.Parse(dateTimePicker_BirthDate.Value.ToShortDateString()); if (radioButton_SexGirl.Checked) { userMod.Sex = 'F'; } else { userMod.Sex = 'M'; } if (comboBox_CertificateType.SelectedValue == null) { comboBox_CertificateType.SelectedIndex = 0; } userMod.CertificateTypeCode = comboBox_CertificateType.SelectedValue.ToString().Trim(); userMod.CertificateNumber = textBox_CertificateNumber.Text.Trim(); userMod.UserContact = textBox_Contact.Text.Trim(); userMod.UserAddress = textBox_UserAddress.Text.Trim(); userMod.UserDescription = textBox_UserDescription.Text.Trim(); if (userDAL.ModifyData(userMod)) { textBox_UserID.Enabled = true; button_Check.Enabled = false; button_Delete.Enabled = false; button_Modify.Enabled = false; MessageBox.Show("修改用户成功!", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } }
/// <summary> /// 通过用户名称可以获取一个用户 /// 返回null 表示没有改用户 /// </summary> /// <param name="_userName"></param> /// <returns></returns> public Renting_Management_System.Models.UserMod SelectByName(string _userName) { StringBuilder selectStr = new StringBuilder(); selectStr.Append("Select * From [User]"); selectStr.Append("Where 用户名称 = '"); selectStr.Append(_userName); selectStr.Append("'"); da = new DBConnection(); DataSet ds = new DataSet(); ds = da.SelectQuery(selectStr.ToString()); if (ds.Tables[0].Rows.Count == 0) { return null; } else { user = new Renting_Management_System.Models.UserMod(); user.UserID = ds.Tables[0].Rows[0]["用户编号"].ToString().Trim(); user.UserName = ds.Tables[0].Rows[0]["用户名称"].ToString().Trim(); user.Sex = char.Parse(ds.Tables[0].Rows[0]["性别"].ToString().Trim()); if (ds.Tables[0].Rows[0]["出生日期"].ToString().Trim() != "") { user.BirthDate = DateTime.Parse(ds.Tables[0].Rows[0]["出生日期"].ToString().Trim()); } user.UserPassword = ds.Tables[0].Rows[0]["用户密码"].ToString().Trim(); user.UserTypeCode = ds.Tables[0].Rows[0]["用户类代码"].ToString().Trim(); user.CertificateTypeCode = ds.Tables[0].Rows[0]["证件类代码"].ToString().Trim(); user.CertificateNumber = ds.Tables[0].Rows[0]["证件号码"].ToString().Trim(); user.UserContact = ds.Tables[0].Rows[0]["联系方式"].ToString().Trim(); user.UserAddress = ds.Tables[0].Rows[0]["用户地址"].ToString().Trim(); user.UserDescription = ds.Tables[0].Rows[0]["用户描述"].ToString().Trim(); if (ds.Tables[0].Rows[0]["用户拒绝"].ToString().Trim() != "") { user.UserDeny = bool.Parse(ds.Tables[0].Rows[0]["用户拒绝"].ToString().Trim()); } return user; } }
/// <summary> /// 修改一个用户 /// 返回 true 表示成功,否则表示该用户信息不存在 /// </summary> /// <param name="_user"></param> /// <returns></returns> public bool ModifyData(Renting_Management_System.Models.UserMod _user) { user = new Renting_Management_System.Models.UserMod(); user = SelectByID(_user.UserID); if (user == null) { return false; } else { StringBuilder updateStr = new StringBuilder(); updateStr.Append("Update [User] "); updateStr.Append("Set "); updateStr.Append("用户名称 = '"); updateStr.Append(_user.UserName + "'"); updateStr.Append(",性别 = '"); updateStr.Append(_user.Sex + "'"); updateStr.Append(",出生日期 = '"); updateStr.Append(_user.BirthDate.ToShortDateString()); updateStr.Append("',用户密码 = '"); updateStr.Append(_user.UserPassword + "'"); updateStr.Append(",用户类代码 = '"); updateStr.Append(_user.UserTypeCode + "'"); updateStr.Append(",证件类代码 = '"); updateStr.Append(_user.CertificateTypeCode + "'"); updateStr.Append(",证件号码 = '"); updateStr.Append(_user.CertificateNumber + "'"); updateStr.Append(",联系方式 = '"); updateStr.Append(_user.UserContact + "'"); updateStr.Append(",用户地址 = '"); updateStr.Append(_user.UserAddress + "'"); updateStr.Append(",用户描述 = '"); updateStr.Append(_user.UserDescription + "'"); updateStr.Append(",用户拒绝 = '"); updateStr.Append(_user.UserDeny.ToString()); updateStr.Append("'"); updateStr.Append("Where 用户编号 = '"); updateStr.Append(_user.UserID + "'"); da = new DBConnection(); da.UpdateQuery(updateStr.ToString()); return true; } }