//赠送卡 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; } }