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