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);
}
