//根据用户Id查询用户信息 public static Users GetUserById(int id) { string sql = "select * from Users where Id=" + id; int userStateId; int userRoleId; using (SqlDataReader reader = DBHelper.GetReader(sql)) { if (reader.Read()) { Users us = new Users(); us.Id = (int)reader["Id"]; us.LoginId = (string)reader["LoginId"]; us.LoginPwd = (string)reader["LoginPwd"]; us.Name = (string)reader["Name"]; us.Address = (string)reader["Address"]; us.Phone = (string)reader["Phone"]; us.Mail = (string)reader["Mail"]; userStateId = (int)reader["UserStateId"]; userRoleId = (int)reader["UserRoleId"]; reader.Close(); us.UserStates = UserStateService.GetUserStateById(userStateId); //FK us.UserRoles = UserRoleService.GetUserRoleById(userRoleId); //FK return(us); } else { reader.Close(); return(null); } } }
//查询所有用户 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); }