private void cmbMonth_TextChanged(object sender, EventArgs e) { recDataTable = new DataTable(); recDataTable.Columns.Add("pId"); recDataTable.Columns.Add("设备编号"); recDataTable.Columns.Add("eiId"); recDataTable.Columns.Add("工时"); costDetachDB db = new costDetachDB(); DataTable dt = new DataTable(); switch (formSort) { case 1: dt = db.SelectbitumenDetachParameter(cmbYear.Text, cmbMonth.Text, 1); dataGridView1.DataSource = dt; dataGridView1.Columns["pid"].Visible = false; break; case 2: dt = db.SelectbitumenDetachParameter(cmbYear.Text, cmbMonth.Text, 2); dataGridView1.DataSource = dt; dataGridView1.Columns["pid"].Visible = false; break; case 3: dt = db.SelectbitumenDetachParameter(cmbYear.Text, cmbMonth.Text, 3); dataGridView1.DataSource = dt; dataGridView1.Columns["pid"].Visible = false; break; } }
private void FormInit() { recDataTable = new DataTable(); recDataTable.Columns.Add("pId"); recDataTable.Columns.Add("设备编号"); recDataTable.Columns.Add("eiId"); recDataTable.Columns.Add("工时"); cmbYear.Text = year; cmbMonth.Text = month; costDetachDB db = new costDetachDB(); DataTable dt = new DataTable(); switch (formSort) { case 1: //costDetachDB db = new costDetachDB(); //DataTable dt = new DataTable(); //dt = db.SelectbitumenDetachParameter("2009", "3", 1); dt = db.SelectbitumenDetachParameter(cmbYear.Text, cmbMonth.Text, 1); dataGridView1.DataSource = dt; dataGridView1.Columns["pid"].Visible = false; break; case 2: //costDetachDB db = new costDetachDB(); //DataTable dt = new DataTable(); //dt = db.SelectbitumenDetachParameter("2009", "3", 2); dt = db.SelectbitumenDetachParameter(cmbYear.Text, cmbMonth.Text, 2); dataGridView1.DataSource = dt; dataGridView1.Columns["pid"].Visible = false; break; case 3: //costDetachDB db = new costDetachDB(); //DataTable dt = new DataTable(); //dt = db.SelectbitumenDetachParameter("2009", "3", 3); dt = db.SelectbitumenDetachParameter(cmbYear.Text, cmbMonth.Text, 3); dataGridView1.DataSource = dt; dataGridView1.Columns["pid"].Visible = false; break; } }