/// <summary>
/// 根据表名获取记录
/// </summary>
/// <param name="TableName"></param>
/// <returns></returns>
public static Models.DB.RoleInfoModel SelectRoleInfoModel(string TableName)
{
Models.DB.RoleInfoModel RoleInfo = new Models.DB.RoleInfoModel();
RoleInfo.TableName = TableName;
System.Data.DataTable dt = DAL.Select.GetList(RoleInfo, "TableName");
if (dt.Rows.Count > 0)
{
RoleInfo.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
RoleInfo.Name = dt.Rows[0]["Name"].ToString();
RoleInfo.TableName = dt.Rows[0]["TableName"].ToString();
RoleInfo.RoleId = Convert.ToInt32(dt.Rows[0]["RoleId"]);
RoleInfo.AdminDirectory = dt.Rows[0]["AdminDirectory"].ToString();
}
return(RoleInfo);
}
/// <summary>
/// 根据Enable获取数据
/// </summary>
/// <param name="Enable"></param>
/// <param name="pagesize"></param>
/// <param name="currentPage"></param>
/// <returns></returns>
public static List <Models.DB.StudentInfoModel> SelectByEnable(string Enable, int pagesize, int currentPage)
{
List <Models.DB.StudentInfoModel> Students = new List <Models.DB.StudentInfoModel>();
bool enable = true;
if (string.IsNullOrEmpty(Enable))
{
return(Students);
}
try
{
enable = Convert.ToBoolean(Enable);
}
catch
{
return(Students);
}
Models.DB.StudentInfoModel Student = new Models.DB.StudentInfoModel();
Models.DB.User User = new Models.DB.User();
Models.DB.RoleInfoModel Model = BLL.RoleInfoModel.SelectRoleInfoModel("Tb_StudentInfoModel");
List <Models.DB.Role> Roles = BLL.Role.SelectRole(Model.Id);
if (Roles.Count <= 0)
{
return(Students);
}
User.Enable = enable;
User.RoleId = Roles[0].ID;
string[] targets = { "RoleId", "Enable" };
System.Data.DataTable dt = DAL.Select.GetSome(User, targets, pagesize, currentPage, "ID", "");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Student = BLL.StudentInfoModel.SelectOneByUserId(dt.Rows[i]["Id"].ToString());
Students.Add(Student);
}
}
return(Students);
}
private void initRoles()
{
Models.DB.RoleInfoModel RoleInfo = BLL.RoleInfoModel.SelectRoleInfoModel("Tb_AdminModel");
Roles = BLL.Role.SelectRole(RoleInfo.Id);
}
