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);
}
private void Form1_Load(object sender, EventArgs e)
{
this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.None;//设置dava宽度
#region RGL2
DataTable dt1 = new DataTable();
dt1.Columns.Add("Id", typeof(int));
dt1.Columns.Add("面料", typeof(string));
dt1.Columns.Add("款式", typeof(string));
dt1.Columns["款式"].ReadOnly = true;
dt1.Columns.Add("货号", typeof(string));
dt1.Columns.Add("颜色", typeof(string));
dt1.Columns.Add("颜色编号", typeof(string));
dt1.Columns.Add("裤子", typeof(string));
dt1.Columns.Add("28", typeof(string));
dt1.Columns.Add("30", typeof(string));
dt1.Columns.Add("32", typeof(string));
dt1.Columns.Add("34", typeof(string));
dt1.Columns.Add("36", typeof(string));
dt1.Columns.Add("38", typeof(string));
dt1.Columns.Add("40", typeof(string));
dt1.Columns.Add("42", typeof(string));
dt1.Columns.Add("44", typeof(string));
dt1.Columns.Add("46", typeof(string));
dt1.Columns.Add("48", typeof(string));
dt1.Columns.Add("50", typeof(string));
dt1.Columns.Add("52", typeof(string));
dt1.Columns.Add("54", typeof(string));
dt1.Columns.Add("56", typeof(string));
dt1.Columns.Add(" 30", typeof(string));
dt1.Columns.Add(" 32", typeof(string));
dt1.Columns.Add(" 34", typeof(string));
dt1.Columns.Add(" 36", typeof(string));
dt1.Columns.Add(" 38", typeof(string));
dt1.Columns.Add(" 40", typeof(string));
dt1.Columns.Add(" 42", typeof(string));
dt1.Columns.Add(" 44", typeof(string));
dt1.Columns.Add(" 46", typeof(string));
dt1.Columns.Add(" 48", typeof(string));
dt1.Columns.Add(" 50", typeof(string));
dt1.Columns.Add(" 52", typeof(string));
dt1.Columns.Add(" 54", typeof(string));
dt1.Columns.Add(" 56", typeof(string));
dt1.Columns.Add(" 58", typeof(string));
dt1.Columns.Add(" 60", typeof(string));
dt1.Columns.Add(" 62", typeof(string));
dt1.Columns.Add("34 ", typeof(string));
dt1.Columns.Add("36 ", typeof(string));
dt1.Columns.Add("38 ", typeof(string));
dt1.Columns.Add("40 ", typeof(string));
dt1.Columns.Add("Sub Total: ", typeof(string));
dataGridView1.DataSource = dt1;
DataGridViewHelper rowMergeView = new DataGridViewHelper(dataGridView1);
dataGridView1.Columns["Id"].Visible = false;
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, "64L"));
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, "订单合计"));
#endregion
dataGridView1.CellValueChanged -= dataGridView1_CellValueChanged;
txt_Style.Text = sty;
txt_Label.Text = cmd;
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;
txt_CaidanNo.SelectedIndexChanged += txt_CaidanNo_SelectedIndexChanged;
cb_jgc.DataSource = jgc;
cb_jgc.DisplayMember = "Name";
cb_jgc.ValueMember = "id";
txt_zhidan.Text = DateTime.Now.ToString();
List <clsBuiness.CaiDan_RGL2> caidan = gn2.selectCaiDanRGL2("").GroupBy(g => g.CaiDanHao).Select(s => s.First()).ToList <clsBuiness.CaiDan_RGL2>();
clsBuiness.CaiDan_RGL2 c = new clsBuiness.CaiDan_RGL2()
{
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;
//dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
// dataGridView1.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
//dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
// dataGridView1.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
resizedava_cloumn(dataGridView1);//设置Dave 宽度
//for (int j = 0; j < 43; j++)
//{
// //if (j < dataGridView1.ColumnCount - Convert.ToInt32(toolStripComboBox4.Text))
// dataGridView1.Columns[j].Width = 500;
// }
}
private void CaiDanRGLJ_Load(object sender, EventArgs e)
{
this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.None;//设置dava宽度
#region RGLJ
DataTable dt4 = new DataTable();
dt4.Columns.Add("Id", typeof(int));
dt4.Columns.Add("面料", typeof(string));
dt4.Columns.Add("款式", typeof(string));
dt4.Columns["款式"].ReadOnly = true;
dt4.Columns.Add("货号", typeof(string));
dt4.Columns.Add("颜色", typeof(string));
dt4.Columns.Add("颜色编号", typeof(string));
dt4.Columns.Add("上衣", typeof(string));
dt4.Columns.Add("34R", typeof(string));
dt4.Columns.Add("36R", typeof(string));
dt4.Columns.Add("38R", typeof(string));
dt4.Columns.Add("40R", typeof(string));
dt4.Columns.Add("42R", typeof(string));
dt4.Columns.Add("44R", typeof(string));
dt4.Columns.Add("46R", typeof(string));
dt4.Columns.Add("48R", typeof(string));
dt4.Columns.Add("50R", typeof(string));
dt4.Columns.Add("52R", typeof(string));
dt4.Columns.Add("54R", typeof(string));
dt4.Columns.Add("56R", typeof(string));
dt4.Columns.Add("58R", typeof(string));
dt4.Columns.Add("60R", typeof(string));
dt4.Columns.Add("62R", typeof(string));
dt4.Columns.Add("36L", typeof(string));
dt4.Columns.Add("38L", typeof(string));
dt4.Columns.Add("40L", typeof(string));
dt4.Columns.Add("42L", typeof(string));
dt4.Columns.Add("44L", typeof(string));
dt4.Columns.Add("46L", typeof(string));
dt4.Columns.Add("48L", typeof(string));
dt4.Columns.Add("50L", typeof(string));
dt4.Columns.Add("52L", typeof(string));
dt4.Columns.Add("54L", typeof(string));
dt4.Columns.Add("56L", typeof(string));
dt4.Columns.Add("58L", typeof(string));
dt4.Columns.Add("60L", typeof(string));
dt4.Columns.Add("62L", typeof(string));
dt4.Columns.Add("34S", typeof(string));
dt4.Columns.Add("36S", typeof(string));
dt4.Columns.Add("38S", typeof(string));
dt4.Columns.Add("40S", typeof(string));
dt4.Columns.Add("42S", typeof(string));
dt4.Columns.Add("44S", typeof(string));
dt4.Columns.Add("46S", typeof(string));
dt4.Columns.Add("Sub Total: ", typeof(string));
dataGridView1.DataSource = dt4;
dataGridView1.Columns["Id"].Visible = false;
//rowMergeView = new DataGridViewHelper(RGLJ);
DataGridViewHelper rowMergeView = new DataGridViewHelper(dataGridView1);
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(1, 1, "LOT#"));
//rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(0, 1, "LOT1#"));
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(44, 1, "订单合计"));
#endregion
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;
txt_CaidanNo.SelectedIndexChanged += txt_CaidanNo_SelectedIndexChanged;
cb_jgc.DataSource = jgc;
cb_jgc.DisplayMember = "Name";
cb_jgc.ValueMember = "id";
txt_zhidan.Text = DateTime.Now.ToString();
List <clsBuiness.CaiDan_RGLJ> caidan = new List <CaiDan_RGLJ>();
if (!txt_CaidanNo.Equals(string.Empty))
{
caidan = gn2.selectCaiDanRGLJ("").GroupBy(g => g.CaiDanHao).Select(s => s.First()).ToList <clsBuiness.CaiDan_RGLJ>();
}
clsBuiness.CaiDan_RGLJ c = new clsBuiness.CaiDan_RGLJ()
{
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;
resizedava_cloumn(dataGridView1);//设置Dave 宽度
}
private void CaidanSLIM_Load(object sender, EventArgs e)
{
this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;//设置dava宽度
#region SLIM
DataTable dt3 = new DataTable();
dt3.Columns.Add("Id", typeof(int));
dt3.Columns.Add("面料", typeof(string));
dt3.Columns.Add("款式", typeof(string));
dt3.Columns["款式"].ReadOnly = true;
dt3.Columns.Add("货号", typeof(string));
dt3.Columns.Add("颜色", typeof(string));
dt3.Columns.Add("颜色编号", typeof(string));
dt3.Columns.Add("裤子", typeof(string));
dt3.Columns.Add("28", typeof(string));
dt3.Columns.Add("30", typeof(string));
dt3.Columns.Add("32", typeof(string));
dt3.Columns.Add("34", typeof(string));
dt3.Columns.Add("36", typeof(string));
dt3.Columns.Add("38", typeof(string));
dt3.Columns.Add("40", typeof(string));
dt3.Columns.Add("42", typeof(string));
dt3.Columns.Add(" 30", typeof(string));
dt3.Columns.Add(" 32", typeof(string));
dt3.Columns.Add(" 34", typeof(string));
dt3.Columns.Add(" 36", typeof(string));
dt3.Columns.Add(" 38", typeof(string));
dt3.Columns.Add(" 40", typeof(string));
dt3.Columns.Add(" 42", typeof(string));
dt3.Columns.Add("28 ", typeof(string));
dt3.Columns.Add("30 ", typeof(string));
dt3.Columns.Add("32 ", typeof(string));
dt3.Columns.Add("34 ", typeof(string));
dt3.Columns.Add("36 ", typeof(string));
dt3.Columns.Add("38 ", typeof(string));
dt3.Columns.Add("40 ", typeof(string));
dt3.Columns.Add("Sub Total: ", typeof(string));
dataGridView1.DataSource = dt3;
DataGridViewHelper rowMergeView = new DataGridViewHelper(dataGridView1);
dataGridView1.Columns["Id"].Visible = false;
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, "36L"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(16, 1, "38L"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(17, 1, "40L"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(18, 1, "42L"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(19, 1, "44L"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(20, 1, "46L"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(21, 1, "48L"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(22, 1, "34S"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(23, 1, "36S"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(24, 1, "38S"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(25, 1, "40S"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(26, 1, "42S"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(27, 1, "44S"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(28, 1, "46S"));
rowMergeView.Headers.Add(new DataGridViewHelper.TopHeader(29, 1, "订单合计"));
#endregion
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;
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_SLIM> caidan = gn2.selectCaiDanSLIM("").GroupBy(g => g.CaiDanHao).Select(s => s.First()).ToList <clsBuiness.CaiDan_SLIM>();
clsBuiness.CaiDan_SLIM c = new clsBuiness.CaiDan_SLIM()
{
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;
resizedava_cloumn(dataGridView1); //设置Dave 宽度
}
