public ObjEntity GetList(int DeptId, PagerInfo pageInfo)
{
string sql = "select * from Sys_User where DeptId=@DeptId";
List<SqlParam> list = new List<SqlParam>();
list.Add(new SqlParam("DeptId", DeptId));
return new Helper().ExecutePages<Sys_User>(sql, pageInfo, list);
}
public ObjEntity GetDataTablePager(PagerInfo pageInfo)
{
StringBuilder sb = new StringBuilder();
sb.Append("select * from munich_re where IsTrue=@IsTrue");
List<SqlParam> list = new List<SqlParam>();
list.Add(new SqlParam("IsTrue", 0));
return new Helper().ExecuteDataTablePagerInfo(sb.ToString(), list, pageInfo);
}
public ObjEntity GetList(PagerInfo pageInfo)
{
string sql = "select * from Sys_Role ";
return new Helper().ExecutePages<Sys_Role>(sql, pageInfo, null);
}
public ObjEntity GetPagerList(PagerInfo pageInfo, List<SqlParamList> list)
{
ObjEntity result = new Helper().ExecutePage(new munich_re(), pageInfo, list);
return result;
}