private void inputMianLiaoDingGou_Load(object sender, EventArgs e) { try { List <clsBuiness.CaiDan> cd = gn.selectCaiDan("").GroupBy(c => new { c.STYLE, c.MianLiao }).Select(s => s.First()).ToList <clsBuiness.CaiDan>(); txt_ks.DataSource = cd; txt_ks.DisplayMember = "STYLE"; txt_ks.ValueMember = "Id"; txt_ml.DataSource = cd; txt_ml.DisplayMember = "MianLiao"; txt_ml.ValueMember = "Id"; List <clsBuiness.CaiDan> cdID = gn.selectCaiDan("").GroupBy(c => new { c.CaiDanHao }).Select(s => s.First()).ToList <clsBuiness.CaiDan>(); cb_cd.DataSource = cdID; cb_cd.DisplayMember = "CaiDanHao"; cb_cd.ValueMember = "Id"; List <JiaGongChang> jgc = dfi.selectJiaGongChang().GroupBy(j => j.Name).Select(s => s.First()).ToList <JiaGongChang>(); cb_jgc.DataSource = jgc; cb_jgc.DisplayMember = "Name"; cb_jgc.ValueMember = "id"; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void InputCaiDanNo_Load(object sender, EventArgs e) { List <clsBuiness.CaiDan> cdlist = gn2.selectCaiDan("").GroupBy(c => c.CaiDanHao).Select(sc => sc.First()).ToList <clsBuiness.CaiDan>(); txt_caidan.DataSource = cdlist; txt_caidan.DisplayMember = "CaiDanHao"; txt_caidan.ValueMember = "Id"; }
private void CaiDan_Load(object sender, EventArgs e) { this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.None; try { DataTable dt = new DataTable(); dt.Columns.Add("Id", typeof(int)); dt.Columns.Add("面料", typeof(string)); dt.Columns.Add("款式", typeof(string)); dt.Columns["款式"].ReadOnly = true; dt.Columns.Add("货号", typeof(string)); dt.Columns.Add("颜色", typeof(string)); dt.Columns.Add("颜色编号", typeof(string)); dt.Columns.Add("裤子", typeof(string)); dt.Columns.Add("28", typeof(string)); dt.Columns.Add("30", typeof(string)); dt.Columns.Add("32", typeof(string)); dt.Columns.Add("34", typeof(string)); dt.Columns.Add("36", typeof(string)); dt.Columns.Add("39", typeof(string)); dt.Columns.Add("41", typeof(string)); dt.Columns.Add("43", typeof(string)); dt.Columns.Add("46", typeof(string)); dt.Columns.Add("48", typeof(string)); dt.Columns.Add("50", typeof(string)); dt.Columns.Add("52", typeof(string)); dt.Columns.Add("54", typeof(string)); dt.Columns.Add("56", typeof(string)); dt.Columns.Add("58", typeof(string)); dt.Columns.Add(" 30", typeof(string)); dt.Columns.Add(" 32", typeof(string)); dt.Columns.Add(" 34", typeof(string)); dt.Columns.Add(" 36", typeof(string)); dt.Columns.Add(" 39", typeof(string)); dt.Columns.Add(" 41", typeof(string)); dt.Columns.Add(" 43", typeof(string)); dt.Columns.Add(" 46", typeof(string)); dt.Columns.Add(" 48", typeof(string)); dt.Columns.Add(" 50", typeof(string)); dt.Columns.Add(" 52", typeof(string)); dt.Columns.Add(" 54", typeof(string)); dt.Columns.Add(" 56", typeof(string)); dt.Columns.Add(" 58", typeof(string)); dt.Columns.Add("28 ", typeof(string)); dt.Columns.Add("30 ", typeof(string)); dt.Columns.Add("32 ", typeof(string)); dt.Columns.Add("34 ", typeof(string)); dt.Columns.Add("36 ", typeof(string)); dt.Columns.Add("39 ", typeof(string)); dt.Columns.Add("41 ", typeof(string)); dt.Columns.Add("Sub Total: ", typeof(string)); dataGridView1.DataSource = dt; dataGridView1.Columns["Id"].Visible = false; dataGridView1.Columns["面料"].Width = 3; DataGridViewHelper rowMergeView = new DataGridViewHelper(dataGridView1); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(1, 1, "LOT#")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(2, 1, "STYLE")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(3, 1, "ART")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(4, 1, "COLOR")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(5, 1, "COLOR#")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(6, 1, "上衣")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(7, 1, "34R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(8, 1, "36R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(9, 1, "38R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(10, 1, "40R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(11, 1, "42R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(12, 1, "44R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(13, 1, "46R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(14, 1, "48R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(15, 1, "50R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(16, 1, "52R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(17, 1, "54R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(18, 1, "56R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(19, 1, "58R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(20, 1, "60R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(21, 1, "62R")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(22, 1, "36L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(23, 1, "38L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(24, 1, "40L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(25, 1, "42L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(26, 1, "44L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(27, 1, "46L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(28, 1, "48L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(29, 1, "50L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(30, 1, "52L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(31, 1, "54L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(32, 1, "56L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(33, 1, "58L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(34, 1, "60L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(35, 1, "62L")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(36, 1, "34S")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(37, 1, "36S")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(38, 1, "38S")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(39, 1, "40S")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(40, 1, "42S")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(41, 1, "44S")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(42, 1, "46S")); rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(43, 1, "订单合计")); dataGridView1.CellValueChanged -= dataGridView1_CellValueChanged; txt_Style.Text = StyleId; txt_Label.Text = chima; txt_CaidanNo.SelectedIndexChanged -= txt_CaidanNo_SelectedIndexChanged; this.txt_desc.Text = cd[0].DESC.ToString(); this.txt_fabric.Text = cd[0].FABRIC.ToString(); this.txt_jacket.Text = cd[0].Jacket.ToString(); this.txt_pant.Text = cd[0].Pant.ToString(); this.txt_shuoming.Text = cd[0].shuoming.ToString(); dataGridView1.ColumnHeadersHeight = 35; //this.dataGridView1.Width = //this.dataGridView1.Columns[0].HeaderCell.Size.Width * 43; //this.dataGridView1.DataSource = dt; //int width = this.dataGridView1.Width; //int avgWidth = width / dt.Columns.Count;//求出每一列的header宽度 //for (int i = 0; i < this.dataGridView1.Columns.Count; i++) //{ // this.dataGridView1.Columns[i].Width = avgWidth;//设置每一列的宽度 //} txt_CaidanNo.SelectedIndexChanged += txt_CaidanNo_SelectedIndexChanged; cb_jgc.DataSource = jgc; cb_jgc.DisplayMember = "Name"; cb_jgc.ValueMember = "id"; txt_zhidan.Text = DateTime.Now.ToLongDateString().ToString(); List <clsBuiness.CaiDan> caidan = gn2.selectCaiDan("").GroupBy(g => g.CaiDanHao).Select(s => s.First()).ToList <clsBuiness.CaiDan>(); clsBuiness.CaiDan c = new clsBuiness.CaiDan() { CaiDanHao = " " }; caidan.Add(c); txt_CaidanNo.DataSource = caidan; txt_CaidanNo.DisplayMember = "CaiDanHao"; txt_CaidanNo.ValueMember = "id"; if (txt_CaidanNo.FindString(" ") >= 0) { txt_CaidanNo.SelectedIndex = txt_CaidanNo.FindString(" "); } dataGridView1.CellValueChanged += dataGridView1_CellValueChanged; } catch (Exception ex) { //throw ex; MessageBox.Show(ex.Message); } resizedava_cloumn(dataGridView1); //设置Dave 宽度 resizedava_row(dataGridView1); }