| | |
| | | { |
| | | public Model.ClsQC_ProcessCheckBillMain omodel = new Model.ClsQC_ProcessCheckBillMain(); |
| | | public List<Model.ClsQC_ProcessCheckBillSub> DetailColl = new List<Model.ClsQC_ProcessCheckBillSub>(); |
| | | |
| | | public List<Model.ClsQC_ProcessCheckBillSub_ValueGrid> DetailColl_Value = new List<Model.ClsQC_ProcessCheckBillSub_ValueGrid>(); |
| | | public ClsQC_ProcessCheckBill() |
| | | { |
| | | base.MvarItemKeySub = "QC_ProcessCheckBillSub"; |
| | | base.MvarItemKeySub2 = ""; |
| | | base.MvarItemKeySub2 = "QC_ProcessCheckBillSub_ValueGrid"; |
| | | base.MvarItemKeySub3 = ""; |
| | | base.MvarItemKeySub4 = ""; |
| | | base.MvarItemKey="QC_ProcessCheckBillMain"; |
| | |
| | | ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" + |
| | | ",HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HQCCheckClassID,HQCCheckItemID,HQCStd,HQCRelValue,HResult" + |
| | | ",HProcCheckEmp,HProcCheckTime" + |
| | | ",HProcCheckEmp,HProcCheckTime, HSampleSchemeID,HSampleQty,HSampleDamageQty,HAcceptQty" + |
| | | ",HRejectQty,HSampleUnRightQty,HStatus,HUnitID,HInspectVal,HTargetVal" + |
| | | ",HUpLimit,HDownLimit,HUpOffSet,HDownOffSet,HKeyInspect,HAnalysisMethod" + |
| | | ") 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.HProcCheckEmp.ToString() + ",'" + oSub.HProcCheckTime + "'," + 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 + "'" + |
| | | ") "); |
| | | } |
| | | |
| | |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | //æ°å¢æ£éªå¼ |
| | | public virtual bool AddValue(ref string sReturn, ref long HInterID, ref long HEntryID) |
| | | { |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | |
| | | oCn.RunProc("delete from QC_ProcessCheckBillSub_ValueGrid where HInterID = " + HInterID + " and HEntryID = " + HEntryID); |
| | | |
| | | //æå
¥å表 |
| | | foreach (Model.ClsQC_ProcessCheckBillSub_ValueGrid value in DetailColl_Value) |
| | | { |
| | | oCn.RunProc("Insert into QC_ProcessCheckBillSub_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 override bool ShowBill(Int64 lngBillKey, ref string sReturn) |
| | | { |