1

沈泽

2021-10-11 a72ba1e5a848c461186ff0e5cafa8123e58142b8

 WebAPI/Controllers/Pay_SingleBalBillController.cs

@@ -174,15 +174,14 @@
                int HPRDORGID = mainList[0].HPRDORGID;  //组织

                //主表
                oCN.RunProc("Insert Into Pay_SingleBalBillMain   " +
                "(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_SingleBalBillMain " + 
                    "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + 
                    ",HYear,HPeriod,HRemark,HMaker" + 
                    ",HGroupID,HDeptID,HEmpID,HPayType,HExplanation,HInnerBillNo" + ")" +
                    "values('" + HBillType + "'" + HBillSubType + "," + HInterID + ",'" + HBillNo + "','" + HDate +
                    "',"+ HDeptID + "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "'," + HGroupID + 
                    "," + HEmpID + ","+ HPayType +",'" + HInnerBillNo + "'" + HExplanation + 
                   ") ");

                //保存子表
                objJsonResult = AddBillSub(msg3, HInterID);