public void setInitialValue() { gbentry.Visible = true; load_processing_company_cb(); List <object[]> data = new List <object[]>(); MainMenu frm = new MainMenu(); /* * data = frm.get_data_table_string_byid_desc("tbprocessingcompany", "", ""); * cbreceived.Items.Clear(); * if (data.Count > 0) * { * for (int i = 0; i < data.Count; i++) * { * cbreceived.Items.Add(data[i][1].ToString().Trim()); * } * } */ dateTimePicker1.Value = DateTime.Now; data = frm.get_data_table_string_byid_desc("tbreceiving_box", "", ""); cbreceiving_recent.Items.Clear(); if (data.Count > 0) { for (int i = 0; i < data.Count; i++) { cbreceiving_recent.Items.Add(data[i][1].ToString().Trim()); } } }
private void load_processing_company_cb() { List <object[]> data1 = new List <object[]>(); MainMenu frm = new MainMenu(); data1 = frm.get_data_table_string_byid_desc("tbprocessingcompany", "", ""); cbreceived.Items.Clear(); if (data1.Count > 0) { for (int i = 0; i < data1.Count; i++) { cbreceived.Items.Add(data1[i][1].ToString().Trim()); } } }
public void loaddatacutdet() { //set grade empty String intlotcode = lblInternalcode.Text.Trim(); //get data from table MainMenu frm = new MainMenu(); List <object[]> data = new List <object[]>(); data = frm.get_data_table_string_byid_desc("tbcuttingdetails", "intlotcode", intlotcode); //Type RM Int32 no = 0; dataGridView1.Visible = true; dataGridView1.Rows.Clear(); if (data.Count > 0) { dataGridView1.Rows.Add(data.Count); for (int i = 0; i < data.Count; i++) { no = data.Count - i; dataGridView1.Rows[i].Height = 50; dataGridView1.Rows[i].Cells[0].Value = (no).ToString(); dataGridView1.Rows[i].Cells[1].Value = data[i][4].ToString(); dataGridView1.Rows[i].Cells[2].Value = data[i][5].ToString(); } } //Image img1 = picedit.Image; //Bitmap bmp1 = new Bitmap(img1); Edit_columnbutton(); //Image img = pictureBox2.Image; //Bitmap bmp = new Bitmap(img); Delete_columnbutton(); }
void cuttingentry(object sender, EventArgs e, String intlot) { String intlotcode = ""; String cutdate = ""; String supplier = ""; String tipe = ""; String species = ""; //var current = sender as Button; //this.Hide(); //var frmCutting = new frmCutting(); //frmCutting.Closed += (s, args) => this.Close(); //rcv date DateTime dt = DateTime.Now; cutdate = dt.ToString("yyyy-MM-dd HH:mm tt"); // supplier intlotcode = intlot; List <object[]> data = new List <object[]>(); MainMenu frm = new MainMenu(); data = frm.get_data_table_string("tbreceiving", "intlotcode", intlotcode); if (data.Count > 0) { tipe = data[0][3].ToString(); species = data[0][2].ToString(); supplier = data[0][5].ToString(); } if (supplier.Equals("")) { supplier = frm.get_suppliername(intlotcode); } if (species.Equals("")) { data = frm.get_data_table_string_byid_desc("tbreceiving", "", ""); if (data.Count > 0) { species = data[0][2].ToString(); } } if (tipe.Equals("")) { data = frm.get_data_table_string("tbcuttingdetails", "intlotcode", intlotcode); if (data.Count > 0) { tipe = data[0][3].ToString(); } } /* * * if (supplier.Equals("")) * { * data = frm.get_data_table_string("tbcuttingdetails", "intlotcode", intlotcode); * if (data.Count > 0) * { * tipe = data[0][3].ToString(); * supplier = frm.get_suppliername(intlotcode); * } * * data = frm.get_data_table_string_byid_desc("tbreceiving", "", ""); * if (data.Count > 0) * { * species = data[0][2].ToString(); * } * } */ this.Hide(); frmCutting fc = new frmCutting(); fc.Closed += (s, args) => this.Close(); if (data.Count > 0) { fc.setInitialValue(tipe, species, intlotcode, supplier); fc.loaddatacutdet(); fc.loaddatasummary(); fc.ShowDialog(); } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Rows[e.RowIndex].Cells[1].Value == null) { return; } if (e.ColumnIndex == dataGridView1.Columns["Delete"].Index && e.RowIndex >= 0 && dataGridView1.Rows.Count > 0) { DialogResult dialogResult = MessageBox.Show("Are you sure to delete " + this.dataGridView1.Rows[e.RowIndex].Cells[1].Value + " , " + this.dataGridView1.Rows[e.RowIndex].Cells[2].Value + "Kg ?", "Delete", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { Int32 n = e.RowIndex; Int32 id = 0; String intlotcode = lblInternalcode.Text.Trim(); MainMenu frm = new MainMenu(); List <object[]> data = new List <object[]>(); if (textBox1.Text.Equals("")) { data = frm.get_data_table_string_byid_desc("tbcuttingdetails", "intlotcode", intlotcode); } else { data = frm.get_data_table_search("tbcuttingdetails", lblInternalcode.Text.Trim(), textBox1.Text.Trim()); } //get_data_table_search(String tablename, String intlotcode, String value) //data = frm.get_data_table_transaction("tbcuttingdetails", intlotcode, "seq1", "seq2"); for (int i = 0; i <= n; i++) { if (i == n) { id = Int32.Parse(data[i][0].ToString()); } } //frm.delete_table("tbcuttingdetails", "id", id.ToString()); String connString = Konek(); MySqlConnection conn5 = new MySqlConnection(connString); conn5.Open(); try { MySqlCommand mySql3 = conn5.CreateCommand(); mySql3.CommandText = "update tbcuttingdetails set tipe=@tipe,grade=@grade,cweight=0,intlotcode=@intlotcode, moddatetime=@moddatetime where id=@id"; mySql3.Parameters.AddWithValue("@tipe", ""); mySql3.Parameters.AddWithValue("@grade", ""); mySql3.Parameters.AddWithValue("@intlotcode", "4del"); mySql3.Parameters.AddWithValue("@moddatetime", frm.get_server_time()); mySql3.Parameters.AddWithValue("@id", id.ToString()); mySql3.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } if (textBox1.Text.Equals("")) { loaddatacutdet(); } else { loaddatasearch(textBox1.Text.Trim()); } } } if (e.ColumnIndex == dataGridView1.Columns["Edit"].Index && e.RowIndex >= 0 && dataGridView1.Rows.Count > 0) { DialogResult dialogResult = MessageBox.Show("Are you sure to Edit " + this.dataGridView1.Rows[e.RowIndex].Cells[1].Value + " , " + this.dataGridView1.Rows[e.RowIndex].Cells[2].Value + "Kg ?", "Edit", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { Int32 n = e.RowIndex; Int32 id = 0; String intlotcode = lblInternalcode.Text.Trim(); MainMenu frm = new MainMenu(); List <object[]> data = new List <object[]>(); if (textBox1.Text.Equals("")) { data = frm.get_data_table_string_byid_desc("tbcuttingdetails", "intlotcode", intlotcode); } else { data = frm.get_data_table_search("tbcuttingdetails", lblInternalcode.Text.Trim(), textBox1.Text.Trim()); } for (int i = 0; i <= n; i++) { if (i == n) { id = Int32.Parse(data[i][0].ToString()); lblid.Text = id.ToString(); } } panel1.Visible = true; txtgrade.Text = this.dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); txtweightedit.Text = this.dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(); } } }