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