提交

王 垚

2022-12-21 3c2e0c966f46c7da818ddebb08f7accf4133b97f

提交

 zymes/OperationService/zymes_RealessBillType.cs

@@ -83,7 +83,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("单据类型同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("单据类型同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("单据类型同步异常,POST," +   "Xt_BillType/SaveXt_BillTypeListApi");
                    LogService.Write("单据类型同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessBom.cs

@@ -249,7 +249,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("生产BOM同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("生产BOM同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("生产BOM同步异常,POST," +   "Gy_ICBomBill/Gy_ICBomBillaveApi");
                    LogService.Write("生产BOM同步异常,JsonConvert.SerializeObject(jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessCurrency.cs

@@ -86,7 +86,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("币别同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("币别同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("币别同步异常,POST," +   "Gy_Currency/SaveGy_CurrencyListApi");
                    LogService.Write("币别同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessCustomer.cs

@@ -104,7 +104,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("客户同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("客户同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("客户同步异常,POST," + "Gy_Customer/SaveGy_CustomerListApi");
                    LogService.Write("客户同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessDepartment.cs

@@ -84,7 +84,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("部门同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("部门同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("部门同步异常,POST," + "Gy_Department/SaveGy_DepartmentListApi");
                    LogService.Write("部门同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessMatePriceSup.cs

@@ -87,7 +87,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("采购价格同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("采购价格同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("采购价格同步异常,POST," +   "Gy_MatePriceSup/SaveGy_MatePriceSupListApi");
                    LogService.Write("采购价格同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessMaterial.cs

@@ -254,7 +254,7 @@
                    var contentPost = responsePost.Content;
                    if (!contentPost.Contains("成功"))
                    {
                        LogService.Write("物料同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                        LogService.Write("物料同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                        //LogService.Write("物料同步异常,ContentType," + responsePost.ContentType);
                        //LogService.Write("物料同步异常,ContentEncoding," + responsePost.ContentEncoding);
                        //LogService.Write("物料同步异常,Content," + responsePost.Content);
@@ -264,7 +264,7 @@
                        LogService.Write("物料同步异常,POST," + "Gy_Material/SaveGy_MaterialListApi");
                        LogService.Write("物料同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                    }
                    //Console.WriteLine("POST方式获取结果：" + contentPost);
                    //Console.WriteLine("POST方式获取结果：" + responsePost.ErrorMessage);
                    //Console.Read();
                };
            }

 zymes/OperationService/zymes_RealessOperator.cs

@@ -98,7 +98,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("业务员同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("业务员同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("业务员同步异常,POST," + "Gy_Operator/SaveGy_OperatorListApi");
                    LogService.Write("业务员同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessPaymentCondition.cs

@@ -85,7 +85,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("付款条件同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("付款条件同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("付款条件同步异常,POST," +   "Gy_PaymentCondition/SaveGy_PaymentConditionListApi");
                    LogService.Write("付款条件同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessPrdMo.cs

@@ -257,7 +257,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("生产订单同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("生产订单同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("生产订单同步异常,POST," +   "Sc_ICMOBill/ICMOBillSaveApi");
                    LogService.Write("生产订单同步异常,JsonConvert.SerializeObject(jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessPrdMoReport.cs

@@ -260,7 +260,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("生产汇报单同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("生产汇报单同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("生产汇报单同步异常,POST," +   "Sc_ICMOReportBill/Sc_ICMOReportBillSaveApi");
                    LogService.Write("生产汇报单同步异常,JsonConvert.SerializeObject(jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessPrdPpbom.cs

@@ -254,7 +254,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("生产用料清单同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("生产用料清单同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("生产用料清单同步异常,POST," +   "Sc_PPBomBill/Sc_PPBomBillSaveApi");
                    LogService.Write("生产用料清单同步异常,JsonConvert.SerializeObject(jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessPurPoorder.cs

@@ -262,7 +262,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("采购订单同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("采购订单同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("采购订单同步异常,POST," +   "Cg_POOrderBill/Cg_POOrderBillSaveApi");
                    LogService.Write("采购订单同步异常,JsonConvert.SerializeObject(jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessPurReceive.cs

@@ -262,7 +262,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("收料通知单同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("收料通知单同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("收料通知单同步异常,POST," +   "Cg_POInStockBill/Cg_POInStockBillSaveApi");
                    LogService.Write("收料通知单同步异常,JsonConvert.SerializeObject(jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessRateType.cs

@@ -87,7 +87,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("汇率类型同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("汇率类型同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("汇率类型同步异常,POST," +"Gy_RateType/SaveGy_RateTypeListApi");
                    LogService.Write("汇率类型同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessRecCondition.cs

@@ -85,7 +85,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("收款条件同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("收款条件同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("收款条件同步异常,POST," +   "Gy_RecCondition/SaveGy_RecConditionListApi");
                    LogService.Write("收款条件同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessSettleStyle.cs

@@ -86,7 +86,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("结算方式同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("结算方式同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("结算方式同步异常,POST," +   "Gy_SettleStyle/SaveGy_SettleStyleListApi");
                    LogService.Write("结算方式同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessStaff.cs

@@ -87,7 +87,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("员工同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("员工同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("员工同步异常,POST," + "Gy_Staff/SaveGy_StaffListApi");
                    LogService.Write("员工同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessStock.cs

@@ -46,8 +46,8 @@
            foreach (var billObj in e.DataEntitys)
            {
                var forgName = Context.CurrentOrganizationInfo.Name;
                if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                    continue;
                //if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                //    continue;
                //var sql = $"exec zymes_RealessStock {billObj["Id"]} ";
                var id = billObj["Id"].ToString();
                string sql = string.Empty;
@@ -60,7 +60,19 @@
from T_BD_STOCK a with(nolock)
inner join T_BD_STOCK_L l with(nolock) on a.FSTOCKID=l.FSTOCKID
Where a.FSTOCKID = {0}
",id);

select  t1.FSTOCKLOCID as HItemID,t1.FSTOCKLOCID as HERPItemID,t3.FNUMBER HNumber,t4.FNAME HName,t3.FNUMBER HShortNumber,1 HParentID,'' HSPType,''  HSrcSPType,'' HDesSPType
,1 as HLevel,1 as HEndFlag,0 as HStopflag,'CLD-ERP导入' HRemark,t1.fstockid as HSPGroupID,'已使用' as HUseFlag,getdate() as HMakeTime,st.FCREATORID HCREATEORGID,st.FUSEORGID HUSEORGID from 
T_BD_FLEXVALUESCOM t1 
join T_BD_STOCK st on t1.FSTOCKID = st.FSTOCKID 
join T_BD_STOCK_l stl on t1.FSTOCKID = stl.FSTOCKID  and stl.FLOCALEID = 2052
join T_BAS_FLEXVALUESDETAIL t2 on t1.FSTOCKLOCID = t2.FID
--SELECT * FROM T_BAS_FLEXVALUESENTRY t1--仓位值集列表明细
--join T_BAS_FLEXVALUESENTRY_L  t2 on t1.FENTRYID=t2.FENTRYID--仓位值集列表
join T_BAS_FLEXVALUESENTRY t3 on t2.FF100003 = t3.FENTRYID--仓位值集列表明细
join T_BAS_FLEXVALUESENTRY_L t4 on t3.FENTRYID=t4.FENTRYID
where t1.fstockid= {0} --采购入库单选择仓库后 选择仓位
", id);
//select c.HID as HItemID,c.HID as HERPItemID,c.HNumber as HNumber,c.HName as HName,c.HNumber as HShortNumber,0 as HParentID,c.HSPType as HSPType,c.HSrcSPType as HSrcSPType,c.HDesSPType as HDesSPType
//,1 as HLevel,'true' as HEndFlag,'false' as HStopflag,'CLD-ERP导入' as HRemark,a.FSTOCKID as HSPGroupID,'已使用' as HUseFlag,getdate() as HMakeTime,a.FCREATEORGID as HCREATEORGID,a.FUSEORGID as HUSEORGID
//from T_BD_STOCK A  with(nolock)
@@ -125,7 +137,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("仓库仓位同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("仓库仓位同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("仓库仓位同步异常,POST," +   "Gy_Warehouse/SaveGy_WarehouseListApi");
                    LogService.Write("仓库仓位同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessStockStatus.cs

@@ -85,7 +85,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("库存状态同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("库存状态同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("库存状态同步异常,POST," +   "Gy_StockStatus/SaveGy_StockStatusListApi");
                    LogService.Write("库存状态同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessSupplier.cs

@@ -84,7 +84,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("供应商同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("供应商同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("供应商步异常,POST," +   "Gy_Supplier/SaveGy_SupplierListApi");
                    LogService.Write("供应商同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessTaxMIX.cs

@@ -90,7 +90,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("税率组合同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("税率组合同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("税率组合同步异常,POST," + clientUrl + "Gy_TaxMIXMain/SaveGy_TaxMIXMainListApi");
                    LogService.Write("税率组合同步异常,JsonConvert.SerializeObject(jsonRoot)," + JsonConvert.SerializeObject(jsonRoot));
                }

 zymes/OperationService/zymes_RealessTaxRate.cs

@@ -85,7 +85,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("税率同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("税率同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("税率同步异常,POST," +   "Gy_TaxRate/SaveGy_TaxRateListApi");
                    LogService.Write("税率同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessUnit.cs

@@ -86,7 +86,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("单位同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("单位同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("单位同步异常,POST," + "Gy_Unit/SaveGy_UnitListApi");
                    LogService.Write("单位同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }

 zymes/OperationService/zymes_RealessWork.cs

@@ -86,7 +86,7 @@
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                { 
                    LogService.Write("作业同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("作业同步异常,POST方式获取结果," + billObj["Id"] + "," + responsePost.ErrorMessage);
                    LogService.Write("作业同步异常,POST," + "Gy_Work/SaveGy_WorkListApi");
                    LogService.Write("作业同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }