From b14d014e39c97d339ee83c0e272afd4e7a6ee709 Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期四, 14 十月 2021 16:54:57 +0800 Subject: [PATCH] 分布式调入调出 --- WebAPI/Controllers/Pay_OtherBalBillController.cs | 24 +++++++++++------------- 1 files changed, 11 insertions(+), 13 deletions(-) diff --git a/WebAPI/Controllers/Pay_OtherBalBillController.cs b/WebAPI/Controllers/Pay_OtherBalBillController.cs index 44e2217..9389403 100644 --- a/WebAPI/Controllers/Pay_OtherBalBillController.cs +++ b/WebAPI/Controllers/Pay_OtherBalBillController.cs @@ -160,10 +160,10 @@ int HYear = 2021; double HPeriod = 1; string HRemark = mainList[0].HRemark;//澶囨敞 - string HBillSubType = mainList[0].HBillSubType; + string HBillSubType = "2206"; string HMaker = mainList[0].HMaker; - string HExplanation = mainList[0].HExplanation; - string HInnerBillNo = mainList[0].HInnerBillNo; + string HExplanation = "0"; + string HInnerBillNo = "0"; long HMaterID = mainList[0].HMaterID;//浜у搧ID long HGroupID = mainList[0].HGroupID; long HDeptID = mainList[0].HDeptID; @@ -174,16 +174,14 @@ int HPRDORGID = mainList[0].HPRDORGID; //缁勭粐 //涓昏〃 - oCN.RunProc("Insert Into Pay_OtherBalBillMain " + - "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + - ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + - ",HGroupID,HDeptID,HEmpID,HPayType,HExplanation,HInnerBillNo" + - ") " + - " values('" + HBillType + "'," + HBillSubType + ",'" + HInterID + "','" + HBillNo + "','" + HDate + "'" + - "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HGroupID + "," + HDeptID + "," + HEmpID + ","+ - "," + HPayType + "," + HExplanation + ",'" + HInnerBillNo + "'," + - ") "); - + oCN.RunProc(" Insert Into Pay_OtherBalBillMain " + + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + + ",HYear,HPeriod,HRemark,HMaker" + + ",HGroupID,HDeptID,HEmpID,HPayType,HInnerBillNo,HExplanation" + ")" + + "values('" + HBillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + + "','" + HYear + "'," + HPeriod + ",'" + HRemark + "','" + HMaker + "'," + HGroupID + ", " + HDeptID + + "," + HEmpID + ",'" + HPayType + "','" + HInnerBillNo + "'," + HExplanation + + ") "); //淇濆瓨瀛愯〃 objJsonResult = AddBillSub(msg3, HInterID); if (objJsonResult.code == "0") -- Gitblit v1.9.1