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; } }