代码提价

王 垚

2022-12-20 b1bf58acf727652b1a3a8760406879cae9018bc7

代码提价

 zymes/OperationService/zymes_RealessBillType.cs

@@ -76,7 +76,7 @@
                //LogService.Write("单据类型同步示例JsonConvert.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("单据类型同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Xt_BillType/SaveXt_BillTypeListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessBom.cs

@@ -241,7 +241,7 @@
                };
                //LogService.Write("生产BOM同步示例" + JsonConvert.SerializeObject(jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                //新增
                var requestPost = new RestRequest("Gy_ICBomBill/Gy_ICBomBillaveApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);

 zymes/OperationService/zymes_RealessCurrency.cs

@@ -79,7 +79,7 @@
                //LogService.Write("币别同步示例.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("币别同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Currency/SaveGy_CurrencyListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessCustomer.cs

@@ -97,7 +97,7 @@
                };
                //LogService.Write("客户同步示例" + JsonConvert.SerializeObject(jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Customer/SaveGy_CustomerListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessDepartment.cs

@@ -77,7 +77,7 @@
                };
                //LogService.Write("部门同步示例：" + JsonConvert.SerializeObject(_jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Department/SaveGy_DepartmentListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessMatePriceSup.cs

@@ -80,7 +80,7 @@
                //LogService.Write("采购价格同步示例JsonConvert.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("采购价格同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_MatePriceSup/SaveGy_MatePriceSupListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessMaterial.cs

@@ -183,19 +183,20 @@
        {
            base.AfterExecuteOperationTransaction(e);
            Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息
            foreach (var billObj in e.DataEntitys)
            try
            {
                var forgName = Context.CurrentOrganizationInfo.Name;
                var forgID = Context.CurrentOrganizationInfo.ID;
                LogService.Write(Context.CurrentOrganizationInfo.ID);
                LogService.Write($"组织:{forgName},{forgID}");
                if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                    continue;
                LogService.Write("物料同步插件执行开始：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff"));
                //var sql = $"exec zymes_RealessMaterial {billObj["Id"]} ";
                var id = billObj["Id"].ToString();
                string sql = string.Empty;
                sql = $@"
                foreach (var billObj in e.DataEntitys)
                {
                    var forgName = Context.CurrentOrganizationInfo.Name;
                    var forgID = Context.CurrentOrganizationInfo.ID;
                    LogService.Write($"组织:{forgName},{forgID}");
                    if (!forgName.Contains("杭州斯莫尔磁性材料有限公司"))
                        continue;
                    LogService.Write("物料同步插件执行开始：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff"));
                    //var sql = $"exec zymes_RealessMaterial {billObj["Id"]} ";
                    var id = billObj["Id"].ToString();
                    string sql = string.Empty;
                    sql = $@"
/*dialect*/
select a.FMATERIALID as HItemID ,a.FMATERIALID as HERPItemID,a.FNUMBER as HNumber,l.FNAME as HName,isnull(l.FSPECIFICATION,'') as HModel,a.FNUMBER as HShortNumber,0 as HParentID
,1 HLevel,'false' as HEndFlag,case when a.FFORBIDSTATUS='A' then 'false' else 'true' end as HStopflag,'CLD-ERP导入' as HRemark,b.FErpClsID as HMaterClsID,isnull(s.FSTOREUNITID,0) as HUnitID,0  as HUnitGroupID
@@ -215,77 +216,62 @@
Where l.FLOCALEID=2052
and a.FMATERIALID = {id}
";
                DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
                if (dt.Rows.Count == 0)
                {
                    LogService.Write("物料同步异常：" + sql);
                    continue;
                }
                DataRow dr = dt.Rows[0];
                JObject model = new JObject();
                foreach (DataColumn column in dt.Columns)
                {
                    model.Add(column.ColumnName, dr[column.ColumnName].ToString());
                }
                //model.Add("HItemID", dr["HItemID"].ToString());
                //model.Add("HERPItemID", dr["HERPItemID"].ToString());
                //model.Add("HCREATEORGID", dr["HCREATEORGID"].ToString());
                //model.Add("HUSEORGID", dr["HUSEORGID"].ToString());
                //model.Add("HNumber", dr["HNumber"].ToString());
                //model.Add("HName", dr["HName"].ToString());
                //model.Add("HModel", dr["HModel"].ToString());
                //model.Add("HUnitID", dr["HUnitID"].ToString());
                //model.Add("HUnitGroupID", dr["HUnitGroupID"].ToString());
                //model.Add("HMaterClsID", dr["HMaterClsID"].ToString());
                //model.Add("HMaterTypeID", dr["HMaterTypeID"].ToString());
                //model.Add("HWhID", dr["HWhID"].ToString());
                //model.Add("HSPID", dr["HSPID"].ToString());
                //model.Add("HMinPickQty", dr["HMinPickQty"].ToString());
                string _model = JsonConvert.SerializeObject(model);
                //JObject jsonRoot = new JObject()
                //{
                //    ["model"] = model + ";Admin;100038"
                //};
                JObject _jsonRoot = new JObject()
                {
                    ["model"] = model
                    DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
                    if (dt.Rows.Count == 0)
                    {
                        LogService.Write("物料同步异常：" + sql);
                        continue;
                    }
                    DataRow dr = dt.Rows[0];
                    JObject model = new JObject();
                    foreach (DataColumn column in dt.Columns)
                    {
                        model.Add(column.ColumnName, dr[column.ColumnName].ToString());
                    }
                    string _model = JsonConvert.SerializeObject(model);
                    JObject _jsonRoot = new JObject()
                    {
                        ["model"] = model
                    };
                    LogService.Write("物料同步插件,JSON拼接完成：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff"));
                    //var client = new RestSharp.RestClient("http://47.96.97.237/api/");
                    //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                    var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                    //var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                    //删除
                    //var requestGet = new RestRequest("Gy_Material/Delete", Method.GET);
                    //requestGet.AddParameter("HItemID", dr["HERPItemID"].ToString());
                    //requestGet.AddParameter("user", "10000");
                    //IRestResponse response = client.Execute(requestGet);
                    //var contentGet = response.Content;
                    //Console.WriteLine("GET方式获取结果：" + contentGet);
                    //新增
                    //LogService.Write("物料同步示例："+ JsonConvert.SerializeObject(_jsonRoot));
                    var requestPost = new RestRequest("Gy_Material/SaveGy_MaterialListApi", Method.POST);
                    requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                    IRestResponse responsePost = client.Execute(requestPost);
                    LogService.Write("物料同步插件,post完成：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff"));
                    var contentPost = responsePost.Content;
                    if (!contentPost.Contains("成功"))
                    {
                        LogService.Write("物料同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                        //LogService.Write("物料同步异常,ContentType," + responsePost.ContentType);
                        //LogService.Write("物料同步异常,ContentEncoding," + responsePost.ContentEncoding);
                        //LogService.Write("物料同步异常,Content," + responsePost.Content);
                        //LogService.Write("物料同步异常,StatusDescription," + responsePost.StatusDescription);
                        //LogService.Write("物料同步异常,Server," + responsePost.Server);
                        //LogService.Write("物料同步异常,ErrorMessage," + responsePost.ErrorMessage);
                        LogService.Write("物料同步异常,POST," + "Gy_Material/SaveGy_MaterialListApi");
                        LogService.Write("物料同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                    }
                    //Console.WriteLine("POST方式获取结果：" + contentPost);
                    //Console.Read();
                };
                LogService.Write("物料同步插件,JSON拼接完成：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff"));
                //string jsonRoot = JsonConvert.SerializeObject(jsonRoot);
                //var client = new RestSharp.RestClient("http://47.96.97.237/api/");
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                //删除
                //var requestGet = new RestRequest("Gy_Material/Delete", Method.GET);
                //requestGet.AddParameter("HItemID", dr["HERPItemID"].ToString());
                //requestGet.AddParameter("user", "10000");
                //IRestResponse response = client.Execute(requestGet);
                //var contentGet = response.Content;
                //Console.WriteLine("GET方式获取结果：" + contentGet);
                //新增
                //LogService.Write("物料同步示例："+ JsonConvert.SerializeObject(_jsonRoot));
                var requestPost = new RestRequest("Gy_Material/SaveGy_MaterialListApi", Method.POST);
                //var json = newjson.ToString() + ";Admin;100038";
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);
                LogService.Write("物料同步插件,post完成：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff"));
                var contentPost = responsePost.Content;
                if (!contentPost.Contains("成功"))
                {
                    LogService.Write("物料同步异常,POST方式获取结果," + billObj["Id"] + "," + contentPost);
                    LogService.Write("物料同步异常,ContentType," + responsePost.ContentType);
                    LogService.Write("物料同步异常,ContentEncoding," + responsePost.ContentEncoding);
                    LogService.Write("物料同步异常,Content," + responsePost.Content);
                    LogService.Write("物料同步异常,StatusDescription," + responsePost.StatusDescription);
                    LogService.Write("物料同步异常,Server," + responsePost.Server);
                    LogService.Write("物料同步异常,ErrorMessage," + responsePost.ErrorMessage);

                    LogService.Write("物料同步异常,POST," + "Gy_Material/SaveGy_MaterialListApi");
                    LogService.Write("物料同步异常,JsonConvert.SerializeObject(_jsonRoot)," + JsonConvert.SerializeObject(_jsonRoot));
                }
                //Console.WriteLine("POST方式获取结果：" + contentPost);
                //Console.Read();
            };
            }
            catch (Exception ex)
            {
                LogService.Write("物料同步插件，抛出异常：" + ex.Message.ToString());
            }
            LogService.Write("物料同步插件,代码执行完成：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff:ffffff"));
            //foreach (var item in dictionary)
            //{

 zymes/OperationService/zymes_RealessOperator.cs

@@ -91,7 +91,7 @@
                //LogService.Write("业务员同步示例：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("业务员同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Operator/SaveGy_OperatorListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessPaymentCondition.cs

@@ -78,7 +78,7 @@
                //LogService.Write("付款条件同步示例JsonConvert.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("付款条件同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_PaymentCondition/SaveGy_PaymentConditionListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessPrdMo.cs

@@ -249,7 +249,7 @@
                    ["model"] = model
                };
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                //新增
                var requestPost = new RestRequest("Sc_ICMOBill/ICMOBillSaveApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);

 zymes/OperationService/zymes_RealessPrdMoReport.cs

@@ -252,7 +252,7 @@
                };
                //LogService.Write("生产汇报单同步示例" + JsonConvert.SerializeObject(jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                //新增
                var requestPost = new RestRequest("Sc_ICMOReportBill/Sc_ICMOReportBillSaveApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);

 zymes/OperationService/zymes_RealessPrdPpbom.cs

@@ -246,7 +246,7 @@
                };
                //LogService.Write("生产用料清单同步示例" + JsonConvert.SerializeObject(jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                //新增
                var requestPost = new RestRequest("Sc_PPBomBill/Sc_PPBomBillSaveApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);

 zymes/OperationService/zymes_RealessPurPoorder.cs

@@ -254,7 +254,7 @@
                };
                //LogService.Write("采购订单同步示例" + JsonConvert.SerializeObject(jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                //新增
                var requestPost = new RestRequest("Cg_POOrderBill/Cg_POOrderBillSaveApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);

 zymes/OperationService/zymes_RealessPurReceive.cs

@@ -254,7 +254,7 @@
                };
                //LogService.Write("收料通知单同步示例" + JsonConvert.SerializeObject(jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                //新增
                var requestPost = new RestRequest("Cg_POInStockBill/Cg_POInStockBillSaveApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);

 zymes/OperationService/zymes_RealessRateType.cs

@@ -80,7 +80,7 @@
                //LogService.Write("汇率类型同步示例.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("汇率类型同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_RateType/SaveGy_RateTypeListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessRecCondition.cs

@@ -78,7 +78,7 @@
                //LogService.Write("收款条件同步示例JsonConvert.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("收款条件同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_RecCondition/SaveGy_RecConditionListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessSettleStyle.cs

@@ -79,7 +79,7 @@
                //LogService.Write("结算方式同步示例JsonConvert.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("结算方式同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_SettleStyle/SaveGy_SettleStyleListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessStaff.cs

@@ -80,7 +80,7 @@
                //LogService.Write("员工同步示例：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("员工同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Staff/SaveGy_StaffListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessStock.cs

@@ -60,27 +60,33 @@
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}

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)
inner join T_BD_STOCK_L L with(nolock) on A.FSTOCKID=L.FSTOCKID 
inner join T_BD_FLEXVALUESCOM ST with(nolock) on a.FSTOCKID = st.FSTOCKID
inner join (select c.FID HID,c.FF100001 HSPTypeID
,''""FStockLocId"":{""FSTOCKLOCID__FF100001"":{""FNUMBER"":""'' HSPType
,''""FSrcStockLocId"":{""FSRCSTOCKLOCID__FF100001"":{""FNUMBER"":""'' HSrcSPType
,''""FDestStockLocId"":{""FDESTSTOCKLOCID__FF100001"":{""FNUMBER"":""'' HDesSPType
,s.FNUMBER HNumber, sp.FName HName
from T_BAS_FLEXVALUESDETAIL c
inner
join T_BAS_FLEXVALUESENTRY s on s.FENTRYID = c.FF100001
inner
join T_BAS_FLEXVALUESENTRY_L sp on sp.FENTRYID = c.FF100001) c on c.HID = st.FSTOCKLOCID
inner join T_ORG_ORGANIZATIONS_L o with(nolock) on o.FORGID = A.FUSEORGID
where ST.FISDISABLE = '0' AND ST.FSYSDISABLE = '0'
and l.FLOCALEID = 2052 and isnull(o.FNAME,'') <> ''
and a.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)
//inner join T_BD_STOCK_L L with(nolock) on A.FSTOCKID = L.FSTOCKID
//inner join T_BD_FLEXVALUESCOM ST with(nolock) on a.FSTOCKID = st.FSTOCKID
//inner join(select c.FID HID, c.FF100001 HSPTypeID
//,''""FStockLocId"":{
//""FSTOCKLOCID__FF100001"":{
//""FNUMBER"":""'' HSPType
//,''""FSrcStockLocId"":{
//""FSRCSTOCKLOCID__FF100001"":{
//""FNUMBER"":""'' HSrcSPType
//,''""FDestStockLocId"":{
//""FDESTSTOCKLOCID__FF100001"":{
//""FNUMBER"":""'' HDesSPType
//,s.FNUMBER HNumber, sp.FName HName
//from T_BAS_FLEXVALUESDETAIL c
//inner
//join T_BAS_FLEXVALUESENTRY s on s.FENTRYID = c.FF100001
//inner
//join T_BAS_FLEXVALUESENTRY_L sp on sp.FENTRYID = c.FF100001) c on c.HID = st.FSTOCKLOCID
//inner join T_ORG_ORGANIZATIONS_L o with(nolock) on o.FORGID = A.FUSEORGID
//where ST.FISDISABLE = '0' AND ST.FSYSDISABLE = '0'
//and l.FLOCALEID = 2052 and isnull(o.FNAME,'') <> ''
//and a.FSTOCKID = {0}
                                        
                DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql);
                DataTable maindt = ds.Tables[0];//仓库
                DataTable subdt = ds.Tables[1];//仓位
@@ -112,7 +118,7 @@
                };
                LogService.Write("仓库仓位同步示例：" + JsonConvert.SerializeObject(jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Warehouse/SaveGy_WarehouseListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessStockStatus.cs

@@ -78,7 +78,7 @@
                //LogService.Write("库存状态同步示例JsonConvert.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("库存状态同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_StockStatus/SaveGy_StockStatusListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessSupplier.cs

@@ -77,7 +77,7 @@
                };
                //LogService.Write("供应商同步示例：" + JsonConvert.SerializeObject(_jsonRoot));
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Supplier/SaveGy_SupplierListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessTaxRate.cs

@@ -78,7 +78,7 @@
                //LogService.Write("税率同步示例JsonConvert.SerializeObject(_jsonRoot)：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("税率同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_TaxRate/SaveGy_TaxRateListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessUnit.cs

@@ -79,7 +79,7 @@
                //LogService.Write("单位同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                //var client = new RestSharp.RestClient("http://47.96.97.237/API/");
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Unit/SaveGy_UnitListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);

 zymes/OperationService/zymes_RealessWork.cs

@@ -79,7 +79,7 @@
                //LogService.Write("作业同步示例：" + JsonConvert.SerializeObject(_jsonRoot));
                //LogService.Write("作业同步示例：" + _jsonRoot);
                //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址
                var client = new RestSharp.RestClient("http://61.130.182.102:18181/simoerAPI/");
                var client = new RestSharp.RestClient(" http://10.11.18.195:8080/simoerapi/");
                var requestPost = new RestRequest("Gy_Work/SaveGy_WorkListApi", Method.POST);
                requestPost.AddParameter("application/json", JsonConvert.SerializeObject(_jsonRoot), ParameterType.RequestBody);
                IRestResponse responsePost = client.Execute(requestPost);