protected override void DoQuery()
{
base.DoQuery();
if (this.CheckBeforeQuery())
{
this.AutoRefresh = this.chbRefreshAuto.Checked;
string byTimeType = this.UCGroupConditions1.UserSelectByTimeType.Trim().ToLower();
string exceptionOrDuty = UCGroupConditions1.UserExceptionOrDuty;
string dataField = "ExceptionCode";
if (exceptionOrDuty == NewReportExceptionOrDuty.Exception)
{
dataField = "ExceptionDesc";
}
else if (exceptionOrDuty == NewReportExceptionOrDuty.Duty)
{
dataField = "DutyDesc";
}
object[] dateSource = null;
//一般数据
dateSource = this.LoadDataSource();
if (dateSource == null || dateSource.Length <= 0)
{
this.gridWebGrid.Visible = false;
//this.OWCChartSpace1.Display = false;
this.columnChart.Visible = false;
this.pieChart.Visible = false;
this.cmdGridExport.Visible = false;
ReportPageHelper.SetPageScrollToBottom(this);
return;
}
//数据加载到Grid
List <string> fixedColumnList = GetRows();
fixedColumnList.AddRange(GetColumns());
List <string> columnPropertyListForGrid = new List <string>();
List <ReportGridDim3Property> dim3PropertyList = new List <ReportGridDim3Property>();
columnPropertyListForGrid.Add(dataField);
if (UCQueryDataType1.GetQueryDataType() == NewReportQueryDataType.DataNumber)
{
dim3PropertyList.Add(new ReportGridDim3Property("LostManHour", "0.0000", "SUM", "SUM", false));
}
else
{
dim3PropertyList.Add(new ReportGridDim3Property("LostManHourPercent", "0.00%", "SUM", "SUM", false));
}
ReportGridHelperNew reportGridHelper = new ReportGridHelperNew(this.DataProvider, this.languageComponent1, this.gridWebGrid, DtSource);
reportGridHelper.DataSource = dateSource;
reportGridHelper.Dim1PropertyList = fixedColumnList;
reportGridHelper.Dim2PropertyList = columnPropertyListForGrid;
reportGridHelper.Dim3PropertyList = dim3PropertyList;
reportGridHelper.HasDim3PropertyNameRowColumn = true;
reportGridHelper.ByTimeType = byTimeType;
reportGridHelper.ShowGrid();
reportGridHelper.AddPercentByRow(false, "0.00%");
base.InitWebGrid();
this.gridWebGrid.Behaviors.RowSelectors.RowNumbering = false;
this.gridWebGrid.Behaviors.Sorting.Enabled = false;
//修正最后的汇总列里面数据（接近100修改为100）
if (UCQueryDataType1.GetQueryDataType() == NewReportQueryDataType.DataRate)
{
if (this.gridWebGrid.Rows.Count > 0 && this.gridWebGrid.Columns.Count > 0)
{
string sumCellText = this.gridWebGrid.Rows[this.gridWebGrid.Rows.Count - 1].Items[this.gridWebGrid.Columns.Count - 1].Text.Trim();
if (sumCellText.Length > 0 && sumCellText.IndexOf("%") == sumCellText.Length - 1)
{
this.gridWebGrid.Rows[this.gridWebGrid.Rows.Count - 1].Items[this.gridWebGrid.Columns.Count - 1].Text = "100.00%";
}
}
if (this.gridWebGrid.Rows.Count == 2 && this.gridWebGrid.Columns.Count > 0)
{
string sumCellText = this.gridWebGrid.Rows[0].Items[this.gridWebGrid.Columns.Count - 1].Text.Trim();
if (sumCellText.Length > 0 && sumCellText.IndexOf("%") == sumCellText.Length - 1)
{
this.gridWebGrid.Rows[0].Items[this.gridWebGrid.Columns.Count - 1].Text = "100.00%";
}
}
}
//获取表格和图示
if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.Grid)
{
this.gridWebGrid.Visible = true;
//this.OWCChartSpace1.Display = false;
this.pieChart.Visible = false;
this.columnChart.Visible = false;
this.cmdGridExport.Visible = true;
}
else if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.LineChart ||
UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.PieChart ||
UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.HistogramChart)
{
List <string> rowPropertyList = new List <string>();
rowPropertyList.Add(dataField);
List <string> columnPropertyList = GetRows();
columnPropertyList.AddRange(GetColumns());
List <string> dataPropertyList = new List <string>();
dataPropertyList.Add("LostManHourPercent");
NewReportDomainObject[] dateSourceForOWC = new NewReportDomainObject[dateSource.Length];
dateSource.CopyTo(dateSourceForOWC, 0);
//针对于饼图，数据源只使用最下面的汇总行的数据
if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.PieChart)
{
int count = this.gridWebGrid.Columns.Count - fixedColumnList.Count - 2;
dateSourceForOWC = new NewReportDomainObject[count];
float totalErrorCount = GetFloatFromGrid(this.gridWebGrid.Rows[this.gridWebGrid.Rows.Count - 1].Items[this.gridWebGrid.Columns.Count - 1].Text);
for (int i = fixedColumnList.Count + 1; i < this.gridWebGrid.Columns.Count - 1; i++)
{
NewReportDomainObject domainObject = new NewReportDomainObject();
if (exceptionOrDuty == NewReportExceptionOrDuty.Exception)
{
domainObject.ExceptionDesc = this.gridWebGrid.Columns[i].Header.Text;
}
else if (exceptionOrDuty == NewReportExceptionOrDuty.Duty)
{
domainObject.DutyDesc = this.gridWebGrid.Columns[i].Header.Text;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Period)
{
domainObject.PeriodCode = this.gridWebGrid.Columns[i].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Shift)
{
domainObject.ShiftCode = this.gridWebGrid.Columns[i].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.ShiftDay)
{
domainObject.ShiftDay = this.gridWebGrid.Columns[i].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Week)
{
domainObject.Week = this.gridWebGrid.Columns[i].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Month)
{
domainObject.Month = this.gridWebGrid.Columns[i].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Year)
{
domainObject.Year = this.gridWebGrid.Columns[i].Header.Text;;
}
float errorCount = GetFloatFromGrid(this.gridWebGrid.Rows[this.gridWebGrid.Rows.Count - 1].Items[i].Text);
domainObject.LostManHourPercent = errorCount / totalErrorCount;
dateSourceForOWC[i - fixedColumnList.Count - 1] = domainObject;
}
columnPropertyList.Clear();
rowPropertyList.Clear();
rowPropertyList.Add(dataField);
}
else
{
int countRow = this.gridWebGrid.Rows.Count - 1;
int countColumn = this.gridWebGrid.Columns.Count - fixedColumnList.Count - 2;
dateSourceForOWC = new NewReportDomainObject[countRow * countColumn];
Type t = typeof(NewReportDomainObject);
for (int i = 0; i < this.gridWebGrid.Rows.Count - 1; i++)
{
float totalErrorCount = GetFloatFromGrid(this.gridWebGrid.Rows[i].Items[this.gridWebGrid.Columns.Count - 1].Text);
for (int j = fixedColumnList.Count + 1; j < this.gridWebGrid.Columns.Count - 1; j++)
{
//NewReportDomainObject domainObject = (NewReportDomainObject)dateSourceForOWC[i * countColumn + (j - fixedColumnList.Count - 1)];//new NewReportDomainObject();
NewReportDomainObject domainObject = new NewReportDomainObject();
for (int k = 0; k < fixedColumnList.Count; k++)
{
t.GetField(fixedColumnList[k]).SetValue(domainObject, this.gridWebGrid.Rows[i].Items[k].Text);
}
if (exceptionOrDuty == NewReportExceptionOrDuty.Exception)
{
domainObject.ExceptionDesc = this.gridWebGrid.Columns[j].Header.Text;
}
else if (exceptionOrDuty == NewReportExceptionOrDuty.Duty)
{
domainObject.DutyDesc = this.gridWebGrid.Columns[j].Header.Text;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Period)
{
domainObject.PeriodCode = this.gridWebGrid.Columns[j].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Shift)
{
domainObject.ShiftCode = this.gridWebGrid.Columns[j].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.ShiftDay)
{
domainObject.ShiftDay = this.gridWebGrid.Columns[j].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Week)
{
domainObject.Week = this.gridWebGrid.Columns[j].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Month)
{
domainObject.Month = this.gridWebGrid.Columns[j].Header.Text;;
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Year)
{
domainObject.Year = this.gridWebGrid.Columns[j].Header.Text;;
}
float errorCount = GetFloatFromGrid(this.gridWebGrid.Rows[i].Items[j].Text);
domainObject.LostManHourPercent = errorCount / totalErrorCount;
//dateSourceForOWC[i - fixedColumnList.Count - 1] = domainObject;
dateSourceForOWC[i * countColumn + (j - fixedColumnList.Count - 1)] = domainObject;
}
}
}
string propertyName = this.languageComponent1.GetString(dataPropertyList[0]);
foreach (NewReportDomainObject domainObject in dateSourceForOWC)
{
domainObject.EAttribute1 = propertyName + domainObject.EAttribute1;
}
foreach (NewReportDomainObject obj in dateSourceForOWC)
{
obj.TempValue = obj.LostManHourPercent.ToString();
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Period)
{
obj.PeriodCode = obj.PeriodCode.ToString();
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Shift)
{
obj.PeriodCode = obj.ShiftCode.ToString();
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.ShiftDay)
{
obj.PeriodCode = obj.ShiftDay.ToString();
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Week)
{
obj.PeriodCode = obj.Week.ToString();
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Month)
{
obj.PeriodCode = obj.Month.ToString();
}
if (UCGroupConditions1.UserSelectByTimeType == NewReportByTimeType.Year)
{
obj.PeriodCode = obj.Year.ToString();
}
}
if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.PieChart)
{
this.columnChart.Visible = false;
this.pieChart.Visible = true;
pieChart.ChartGroupByString = UCGroupConditions1.GetCheckedColumnsString();
//设置首页报表的大小
if (ViewState["Width"] != null)
{
pieChart.Width = int.Parse(ViewState["Width"].ToString());
}
if (ViewState["Height"] != null)
{
pieChart.Height = int.Parse(ViewState["Height"].ToString());
}
//end
this.pieChart.ChartTextFormatString = "<DATA_VALUE:0.00%>";
this.pieChart.YLabelFormatString = "<DATA_VALUE:0.##%>";
this.pieChart.DataType = true;
this.pieChart.DataSource = dateSourceForOWC;
this.pieChart.DataBind();
}
else if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.HistogramChart)
{
this.columnChart.Visible = true;
this.pieChart.Visible = false;
columnChart.ChartGroupByString = UCGroupConditions1.GetCheckedColumnsString();
//设置首页报表的大小
if (ViewState["Width"] != null)
{
columnChart.Width = int.Parse(ViewState["Width"].ToString());
}
if (ViewState["Height"] != null)
{
columnChart.Height = int.Parse(ViewState["Height"].ToString());
}
//end
this.columnChart.ChartTextFormatString = "<DATA_VALUE:#0.##%>";
this.columnChart.YLabelFormatString = "<DATA_VALUE:#0.##%>";
this.columnChart.DataType = true;
this.columnChart.DataSource = dateSourceForOWC;
this.columnChart.DataBind();
}
else
{
this.columnChart.Visible = false;
this.pieChart.Visible = false;
}
this.gridWebGrid.Visible = false;
//this.OWCChartSpace1.Display = true;
this.cmdGridExport.Visible = false;
}
ReportPageHelper.SetPageScrollToBottom(this);
}
else
{
this.chbRefreshAuto.Checked = false;
this.AutoRefresh = false;
}
}
private void DoQuery()
{
if (this.CheckBeforeQuery())
{
this.AutoRefresh = this.chbRefreshAuto.Checked;
string compareType = this.UCGroupConditions1.UserSelectCompareType.Trim().ToLower();
string byTimeType = this.UCGroupConditions1.UserSelectByTimeType.Trim().ToLower();
string inputOutput = this.UCWhereConditions1.UserSelectInputOutput.Trim().ToLower();
object[] dateSource = null;
object[] dateSourceCompare = null;
//一般数据
dateSource = this.LoadDataSource(false, compareType.Trim().Length > 0);
if (dateSource == null || dateSource.Length <= 0)
{
this.gridWebGrid.Visible = false;
//this.OWCChartSpace1.Display = false;
this.cmdGridExport.Visible = false;
this.columnChart.Visible = false;
this.pieChart.Visible = false;
ReportPageHelper.SetPageScrollToBottom(this);
return;
}
//环比/同期比数据
if (compareType.Trim().Length > 0)
{
dateSourceCompare = this.LoadDataSource(true, true);
}
if (dateSourceCompare == null)
{
dateSourceCompare = new NewReportDomainObject[0] {
};
}
//数据加载到Grid
List <string> fixedColumnList = GetRows();
List <string> columnPropertyListForGrid = new List <string>();
List <ReportGridDim3Property> dim3PropertyList = new List <ReportGridDim3Property>();
columnPropertyListForGrid.Add("DutyDesc");
if (UCQueryDataType1.GetQueryDataType() == NewReportQueryDataType.DataNumber)
{
dim3PropertyList.Add(new ReportGridDim3Property("ErrorCount", "0", "SUM", "SUM", false));
}
else
{
dim3PropertyList.Add(new ReportGridDim3Property("ErrorPercent", "0.00%", "SUM", "SUM", false));
}
ReportGridHelperNew reportGridHelper = new ReportGridHelperNew(this.DataProvider, this.languageComponent1, this.gridWebGrid, DtSource);
reportGridHelper.DataSource = dateSource;
reportGridHelper.DataSourceForCompare = dateSourceCompare;
reportGridHelper.Dim1PropertyList = fixedColumnList;
reportGridHelper.Dim2PropertyList = columnPropertyListForGrid;
reportGridHelper.Dim3PropertyList = dim3PropertyList;
reportGridHelper.HasDim3PropertyNameRowColumn = true;
reportGridHelper.CompareType = compareType;
reportGridHelper.ByTimeType = byTimeType;
reportGridHelper.ShowGrid();
reportGridHelper.AddPercentByRow(false, "0.00%");
//修正最后的汇总列里面数据（接近100修改为100）
if (UCQueryDataType1.GetQueryDataType() == NewReportQueryDataType.DataRate)
{
if (this.gridWebGrid.Rows.Count > 0 && this.gridWebGrid.Columns.Count > 0)
{
string sumCellText = this.gridWebGrid.Rows[this.gridWebGrid.Rows.Count - 1].Items[this.gridWebGrid.Columns.Count - 1].Text.Trim();
if (sumCellText.Length > 0 && sumCellText.IndexOf("%") == sumCellText.Length - 1)
{
this.gridWebGrid.Rows[this.gridWebGrid.Rows.Count - 1].Items[this.gridWebGrid.Columns.Count - 1].Text = "100.00%";
}
}
if (this.gridWebGrid.Rows.Count == 2 && this.gridWebGrid.Columns.Count > 0)
{
string sumCellText = this.gridWebGrid.Rows[0].Items[this.gridWebGrid.Columns.Count - 1].Text.Trim();
if (sumCellText.Length > 0 && sumCellText.IndexOf("%") == sumCellText.Length - 1)
{
this.gridWebGrid.Rows[0].Items[this.gridWebGrid.Columns.Count - 1].Text = "100.00%";
}
}
}
//获取表格和图示
if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.Grid)
{
this.gridWebGrid.Visible = true;
//this.OWCChartSpace1.Display = false;
this.cmdGridExport.Visible = true;
this.columnChart.Visible = false;
this.pieChart.Visible = false;
}
else if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.LineChart ||
UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.PieChart ||
UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.HistogramChart)
{
List <string> rowPropertyList = GetColumns();
rowPropertyList.Add("DutyDesc");
List <string> columnPropertyList = GetRows();
columnPropertyList.Add("EAttribute1");
List <string> dataPropertyList = new List <string>();
dataPropertyList.Add("ErrorPercent");
NewReportDomainObject[] dateSourceForOWC = new NewReportDomainObject[dateSource.Length + dateSourceCompare.Length];
dateSource.CopyTo(dateSourceForOWC, 0);
for (int i = 0; i < dateSourceCompare.Length; i++)
{
dateSourceForOWC[dateSource.Length + i] = (NewReportDomainObject)dateSourceCompare[i];
}
//针对于饼图，数据源只使用最下面的汇总行的数据
if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.PieChart)
{
int count = this.gridWebGrid.Columns.Count - fixedColumnList.Count - 2;
dateSourceForOWC = new NewReportDomainObject[count];
float totalErrorCount = GetFloatFromGrid(this.gridWebGrid.Rows[this.gridWebGrid.Rows.Count - 1].Items[this.gridWebGrid.Columns.Count - 1].Text);
for (int i = fixedColumnList.Count + 1; i < this.gridWebGrid.Columns.Count - 1; i++)
{
NewReportDomainObject domainObject = new NewReportDomainObject();
domainObject.DutyDesc = this.gridWebGrid.Columns[i].Header.Text;
float errorCount = GetFloatFromGrid(this.gridWebGrid.Rows[this.gridWebGrid.Rows.Count - 1].Items[i].Text);
domainObject.ErrorPercent = errorCount / totalErrorCount;
dateSourceForOWC[i - fixedColumnList.Count - 1] = domainObject;
}
columnPropertyList.Clear();
rowPropertyList.Clear();
rowPropertyList.Add("DutyDesc");
}
else
{
int countRow = this.gridWebGrid.Rows.Count - 1;
int countColumn = this.gridWebGrid.Columns.Count - fixedColumnList.Count - 2;
dateSourceForOWC = new NewReportDomainObject[countRow * countColumn];
Type t = typeof(NewReportDomainObject);
for (int i = 0; i < this.gridWebGrid.Rows.Count - 1; i++)
{
float totalErrorCount = GetFloatFromGrid(this.gridWebGrid.Rows[i].Items[this.gridWebGrid.Columns.Count - 1].Text);
for (int j = fixedColumnList.Count + 1; j < this.gridWebGrid.Columns.Count - 1; j++)
{
NewReportDomainObject domainObject = new NewReportDomainObject();
for (int k = 0; k < fixedColumnList.Count; k++)
{
t.GetField(fixedColumnList[k]).SetValue(domainObject, this.gridWebGrid.Rows[i].Items[k].Text);
}
domainObject.DutyDesc = this.gridWebGrid.Columns[j].Header.Text;
float errorCount = GetFloatFromGrid(this.gridWebGrid.Rows[i].Items[j].Text);
domainObject.ErrorPercent = errorCount / totalErrorCount;
dateSourceForOWC[i * countColumn + (j - fixedColumnList.Count - 1)] = domainObject;
}
}
}
string propertyName = this.languageComponent1.GetString(dataPropertyList[0]);
foreach (NewReportDomainObject domainObject in dateSourceForOWC)
{
domainObject.EAttribute1 = propertyName + domainObject.EAttribute1;
}
//ReportChartHelper reportChartHelper = new ReportChartHelper(this.OWCPivotTable1, this.OWCChartSpace1, this.languageComponent1);
//reportChartHelper.DataSource = dateSourceForOWC;
//reportChartHelper.RowPropertyList = rowPropertyList.ToArray();
//reportChartHelper.ColumnPropertyList = columnPropertyList.ToArray();
//reportChartHelper.DataPropertyList = dataPropertyList.ToArray();
//reportChartHelper.UserOWCChartType = UCDisplayConditions1.GetDisplayType().Trim().ToLower();
//reportChartHelper.IsPercent = true;
//reportChartHelper.LoadOWCChart();
foreach (NewReportDomainObject obj in dateSourceForOWC)
{
obj.TempValue = obj.ErrorPercent.ToString();
obj.PeriodCode = obj.DutyDesc.ToString();
}
if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.HistogramChart)
{
this.columnChart.Visible = true;
this.pieChart.Visible = false;
columnChart.ChartGroupByString = UCGroupConditions1.GetCheckedColumnsString();
//设置首页报表的大小
if (ViewState["Width"] != null)
{
columnChart.Width = int.Parse(ViewState["Width"].ToString());
}
if (ViewState["Height"] != null)
{
columnChart.Height = int.Parse(ViewState["Height"].ToString());
}
//end
this.columnChart.ChartTextFormatString = "<DATA_VALUE:#0.##%>";
this.columnChart.YLabelFormatString = "<DATA_VALUE:#0.##%>";
this.columnChart.DataType = true;
this.columnChart.DataSource = dateSourceForOWC;
this.columnChart.DataBind();
}
else if (UCDisplayConditions1.GetDisplayType().Trim().ToLower() == NewReportDisplayType.PieChart)
{
this.columnChart.Visible = false;
this.pieChart.Visible = true;
pieChart.ChartGroupByString = UCGroupConditions1.GetCheckedColumnsString();
//设置首页报表的大小
if (ViewState["Width"] != null)
{
pieChart.Width = int.Parse(ViewState["Width"].ToString());
}
if (ViewState["Height"] != null)
{
pieChart.Height = int.Parse(ViewState["Height"].ToString());
}
//end
this.pieChart.ChartTextFormatString = "<DATA_VALUE:#0.##%>";
this.pieChart.YLabelFormatString = "<DATA_VALUE:#0.##%>";
this.pieChart.DataType = true;
this.pieChart.DataSource = dateSourceForOWC;
this.pieChart.DataBind();
}
else
{
this.columnChart.Visible = false;
this.pieChart.Visible = false;
}
this.gridWebGrid.Visible = false;
//this.OWCChartSpace1.Display = true;
this.cmdGridExport.Visible = false;
}
ReportPageHelper.SetPageScrollToBottom(this);
}
else
{
this.chbRefreshAuto.Checked = false;
this.AutoRefresh = false;
}
}
