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