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