From 9579db7cd380d246ba9f89f7a53ea431b18b915c Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期四, 09 五月 2024 17:08:42 +0800 Subject: [PATCH] 网页版 和 PDA版 设备点检表和器具点检表 增加 字段,新增器具点检PDA模块 --- WebAPI/DLL/ClsSb_EquipDotCheckBill.cs | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/WebAPI/DLL/ClsSb_EquipDotCheckBill.cs b/WebAPI/DLL/ClsSb_EquipDotCheckBill.cs index a6b7346..87f7edc 100644 --- a/WebAPI/DLL/ClsSb_EquipDotCheckBill.cs +++ b/WebAPI/DLL/ClsSb_EquipDotCheckBill.cs @@ -115,11 +115,12 @@ ",HYear,HPeriod,HRemark,HEquipID" + ",HBeginDate,HEndDate,HPlanNo,HExplanation,HInnerBillNo" + ",HDeptID,HQty,HEquipDotCheckRuleInterID" + + ",HLastResult,HErrNote,HBigSafeNote,HShiftsID,HDotCheckNote" + ") " + " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'," + omodel.HEquipID.ToString() + ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "','" + omodel.HPlanNo + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'" + - ",'" + omodel.HDeptID + "'," + omodel.HQty + "," + omodel.HEquipDotCheckRuleInterID + + ",'" + omodel.HDeptID + "'," + omodel.HQty + "," + omodel.HEquipDotCheckRuleInterID + ",'" + omodel.HLastResult + "','" + omodel.HErrNote + "','" + omodel.HBigSafeNote + "'," + omodel.HShiftsID + ",'" + omodel.HDotCheckNote + "'" + ") "); //鎻掑叆瀛愯〃 foreach (Models.ClsSb_EquipDotCheckBillSub oSub in DetailColl) @@ -130,12 +131,13 @@ "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + "HDotCheckItem,HDotCheckPart,HClaim," + "HManagerID,HManagerNumber,HDotCheckResult,HDotCheckItemID " + + ",HDotCheckItemClassID,HDotCheckItemMethodID" + ") values(" + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + ",'" + oSub.HDotCheckItem + "','" + oSub.HDotCheckPart + "','" + oSub.HClaim + - "'," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "','" + oSub.HDotCheckResult + "'," + oSub.HDotCheckItemID + + "'," + oSub.HManagerID.ToString() + ",'" + oSub.HManagerNumber + "','" + oSub.HDotCheckResult + "'," + oSub.HDotCheckItemID + "," + oSub.HDotCheckItemClassID + "," + oSub.HDotCheckItemMethodID + ") "); } //鏇存柊鐐规璁″垝瀛愯〃鍏宠仈鏍囪 -- Gitblit v1.9.1