private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
if (this._checkRequireFields())
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQueryOQCLotDetailsFacade().QueryOQCLotDetailsListInfo(
FormatHelper.CleanString(this.txtOQCLotQuery.Text).ToUpper(),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryOQCLotDetailsFacade().QueryOQCLotDetailsListInfoCount(
FormatHelper.CleanString(this.txtOQCLotQuery.Text).ToUpper());
}
}
//导出事件
private void ExportQueryEvent(object sender, EventArgs e)
{
//将序列号转换为SourceCode
DataCollectFacade dataCollectfacade = new DataCollectFacade(this.DataProvider);
//对于序列号的输入框，需要进行一下处理
string startRCard = FormatHelper.CleanString(this.txtStartSnQuery.Text.Trim().ToUpper());
string endRCard = FormatHelper.CleanString(this.txtEndSnQuery.Text.Trim().ToUpper());
//转换成SourceCard
string startSourceCard = dataCollectfacade.GetSourceCard(startRCard, string.Empty);
string endSourceCard = dataCollectfacade.GetSourceCard(endRCard, string.Empty);
//end
int PackedBeginDate = DefaultDateTime.DefaultToInt;
int PackedBeginTime = FormatHelper.TOTimeInt(this.txtPackedBeginTime.Text);
int PackedEndDate = DefaultDateTime.DefaultToInt;
int PackedEndTime = FormatHelper.TOTimeInt(this.txtPackedEndTime.Text);
int OQCBeginDate = DefaultDateTime.DefaultToInt;
int OQCBeginTime = 0;
//FormatHelper.TOTimeInt(this.txtOQCBeginTime.Text);
int OQCEndDate = DefaultDateTime.DefaultToInt;
int OQCEndTime = 0;
int reworkBeginDate = FormatHelper.TODateInt(this.txtDecideBegdateQuery.Text);
int reworkEndDate = FormatHelper.TODateInt(this.txtDecideEnddateQuery.Text);
//FormatHelper.TOTimeInt(this.txtOQCEndTime.Text);
// PackedBeginDate = FormatHelper.TODateInt(this.txtPackedBeginDate.Text);
// PackedEndDate = FormatHelper.TODateInt(this.txtPackedEndDate.Text);
//
// if(cbOQC.Checked)
// {
// OQCBeginDate = FormatHelper.TODateInt(this.txtOQCBeginDate.Text);
// OQCEndDate = FormatHelper.TODateInt(this.txtOQCEndDate.Text);
// }
if (this.chbOQCDate.Checked)
{
OQCBeginDate = FormatHelper.TODateInt(this.txtOQCBeginDate.Text);
OQCEndDate = FormatHelper.TODateInt(this.txtOQCEndDate.Text);
}
if (this.rdbPackedDate.Checked)
{
PackedBeginDate = FormatHelper.TODateInt(this.txtPackedBeginDate.Text);
PackedEndDate = FormatHelper.TODateInt(this.txtPackedEndDate.Text);
}
if (chbItemDetail.Checked)
{
//TODO ForSimone
#region 产品明细导出
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateQueryOQCLotDetailsFacade().ExportQueryOQCLotDetails(
FormatHelper.CleanString(this.txtProductionTypeQuery.Text),
FormatHelper.CleanString(this.txtStepSequence.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtOQCLotQuery.Text),
FormatHelper.CleanString(this.drpOQCStateQuery.SelectedValue),
FormatHelper.CleanString(startSourceCard),
FormatHelper.CleanString(endSourceCard),
FormatHelper.CleanString(this.drpFirstClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpSecondClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpThirdClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpCrewCodeQuery.SelectedValue),
FormatHelper.CleanString(this.txtBigSSCodeWhere.Text),
FormatHelper.CleanString(this.txtMaterialModelCodeWhere.Text),
FormatHelper.CleanString(this.txtMaterialMachineTypeWhere.Text),
FormatHelper.CleanString(this.drpMaterialExportImportWhere.SelectedValue),
FormatHelper.CleanString(this.txtDecideManQuery.Text),
FormatHelper.CleanString(this.txtOQCLotTypeQuery.Text),
FormatHelper.CleanString(this.txtReWorkMOQuery.Text),
reworkBeginDate, reworkEndDate,
PackedBeginDate, PackedBeginTime,
PackedEndDate, PackedEndTime,
OQCBeginDate, OQCBeginTime,
OQCEndDate, OQCEndTime,
this.chbQueryHistory.Checked,
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
#endregion
}
else if (chbRepairDetail.Checked)
{
//TODO ForSimone
#region 样本不良明细导出
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateQueryOQCLotDetailsFacade().ExportQueryOQCLotSampleDetails(
FormatHelper.CleanString(this.txtProductionTypeQuery.Text),
FormatHelper.CleanString(this.txtStepSequence.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtOQCLotQuery.Text),
FormatHelper.CleanString(this.drpOQCStateQuery.SelectedValue),
FormatHelper.CleanString(startSourceCard),
FormatHelper.CleanString(endSourceCard),
FormatHelper.CleanString(this.drpFirstClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpSecondClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpThirdClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpCrewCodeQuery.SelectedValue),
FormatHelper.CleanString(this.txtBigSSCodeWhere.Text),
FormatHelper.CleanString(this.txtMaterialModelCodeWhere.Text),
FormatHelper.CleanString(this.txtMaterialMachineTypeWhere.Text),
FormatHelper.CleanString(this.drpMaterialExportImportWhere.SelectedValue),
FormatHelper.CleanString(this.txtDecideManQuery.Text),
FormatHelper.CleanString(this.txtOQCLotTypeQuery.Text),
FormatHelper.CleanString(this.txtReWorkMOQuery.Text),
reworkBeginDate, reworkEndDate,
PackedBeginDate, PackedBeginTime,
PackedEndDate, PackedEndTime,
OQCBeginDate, OQCBeginTime,
OQCEndDate, OQCEndTime,
this.chbQueryHistory.Checked,
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
#endregion
}
else
{
this.QueryEvent(sender, e);
}
}
