/// <summary> /// 获取指定角色用户列表 /// </summary> public static List <Model.ROSOUser> GetUserListByRole(string role) { string sql = "select * from ROSO_User where Role=@Role"; SqlParameter[] p = { new SqlParameter("@Role", role) }; List <Model.ROSOUser> list = new List <Model.ROSOUser>(); using (SqlDataReader dr = SQLHelper.ExecuteReader(sql, CommandType.Text, p)) { while (dr.Read()) { Model.ROSOUser user = new Model.ROSOUser(); user.ID = Convert.ToInt32(dr["ID"]); user.Account = Convert.ToString(dr["Account"]); user.LastLoginTime = Convert.ToDateTime(dr["LastLoginTime"]); user.Password = Convert.ToString(dr["Password"]); user.Role = Convert.ToString(dr["Role"]); list.Add(user); } } return(list); }
/// <summary> /// 添加用户 /// </summary> public static bool AddUser(Model.ROSOUser user) { string sql = "insert into ROSO_User(Account,Password,Role,LastLoginTime) values(@Account,@Password,@Role,@LastLoginTime)"; SqlParameter[] p = { new SqlParameter("@Account", user.Account), new SqlParameter("@Password", user.Password), new SqlParameter("@Role", user.Role), new SqlParameter("@LastLoginTime", user.LastLoginTime) }; int i = SQLHelper.ExecuteNonQuery(sql, CommandType.Text, p); return(i > 0); }
private void button2_Click(object sender, EventArgs e) { //模拟添加管理员用户 Model.ROSOUser user = new Model.ROSOUser(); user.Account = "jerry"; user.Password = "******"; user.Role = "管理员"; user.LastLoginTime = DateTime.Now; if (!BLL.BL_User.UserIsExist(user.Account)) { BLL.BL_User.AddUser(user); } else { MessageBox.Show("帐号已经存在!"); } }
/// <summary> /// 获取所有用户列表 /// </summary> public static List <Model.ROSOUser> GetUserList() { string sql = "select * from ROSO_User order by Role desc"; List <Model.ROSOUser> list = new List <Model.ROSOUser>(); using (SqlDataReader dr = SQLHelper.ExecuteReader(sql, CommandType.Text, null)) { while (dr.Read()) { Model.ROSOUser user = new Model.ROSOUser(); user.ID = Convert.ToInt32(dr["ID"]); user.Account = Convert.ToString(dr["Account"]); user.LastLoginTime = Convert.ToDateTime(dr["LastLoginTime"]); user.Password = Convert.ToString(dr["Password"]); user.Role = Convert.ToString(dr["Role"]); list.Add(user); } } return(list); }
/// <summary> /// 根据帐号获取用户 /// </summary> public static Model.ROSOUser GetUser(string account) { string sql = "select * from ROSO_User where Account=@Account"; SqlParameter[] p = { new SqlParameter("@Account", account) }; Model.ROSOUser user = new Model.ROSOUser(); using (SqlDataReader dr = SQLHelper.ExecuteReader(sql, CommandType.Text, p)) { if (dr.Read()) { user.ID = Convert.ToInt32(dr["ID"]); user.Account = Convert.ToString(dr["Account"]); user.LastLoginTime = Convert.ToDateTime(dr["LastLoginTime"]); user.Password = Convert.ToString(dr["Password"]); user.Role = Convert.ToString(dr["Role"]); } } return(user); }
/// <summary> /// 添加用户 /// </summary> public static bool AddUser(Model.ROSOUser user) { user.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(user.Password, "MD5"); return(DAL.DA_User.AddUser(user)); }