~yxj/MES-WEB-API.git

			@@ -9,6 +9,7 @@
			{
			public Model.ClsSb_MouldRepairWorkBillMain omodel = new Model.ClsSb_MouldRepairWorkBillMain();
			public List<Model.ClsSb_MouldRepairWorkBillSub> DetailColl = new List<Model.ClsSb_MouldRepairWorkBillSub>();
			public List<Model.ClsSb_MouldRepairWorkBillSub_Item> DetailCol = new List<Model.ClsSb_MouldRepairWorkBillSub_Item>();

			public ClsSb_MouldRepairWorkBill()
			{
			@@ -17,7 +18,7 @@
			base.MvarItemKeySub3 = "";
			base.MvarItemKeySub4 = "";
			base.MvarItemKey="Sc_MouldRepairWorkBillMain";
			base.MvarReportTitle = "妯″叿缁翠慨宸ュ崟";
			base.MvarReportTitle = "妯″叿缁翠慨璁板綍宸ュ崟";
			base.BillType = "3807";
			base.HBillSubType = "3807";

			@@ -72,6 +73,7 @@
			" where HInterID=" + lngBillKey.ToString());
			//鍒犻櫎鍏宠仈
			DeleteRelation(ref sReturn, lngBillKey);
			oCn.RunProc("delete from Sc_MouldRepairWorkBillSub_Item where HInterID=" + lngBillKey);
			//鍒犻櫎瀛愯〃
			DeleteBillSub(lngBillKey);
			//鎻掑叆瀛愯〃
			@@ -86,6 +88,21 @@
			+ omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + 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.HRepairID.ToString() + ",'" + oSub.HRepairExplanation + "'," + oSub.HManagerID.ToString() + "," + oSub.HMoney.ToString() +
			") ");
			}
			//鎻掑叆瀛愯〃閰嶄欢淇℃伅
			foreach (Model.ClsSb_MouldRepairWorkBillSub_Item oSub in DetailCol)
			{
			oCn.RunProc("Insert into Sc_MouldRepairWorkBillSub_Item " +
			" (HInterID,HEntryID,HMaterID" +
			",HQty,HUnitID,HQtyMust" +
			",HCloseMan,HCloseType,HRemark" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			") values("
			+ omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaterID.ToString() +
			"," + oSub.HQty.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() +
			",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
			"," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
			") ");
			}
			//
			@@ -149,6 +166,21 @@
			"," + oSub.HRepairID.ToString() + ",'" + oSub.HRepairExplanation + "'," + oSub.HManagerID.ToString() + "," + oSub.HMoney.ToString() +
			") ");
			}
			//鎻掑叆瀛愯〃閰嶄欢淇℃伅
			foreach (Model.ClsSb_MouldRepairWorkBillSub_Item oSub in DetailCol)
			{
			oCn.RunProc("Insert into Sc_MouldRepairWorkBillSub_Item " +
			" (HInterID,HEntryID,HMaterID" +
			",HQty,HUnitID,HQtyMust" +
			",HCloseMan,HCloseType,HRemark" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			") values("
			+ omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaterID.ToString() +
			"," + oSub.HQty.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() +
			",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
			"," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
			") ");
			}
			//
			//foreach (Model.ClsSb_MouldRepairWorkBillSub oSub in DetailColl)
			//{