private void button1_Click_1(object sender, EventArgs e)
{
if (comboBox1.Text == "类别" && textBox1.Text == "输入编号/名称")
{
}
else if (comboBox1.Text != "类别" && textBox1.Text == "输入编号/名称")
{
rawmaterialdao p = new rawmaterialdao();
List <rawmaterial> rs = new List <rawmaterial>();
rs = p.selectType(comboBox1.Text);
Console.Write(rs);
DataSet ds = new DataSet();
DataTable dt = new DataTable("Table_New");
dt.Columns.Add("类别", typeof(string));
dt.Columns.Add("编号", typeof(string));
dt.Columns.Add("名称", typeof(String));
dt.Columns.Add("数量", typeof(double));
dt.Columns.Add("单位", typeof(String));
foreach (rawmaterial r1 in rs)
{
dt.Rows.Add(r1.Rawmaterial_type, r1.Rawmaterial_number, r1.Rawmaterial_name, r1.Rawmaterial_count, r1.Rawmaterial_unit);
}
dataGridView1.DataSource = dt;
}
else if (comboBox1.Text == "类别" && textBox1.Text != "输入编号/名称")
{
rawmaterialdao p = new rawmaterialdao();
List <rawmaterial> rs = new List <rawmaterial>();
rs = p.selectNumberOrName(textBox1.Text);
Console.Write(rs);
DataSet ds = new DataSet();
DataTable dt = new DataTable("Table_New");
dt.Columns.Add("类别", typeof(string));
dt.Columns.Add("编号", typeof(string));
dt.Columns.Add("名称", typeof(string));
dt.Columns.Add("数量", typeof(double));
dt.Columns.Add("单位", typeof(String));
foreach (rawmaterial r1 in rs)
{
dt.Rows.Add(r1.Rawmaterial_type, r1.Rawmaterial_number, r1.Rawmaterial_name, r1.Rawmaterial_count, r1.Rawmaterial_unit);
}
dataGridView1.DataSource = dt;
}
data = dataGridView1;
}
