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_RealessRecCondition.cs | 16 +++++++++++++---
1 files changed, 13 insertions(+), 3 deletions(-)
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);
--
Gitblit v1.9.1