1

沈泽

2021-10-12 4ce845ec79f717ac4669ce3e39eaa0cb7323b1ad

 WebAPI/Controllers/Pay_OtherBalBillController.cs

@@ -93,8 +93,8 @@
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                string sql1 = "SELECT 物料ID,物料代码,物料名称,HDeptID,部门代码,部门" +
                    ", HGroupID, 班组代码, 班组, 工资类型, 摘要, 内部单据号, 表头备注, 制单人, 制单日期" +
                    ", 审核人, 审核日期, 修改人, 修改日期, 关闭人, 关闭日期, 工序ID, 工序代码, 工序名称" +
                    ", HGroupID, 班组代码, 班组, 工资类型, 摘要, 内部单据号, 表头备注" +
                    ", 工序ID, 工序代码, 工序名称" +
                    ", 职员ID, 职员代码, 职员, 工时, 数量, 工价, 金额 FROM h_v_Pay_OtherBalBillList where 1 = 1 ";
                string sql = sql1 + sqlWhere;
                ds = oCN.RunProcReturn(sql, "h_v_Pay_OtherBalBillList");
@@ -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")