public JsonResult GetOrderNumber()
{
rtn_data rtn = new rtn_data();
try
{
AllocationOrder.AllocationOrderRule rule = allocationOrder.UserRule(this.UserValidator.UserID);
if (rule != null)
{
//条件
string condtions = "";
#region 道类型
if (rule.ChannelType == "内网")
{
condtions += " and app.createdbyparentid ='28a0ba01-4f58-4097-96cb-77c2b09e8253'";
}
else if (rule.ChannelType == "外网")
{
condtions += " and app.createdbyparentid ='9b8eb0fb-31c2-4577-bea7-9e453812f863'";
}
#endregion
#region 资产类型
if (!string.IsNullOrEmpty(rule.AssetCondition))
{
condtions += " and vehicle.condition='" + rule.AssetCondition + "'";
}
#endregion
#region 审核额度
condtions += " and contract.amount_financed>=" + rule.LoanAmountFrom;
condtions += " and contract.amount_financed<=" + rule.LoanAmountTo;
#endregion
#region SQL
string sql = allocationOrder.GetQueryTaskSql(condtions);
#endregion
int filterNumber = AppUtility.Engine.EngineConfig.CommandFactory.CreateCommand().ExecuteDataTable(sql).Rows.Count;
int totalNumber = allocationOrder.GetTaskTotalNumber();
rtn.code = 1;
rtn.data = "满足[" + filterNumber + "]/总[" + totalNumber + "]";
}
else
{
rtn.code = -1;
rtn.message = "无分单规则";
}
return(Json(rtn));
}
catch (Exception ex)
{
rtn.code = -1;
rtn.message = "查询异常";
return(Json(rtn));
}
}
