protected override AbstractRequestParams GetParams()
{
//查历史同步记录
var jobRecord = Helper.GetWhere <SyncJob_Definition>(new SyncJob_Definition()
{
JobClassName = this.JobName
}).FirstOrDefault();
var pars = new AcctOAStatusParam();
pars.acctCode = ConfigurationManager.AppSettings["dealerCode"];
if (jobRecord == null)
{
jobRecord = new SyncJob_Definition();
jobRecord.JobClassName = this.JobName;
jobRecord.LastExecute = DateTime.Now;
}
return(pars);
}
public bool AcctOaStatus(AcctOAStatusParam pars)
{
var token = CommonToken.GetToken();
var http = new ArrowInterface.ArrowInterface();
pars.acctCode = ConfigurationManager.AppSettings["dealerCode"];
var result = http.AcctOaStatus(token.Token, pars);
var Helper = new OracleDBHelper();
if (result.Success)
{
foreach (var row in result.Rows.AsParallel())
{
var conn = Helper.GetNewConnection();
conn.Open();
var tran = conn.BeginTransaction();
try
{
Helper.DeleteWithTran(row, tran);
Helper.DeleteWithTran <AcctOAStatusDetailed>($" AND ORDERNO='{row.orderNo}'", tran);
Helper.InsertWithTransation(row, tran);
}
catch (Exception e)
{
tran.Rollback();
conn.Close();
var message = $"OA同步结果插入失败：{JsonConvert.SerializeObject(row)}";
LogHelper.Info(message);
LogHelper.Error(e);
return(false);
}
tran.Commit();
}
}
return(result.Success);
}
public bool AcctOaStatus(AcctOAStatusParam pars)
{
LogHelper.Info($"接收参数 ：{JsonConvert.SerializeObject(pars)}");
return(methods.AcctOaStatus(pars));
}
/// <summary>
/// 8、审核状态回传
/// </summary>
/// <param name="token"></param>
/// <param name="pars"></param>
/// <returns></returns>
public AbsRequestResult <AcctOAStatus> AcctOaStatus(string token, AcctOAStatusParam pars)
{
return(BaseRequest <AbsRequestResult <AcctOAStatus> >(GlobParams.QueryAcctOAStatus, token, pars.ToDictionary()));
}
public bool AcctOaStatus(AcctOAStatusParam pars)
{
return(methods.AcctOaStatus(pars));
}
