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);
}
}
