public txt_chuumoncode2(DataGridView dg) { InitializeComponent(); textBox1.Text = "true"; string columnName = dg.Columns[0].Name; prueba.Text = columnName; /* * * * from here add nith */ if (prueba.Text == "注文コード") { Register.Enabled = false; button2.Enabled = false; ExitBtn.Enabled = false; this.ControlBox = false; OleDbConnection olecon = new OleDbConnection(); olecon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=HacchuuKannri.accdb;"; try { olecon.Open(); OleDbCommand ocmd = new OleDbCommand(); ocmd.Connection = olecon; //ocmd.CommandText = "SELECT * FROM 会員管理"; ocmd.CommandText = "SELECT TOP 1 * FROM 発注 ORDER BY 発注コード DESC"; OleDbDataAdapter adapter = new OleDbDataAdapter(ocmd); DataTable dt = new DataTable(); adapter.Fill(dt); txt_hacchuunum.Text = dt.Rows[0]["発注値"].ToString(); int i = int.Parse(txt_hacchuunum.Text); i += 1; txt_hacchuunum.Text = i.ToString(); txt_hacchuucode.Text = "H" + i.ToString("000"); txt_arrival.Text = dt.Rows[0]["着荷"].ToString(); textBox2.Text = dt.Rows[0]["注文コード"].ToString(); if (textBox2.Text != "") { mise_id = dt.Rows[0]["店コード"].ToString(); mise_name = dt.Rows[0]["店名"].ToString(); } olecon.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } int kakakufinal = 0; for (int i = 0; i < dg.RowCount - 1; i++) { // if (Convert.ToDouble(dg.Rows[i].Cells[13].Value) < 50) // { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells[3].Value = dg.Rows[i].Cells[0].Value; // 注文コード dataGridView1.Rows[i].Cells[6].Value = dg.Rows[i].Cells[1].Value; dataGridView1.Rows[i].Cells[7].Value = dg.Rows[i].Cells[2].Value; dataGridView1.Rows[i].Cells[2].Value = dg.Rows[i].Cells[3].Value; dataGridView1.Rows[i].Cells[1].Value = dg.Rows[i].Cells[4].Value; dataGridView1.Rows[i].Cells[4].Value = dg.Rows[i].Cells[5].Value; dataGridView1.Rows[i].Cells[5].Value = dg.Rows[i].Cells[6].Value; dataGridView1.Rows[i].Cells[11].Value = dg.Rows[i].Cells[7].Value; dataGridView1.Rows[i].Cells[9].Value = dg.Rows[i].Cells[8].Value; dataGridView1.Rows[i].Cells[10].Value = dg.Rows[i].Cells[10].Value; dataGridView1.Rows[i].Cells[12].Value = txt_hacchuunum.Text; dataGridView1.Rows[i].Cells[0].Value = txt_hacchuucode.Text; dataGridView1.Rows[i].Cells[8].Value = dg.Rows[i].Cells[14].Value; dataGridView1.Rows[i].Cells["new在庫"].Value = 50; // kakakufinal+=Convert.ToInt32(dg.Rows[i].Cells[10].Value); //txt_totalprice_final.Text = kakakufinal.ToString(); // } } for (int i = dataGridView1.Rows.Count - 1; i > -1; i--) { DataGridViewRow row = dataGridView1.Rows[i]; //if (!row.IsNewRow && row.Cells[0].Value == null) if (Convert.ToInt32(dataGridView1.Rows[i].Cells[8].Value) < 0) { dataGridView1.Rows.RemoveAt(i); } } for (int o = 0; o < dg.RowCount - 1; o++) { kakakufinal += Convert.ToInt32(dg.Rows[o].Cells[10].Value); total_price.Text = kakakufinal.ToString(); } } else { dataGridView1.AutoGenerateColumns = false; int sum = 0; txt_chuumoncode2 n = new txt_chuumoncode2(); for (int i = 0; i < dg.RowCount - 1; i++) { dataGridView1.Rows.Add(); dataGridView1.Rows[i].Cells["発注コード"].Value = n.txt_hacchuucode.Text; // 発注コード dataGridView1.Rows[i].Cells["商品コード"].Value = dg.Rows[i].Cells[0].Value; // 商品コード dataGridView1.Rows[i].Cells["商品名"].Value = dg.Rows[i].Cells[1].Value; // 商品名 dataGridView1.Rows[i].Cells["出版社コード"].Value = dg.Rows[i].Cells[4].Value; // 出版社コード dataGridView1.Rows[i].Cells["出版社名"].Value = dg.Rows[i].Cells[3].Value; // 出版社名 int hachuu_num = 50 - Convert.ToInt32(dg.Rows[i].Cells[6].Value); dataGridView1.Rows[i].Cells["発注数量"].Value = hachuu_num; //発注数量 dataGridView1.Rows[i].Cells["単価"].Value = dg.Rows[i].Cells[7].Value; // 単価 int money = hachuu_num * Convert.ToInt32(dg.Rows[i].Cells[7].Value); dataGridView1.Rows[i].Cells["金額"].Value = money; //金額 dataGridView1.Rows[i].Cells["発注日付"].Value = dateTimePicker1.Value.ToString("yyyy/MM/dd"); //発注日付 dataGridView1.Rows[i].Cells["発注値"].Value = n.txt_hacchuunum.Text; //発注値 dataGridView1.Rows[i].Cells["注文コード"].Value = ""; //注文コード dataGridView1.Rows[i].Cells["店コード"].Value = ""; //店コード dataGridView1.Rows[i].Cells["店名"].Value = ""; //店名 //if(dg.Rows[i].) dataGridView1.Rows[i].Cells["new在庫"].Value = 50; //new在庫 dataGridView1.Rows[i].Cells["チェック"].Value = dg.Rows[i].Cells[8].Value; //チェック } for (int i = dataGridView1.Rows.Count - 1; i > -1; i--) { //DataGridViewRow row = dataGridView1.Rows[i]; if (Convert.ToInt32(dataGridView1.Rows[i].Cells["チェック"].Value) == 0 || Convert.ToInt32(dataGridView1.Rows[i].Cells["発注数量"].Value) <= 0) { dataGridView1.Rows.RemoveAt(i); } } //if (txt_totalprice_final.Text == "") for (int i = 0; i < dataGridView1.RowCount; i++) { //have_data.Text += dataGridView1.Rows[i].Cells["金額"].Value.ToString(); sum += Convert.ToInt32(dataGridView1.Rows[i].Cells["金額"].Value); //sum += sum; total_price.Text = sum.ToString(); } } dataGridView1.Columns["new在庫"].Visible = false; }
private void add_hacchuu_btn_Click(object sender, EventArgs e) { txt_chuumoncode2 f = new txt_chuumoncode2(); f.ShowDialog(); }