//赠送卡
private void btn_free_Click(object sender, EventArgs e)
{
if (btnOk.Text == "读卡")
{
get_member();
}
else if (btnOk.Text == "激活")
{
if (m_use_finder_pwd && m_finger == null)
{
if (BathClass.printAskMsg("系统指定需要使用指纹密码，是否确定放弃录入指纹?") != DialogResult.Yes)
{
return;
}
}
if (tb_cash.Text.Trim() != "" || tb_bank.Text.Trim() != "")
{
BathClass.printErrorMsg("已经输入付款金额，请点击\"激活\"售卡激活!");
return;
}
string pars = "memberId";
string vals = "'" + m_member.CI_CardNo + "'";
pars += ",payEmployee";
vals += ",'" + LogIn.m_User.id + "'";
pars += ",payTime";
vals += ",getdate()";
pars += ",macAddress";
vals += ",'" + PCUtil.getMacAddr_Local() + "'";
if (balance.Text != "")
{
pars += ",balance";
vals += ",'" + balance.Text + "'";
}
pars += ",note";
vals += ",'赠送卡'";
if (tb_seat.Text != "")
{
pars += ",seat";
vals += ",'" + tb_seat.Text + "'";
}
string cmd_str = @"insert into [CardSale](" + pars + ") values(" + vals + ") ";
if (m_finger == null || m_finger == "")
{
m_finger = "null";
}
else
{
m_finger = "'" + m_finger + "'";
}
cmd_str += @"update [CardInfo] set state='在用',CI_Password="******" where CI_CardNo='" + id.Text + "'";
if (!dao.execute_command(cmd_str))
{
BathClass.printErrorMsg("赠送卡失败，请重试!");
return;
}
string seat = null;
if (tb_seat.Text != "")
{
seat = tb_seat.Text;
}
PrintMemberActivateMsg.Print_DataGridView(id.Text, type.Text, balance.Text, LogIn.m_User.id,
DateTime.Now.ToString("MM-dd HH:mm"), LogIn.options.companyName, null, seat);
this.DialogResult = DialogResult.OK;
}
}
//确定
private void btnOk_Click(object sender, EventArgs e)
{
if (btnOk.Text == "读卡")
{
get_member();
}
else if (btnOk.Text == "激活")
{
if (m_use_finder_pwd && m_finger == null)
{
if (BathClass.printAskMsg("系统指定需要使用指纹密码，是否确定放弃录入指纹?") != DialogResult.Yes)
{
return;
}
}
var m_waiter = dao.get_Employee("id='" + tb_waiter.Text + "'");
if (m_waiter == null)
{
BathClass.printErrorMsg("输入服务员工号不存在!");
return;
}
if (tb_cash.Text.Trim() == "" && tb_bank.Text.Trim() == "")
{
BathClass.printErrorMsg("需要输入金额!");
return;
}
double card_val = find_card_value(MConvert <double> .ToTypeOrDefault(balance.Text, 0));
if (card_val != -1 && MConvert <double> .ToTypeOrDefault(tb_cash.Text, 0) + MConvert <double> .ToTypeOrDefault(tb_bank.Text, 0) < card_val)
{
BathClass.printErrorMsg("付款金额不足");
return;
}
string pars = "";
string vals = "";
pars = "memberId";
vals = "'" + m_member.CI_CardNo + "'";
pars += ",payEmployee";
vals += ",'" + m_waiter.id + "'";
pars += ",payTime";
vals += ",getdate()";
pars += ",macAddress";
vals += ",'" + PCUtil.getMacAddr_Local() + "'";
Dictionary <string, string> pay_info = new Dictionary <string, string>();
if (tb_bank.Text.Trim() != "")
{
pars += ",bankUnion";
vals += ",'" + tb_bank.Text + "'";
pay_info["银联"] = tb_bank.Text;
}
if (tb_cash.Text.Trim() != "")
{
pars += ",cash";
vals += ",'" + tb_cash.Text + "'";
pay_info["现金"] = tb_cash.Text;
}
if (balance.Text != "")
{
pars += ",balance";
vals += ",'" + balance.Text + "'";
}
if (tb_seat.Text != "")
{
pars += ",seat";
vals += ",'" + tb_seat.Text + "'";
}
string cmd_str = @"insert into [CardSale](" + pars + ") values(" + vals + ")";
if (m_finger == null || m_finger == "")
{
m_finger = "null";
}
else
{
m_finger = "'" + m_finger + "'";
}
cmd_str += @"update [CardInfo] set state='在用',CI_Password="******" where CI_CardNo='" + id.Text + "'";
if (!dao.execute_command(cmd_str))
{
BathClass.printErrorMsg("会员激活失败，请重试!");
return;
}
string seat = null;
if (tb_seat.Text != "")
{
seat = tb_seat.Text;
}
PrintMemberActivateMsg.Print_DataGridView(id.Text, type.Text, balance.Text, LogIn.m_User.id,
DateTime.Now.ToString("MM-dd HH:mm"), LogIn.options.companyName, pay_info, seat);
this.DialogResult = DialogResult.OK;
}
else if (btnOk.Text == "退卡")
{
if (BathClass.printAskMsg("确定退还卡号：" + m_member.CI_CardNo + "?") != DialogResult.Yes)
{
return;
}
if (dao.exist_instance("CardCharge", "CC_CardNo='" + m_member.CI_CardNo + "' and (CC_ItemExplain='会员刷卡' or CC_ItemExplain='会员打折')"))
{
BathClass.printErrorMsg("已有消费记录，不能退卡");
return;
}
string cmd_str = @" update cardSale set abandon='" + LogIn.m_User.id + "' where id in (select top 1 id from cardsale where memberId='" + id.Text + "' order by id desc)";
cmd_str += @"update [CardInfo] set state='入库' where CI_CardNo='" + id.Text + "'";
if (!dao.execute_command(cmd_str))
{
BathClass.printErrorMsg("退卡失败，请重试!");
return;
}
this.DialogResult = DialogResult.OK;
}
}
