private void button_CalUnitNum_Click(object sender, EventArgs e)
{
label_CalUnit.Text = "计算中……";
label_CalUnit.Refresh();
SqlGenerator sg = new SqlGenerator();
string csql = sg.GenGSetSql(GSetSqlType.CalUnitNum, science, item, unitcode, abtype, abtype2, stationid, instr, checkBox_NationGood.Checked, checkBox_AreaGood.Checked, checkBox_ScienceGood.Checked, dateTimePicker_Begin.Value, dateTimePicker_End.Value, checkBox_BeginTrim.Checked ? dateTimePicker_Begin.Value : (DateTime?)null, checkBox_EndTrim.Checked ? dateTimePicker_End.Value : (DateTime?)null);
DataTable dt = orah.GetDataTable(csql);
int sum = 0;
foreach (DataRow r in this.dt_units.Rows)
{
DataTableHelper dth = new DataTableHelper();
int? num = dth.ExtractRowByLeftFirstCol_Int(dt, r["UNIT_CODE"].ToString());
if (num == null)
r["NUM"] = DBNull.Value;
else
{
r["NUM"] = num;
sum += (int)num;
}
}
label_CalUnit.Text = sum.ToString();
dataGridView_Unit.Sort(dataGridView_Unit.Columns["NUM"], ListSortDirection.Descending);
// this.dv .Sort = "num desc";
richTextBox_Debug.Text += csql + "\n";
}
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("写入完毕");
}