MES-WEB-API.git

			@@ -92,11 +92,8 @@
			",HMainSourceInterID='" + omodel.HMainSourceInterID.ToString() + "'" +
			",HMainSourceEntryID='" + omodel.HMainSourceEntryID.ToString() + "'" +

			",HCusID='" + omodel.HCusID.ToString() + "'" +
			",HBeginAddr='" + omodel.HBeginAddr.ToString() + "'" +
			",HEndAddr='" + omodel.HEndAddr.ToString() + "'" +
			",HPickAddr='" + omodel.HPickAddr.ToString() + "'" +
			",HArriverAddr='" + omodel.HArriverAddr.ToString() + "'" +
			",HTransType='" + omodel.HTransType.ToString() + "'" +
			",HCarTypeID='" + omodel.HCarTypeID.ToString() + "'" +
			",HCarTypeMaxVolume='" + omodel.HCarTypeMaxVolume.ToString() + "'" +
			@@ -145,7 +142,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,HScatteredVolume,HMouldQty) values("
			",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQtym,,HCusID,HPickAddr,HArriverAddr) values("
			+ SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int
			+ SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50)
			+ (oSub.HEntryID) + ",'" // HEntryID int
			@@ -170,7 +167,10 @@
			+ (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)
			+ (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + ","
			+ (oSub.HCusID) + "," // HSNP dec(18,8)
			+ "'" + SafeString(oSub.HPickAddr?.ToString(), "") + "',"
			+ "'" + SafeString(oSub.HArriverAddr?.ToString(), "") + "')"; // HMouldQty dec(18,8)
			oCn.RunProc(sql);
			}

			@@ -236,7 +236,7 @@
			string sql = "Insert Into WL_YayBillMain " +
			"(HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus," +
			"HRemark,HMaker,HMakeDate,HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo," +
			"HOrgID,HCusID,HBeginAddr,HEndAddr,HPickAddr,HArriverAddr,HTransType,HCarTypeID,HCarTypeMaxVolume,HTotalVolume," +
			"HOrgID,HBeginAddr,HEndAddr,HTransType,HCarTypeID,HCarTypeMaxVolume,HTotalVolume," +
			"HLoadingRate,HContractTransportInterID,HContractTransportEntryID," +
			"HContractTransportBillNo,HCarrierID,HDistance,HTransportTimes," +
			"HTransportTyep,HSSID,HCurID,HMoney,HDateForRequestedPick," +
			@@ -258,11 +258,8 @@
			",'" + omodel.HMainSourceEntryID + "'" +
			",'" + omodel.HMainSourceBillNo + "'" +
			",'" + omodel.HOrgID + "'" +
			",'" + omodel.HCusID + "'" +
			",'" + omodel.HBeginAddr + "'" +
			",'" + omodel.HEndAddr + "'" +
			",'" + omodel.HPickAddr + "'" +
			",'" + omodel.HArriverAddr + "'" +
			",'" + omodel.HTransType + "'" +
			",'" + omodel.HCarTypeID + "'" +
			",'" + omodel.HCarTypeMaxVolume + "'" +
			@@ -292,7 +289,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,HScatteredVolume,HMouldQty) values("
			",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQty,HCusID,HPickAddr,HArriverAddr) values("
			+ SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int
			+ SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50)
			+ (oSub.HEntryID) + ",'" // HEntryID int
			@@ -317,7 +314,10 @@
			+ (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)
			+ (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + ","
			+ (oSub.HCusID) + "," // HSNP dec(18,8)
			+ "'" + SafeString(oSub.HPickAddr?.ToString(), "") + "',"
			+ "'" + SafeString(oSub.HArriverAddr?.ToString(), "") + "')"; // HMouldQty dec(18,8)
			oCn.RunProc(sql);
			}
			//=========================保存后控制