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("Системна помилка при додаванні користувача");
}
}
