器具管理维护

yangle

2022-12-30 e69dfa27e62cf31380576ae275a812ece2cf20f9

 WebAPI/Controllers/基础资料/基础资料/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;