private int GetElectricCount() { int seq; try { seq = int.Parse(this.txtSeq.Value); } catch { seq = -1; } if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } OQCFuncTestValue obj = (OQCFuncTestValue)this._facade.GetOQCFuncTestValue(this.txtSN.Value, seq, this.txtLotNo.Value, this.txtLotSeq.Value); if (obj != null) { electriccount = Convert.ToInt32(obj.ElectricTestCount); } else { electriccount = 0; } return(electriccount); }
protected override object[] LoadDataSource(int inclusive, int exclusive) { int seq; try { seq = int.Parse(this.txtSeq.Value); } catch { seq = -1; } if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } this.EleDetails = this._facade.QueryOQCFuncTestValueEleDetail(this.txtSN.Value, seq, this.txtLotNo.Value, this.txtLotSeq.Value); return(this._facade.QueryOQCFuncTestValueDetail( this.txtSN.Value, seq, this.txtLotNo.Value, this.txtLotSeq.Value, inclusive, exclusive)); }
protected object[] LoadDataSourceSN(int inclusive, int exclusive) { int seq; try { seq = int.Parse(this.txtSeq.Value); } catch { seq = -1; } if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } object[] objs = this._facade.QueryOQCDimentionValue( this.txtSN.Value, seq, this.txtLotNo.Value, this.txtLotSeq.Value); this.DimentionValues = objs; return(objs); }
private int GetRowCountFT() { int seq; try { seq = int.Parse(this.txtSeq.Value); } catch { seq = -1; } if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } int OQCBeginDate = FormatHelper.TODateInt(this.txtOQCBeginDate.Text); int OQCEndDate = FormatHelper.TODateInt(this.txtOQCEndDate.Text); int OQCBeginTime = FormatHelper.TOTimeInt(this.txtOQCBeginTime.Text); int OQCEndTime = FormatHelper.TOTimeInt(this.txtOQCEndTime.Text); return(this._facade.QueryOQCFuncTestValueCount( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), FormatHelper.CleanString(this.txtStartSnQuery.Text), FormatHelper.CleanString(this.txtEndSnQuery.Text), FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime )); }
private void GetRcardByCarton() { if (rcardListInCarton == null) { if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } rcardListInCarton = _facade.GetRCardListInCarton( this.txtCartonNoQuery.Text.Trim().ToUpper(), this.txtStartSnQuery.Text.Trim().ToUpper(), this.txtEndSnQuery.Text.Trim().ToUpper()); } }
protected int GetRowCountSN() { int seq; try { seq = int.Parse(this.txtSeq.Value); } catch { seq = -1; } if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } return(this._facade.QueryOQCDimentionCount( this.txtSN.Value, seq, this.txtLotNo.Value, this.txtLotSeq.Value )); }
private int GetElectricCount() { int OQCBeginDate = FormatHelper.TODateInt(this.txtOQCBeginDate.Text); int OQCEndDate = FormatHelper.TODateInt(this.txtOQCEndDate.Text); int OQCBeginTime = FormatHelper.TOTimeInt(this.txtOQCBeginTime.Text); int OQCEndTime = FormatHelper.TOTimeInt(this.txtOQCEndTime.Text); if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } return(this._facade.QueryMaxOQCFuncTestValueDetailElectricCount( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), FormatHelper.CleanString(this.txtStartSnQuery.Text), FormatHelper.CleanString(this.txtEndSnQuery.Text), FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime )); }
private void LoadDataSourceFT(object sender, EventArgs e) //private object[] LoadDataSourceFT(int inclusive, int exclusive) { // Added by Icyer 2006/08/16 if (this.txtConditionItem.Text.Trim() == string.Empty) { throw new Exception("$Error_ItemCode_NotCompare"); } // Added end int seq; try { seq = int.Parse(this.txtSeq.Value); } catch { seq = -1; } if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } int OQCBeginDate = FormatHelper.TODateInt(this.txtOQCBeginDate.Text); int OQCEndDate = FormatHelper.TODateInt(this.txtOQCEndDate.Text); int OQCBeginTime = FormatHelper.TOTimeInt(this.txtOQCBeginTime.Text); int OQCEndTime = FormatHelper.TOTimeInt(this.txtOQCEndTime.Text); GetRcardByCarton(); string rcardStart = this.txtStartSnQuery.Text.Trim().ToUpper(); string rcardEnd = this.txtEndSnQuery.Text.Trim().ToUpper(); if (this.rcardListInCarton != null && this.rcardListInCarton != string.Empty) { rcardStart = rcardListInCarton; rcardEnd = rcardListInCarton; } //导出 if ((sender is System.Web.UI.HtmlControls.HtmlInputButton) && ((System.Web.UI.HtmlControls.HtmlInputControl)(((System.Web.UI.HtmlControls.HtmlInputButton)(sender)))).Name == "btnExportFT") { this.EleDetails = _facade.QueryOQCFuncTestValueEleDetail( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), rcardStart, rcardEnd, FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime); this.OQCFuncTestValues = _facade.QueryOQCFuncTestValue( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), rcardStart, rcardEnd, FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime, 0, int.MaxValue); (e as WebQueryEventArgs).GridDataSource = _facade.QueryOQCFuncTestValueDetailForExport( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), rcardStart, rcardEnd, FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime, (e as WebQueryEventArgs).StartRow, (e as WebQueryEventArgs).EndRow); if ((e as WebQueryEventArgs).GridDataSource != null) { (e as WebQueryEventArgs).RowCount = (e as WebQueryEventArgs).GridDataSource.Length; } } else { (e as WebQueryEventArgs).GridDataSource = _facade.QueryOQCFuncTestValue( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), rcardStart, rcardEnd, FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime, (e as WebQueryEventArgs).StartRow, (e as WebQueryEventArgs).EndRow); (e as WebQueryEventArgs).RowCount = this._facade.QueryOQCFuncTestValueCount( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), rcardStart, rcardEnd, FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime); } }
private void LoadDataSourceSN(object sender, EventArgs e) //protected object[] LoadDataSourceSN(int inclusive, int exclusive) { int seq; try { seq = int.Parse(this.txtSeq.Value); } catch { seq = -1; } int OQCBeginDate = FormatHelper.TODateInt(this.txtOQCBeginDate.Text); int OQCEndDate = FormatHelper.TODateInt(this.txtOQCEndDate.Text); int OQCBeginTime = FormatHelper.TOTimeInt(this.txtOQCBeginTime.Text); int OQCEndTime = FormatHelper.TOTimeInt(this.txtOQCEndTime.Text); if (_facade == null) { _facade = new QueryOQCFunctionFacade(this.DataProvider); } GetRcardByCarton(); string rcardStart = this.txtStartSnQuery.Text.Trim().ToUpper(); string rcardEnd = this.txtEndSnQuery.Text.Trim().ToUpper(); if (this.rcardListInCarton != null && this.rcardListInCarton != string.Empty) { rcardStart = rcardListInCarton; rcardEnd = rcardListInCarton; } //导出 if ((sender is System.Web.UI.HtmlControls.HtmlInputButton) && ((System.Web.UI.HtmlControls.HtmlInputControl)(((System.Web.UI.HtmlControls.HtmlInputButton)(sender)))).Name == "btnExpDimension") { object[] objs = _facade.QueryOQCDimentionValueForExport( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), rcardStart, rcardEnd, FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime, (e as WebQueryEventArgs).StartRow, (e as WebQueryEventArgs).EndRow); this.DimentionValues = objs; ArrayList list = new ArrayList(); Hashtable table = new Hashtable(); foreach (OQCDimentionValue v in DimentionValues) { if (!table.ContainsKey(v.RunningCard + v.LOTNO)) { table.Add(v.RunningCard + v.LOTNO, v); list.Add(v); } } (e as WebQueryEventArgs).GridDataSource = (object[])list.ToArray(typeof(object)); if ((e as WebQueryEventArgs).GridDataSource != null) { (e as WebQueryEventArgs).RowCount = (e as WebQueryEventArgs).GridDataSource.Length; } } else { (e as WebQueryEventArgs).GridDataSource = _facade.QueryOQCDimention( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), rcardStart, rcardEnd, FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime, (e as WebQueryEventArgs).StartRow, (e as WebQueryEventArgs).EndRow); (e as WebQueryEventArgs).RowCount = this._facade.QueryOQCDimentionCount( FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(), FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(), FormatHelper.CleanString(this.txtOQCLotQuery.Text), rcardStart, rcardEnd, FormatHelper.CleanString(this.txtSSCode.Text), OQCBeginDate, OQCBeginTime, OQCEndDate, OQCEndTime); } }