| | |
| | | ",HDownLimitKey,HUpOffSetKey,HDownOffSetKey,HTargetValQ,HUpLimitQ,HDownLimitQ" + |
| | | ",HUpOffSetQ,HDownOffSetQ,HTargetValB,HUpLimitB,HDownLimitB,HUpOffSetB" + |
| | | ",HDownOffSetB,HTargetValTxt,HUpLimitTxt,HDownLimitTxt,HUpOffSetTxt,HDownOffSetTxt" + |
| | | ",HControlUpperLimit,HControlLowerLimit" + |
| | | ",HControlUpperLimit,HControlLowerLimit,HSampleCount,HSampleDayCount" + |
| | | ") 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.HUpOffSetQ + "," + oSub.HDownOffSetQ + "," + oSub.HTargetValB + "," + oSub.HUpLimitB + "," + oSub.HDownLimitB + |
| | | "," + oSub.HUpOffSetB + "," + oSub.HDownOffSetB + ",'" + oSub.HTargetValTxt + "','" + oSub.HUpLimitTxt + "','" + oSub.HDownLimitTxt |
| | | + "','" + oSub.HUpOffSetTxt + "','" + oSub.HDownOffSetTxt + "'" + |
| | | ","+ oSub.HControlUpperLimit + ","+ oSub.HControlLowerLimit + |
| | | ","+ oSub.HControlUpperLimit + ","+ oSub.HControlLowerLimit + "," + oSub.HSampleCount + "," + oSub.HSampleDayCount + |
| | | ") "); |
| | | } |
| | | //=========================ä¿ååæ§å¶ |
| | |
| | | ",HDownLimitKey,HUpOffSetKey,HDownOffSetKey,HTargetValQ,HUpLimitQ,HDownLimitQ" + |
| | | ",HUpOffSetQ,HDownOffSetQ,HTargetValB,HUpLimitB,HDownLimitB,HUpOffSetB" + |
| | | ",HDownOffSetB,HTargetValTxt,HUpLimitTxt,HDownLimitTxt,HUpOffSetTxt,HDownOffSetTxt" + |
| | | ",HControlUpperLimit,HControlLowerLimit" + |
| | | ",HControlUpperLimit,HControlLowerLimit,HSampleCount,HSampleDayCount" + |
| | | ") 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.HUpOffSetQ + "," + oSub.HDownOffSetQ + "," + oSub.HTargetValB + "," + oSub.HUpLimitB + "," + oSub.HDownLimitB + |
| | | "," + oSub.HUpOffSetB + "," + oSub.HDownOffSetB + ",'" + oSub.HTargetValTxt + "','" + oSub.HUpLimitTxt + "','" + oSub.HDownLimitTxt |
| | | + "','" + oSub.HUpOffSetTxt + "','" + oSub.HDownOffSetTxt + "'" + |
| | | ","+ oSub.HControlUpperLimit + "," +oSub.HControlLowerLimit + |
| | | ","+ oSub.HControlUpperLimit + "," +oSub.HControlLowerLimit + "," + oSub.HSampleCount + "," + oSub.HSampleDayCount + |
| | | ") "); |
| | | } |
| | | //=========================ä¿ååæ§å¶ |
| | |
| | | public Decimal HDownOffSetQ; |
| | | public Decimal HControlUpperLimit; |
| | | public Decimal HControlLowerLimit; |
| | | public Int64 HSampleCount; |
| | | public Int64 HSampleDayCount; |
| | | public Int64 HTargetValB; |
| | | public Int64 HUpLimitB; |
| | | public Int64 HDownLimitB; |