private void button1_Click(object sender, EventArgs e) { // int selectLip = comboBox1.SelectedIndex; // string s = textBox1.Text; string strselect = comboBox2.Text; switch (strselect) { case "레드벨벳(매트)": string packet1 = "BUYLIPSTIK_CNT1" + "\a"; packet1 += textBox1.Text; client.SendDataOne(packet1); break; case "레드벨벳(글로우)": string packet2 = "BUYLIPSTIK_CNT2" + "\a"; packet2 += textBox1.Text; client.SendDataOne(packet2); break; case "딸기가좋아(매트)": string packet3 = "BUYLIPSTIK_CNT3" + "\a"; packet3 += textBox1.Text; client.SendDataOne(packet3); break; case "딸기가 좋아(글로우)": string packet4 = "BUYLIPSTIK_CNT4" + "\a"; packet4 += textBox1.Text; client.SendDataOne(packet4); break; case "체리필터(매트)": string packet5 = "BUYLIPSTIK_CNT5" + "\a"; packet5 += textBox1.Text; client.SendDataOne(packet5); break; case "체리필터(글로우)": string packet6 = "BUYLIPSTIK_CNT6" + "\a"; packet6 += textBox1.Text; client.SendDataOne(packet6); break; case "캔디크러시(매트)": string packet7 = "BUYLIPSTIK_CNT7" + "\a"; packet7 += textBox1.Text; client.SendDataOne(packet7); break; case "캔디크러시(글로우)": string packet8 = "BUYLIPSTIK_CNT8" + "\a"; packet8 += textBox1.Text; client.SendDataOne(packet8); break; case "과즙톡톡(매트)": string packet9 = "BUYLIPSTIK_CNT9" + "\a"; packet9 += textBox1.Text; client.SendDataOne(packet9); break; case "과즙톡톡(글로우)": string packet10 = "BUYLIPSTIK_CNT10" + "\a"; packet10 += textBox1.Text; client.SendDataOne(packet10); break; case "크레용팝(매트)": string packet11 = "BUYLIPSTIK_CNT11" + "\a"; packet11 += textBox1.Text; client.SendDataOne(packet11); break; case "크레용팝(글로우)": string packet12 = "BUYLIPSTIK_CNT12" + "\a"; packet12 += textBox1.Text; client.SendDataOne(packet12); break; } /* * if (selectLip == 0) * { * * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(체리)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(빨강)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '레드벨벳(메트)'"); * } * * else if (selectLip == 1) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(체리)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(빨강)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '레드벨벳(글로우)'"); * } * else if (selectLip == 2) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(딸기)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(빨강)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '딸기가 좋아(메트)'"); * } * else if (selectLip == 3) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(딸기)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(빨강)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '딸기가 좋아(글로우)'"); * } * * else if (selectLip == 4) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(체리)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(빨강)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '체리필터(메트)'"); * } * * * else if (selectLip == 5) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(체리)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(빨강)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '체리필터(글로우)'"); * } * * int selectLip2 = comboBox2.SelectedIndex; * * if (selectLip2 == 0) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(사과)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(핑크)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '캔디크러시(메트)'"); * } * else if (selectLip2 == 1) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(사과)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(핑크)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '캔디크러시(글로우)'"); * } * else if (selectLip2 == 2) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(사과)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(핑크)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '과즙톡톡(메트)'"); * } * else if (selectLip2 == 3) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(사과)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(핑크)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '과즙톡톡(글로우)'"); * } * else if (selectLip2 == 4) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(딸기)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(핑크)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '크레용팝(메트)'"); * } * else if (selectLip2 == 5) * { * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '켄텔릴라왁스'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '유동 파라핀'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '안료'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '향료(딸기)'"); * Db($"update material_tb set material_count =material_count-({s})*20 where material_name = '색소(핑크)'"); * Db($"update lipstik_tb set lipstik_cnt =lipstik_cnt - ({s}) where lipstik_name = '크레용팝(글로우)'"); * }*/ }