MES-WEB-API.git

			@@ -126,6 +126,7 @@
			",HSurer_Trans='" + omodel.HSurer_Trans.ToString() + "'" +
			",HDate_Trans='" + omodel.HDate_Trans.ToString() + "'" +
			",HSurer_Receive='" + omodel.HSurer_Receive.ToString() + "'" +
			",HExRate='" + omodel.HExRate.ToString() + "'" +
			",HDate_Receive='" + omodel.HDate_Receive.ToString() + "'" +
			",HSurer_Accounting='" + omodel.HSurer_Accounting.ToString() + "'" +
			",HDate_Accounting='" + omodel.HDate_Accounting.ToString() + "'" +
			@@ -144,7 +145,7 @@
			"(HInterID,HBillNo_bak,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HMaterID,HUnitID,HMouldID,HMouldLength,HMouldHeight,HMouldWidth" +
			",HMouldFoldHeight,HVolume,HQty,HSNP,HMouldQty) values("
			",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQty) values("
			+ SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int
			+ SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50)
			+ (oSub.HEntryID) + ",'" // HEntryID int
			@@ -168,6 +169,7 @@
			+ (oSub.HVolume.ToString() == "" ? 0 : oSub.HVolume) + "," // HVolume dec(18,8)
			+ (oSub.HQty.ToString() == "" ? 0 : oSub.HQty) + "," // HQty dec(18,8)
			+ (oSub.HSNP.ToString() == "" ? 0 : oSub.HSNP) + "," // HSNP dec(18,8)
			+ (oSub.HScatteredVolume) + "," // HSNP dec(18,8)
			+ (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + ")"; // HMouldQty dec(18,8)
			oCn.RunProc(sql);
			}
			@@ -245,7 +247,7 @@
			"HTransportTyep,HSSID,HCurID,HMoney,HDateForRequestedPick," +
			"HDataForRequestedArrived,HCarryStatus,HDate_CarrierSure," +
			"HDate_AllocationDriver,HCarID,HDriverID,HSurer_Arrive,HDate_Arrive," +
			"HSurer_Pick,HDate_Pick,HSurer_Trans,HDate_Trans,HSurer_Receive," +
			"HSurer_Pick,HDate_Pick,HSurer_Trans,HDate_Trans,HSurer_Receive,HExRate," +
			"HDate_Receive,HSurer_Accounting,HDate_Accounting) " +
			"values(" +
			SafeInt(omodel.HInterID.ToString(), 0) + "," + // HInterID
			@@ -312,6 +314,7 @@
			"'" + SafeString(omodel.HSurer_Trans) + "'," +
			SafeDateTime(omodel.HDate_Trans?.ToString(), "'" + currentDateTime + "'") + "," +
			"'" + SafeString(omodel.HSurer_Receive) + "'," +
			"'" + omodel.HExRate + "'," +
			SafeDateTime(omodel.HDate_Receive?.ToString(), "'" + currentDateTime + "'") + "," +
			"'" + SafeString(omodel.HSurer_Accounting) + "'," +
			SafeDateTime(omodel.HDate_Accounting?.ToString(), "'" + currentDateTime + "'") + ")";
			@@ -326,7 +329,7 @@
			"(HInterID,HBillNo_bak,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
			",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HMaterID,HUnitID,HMouldID,HMouldLength,HMouldHeight,HMouldWidth" +
			",HMouldFoldHeight,HVolume,HQty,HSNP,HMouldQty) values("
			",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQty) values("
			+ SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int
			+ SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50)
			+ (oSub.HEntryID) + ",'" // HEntryID int
			@@ -350,6 +353,7 @@
			+ (oSub.HVolume.ToString() == "" ? 0 : oSub.HVolume) + "," // HVolume dec(18,8)
			+ (oSub.HQty.ToString() == "" ? 0 : oSub.HQty) + "," // HQty dec(18,8)
			+ (oSub.HSNP.ToString() == "" ? 0 : oSub.HSNP) + "," // HSNP dec(18,8)
			+ (oSub.HScatteredVolume) + "," // HSNP dec(18,8)
			+ (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + ")"; // HMouldQty dec(18,8)
			oCn.RunProc(sql);
			}