//查询所有用户
public static IList <Users> GetUsersAll()
{
IList <Users> list = new List <Users>();
string sql = "select * from Users";
DataTable table = DBHelper.GetDataSet(sql);
foreach (DataRow row in table.Rows)
{
Users us = new Users();
us.Id = (int)row["Id"];
us.LoginId = (string)row["LoginId"];
us.LoginPwd = (string)row["LoginPwd"];
us.Name = (string)row["Name"];
us.Address = (string)row["Address"];
us.Phone = (string)row["Phone"];
us.Mail = (string)row["Mail"];
us.UserStates = UserStateService.GetUserStateById((int)row["UserStateId"]); //FK
us.UserRoles = UserRoleService.GetUserRoleById((int)row["UserRoleId"]); //FK
list.Add(us);
}
return(list);
}