From 6a2a02e183b0c0a8b01bebd0452bd0ac0bbed445 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期一, 03 十一月 2025 16:26:34 +0800
Subject: [PATCH] 1
---
WebAPI/Controllers/基础资料/基础资料/Gy_AssistantDataEntryController.cs | 23 +++++++++++++----------
1 files changed, 13 insertions(+), 10 deletions(-)
diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_AssistantDataEntryController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_AssistantDataEntryController.cs"
index d4e557a..fab9cbf 100644
--- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_AssistantDataEntryController.cs"
+++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_AssistantDataEntryController.cs"
@@ -30,39 +30,42 @@
{
oCN.BeginTran();
LogService.Write("閿�鍞��璐у師鍥�/閫�璐х被鍨� 瀹℃牳鍚屾: " + sMainSub.ToString());
-
- var sMain = "[" + sMainSub["model"].ToString() + "]";
+ foreach (var oSub in sMainSub["model"]["FENTRY"])
+ {
+ oSub["hstopflag"] = string.Equals(oSub["hstopflag"].ToString(), "1");
+ }
+ var sMain = sMainSub["model"].ToString();
var sSub = sMainSub["model"]["FENTRY"].ToString();
List<Model.ClsGy_AssistantData> lsmain = new List<Model.ClsGy_AssistantData>();
List<Model.ClsGy_AssistantDataEntry> lssub = new List<Model.ClsGy_AssistantDataEntry>();
lsmain = oListModels.getObjectByJson_Gy_AssistantData(sMain);
- lssub = oListModels.getObjectByJson_Gy_AssistantDataEntry(sSub);
+ lssub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_AssistantDataEntry>>(sSub);
var sql = string.Empty;
foreach (var oMain in lsmain)
{
// 鍒犻櫎涓昏〃鏁版嵁
- sql = $@"delete from Gy_AssistantData where HID = {oMain.HID}";
+ sql = $@"delete from Gy_AssistantData where HID = '{oMain.HID}'";
oCN.RunProc(sql);
// 鍒犻櫎瀛愯〃鏁版嵁
- sql = $@"delete from Gy_AssistantDataEntry where HID = {oMain.HID}";
+ sql = $@"delete from Gy_AssistantDataEntry where HID = '{oMain.HID}'";
oCN.RunProc(sql);
sql = $@"insert into Gy_AssistantData
(HID,HNumber,HName,HRemark,HLOCALEID)
- values({oMain.HID}, '{oMain.HNumber}', '{oMain.HName}', '{oMain.HRemark}',
- {oMain.HLOCALEID}
+ values('{oMain.HID}', '{oMain.HNumber}', '{oMain.HName}', '{oMain.HRemark}',
+ '{oMain.HLOCALEID}'
)
- )
";
+ oCN.RunProc(sql);
- foreach(var oSub in lssub)
+ foreach (var oSub in lssub)
{
sql = $@"insert into Gy_AssistantDataEntry
(HID,HEntryID,HNumber,HName,HStopflag,HRemark
,HMakeTime,HMakeEmp,HCheckTime,HCheckEmp,HModifyTime,HModifyEmp
,HLOCALEID,HUSEORGID,HCREATEORGID)
- values({oSub.HID}, '{oSub.HEntryID}', '{oSub.HNumber}', '{oSub.HName}',
+ values('{oSub.HID}', '{oSub.HEntryID}', '{oSub.HNumber}', '{oSub.HName}',
'{oSub.HStopflag}', '{oSub.HRemark}', '{oSub.HMakeTime}',
'{oSub.HMakeEmp}', '{oSub.HCheckTime}', '{oSub.HCheckEmp}',
'{oSub.HModifyTime}', '{oSub.HModifyEmp}','{oSub.HLOCALEID}',
--
Gitblit v1.9.1