public int GetSHDSysNoByRefOrder(ERPShippingInfo shipInfo)
{
DataCommand dc = DataCommandManager.GetDataCommand("ECC_GetSHDSysNoByRefOrder");
dc.SetParameterValue("@RefOrderNo", shipInfo.RefOrderNo);
dc.SetParameterValue("RefOrderType", shipInfo.RefOrderType);
return(dc.ExecuteScalar <int>());
}
public static void DoWork(JobContext Context)
{
CurrentContext = Context;
var data = DA.GetERPOrder();
List <ERPShippingInfo> orderList = new List <ERPShippingInfo>();
OnShowInfo(string.Format("获取到{0}个ERP订单", data.Count));
foreach (var item in data)
{
ERPShippingInfo info = new ERPShippingInfo
{
RefOrderNo = item.RefOrderNo,
RefOrderType = "销售订单"
};
orderList.Add(info);
}
OnShowInfo(string.Format("调用ERP接口获取送货单列表..."));
orderList = CallSystemCreateService(orderList);
OnShowInfo(string.Format("ERP接口返回列表数：{0}", orderList.Count));
var result = orderList.Where(p => p.ShippingStatus == 1).Select(p => new ErpOrder {
RefOrderNo = p.RefOrderNo
}).ToList();
OnShowInfo(string.Format("有{0}个订单需要回刷状态", result.Count()));
foreach (var item in result)
{
DA.UpdateErpOrder(item);
}
OnShowInfo(string.Format("ERP订单回刷状态完成。", result.Count()));
var huodao = DA.GetHuoDao(result);
OnShowInfo(string.Format("有{0}个ERP订单为货到订单，需要生成收款单", huodao.Count()));
CallCreateSOIncomeService(huodao);
OnShowInfo(string.Format("收款单创建完成", huodao.Count()));
OnShowInfo(string.Format("全部工作完成。", huodao.Count()));
}
