1

yangle

2025-02-13 ed9db56a79756894ee8c997582b1ed797f379f18

 DAL/计划管理/ClsGy_ICBomBill.cs

@@ -39,9 +39,9 @@
                //鏇存柊涓昏〃
                oCn.RunProc("UpDate Gy_ICBomBillMain set  " +
                " HBillNo='" + omodel.HBillNo + "'" +
                ",HDate='" + omodel.HDate + "'" +
                ",HYear='" + omodel.HYear.ToString() + "'" +
                ",HPeriod='" + omodel.HPeriod.ToString() + "'" +
                //",HDate='" + omodel.HDate + "'" +
                //",HYear='" + omodel.HYear.ToString() + "'" +
                //",HPeriod='" + omodel.HPeriod.ToString() + "'" +
                ",HRemark='" + omodel.HRemark + "'" +
                ",HUpDater='" + omodel.HUpDater + "'" +
                ",HUpDateDate='" + omodel.HUpDateDate + "'" +
@@ -56,6 +56,7 @@
                ",HProdRate=" + omodel.HProdRate.ToString() +
                ",HQty=" + omodel.HQty.ToString() +
                ",HJump='" + omodel.HJump + "'" +
                ",HBomType='" + omodel.HBomType + "'" +
                " where HInterID=" + lngBillKey.ToString());
                //鍒犻櫎鍏宠仈
                DeleteRelation(ref sReturn, lngBillKey);
@@ -104,12 +105,12 @@
                "(HBillType,HInterID,HBillNo,HDate" + 
                ",HYear,HPeriod,HRemark,HMaker,HMakeDate,HMaterTypeID,HStatus" +
                ",HMaterID,HParentID,HVersion,HPicNo,HPropertyID" +
                ",HUnitID,HQty,HProdRate,HJump" +
                ",HUnitID,HQty,HProdRate,HJump,HBomType" +
                ") " +
                " values('" + this.BillType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate(),'" + omodel.HMaterTypeID.ToString() + "','" + omodel.HStatus +
                "','" + omodel.HMaterID.ToString() + "'," + omodel.HParentID.ToString() + ",'" + omodel.HVersion + "','" + omodel.HPicNo + "'," +omodel.HPropertyID.ToString() +
                ","+omodel.HUnitID.ToString()+","+omodel.HQty.ToString()+","+omodel.HProdRate.ToString()+",'"+omodel.HJump +"'"+
                ","+omodel.HUnitID.ToString()+","+omodel.HQty.ToString()+","+omodel.HProdRate.ToString()+",'"+omodel.HJump +"','"+omodel.HBomType + "'"+
                ") ");
                //鎻掑叆瀛愯〃
                foreach (Model.ClsGy_ICBomBillSub oSub in DetailColl)