private void MenuItem_GenCompareDt_Click(object sender, EventArgs e)
{
SaveFileDialog sd = new SaveFileDialog();
sd.Filter = "dt文件|*.dt";
sd.FilterIndex = 1;
if (sd.ShowDialog() != System.Windows.Forms.DialogResult.OK)
{
return;
}
DataTable dt = this.dt_logs.Clone();
foreach (DataGridViewRow r in dataGridView_Logs.Rows)
{
if (r == null || r.DataBoundItem == null)
continue;
DataRow _r = (r.DataBoundItem as DataRowView).Row;
int re = Convert.ToInt32(_r["SCORE_GROUP"]) * 2 + Convert.ToInt32(_r["SCORE_TIME"]) * 2 + Convert.ToInt32(_r["SCORE_LOG"]) + Convert.ToInt32(_r["SCORE_GRAPH"]);
CheckResultHelper cr = new CheckResultHelper();
cr.Fill(this.dt_check, _r["LOG_ID"].ToString());
if (cr.wholeresult[1] != -1 && cr.wholeresult[1] != re)
{
dt.Rows.Add(_r.ItemArray);
}
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.Tables.Add(dt_check.Copy());
ds.Tables.Add(dt_itemloginfo.Copy());
ds.Tables.Add(dt_units_comments.Copy());
ds.Tables.Add(dt_param.Copy());
ds.WriteXml(sd.FileName, XmlWriteMode.WriteSchema);
MessageBox.Show("比较结果输出成功");
}
private void backgroundWorker_ReportWriter_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
{
RefreshStatus("正在生成报表……\n");
ReportWriterParam p = e.Argument as ReportWriterParam;
DataView dv_log = new DataView(p.dt_logs);
DataView dv_units = new DataView(p.dt_units);
// DataTable units = dv_log.ToTable(true, "UNITNAME");
DataTable output = new DataTable();
output.Columns.Add("单位名称");
output.Columns.Add("序号");
output.Columns.Add("事件ID");
output.Columns.Add("台站ID");
output.Columns.Add("台站名称");
output.Columns.Add("测点");
output.Columns.Add("仪器编码");
output.Columns.Add("仪器名称");
output.Columns.Add("起始时间", typeof(DateTime));
output.Columns.Add("结束时间", typeof(DateTime));
output.Columns.Add("事件类型");
output.Columns.Add("事件分类");
output.Columns.Add("事件分类说明");
output.Columns.Add("事件分类得分");
output.Columns.Add("起止时间");
output.Columns.Add("起止时间说明");
output.Columns.Add("起止时间得分");
output.Columns.Add("图件标注");
output.Columns.Add("图件标注说明");
output.Columns.Add("图件标注得分");
output.Columns.Add("事件分析");
output.Columns.Add("事件分析说明");
output.Columns.Add("事件分析得分");
output.Columns.Add("国家中心审核");
output.Columns.Add("区域中心审核");
output.Columns.Add("审核正确率得分");
output.Columns.Add("合计");
int j = 0, h = 0;
for (int k = 0; k < UNIT_NUM.GetLength(0); k++)
{
dv_units.RowFilter = dv_log.RowFilter = "UNIT_CODE = '" + UNIT_NUM[k, 0] + "'";
string u_name;
if (dv_units.Count > 0)
{
u_name = dv_units[0]["UNITNAME"].ToString();
}
else
{
u_name = UNIT_NUM[k, 0].ToString();
}
RefreshStatus("正在生成" + u_name + "……", true);
if (Convert.ToInt32(UNIT_NUM[k, 1]) == 0)
{
DataRow r = output.NewRow();
r["单位名称"] = u_name;
output.Rows.Add(r);
j++;
continue;
}
int i = 0;
double sum_group = 0, sum_time = 0, sum_graph = 0, sum_log = 0, sum_checkright = 0;
h = j;
for (; i < Math.Min(dv_log.Count, Convert.ToInt32(UNIT_NUM[k, 1])); i++, j++)
{
DataRow r = output.NewRow();
r["序号"] = i + 1;
r["事件ID"] = "'" + dv_log[i]["LOG_ID"];
r["台站ID"] = "'" + dv_log[i]["STATIONID"];
r["台站名称"] = "'" + dv_log[i]["STATIONNAME"];
r["测点"] = "'" + dv_log[i]["POINTID"];
r["仪器编码"] = "'" + dv_log[i]["INSTRCODE"];
r["仪器名称"] = dv_log[i]["INSTRNAME"];
r["起始时间"] = dv_log[i]["START_DATE"];
r["结束时间"] = dv_log[i]["END_DATE"];
r["事件类型"] = dv_log[i]["AB_TYPE_NAME"];
int s_group = Convert.ToInt32(dv_log[i]["SCORE_GROUP"]);
r["事件分类"] = s_group == 0 ? "正确" : "错误";
r["事件分类说明"] = dv_log[i]["COMMENTS_GROUP"];
int s_time = Convert.ToInt32(dv_log[i]["SCORE_TIME"]);
r["起止时间"] = s_time == 0 ? "正确" : "错误";
r["起止时间说明"] = dv_log[i]["COMMENTS_TIME"];
int s_graph = Convert.ToInt32(dv_log[i]["SCORE_GRAPH"]);
r["图件标注"] = s_graph == 0 ? "好" : s_graph == 1 ? "中" : "差";
r["图件标注说明"] = dv_log[i]["COMMENTS_GRAPH"];
int s_log = Convert.ToInt32(dv_log[i]["SCORE_LOG"]);
r["事件分析"] = s_log == 0 ? "好" : s_log == 1 ? "中" : "差";
r["事件分析说明"] = dv_log[i]["COMMENTS_LOG"];
int s_whole = s_group * 2 + s_time * 2 + s_graph + s_log;
if (s_whole > 2)
s_whole = 2;
r["国家中心审核"] = s_whole == 0 ? "好" : s_whole == 1 ? "中" : "差";
CheckResultHelper cr = new CheckResultHelper();
cr.Fill(p.dt_check, dv_log[i]["LOG_ID"].ToString());
r["区域中心审核"] = cr.wholeresult[0] == -1 ? "未审核" : (cr.wholeresult[0] == 0 ? "好" : cr.wholeresult[0] == 1 ? "中" : "差");
int s_checkright;
if (((cr.wholeresult[0] == -1 || cr.wholeresult[0] == 0) && s_whole == 2) ||
(cr.wholeresult[0] == 2 && s_whole == 0))
{
s_checkright = 1;
}
else
{
s_checkright = 0;
}
sum_group += 1.0 - s_group;
sum_time += 1.0 - s_time;
sum_graph += 1.0 - s_graph / 2.0;
sum_log += 1.0 - s_log / 2.0;
sum_checkright += 1.0 - s_checkright;
output.Rows.Add(r);
}
if (i > 0)
{
output.Rows[h]["单位名称"] = u_name;
double sum = 0;
output.Rows[h]["事件分类得分"] = sum_group * 2.0 / i;
output.Rows[h]["起止时间得分"] = sum_time * 1.0 / i;
output.Rows[h]["图件标注得分"] = sum_graph * 2.0 / i;
output.Rows[h]["事件分析得分"] = sum_log * 2.0 / i;
output.Rows[h]["审核正确率得分"] = sum_checkright * 1.0 / i;
output.Rows[h]["合计"] = Convert.ToDouble(output.Rows[h]["事件分类得分"]) +
Convert.ToDouble(output.Rows[h]["起止时间得分"]) +
Convert.ToDouble(output.Rows[h]["图件标注得分"]) +
Convert.ToDouble(output.Rows[h]["事件分析得分"]) +
Convert.ToDouble(output.Rows[h]["审核正确率得分"]);
}
for (; i < Convert.ToInt32(UNIT_NUM[k, 1]); i++, j++)
{
DataRow r = output.NewRow();
if (i == 0)
{
r["单位名称"] = u_name;
}
output.Rows.Add(r);
}
}
RefreshStatus("生成完毕", true);
RefreshStatus("正在写入Excel文件……");
DataTableHelper dth = new DataTableHelper();
dth.DTToExcel(output, p.filename);
RefreshStatus("写入完毕");
}