zzr99
2021-10-12 dd031f91464d6452c0705cb5456f854a3d91dcc2
WebAPI/Controllers/Pay_SingleBalBillController.cs
@@ -160,10 +160,10 @@
                int HYear = 2021;
                double HPeriod = 1;
                string HRemark = mainList[0].HRemark;//备注
                string HBillSubType = mainList[0].HBillSubType;
                string HBillSubType = "2205";
                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;
@@ -176,11 +176,11 @@
                //主表
                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 +
                    ",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 +
                   ") ");
                //保存子表