MES-WEB-API.git

			@@ -79,7 +79,8 @@

			oCn.BeginTran();
			string mainSql = "UpDate Xs_SeOrderBillMain set " +
			" HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼===============
			" HBillSubType='" + omodel.HBillSubType + "'" +
			",HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼===============
			",HDate='" + omodel.HDate + "'" +
			",HYear='" + omodel.HYear.ToString() + "'" +
			",HPeriod='" + omodel.HPeriod.ToString() + "'" +
			@@ -129,7 +130,7 @@
			// ") ");

			string subSql = "Insert into Xs_SeOrderBillSub" +
			"(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" +
			"(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationQty_SellOutCheck,HRelationMoney_SellOutCheck,HRelationQty_ICMO,HRelationQty_SellBack,HRelationQty_SellBackCheck,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" +
			",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID" +
			",HCusMaterNumber,HCusModel,HCusMaterName,HisStockGoods) " +
			"values(" +
			@@ -140,6 +141,11 @@
			",'" + (oSub.HSourceBillNo == null ? "" : oSub.HSourceBillNo) +
			"','" + (oSub.HSourceBillType == null ? "" : oSub.HSourceBillType) +
			"'," + oSub.HRelationQty +
			"," + oSub.HRelationQty_SellOutCheck +
			"," + oSub.HRelationMoney_SellOutCheck +
			"," + oSub.HRelationQty_ICMO +
			"," + oSub.HRelationQty_SellBack +
			"," + oSub.HRelationQty_SellBackCheck +
			"," + oSub.HRelationMoney +
			"," + oSub.HMaterID +
			"," + oSub.HUnitID +
			@@ -277,7 +283,7 @@
			"" + omodel.HYear +
			"," + omodel.HPeriod +
			",'" + this.BillType +
			"','" + this.HBillSubType +
			"','" + omodel.HBillSubType +
			"'," + omodel.HBillStatus +
			",'" + omodel.HExplanation +

			@@ -336,7 +342,7 @@
			// "," + oSub.HTaxPrice.ToString() + "," + oSub.HDiscountRate.ToString() + "," + oSub.HRelTaxPrice.ToString() + "," + oSub.HOutStockQty.ToString() + "," + oSub.HInvoiceQty.ToString() +
			// ") ");
			string subSql = "Insert into Xs_SeOrderBillSub" +
			"(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" +
			"(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationQty_SellOutCheck,HRelationMoney_SellOutCheck,HRelationQty_ICMO,HRelationQty_SellBack,HRelationQty_SellBackCheck,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" +
			",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID" +
			",HCusMaterNumber,HCusModel,HCusMaterName,HisStockGoods) " +
			"values(" +
			@@ -347,6 +353,11 @@
			",'" + (oSub.HSourceBillNo==null?"":oSub.HSourceBillNo) +
			"','" + (oSub.HSourceBillType==null?"":oSub.HSourceBillType) +
			"'," + oSub.HRelationQty +
			"," + oSub.HRelationQty_SellOutCheck +
			"," + oSub.HRelationMoney_SellOutCheck +
			"," + oSub.HRelationQty_ICMO +
			"," + oSub.HRelationQty_SellBack +
			"," + oSub.HRelationQty_SellBackCheck +
			"," + oSub.HRelationMoney +
			"," + oSub.HMaterID +
			"," + oSub.HUnitID +
			@@ -497,6 +508,12 @@
			oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEntryCloseDate"]);
			oSub.HRemark = DsSub.Tables[0].Rows[i]["HRemark"].ToString().Trim();
			//===================================================
			oSub.HRelationQty_SellOutCheck = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty_SellOutCheck"]);
			oSub.HRelationMoney_SellOutCheck = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationMoney_SellOutCheck"]);
			oSub.HRelationQty_ICMO = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty_ICMO"]);
			oSub.HRelationQty_SellBack = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty_SellBack"]);
			oSub.HRelationQty_SellBackCheck = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty_SellBackCheck"]);
			//===================================================
			oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]);
			oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUnitID"]);
			oSub.HQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HQty"]);