public ActionResult GetFinancePolicyList(CarFinancePolicyQuery query) { try { var result = _carFinancePolicyRepository.GetFinancePolicyList(query); return(Page(result.Data, result.Page)); } catch (Exception ex) { return(Fail(ex.Message)); } }
/// <summary> /// 获取金融政策分页数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public dynamic GetFinancePolicyList(CarFinancePolicyQuery query) { string where = _permissionHelper.GetCondition(AbpSession.USR_TYPE, AbpSession.USR_SCOPE, "CREATE_ORG_NO", AbpSession.ORG_NO, AbpSession.BG_NO); return(_sqlQuery.Select("*") .Filter("DEL_FLAG", 1) .Filter("BIZ_TYPE", query.BIZ_TYPE) .Filter("BRAND_CODE", query.BRAND_CODE) .Filter("CLASS_CODE", query.CLASS_CODE) .Filter("TYPE_CODE", query.TYPE_CODE) .Filter("SUBTYPE_CODE", query.SUBTYPE_CODE) .Contains("TAG_IDS", query.TAG_IDS) .And(where) .OrderBy("CREATE_DATE desc") .GetPageList <dynamic>("CAR_FINANCE_POLICY", Context.Database.GetDbConnection(), query)); }