/// <summary> /// 测试用户的合法性 /// </summary> /// <param name="vAIS_Users"></param> /// <returns></returns> public Model.v_UserInfos TestUser(Model.v_UserInfos vUser) { Model.v_UserInfos users = null; StringBuilder sql = new StringBuilder(); sql.Append("select UserID,UserAccount,UserName From UserInfos "); sql.Append(" where UserAccount=@UserAccount and UserPassword=@UserPassword "); MySqlParameter[] paras = new MySqlParameter[]{ new MySqlParameter("@UserAccount",vUser.UserAccount), new MySqlParameter("@UserPassword",vUser.UserPassword) }; using (MySqlDataReader reader = db.getSelectData(sql.ToString(), paras)) { if (reader.Read()) { users = new Model.v_UserInfos(); users.UserID = reader.GetDecimal(0); users.UserAccount = reader.GetString(1); users.UserName = reader.GetString(2); } reader.Close(); return users; } }
// 删除 public bool del(Model.v_UserInfos vUser) { StringBuilder sql = new StringBuilder(); sql.Append("Delete From UserInfos where UserID=@UserID"); MySqlParameter[] paras = new MySqlParameter[]{ new MySqlParameter("@UserID",vUser.UserID) }; return db.insert_or_update_or_delete(sql.ToString(), paras) > 0 ? true : false; }
/// <summary> /// 修改用户 /// </summary> /// <param name="vUser"></param> /// <returns></returns> public bool edit(Model.v_UserInfos vUser) { StringBuilder sql = new StringBuilder(); sql.Append("Update UserInfos Set UserPassword=@UserPassword,UserName=@UserName ,UserType=@UserType "); sql.Append(" where UserID=@UserID"); MySqlParameter[] paras = new MySqlParameter[]{ new MySqlParameter("@UserID",vUser.UserID), new MySqlParameter("@UserPassword",vUser.UserPassword), new MySqlParameter("@UserName",vUser.UserName), new MySqlParameter("@UserType",vUser.UserType) }; return db.insert_or_update_or_delete(sql.ToString(), paras) > 0 ? true : false; }
/// <summary> /// 测试账号是否已经存在 /// </summary> /// <param name="useraccount"></param> /// <returns></returns> public Model.v_UserInfos TestAccountIsExist(string useraccount) { Model.v_UserInfos users = null; string sql = string.Format("select UserAccount from UserInfos where UserAccount like '{0}%' order by UserAccount Desc", useraccount); using (MySqlDataReader reader = db.getSelectData(sql)) { if (reader.Read()) { users = new Model.v_UserInfos(); users.UserAccount = reader.GetString(0); } reader.Close(); return users; } }
public bool add(Model.v_UserInfos vUser) { StringBuilder sql = new StringBuilder(); sql.Append("Insert into UserInfos (UserID,UserAccount,UserPassword,UserName,UserType) "); sql.Append(" Values (@UserID,@UserAccount,@UserPassword,@UserName,@UserType)"); MySqlParameter[] paras = new MySqlParameter[]{ new MySqlParameter("@UserID",vUser.UserID), new MySqlParameter("@UserAccount",vUser.UserAccount), new MySqlParameter("@UserPassword",vUser.UserPassword), new MySqlParameter("@UserName",vUser.UserName), new MySqlParameter("@UserType",vUser.UserType) }; return db.insert_or_update_or_delete(sql.ToString(), paras) > 0 ? true : false; }