private void ReloadDataSource() { DtSource = new DataTable(); this.gridWebGrid.ClearDataSource(); this.gridWebGrid.Columns.Clear(); this.gridHelper = new GridHelperNew(this.gridWebGrid, this.DtSource); this._initialWebGrid(); if (this._checkRequireFields()) { int startRow = (this.gridHelper._pagerToolBar.PageCount - 1) * this.gridHelper._pagerToolBar.PageSize + 1; int endRow = this.gridHelper._pagerToolBar.RowCount; 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(), int.Parse(this.upDown.Control.Text), FormatHelper.CleanString(this.txtErrorcomponentQuery.Text).ToUpper(), startRow, endRow); this.gridHelper.RefreshData(); this._processOWC(dataSource); } }
//导出事件 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.CreateQueryTSInfoFacade().ExportQueryTSInfoList( FormatHelper.CleanString(this.ECG).ToUpper(), FormatHelper.CleanString(this.EC).ToUpper(), FormatHelper.CleanString(this.ECS).ToUpper(), FormatHelper.CleanString(this.ECSG).ToUpper(), FormatHelper.CleanString(this.LOC).ToUpper(), FormatHelper.CleanString(this.DUTY).ToUpper(), FormatHelper.CleanString(this.MoCode).ToUpper(), FormatHelper.CleanString(this.Errorcomponent).ToUpper(), FormatHelper.CleanString(this.FirstClassGroup).ToUpper(), FormatHelper.CleanString(this.SecondClassGroup).ToUpper(), FormatHelper.CleanString(this.ThirdClassGroup).ToUpper(), this.StartDate, this.EndDate, this.SummaryTarget, this.SummaryObject, this.SummaryObject1, FormatHelper.CleanString(this.ModelCode), FormatHelper.CleanString(this.ItemCode).ToUpper(), FormatHelper.CleanString(this.FrmResCodes).ToUpper(), FormatHelper.CleanString(this.LotNo).ToUpper(), (e as WebQueryEventArgsNew).StartRow, (e as WebQueryEventArgsNew).EndRow); } } else { this.QueryEvent(sender, e); } }
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)); 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 List <string> fixedColumnList = new List <string>(); fixedColumnList.Add("ErrorLocation"); if (dataSource == null || dataSource.Length <= 0) { this.gridWebGrid.Visible = false; this.columnChart.Visible = false; return; } NewReportDomainObject[] newReportDomainObject = new NewReportDomainObject[dataSource.Length]; for (int i = 0; i < dataSource.Length; i++) { NewReportDomainObject domainObject = new NewReportDomainObject(); domainObject.ErrorCause = ((QDOTSInfo)dataSource[i]).ErrorCauseDesc; domainObject.ErrorLocation = ((QDOTSInfo)dataSource[i]).ErrorLocation; domainObject.Quantity = ((QDOTSInfo)dataSource[i]).Quantity; newReportDomainObject[i] = domainObject; } if (this.rblVisibleStyle.SelectedValue.ToUpper() == VisibleStyle.Pivot.ToUpper()) { this.columnChart.Visible = false; List <ReportGridDim3Property> dim3PropertyList = new List <ReportGridDim3Property>(); dim3PropertyList.Add(new ReportGridDim3Property("Quantity", "0", "SUM", "SUM", false)); ReportGridHelper reportGridHelper = new ReportGridHelper(this.DataProvider, this.languageComponent1, this.gridWebGrid); reportGridHelper.DataSource = newReportDomainObject; reportGridHelper.Dim1PropertyList = fixedColumnList; reportGridHelper.Dim3PropertyList = dim3PropertyList; reportGridHelper.HasDim3PropertyNameRowColumn = true; reportGridHelper.ShowGrid(); this.gridWebGrid.Columns[2].Header.Caption = languageComponent1.GetString("ErrorCauseDesc"); this.gridWebGrid.Visible = true; } if (this.rblVisibleStyle.SelectedValue.ToUpper() == VisibleStyle.Chart.ToUpper()) { this.gridWebGrid.Visible = false; //设置首页报表的大小 if (ViewState["Width"] != null) { columnChart.Width = int.Parse(ViewState["Width"].ToString()); } if (ViewState["Height"] != null) { columnChart.Height = int.Parse(ViewState["Height"].ToString()); } //end DataTable dataTableColumn = new DataTable(); dataTableColumn.Columns.Add("Names", typeof(System.String)); dataTableColumn.Columns.Add(" ", typeof(System.Int32)); for (int i = 0; i < newReportDomainObject.Length; i++) { dataTableColumn.Rows.Add(new object[] { newReportDomainObject[i].ErrorLocation, newReportDomainObject[i].Quantity }); } this.columnChart.DataType = true; this.columnChart.YLabelFormatString = "<DATA_VALUE:0.##>"; this.columnChart.ChartTextFormatString = "<DATA_VALUE:0.##>"; this.columnChart.ColumnDataSource = dataTableColumn; this.columnChart.DataBindTable(); this.columnChart.Visible = true; } }