private void Button1_Click(object sender, EventArgs e) { if (textBox1.Text != null && textBox2.Text != null && textBox3.Text != null && textBox4.Text != null && textBox5.Text != null) { string connStr = string.Format("server=localhost;" + "user=root;" + "password=apmsetup;" + "database=csharpdb"); MySqlConnection conn = new MySqlConnection(connStr); try { conn.Open(); if (conn.State == ConnectionState.Open) { int total = (Convert.ToInt32(textBox1.Text) * 1000) + (Convert.ToInt32(textBox2.Text) * 500) + (Convert.ToInt32(textBox3.Text) * 100) + (Convert.ToInt32(textBox4.Text) * 50) + (Convert.ToInt32(textBox5.Text) * 10); string sql1 = "update havem set m_1000 = " + textBox1.Text + " where day = " + System.DateTime.Now.ToString("yyyyMMdd") + ";"; string sql2 = "update havem set m_500 = " + textBox2.Text + " where day = " + System.DateTime.Now.ToString("yyyyMMdd") + ";"; string sql3 = "update havem set m_100 = " + textBox3.Text + " where day = " + System.DateTime.Now.ToString("yyyyMMdd") + ";"; string sql4 = "update havem set m_50 = " + textBox4.Text + " where day = " + System.DateTime.Now.ToString("yyyyMMdd") + ";"; string sql5 = "update havem set m_10 = " + textBox5.Text + " where day = " + System.DateTime.Now.ToString("yyyyMMdd") + ";"; string sql6 = "update havem set total = " + total + " where day = " + System.DateTime.Now.ToString("yyyyMMdd") + ";"; MySqlCommand cmd1 = new MySqlCommand(sql1, conn); MySqlCommand cmd2 = new MySqlCommand(sql2, conn); MySqlCommand cmd3 = new MySqlCommand(sql3, conn); MySqlCommand cmd4 = new MySqlCommand(sql4, conn); MySqlCommand cmd5 = new MySqlCommand(sql5, conn); MySqlCommand cmd6 = new MySqlCommand(sql6, conn); cmd1.ExecuteNonQuery(); cmd2.ExecuteNonQuery(); cmd3.ExecuteNonQuery(); cmd4.ExecuteNonQuery(); cmd5.ExecuteNonQuery(); cmd6.ExecuteNonQuery(); MessageBox.Show("입력 성공"); } } catch (Exception ex) { conn.Close(); } } this.Close(); DrinkDAO.Get_DB(); }
public static void buy() { // 남은 음료의 수 계산 for (int i = 0; i < Zapangi.d_amount; i++) { Zapangi.LEFT_D[i] -= Zapangi.BUY_D[i]; } // 남은 스낵의 수 계산 for (int i = 0; i < Zapangi.s_amount; i++) { Zapangi.LEFT_S[i] -= Zapangi.BUY_S[i]; } // DB에 저장 DrinkDAO.Change_DAO(); DrinkDAO.Get_DB(); }
// 폼 초기화 public Order(int room = 0) { InitializeComponent(); RoomNum.Text = room.ToString(); DrinkDAO.Get_DB(); for (int i = 0; i < Zapangi.d_amount; i++) { Zapangi.DRINK_B_LIST[i] = Zapangi.DRINK_LIST[i]; } for (int i = 0; i < Zapangi.s_amount; i++) { Zapangi.SNACK_B_LIST[i] = Zapangi.SNACK_LIST[i]; } Set_image(); Set_price(); }
private void Button1_Click(object sender, EventArgs e) { for (int i = 0; i < Zapangi.d_amount; i++) { Zapangi.DRINK_B_LIST[i] = Zapangi.DRINK_LIST[i]; } for (int i = 0; i < Zapangi.s_amount; i++) { Zapangi.SNACK_B_LIST[i] = Zapangi.SNACK_B_LIST[i]; } // 음료 가격 수정 if (checkBox1.Checked) { if (textBox8.Text != null && textBox7.Text != null && textBox6.Text != null && textBox5.Text != null) { Zapangi.DRINK_PRICE[0] = Convert.ToInt32(textBox8.Text); Zapangi.DRINK_PRICE[1] = Convert.ToInt32(textBox7.Text); Zapangi.DRINK_PRICE[2] = Convert.ToInt32(textBox6.Text); Zapangi.DRINK_PRICE[3] = Convert.ToInt32(textBox5.Text); } } // 음료 수량 수정 if (checkBox2.Checked) { if (textBox1.Text != null && textBox2.Text != null && textBox3.Text != null && textBox4.Text != null) { Zapangi.LEFT_D[0] = Convert.ToInt32(textBox1.Text); Zapangi.LEFT_D[1] = Convert.ToInt32(textBox2.Text); Zapangi.LEFT_D[2] = Convert.ToInt32(textBox4.Text); Zapangi.LEFT_D[3] = Convert.ToInt32(textBox3.Text); } } // 음료 종류 변경 if (checkBox3.Checked) { for (int i = 0; i < Zapangi.d_amount; i++) { Zapangi.DRINK_B_LIST[i] = Zapangi.DRINK_LIST[i]; } int count = 0; for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++) { string item = checkedListBox1.CheckedItems[i].ToString(); if (item == "콜라") { Zapangi.DRINK_LIST[count++] = "COKE"; } else if (item == "환타") { Zapangi.DRINK_LIST[count++] = "FANTA"; } else if (item == "커피") { Zapangi.DRINK_LIST[count++] = "COFFEE"; } else if (item == "물") { Zapangi.DRINK_LIST[count++] = "WATER"; } else if (item == "알로에쥬스") { Zapangi.DRINK_LIST[count++] = "ALOE"; } else if (item == "망고쥬스") { Zapangi.DRINK_LIST[count++] = "MANGO"; } else if (item == "웰치스") { Zapangi.DRINK_LIST[count++] = "WELCHS"; } } } // 스낵 가격 변경 if (checkBox4.Checked) { if (textBox16.Text != null && textBox15.Text != null && textBox14.Text != null && textBox13.Text != null) { Zapangi.SNACK_PRICE[0] = Convert.ToInt32(textBox16.Text); Zapangi.SNACK_PRICE[1] = Convert.ToInt32(textBox15.Text); Zapangi.SNACK_PRICE[2] = Convert.ToInt32(textBox14.Text); Zapangi.SNACK_PRICE[3] = Convert.ToInt32(textBox13.Text); } } //스낵 수량 변경 if (checkBox5.Checked) { if (textBox9.Text != null && textBox10.Text != null && textBox11.Text != null && textBox12.Text != null) { Zapangi.LEFT_S[0] = Convert.ToInt32(textBox9.Text); Zapangi.LEFT_S[1] = Convert.ToInt32(textBox10.Text); Zapangi.LEFT_S[2] = Convert.ToInt32(textBox11.Text); Zapangi.LEFT_S[3] = Convert.ToInt32(textBox12.Text); } } //스낵 종류 변경 if (checkBox6.Checked) { for (int i = 0; i < Zapangi.s_amount; i++) { Zapangi.SNACK_B_LIST[i] = Zapangi.SNACK_LIST[i]; } int count = 0; for (int i = 0; i < checkedListBox2.CheckedItems.Count; i++) { string item = checkedListBox2.CheckedItems[i].ToString(); if (item == "허니버터칩") { Zapangi.SNACK_LIST[count++] = "HONEY"; } else if (item == "빼빼로") { Zapangi.SNACK_LIST[count++] = "STICK"; } else if (item == "프링글스") { Zapangi.SNACK_LIST[count++] = "PRINGLE"; } else if (item == "꾸이꾸이") { Zapangi.SNACK_LIST[count++] = "COOKIE"; } else if (item == "숏다리") { Zapangi.SNACK_LIST[count++] = "SHORT"; } else if (item == "하리보") { Zapangi.SNACK_LIST[count++] = "HARIBO"; } else if (item == "새우깡") { Zapangi.SNACK_LIST[count++] = "SHRIMP"; } else if (item == "아이스쿨") { Zapangi.SNACK_LIST[count++] = "ICECOOL"; } } } MessageBox.Show("입력 성공"); this.Close(); // 세팅 후 DB변경 및 읽어오기 DrinkDAO.Change_DAO(); DrinkDAO.Get_DB(); }