public static bool Insert(Manager[] model, ref string e)
{
int count = model.Length;
for (int i = 0; i < count; i++)
{
string sql = "insert into tb_Manager values(@mID,@mPassword,@mType,@mDepartment)";
SqlParameter[] parameters =
{
new SqlParameter("@mID", SqlDbType.VarChar,10),
new SqlParameter("@mPassword",SqlDbType.Char,6),
new SqlParameter("@mType", SqlDbType.VarChar,10),
new SqlParameter("@mDepartment", SqlDbType.NVarChar,50)
};
parameters[0].Value = model[i].MID;
parameters[1].Value = model[i].MPassword;
parameters[2].Value = model[i].MType;
parameters[3].Value = model[i].MDepartment;
string exception = db.InsertExec(sql, parameters);
if (exception != "" && exception != null)
{
e = exception;
return false;
}
}
return true;
}
private DAL.Models.Manager ToObject(Model.Manager manager)
{
return(new DAL.Models.Manager()
{
SecondName = manager.SecondName
});
}
public static string login(Manager mag)//判断经理用户名密码是否一致
{
string str = "";
SqlDataReader sqlrd;
DataBase db = new DataBase();
string sql = "select tKey from tb_Manager where Name='" + mag.Name + "'";
sqlrd = db.GetDataReader(sql);
while (sqlrd.Read())
{
str = (string)(sqlrd["tKey"]);
}
return str;
}
//设置新密码
public bool SetNewPassword(string name, string password, string type)
{
if (type.ElementAt(1) == '1')
{
if (name == "" || password == "" )
return false;
Manager manager = new Manager();
manager.MID = name;
manager.MPassword = password;
manager.MType = type;
string ex = "";
if (ManagerBLL.Update(manager, ref ex))
{
return true;
}
else
{
return false;
}
}
else if (type.ElementAt(2) == '1')
{
if (name == "" || password == "" )
return false;
User user = new User();
user.UID = name;
user.UPassword = password;
user.UType = type;
string ex = "";
if (UserBLL.Update(user, ref ex))
{
return true;
}
else
{
return false;
}
}
else
return false;
}
public static bool Select(Manager manager, ref string e)
{
string mID = manager.MID;
string mPassword = manager.MPassword;
string mType = manager.MType;
string sql = "select * from tb_Manager where mID='" + mID + "' and mPassword='******' and mType like'" + mType + "'";
DataTable table = new DataTable();
table = db.QueryDataTable(sql, ref e);
if (table != null && table.Rows.Count > 0)
{
return true;
}
else
{
if (e != "" && e != null)
return false;
e = "用户名或密码错误!";
return false;
}
}
private void but_login_Click(object sender, EventArgs e)
{
manager_window maw = new manager_window();
if (this.text_name.Text != "" && this.text_psw.Text != ""&&(this.check_manger .Checked ||this.check_stf .Checked ))
{
if (this.check_stf .Checked )
{
Model.Stuff stf = new Stuff();
stf.Name = this.text_name.Text.Trim();
if (this.text_psw.Text == stfmanager.login_(stf))//验证员工用户名和密码是否一致
{
maw.Show();
}
else
{
MessageBox.Show("用户名或密码不正确！");
}
}
if (this.check_manger .Checked )
{
Model.Manager mag = new Manager();
mag.Name = this.text_name.Text.Trim();
if (this.text_psw.Text ==managet_ .login_ (mag))//验证员工用户名和密码是否一致
{
maw.Show();
}
else
{
MessageBox.Show("用户名或密码不正确！");
}
}
}
else
{ MessageBox.Show("请填写完整信息！"); }
}
public static string login_(Manager stf)
{
string str = Managers.login(stf);
return str;
}
public static bool UpdatePassword(string mID, string mType, string mDepartment, string newPassword, ref string e)
{
Manager manager = new Manager();
manager.MID = mID;
manager.MType = mType;
manager.MDepartment = mDepartment;
manager.MPassword = newPassword;
return Update(manager, ref e);
}
public static bool Update(Manager model, ref string e)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Manager set ");
strSql.Append("mPassword=@mPassword,");
strSql.Append("mType=@mType,");
strSql.Append("mDepartment=@mDepartment");
strSql.Append(" where mID=@mID ");
SqlParameter[] parameters =
{
new SqlParameter("@mID", SqlDbType.VarChar,10),
new SqlParameter("@mPassword",SqlDbType.Char,6),
new SqlParameter("@mType", SqlDbType.VarChar, 10),
new SqlParameter("@mDepartment", SqlDbType.NVarChar,50)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.MPassword;
parameters[2].Value = model.MType;
parameters[3].Value = model.MDepartment;
e = db.QueryExec(strSql.ToString(), parameters);
if (e != "" && e != null)
{
return false;
}
return true;
}
public static bool Select(string mID, ref List<Manager> model, ref string e)
{
mID = mID.Trim();
string sql = "select * from tb_Manager where mID='" + mID + "'";
DataTable table = new DataTable();
table = db.QueryDataTable(sql, ref e);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
Manager manager = new Manager();
manager.MID = (string)table.Rows[i]["mID"];
manager.MPassword = (string)table.Rows[i]["mPassword"];
manager.MType = (string)table.Rows[i]["mType"];
manager.MDepartment = (string)table.Rows[i]["mDepartment"];
model.Add(manager);
}
return true;
}
else
{
if (e != "" && e != null)
return false;
e = "无此用户！";
return false;
}
}
public static bool Select(ref List<Manager> managers, ref string e,string sql)
{
DataTable table = new DataTable();
table = db.QueryDataTable(sql, ref e);
if (table != null && table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
Manager manager = new Manager();
manager.MID = (string)table.Rows[i]["mID"];
manager.MPassword = (string)table.Rows[i]["mPassword"];
manager.MDepartment = (string)table.Rows[i]["mDepartment"];
manager.MType = (string)table.Rows[i]["mType"];
managers.Add(manager);
}
return true;
}
else
{
if (e != "" && e != null)
return false;
e = "查询用户不存在";
return false;
}
}
