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