MES-WEB-API.git

			@@ -9,11 +9,11 @@
			{
			public Model.ClsQC_LastPieceCheckBillMain omodel = new Model.ClsQC_LastPieceCheckBillMain();
			public List<Model.ClsQC_LastPieceCheckBillSub> DetailColl = new List<Model.ClsQC_LastPieceCheckBillSub>();
			//public List<Model.ClsQC_LastPieceCheckBillSub_Item> DetailColl1 = new List<Model.ClsQC_LastPieceCheckBillSub_Item>();
			public List<Model.ClsQC_LastPieceCheckBillSub_ValueGrid> DetailColl_Value = new List<Model.ClsQC_LastPieceCheckBillSub_ValueGrid>();
			public ClsQC_LastPieceCheckBill()
			{
			base.MvarItemKeySub = "QC_LastPieceCheckBillSub";
			base.MvarItemKeySub2 = "";
			base.MvarItemKeySub2 = "QC_LastPieceCheckBillSub_ValueGrid";
			base.MvarItemKeySub3 = "";
			base.MvarItemKeySub4 = "";
			base.MvarItemKey="QC_LastPieceCheckBillMain";
			@@ -29,7 +29,7 @@
			{
			DetailColl = null;
			}


			#endregion èªå®ä¹æ¹æ³
			//ä¿®æ¹åæ®
			public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
			@@ -60,34 +60,26 @@
			//",HCloseType="+omodel.HCloseType.ToString()+
			//",HDeleteMan='" + omodel.HDeleteMan + "'" +
			//",HDeleteDate='" + omodel.HDeleteDate + "'" +
			",HPrintQty="+omodel.HPrintQty.ToString()+
			",HPrintQty=" + omodel.HPrintQty.ToString() +
			//========================================
			//",HSupID=" + omodel.HSupID.ToString() +
			//",HEmpID=" + omodel.HEmpID.ToString() +
			",HSourceID=" + omodel.HSourceID.ToString() +
			",HQCSchemeID=" + omodel.HQCSchemeID.ToString() +
			",HICMOInterID=" + omodel.HICMOInterID.ToString() +
			",HICMOBillNo='" + omodel.HICMOBillNo + "'" +
			",HInStockQty=" + omodel.HInStockQty.ToString() +
			",HCheckQty=" + omodel.HCheckQty.ToString() +
			",HRightQty=" + omodel.HRightQty.ToString() +
			",HBadQty=" + omodel.HBadQty.ToString() +
			",HICMOQty=" + omodel.HICMOQty.ToString() +
			",HProcExchInterID=" + omodel.HProcExchInterID.ToString() +
			",HProcExchEntryID=" + omodel.HProcExchEntryID.ToString() +
			",HProcExchBillNo='" + omodel.HProcExchBillNo + "'" +
			",HProcExchQty=" + omodel.HProcExchQty.ToString() +
			",HProcID=" + omodel.HProcID.ToString() +
			",HMaterID=" + omodel.HMaterID.ToString() +
			",HFirstCheckEmp=" + omodel.HFirstCheckEmp.ToString() +
			",HCheckerResult='" + omodel.HCheckerResult + "'" +
			",HCheckDept=" + omodel.HCheckDept.ToString() +
			",HCheckDeptResult='" + omodel.HCheckDeptResult + "'" +
			",HCheckDept2=" + omodel.HCheckDept2.ToString() +
			",HCheckDeptResult2='" + omodel.HCheckDeptResult2 + "'" +
			",HBarCode='" + omodel.HBarCode + "'" +
			",HStoveBatchNo='" + omodel.HStoveBatchNo + "'" +
			",HCusID=" + omodel.HCusID.ToString() +
			",HSortBillNo='" + omodel.HSortBillNo + "'" +
			",HContrctBatchNo='" + omodel.HContrctBatchNo + "'" +
			",HProdAreaID=" + omodel.HProdAreaID.ToString() +
			",HProdTypeID=" + omodel.HProdTypeID.ToString() +
			",HRoutingInterID=" + omodel.HRoutingInterID.ToString() +
			",HDrawingDireID='" + omodel.HDrawingDireID + "'" +
			",HPackTypeID=" + omodel.HPackTypeID.ToString() +
			",HLastResult=" + DBUtility.ClsPub.BoolToString(omodel.HLastResult) +
			",HShiftsID=" + omodel.HShiftsID.ToString() +
			",HErrTreatment='" + omodel.HErrTreatment + "'" +
			",HBatchNo='" + omodel.HBatchNo + "'" +
			" where HInterID=" + lngBillKey.ToString());
			//å é¤å³è
			DeleteRelation(ref sReturn, lngBillKey);
			@@ -101,14 +93,14 @@
			" (HInterID,HBillNo_bak,HEntryID,HCloseMan" +
			",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" +
			",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HQCCheckClassID,HQCCheckItemID,HQCStd,HQCRelValue,HResult" +
			",HProcCheckEmp,HProcCheckTime" +
			",HQCCheckItemID,HQCStd,HUnit,HQCNote,HResult" +
			",HMax,HMin,HAvg,HInspectVal,HUpLimit,HDownLimit,HInspectInstruMentID" +
			") values("
			+ omodel.HInterID.ToString() + ",'" + oSub.HBillNo_bak + "'," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'" +
			",getdate()," + 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.HQCCheckClassID.ToString() + "," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HQCRelValue + "','" + oSub.HResult + "'" +
			"," + oSub.HProcCheckEmp.ToString() + ",'" + oSub.HProcCheckTime + "'" +
			"," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HUnit + "','" + oSub.HQCNote + "','" + oSub.HResult + "'" +
			",'" + oSub.HMax + "','" + oSub.HMin + "','" + oSub.HAvg + "','" + oSub.HInspectVal + "','" + oSub.HUpLimit + "','" + oSub.HDownLimit + "','" + oSub.HInspectInstruMentID + "'" +
			") ");
			}
			//foreach (Model.ClsQC_LastPieceCheckBillSub_Item oSub2 in DetailColl1)
			@@ -155,28 +147,24 @@
			try
			{
			//å¾å°mainid
			omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
			// omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
			//è¥MAINDIéå¤åéæ°è·å
			oCn.BeginTran();
			//ä¸»è¡¨
			oCn.RunProc("Insert Into QC_LastPieceCheckBillMain " +
			"(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
			",HYear,HPeriod,HRemark" +
			",HSourceID,HICMOInterID,HICMOBillNo,HInStockQty,HCheckQty,HRightQty" +
			",HBadQty,HMaterID,HFirstCheckEmp" +
			",HCheckerResult,HCheckDept,HCheckDeptResult,HCheckDept2,HCheckDeptResult2" +
			",HBarCode,HStoveBatchNo,HCusID,HSortBillNo,HContrctBatchNo" +
			",HProdAreaID,HProdTypeID" +
			",HRoutingInterID,HDrawingDireID,HPackTypeID" +
			",HSourceID,HICMOInterID,HICMOBillNo,HICMOQty,HProcExchInterID,HProcExchEntryID" +
			",HProcExchBillNo,HProcExchQty,HMaterID,HFirstCheckEmp,HLastResult" +
			",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HICMOEntryID,HQCSchemeID,HShiftsID,HErrTreatment,HBatchNo" +
			",HTakeSampleCheckBillID,HTakeSampleCheckBillNo,HProcID" +
			") " +
			" values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
			" values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",'" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" +
			"," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" +
			"," + omodel.HSourceID.ToString() + "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HInStockQty.ToString() + "," + omodel.HCheckQty.ToString() + "," + omodel.HRightQty.ToString() +
			"," + omodel.HBadQty.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HFirstCheckEmp.ToString() +
			",'"+omodel.HCheckerResult+"',"+omodel .HCheckDept.ToString()+",'"+omodel.HCheckDeptResult+"',"+omodel .HCheckDept2.ToString()+",'"+omodel.HCheckDeptResult2+"'"+
			",'" + omodel.HBarCode + "','" + omodel.HStoveBatchNo + "'," + omodel.HCusID.ToString() + ",'" + omodel.HSortBillNo + "','" + omodel.HContrctBatchNo + "'" +
			"," + omodel.HProdAreaID.ToString() + "," + omodel.HProdTypeID.ToString() +
			"," + omodel.HRoutingInterID.ToString() + ",'" + omodel.HDrawingDireID + "'," + omodel.HPackTypeID.ToString() +
			"," + omodel.HSourceID.ToString() + "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HICMOQty.ToString() + "," + omodel.HProcExchInterID.ToString() + "," + omodel.HProcExchEntryID.ToString() +
			",'" + omodel.HProcExchBillNo + "'," + omodel.HProcExchQty.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HFirstCheckEmp.ToString() + ", " + DBUtility.ClsPub.BoolToString(omodel.HLastResult) +
			"," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'," + omodel.HICMOEntryID + "," + omodel.HQCSchemeID + "," + omodel.HShiftsID + ",'" + omodel.HErrTreatment + "','" + omodel.HBatchNo + "'" +
			"," + omodel.HTakeSampleCheckBillID + ",'" + omodel.HTakeSampleCheckBillNo + "','" + omodel.HProcID + "'" +
			") ");
			//æå¥åè¡¨
			foreach (Model.ClsQC_LastPieceCheckBillSub oSub in DetailColl)
			@@ -185,15 +173,19 @@
			" (HInterID,HBillNo_bak,HEntryID,HCloseMan" +
			",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" +
			",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
			",HQCCheckClassID,HQCCheckItemID,HQCStd,HQCRelValue,HResult" +
			",HProcCheckEmp,HProcCheckTime" +
			",HQCCheckItemID,HQCStd,HUnit,HQCNote,HResult" +
			",HMax,HMin,HAvg,HSampleSchemeID,HSampleQty,HSampleDamageQty,HAcceptQty" +
			",HRejectQty,HSampleUnRightQty,HStatus,HUnitID,HInspectVal,HTargetVal" +
			",HUpLimit,HDownLimit,HUpOffSet,HDownOffSet,HKeyInspect,HAnalysisMethod,HInspectInstruMentID,HInspectResult" +
			") values("
			+ omodel.HInterID.ToString() + ",'" + oSub.HBillNo_bak + "'," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "'" +
			",getdate()," + 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.HQCCheckClassID.ToString() + "," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HQCRelValue + "','" + oSub.HResult + "'" +
			"," + oSub.HProcCheckEmp.ToString() + ",'" + oSub.HProcCheckTime + "'" +
			") ");
			"," + oSub.HQCCheckItemID.ToString() + ",'" + oSub.HQCStd + "','" + oSub.HUnit + "','" + oSub.HQCNote + "','" + oSub.HResult + "'" +
			",'" + oSub.HMax + "','" + oSub.HMin + "','" + oSub.HAvg + "'" + "," + oSub.HSampleSchemeID + "," + oSub.HSampleQty +
			"," + oSub.HSampleDamageQty + "," + oSub.HAcceptQty + "," + oSub.HRejectQty + "," + oSub.HSampleUnRightQty + ",'" + oSub.HStatus +
			"'," + oSub.HUnitID + ",'" + oSub.HInspectVal + "','" + oSub.HTargetVal + "','" + oSub.HUpLimit + "','" + oSub.HDownLimit +
			"','" + oSub.HUpOffSet + "','" + oSub.HDownOffSet + "'," + oSub.HKeyInspect + ",'" + oSub.HAnalysisMethod + "'," + oSub.HInspectInstruMentID + ",'" + oSub.HInspectResult + "'" + ") ");
			}
			//foreach (Model.ClsQC_LastPieceCheckBillSub_Item oSub2 in DetailColl1)
			//{
			@@ -240,17 +232,17 @@
			try
			{
			//æ¥è¯¢ä¸»è¡¨
			DataSet Ds ;
			DataSet Ds;
			Ds = oCn.RunProcReturn("Select * from QC_LastPieceCheckBillMain Where HInterID=" + lngBillKey.ToString(), "QC_LastPieceCheckBillMain");
			if(Ds.Tables[0].Rows.Count==0)
			if (Ds.Tables[0].Rows.Count == 0)
			{
			sReturn = "åæ®æªæ¾å°ï¼";
			return false;
			}
			//åºå®èµå¼===========================================
			omodel.HInterID =DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]);
			omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]);
			omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim();
			omodel.HDate =DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]);
			omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]);
			omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"]);
			omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"]);
			omodel.HCheckItemNowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNowID"]);
			@@ -282,32 +274,17 @@
			omodel.HSourceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSourceID"]);
			omodel.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOInterID"]);
			omodel.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HICMOBillNo"]);
			omodel.HInStockQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInStockQty"]); ;
			omodel.HCheckQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckQty"]);
			omodel.HRightQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HRightQty"]);
			omodel.HBadQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBadQty"]);
			omodel.HICMOQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HICMOQty"]); ;
			omodel.HProcExchInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcExchInterID"]);
			omodel.HProcExchEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcExchEntryID"]);
			omodel.HProcExchBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProcExchBillNo"]);
			omodel.HProcExchQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProcExchQty"]);
			omodel.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMaterID"]);
			omodel.HFirstCheckEmp = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HFirstCheckEmp"]);
			omodel.HCheckerResult = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCheckerResult"]);
			omodel.HCheckDept = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckDept"]);
			omodel.HCheckDeptResult = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCheckDeptResult"]);
			omodel.HCheckDept2 = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckDept2"]);
			omodel.HCheckDeptResult2 = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCheckDeptResult2"]);
			omodel.HBarCode = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBarCode"]);
			omodel.HStoveBatchNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HStoveBatchNo"]);
			omodel.HCusID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCusID"]);
			omodel.HSortBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSortBillNo"]);
			omodel.HContrctBatchNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HContrctBatchNo"]);
			omodel.HProdAreaID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProdAreaID"]);
			omodel.HProdTypeID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HProdTypeID"]);
			omodel.HRoutingInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HRoutingInterID"]);
			omodel.HDrawingDireID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HDrawingDireID"]);
			omodel.HPackTypeID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPackTypeID"]);
			//omodel.HRedBlueFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HRedBlueFlag"]);
			//

			omodel.HLastResult = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HLastResult"]);

			//å¾ªç¯
			DataSet DsSub ;
			DataSet DsSub;
			DsSub = oCn.RunProcReturn("Select * from QC_LastPieceCheckBillSub Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", "QC_LastPieceCheckBillSub");
			DetailColl.Clear();//æ¸ç©º
			for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
			@@ -328,13 +305,14 @@
			oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty"]);
			oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationMoney"]);
			//===================================================
			oSub.HQCCheckClassID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HQCCheckClassID"]);
			oSub.HQCCheckItemID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HQCCheckItemID"]);
			oSub.HQCStd = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HQCStd"]);
			oSub.HQCRelValue = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HQCRelValue"]);
			oSub.HUnit = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HUnit"]);
			oSub.HQCNote = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HQCNote"]);
			oSub.HResult = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HResult"]);
			oSub.HProcCheckEmp = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HProcCheckEmp"]);
			oSub.HProcCheckTime = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HProcCheckTime"]);
			oSub.HMax = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMax"]);
			oSub.HMin = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMin"]);
			oSub.HAvg = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HAvg"]);
			//oSub.HDotCheckItemID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HDotCheckItemID"]);
			//oSub.HDotCheckItem = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HDotCheckItem"]);
			//oSub.HDotCheckPart = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HDotCheckPart"]);
			@@ -368,7 +346,7 @@
			//oSub.HSeOrderInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderInterID"]);
			//oSub.HSeOrderEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderEntryID"]);
			//oSub.HSeOrderBillNo = DsSub.Tables[0].Rows[i]["HSeOrderBillNo"].ToString().Trim();


			DetailColl.Add(oSub);
			}
			//DataSet DsSub2;
			@@ -437,6 +415,38 @@
			}
			}

			//æ°å¢æ£éªå¼
			public virtual bool AddValue(ref string sReturn, ref long HInterID, ref long HEntryID)
			{
			try
			{
			oCn.BeginTran();

			oCn.RunProc("delete from QC_LastPieceCheckBillSub_ValueGrid where HInterID = " + HInterID + " and HEntryID = " + HEntryID);

			//æå¥åè¡¨
			foreach (Model.ClsQC_LastPieceCheckBillSub_ValueGrid value in DetailColl_Value)
			{
			oCn.RunProc("Insert into QC_LastPieceCheckBillSub_ValueGrid " +
			" (HInterID,HEntryID,HSEQ,HInSpectResult" +
			",HInSpectValue,HInSpectValueB,HInSpectValueT" +
			") values("
			+ HInterID + "," + HEntryID + "," + value.HSEQ + ",'" + value.HInSpectResult + "'," +
			value.HInSpectValue + "," + value.HInSpectValueB + ",'" + value.HInSpectValueT + "'" +
			") ");
			}
			sReturn = "æ°å¢æ£éªå¼æåï¼";
			oCn.Commit();
			return true;
			}
			catch (Exception e)
			{
			sReturn = e.Message;
			oCn.RollBack();
			throw (e);
			}
			}

			//å®¡æ ¸
			public bool CheckBill(Int64 lngBillKey, ref string sReturn)
			{
			@@ -465,6 +475,6 @@





			}
			}