private void btnCancle_Click(object sender, EventArgs e) { s = Sell.Load(); s.ClientID = null; this.Dispose(); }
private void frmSign_Load(object sender, EventArgs e) { Sell s = Sell.Load(); signPad1.PenWidth = 8; if (s.Cardmoeny > 50000) { } else { btnOk_Click(null, null); this.Visible = false; this.Dispose(); } }
private void btnSave_Click(object sender, EventArgs e) { if (selectflage) { Sell s = Sell.Load(); s.SavePoint = int.Parse(tboxSave.Text); s.Phone = tempphone; s.ClientID = tempID; frmMain fm = (frmMain)Owner; fm.T2.Text = "회원 이름 : " + lblName.Text + "\r\n"; fm.T2.Text += "적립 포인트 : " + tboxSave.Text + "점"; this.Dispose(); } else { MessageBox.Show("정보를 검색해주세요."); } }
private void frmPointSave_Load(object sender, EventArgs e) { Sell s = Sell.Load(); tboxMoney.Text = money; }
private void btnPUse_Click(object sender, EventArgs e) { s = Sell.Load(); con = DBcontroller.Instance(); con.Open(); using (var cmd = new SqlCommand("SearchMember", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@phone", tboxPhone.Text); cmd.Parameters.AddWithValue("@pwd", tboxPass.Text); var sdr = cmd.ExecuteReader(); if (sdr.HasRows) { while (sdr.Read()) { if (sdr[0].ToString() == "0") { MessageBox.Show("정보 불일치"); con.Close(); return; } else { s.ClientID = sdr["memberNum"].ToString(); selectflage = true; } } } } con.Close(); con.Open(); if (selectflage) { using (var cmd = new SqlCommand("UpdatePoint", con)) { int s = -1 * int.Parse(tboxInputPoint.Text); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@phone", tboxPhone.Text); cmd.Parameters.AddWithValue("@point", s); cmd.ExecuteNonQuery(); } } con.Close(); if (tboxInputPoint.Text != "" && int.Parse(tboxUPoint.Text) >= int.Parse(tboxInputPoint.Text)) { s.Pointmoney = decimal.Parse(tboxInputPoint.Text); frmMain fm = (frmMain)Owner; fm.T2.Text = "포인트 할인이 적용되었습니다.\r\n"; fm.T2.Text += "할인전 보유 포인트 : " + tboxUPoint.Text + "\r\n"; fm.T2.Text += "사용 포인트 : " + tboxInputPoint.Text + "\r\n"; fm.T2.Text += "할인후 보유 포인트 : " + (int.Parse(tboxUPoint.Text) - int.Parse(tboxInputPoint.Text)) + "\r\n"; fm.T1.Text = (int.Parse(fm.T1.Text) - int.Parse(tboxInputPoint.Text)).ToString(); fm.T5.Text = (int.Parse(fm.T4.Text) + int.Parse(fm.T1.Text)).ToString(); s.Phone = tboxPhone.Text; this.Dispose(); } else { tboxInputPoint.Focus(); tboxInputPoint.Text = ""; MessageBox.Show("보유 포인트 부족"); } con.Close(); MessageBox.Show(tboxInputPoint.Text); }
private void btnPay_Click(object sender, EventArgs e) { //결제끝 Sell s = Sell.Load(); frmPayment fm = (frmPayment)Owner; if (tboxBit.Text == "") { tboxReceive.Text = tboxTotal.Text; tboxBit.Text = "0"; tboxChange.Text = "0"; } if (decimal.Parse(tboxBit.Text) == 0) { con = DBcontroller.Instance(); s.Cashmoney = s.Cashmoney + int.Parse(tboxReceive.Text); fm.T1.Text = "0"; fm.T2.Text = "0"; //payList fm.T3.Text = "0"; fm.T4.Text = "0"; fm.T5.Text = "0"; int type = 1; if (s.Pointmoney != 0) { type = 3; } try { con.Open(); using (var cmd = new SqlCommand("InsertSell", con)) { cmd.CommandType = CommandType.StoredProcedure; if (s.ClientID == null) { cmd.Parameters.AddWithValue("@memberNum", DBNull.Value); } else { cmd.Parameters.AddWithValue("@memberNum", int.Parse(s.ClientID)); } cmd.Parameters.AddWithValue("@sellDate", DateTime.Now); cmd.Parameters.AddWithValue("@clientNum", s.Ages); cmd.Parameters.AddWithValue("@methodNum", type); cmd.Parameters.AddWithValue("@totalMoney", s.Tot); cmd.Parameters.AddWithValue("@receiveCash", s.Cashmoney); cmd.Parameters.AddWithValue("@receiveCard", s.Cardmoeny); cmd.Parameters.AddWithValue("@receivePoint", s.Pointmoney); cmd.Parameters.AddWithValue("@note", s.Sale.ToString()); cmd.Parameters.AddWithValue("@savePoint", s.SavePoint); cmd.Parameters.AddWithValue("@empNum", s.EmpId); cmd.Parameters.AddWithValue("@card", DBNull.Value); cmd.Parameters.AddWithValue("@preturn", DBNull.Value); cmd.Parameters.AddWithValue("@returnReason", DBNull.Value); cmd.ExecuteNonQuery(); } fm.T2.Text = "************이전 정보 \r\n"; fm.T2.Text += "현금 결제 : " + tboxTotal.Text + "원\r\n"; fm.T2.Text += "카드 결제 : " + s.Cardmoeny + "원\r\n"; fm.T2.Text += "포인트 결제 : " + s.Pointmoney + "원\r\n"; con.Close(); con.Open(); foreach (DataRow row in fm.Ss.Rows) { using (var ccmd = new SqlCommand("InsertSellInfo", con)) { ccmd.CommandType = CommandType.StoredProcedure; decimal salesquantity = 0; decimal tot = -1 * int.Parse(row["할인"].ToString()); salesquantity = tot / decimal.Parse(row["단가"].ToString()); ccmd.Parameters.AddWithValue("@barcode", row["바코드"].ToString()); ccmd.Parameters.AddWithValue("@quantity", row["수량"].ToString()); ccmd.Parameters.AddWithValue("@salesquantity", tot); ccmd.ExecuteNonQuery(); } } if (s.ClientID != null) { using (var ccmd = new SqlCommand("UpdatePoint", con)) { MessageBox.Show(s.ClientID.ToString()); ccmd.CommandType = CommandType.StoredProcedure; ccmd.Parameters.AddWithValue("@phone", s.Phone); ccmd.Parameters.AddWithValue("@point", s.SavePoint); ccmd.ExecuteNonQuery(); } using (var ccmd = new SqlCommand("SelectMemberGrade", con)) { MessageBox.Show("Test"); ccmd.CommandType = CommandType.StoredProcedure; ccmd.Parameters.AddWithValue("@phone", s.Phone); ccmd.ExecuteNonQuery(); } } foreach (DataRow row in fm.Ss.Rows) { using (var ccmd = new SqlCommand("UpdateProducts", con)) { ccmd.CommandType = CommandType.StoredProcedure; ccmd.Parameters.AddWithValue("@barcode", row["바코드"].ToString()); ccmd.Parameters.AddWithValue("@quantity", row["수량"].ToString()); if (ccmd.ExecuteNonQuery() != 1) { MessageBox.Show("상품 재고 업데이트 에러"); } } } Sell.Clear(); fm.Ss.Clear(); con.Close(); this.Dispose(); } catch (Exception msg) { con.Close(); MessageBox.Show(msg.Message); } } //복합결제 else { s.Cashmoney = int.Parse(tboxReceive.Text); fm.T5.Text = (int.Parse(fm.T5.Text) - int.Parse(tboxReceive.Text)).ToString(); fm.T2.Text = "************이전 정보 \r\n"; fm.T2.Text += "현금 결제 : " + s.Cashmoney + "원\r\n"; fm.T2.Text += "카드 결제 : " + s.Cardmoeny + "원\r\n"; fm.T2.Text += "포인트 결제 : " + s.Pointmoney + "원\r\n"; this.Dispose(); } }
private void btnOk_Click(object sender, EventArgs e) { Sell s = Sell.Load(); frmCard fm = (frmCard)Owner; signPad1.Save(); SqlConnection con = DBcontroller.Instance(); con.Open(); using (var cmd = new SqlCommand("InsertSell", con)) { cmd.CommandType = CommandType.StoredProcedure; if (s.ClientID == null) { cmd.Parameters.AddWithValue("@memberNum", DBNull.Value); } else { cmd.Parameters.AddWithValue("@memberNum", s.ClientID); } int type = 2; if (s.Cardmoeny != 0 || s.Pointmoney != 0) { type = 3; } string cardNum = s.CardNumber.Substring(0, 6); cardNum += "******"; cardNum += s.CardNumber.Substring(12, 4); cmd.Parameters.AddWithValue("@sellDate", DateTime.Now); cmd.Parameters.AddWithValue("@clientNum", s.Ages); cmd.Parameters.AddWithValue("@methodNum", type); cmd.Parameters.AddWithValue("@totalMoney", s.Tot); cmd.Parameters.AddWithValue("@receiveCash", s.Cashmoney); cmd.Parameters.AddWithValue("@receiveCard", s.Cardmoeny); cmd.Parameters.AddWithValue("@receivePoint", s.Pointmoney); cmd.Parameters.AddWithValue("@note", s.Sale.ToString()); cmd.Parameters.AddWithValue("@card", cardNum); cmd.Parameters.AddWithValue("@empNum", s.EmpId); cmd.Parameters.AddWithValue("@savePoint", s.SavePoint); cmd.Parameters.AddWithValue("@preturn", DBNull.Value); cmd.Parameters.AddWithValue("@returnReason", DBNull.Value); cmd.ExecuteNonQuery(); } con.Close(); con.Open(); MessageBox.Show(fm.Ss.Rows.Count.ToString()); foreach (DataRow row in fm.Ss.Rows) { using (var ccmd = new SqlCommand("InsertSellInfo", con)) { ccmd.CommandType = CommandType.StoredProcedure; decimal salesquantity = 0; decimal tot = -1 * decimal.Parse(row["할인"].ToString()); salesquantity = tot / decimal.Parse(row["단가"].ToString()); ccmd.Parameters.AddWithValue("@barcode", row["바코드"].ToString()); ccmd.Parameters.AddWithValue("@quantity", row["수량"].ToString()); ccmd.Parameters.AddWithValue("@salesquantity", tot); ccmd.ExecuteNonQuery(); } } if (s.ClientID != null) { using (var ccmd = new SqlCommand("UpdatePoint", con)) { ccmd.CommandType = CommandType.StoredProcedure; ccmd.Parameters.AddWithValue("@phone", s.Phone); ccmd.ExecuteNonQuery(); } using (var ccmd = new SqlCommand("SelectMemberGrade", con)) { MessageBox.Show("Test"); ccmd.CommandType = CommandType.StoredProcedure; ccmd.Parameters.AddWithValue("@phone", s.Phone); ccmd.ExecuteNonQuery(); } } foreach (DataRow row in fm.Ss.Rows) { using (var ccmd = new SqlCommand("UpdateProducts", con)) { ccmd.CommandType = CommandType.StoredProcedure; ccmd.Parameters.AddWithValue("@barcode", row["바코드"].ToString()); ccmd.Parameters.AddWithValue("@quantity", row["수량"].ToString()); if (ccmd.ExecuteNonQuery() != 1) { MessageBox.Show("상품 재고 업데이트 에러"); } } } con.Close(); signPad1.Save(); this.Dispose(); }