public ActionResult GetHelpTelPageList(WctHelpTelMstrQuery query) { try { query.CREATE_ORG_NO = AbpSession.ORG_NO; var result = _iWctHelpTelMstrRepository.GetHelpInfoPageList(query); return(Page(result.Data, result.Page)); } catch (Exception ex) { return(Fail(ex.Message)); } }
public PagerList <dynamic> GetHelpInfoPageList(WctHelpTelMstrQuery query) { string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO); var list = _sqlQuery.Select(@"TEL_ID, TEL_NAME, TEL_NO,TEL_ID_NO, CREATE_ORG_NO, CREATE_PSN, CREATE_DATE, UPDATE_PSN, UPDATE_DATE, BG_NO, case TEL_TYPE when 'insurance' then '保险' when 'help' then '救援' else '' end as TEL_TYPE") .Filter("DEL_FLAG", 1) .Filter("CREATE_ORG_NO", query.CREATE_ORG_NO) .Contains("TEL_NO", query.TEL_NO) .And(where) .OrderBy("CREATE_DATE DESC") .GetPageList <dynamic>(" WCT_HELP_TEL_MSTR", Context.Database.GetDbConnection(), query); return(list); }