private void Form4_Load(object sender, EventArgs e) { textBox_UserName.Text = LoginForm.idValue; // ProductName = Form2.ProductName; string productName = Form2.ProductIsbn; label_Addres.Text = "한진택배"; label_ProductCount.Text = Form2.ProductCount; int countP = sql.Query_Select_DataSet("WHERE Isbn = '" + Form2.ProductIsbn + "'").Tables[0].Rows.Count; if (countP != 0) {//상품 금액 , 총 결제 금액 label 값을 넣어줌 string ciar = sql.Query_Select_DataSet("WHERE Isbn = '" + Form2.ProductIsbn + "'").Tables[0].Rows[0]["Cigar"].ToString(); label_Cigar.Text = (int.Parse(ciar) * int.Parse(Form2.ProductCount)).ToString(); int total = int.Parse(label_Cigar.Text) * int.Parse(Form2.ProductCount) + 2500; label_Total.Text = total.ToString(); } int countU = sqluser.Query_Select_DataSet("WHERE ID = '" + LoginForm.idValue + "'").Tables[0].Rows.Count; if (countU != 0) {// 고객 정보 자동 입력 textBox_UserName.Text = sqluser.Query_Select_DataSet("WHERE ID = '" + LoginForm.idValue + "'").Tables[0].Rows[0]["NAME"].ToString(); textBox_Address.Text = sqluser.Query_Select_DataSet("WHERE ID = '" + LoginForm.idValue + "'").Tables[0].Rows[0]["ADDRESS"].ToString(); textBox_Tel.Text = sqluser.Query_Select_DataSet("WHERE ID = '" + LoginForm.idValue + "'").Tables[0].Rows[0]["TEL"].ToString(); } }
private void button_login_Click(object sender, EventArgs e) {//로그인 버튼 try { if (textBox_id.Text.Trim() == "" || textBox_pwd.Text.Trim() == "") { MessageBox.Show("빈칸이 있습니다. 다시 입력해 주세요"); } else { SqlLogin sqle = new SqlLogin(); int count = sqle.Query_Select_DataSet("WHERE ID = '" + textBox_id.Text + "' and pwd ='" + textBox_pwd.Text + "'").Tables[0].Rows.Count; if (count == 1) { string strId = sqle.Query_Select_DataSet("WHERE ID = '" + textBox_id.Text + "' and pwd ='" + textBox_pwd.Text + "'").Tables[0].Rows[0]["ID"].ToString(); string strPwd = sqle.Query_Select_DataSet("WHERE ID = '" + textBox_id.Text + "' and pwd ='" + textBox_pwd.Text + "'").Tables[0].Rows[0]["PWD"].ToString(); string strName = sqle.Query_Select_DataSet("WHERE ID = '" + textBox_id.Text + "' and pwd ='" + textBox_pwd.Text + "'").Tables[0].Rows[0]["NAME"].ToString(); if (strId == textBox_id.Text && strPwd == textBox_pwd.Text) { if (textBox_id.Text == "1" && textBox_pwd.Text == "1") { MessageBox.Show("운영자님 환영합니다."); Form6 showForm6 = new Form6(); showForm6.Show(); this.Visible = false; } else { idValue = textBox_id.Text; MessageBox.Show(strName + "님 환영합니다."); // 추가 // Form2 showForm2 = new Form2(); ProductListForm showForm2 = new ProductListForm(); showForm2.Show(); //sql.Id = textBox_id.Text; this.Visible = false; } } } else { MessageBox.Show("로그인 실패"); } } }catch (Exception error) { //MessageBox.Show("로그인 실패"); MessageBox.Show("" + error); } }
private void button_Click(object sender, EventArgs e) {//구매하기 버튼 if (LoginForm.idValue == null) { MessageBox.Show("로그인을 해주세요"); } else { int index = comboBox_colorSize.SelectedIndex; if (index <= -1) { MessageBox.Show("선택해주세요"); } else { String purchase_size = ds.Tables[0].Rows[index]["Size"].ToString(); String purchase_color = ds.Tables[0].Rows[index]["Color"].ToString(); String purchase_count = comboBox_count.SelectedItem as String; String purchase_cigar = ds.Tables[0].Rows[index]["Cigar"].ToString(); String total = (int.Parse(purchase_cigar) * int.Parse(purchase_count) + 2500).ToString(); //회원 정보 DataSet uds = uSqp.Query_Select_DataSet("WHERE ID = '" + LoginForm.idValue + "'"); int countU = uds.Tables[0].Rows.Count; String tel_inform = uds.Tables[0].Rows[0]["TEL"].ToString(); textBox_tel.Text = tel_inform.Substring(0, 3); textBox_tel1.Text = tel_inform.Substring(4, 4); textBox_tel2.Text = tel_inform.Substring(9, 4); if (countU != 0) {// 로그인이 된 상태라면 textBox_user_name.Text = uds.Tables[0].Rows[0]["NAME"].ToString(); textBox__user_address.Text = uds.Tables[0].Rows[0]["ADDRESS"].ToString(); textBox__user_memo.Text = uds.Tables[0].Rows[0]["ADDRESS"].ToString(); } label_purchase_name.Text = product_name; label_purchase_size.Text = purchase_size; label_purchase_color.Text = purchase_color; label_purchase_count.Text = purchase_count; label_purchase_cigar.Text = purchase_cigar; label_purchase_total.Text = total; // groupBox_purchase.Visible = true; } } }
public MyInformationForm() { InitializeComponent(); label_id.Text = LoginForm.idValue; DataSet ds = sql.Query_Select_DataSet("WHERE id = '" + label_id.Text + "'"); textBox_name.Text = ds.Tables[0].Rows[0]["NAME"].ToString(); textBox_address.Text = ds.Tables[0].Rows[0]["ADDRESS"].ToString(); String tel = ds.Tables[0].Rows[0]["TEL"].ToString(); String tel1 = tel.Substring(0, 3); textBox_tel2.Text = tel.Substring(4, 4); textBox_tel3.Text = tel.Substring(9, 4); //textBox_address.Text = ds.Tables[0].Rows[0]["ADDRESS"].ToString(); //String tel_inform = ds.Tables[0].Rows[0]["TEL"].ToString(); string[] tell = { "010", "011", "016", "017", "018", "019" }; comboBox1.Items.AddRange(tell); switch (tel1) { case "010": comboBox1.SelectedIndex = 0; break; case "011": comboBox1.SelectedIndex = 1; break; case "016": comboBox1.SelectedIndex = 2; break; case "017": comboBox1.SelectedIndex = 3; break; case "018": comboBox1.SelectedIndex = 4; break; case "019": comboBox1.SelectedIndex = 5; break; } }
public Form5() { InitializeComponent(); label_id.Text = LoginForm.idValue; DataSet ds = sqlLogin.Query_Select_DataSet("WHERE id = '" + label_id.Text + "'"); textBox_pwd.Text = ds.Tables[0].Rows[0]["PWD"].ToString(); textBox_name.Text = ds.Tables[0].Rows[0]["NAME"].ToString(); textBox_address.Text = ds.Tables[0].Rows[0]["ADDRESS"].ToString(); String tel_inform = ds.Tables[0].Rows[0]["TEL"].ToString(); String tel1 = tel_inform.Substring(3, 4); String tel2 = tel_inform.Substring(7, 4); textBox_tel1.Text = tel1; textBox_tel2.Text = tel2; string[] tel = { "010", "011", "016", "017", "018", "019" }; comboBox1.Items.AddRange(tel); comboBox1.SelectedIndex = 0; }