using Demo.Common.Untility;
|
using Demo.Model.Log;
|
using Kingdee.BOS.Core.DynamicForm;
|
using Kingdee.BOS.Core.DynamicForm.PlugIn;
|
using Kingdee.BOS.Core.DynamicForm.PlugIn.Args;
|
using Kingdee.BOS.Orm.DataEntity;
|
using Kingdee.BOS.ServiceHelper;
|
using Kingdee.BOS.Util;
|
using Kingdee.BOS.WebApi.Client;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading;
|
using System.Threading.Tasks;
|
using ZD.Cloud.Logger;
|
using ZD.Cloud.WebApi;
|
|
namespace Demo.OperationService.SCM.SAL_SaleOrder
|
{
|
[HotUpdate]
|
[Description("销售订单审核拆单")]
|
public class SAL_SaleOrderSplitBill : AbstractOperationServicePlugIn
|
{
|
private void CreateQkForm(AfterExecuteOperationTransaction e)
|
{
|
var client = KingdeeClient.ApiLogin(Context);
|
|
foreach (var data in e.DataEntitys)
|
{
|
var billNo = data.GetValue<string>("BillNo");
|
|
LogService.WriteAsync("SAL_SaleOrderSplitBill=>"+billNo);
|
|
if (data.GetValue<bool>("FIsSplitBill") || data.GetValue<string>("RedBule") == "1") continue;
|
|
//LogService.WriteAsync($"BillNo={billNo},FIsSplitBill={data.GetValue<bool>("FIsSplitBill")},FISLAST={data.GetValue<bool>("FISLAST")},RedBule={data.GetValue<string>("RedBule")}");
|
|
var id = data.GetValue<int>("Id");
|
|
//如果单据已经是_A,在审核时候直接跳过执行
|
if (billNo.EndsWith("_A")) continue;
|
|
var sql = $"Exec V_FilterSaleOrder @id={id}";
|
|
var table = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0];
|
LogService.WriteAsync(table);
|
|
if (table.Rows.Count == 0) continue;
|
|
string sql3 = $"select top 1 F_YQN_ZDR,FNOTE from T_SAL_ORDER WHERE FID={id}";
|
var table3 = DBServiceHelper.ExecuteDataSet(this.Context, sql3).Tables[0];
|
|
var model = new
|
{
|
FBillTypeID = new
|
{
|
FNUMBER = Context.DBId == "5ffd9795291fb7" ? "XSDD01_SYS" : "XSDD101_SYS"
|
},
|
FDate = DateTime.Now,
|
FSaleOrgId = new
|
{
|
FNumber = "100"
|
},
|
FCustId = new
|
{
|
FNumber = "AR07000000022"
|
},
|
FReceiveId = new
|
{
|
FNumber = "AR07000000022"
|
},
|
FSaleGroupId = new
|
{
|
FNumber = "100002"
|
},
|
FSalerId = new
|
{
|
FNumber = "D080190016"
|
},
|
//FLinkPhone= "13757508209",
|
FSettleId = new
|
{
|
FNumber = "AR07000000022"
|
},
|
FChargeId = new
|
{
|
FNumber = "AR07000000022"
|
},
|
F_zzzz_Assistant = new
|
{
|
FNumber = "087"
|
},
|
FPAYCUSTOMER = new
|
{
|
FNUMBER = "AR07000000022"
|
},
|
FISGUARANTEE = true,
|
FBillNo = $"{billNo}_A",
|
F_YQN_ZDR = table3.Rows.Count == 0 ? string.Empty : table3.Rows[0][0],//制单人
|
FNOTE = table3.Rows.Count == 0 ? string.Empty : table3.Rows[0][1],//整单摘要
|
FSaleOrderEntry = table.AsEnumerable().Select(row => new
|
{
|
FSUBMATERIALNUMBER = new
|
{
|
FNumber = Context.DBId == "5ffd9795291fb7" ? "CSCS0001" : "F9900000000"
|
},
|
|
FRowType = "Standard",
|
FDeliveryDate = DateTime.Now,
|
FStockOrgId = new
|
{
|
FNumber = "100"
|
},
|
FSettleOrgIds = new
|
{
|
FNumber = "100"
|
},
|
FSupplyOrgId = new
|
{
|
FNumber = "100"
|
},
|
FOwnerTypeId = "BD_OwnerOrg",
|
FOwnerId = new
|
{
|
FNumber = "100"
|
},
|
FReserveType = "1",
|
FOUTLMTUNIT = "SAL",
|
FMaterialId = new
|
{
|
FNumber = row["MaterialNo"]
|
},
|
|
F_YQN_DYXH = "CS001",
|
FSOSTOCKID = new
|
{
|
FNumber = row["FStockNo"]
|
},
|
FLot = new
|
{
|
FNumber = row["LotNo"]
|
},
|
FLOT_TEXT=row["FLotName"],
|
FQty = row["Qty"]
|
})
|
};
|
|
LogService.WriteAsync(model);
|
|
|
var restlt = client.Save("SAL_SaleOrder", JsonConvert.SerializeObject(new { Model = model }));
|
LogService.WriteAsync(restlt);
|
|
var response = JsonConvert.DeserializeObject<KingdeeResponse2>(restlt);
|
if (response.Result.ResponseStatus.IsSuccess)
|
{
|
var ids = JsonConvert.SerializeObject(new { Ids = response.Result.ResponseStatus.SuccessEntitys[0].Id });
|
LogService.WriteAsync(ids);
|
var r = client.Submit("SAL_SaleOrder", ids);
|
LogService.WriteAsync(r);
|
r = client.Audit("SAL_SaleOrder", ids);
|
}
|
|
foreach (var item in this.OperationResult.OperateResult)
|
{
|
if (item.PKValue?.ToString() == id.ToString())
|
{
|
item.Message += response.Result.ResponseStatus.IsSuccess ? $"生成墙咔领料单据{billNo}_A" : $"{billNo}生成强卡领料单据失败:{JsonConvert.SerializeObject(response.Result.ResponseStatus.Errors.Select(x => x.Message + ";"))}";
|
}
|
}
|
}
|
|
}
|
|
|
public override void OnPreparePropertys(PreparePropertysEventArgs e)
|
{
|
base.OnPreparePropertys(e);
|
#region 字段信息加载
|
e.FieldKeys.Add("FOrderEntryPlan");
|
e.FieldKeys.Add("FIsSplitBill");
|
e.FieldKeys.Add("FOverOrgTransDirect");
|
e.FieldKeys.Add("FExchangeTypeId");
|
e.FieldKeys.Add("FIsIncludedTax");
|
e.FieldKeys.Add("FSettleModeId");
|
e.FieldKeys.Add("FIsPriceExcludeTax");
|
e.FieldKeys.Add("FRecConditionId");
|
e.FieldKeys.Add("FSettleCurrId");
|
e.FieldKeys.Add("FIsSplitBill");
|
e.FieldKeys.Add("F_zzzz_CheckBox2");
|
e.FieldKeys.Add("F_zzzz_Text7");
|
e.FieldKeys.Add("FCollectionTime");
|
e.FieldKeys.Add("F_zzzz_Assistant");
|
e.FieldKeys.Add("FDifferenceAmount");
|
e.FieldKeys.Add("F_zzzz_Text8");
|
e.FieldKeys.Add("FLCLSituation");
|
e.FieldKeys.Add("FCustInvioce");
|
e.FieldKeys.Add("FPAYCUSTOMER");
|
e.FieldKeys.Add("FWEBANKACCOUNT");
|
e.FieldKeys.Add("FHEADLOCID");
|
e.FieldKeys.Add("FIsMobile");
|
e.FieldKeys.Add("FNote");
|
e.FieldKeys.Add("FISINIT");
|
e.FieldKeys.Add("FChargeId");
|
e.FieldKeys.Add("FReceiveContact");
|
e.FieldKeys.Add("FSettleId");
|
e.FieldKeys.Add("FReceiveAddress");
|
e.FieldKeys.Add("FLinkPhone");
|
e.FieldKeys.Add("FSalerId");
|
e.FieldKeys.Add("FSaleGroupId");
|
e.FieldKeys.Add("FSaleDeptId");
|
e.FieldKeys.Add("FReceiveId");
|
e.FieldKeys.Add("FCOLLECTBALANCEAMOUNT");
|
e.FieldKeys.Add("FCustId");
|
e.FieldKeys.Add("FSaleOrgId");
|
e.FieldKeys.Add("FDate");
|
e.FieldKeys.Add("FBillTypeID");
|
e.FieldKeys.Add("FRowType");
|
e.FieldKeys.Add("FMaterialId");
|
e.FieldKeys.Add("FSUBMATERIALNUMBER");
|
e.FieldKeys.Add("FMapId");
|
e.FieldKeys.Add("FUnitID");
|
e.FieldKeys.Add("FQty");
|
e.FieldKeys.Add("FPrice");
|
e.FieldKeys.Add("FTaxPrice");
|
e.FieldKeys.Add("F_zzzz_Decimal4");
|
e.FieldKeys.Add("FLot");
|
e.FieldKeys.Add("FIsFree");
|
e.FieldKeys.Add("FEntryTaxRate");
|
e.FieldKeys.Add("FDeliveryDate");
|
e.FieldKeys.Add("FStockOrgId");
|
e.FieldKeys.Add("FSettleOrgIds");
|
e.FieldKeys.Add("FSupplyOrgId");
|
e.FieldKeys.Add("FOwnerTypeId");
|
e.FieldKeys.Add("FOwnerId");
|
e.FieldKeys.Add("FEntryNote");
|
e.FieldKeys.Add("FReserveType");
|
e.FieldKeys.Add("F_zzzz_Text9");
|
e.FieldKeys.Add("FPriceBaseQty");
|
e.FieldKeys.Add("FStockUnitID");
|
e.FieldKeys.Add("FStockQty");
|
e.FieldKeys.Add("FStockBaseQty");
|
e.FieldKeys.Add("FOUTLMTUNIT");
|
e.FieldKeys.Add("FOutLmtUnitID");
|
e.FieldKeys.Add("FISMRP");
|
e.FieldKeys.Add("FLOCKSTOCK");
|
e.FieldKeys.Add("F_zzzz_Combo1");
|
e.FieldKeys.Add("F_zzzz_CheckBox");
|
e.FieldKeys.Add("F_zzzz_Text");
|
e.FieldKeys.Add("F_zzzz_Assistant2");
|
e.FieldKeys.Add("F_zzzz_Decimal7");
|
e.FieldKeys.Add("F_zzzz_Decimal8");
|
e.FieldKeys.Add("FSpecialOffer");
|
e.FieldKeys.Add("FMESScheduling");
|
e.FieldKeys.Add("FMESScheduling");
|
e.FieldKeys.Add("FIsUnsalablePrd");
|
e.FieldKeys.Add("FPlanProdDate");
|
e.FieldKeys.Add("FQitao");
|
e.FieldKeys.Add("FOrderEntryPlan");
|
e.FieldKeys.Add("FDetailLocId");
|
e.FieldKeys.Add("FDetailLocAddress");
|
e.FieldKeys.Add("FPlanDate");
|
e.FieldKeys.Add("FTransportLeadTime");
|
e.FieldKeys.Add("FPlanQty");
|
e.FieldKeys.Add("FCOLLECTIONNO");
|
e.FieldKeys.Add("FOtherARBillNo");
|
e.FieldKeys.Add("F_YQN_ZDR");
|
e.FieldKeys.Add("FCreatorId");
|
e.FieldKeys.Add("FISGuarantee");
|
e.FieldKeys.Add("F_zzzz_DDBZ");
|
e.FieldKeys.Add("F_YQN_CSHDDBH");
|
e.FieldKeys.Add("FCreatorId");
|
e.FieldKeys.Add("FModifierId");
|
e.FieldKeys.Add("F_YQN_DYXH");
|
e.FieldKeys.Add("F_YQN_GYS");
|
e.FieldKeys.Add("F_YQN_CGY1");
|
e.FieldKeys.Add("FFIRSTPRINTTIME");
|
e.FieldKeys.Add("F_ZZZZ_PRINTTIMES");
|
e.FieldKeys.Add("F_zzzz_PrintDateTime");
|
e.FieldKeys.Add("FFirstTime");
|
e.FieldKeys.Add("FLastTime");
|
e.FieldKeys.Add("FPrintCount");
|
e.FieldKeys.Add("FIsNeedCheck");
|
e.FieldKeys.Add("FISCASHSALE");
|
e.FieldKeys.Add("F_ZZZZ_QIAO");
|
e.FieldKeys.Add("F_ZZZZ_OEM");
|
e.FieldKeys.Add("FPushPrdPlan");
|
e.FieldKeys.Add("FLotTxt");
|
e.FieldKeys.Add("F_zzzz_Decimal");
|
e.FieldKeys.Add("F_zzzz_Decimal1");
|
e.FieldKeys.Add("F_zzzz_Assistant3");
|
e.FieldKeys.Add("F_zzzz_Assistant4");
|
e.FieldKeys.Add("F_zzzz_Assistant6");
|
e.FieldKeys.Add("F_zzzz_Assistant7");
|
e.FieldKeys.Add("F_zzzz_Assistant8");
|
e.FieldKeys.Add("F_zzzz_Assistant9");
|
e.FieldKeys.Add("FLossParam");
|
e.FieldKeys.Add("F_zzzz_Decimal5");
|
e.FieldKeys.Add("F_zzzz_Text1");
|
e.FieldKeys.Add("F_zzzz_Assistant1");
|
e.FieldKeys.Add("FSOStockId");
|
e.FieldKeys.Add("F_zzzz_FLBZ");
|
e.FieldKeys.Add("F_zzzz_WBBZ");
|
e.FieldKeys.Add("FISLAST");
|
e.FieldKeys.Add("F_zzzz_CQFS");
|
e.FieldKeys.Add("F_zzzz_MLKD");
|
e.FieldKeys.Add("F_zzzz_BGD");
|
e.FieldKeys.Add("F_zzzz_BKD");
|
e.FieldKeys.Add("F_zzzz_DDSL");
|
e.FieldKeys.Add("F_CUT_TIME");
|
e.FieldKeys.Add("F_BZ_TIME");
|
e.FieldKeys.Add("F_loss_backup");
|
e.FieldKeys.Add("FIsCustomerProvide");
|
e.FieldKeys.Add("FISREFRESHLOT");
|
e.FieldKeys.Add("F_zzzz_WBBZ1");
|
e.FieldKeys.Add("FSaleQty");
|
e.FieldKeys.Add("FTotalAmount");
|
e.FieldKeys.Add("FLotEmptyDate");
|
e.FieldKeys.Add("FSaleOutLot");
|
e.FieldKeys.Add("FIsClose");
|
e.FieldKeys.Add("FIsStatistics");
|
e.FieldKeys.Add("F_zzzz_CheckBox1");
|
e.FieldKeys.Add("F_zzzz_Text3");
|
e.FieldKeys.Add("F_zzzz_Text4");
|
e.FieldKeys.Add("F_zzzz_Text5");
|
e.FieldKeys.Add("F_zzzz_Text10");
|
e.FieldKeys.Add("F_zzzz_Text11");
|
e.FieldKeys.Add("F_zzzz_Integer");
|
e.FieldKeys.Add("FParentDateTime");
|
e.FieldKeys.Add("FChildrenDatetime");
|
e.FieldKeys.Add("FSplitSBillNo");
|
e.FieldKeys.Add("FIsNeedAllSend");
|
e.FieldKeys.Add("F_XSDD_PGBZ");
|
e.FieldKeys.Add("F_XSDD_PGSJ");
|
#endregion
|
|
|
|
|
}
|
public override void AfterExecuteOperationTransaction(AfterExecuteOperationTransaction e)
|
{
|
base.AfterExecuteOperationTransaction(e);
|
|
CreateQkForm(e);
|
|
var srcDatas = e.SelectedRows;
|
//// 使用webapi引用组件Kingdee.BOS.WebApi.Client.dll，进行单据处理
|
//K3CloudApiClient client = new K3CloudApiClient("http://localhost/k3Cloud/");
|
////var loginResult = client.ValidateLogin("5fe40ecc0b7bf2", "Administrator", "888888", 2052);//本地环境
|
//var loginResult = client.ValidateLogin("5f56ea565892f4", "Administrator", "ycy123", 2052);//正式环境
|
//var resultType = JObject.Parse(loginResult)["LoginResultType"].Value<int>();
|
////登录结果类型等于1，代表登录成功
|
//if (resultType == 1)
|
//{
|
CloudClient client = new CloudClient("http://localhost/k3Cloud/");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单", "API登录成功");
|
Dictionary<string, string> dictionary = new Dictionary<string, string>();
|
foreach (var srcData in srcDatas)
|
{
|
//string billno = srcData["BillNo"].ToString();//单据编号
|
//string UnAuditResult = client.UnAudit("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":['" + billno + "'],\"Ids\":\"\",\"InterationFlags\":\"\",\"NetworkCtrl\":\"\"}");
|
//JObject UnAuditResultObj = JObject.Parse(UnAuditResult);
|
//if (UnAuditResultObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
//{
|
// string DeleteResult = client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":['" + billno + "'],\"Ids\":\"\",\"NetworkCtrl\":\"\"}");
|
//}
|
bool curr = false;
|
string idlist = string.Empty;//暂存单据集合
|
string savejsonlist = string.Empty;//暂存单据保存JSON
|
string billno = srcData["BillNo"].ToString();//单据编号
|
bool IsSplitBill = bool.Parse(srcData["FIsSplitBill"].ToString());//是否拆单
|
if (IsSplitBill)
|
{
|
try
|
{
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "符合拆单条件：" + billno);
|
string sql = $@"/*dialect*/SELECT B.FQitao
|
FROM dbo.T_SAL_ORDER A(NOLOCK)
|
JOIN dbo.T_SAL_ORDERENTRY B(NOLOCK) ON B.FID = A.FID
|
WHERE A.FBILLNO='{billno}'
|
GROUP BY B.FQitao";
|
DataTable data = DBServiceHelper.ExecuteDataSet(this.Context, sql).Tables[0];
|
//拆单
|
for (int i = 0; i < data.Rows.Count; i++)
|
{
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "进入拆单循环");
|
#region 拼接表头
|
string SplitBillNo = billno + "-" + (i + 1);//拆单单号
|
StringBuilder sJson = new StringBuilder();
|
sJson.Append("{");
|
sJson.Append("\"NeedUpDateFields\": [],");
|
sJson.Append("\"NeedReturnFields\": [],");
|
sJson.Append("\"IsDeleteEntry\": \"true\",");
|
sJson.Append("\"SubSystemId\": \"\",");
|
sJson.Append("\"IsVerifyBaseDataField\": \"true\",");
|
sJson.Append("\"IsEntryBatchFill\": \"true\",");
|
sJson.Append("\"ValidateFlag\": \"true\",");
|
sJson.Append("\"NumberSearch\": \"true\",");
|
sJson.Append("\"InterationFlags\": \"\",");
|
sJson.Append("\"Model\": {");
|
sJson.Append("\"FID\": 0,");
|
sJson.Append("\"FBillTypeID\": {\"FNUMBER\": \"" + ((srcData["BillTypeID"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FDate\": \"" + (srcData["Date"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FSaleOrgId\": {\"FNumber\": \"" + ((srcData["SaleOrgId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FCustId\": {\"FNumber\": \"" + ((srcData["CustId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FBillNo\": \"" + SplitBillNo + "\",");
|
sJson.Append("\"FCOLLECTBALANCEAMOUNT\": " + (srcData["COLLECTBALANCEAMOUNT"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FReceiveId\": {\"FNumber\": \"" + ((srcData["ReceiveId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FSaleDeptId\": {\"FNumber\": \"" + ((srcData["SaleDeptId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FSaleGroupId\": {\"FNumber\": \"" + ((srcData["SaleGroupId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FSalerId\": {\"FNumber\": \"" + ((srcData["SalerId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FSettleId\": {\"FNumber\": \"" + ((srcData["SettleId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FReceiveContact\": {\"FNumber\": \"" + ((srcData["ReceiveContact"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FChargeId\": {\"FNumber\": \"" + ((srcData["ChargeId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FISINIT\": \"" + (srcData["ISINIT"]?.ToString() ?? "False") + "\",");
|
sJson.Append("\"FISGuarantee\": \"" + (srcData["ISGuarantee"]?.ToString() ?? "false") + "\",");
|
if ((srcData["F_YQN_ZDR"]?.ToString() ?? "") == "")
|
{
|
sJson.Append("\"F_YQN_ZDR\": \"" + ((srcData["CreatorId"] as DynamicObject)?["Name"].ToString() ?? "") + "\",");
|
}
|
else
|
{
|
sJson.Append("\"F_YQN_ZDR\": \"" + (srcData["F_YQN_ZDR"]?.ToString() ?? "") + "\",");
|
}
|
sJson.Append("\"FISCASHSALE\": \"" + (srcData["ISCASHSALE"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FIsNeedCheck\": \"True\",");
|
sJson.Append("\"FISLAST\": \"False\",");
|
sJson.Append("\"FFIRSTPRINTTIME\": \"" + (srcData["FFIRSTPRINTTIME"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_PrintDateTime\": \"" + (srcData["F_zzzz_PrintDateTime"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_ZZZZ_PRINTTIMES\": " + (srcData["F_ZZZZ_PRINTTIMES"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FFirstTime\": \"" + (srcData["FFirstTime"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FLastTime\": \"" + (srcData["FLastTime"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FPrintCount\": " + (srcData["FPrintCount"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_YQN_CSHDDBH\": \"" + (srcData["F_YQN_CSHDDBH"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FCOLLECTIONNO\": \"" + (srcData["COLLECTIONNO"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FOtherARBillNo\": \"" + (srcData["OtherARBillNo"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FNote\": \"" + (srcData["Note"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FIsMobile\": \"" + (srcData["IsMobile"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FHEADLOCID\": {\"FNUMBER\": \"" + ((srcData["HEADLOCID"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FWEBANKACCOUNT\": {\"FNUMBER\": \"" + ((srcData["WEBANKACCOUNT"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FPAYCUSTOMER\": {\"FNUMBER\": \"" + ((srcData["PAYCUSTOMER"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FCustInvioce\": {\"FNUMBER\": \"" + ((srcData["CustInvioce"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FLCLSituation\": \"" + (srcData["LCLSituation"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text8\": \"" + (srcData["F_zzzz_Text8"]?.ToString() ?? "") + "\",");
|
//sJson.Append("\"FDifferenceAmount\": " + (srcData["FDifferenceAmount"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FCollectionTime\": \"" + (srcData["CollectionTime"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_CheckBox2\": \"" + (srcData["F_zzzz_CheckBox2"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FIsSplitBill\": \"false\",");
|
sJson.Append("\"F_zzzz_Assistant\": {\"FNumber\": \"" + ((srcData["F_zzzz_Assistant"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FLinkPhone\": \"" + (srcData["FLinkPhone"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FReceiveAddress\": \"" + (srcData["ReceiveAddress"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text7\": \"" + (srcData["F_zzzz_Text7"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FCreatorId\": {\"FUserID\": " + (srcData["CreatorId_Id"]?.ToString() ?? "0") + "},");
|
sJson.Append("\"FModifierId\": {\"FUserID\": " + (srcData["ModifierId_Id"]?.ToString() ?? "0") + "},");
|
sJson.Append("\"F_zzzz_FLBZ\": \"" + (srcData["F_zzzz_FLBZ"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_WBBZ\": \"" + (srcData["F_zzzz_WBBZ"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FIsStatistics\": \"True\",");
|
string no = billno;
|
string bno = string.Empty;
|
if ((no.IndexOf("_") == -1 ? 99999 : no.IndexOf("_")) > (no.IndexOf("-") == -1 ? 99999 : no.IndexOf("-")))
|
{
|
bno = no.Substring(0, no.IndexOf("-"));
|
}
|
else if ((no.IndexOf("_") == -1 ? 99999 : no.IndexOf("_")) < (no.IndexOf("-") == -1 ? 99999 : no.IndexOf("-")))
|
{
|
bno = no.Substring(0, no.IndexOf("_"));
|
}
|
else if ((no.IndexOf("_") == -1 ? 99999 : no.IndexOf("_")) == (no.IndexOf("-") == -1 ? 99999 : no.IndexOf("-")))
|
{
|
bno = no;
|
}
|
sJson.Append("\"FSplitSBillNo\": \""+ bno + "\",");
|
sJson.Append("\"FIsNeedAllSend\": \"" + (srcData["FIsNeedAllSend"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"F_zzzz_CheckBox1\": \"" + (srcData["F_zzzz_CheckBox1"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FIsCustomerProvide\": \"" + (srcData["FIsCustomerProvide"]?.ToString() ?? "false") + "\",");
|
DynamicObjectCollection SaleDataFinance = srcData["SaleOrderFinance"] as DynamicObjectCollection;//财务明细
|
sJson.Append("\"FSaleOrderFinance\":");
|
sJson.Append("{");
|
sJson.Append("\"FSettleCurrId\": {\"FNumber\": \"" + ((SaleDataFinance[0]["SettleCurrId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FRecConditionId\": {\"FNumber\": \"" + ((SaleDataFinance[0]["RecConditionId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FIsPriceExcludeTax\": \"" + (SaleDataFinance[0]["IsPriceExcludeTax"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FSettleModeId\": {\"FNumber\": \"" + ((SaleDataFinance[0]["SettleModeId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FIsIncludedTax\": \"" + (SaleDataFinance[0]["IsIncludedTax"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FExchangeTypeId\": {\"FNumber\": \"" + ((SaleDataFinance[0]["ExchangeTypeId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FOverOrgTransDirect\": \"" + (SaleDataFinance[0]["OverOrgTransDirect"]?.ToString() ?? "false") + "\"");
|
sJson.Append("},");
|
sJson.Append("\"FSaleOrderEntry\": [");
|
#endregion
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "表头JSON处理完");
|
//拆明细
|
DynamicObjectCollection SaleData = srcData["SaleOrderEntry"] as DynamicObjectCollection;//订单明细
|
string sqldtl = $@"/*dialect*/SELECT B.FSEQ
|
FROM dbo.T_SAL_ORDER A(NOLOCK)
|
JOIN dbo.T_SAL_ORDERENTRY B(NOLOCK) ON B.FID = A.FID
|
WHERE A.FBILLNO='{billno}' AND B.FQitao='{data.Rows[i]["FQitao"]}'";
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "表体拼接sql执行语句：" + sqldtl);
|
DataTable datadtl = DBServiceHelper.ExecuteDataSet(this.Context, sqldtl).Tables[0];
|
for (int j = 0; j < datadtl.Rows.Count; j++)
|
{
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "表体循环开始");
|
int fseq = int.Parse(datadtl.Rows[j]["FSEQ"].ToString());
|
sJson.Append("{");
|
sJson.Append("\"FRowType\": \"" + (SaleData[fseq - 1]["RowType"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FMapId\": {\"FName\": \"" + ((SaleData[fseq - 1]["MapId"] as DynamicObject)?["Name"].ToString() ?? "") + "\"},");
|
//sJson.Append("\"FSUBMATERIALNUMBER\": {\"FName\": \"" + ((SaleData[fseq - 1]["SUBMATERIALNUMBER"] as DynamicObject)?["Name"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FSUBMATERIALNUMBER\": {\"FNUMBER\": \"" + ((SaleData[fseq - 1]["SUBMATERIALNUMBER"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
//sJson.Append("\"FMaterialId\": {\"FName\": \"" + ((SaleData[fseq - 1]["MaterialId"] as DynamicObject)?["Name"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FMaterialId\": {\"FNUMBER\": \"" + ((SaleData[fseq - 1]["MaterialId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FUnitID\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["UnitID"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
//sJson.Append("\"FPrice\": " + (SaleData[fseq - 1]["Price"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_zzzz_Decimal4\": " + (SaleData[fseq - 1]["F_zzzz_Decimal4"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FIsFree\": \"" + (SaleData[fseq - 1]["IsFree"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FEntryTaxRate\": " + (SaleData[fseq - 1]["TaxRate"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FDeliveryDate\": \"" + (SaleData[fseq - 1]["DeliveryDate"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FStockOrgId\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["StockOrgId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FSettleOrgIds\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["SettleOrgId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FSupplyOrgId\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["SupplyOrgId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FOwnerTypeId\": \"" + (SaleData[fseq - 1]["OwnerTypeId"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FOwnerId\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["OwnerId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FReserveType\": \"" + (SaleData[fseq - 1]["ReserveType"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text9\": \" " + (SaleData[fseq - 1]["F_zzzz_Text9"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FPriceBaseQty\": " + (SaleData[fseq - 1]["PriceBaseQty"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FStockUnitID\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["StockUnitID"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FStockQty\": " + (SaleData[fseq - 1]["StockQty"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FStockBaseQty\": " + (SaleData[fseq - 1]["StockBaseQty"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_zzzz_DDBZ\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_DDBZ"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FOUTLMTUNIT\": \"" + (SaleData[fseq - 1]["OUTLMTUNIT"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FOutLmtUnitID\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["OutLmtUnitID"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FISMRP\": \"" + (SaleData[fseq - 1]["FISMRP"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FLOCKSTOCK\": \"" + (SaleData[fseq - 1]["LOCKSTOCK"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"F_zzzz_CheckBox\": \"" + (SaleData[fseq - 1]["F_zzzz_CheckBox"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FPushPrdPlan\": \"" + (SaleData[fseq - 1]["FPushPrdPlan"]?.ToString() ?? "false") + "\",");
|
//sJson.Append("\"F_zzzz_CheckBox1\": \"" + (SaleData[fseq - 1]["F_zzzz_CheckBox1"]?.ToString() ?? "false") + "\",");
|
//sJson.Append("\"F_zzzz_Combo7\": \"" + (SaleData[fseq - 1]["F_zzzz_Combo7"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_BKD\": " + (SaleData[fseq - 1]["F_zzzz_BKD"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_zzzz_BGD\": " + (SaleData[fseq - 1]["F_zzzz_BGD"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_zzzz_MLKD\": " + (SaleData[fseq - 1]["F_zzzz_MLKD"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_zzzz_CQFS\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_CQFS"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_DDSL\": " + (SaleData[fseq - 1]["F_zzzz_DDSL"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_ZZZZ_OEM\": \"" + (SaleData[fseq - 1]["F_ZZZZ_OEM"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_ZZZZ_QIAO\": \"" + (SaleData[fseq - 1]["F_ZZZZ_QIAO"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_YQN_DYXH\": \"" + (SaleData[fseq - 1]["F_YQN_DYXH"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_YQN_GYS\": \"" + (SaleData[fseq - 1]["F_YQN_GYS"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_YQN_CGY1\": \"" + (SaleData[fseq - 1]["F_YQN_CGY1"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text\": \"" + (SaleData[fseq - 1]["F_zzzz_Text"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Assistant2\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_Assistant2"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_Decimal7\": " + (SaleData[fseq - 1]["F_zzzz_Decimal7"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_zzzz_Decimal8\": " + (SaleData[fseq - 1]["F_zzzz_Decimal8"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FSpecialOffer\": \"" + (SaleData[fseq - 1]["SpecialOffer"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FIsClose\": \"" + (SaleData[fseq - 1]["FIsClose"]?.ToString() ?? "A") + "\",");
|
sJson.Append("\"FMESScheduling\": \"" + (SaleData[fseq - 1]["FMESScheduling"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FIsUnsalablePrd\": \"" + (SaleData[fseq - 1]["IsUnsalablePrd"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"FPlanProdDate\": \"" + (SaleData[fseq - 1]["PlanProdDate"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FISREFRESHLOT\": \"" + (SaleData[fseq - 1]["FISREFRESHLOT"]?.ToString() ?? "false") + "\",");
|
sJson.Append("\"F_zzzz_Assistant3\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_Assistant3"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_Assistant4\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_Assistant4"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_Assistant6\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_Assistant6"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_Assistant7\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_Assistant7"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_Assistant8\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_Assistant8"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_Assistant9\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_Assistant9"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_Assistant1\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["F_zzzz_Assistant1"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"F_zzzz_Decimal\": " + (SaleData[fseq - 1]["F_zzzz_Decimal"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_zzzz_Decimal1\": " + (SaleData[fseq - 1]["F_zzzz_Decimal1"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_zzzz_Decimal5\": " + (SaleData[fseq - 1]["F_zzzz_Decimal5"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"F_XSDD_PGBZ\": \"" + (SaleData[fseq - 1]["F_XSDD_PGBZ"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_XSDD_PGSJ\": \"" + (SaleData[fseq - 1]["F_XSDD_PGSJ"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text1\": \"" + (SaleData[fseq - 1]["F_zzzz_Text1"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_WBBZ1\": \"" + (SaleData[fseq - 1]["F_zzzz_WBBZ1"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FSaleQty\": " + (SaleData[fseq - 1]["FSaleQty"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FTotalAmount\": " + (SaleData[fseq - 1]["FTotalAmount"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FLossParam\": " + (SaleData[fseq - 1]["LossParam"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FEntryNote\": \"" + (SaleData[fseq - 1]["Note"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_BZ_TIME\": \"" + (SaleData[fseq - 1]["F_BZ_TIME"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_CUT_TIME\": \"" + (SaleData[fseq - 1]["F_CUT_TIME"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_loss_backup\": " + (SaleData[fseq - 1]["F_loss_backup"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FSOStockId\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["SOStockId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
//sJson.Append("\"FQitao\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["FQitao"] as DynamicObject)?["FNumber"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FQty\": " + (SaleData[fseq - 1]["Qty"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FLot\": {\"FNumber\": \"" + ((SaleData[fseq - 1]["Lot"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
sJson.Append("\"FTaxPrice\": " + (SaleData[fseq - 1]["TaxPrice"]?.ToString() ?? "0") + ",");
|
sJson.Append("\"FLotEmptyDate\": \"" + (SaleData[fseq - 1]["FLotEmptyDate"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FSaleOutLot\": \"" + (SaleData[fseq - 1]["FSaleOutLot"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text3\": \"" + (SaleData[fseq - 1]["F_zzzz_Text3"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text4\": \"" + (SaleData[fseq - 1]["F_zzzz_Text4"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text5\": \"" + (SaleData[fseq - 1]["F_zzzz_Text5"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text10\": \"" + (SaleData[fseq - 1]["F_zzzz_Text10"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Text11\": \"" + (SaleData[fseq - 1]["F_zzzz_Text11"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"F_zzzz_Integer\": \"" + (SaleData[fseq - 1]["F_zzzz_Integer"]?.ToString() ?? "0") + "\",");
|
sJson.Append("\"FParentDateTime\": \"" + (SaleData[fseq - 1]["FParentDateTime"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FChildrenDatetime\": \"" + (SaleData[fseq - 1]["FChildrenDatetime"]?.ToString() ?? "") + "\",");
|
sJson.Append("\"FLotTxt\": \"" + (SaleData[fseq - 1]["FLotTxt"]?.ToString() ?? "0") + "\"");
|
//sJson.Append("\"FLotTxt\": \"" + (SaleData[fseq - 1]["FLotTxt"]?.ToString() ?? "0") + "\",");
|
//报错未查出原因，暂拿掉交货明细表体20210302
|
//DynamicObjectCollection SaleDataPlan = SaleData[fseq - 1]["OrderEntryPlan"] as DynamicObjectCollection;
|
//sJson.Append("\"FOrderEntryPlan\": [{");
|
//sJson.Append("\"FDetailLocId\": {\"FNumber\": \"" + ((SaleDataPlan[0]["DetailLocId"] as DynamicObject)?["Number"].ToString() ?? "") + "\"},");
|
//sJson.Append("\"FDetailLocAddress\": \"" + (SaleDataPlan[0]["DetailLocAddress"]?.ToString() ?? "") + "\",");
|
//sJson.Append("\"FPlanDate\": \"" + (SaleDataPlan[0]["PlanDate"]?.ToString() ?? "") + "\",");
|
//sJson.Append("\"FTransportLeadTime\": " + (SaleDataPlan[0]["TransportLeadTime"]?.ToString() ?? "") + ",");
|
//sJson.Append("\"FPlanQty\": " + (SaleDataPlan[0]["PlanQty"]?.ToString() ?? "0") + "}]");
|
sJson.Append("}");
|
|
if (j != datadtl.Rows.Count - 1)
|
{
|
sJson.Append(",");
|
}
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "表体循环结束");
|
}
|
sJson.Append("]");
|
//sJson.Append("\"FSaleOrderPlan\": [");
|
//sJson.Append("{");
|
//sJson.Append("\"FNeedRecAdvance\": " + SaleData[fseq - 1]["RowType"].ToString() + ",");
|
//sJson.Append("\"FRecAdvanceRate\": " + SaleData[fseq - 1]["RowType"].ToString() + ",");
|
//sJson.Append("\"FRecAdvanceAmount\": " + SaleData[fseq - 1]["RowType"].ToString() + ",");
|
//sJson.Append("\"FIsOutStockByRecamount\": " + SaleData[fseq - 1]["RowType"].ToString() + "");
|
//sJson.Append("}");
|
//sJson.Append("]");
|
sJson.Append("}");
|
sJson.Append("}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "表体JSON处理结束，单据JSON：" + sJson.ToString());
|
JObject aa = JObject.Parse(JObject.Parse(sJson.ToString())["Model"].ToString());
|
savejsonlist += aa.ToString() + ",";
|
#region 第一版
|
////暂存处理
|
//string DraftResult = client.Draft("SAL_SaleOrder", sJson.ToString());
|
//WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "表体JSON处理结束，暂存结果：" + DraftResult);
|
//JObject DraftResultObj = JObject.Parse(DraftResult);
|
//if (DraftResultObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
//{
|
// JObject aa = JObject.Parse(JObject.Parse(sJson.ToString())["Model"].ToString());
|
// aa["FID"] = DraftResultObj["Result"]["Id"].ToString();
|
// savejsonlist += aa.ToString() + ",";
|
// idlist += DraftResultObj["Result"]["Id"].ToString() + ",";
|
// //LogHelper.Info("订单审核拆单json:"+ aa.ToString());
|
//}
|
//else//暂存失败则删除当前单据拆出来的所有暂存单据，并且跳出当前拆单单据，进行下一个拆单处理
|
//{
|
// idlist = idlist.Substring(0, idlist.Length - 1);
|
// string deletemessage = client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + idlist + "\",\"NetworkCtrl\":\"\"}");
|
// WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "暂存失败，删除原订单拆单结果：" + deletemessage);
|
// dictionary.Add(billno, DraftResultObj["Result"]["ResponseStatus"]["Errors"].ToString());
|
// curr = true;
|
// break;
|
//}
|
#endregion
|
|
}
|
string successNo = string.Empty;
|
savejsonlist = savejsonlist.Substring(0, savejsonlist.Length - 1);
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量保存JSON：" + "{\"NumberSearch\":\"true\",\"ValidateFlag\":\"true\",\"IsDeleteEntry\":\"true\",\"IsEntryBatchFill\":\"true\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"SubSystemId\":\"\",\"InterationFlags\":\"\",\"Model\":[" + savejsonlist.Replace("\r", "").Replace("\n", "") + "],\"BatchCount\":" + data.Rows.Count.ToString() + "}");
|
string message = client.BatchSave("SAL_SaleOrder", "{\"NumberSearch\":\"true\",\"ValidateFlag\":\"true\",\"IsDeleteEntry\":\"true\",\"IsEntryBatchFill\":\"true\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"SubSystemId\":\"\",\"InterationFlags\":\"\",\"Model\":[" + savejsonlist.Replace("\r", "").Replace("\n", "") + "],\"BatchCount\":" + data.Rows.Count.ToString() + "}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量保存结果：" + message);
|
JObject messageObj = JObject.Parse(message);
|
for (int i = 0; i < messageObj["Result"]["ResponseStatus"]["SuccessEntitys"].ToList().Count; i++)
|
{
|
successNo += messageObj["Result"]["ResponseStatus"]["SuccessEntitys"][i]["Id"].ToString() + ",";
|
}
|
if (successNo.Length > 0)
|
{
|
successNo = successNo.Substring(0, successNo.Length - 1);
|
}
|
if (messageObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
{
|
string UnAuditResult = client.UnAudit("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":['" + billno + "'],\"Ids\":\"\",\"InterationFlags\":\"\",\"NetworkCtrl\":\"\"}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "反审核结果：" + UnAuditResult);
|
JObject UnAuditResultObj = JObject.Parse(UnAuditResult);
|
if (UnAuditResultObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
{
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "删除原单开始时间：" + DateTime.Now.ToString());
|
string DeleteResult = client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":['" + billno + "'],\"Ids\":\"\",\"NetworkCtrl\":\"\"}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "删除原单结束时间" + DateTime.Now.ToString());
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "删除结果：" + DeleteResult);
|
JObject DeleteResultObj = JObject.Parse(DeleteResult);
|
if (DeleteResultObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
{
|
sql = $@"/*dialect*/UPDATE A
|
SET A.FIsStatistics=0
|
FROM dbo.T_SAL_ORDER A
|
WHERE A.FID IN ({successNo})";
|
int rows = DBServiceHelper.Execute(this.Context, sql);
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "更新是否统计结果：" + rows);
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量提交开始时间" + DateTime.Now.ToString());
|
string mes = client.Submit("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + successNo + "\",\"SelectedPostId\":0,\"NetworkCtrl\":\"\"}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量提交结束时间" + DateTime.Now.ToString());
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量提交结果：" + mes);
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量审核开始时间" + DateTime.Now.ToString());
|
string mess = client.Audit("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + successNo + "\",\"InterationFlags\":\"\",\"NetworkCtrl\":\"\"}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量审核结束时间" + DateTime.Now.ToString());
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量审核结果：" + mess);
|
|
|
|
//dictionary.Add(billno, "拆单成功！");
|
}
|
else
|
{
|
if (successNo.Length > 0)
|
{
|
string deletestr = client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + successNo + "\",\"NetworkCtrl\":\"\"}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "原单删除失败--拆单成功的单据删除结果：" + deletestr);
|
dictionary.Add(billno, "拆单失败,详细原因：原单删除失败！");
|
}
|
|
}
|
}
|
else
|
{
|
if (successNo.Length > 0)
|
{
|
string unaduitstr = client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + successNo + "\",\"NetworkCtrl\":\"\"}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "原单反审核失败--拆单成功的单据删除结果：" + unaduitstr);
|
dictionary.Add(billno, "拆单失败,详细原因：原单反审核失败！");
|
}
|
|
}
|
}
|
else
|
{
|
if (successNo.Length > 0)
|
{
|
string spiltstr = client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + successNo + "\",\"NetworkCtrl\":\"\"}");
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "原单拆单失败--拆单成功的单据删除结果：" + spiltstr);
|
dictionary.Add(billno, "拆单失败,详细原因：原单拆单失败！");
|
}
|
|
}
|
|
#region 第一版
|
//if (curr)
|
//{
|
// string UnAuditResult = client.UnAudit("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":['" + billno + "'],\"Ids\":\"\",\"InterationFlags\":\"\",\"NetworkCtrl\":\"\"}");
|
// WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "拆单暂存失败，进行原单反审核：" + UnAuditResult);
|
//}
|
//else
|
//{
|
// savejsonlist = savejsonlist.Substring(0, savejsonlist.Length - 1);
|
// idlist = idlist.Substring(0, idlist.Length - 1);
|
// WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "JSON：" + savejsonlist);
|
// //拆单暂存完后删除原单据，在对暂存单据进行保存
|
// string UnAuditResult = client.UnAudit("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":['" + billno + "'],\"Ids\":\"\",\"InterationFlags\":\"\",\"NetworkCtrl\":\"\"}");
|
// WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "反审核结果：" + UnAuditResult);
|
// JObject UnAuditResultObj = JObject.Parse(UnAuditResult);
|
// if (UnAuditResultObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
// {
|
// string DeleteResult = client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":['" + billno + "'],\"Ids\":\"\",\"NetworkCtrl\":\"\"}");
|
// WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "删除结果：" + DeleteResult);
|
// JObject DeleteResultObj = JObject.Parse(DeleteResult);
|
// if (DeleteResultObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
// {
|
// string message = client.BatchSave("SAL_SaleOrder", "{\"NumberSearch\":\"true\",\"ValidateFlag\":\"true\",\"IsDeleteEntry\":\"true\",\"IsEntryBatchFill\":\"true\",\"NeedUpDateFields\":[],\"NeedReturnFields\":[],\"SubSystemId\":\"\",\"InterationFlags\":\"\",\"Model\":[" + savejsonlist.Replace("\r", "").Replace("\n", "") + "],\"BatchCount\":" + data.Rows.Count.ToString() + "}");
|
// WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量保存结果：" + message);
|
// JObject messageObj = JObject.Parse(message);
|
// if (messageObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() == "TRUE")
|
// {
|
// string str = $@"/*dialect*/UPDATE A
|
// SET A.FLOT=A.FLotTxt,A.FLOT_TEXT=ISNULL(C.FNAME,'')
|
// FROM dbo.T_SAL_ORDERENTRY A(NOLOCK)
|
// JOIN dbo.T_SAL_ORDER B(NOLOCK) ON B.FID = A.FID
|
// JOIN T_BD_LOTMASTER_L C(NOLOCK) ON C.FLOTID=A.FLotTxt
|
// WHERE B.FBILLNO LIKE '%{billno}%'";
|
// DBServiceHelper.Execute(this.Context, str);
|
// string mes = client.Submit("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + idlist + "\",\"SelectedPostId\":0,\"NetworkCtrl\":\"\"}");
|
// WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量提交结果：" + mes);
|
// string mess = client.Audit("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + idlist + "\",\"InterationFlags\":\"\",\"NetworkCtrl\":\"\"}");
|
// WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "批量审核结果：" + mess);
|
// //dictionary.Add(billno, messageObj["Result"]["ResponseStatus"]["SuccessEntitys"].ToString());
|
// }
|
// else
|
// {
|
// dictionary.Add(billno, messageObj["Result"]["ResponseStatus"]["Errors"].ToString());
|
// }
|
|
// }
|
// else
|
// {
|
// client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + idlist + "\",\"NetworkCtrl\":\"\"}");
|
// }
|
// }
|
// else
|
// {
|
// client.Delete("SAL_SaleOrder", "{\"CreateOrgId\":0,\"Numbers\":[],\"Ids\":\"" + idlist + "\",\"NetworkCtrl\":\"\"}");
|
// }
|
//}
|
#endregion
|
|
|
}
|
catch (Exception ex)
|
{
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "异常信息：" + JsonConvert.SerializeObject(ex));
|
throw new Exception(ex.Message);
|
}
|
|
|
}
|
WriteLog.SAL_SaleOrderSplitBill("订单审核拆单：" + billno, "截止时间:" + DateTime.Now.ToString());
|
|
}
|
//对拆单结果进行提示
|
foreach (var item in dictionary)
|
{
|
ResultMessage.dataError(this.OperationResult.OperateResult, item.Key, "拆单信息：" + item.Value);
|
}
|
|
//}
|
//else
|
//{
|
// throw new Exception("金蝶API登录失败！详细原因：1.检查密码是否调整，调整请联系金蝶开发人员。2.请检查网络状况！");
|
//}
|
|
}
|
|
public static class ResultMessage
|
{/// <summary>
|
/// 修改提示信息
|
/// </summary>
|
/// <param name="operateResult"></param>
|
/// <param name="billno"></param>
|
/// <param name="message"></param>
|
public static void dataError(OperateResultCollection operateResult, string billno, string message)
|
{
|
OperateResult operate = operateResult.Where(n => n.Number == billno).First();
|
operate.Message = message;
|
operate.SuccessStatus = false;
|
operate.MessageType = MessageType.Normal;
|
}
|
|
|
}
|
|
|
|
}
|
}
|
