public ActionResult GetQpaperQuPageList(CrmQpaperQuQuery query) { try { var result = _crmQpaperQuRepository.GetCrmQpaperQuPageList(query); return(Page(result.Data, result.Page)); } catch (global::System.Exception ex) { return(Fail(ex.Message)); } }
public PagerList <dynamic> GetCrmQpaperQuPageList(CrmQpaperQuQuery query) { string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO); return(_sqlQuery.Select(@"QU_ID, QU_SN, QU_TYPE, QU_NAME, QU_ENABLED, QU_ANSWER, PAPER_TYPE") .Filter("DEL_FLAG", 1) .Filter("QU_SN", query.QU_SN) .Contains("QU_NAME", query.QU_NAME) .Filter("PAPER_TYPE", query.PAPER_TYPE) .Filter("QU_TYPE", query.QU_TYPE) .Filter("QU_ENABLED", query.QU_ENABLED) .OrderBy("CREATE_DATE desc") .GetPageList <dynamic>(" CRM_QPAPER_QU", Context.Database.GetDbConnection(), query)); }