62,074
社区成员
发帖
与我相关
我的任务
分享
IList<BL_UsersInfo> Users = new List<BL_UsersInfo>();
using (SqlDataReader dr = SqlDBHelper.ExecuteReader(SqlDBHelper.ConnectionString1, CommandType.StoredProcedure, "xp_User_SelectAll", null))
{
while (dr.Read())
{
BL_UsersInfo UserInfo = new BL_UsersInfo();
UserInfo.UserId = dr["U_Id"].ToString();
UserInfo.UserName = dr["U_Name"].ToString();
UserInfo.UserDescribe = dr["U_Describe"].ToString();
UserInfo.UserPwd = dr["U_Pwd"].ToString();
UserInfo.UserRole = dr["U_Role"].ToString();
Users.Add(UserInfo);
}
}
return Users;