private void QueryEvent(object sender, EventArgs e)
{
int BeginDate = FormatHelper.TODateInt(this.txtBeginDate.Text);
int EndDate = FormatHelper.TODateInt(this.txtEndDate.Text);
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateQueryFacade3().QueryPT(
FormatHelper.CleanString(this.txtItemQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSnQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtEndSnQuery.Text).ToUpper(),
BeginDate,
EndDate,
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
facadeFactory.CreateQueryFacade3().QueryPTCount(
FormatHelper.CleanString(this.txtItemQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSnQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtEndSnQuery.Text).ToUpper(),
BeginDate,
EndDate
);
}
private void _initialChartTSInfo()
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
object[] dataSource =
facadeFactory.CreateQueryTSInfoFacade().QueryTSInfo(
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
string.Empty,
FormatHelper.TODateInt(DateTime.Today.Year.ToString() + "/" + DateTime.Today.Month.ToString() + "/01"),
FormatHelper.TODateInt(DateTime.Today.ToString("yyyy/MM/dd")),
TSInfoSummaryTarget.ErrorCode,
string.Empty,
5,
1,
int.MaxValue);
this._processTSInfoOWC(dataSource);
}
private void QueryEvent(object sender, EventArgs e)
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateDataLinkFacade().QueryFT(
FormatHelper.TODateInt(this.txtDateFrom.Text),
FormatHelper.TODateInt(this.txDateTo.Text),
FormatHelper.CleanString(this.txtStepSequence.Text).ToUpper(),
FormatHelper.CleanString(this.txtItemQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtResQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSnQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtEndSnQuery.Text).ToUpper(),
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
facadeFactory.CreateDataLinkFacade().QueryFTCount(
FormatHelper.TODateInt(this.txtDateFrom.Text),
FormatHelper.TODateInt(this.txDateTo.Text),
FormatHelper.CleanString(this.txtStepSequence.Text).ToUpper(),
FormatHelper.CleanString(this.txtItemQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtResQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSnQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtEndSnQuery.Text).ToUpper());
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!this.IsPostBack)
{
// 初始化页面语言
this.InitPageLanguage(this.languageComponent1, false);
QueryFacade2 _qFacade = new FacadeFactory(base.DataProvider).CreateQueryFacade2();
string rcard = this.GetRequestParam("RCARD");
int rcardseq;
try
{
rcardseq = int.Parse(this.GetRequestParam("RCARDSEQ"));
}
catch
{
rcardseq = -1;
}
string moCode = this.GetRequestParam("MOCODE");
object obj = _qFacade.GetProductionProcess(moCode, rcard, rcardseq);
if (obj == null)
{
ExceptionManager.Raise(this.GetType(), "$Error_ItemTracing_not_exist");
}
this.txtItem.Value = ((ProductionProcess)obj).ItemCode;
this.txtMO.Value = ((ProductionProcess)obj).MOCode;
this.txtModel.Value = ((ProductionProcess)obj).ModelCode;
this.txtSN.Value = ((ProductionProcess)obj).RCard;
this.txtSeq.Value = ((ProductionProcess)obj).RCardSequence.ToString();
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
if (this._checkRequireFields())
{
(e as WebQueryEventArgs).GridDataSource =
FacadeFactory.CreateQueryTSDetailsFacade().QueryTSDetails(
FormatHelper.CleanString(this.txtModelQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtItemQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtRepaireOperationQuery.Text).ToUpper(),
"",
this.SourceOperationDate,
this.SourceOperationTime,
FormatHelper.CleanString(this.txtTsStateQuery.Text).ToUpper(),
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
FacadeFactory.CreateQueryTSDetailsFacade().QueryTSDetailsCount(
FormatHelper.CleanString(this.txtModelQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtItemQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtRepaireOperationQuery.Text).ToUpper(),
"",
this.SourceOperationDate,
this.SourceOperationTime,
FormatHelper.CleanString(this.txtTsStateQuery.Text).ToUpper());
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
if (this._checkRequireFields())
{
(e as WebQueryEventArgs).GridDataSource =
FacadeFactory.CreateQueryTSRecordFacade().QueryTSRecord(
FormatHelper.CleanString(this.txtConditionModel.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSnQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtEndSnQuery.Text).ToUpper(),
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text),
TSStateListBuilder.GetCheckedTSStateList(this.chkTSStateList),
"",
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
FacadeFactory.CreateQueryTSRecordFacade().QueryTSRecordCount(
FormatHelper.CleanString(this.txtConditionModel.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSnQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtEndSnQuery.Text).ToUpper(),
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text),
TSStateListBuilder.GetCheckedTSStateList(this.chkTSStateList),
"");
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource = facadeFactory.CreateQueryItemConfigrationFacade().QueryItemConfigration
(FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtConditionItem.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtConditionMo.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtRCardStart.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtRCardEnd.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtItemConfig.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtConfigCode.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtConfigValue.Text)),
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text),
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow
);
(e as WebQueryEventArgs).RowCount = facadeFactory.CreateQueryItemConfigrationFacade().QueryItemConfigrationCount
(FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtConditionItem.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtConditionMo.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtRCardStart.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtRCardEnd.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtItemConfig.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtConfigCode.Text)),
FormatHelper.CleanString(FormatHelper.PKCapitalFormat(this.txtConfigValue.Text)),
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text));
}
//查询事件
private void QueryEvent(object sender, EventArgs e)
{
//added by jessie lee,2005/9/20
//限制计入统计的维修状态
ArrayList array = new ArrayList();
array.Add(TSStatus.TSStatus_Complete);
array.Add(TSStatus.TSStatus_Reflow);
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateQueryTSRecordFacade().QueryTSPerformanceRecord(
FormatHelper.CleanString(this.ModelCode).ToUpper(),
FormatHelper.CleanString(this.ItemCode).ToUpper(),
FormatHelper.CleanString(this.MoCode).ToUpper(),
"", "",
this.StartDate,
this.EndDate,
array, this.TsOperator, this.TsResource,
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
facadeFactory.CreateQueryTSRecordFacade().QueryTSPerformanceRecordCount(
FormatHelper.CleanString(this.ModelCode).ToUpper(),
FormatHelper.CleanString(this.ItemCode).ToUpper(),
FormatHelper.CleanString(this.MoCode).ToUpper(),
"", "",
this.StartDate,
this.EndDate,
array, this.TsOperator, this.TsResource);
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQueryFacade3().QueryOnWipInfoDistributing(
this.ViewState["Status"].ToString(),
this.txtItemCodeQuery.Text,
this.ViewState["ShiftCode"].ToString(),
this.txtOperationCodeQuery.Text,
this.txtResourceCodeQuery.Text,
this.txtMoCodeQuery.Text,
FormatHelper.TODateInt(this.ViewState["ShiftDay"].ToString()),
FormatHelper.TODateInt(this.ViewState["ShiftDay"].ToString()),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryFacade3().QueryOnWipInfoDistributingCount(
this.ViewState["Status"].ToString(),
this.txtItemCodeQuery.Text,
this.ViewState["ShiftCode"].ToString(),
this.txtOperationCodeQuery.Text,
this.txtResourceCodeQuery.Text,
this.txtMoCodeQuery.Text,
FormatHelper.TODateInt(this.ViewState["ShiftDay"].ToString()),
FormatHelper.TODateInt(this.ViewState["ShiftDay"].ToString()));
}
//查询按钮事件
private void QueryEvent(object sender, EventArgs e)
{
if (this._checkRequireFields())
{
int receiveBeginDate = FormatHelper.TODateInt(this.txtReceiveBeginDate.Text);
int receiveEndDate = FormatHelper.TODateInt(this.txtReceiveEndDate.Text);
int receiveBeginTime = FormatHelper.TOTimeInt(this.txtReceiveBeginTime.Text);
int receiveEndTime = FormatHelper.TOTimeInt(this.txtReceiveEndTime.Text);
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQueryRMATSFacade().QueryRMATSRecord(
FormatHelper.CleanString(this.txtConditionModel.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtReworkMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtRMABillCode.Text).ToUpper(),
receiveBeginDate, receiveBeginTime,
receiveEndDate, receiveEndTime,
CheckBoxListBuilder.GetCheckedList(this.chkTSStateList),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryRMATSFacade().QueryRMATSRecordCount(
FormatHelper.CleanString(this.txtConditionModel.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtReworkMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtRMABillCode.Text).ToUpper(),
receiveBeginDate, receiveBeginTime,
receiveEndDate, receiveEndTime,
CheckBoxListBuilder.GetCheckedList(this.chkTSStateList));
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
if (this._checkRequireFields())
{
_initialWebGrid();
FacadeFactory facadeFactory = new FacadeFactory(this.DataProvider);
object[] dataSource = facadeFactory.CreateQueryRMATSFacade().QueryRMADefect(
rblSummaryTargetQuery.SelectedValue,
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow
);;
(e as WebQueryEventArgsNew).GridDataSource = dataSource;
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryRMATSFacade().QueryRMADefectCount(
rblSummaryTargetQuery.SelectedValue,
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text));
this._processOWC(dataSource);
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateQueryFacade1().QueryRealTimeDetails(
this.txtSegmentQuery.Text,
FormatHelper.TODateInt(this.eMESDate1.Text),
this.txtShiftCodeQuery.Text,
this.txtStepSeqenceCodeQuery.Text,
this.txtModelCodeQuery.Text,
this.txtItemCodeQuery.Text,
this.txtMoCodeQuery.Text,
this.txtTimePeriodQuery.Text,
(bool)this.ViewState["IncludeMidOutput"],
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
facadeFactory.CreateQueryFacade1().QueryRealTimeDetailsCount(
this.txtSegmentQuery.Text,
FormatHelper.TODateInt(this.eMESDate1.Text),
this.txtShiftCodeQuery.Text,
this.txtStepSeqenceCodeQuery.Text,
this.txtModelCodeQuery.Text,
this.txtItemCodeQuery.Text,
this.txtMoCodeQuery.Text,
this.txtTimePeriodQuery.Text,
(bool)this.ViewState["IncludeMidOutput"]);
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateQuerySNNGFacade().QuerySNNG(
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionStepSequence.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSnQuery.Text),
FormatHelper.CleanString(this.txtEndSnQuery.Text),
FormatHelper.CleanString(this.txtResource.Text).ToUpper(),
FormatHelper.CleanString(this.txtFrmDateFrom.Text).ToUpper(),
FormatHelper.CleanString(this.txtFrmDateTo.Text).ToUpper(),
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
facadeFactory.CreateQuerySNNGFacade().QuerySNNGCount(
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionStepSequence.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSnQuery.Text),
FormatHelper.CleanString(this.txtEndSnQuery.Text),
FormatHelper.CleanString(this.txtResource.Text).ToUpper(),
FormatHelper.CleanString(this.txtFrmDateFrom.Text).ToUpper(),
FormatHelper.CleanString(this.txtFrmDateTo.Text).ToUpper());
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
int BeginDate = FormatHelper.TODateInt(this.txtBeginDate.Text);
int EndDate = FormatHelper.TODateInt(this.txtEndDate.Text);
string softCompareResult = this.SoftCompareResult;
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateQuerySoftwareVersionFacade().QuerySoftwareVersion(
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSNQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtEndSNQuery.Text).ToUpper(),
BeginDate, EndDate, softCompareResult,
FormatHelper.CleanString(this.txtSoftwareNameQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtSoftwareVersionQuery.Text).ToUpper(),
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
facadeFactory.CreateQuerySoftwareVersionFacade().QuerySoftwareVersionCount(
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtStartSNQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtEndSNQuery.Text).ToUpper(),
BeginDate, EndDate, softCompareResult,
FormatHelper.CleanString(this.txtSoftwareNameQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtSoftwareVersionQuery.Text).ToUpper());
}
private void QueryEvent(object sender, EventArgs e)
{
// int BeginDate = FormatHelper.TODateInt(this.txtBeginDate.Text);
// int EndDate = FormatHelper.TODateInt(this.txtEndDate.Text);
string recBegDate = String.Empty;
string recEndDate = String.Empty;
string tossBegDate = String.Empty;
string tossEndDate = String.Empty;
if (chbRecieve.Checked == true)
{
recBegDate = FormatHelper.TODateInt(DateTime.Parse(this.txtRecieveBeginDate.Text)).ToString();
recEndDate = FormatHelper.TODateInt(DateTime.Parse(this.txtRecieveEndDate.Text)).ToString();
}
if (chbToss.Checked == true)
{
tossBegDate = FormatHelper.TODateInt(DateTime.Parse(this.txtTossBeginDate.Text)).ToString();
tossEndDate = FormatHelper.TODateInt(DateTime.Parse(this.txtTossEndDate.Text)).ToString();
}
string moCode = String.Empty;
string itemCode = String.Empty;
if (FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper() != String.Empty)
{
moCode = String.Join("','", FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper().Split(','));
}
if (FormatHelper.CleanString(this.txtItemQuery.Text).ToUpper() != String.Empty)
{
itemCode = String.Join("','", FormatHelper.CleanString(this.txtItemQuery.Text).ToUpper().Split(','));
}
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgs).GridDataSource =
facadeFactory.CreateInventoryFacade().QueryERPINVInterface(
FormatHelper.CleanString(this.txtRecNO.Text).ToUpper(),
moCode,
itemCode,
recBegDate,
recEndDate,
tossBegDate,
tossEndDate,
FormatHelper.CleanString(this.drpStatusEdit.SelectedValue).ToUpper(),
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).RowCount =
facadeFactory.CreateInventoryFacade().QueryERPINVInterfaceCount(
FormatHelper.CleanString(this.txtRecNO.Text).ToUpper(),
moCode,
itemCode,
recBegDate,
recEndDate,
tossBegDate,
tossEndDate,
FormatHelper.CleanString(this.drpStatusEdit.SelectedValue).ToUpper()
);
}
private void _processSegment()
{
object[] obj = new FacadeFactory(base.DataProvider).CreateQueryFacade1().QuerySegmentRealTimeYieldPercent(
this.V_SegmentCode,
this.V_ModelCode,
this.V_ItemCode,
this.V_MoCode,
this.V_ShiftCode,
FormatHelper.TODateInt(this.V_Date));
if (obj != null)
{
RealTimeYieldPercent segYield = obj[0] as RealTimeYieldPercent;
this.txtSegmentAllGoodQuantity.Text = segYield.AllGoodQuantity.ToString();
this.txtSegmentQuantity.Text = segYield.Quantity.ToString();
this.txtSegmentNotYieldPercent.Text =
System.Decimal.Round(System.Decimal.Parse(segYield.AllGoodYieldPercent.ToString()) * 100, 2).ToString() + "%";
}
else
{
this.txtSegmentAllGoodQuantity.Text = "";
this.txtSegmentQuantity.Text = "";
this.txtSegmentNotYieldPercent.Text = "";
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
if (this._checkRequireFields())
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
object[] dataSource =
facadeFactory.CreateQueryTSPerformanceFacade().QueryTSPerformance(
FormatHelper.CleanString(this.txtConditionModel.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionResource.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionOperator.Text).ToUpper(),
this.rblSummaryTargetQuery.SelectedValue,
this.upDown.Value,
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).GridDataSource = dataSource;
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryTSPerformanceFacade().QueryTSPerformanceCount(
FormatHelper.CleanString(this.txtConditionModel.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionResource.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionOperator.Text).ToUpper(),
this.rblSummaryTargetQuery.SelectedValue,
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text), this.upDown.Value);
this._processOWC(dataSource);
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
PageCheckManager manager = new PageCheckManager();
manager.Add(new DateRangeCheck(this.lblStockDateFromQuery, this.dateStockDateFromQuery.Text, this.dateStockDateToQuery.Text, true));
if (!manager.Check())
{
WebInfoPublish.Publish(this, manager.CheckMessage, this.languageComponent1);
return;
}
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
object[] dataSource = facadeFactory.CreateQueryStockFacade().QueryStockContrast(
this.rdbStockStatusQuery.SelectedIndex,
FormatHelper.TODateInt(this.dateStockDateFromQuery.Text),
FormatHelper.TODateInt(this.dateStockDateToQuery.Text),
(e as WebQueryEventArgs).StartRow,
(e as WebQueryEventArgs).EndRow);
(e as WebQueryEventArgs).GridDataSource = dataSource;
(e as WebQueryEventArgs).RowCount =
facadeFactory.CreateQueryStockFacade().QueryStockContrastCount(
this.rdbStockStatusQuery.SelectedIndex,
FormatHelper.TODateInt(this.dateStockDateFromQuery.Text),
FormatHelper.TODateInt(this.dateStockDateToQuery.Text));
}
private void _helper_LoadGridDataSource(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
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQuerySMTNGFacade().QuerySMTNG(
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionStepSequence.Text).ToUpper(),
FormatHelper.CleanString(startSourceCard),
FormatHelper.CleanString(endSourceCard),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQuerySMTNGFacade().QuerySMTNGCount(
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionStepSequence.Text).ToUpper(),
FormatHelper.CleanString(startSourceCard),
FormatHelper.CleanString(endSourceCard));
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
if (this._checkRequireFields())
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQueryTSChangedPartsFacade().QueryTSChangedParts(
"",
"",
FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtSnQuery.Text).ToUpper(),
"",
FormatHelper.CleanString(this.txtRepaireResourceQuery.Text).ToUpper(),
"",
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryTSChangedPartsFacade().QueryTSChangedPartsCount(
"",
"",
FormatHelper.CleanString(this.txtMoQuery.Text).ToUpper(),
FormatHelper.CleanString(this.txtSnQuery.Text).ToUpper(),
"",
FormatHelper.CleanString(this.txtRepaireResourceQuery.Text).ToUpper(),
"");
}
}
protected void drpShiftQuery_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.drpShiftQuery.Items.Clear();
BaseModelFacade facade = new FacadeFactory(base.DataProvider).CreateBaseModelFacade();
object[] shifts = new FacadeFactory(base.DataProvider).CreateShfitModelFacade().QueryShift("", "", 0, System.Int32.MaxValue);
if (shifts != null)
{
string selected = "";
int now = FormatHelper.TODateInt(System.DateTime.Now);
foreach (Shift shift in shifts)
{
if (shift.ShiftBeginTime <= now &&
shift.ShiftEndTime >= now)
{
selected = shift.ShiftCode;
}
this.drpShiftQuery.Items.Add(shift.ShiftCode);
}
try
{
this.drpShiftQuery.SelectedValue = selected;
}
catch
{
this.drpShiftQuery.SelectedIndex = 0;
}
}
}
}
private void WebQueryHelper_LoadGridDataSource(object sender, EventArgs e)
{
InitWebGrid();
if (CheckRequireFields())
{
//该页面不需要分页,做法是将页面元素注释了
FacadeFactory facadeFactory = new FacadeFactory(this.DataProvider);
object[] dataSource = facadeFactory.CreateQueryFacade1().QueryStockAge(
FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtStorageTypeEdit.Text)),
this.drpPeiodGroupEdit.SelectedValue,
this.txtItemCodeEdit.Text,
FormatHelper.CleanString(this.txtOrderNoEdit.Text),
this.txtMmodelcode.Text,
this.drpFirstClassGroup.SelectedValue,
this.chbSAPCompelete.Checked,
1, //(e as WebQueryEventArgs).StartRow,
int.MaxValue //(e as WebQueryEventArgs).EndRow
);
//(e as WebQueryEventArgs).RowCount = facadeFactory.CreateQueryFacade1().QueryStockAgeCount(
// FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtStorageTypeEdit.Text)),
// this.drpPeiodGroupEdit.SelectedValue,
// this.txtItemCodeEdit.Text,
// FormatHelper.CleanString(this.txtOrderNoEdit.Text),
// this.txtMmodelcode.Text,
// this.drpFirstClassGroup.SelectedValue,
// this.chbSAPCompelete.Checked
// );
this.ProcessDataDourceToGrid(dataSource);
}
}
//导出事件
private void ExportQueryEvent(object sender, EventArgs e)
{
if (chbRepairDetail.Checked)
{
//TODO ForSimone
//added by jessie lee,2005/9/20
//限制计入统计的维修状态
ArrayList array = new ArrayList();
array.Add(TSStatus.TSStatus_Complete);
array.Add(TSStatus.TSStatus_Reflow);
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQueryTSRecordFacade().ExportQueryTSPerformanceRecord(
FormatHelper.CleanString(this.ModelCode).ToUpper(),
FormatHelper.CleanString(this.ItemCode).ToUpper(),
FormatHelper.CleanString(this.MoCode).ToUpper(),
"", "",
this.StartDate,
this.EndDate,
array, this.TsOperator, this.TsResource,
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
}
else
{
this.QueryEvent(sender, e);
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQueryFacade1().QueryKeyPartsInfo(
FormatHelper.CleanString(this.txtKeypartsQuery.Text),
this.GetRequestParam("InsideItemCode"),
this.GetRequestParam("VendorCode"),
this.GetRequestParam("VendorItemCode"),
this.GetRequestParam("LotNo"),
this.GetRequestParam("DateCode"),
FormatHelper.CleanString(this.txtKeyparts.Text),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryFacade1().QueryKeyPartsInfoCount(
FormatHelper.CleanString(this.txtKeypartsQuery.Text),
this.GetRequestParam("InsideItemCode"),
this.GetRequestParam("VendorCode"),
this.GetRequestParam("VendorItemCode"),
this.GetRequestParam("LotNo"),
this.GetRequestParam("DateCode"),
FormatHelper.CleanString(this.txtKeyparts.Text));
}
//导出事件
private void ExportQueryEvent(object sender, EventArgs e)
{
if (chbRepairDetail.Checked)
{
//TODO ForSimone
if (this._checkRequireFields())
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQueryRMATSFacade().ExportQueryRMATSInfoList(
FormatHelper.CleanString(this.MoCode).ToUpper(),
this.StartDate, this.EndDate,
this.SummaryTarget,
this.SummaryObject,
this.SummaryObject1,
FormatHelper.CleanString(this.ModelCode).ToUpper(),
FormatHelper.CleanString(this.ItemCode).ToUpper(),
FormatHelper.CleanString(this.FrmResCodes).ToUpper(),
FormatHelper.CleanString(this.RMABillCodes).ToUpper(),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
}
}
else
{
this.QueryEvent(sender, e);
}
}
//查询事件
private void QueryEvent(object sender, EventArgs e)
{
if (this._checkRequireFields())
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
(e as WebQueryEventArgsNew).GridDataSource =
facadeFactory.CreateQueryRMATSFacade().QueryRMATSInfoList(
FormatHelper.CleanString(this.MoCode).ToUpper(),
this.StartDate, this.EndDate,
this.SummaryTarget,
this.SummaryObject,
this.SummaryObject1,
FormatHelper.CleanString(this.ModelCode).ToUpper(),
FormatHelper.CleanString(this.ItemCode).ToUpper(),
FormatHelper.CleanString(this.FrmResCodes).ToUpper(),
FormatHelper.CleanString(this.RMABillCodes).ToUpper(),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryRMATSFacade().QueryRMATSInfoListCount(
FormatHelper.CleanString(this.MoCode).ToUpper(),
this.StartDate, this.EndDate,
this.SummaryTarget,
this.SummaryObject,
this.SummaryObject1,
FormatHelper.CleanString(this.ModelCode).ToUpper(),
FormatHelper.CleanString(this.ItemCode).ToUpper(),
FormatHelper.CleanString(this.FrmResCodes).ToUpper(),
FormatHelper.CleanString(this.RMABillCodes).ToUpper());
}
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
this._initialWebGrid();
if (this._checkRequireFields())
{
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
object[] dataSource =
facadeFactory.CreateQueryTSInfoFacade().QueryTSInfo(
FormatHelper.CleanString(this.txtErrorCodeGroup.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorCode.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorCause.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorCauseGroup.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorLocation.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorDuty.Text).ToUpper(),
FormatHelper.CleanString(this.drpFinishSemimanuProductQuery.SelectedValue),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtFromResource.Text).ToUpper(),
FormatHelper.CleanString(this.drpFirstClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpSecondClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpThirdClassQuery.SelectedValue),
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text),
this.rblSummaryTargetQuery.SelectedValue,
FormatHelper.CleanString(this.txtLotNo.Text).ToUpper(),
this.upDown.Value,
FormatHelper.CleanString(this.txtErrorcomponentQuery.Text).ToUpper(),
(e as WebQueryEventArgsNew).StartRow,
(e as WebQueryEventArgsNew).EndRow);
(e as WebQueryEventArgsNew).GridDataSource = dataSource;
(e as WebQueryEventArgsNew).RowCount =
facadeFactory.CreateQueryTSInfoFacade().QueryTSInfoCount(
FormatHelper.CleanString(this.txtErrorCodeGroup.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorCode.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorCause.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorCauseGroup.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorLocation.Text).ToUpper(),
FormatHelper.CleanString(this.txtErrorDuty.Text).ToUpper(),
FormatHelper.CleanString(this.drpFinishSemimanuProductQuery.SelectedValue),
FormatHelper.CleanString(this.txtConditionItem.Text).ToUpper(),
FormatHelper.CleanString(this.txtConditionMo.Text).ToUpper(),
FormatHelper.CleanString(this.txtFromResource.Text).ToUpper(),
FormatHelper.CleanString(this.drpFirstClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpSecondClassQuery.SelectedValue),
FormatHelper.CleanString(this.drpThirdClassQuery.SelectedValue),
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text),
this.rblSummaryTargetQuery.SelectedValue,
FormatHelper.CleanString(this.txtLotNo.Text).ToUpper(),
this.upDown.Value,
FormatHelper.CleanString(this.txtErrorcomponentQuery.Text).ToUpper());
this._processOWC(dataSource);
}
}
private void _initialWebGrid()
{
this.gridWebGrid.Columns.Clear();
this._gridHelper.GridHelper.AddColumn("StepSequenceCode", "生产线", null, 100);
this._gridHelper.GridHelper.AddColumn("ItemCode", "产品代码", null, 100);
string selected = "";
if (this.drpShiftQuery.SelectedValue == "")
{
this._gridHelper.GridHelper.AddColumn("TPCode", "时段代码", null);
}
else
{
object[] tps = new FacadeFactory(base.DataProvider).CreateShfitModelFacade().GetTimePeriodByShiftCode(this.drpShiftQuery.SelectedValue);
if (tps != null)
{
this._gridHelper.GridHelper.AddColumn("InputOutputName", "", null, 100);
this.gridWebGrid.Bands[0].Columns.FromKey("StepSequenceCode").MergeCells = true;
int now = FormatHelper.TOTimeInt(System.DateTime.Now);
int count = tps.Length;
//foreach(TimePeriod tp in tps)
for (int i = 0; i < count; i++)
{
TimePeriod tp = tps[i] as TimePeriod;
string key = tp.TimePeriodCode;
this._gridHelper.GridHelper.AddColumn(key, FormatHelper.ToShortTimeString(tp.TimePeriodBeginTime) + "<br>" + FormatHelper.ToShortTimeString(tp.TimePeriodEndTime), null);
if (tp.TimePeriodBeginTime <= now &&
tp.TimePeriodEndTime >= now)
{
selected = tp.TimePeriodCode;
}
}
}
else
{
this._gridHelper.GridHelper.AddColumn("TPCode", "时段代码", null);
}
}
this._gridHelper.GridHelper.AddColumn("Summary", "汇总", null, 100);
GridItemStyle blueBack = new GridItemStyle(true);
blueBack.BackColor = Color.SkyBlue;
if (this.gridWebGrid.Columns.FromKey(selected) != null)
{
this.gridWebGrid.Columns.FromKey(selected).HeaderStyle.BackColor = Color.SkyBlue;
}
this.gridWebGrid.Columns.FromKey("Summary").Hidden = false;
//多语言
this._gridHelper.GridHelper.ApplyLanguage(this.languageComponent1);
}
private void _helper_LoadGridDataSource(object sender, EventArgs e)
{
if (!_checkRequireFields())
{
return;
}
this.ViewState["ItemCode"] = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtItemCodeQuery.Text));
this.ViewState["MoCode"] = FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMoCodeQuery.Text));
this.OWCChartSpace1.ClearCharts();
FacadeFactory facadeFactory = new FacadeFactory(base.DataProvider);
object[] dataSource = facadeFactory.CreateQueryTSInfoFacade().QueryTSLocECode(
this.ViewState["ItemCode"].ToString(),
this.ViewState["MoCode"].ToString(),
FormatHelper.TODateInt(this.dateStartDateQuery.Text),
FormatHelper.TODateInt(this.dateEndDateQuery.Text),
1,
int.MaxValue);
//chart
this.OWCPivotTable1.ClearFieldSet();
string[] schema = new string[] { "ErrorLocation", "ErrorCauseDesc", "Quantity" };
this.OWCPivotTable1.SetDataSource(
dataSource, schema);
string[] rows = new string[] { "ErrorLocation" };
foreach (string row in rows)
{
this.OWCPivotTable1.AddRowFieldSet(row, false);
}
string[] columns = new string[] { "ErrorCauseDesc" };
foreach (string column in columns)
{
this.OWCPivotTable1.AddColumnFieldSet(column, false);
}
string field = "Quantity";
this.OWCPivotTable1.AddTotalField(
this.languageComponent1.GetString(field),
field,
PivotTotalFunctionType.Sum);
if (this.rblVisibleStyle.SelectedValue.ToUpper() == VisibleStyle.Pivot.ToUpper())
{
this.OWCPivotTable1.Display = true;
this.OWCChartSpace1.Display = false;
}
if (this.rblVisibleStyle.SelectedValue.ToUpper() == VisibleStyle.Chart.ToUpper())
{
this.OWCChartSpace1.DataSource = this.OWCPivotTable1.PivotTableName;
this.OWCChartSpace1.ChartType = OWCChartType.ColumnStacked;
this.OWCPivotTable1.Display = false;
this.OWCChartSpace1.Display = true;
}
}
private void _initialWebGrid()
{
this.gridWebGrid.Columns.Clear();
this._gridHelper.AddColumn("StepSequenceCode", "生产线", null);
string selected = "";
if (this.txtShiftCodeQuery.Text == "")
{
this._gridHelper.AddColumn("TPCode", "时段代码", null);
}
else
{
object[] tps = new FacadeFactory(base.DataProvider).CreateShfitModelFacade().QueryTimePeriod("", this.txtShiftCodeQuery.Text, 0, System.Int32.MaxValue);
if (tps != null)
{
int now = FormatHelper.TOTimeInt(System.DateTime.Now);
foreach (TimePeriod tp in tps)
{
string key = tp.TimePeriodCode;
this.gridWebGrid.Bands[0].Columns.Add(key);
this.gridWebGrid.Bands[0].Columns.FromKey(key).HeaderText = FormatHelper.ToTimeString(tp.TimePeriodBeginTime) + "~" + FormatHelper.ToTimeString(tp.TimePeriodEndTime);
this.gridWebGrid.Bands[0].Columns.FromKey(key).Width = new System.Web.UI.WebControls.Unit(150);
this.gridWebGrid.Bands[0].Columns.FromKey(key).CellButtonStyle.BackColor = System.Drawing.Color.Transparent;
this.gridWebGrid.Bands[0].Columns.FromKey(key).CellButtonStyle.BorderStyle = System.Web.UI.WebControls.BorderStyle.None;
this.gridWebGrid.Bands[0].Columns.FromKey(key).CellButtonStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
this.gridWebGrid.Bands[0].Columns.FromKey(key).CellButtonStyle.CustomRules = "BACKGROUND-POSITION: center center;Background-repeat:no-repeat";
this.gridWebGrid.Bands[0].Columns.FromKey(key).CellButtonStyle.BackgroundImage = "";
this.gridWebGrid.Bands[0].Columns.FromKey(key).CellStyle.CustomRules = "BACKGROUND-POSITION: center center;Background-repeat:no-repeat";
if (tp.TimePeriodBeginTime <= now &&
tp.TimePeriodEndTime >= now)
{
selected = tp.TimePeriodCode;
}
}
}
else
{
this._gridHelper.AddColumn("TPCode", "时段代码", null);
}
}
this._gridHelper.AddColumn("Summary", "汇总", null);
GridItemStyle blueBack = new GridItemStyle(true);
blueBack.BackColor = Color.SkyBlue;
if (this.gridWebGrid.Columns.FromKey(selected) != null)
{
this.gridWebGrid.Columns.FromKey(selected).HeaderStyle.BackColor = Color.SkyBlue;
}
//多语言
this._gridHelper.ApplyLanguage(this.languageComponent1);
}
