private void InputCaiDanHao_Load(object sender, EventArgs e)
{
label1.Text = frmLabel;
//List<ChiMa_Dapeibiao> list = cal.SelectChiMaDapei("").GroupBy(p => p.BiaoName).Select(pc => pc.First()).ToList<ChiMa_Dapeibiao>();
comboBox1.DisplayMember = "BiaoName";
comboBox1.ValueMember = "id";
List <ChiMa_Dapeibiao> list = new List <ChiMa_Dapeibiao>();
ChiMa_Dapeibiao cd = new ChiMa_Dapeibiao()
{
BiaoName = "RGL1",
id = 1
};
ChiMa_Dapeibiao cd1 = new ChiMa_Dapeibiao()
{
BiaoName = "RGL2",
id = 2
};
ChiMa_Dapeibiao cd2 = new ChiMa_Dapeibiao()
{
BiaoName = "SLIM",
id = 3
};
ChiMa_Dapeibiao cd3 = new ChiMa_Dapeibiao()
{
BiaoName = "RGLJ",
id = 4
};
ChiMa_Dapeibiao cd4 = new ChiMa_Dapeibiao()
{
BiaoName = "D.PANT",
id = 5
};
ChiMa_Dapeibiao cd5 = new ChiMa_Dapeibiao()
{
BiaoName = "C.PANT",
id = 6
};
list.Add(cd);
list.Add(cd1);
list.Add(cd2);
list.Add(cd3);
list.Add(cd4);
list.Add(cd5);
comboBox1.DisplayMember = "BiaoName";
comboBox1.ValueMember = "id";
comboBox1.DataSource = list;
List <clsBuiness.KuanShiBiao> cdlist = cal.SelectKuanshi().GroupBy(g => g.STYLE).Select(pc => pc.First()).ToList <clsBuiness.KuanShiBiao>();
textBox1.DataSource = cdlist;
textBox1.DisplayMember = "STYLE";
textBox1.ValueMember = "Id";
}
private void InputCreatYjcb_Load(object sender, EventArgs e)
{
List <JiaGongChang> jgc = df.selectJiaGongChang().GroupBy(j => j.Name).Select(sc => sc.First()).ToList <JiaGongChang>();
comboBox1.DataSource = jgc;
comboBox1.DisplayMember = "Name";
comboBox1.ValueMember = "id";
List <clsBuiness.KuanShiBiao> cdlist = cal.SelectKuanshi().GroupBy(g => g.STYLE).Select(pc => pc.First()).ToList <clsBuiness.KuanShiBiao>();
textBox1.DataSource = cdlist;
textBox1.DisplayMember = "STYLE";
textBox1.ValueMember = "Id";
}
public void bindDataGirdview()
{
List <KuanShiBiao> list = cal.SelectKuanshi();
DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
for (int i = 0; i < dataGridView1.Columns.Count; i++)
{
if (!dataGridView1.Columns[i].HeaderCell.Value.ToString().Equals("Id"))
{
dt.Columns.Add(dataGridView1.Columns[i].HeaderCell.Value.ToString(), typeof(String));
}
}
foreach (KuanShiBiao s in list)
{
dt.Rows.Add(s.Id, s.STYLE, s.DESC, s.FABRIC, s.JACKET, s.PANT, s.mark1, s.ShuoMing, s.mark2);
}
dataGridView1.DataSource = dt;
}
