分布式调入调出

王 垚

2021-10-14 b14d014e39c97d339ee83c0e272afd4e7a6ee709

 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")