private void createpacking(object sender, EventArgs e) { String opt = Properties.Settings.Default.username; String grade = Properties.Settings.Default.grade; String packingsize = Properties.Settings.Default.packingsize; DateTime dt = DateTime.Now; int julian = dt.DayOfYear; String juliancode = julian.ToString(); String curryear = DateTime.Now.ToString("yy"); List <object[]> ft = new List <object[]>(); MainMenu frm = new MainMenu(); //get sequence box, boxno, caseno, lot_number frm = new MainMenu(); String boxno = frm.get_data_sequence_boxno(); String caseno = frm.get_data_sequence_caseno(); /* * List<object[]> data1 = new List<object[]>(); * do * { * data1 = frm.get_data_table_string("tbpacking", "case_number", caseno); * if (data1.Count > 0) * { * caseno = frm.get_data_sequence_caseno(); * } * } * while (data1.Count > 0); */ String lot_number = "L" + caseno; String connString = Konek(); MySqlConnection conn5 = new MySqlConnection(connString); conn5.Open(); try { MySqlCommand mySql3 = conn5.CreateCommand(); String userlog = dt.ToString("yyyy-MM-dd hh:mm:ss") + "," + opt + ", rcv creation"; mySql3.CommandText = "Insert into tbpacking(box_number,case_number,grade,packingsize,username,moddatetime,lot_number,productname, productpacking)" + " values(@box_number,@case_number,@grade,@packingsize,@username,@moddatetime,@lot_number, @productname, @productpacking)"; mySql3.Parameters.AddWithValue("@box_number", boxno); mySql3.Parameters.AddWithValue("@case_number", caseno); mySql3.Parameters.AddWithValue("@grade", grade); mySql3.Parameters.AddWithValue("@packingsize", packingsize); mySql3.Parameters.AddWithValue("@moddatetime", DateTime.Parse(dt.ToString("yyyy-MM-dd HH:mm tt"))); mySql3.Parameters.AddWithValue("@username", opt); mySql3.Parameters.AddWithValue("@lot_number", lot_number); mySql3.Parameters.AddWithValue("@productname", cbproducttype.Text.Trim()); mySql3.Parameters.AddWithValue("@productpacking", cbproductsize.Text.Trim()); mySql3.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show("Error message " + ex.Message); } conn5.Close(); packingentry(sender, e, caseno, boxno, grade, packingsize); }
private void createpacking() { String opt = Properties.Settings.Default.username; String grade = cbgrade.Text.Trim(); String intlotcode = get_intlotcode(); String packingsize = cbpackingsize.Text.Trim(); DateTime dt = DateTime.Now; int julian = dt.DayOfYear; String juliancode = julian.ToString(); if (juliancode.Length == 1) { juliancode = "00" + juliancode; } else if (juliancode.Length == 2) { juliancode = "0" + juliancode; } String curryear = DateTime.Now.ToString("yy"); List <object[]> ft = new List <object[]>(); MainMenu frm = new MainMenu(); //get sequence box, boxno, caseno, lot_number frm = new MainMenu(); String boxno = frm.get_data_sequence_boxno(); gboxno = boxno; String caseno = frm.get_data_sequence_caseno(); gcaseno = caseno; String lot_number = "L" + caseno; glotnumber = lot_number; String connString = Konek(); MySqlConnection conn5 = new MySqlConnection(connString); conn5.Open(); try { MySqlCommand mySql3 = conn5.CreateCommand(); String userlog = dt.ToString("yyyy-MM-dd hh:mm:ss") + "," + opt + ", rcv creation"; mySql3.CommandText = "Insert into tbpacking(box_number,case_number,grade,packingsize,username,moddatetime,lot_number,productname, productpacking, batchcode, suppcode, best_before_date, pieces, boxweight,proddate,certificate, intlotcode)" + " values(@box_number,@case_number,@grade,@packingsize,@username,@moddatetime,@lot_number, @productname, @productpacking,@batchcode, @suppcode,@best_before_date,@pieces,@boxweight,@proddate,@certificate,@intlotcode)"; mySql3.Parameters.AddWithValue("@box_number", boxno); mySql3.Parameters.AddWithValue("@case_number", caseno); mySql3.Parameters.AddWithValue("@grade", grade); mySql3.Parameters.AddWithValue("@packingsize", packingsize); mySql3.Parameters.AddWithValue("@moddatetime", frm.get_server_time()); mySql3.Parameters.AddWithValue("@username", opt); mySql3.Parameters.AddWithValue("@lot_number", lot_number); mySql3.Parameters.AddWithValue("@productname", cbproductname.Text.Trim()); mySql3.Parameters.AddWithValue("@productpacking", cbproductpacking.Text.Trim()); mySql3.Parameters.AddWithValue("@batchcode", txtbatch.Text); mySql3.Parameters.AddWithValue("@suppcode", txtsuppcode.Text); DateTime processdate = dateTimePicker1.Value; DateTime best_before_date = processdate.AddDays(730); gbest_before_date = best_before_date; mySql3.Parameters.AddWithValue("@best_before_date", best_before_date); mySql3.Parameters.AddWithValue("@pieces", Int32.Parse(txtpieces.Text.Trim())); mySql3.Parameters.AddWithValue("@boxweight", Double.Parse(txtboxweight.Text.Trim())); mySql3.Parameters.AddWithValue("@proddate", processdate); mySql3.Parameters.AddWithValue("@certificate", cbcertificate.Text.Trim()); mySql3.Parameters.AddWithValue("@intlotcode", intlotcode); mySql3.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show("Error message " + ex.Message); } conn5.Close(); }