From e69dfa27e62cf31380576ae275a812ece2cf20f9 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期五, 30 十二月 2022 10:36:35 +0800
Subject: [PATCH] 器具管理维护
---
WebAPI/Controllers/基础资料/基础资料/Gy_TaxMIXController.cs | 20 ++++++++++++++++----
1 files changed, 16 insertions(+), 4 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_TaxMIXController.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_TaxMIXController.cs"
index 2279de3..5873a83 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_TaxMIXController.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_TaxMIXController.cs"
@@ -363,6 +363,9 @@
oCN.RunProc(sql);
sql = $"delete Gy_TaxMIXSub where HItemID = {mainList[0].HItemID}";
oCN.RunProc(sql);
+
+ sql = "set identity_insert Gy_TaxMIXMain on";
+ oCN.RunProc(sql);
//涓昏〃
oCN.RunProc($@"insert into Gy_TaxMIXMain(HItemID,HNumber,HName ,HShortNumber,HParentID ,HLevel
,HEndFlag,HStopflag,HRemark ,HHelpCode ,HUseFlag
@@ -372,15 +375,24 @@
,{Convert.ToString(mainList[0].HEndFlag ? 1 : 0)},{Convert.ToString(mainList[0].HStopflag ? 1 : 0) },'{mainList[0].HRemark}','{mainList[0].HHelpCode}','{mainList[0].HUseFlag}'
,'{mainList[0].HMakeTime}','{mainList[0].HMakeEmp}','{mainList[0].HCheckEmp}','{mainList[0].HCheckTime}','{mainList[0].HModifyEmp}'
,'{mainList[0].HModifyTime}','{mainList[0].HStopEmp}',null,{mainList[0].HUSEORGID},{mainList[0].HCREATEORGID})", ref DBUtility.ClsPub.sExeReturnInfo);
+
+ sql = "set identity_insert Gy_TaxMIXMain off";
+ oCN.RunProc(sql);
+
+ sql = "set identity_insert Gy_TaxMIXSub on";
+ oCN.RunProc(sql);
//淇濆瓨涓昏〃
foreach (var oSub in subList)
{
oCN.RunProc($@"Insert into Gy_TaxMIXSub
- (HItemID,FTAXMIXID,HTAXBENCHMARK,FTAXRATEID
- ,FTAXBENCHMARKCORRVALUE)
- values({oSub.HItemID},{oSub.HTAXMIXID},{oSub.HTAXBENCHMARK}
- ,{oSub.FTAXRATEID},{oSub.FTAXBENCHMARKCORRVALUE})");
+ (HItemID,HTAXMIXID,HTAXBENCHMARK,FTAXRATEID)
+ values({oSub.HItemID},{oSub.HTAXMIXID},'{oSub.HTAXBENCHMARK}'
+ ,{oSub.FTAXRATEID})");
}
+
+ sql = "set identity_insert Gy_TaxMIXSub off";
+ oCN.RunProc(sql);
+
oCN.Commit();
objJsonResult.code = "1";
objJsonResult.count = 1;
--
Gitblit v1.9.1