private void Button_Query_Click(object sender, EventArgs e)
{
ProgressScreen.Current.ShowSplashScreen();
ProgressScreen.Current.SetStatus = "正在获取数据...";
FpSpread_Info.OperationMode = OperationMode.ReadOnly;
DateTime StartDate = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", DateTimePicker_Start.Value.Year, DateTimePicker_Start.Value.Month, DateTimePicker_Start.Value.Day));
DateTime EndDate = DateTime.Parse(string.Format("{0}-{1}-{2} 23:59:59", DateTimePicker_End.Value.Year, DateTimePicker_End.Value.Month, DateTimePicker_End.Value.Day));
string BGBH = txtBGBH.Text.Trim();
DataTable Data = PXJZReportDataList.GetPXReportRelation(PXTestRoomCode, ModuleID, StartDate, EndDate, BGBH);
if (Data != null)
{
//BizComponents.TextCellType text = new BizComponents.TextCellType();
//text.ReadOnly = false;
FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
FpSpread_Info.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
for (int i = 0; i < Data.Rows.Count; i++)
{
FpSpread_Info.Rows[i].HorizontalAlignment = CellHorizontalAlignment.Center;
for (int j = 0; j < FpSpread_Info.ColumnHeader.Columns.Count; j++)
{
String v = Data.Rows[i][j].ToString();
FpSpread_Info.Cells[i, j].Value = v;
FpSpread_Info.Cells[i, j].Locked = false;
//FpSpread_Info.Cells[i, j].CellType = text;
}
}
}
else
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
MessageBox.Show("无数据，请重新选择条件!");
}
}
else
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
MessageBox.Show("无数据，请重新选择条件!");
}
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
if (Data == null)
{
TotalCount.Text = string.Format("共 {0} 条记录", 0);
}
else
{
TotalCount.Text = string.Format("共 {0} 条记录", Data.Rows.Count);
}
}
private void tsmiResetPXRelation_Click(object sender, EventArgs e)
{
if (MessageBox.Show("您是否确定生成对应的平行关系？", "确认操作", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Row Row = spread_stadium_Sheet1.ActiveRow;
if (Row != null && Row.Tag is String)
{
String[] Tokens = Row.Tag.ToString().Split(',');
Guid PXDataID = new Guid(Tokens[0]);
int flag = PXJZReportDataList.GeneratePXRelation(SGDataID, PXDataID);
if (flag == 1)
{
MessageBox.Show("平行对应关系生成成功,请到平行关系对应查询中查看！");
this.Close();
}
else
{
MessageBox.Show("平行对应关系生成失败，请稍后再试！");
}
}
}
}
//柱状原始
private void PXChart_Load(object sender, EventArgs e)
{
tChart1.Text = modelName;
this.Text = modelName;
bar1.Title = "自检";
line1.Title = "平行";
tChart1.Chart.Aspect.View3D = false;
tChart1.Axes.Bottom.Title.Text = "时间";
tChart1.Axes.Left.Title.Text = "数量（个）";
Data = PXJZReportDataList.GetPXJZReportChart(testRoomID, start, end, modelID);
if (Data != null)
{
bar1.CustomBarWidth = 5;
tChart1.Axes.Left.Minimum = 0;
tChart1.Axes.Left.Increment = 1;
line1.LinePen.Width = 3;
line1.Marks.Visible = true;
tChart1.Axes.Bottom.Increment = 1;
tChart1.Axes.Bottom.Labels.DateTimeFormat = "yyyy-MM-dd";
tChart1.Axes.Bottom.Automatic = true;
foreach (DataRow item in Data.Rows)
{
bar1.Add(DateTime.Parse(item["chartDate"].ToString()), Int32.Parse(item["zjCount"].ToString()), Color.Green);
line1.Add(DateTime.Parse(item["chartDate"].ToString()), Int32.Parse(item["pxjzCount"].ToString()), Color.Red);
}
}
tChart1.Axes.Bottom.Labels.Angle = 270; //设置时间横向和竖向
bar1.Color = Color.Green;
line1.Color = Color.Red;
Double result = GetQulify(Data, start, end, count);
label1.Text = "平行频率质量系数：" + ((Int32)result).ToString();
label3.Text = "平行频率(%)：" + frequency;
}
private void Button_Query_Click(object sender, EventArgs e)
{
ProgressScreen.Current.ShowSplashScreen();
ProgressScreen.Current.SetStatus = "正在获取数据...";
FpSpread_Info.OperationMode = OperationMode.ReadOnly;
String segment = "";
String company = "";
String testroom = "";
if (ComboBox_Segments.SelectedItem is Prjsct)
{
segment = (ComboBox_Segments.SelectedItem as Prjsct).PrjsctCode;
}
if (ComboBox_Company.SelectedItem is Orginfo)
{
company = (ComboBox_Company.SelectedItem as Orginfo).DepCode;
}
if (ComboBox_TestRooms.SelectedItem is PrjFolder)
{
testroom = (ComboBox_TestRooms.SelectedItem as PrjFolder).FolderCode;
}
DateTime StartDate = DateTime.Parse(string.Format("{0}-{1}-{2} 00:00:00", DateTimePicker_Start.Value.Year, DateTimePicker_Start.Value.Month, DateTimePicker_Start.Value.Day));
DateTime EndDate = DateTime.Parse(string.Format("{0}-{1}-{2} 23:59:59", DateTimePicker_End.Value.Year, DateTimePicker_End.Value.Month, DateTimePicker_End.Value.Day));
DataTable Data = PXJZReportDataList.GetJZReportInfos(segment, company, testroom, StartDate, EndDate);
if (Data != null)
{
FpSpread.ShowRow(FpSpread.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
FpSpread_Info.Rows.Count = Data.Rows.Count;
if (Data.Rows.Count > 0)
{
for (int i = 0; i < Data.Rows.Count; i++)
{
FpSpread_Info.Rows[i].HorizontalAlignment = CellHorizontalAlignment.Center;
for (int j = 0; j < FpSpread_Info.ColumnHeader.Columns.Count; j++)
{
String v = Data.Rows[i][FpSpread_Info.ColumnHeader.Cells[0, j].Tag.ToString()].ToString();
FpSpread_Info.Cells[i, j].Value = v;
if (v == "不满足")
{
FpSpread_Info.Rows[i].BackColor = Color.FromArgb(255, 192, 192);
}
else
{
FpSpread_Info.Rows[i].BackColor = Color.FromName(System.Drawing.KnownColor.Control.ToString());
}
}
}
}
else
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
MessageBox.Show("无数据，请重新选择条件!");
}
}
else
{
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
MessageBox.Show("无数据，请重新选择条件!");
}
ProgressScreen.Current.CloseSplashScreen();
this.Activate();
if (Data == null)
{
TotalCount.Text = string.Format("共 {0} 条记录", 0);
}
else
{
TotalCount.Text = string.Format("共 {0} 条记录", Data.Rows.Count);
}
}
private void BindPXBGData()
{
DataTable Data = PXJZReportDataList.GetEnPXedReport(ModuleID, txtBGBH.Text.Trim());
if (Data != null && Data.Rows.Count > 0)
{
spread_stadium.ShowRow(spread_stadium.GetActiveRowViewportIndex(), 0, VerticalPosition.Top);
spread_stadium_Sheet1.Rows.Count = Data.Rows.Count;
int HiddenColumnCount = 2;
spread_stadium_Sheet1.Columns.Count = Data.Columns.Count - HiddenColumnCount;
if (spread_stadium_Sheet1.Columns.Count > 0)
{
spread_stadium_Sheet1.Columns[0].Width = 60;
spread_stadium_Sheet1.Columns[1].Width = 100;
spread_stadium_Sheet1.Columns[2].Width = 80;
spread_stadium_Sheet1.Columns[3].Width = 80;
spread_stadium_Sheet1.Columns[4].Width = 60;
spread_stadium_Sheet1.Columns[5].Width = 60;
spread_stadium_Sheet1.Columns[6].Width = 80;
spread_stadium_Sheet1.Columns[7].Width = 80;
//spread_stadium_Sheet1.Columns[8].Width = 80;
//spread_stadium_Sheet1.Columns[9].Width = 80;
}
DateTimeCellType datetime = new DateTimeCellType();
datetime.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
FarPoint.Win.Spread.CellType.TextCellType text = new FarPoint.Win.Spread.CellType.TextCellType();
text.Multiline = true;
text.WordWrap = true;
spread_stadium_Sheet1.Columns[7].CellType = datetime;
//spread_stadium_Sheet1.Columns[0].Visible = false;
//spread_stadium_Sheet1.Columns[1].Visible = false;
spread_stadium_Sheet1.Rows.Count = Data.Rows.Count;
int i, j;
foreach (System.Data.DataColumn Column in Data.Columns)
{
if (Column.ColumnName == "ID" || Column.ColumnName == "ModuleID")
{
continue;
}
i = Data.Columns.IndexOf(Column);
spread_stadium_Sheet1.Columns[i - HiddenColumnCount].VerticalAlignment = CellVerticalAlignment.Center;
spread_stadium_Sheet1.Columns[i - HiddenColumnCount].Label = Column.ColumnName;
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_stadium_Sheet1.Rows[j].HorizontalAlignment = CellHorizontalAlignment.Center;
spread_stadium_Sheet1.Cells[j, i - HiddenColumnCount].Value = Row[Column.ColumnName].ToString();
}
}
foreach (DataRow Row in Data.Rows)
{
j = Data.Rows.IndexOf(Row);
spread_stadium_Sheet1.Rows[j].Tag = Row["ID"].ToString() + "," + Row["ModuleID"].ToString();
}
spread_stadium.CellDoubleClick -= new CellClickEventHandler(spread_stadium_CellDoubleClick);
spread_stadium.CellDoubleClick += new CellClickEventHandler(spread_stadium_CellDoubleClick);
}
else
{
MessageBox.Show("未找到数据，请检查委托/报告编号是否正确；或打开重新保存资料！");
}
}