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"; }