示例#1
0
 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);
 }
示例#2
0
 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);
 }
示例#3
0
 public ObjEntity GetList(PagerInfo pageInfo)
 {
     string sql = "select * from Sys_Role ";
     return new Helper().ExecutePages<Sys_Role>(sql, pageInfo, null);
 }
示例#4
0
 public ObjEntity GetPagerList(PagerInfo pageInfo, List<SqlParamList> list)
 {
     ObjEntity result = new Helper().ExecutePage(new munich_re(), pageInfo, list);
     return result;
 }