private void RefreshSql()
{
SqlGenerator sg = new SqlGenerator();
richTextBox_Sql.Text = sg.GenGSetSql(GSetSqlType.Normal, 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, richTextBox_Span.Text);
}
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";
}