public ActionResult GetQpaperMstrPageList(CrmQpaperMstrQuery query) { try { var result = _crmQpaperMstrRepository.GetCrmQpaperMstrPageList(query); return(Page(result.Data, result.Page)); } catch (Exception ex) { return(Fail(ex.Message)); } }
public PagerList <dynamic> GetCrmQpaperMstrPageList(CrmQpaperMstrQuery query) { string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO); return(_sqlQuery.Select(@"PAPER_ID, PAPER_NAME, PAPER_TYPE, INCLUDE_QUESTION_IDS, PAPER_SDATE, PAPER_EDATE, PAPER_DESC, PAPER_STATUS") .Filter("DEL_FLAG", 1) .Contains("PAPER_NAME", query.PAPER_NAME) .Filter("PAPER_TYPE", query.PAPER_TYPE) .Filter("PAPER_STATUS", query.PAPER_STATUS) .And(where) .OrderBy("CREATE_DATE desc") .GetPageList <dynamic>(" CRM_QPAPER_MSTR", Context.Database.GetDbConnection(), query)); }