public string Login() { string ans = ""; long l = Request.InputStream.Length; try { if (l > 0) { byte[] buffer = new byte[l]; Request.InputStream.Read(buffer, 0, (int)l); var data = (Encoding.Default.GetString(buffer)).Split(','); Entity.Login log = new Entity.Login( data[0], data[1] ); BrUser brUser = new BrUser(); ans = brUser.Login(log); } } catch (Exception e) { return(e.Message); } return(ans); }
/// <summary> /// 添加新登录用户 /// </summary> /// <param name="user">登录用户实体</param> /// <returns></returns> public int AddUsers(Entity.Login user) { string sql = "insert into Login values('" + user.username + "','" + user.password + "','" + user.level + "','" + user.status + "')"; int res = sqlhelper.ExecuteNonQuery(sql); return(res); }
/// <summary> /// 删除登录用户 /// </summary> /// <param name="user">用户实体</param> /// <returns></returns> public int DeleteUsers(Entity.Login user) { string sql = "delete from Login where UserName='******' And Password='******'"; int res = sqlhelper.ExecuteNonQuery(sql); return(res); }
/// <summary> /// 判断用户密码是否正确,并返回状态信息 /// </summary> /// <param name="user">用户实体</param> /// <returns></returns> public string JudgePassword(Entity.Login user) { string sql = "select UserName,Password,Status from Login where UserName='******' And Password='******'"; DataTable dt = sqlhelper.ExecuteQuery(sql); if (dt.Rows.Count > 0) { return(Convert.ToString(dt.Rows[0][2])); } return(Convert.ToString(false)); }
private void btnDelete_Click(object sender, EventArgs e) //删除用户按钮 { Entity.Login user = new Entity.Login(); user.username = txtUserName.Text.Trim(); user.password = txtPassword.Text.Trim(); Facade.LoginUsers fuser = new Facade.LoginUsers(); int result = fuser.deleteusers(user); if (result > 0) { MessageBox.Show("删除成功!", "温馨提示"); } }
private void btnLogin_Click(object sender, EventArgs e) { Facade.LoginUsers user = new Facade.LoginUsers(); string username = txtUserName.Text.Trim(); //获取界面输入的用户名 string password = txtPassword.Text.Trim(); //获取界面输入的密码 Entity.GoAnyWhere.id = username; // 将登陆id赋值给全局变量 Entity.Login users = new Entity.Login(); users.username = username; users.password = password; if (username == "") //判断用户名是否为空 { MessageBox.Show("请输入用户名!", "温馨提示"); } else if (password == "") //判断密码是否为空 { MessageBox.Show("请输入密码!", "温馨提示"); } else { bool result = user.username(username); if (result == false) //判断用户是否存在 { MessageBox.Show("您输入的用户名不存在!", "温馨提示"); } else { //判断密码是否正确 Facade.LoginUsers pwd = new Facade.LoginUsers(); string result2 = pwd.password(users); if (result2 == Convert.ToString(false)) { MessageBox.Show("密码错误,请重新输入!", "温馨提示"); } //判断是否允许登录 else if (result2.Trim() == "禁止登录") { MessageBox.Show("非法用户,请到前台开户!", "温馨提示"); } else { //判断用户的类型 string result3 = user.userlevel(username); Entity.GoAnyWhere.level = result3; this.DialogResult = DialogResult.OK; //上面的执行成功则显示主窗体 } } } }
private void button1_Click(object sender, EventArgs e) //点击确定添加按钮 { Facade.Consumers consumer = new Facade.Consumers(); //判断卡号是否存在 string cardno = txtCardno.Text.Trim(); DataTable dt = consumer.ReturnConsumeinfo(cardno); if (dt.Rows.Count > 0) { MessageBox.Show("此用户已存在,请确认后重新输入!", "温馨提示"); txtCardno.SelectAll(); } else { Entity.Consumers cs = new Entity.Consumers(); cs.cardno = txtCardno.Text.Trim(); cs.name = txtName.Text.Trim(); cs.age = txtAge.Text.Trim(); cs.gender = cboGender.Text.Trim(); cs.money = txtAddMoney.Text.Trim(); cs.status = cboStatus.Text.Trim(); cs.sno = Entity.GoAnyWhere.id; cs.addtime = DateTime.Now; //将界面获取的数据插入到数据库中 int result = consumer.addconsumers(cs); //插入到消费者信息表 if (result > 0) { MessageBox.Show("添加成功!", "温馨提示"); //将消费者信息插入到登录表中 Entity.Login user = new Entity.Login(); user.username = txtCardno.Text.Trim(); user.password = "******"; user.level = "用户"; user.status = cboStatus.Text.Trim(); Facade.LoginUsers fuser = new Facade.LoginUsers(); int result2 = fuser.addusers(user); } else { MessageBox.Show("添加失败,请联系管理员", "温馨提示"); } } }
private void btnOk_Click(object sender, EventArgs e) //单击确定按钮 { Entity.Login user = new Entity.Login(); user.username = txtUserName.Text.Trim(); user.password = txtPassword.Text.Trim(); user.level = "收银员"; user.status = "允许登录"; //判断用户是否已经存在 Facade.LoginUsers fuser = new Facade.LoginUsers(); bool result = fuser.username(user.username); if (result == true) //判断用户是否存在 { MessageBox.Show("您输入的用户名已存在!", "温馨提示"); } else { int result2 = fuser.addusers(user); if (result2 > 0) { MessageBox.Show("添加用户成功!", "温馨提示"); } } }
/// <summary> /// 删除用户 /// </summary> /// <param name="user">用户实体</param> /// <returns></returns> public int DeleteUsers(Entity.Login user) { return(iu.DeleteUsers(user)); }
/// <summary> /// 添加新用户 /// </summary> /// <param name="user">用户实体</param> /// <returns></returns> public int AddUsers(Entity.Login user) { return(iu.AddUsers(user)); }
/// <summary> /// 判断用户密码是否正确,并返回状态信息 /// </summary> /// <param name="user">用户实体</param> /// <returns></returns> public string JudgePassword(Entity.Login user) { return(iu.JudgePassword(user)); }
public int deleteusers(Entity.Login user) //删除用户 { return(users.DeleteUsers(user)); }
public int addusers(Entity.Login user) //添加用户 { return(users.AddUsers(user)); }
public string password(Entity.Login user) //判断用户密码是否正确,并返回状态信息 { return(users.JudgePassword(user)); }
private void CommandNewClick() { if (userNameText.Text.Trim() == "") { MessageBox.Show("Заповніть нікнейм користувача"); return; } if (userFullNameText.Text.Trim() == "") { MessageBox.Show("Заповніть повне ім'я користувача"); return; } if (rolesBox.SelectedValue.ToString() == "") { MessageBox.Show("Оберіть роль користувача"); return; } string[] tempFullName = userFullNameText.Text.Trim().Split(' '); if (tempFullName.Count() < 2) { MessageBox.Show("Повне ім'я користувача повинне складатись що найменше з двох слів"); return; } userPassword = "******"; userName = userNameText.Text.Trim(); userFullName = userFullNameText.Text.Trim(); string tempRole = rolesBox.SelectedValue.ToString(); try{ role = (from r in ceqacc.Role where r.role_name == tempRole select r.role_id).First().ToString(); } catch { MessageBox.Show("Сталась системна помилка"); return; } if ((from u in ceqacc.Login where u.name == userName select u.uid).Count() > 0) { MessageBox.Show("Користувач з таким ім'ям вже існує"); return; } try { int newuID = (from u in ceqacc.Login select u.uid).ToArray().Max() + 1; if (Convert.ToInt32(role) == 0 || Convert.ToInt32(role) == 1) { int newID = (from u in ceqacc.Admin select u.admin_id).ToArray().Max() + 1; Entity.Admin ad = new Entity.Admin { admin_id = newID, full_name = userFullName }; ceqacc.Admin.Add(ad); Entity.Login lgg = new Entity.Login { uid = newuID, id = newID, password = userPassword, role_id = Convert.ToInt16(role), name = userName }; ceqacc.Login.Add(lgg); ceqacc.SaveChanges(); MessageBox.Show("Користувача успішно додано!"); this.Hide(); } //else if(Convert.ToInt32(role) == 2) //{ // int newID = (from u in ceqacc.Driver select u.id_driver).ToArray().Max() + 1; // userBirthDate = new DateTime(2001, 1, 1); //Entity.Driver ads = new Entity.Driver //{ // id_driver = newID, //last_name = userFullName, //}; // ceqacc.Driver.Add(ads); //Entity.Login lgs = new Entity.Login // { // uid = newuID, // id = newID, // password = userPassword, // role_id = Convert.ToInt16(role), // name = userName //}; // ceqacc.Login.Add(lgs); // ceqacc.SaveChanges(); // MessageBox.Show("Користувача успішно додано!"); // this.Hide(); //} } catch { MessageBox.Show("Системна помилка при додаванні користувача"); } }