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();
}
