//lcy
public static List <AdminsMDL> Getlist(AdminsMDL a)
{
string sql = "select * from admins where 1=1";
List <SqlParameter> list = new List <SqlParameter>();
List <AdminsMDL> list1 = new List <AdminsMDL>();
if (a != null)
{
if (a.userid > 0)
{
sql += " and userid=@userid";
list.Add(new SqlParameter("@username", a.UserName));
}
}
using (SqlDataReader sda = DBhelper.MySqlDataReader(sql, list.ToArray()))
{
while (sda.Read())
{
AdminsMDL ad = new AdminsMDL();
ad.userid = Convert.ToInt32(sda[0]);
ad.UserName = sda[1].ToString();
ad.UserCompellation = sda[3].ToString();
list1.Add(ad);
}
return(list1);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "")
{
new Warning("信息填写不完整", 图标.Erro).Show();
return;
}
try
{
AdminsMDL ad = new AdminsMDL();
ad.userid = AdminsMDL.USERID;
ad.UserName = textBox1.Text;
ad.UserCompellation = textBox2.Text;
int i = AdminsBLL.updateadmin(ad);
if (i > 0)
{
this.Close();
}
else
{
MessageBox.Show("修改失败");
}
}
catch (Exception)
{
MessageBox.Show("发生未只的异常,请联系开发者", "未知异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static int deleteadmin(AdminsMDL a)
{
string sql = "delete from admins where userid=@userid";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@userid", a.userid));
return(DBhelper.MyExecuteNonQuery(sql, list.ToArray()));
}
public static int insertadmin(AdminsMDL ad)
{
string sql = "insert into admins values(@username,@userpwd,@usercompellation,1,1,1,1)";
SqlParameter[] spt = { new SqlParameter("@username", ad.UserName),
new SqlParameter("@userpwd", ad.UserPWD),
new SqlParameter("@usercompellation", ad.UserCompellation) };
return(DBhelper.MyExecuteNonQuery(sql, spt));
}
public static string selectpwd(AdminsMDL a)
{
string sql = "select usercompellation from admins where username=@username and userpwd=@userpwd";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@username", a.UserName));
list.Add(new SqlParameter("@userpwd", a.UserPWD));
return(DBhelper.MyExecuteScalar(sql, list.ToArray()).ToString());
}
public static int updatepwd(AdminsMDL a, AdminsMDL aa)
{
string sql = "update admins set userpwd=@Uerpwd where username=@username and userpwd=@Userpwd";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@username", a.UserName));
list.Add(new SqlParameter("@userpwd", a.UserPWD));
list.Add(new SqlParameter("@Uerpwd", aa.UserPWD));
return(DBhelper.MyExecuteNonQuery(sql, list.ToArray()));
}
public static int logintype(AdminsMDL a)
{
string sql = "update admins set LoginType=@logintype where username=@username ";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@username", a.UserName));
list.Add(new SqlParameter("@logintype", a.LoginType));
return(Convert.ToInt32(DBhelper.MyExecuteNonQuery(sql, list.ToArray())));
}
public static int updateadmin(AdminsMDL a)
{
string sql = "update admins set username=@username,usercompellation=@usercompellation where userid=@userid";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@username", a.UserName));
list.Add(new SqlParameter("@usercompellation", a.UserCompellation));
list.Add(new SqlParameter("@userid", a.userid));
return(DBhelper.MyExecuteNonQuery(sql, list.ToArray()));
}
private void button1_Click(object sender, EventArgs e)
{
string username = txtUser.Text;
string userpwd = txtPwd.Text;
if (username == "请输入用户名")
{
new Warning("请输入用户名", 图标.Erro).Show();
//MessageBox.Show("请输入账号!");
return;
}
if (userpwd == "")
{
new Warning("请输入密码", 图标.Erro).Show();
return;
}
try
{
List <AdminsMDL> list = AdminsBLL.GetLogin(username);
if (list.Count > 0)
{
if (list[0].LoginType == 1)
{
//登录成功
admins.UserCompellation = list[0].UserCompellation;
admins.name = list[0].UserName;
admins.id = list[0].headID;
admins.UserId = list[0].userid;
AdminsMDL a = new AdminsMDL();
a.LoginType = 2;
a.UserName = username;
AdminsBLL.logintype(a);
FrmMain f = new FrmMain();
f.Show();
this.Hide();
}
else if (list[0].LoginType == 2)
{
new Warning("请勿重复登录", 图标.Erro).Show();
}
}
else
{
new Warning("密码错误", 图标.Erro).Show();
}
}
catch (Exception)
{
MessageBox.Show("发生未只的异常,请联系开发者", "未知异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FrmMain_FormClosing(object sender, FormClosingEventArgs e)
{
//主窗体关闭事件
AdminsMDL a = new AdminsMDL();
a.LoginType = 1;
a.UserName = admins.name;
AdminsBLL.logintype(a);
Application.Exit();
}
private void pictureBox7_Click(object sender, EventArgs e)
{
//锁定
AdminsMDL a = new AdminsMDL();
a.LoginType = 1;
a.UserName = admins.name;
AdminsBLL.logintype(a);
this.Hide();
new FrmLogin().Show();
}
private void button17_Click(object sender, EventArgs e)
{
if (listView4.SelectedItems.Count > 0)
{
if (listView4.SelectedItems[0].SubItems[0].Text == admins.UserId.ToString())
{
new Warning("不能删除当前用户", 图标.Erro).Show();
return;
}
AdminsMDL ad = new AdminsMDL();
ad.userid = Convert.ToInt32(listView4.SelectedItems[0].SubItems[0].Text);
AdminsBLL.deleteadmin(ad);
panel4_VisibleChanged(null, null);
}
}
private void button1_Click(object sender, EventArgs e)
{
string a = textBox1.Text;
string a1 = textBox2.Text;
string a2 = textBox3.Text;
string a3 = textBox4.Text;
if (a == "" || a1 == "" || a2 == "" || a3 == "")
{
new Warning("信息填写不完整", 图标.Erro).Show();
return;
}
if (a2 != a3)
{
new Warning("两次输入密码不一致", 图标.Erro).Show();
return;
}
try
{
AdminsMDL ad = new AdminsMDL();
ad.UserName = a;
ad.UserPWD = a1;
string aa = AdminsBLL.selectpwd(ad);
if (aa == "")
{
new Warning("用户名不存在", 图标.Erro).Show();
return;
}
AdminsMDL am = new AdminsMDL();
am.UserPWD = a2;
int b = AdminsBLL.updatepwd(ad, am);
if (b > 0)
{
new Warning("密码修改成功", 图标.Yes).Show();
}
}
catch (Exception)
{
MessageBox.Show("修改失败", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button1_Click(object sender, EventArgs e)
{
string UserName = textBox1.Text;
string UserPWD = textBox2.Text;
string userpwd = textBox3.Text;
string UserCompellation = textBox4.Text;
if (UserName == "" || UserPWD == "" || userpwd == "" || UserCompellation == "")
{
new Warning("信息填写不完整", 图标.Erro).Show();
return;
}
if (UserPWD != userpwd)
{
new Warning("两次密码填写不一致，请重新填写", 图标.Erro).Show();
return;
}
try
{
AdminsMDL ad = new AdminsMDL();
ad.UserName = textBox1.Text;
ad.UserPWD = textBox2.Text;
ad.UserCompellation = textBox4.Text;
int i = AdminsBLL.insertadmin(ad);
if (i > 0)
{
this.Close();
}
else
{
MessageBox.Show("添加失败");
}
}
catch (Exception)
{
MessageBox.Show("发生未只的异常,请联系开发者", "未知异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static List <AdminsMDL> GetLogin(string user)
{
string sql = "select * from admins where Username=@username";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@username", user));
SqlDataReader dr = DBhelper.MySqlDataReader(sql, list.ToArray());
List <AdminsMDL> ad = new List <AdminsMDL>();
while (dr.Read())
{
AdminsMDL adm = new AdminsMDL();
adm.userid = Convert.ToInt32(dr[0]);
adm.UserName = dr[1].ToString();
adm.UserPWD = dr[2].ToString();
adm.UserCompellation = dr[3].ToString();
adm.LoginType = Convert.ToInt32(dr[6]);
adm.headID = Convert.ToInt32(dr[7]);
ad.Add(adm);
}
dr.Close();
return(ad);
}
public static int deleteadmin(AdminsMDL a)
{
return(AdminsDAL.deleteadmin(a));
}
public static int updateadmin(AdminsMDL a)
{
return(AdminsDAL.updateadmin(a));
}
public static int insertadmin(AdminsMDL a)
{
return(AdminsDAL.insertadmin(a));
}
//lcy
public static List <AdminsMDL> getlist(AdminsMDL a)
{
return(AdminsDAL.Getlist(a));
}
public static int updatepwd(AdminsMDL aa, AdminsMDL am)
{
return(AdminsDAL.updatepwd(aa, am));
}
public static string selectpwd(AdminsMDL a)
{
return(AdminsDAL.selectpwd(a));
}
public static int logintype(AdminsMDL a)
{
return(AdminsDAL.logintype(a));
}
