费用实际成本报表

llj

2026-03-03 29cbeedd10e87d70f80d245a3e111cfe8a36fccd

 WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs

@@ -78,13 +78,13 @@
                          ",HManagerID" +
                          ",HCloseMan,HCloseType,HRemark" +
                          ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                          ") values("
                          ",HStdMaintainResult) values("
                          + omodel.HInterID.ToString() + "," + Item.HEntryID.ToString() + "," + Item.HMaintainItemID.ToString() + ",'" + Item.HMaintainItem.ToString() + "'" +
                          ",'" + Item.HMaintainPart.ToString() + "','" + Item.HClaim.ToString() + "'" +
                          "," + Item.HManagerID.ToString() +
                          ",'" + Item.HCloseMan + "'," + Convert.ToString(Item.HCloseType ? 1 : 0) + ",'" + Item.HRemark + "'" +
                          "," + Item.HSourceInterID.ToString() + "," + Item.HSourceEntryID.ToString() + ",'" + Item.HSourceBillNo + "','" + Item.HSourceBillType + "'," + Item.HRelationQty.ToString() + "," + Item.HRelationMoney.ToString() +
                          ") ");
                          $", '{Item.HStdMaintainResult.ToString()}') ");
                }
                //插入配件子表
                foreach (Models.ClsSb_EquipMaintainRuleBillSub oSub in DetailColl_Mater)
@@ -137,6 +137,13 @@
                omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                DataSet _ds = oCn.RunProcReturn("select HInterID from Sb_EquipMaintainRuleBillMain where HBillNo = N'" + omodel.HBillNo + "'", "Sb_EquipMaintainRuleBillMain");
                if(_ds.Tables[0].Rows.Count > 0) 
                {
                    sReturn = "单据号重复！";
                    oCn.RollBack();
                    return false;
                } 
                //主表
                oCn.RunProc("Insert Into Sb_EquipMaintainRuleBillMain   " +
                "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" +
@@ -157,13 +164,13 @@
                          ",HManagerID" +
                          ",HCloseMan,HCloseType,HRemark" +
                          ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                          ") values("
                          $", HStdMaintainResult) values("
                          + omodel.HInterID.ToString() + "," + Item.HEntryID.ToString() + "," + Item.HMaintainItemID.ToString() + ",'" + Item.HMaintainItem.ToString() + "'" +
                          ",'" + Item.HMaintainPart.ToString() + "','" + Item.HClaim.ToString() + "'" +
                          "," + Item.HManagerID.ToString() +
                          ",'" + Item.HCloseMan + "'," + Convert.ToString(Item.HCloseType ? 1 : 0) + ",'" + Item.HRemark + "'" +
                          "," + Item.HSourceInterID.ToString() + "," + Item.HSourceEntryID.ToString() + ",'" + Item.HSourceBillNo + "','" + Item.HSourceBillType + "'," + Item.HRelationQty.ToString() + "," + Item.HRelationMoney.ToString() +
                          ") ");
                          $", '{Item.HStdMaintainResult.ToString()}') ");
                }
                //插入配件子表
                foreach (Models.ClsSb_EquipMaintainRuleBillSub oSub in DetailColl_Mater)