From 0a4aae19e37ca3d6eb8d03e67a42ef07eb584818 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期四, 15 十二月 2022 09:45:17 +0800
Subject: [PATCH] 修改存储过程
---
zymes/OperationService/zymes_RealessTaxRate.cs | 16 ++++++-
zymes/OperationService/zymes_RealessRecCondition.cs | 16 ++++++-
zymes/OperationService/zymes_RealessPaymentCondition.cs | 14 ++++++-
zymes/OperationService/zymes_RealessStockStatus.cs | 16 ++++++-
4 files changed, 51 insertions(+), 11 deletions(-)
diff --git a/zymes/OperationService/zymes_RealessPaymentCondition.cs b/zymes/OperationService/zymes_RealessPaymentCondition.cs
index 4a9fab3..9c11a94 100644
--- a/zymes/OperationService/zymes_RealessPaymentCondition.cs
+++ b/zymes/OperationService/zymes_RealessPaymentCondition.cs
@@ -45,7 +45,17 @@
Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
foreach (var billObj in e.DataEntitys)
{
- var sql = $"exec zymes_RealessPaymentCondition {billObj["Id"]} ";
+ var id = billObj["Id"].ToString();
+ string sql = string.Empty;
+ sql = $@"
+/*dialect*/
+select a.FID as HItemID,a.FNumber as HNumber,l.FName as HName,a.FNumber as HShortNumber,0 as HParentID
+,1 as HLevel,'true' as HEndFlag,case when a.FFORBIDSTATUS='A' then 'false' else 'true' end as HStopflag,'CLD-ERP瀵煎叆' as HRemark,'' HHelpCode,'鏈娴�' as HUseFlag,FCREATEDATE as HMakeTime
+,'' HMakeEmp,'' HCheckEmp,a.FAUDITDATE HCheckTime,'' HModifyEmp,a.FMODIFYDATE HModifyTime,'' HStopEmp,a.FUSEORGID as HUSEORGID,a.FCREATEORGID as HCREATEORGID
+from T_BD_PaymentCondition a with(nolock)
+inner join T_BD_PAYMENTCONDITION_L l with(nolock) on a.FID=l.FID and FLOCALEID=2052
+Where a.FID='{id}'";
+
DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
if (dt.Rows.Count == 0)
{
@@ -63,7 +73,7 @@
["model"] = model
};
//LogService.Write("浠樻鏉′欢鍚屾绀轰緥JsonConvert.SerializeObject(_jsonRoot)锛�" + JsonConvert.SerializeObject(_jsonRoot));
- LogService.Write("浠樻鏉′欢鍚屾绀轰緥锛�" + _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 requestPost = new RestRequest("Gy_PaymentCondition/SaveGy_PaymentConditionListApi", Method.POST);
diff --git a/zymes/OperationService/zymes_RealessRecCondition.cs b/zymes/OperationService/zymes_RealessRecCondition.cs
index 10b6450..d66841f 100644
--- a/zymes/OperationService/zymes_RealessRecCondition.cs
+++ b/zymes/OperationService/zymes_RealessRecCondition.cs
@@ -45,7 +45,17 @@
Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
foreach (var billObj in e.DataEntitys)
{
- var sql = $"exec zymes_RealessRecCondition {billObj["Id"]} ";
+ var id = billObj["Id"].ToString();
+ string sql = string.Empty;
+ sql = $@"
+/*dialect*/
+select a.FID as HItemID,a.FNumber as HNumber,l.FName as HName,a.FNumber as HShortNumber,0 as HParentID
+,1 as HLevel,'true' as HEndFlag,case when a.FFORBIDSTATUS='A' then 'false' else 'true' end as HStopflag,'CLD-ERP瀵煎叆' as HRemark,'' HHelpCode,'鏈娴�' as HUseFlag,FCREATEDATE as HMakeTime
+,'' HMakeEmp,'' HCheckEmp,a.FAUDITDATE HCheckTime,'' HModifyEmp,a.FMODIFYDATE HModifyTime,'' HStopEmp,a.FUSEORGID as HUSEORGID,a.FCREATEORGID as HCREATEORGID
+from T_BD_RecCondition a with(nolock)
+inner join T_BD_RECCONDITION_L l with(nolock) on a.FID=l.FID and FLOCALEID=2052
+Where a.FID='{id}'";
+
DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
if (dt.Rows.Count == 0)
{
@@ -62,8 +72,8 @@
{
["model"] = model
};
- LogService.Write("鏀舵鏉′欢鍚屾绀轰緥JsonConvert.SerializeObject(_jsonRoot)锛�" + JsonConvert.SerializeObject(_jsonRoot));
- LogService.Write("鏀舵鏉′欢鍚屾绀轰緥锛�" + _jsonRoot);
+ //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 requestPost = new RestRequest("Gy_RecCondition/SaveGy_RecConditionListApi", Method.POST);
diff --git a/zymes/OperationService/zymes_RealessStockStatus.cs b/zymes/OperationService/zymes_RealessStockStatus.cs
index 724bc87..0b45e57 100644
--- a/zymes/OperationService/zymes_RealessStockStatus.cs
+++ b/zymes/OperationService/zymes_RealessStockStatus.cs
@@ -45,7 +45,17 @@
Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
foreach (var billObj in e.DataEntitys)
{
- var sql = $"exec zymes_RealessStockStatus {billObj["Id"]} ";
+ var id = billObj["Id"].ToString();
+ string sql = string.Empty;
+ sql = $@"
+/*dialect*/
+select a.FSTOCKSTATUSID as HItemID,a.FNumber as HNumber,l.FName as HName,a.FNumber as HShortNumber,0 as HParentID
+,1 as HLevel,'true' as HEndFlag,case when a.FFORBIDSTATUS='A' then 'false' else 'true' end as HStopflag,'CLD-ERP瀵煎叆' as HRemark,'' HHelpCode,'鏈娴�' as HUseFlag,FCREATEDATE as HMakeTime
+,'' HMakeEmp,'' HCheckEmp,a.FAUDITDATE HCheckTime,'' HModifyEmp,a.FMODIFYDATE HModifyTime,'' HStopEmp,a.FUSEORGID as HUSEORGID,a.FCREATEORGID as HCREATEORGID
+from t_BD_StockStatus a with(nolock)
+inner join T_BD_STOCKSTATUS_L l with(nolock) on a.FSTOCKSTATUSID=l.FSTOCKSTATUSID and FLOCALEID=2052
+Where a.FSTOCKSTATUSID='{id}'";
+
DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
if (dt.Rows.Count == 0)
{
@@ -62,8 +72,8 @@
{
["model"] = model
};
- LogService.Write("搴撳瓨鐘舵�佸悓姝ョず渚婮sonConvert.SerializeObject(_jsonRoot)锛�" + JsonConvert.SerializeObject(_jsonRoot));
- LogService.Write("搴撳瓨鐘舵�佸悓姝ョず渚嬶細" + _jsonRoot);
+ //LogService.Write("搴撳瓨鐘舵�佸悓姝ョず渚婮sonConvert.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 requestPost = new RestRequest("Gy_StockStatus/SaveGy_StockStatusListApi", Method.POST);
diff --git a/zymes/OperationService/zymes_RealessTaxRate.cs b/zymes/OperationService/zymes_RealessTaxRate.cs
index 9f8858c..f31874f 100644
--- a/zymes/OperationService/zymes_RealessTaxRate.cs
+++ b/zymes/OperationService/zymes_RealessTaxRate.cs
@@ -45,7 +45,17 @@
Entity entity = this.BusinessInfo.GetEntity("FEntity");//鑾峰彇鏄庣粏淇℃伅
foreach (var billObj in e.DataEntitys)
{
- var sql = $"exec zymes_RealessTaxRate {billObj["Id"]} ";
+ var id = billObj["Id"].ToString();
+ string sql = string.Empty;
+ sql = $@"
+/*dialect*/
+select a.FID as HItemID,a.FNumber as HNumber,l.FName as HName,a.FNumber as HShortNumber,0 as HParentID
+,1 as HLevel,'true' as HEndFlag,case when a.FFORBIDSTATUS='A' then 'false' else 'true' end as HStopflag,'CLD-ERP瀵煎叆' as HRemark,'' HHelpCode,'鏈娴�' as HUseFlag,FCREATEDATE as HMakeTime
+,'' HMakeEmp,'' HCheckEmp,a.FAPPROVEDATE HCheckTime,'' HModifyEmp,a.FMODIFYDATE HModifyTime,'' HStopEmp,a.FUSEORGID as HUSEORGID,a.FCREATEORGID as HCREATEORGID
+from T_BD_TAXRATE a with(nolock)
+inner join T_BD_TAXRATE_L l with(nolock) on a.FID=l.FID and FLOCALEID=2052
+Where a.FID='{id}'";
+
DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0];
if (dt.Rows.Count == 0)
{
@@ -62,8 +72,8 @@
{
["model"] = model
};
- LogService.Write("绋庣巼鍚屾绀轰緥JsonConvert.SerializeObject(_jsonRoot)锛�" + JsonConvert.SerializeObject(_jsonRoot));
- LogService.Write("绋庣巼鍚屾绀轰緥锛�" + _jsonRoot);
+ //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 requestPost = new RestRequest("Gy_TaxRate/SaveGy_TaxRateListApi", Method.POST);
--
Gitblit v1.9.1