//签字免单 private void freeTool_Click(object sender, EventArgs e) { SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) { return; } var dc_new = new BathDBDataContext(LogIn.connectionString); Account account = new Account(); insert_account(dc_new, ref account, inputSerForm.signature); set_order_paid(dc_new, account); update_seat_room(dc_new); dc_new.SubmitChanges(); setStatus(dc_new); if (printBill) { printTool_Click(dc_new, "结账单"); } if (printStubBill) { printTool_Click(dc_new, "存根单"); } if (printShoe) { List <string> seat_texts = new List <string>(); var ts = account.text.Split('|').ToList(); foreach (var tx in ts) { var s = m_Seats.FirstOrDefault(x => x.text == tx); if (s == null) { continue; } int i = m_Seats.IndexOf(s); if (dgvChain.Rows[i].Cells[1].EditedFormattedValue.ToString() == "False") { seat_texts.Add(tx); } } PrintShoeMsg.Print_DataGridView(seat_texts, account.payEmployee, account.payTime.ToString(), companyName); } this.DialogResult = DialogResult.OK; }
//判断是否需要会员卡 private bool memberCardNeed() { if (creditCard.Text != "") { CardUsingForm memberCardUsingForm = new CardUsingForm(Convert.ToDouble(creditCard.Text)); if (memberCardUsingForm.ShowDialog() != DialogResult.OK) { return(false); } m_Member_List = memberCardUsingForm.m_memberList; if (watch) { BathClass.sendMessageToCamera(db, m_Seats[0].systemId); } } if (coupon.Text != "" && watch) { BathClass.sendMessageToCamera(db, m_Seats[0].systemId); } if (zero.Text != "") { CustomerChooseForm customerChooseForm = new CustomerChooseForm(); if (customerChooseForm.ShowDialog() != DialogResult.OK) { return(false); } customerId = customerChooseForm.customerId; Customer customer = db.Customer.FirstOrDefault(x => x.id.ToString() == customerId); customer.money += Convert.ToDouble(zero.Text); db.SubmitChanges(); } if (sign.Text != "") { SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) { return(false); } signature = inputSerForm.signature; } return(true); }
//签字免单 private void signTool_Click(object sender, EventArgs e) { //2,更新订单信息,修改订单paid属性 //3,插入账单数据库,更新 //4,更新台位信息 //5,更新客房信息 if (check_if_combined()) { return; } SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) { return; } if (!signTool.Enabled) { return; } signTool.Enabled = false; try { set_account(); account.server = m_money; account.serverEmployee = inputSerForm.signature; db.Account.InsertOnSubmit(account); db.SubmitChanges(); set_order_paid(); update_seat_room(); insert_member_infor(); db.SubmitChanges(); this.DialogResult = DialogResult.OK; } catch (System.Exception ex) { handle_exception(ex); } }
//签字免单 private void freeTool_Click(object sender, EventArgs e) { SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) return; var dc_new = new BathDBDataContext(LogIn.connectionString); Account account = new Account(); insert_account(dc_new, ref account, inputSerForm.signature); set_order_paid(dc_new, account); update_seat_room(dc_new); dc_new.SubmitChanges(); setStatus(dc_new); if (printBill) printTool_Click(dc_new, "结账单"); if (printStubBill) printTool_Click(dc_new, "存根单"); if (printShoe) { List<string> seat_texts = new List<string>(); var ts = account.text.Split('|').ToList(); foreach (var tx in ts) { var s = m_Seats.FirstOrDefault(x => x.text == tx); if (s == null) continue; int i = m_Seats.IndexOf(s); if (dgvChain.Rows[i].Cells[1].EditedFormattedValue.ToString() == "False") seat_texts.Add(tx); } PrintShoeMsg.Print_DataGridView(seat_texts, account.payEmployee, account.payTime.ToString(), companyName); } this.DialogResult = DialogResult.OK; }
//确定 private void btnOk_Click(object sender, EventArgs e) { if (btnOk.Text == "读卡") get_member(); else if (btnOk.Text == "充值") { string bank = tb_bank.Text.Trim(); string cash = tb_cash.Text.Trim(); string server = tb_server.Text.Trim(); if (cash == "" && bank == "" && server == "") { BathClass.printErrorMsg("需要输入充值金额"); return; } string serverEmployee = string.Empty; if (tb_server.Text.Trim() != "") { var form = new SignForFreeForm(); if (form.ShowDialog() != DialogResult.OK) { BathClass.printErrorMsg("需要输入赠送人姓名"); return; } serverEmployee = form.signature; } string pars = ""; string vals = ""; pars = "memberId"; vals = "'" + id.Text + "'"; if (balance.Text != "") { pars += ",balance"; vals += ",'" + balance.Text + "'"; } double money = 0; if (bank != "") { double b = Convert.ToDouble(bank); pars += ",bankUnion"; vals += ",'" + bank + "'"; money += b; } if (cash != "") { double c = Convert.ToDouble(cash); pars += ",cash"; vals += ",'" + cash + "'"; money += c; } if (server != "") { double s = Convert.ToDouble(server); pars += ",server"; vals += ",'" + server + "'"; money += s; pars += ",serverEmployee"; vals += ",'" + serverEmployee + "'"; } if (tb_seat.Text.Trim() != "") { pars += ",seat"; vals += ",'" + tb_seat.Text + "'"; } pars += ",macAddress"; vals += ",'" + PCUtil.getMacAddr_Local() + "'"; pars += ",explain"; vals += ",'会员充值'"; pars += ",payEmployee"; vals += ",'" + LogIn.m_User.id + "'"; pars += ",payTime"; vals += ",getdate()"; string cmd_str = @"insert into [CardSale](" + pars + ") values(" + vals + ") "; #region 会员充值 pars = "CC_CardNo"; vals = "'" + m_member.CI_CardNo + "'"; pars += ",CC_DebitSum"; vals += "," + money; pars += ",CC_ItemExplain"; vals += ",'会员卡充值-收'"; pars += ",CC_InputOperator"; vals += ",'" + LogIn.m_User.id + "'"; pars += ",CC_InputDate"; vals += ",getdate()"; if (m_Seat != null) { pars += ",systemId"; vals += ",'" + m_Seat.systemId + "'"; } cmd_str += @" insert into [CardCharge](" + pars + ") values(" + vals + ")"; #endregion #region 会员充值送 var sale_money = get_promotion_for_cardPop(money); if (sale_money != 0) { BathClass.printInformation("会员充值送" + sale_money.ToString()); pars = "CC_CardNo"; vals = "'" + m_member.CI_CardNo + "'"; pars += ",CC_DebitSum"; vals += "," + sale_money; pars += ",CC_ItemExplain"; vals += ",'会员卡充值-送'"; pars += ",CC_InputOperator"; vals += ",'" + LogIn.m_User.id + "'"; pars += ",CC_InputDate"; vals += ",getdate()"; if (m_Seat != null) { pars += ",systemId"; vals += ",'" + m_Seat.systemId + "'"; } cmd_str += @" insert into [CardCharge](" + pars + ") values(" + vals + ")"; } #endregion if (!dao.execute_command(cmd_str)) { BathClass.printErrorMsg("会员充值失败,请重试!"); return; } Dictionary<string, string> pay_info = new Dictionary<string, string>(); if (bank != "") { pay_info["银联"] = bank; } if (cash != "") { pay_info["现金"] = cash; } if (server != "") { pay_info["招待"] = server + "$" + serverEmployee; } string bl = dao.get_member_balance(id.Text).ToString(); PrintMemberPopMsg.Print_DataGridView(id.Text, type.Text, bl, LogIn.m_User.id, DateTime.Now.ToString("MM-dd HH:mm"), LogIn.options.companyName, pay_info, tb_seat.Text); this.DialogResult = DialogResult.OK; this.Close(); } }
//签字免单 private void signTool_Click(object sender, EventArgs e) { //2,更新订单信息,修改订单paid属性 //3,插入账单数据库,更新 //4,更新台位信息 //5,更新客房信息 if (check_if_combined()) return; SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) return; if (!signTool.Enabled) return; signTool.Enabled = false; try { set_account(); account.server = m_money; account.serverEmployee = inputSerForm.signature; db.Account.InsertOnSubmit(account); db.SubmitChanges(); set_order_paid(); update_seat_room(); insert_member_infor(); db.SubmitChanges(); this.DialogResult = DialogResult.OK; } catch (System.Exception ex) { handle_exception(ex); } }
//判断是否需要会员卡 private bool memberCardNeed() { if (creditCard.Text != "") { CardUsingForm memberCardUsingForm = new CardUsingForm(Convert.ToDouble(creditCard.Text)); if (memberCardUsingForm.ShowDialog() != DialogResult.OK) return false; m_Member_List = memberCardUsingForm.m_memberList; if (watch) BathClass.sendMessageToCamera(db, m_Seats[0].systemId); } if (coupon.Text != "" && watch) BathClass.sendMessageToCamera(db, m_Seats[0].systemId); if (zero.Text != "") { CustomerChooseForm customerChooseForm = new CustomerChooseForm(); if (customerChooseForm.ShowDialog() != DialogResult.OK) return false; customerId = customerChooseForm.customerId; Customer customer = db.Customer.FirstOrDefault(x => x.id.ToString() == customerId); customer.money += Convert.ToDouble(zero.Text); db.SubmitChanges(); } if (sign.Text != "") { SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) return false; signature = inputSerForm.signature; } return true; }
//签字免单 private void signTool_Click(object sender, EventArgs e) { //2,更新订单信息,修改订单paid属性 //3,插入账单数据库,更新 //4,更新台位信息 //5,更新客房信息 if (check_if_combined()) return; SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) return; if (!signTool.Enabled) return; signTool.Enabled = false; try { string cmd_str = ""; set_account(); //account.server = m_money; //account.serverEmployee = inputSerForm.signature; //if (!dao.exist_instance("Account", "systemId='" + account.systemId + "' and abandon is null")) //{ string pars = @"text,systemId,openTime,openEmployee,payTime,payEmployee,macAddress"; string vals = "'" + account.text + "','" + account.systemId + "','" + account.openTime + "','" + account.openEmployee + "',getdate(),'" + account.payEmployee + "','" + account.macAddress + "'"; if (account.promotionMemberId != null) { pars += ",promotionMemberId"; vals += ",'" + account.promotionMemberId + "'"; } if (account.promotionAmount != null) { pars += ",promotionAmount"; vals += ",'" + account.promotionAmount + "'"; } pars += ",server"; vals += "," + m_money.ToString(); pars += ",serverEmployee"; vals += ",'" + inputSerForm.signature + "'"; cmd_str = @"declare @NewAct TABLE (id INT NOT NULL PRIMARY KEY)"; cmd_str += @" insert into [Account](" + pars + ") output inserted.id into @NewAct values(" + vals + ") "; //} cmd_str += " " + set_order_paid(); cmd_str += " " + insert_member_infor(); cmd_str += " " + update_seat_room(); cmd_str += " select id from @NewAct"; if (!dao.insert_account(cmd_str, ref _newAccountId)) { btnOk.Enabled = true; BathClass.printErrorMsg("结账失败,请重试!"); return; } //db.Account.InsertOnSubmit(account); //db.SubmitChanges(); //set_order_paid(); //insert_member_infor(); //db.SubmitChanges(); //update_seat_room(); //db.SubmitChanges(); this.DialogResult = DialogResult.OK; } catch (System.Exception ex) { BathClass.printErrorMsg("系统出错:" + ex.Message + ",请重试!"); } }
//判断是否需要会员卡 private bool memberCardNeed() { if (creditCard.Text != "") { CardUsingForm memberCardUsingForm = new CardUsingForm(Convert.ToDouble(creditCard.Text)); if (memberCardUsingForm.ShowDialog() != DialogResult.OK) return false; m_Member_List = memberCardUsingForm.m_memberList; if (watch) { if (!BathClass.sendMessageToCamera(dao, m_Seats[0].systemId)) { BathClass.printErrorMsg("发送消息给摄像头失败,请重试!"); return false; } } } if (coupon.Text != "" && watch) { if (!BathClass.sendMessageToCamera(dao, m_Seats[0].systemId)) { BathClass.printErrorMsg("发送消息给摄像头失败,请重试!"); return false; } } if (zero.Text != "") { CustomerChooseForm customerChooseForm = new CustomerChooseForm(); if (customerChooseForm.ShowDialog() != DialogResult.OK) return false; customerId = customerChooseForm.customerId; string cmd_str = "update [Customer] set money=isnull(money,0)+" + zero.Text + " where id=" + customerId.ToString(); if (!dao.execute_command(cmd_str)) { BathClass.printErrorMsg("客户累计金额失败,请重试!"); return false; } ////Customer customer = db.Customer.FirstOrDefault(x => x.id.ToString() == customerId); ////customer.money += Convert.ToDouble(zero.Text); ////db.SubmitChanges(); } if (sign.Text != "") { SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) return false; signature = inputSerForm.signature; } return true; }
//判断是否需要会员卡 private bool memberCardNeed() { if (creditCard.Text != "") { CardUsingForm memberCardUsingForm = new CardUsingForm(Convert.ToDouble(creditCard.Text)); if (memberCardUsingForm.ShowDialog() != DialogResult.OK) { return(false); } m_Member_List = memberCardUsingForm.m_memberList; if (watch) { if (!BathClass.sendMessageToCamera(dao, m_Seats[0].systemId)) { BathClass.printErrorMsg("发送消息给摄像头失败,请重试!"); return(false); } } } if (coupon.Text != "" && watch) { if (!BathClass.sendMessageToCamera(dao, m_Seats[0].systemId)) { BathClass.printErrorMsg("发送消息给摄像头失败,请重试!"); return(false); } } if (zero.Text != "") { CustomerChooseForm customerChooseForm = new CustomerChooseForm(); if (customerChooseForm.ShowDialog() != DialogResult.OK) { return(false); } customerId = customerChooseForm.customerId; string cmd_str = "update [Customer] set money=isnull(money,0)+" + zero.Text + " where id=" + customerId.ToString(); if (!dao.execute_command(cmd_str)) { BathClass.printErrorMsg("客户累计金额失败,请重试!"); return(false); } ////Customer customer = db.Customer.FirstOrDefault(x => x.id.ToString() == customerId); ////customer.money += Convert.ToDouble(zero.Text); ////db.SubmitChanges(); } if (sign.Text != "") { SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) { return(false); } signature = inputSerForm.signature; } return(true); }
//签字免单 private void signTool_Click(object sender, EventArgs e) { //2,更新订单信息,修改订单paid属性 //3,插入账单数据库,更新 //4,更新台位信息 //5,更新客房信息 if (check_if_combined()) { return; } SignForFreeForm inputSerForm = new SignForFreeForm(); if (inputSerForm.ShowDialog() != DialogResult.OK) { return; } if (!signTool.Enabled) { return; } signTool.Enabled = false; try { string cmd_str = ""; set_account(); //account.server = m_money; //account.serverEmployee = inputSerForm.signature; //if (!dao.exist_instance("Account", "systemId='" + account.systemId + "' and abandon is null")) //{ string pars = @"text,systemId,openTime,openEmployee,payTime,payEmployee,macAddress"; string vals = "'" + account.text + "','" + account.systemId + "','" + account.openTime + "','" + account.openEmployee + "',getdate(),'" + account.payEmployee + "','" + account.macAddress + "'"; if (account.promotionMemberId != null) { pars += ",promotionMemberId"; vals += ",'" + account.promotionMemberId + "'"; } if (account.promotionAmount != null) { pars += ",promotionAmount"; vals += ",'" + account.promotionAmount + "'"; } pars += ",server"; vals += "," + m_money.ToString(); pars += ",serverEmployee"; vals += ",'" + inputSerForm.signature + "'"; cmd_str = @"declare @NewAct TABLE (id INT NOT NULL PRIMARY KEY)"; cmd_str += @" insert into [Account](" + pars + ") output inserted.id into @NewAct values(" + vals + ") "; //} cmd_str += " " + set_order_paid(); cmd_str += " " + insert_member_infor(); cmd_str += " " + update_seat_room(); cmd_str += " select id from @NewAct"; if (!dao.insert_account(cmd_str, ref _newAccountId)) { btnOk.Enabled = true; BathClass.printErrorMsg("结账失败,请重试!"); return; } //db.Account.InsertOnSubmit(account); //db.SubmitChanges(); //set_order_paid(); //insert_member_infor(); //db.SubmitChanges(); //update_seat_room(); //db.SubmitChanges(); this.DialogResult = DialogResult.OK; } catch (System.Exception ex) { BathClass.printErrorMsg("系统出错:" + ex.Message + ",请重试!"); } }
//确定 private void btnOk_Click(object sender, EventArgs e) { if (btnOk.Text == "读卡") { get_member(); } else if (btnOk.Text == "充值") { string bank = tb_bank.Text.Trim(); string cash = tb_cash.Text.Trim(); string server = tb_server.Text.Trim(); if (cash == "" && bank == "" && server == "") { BathClass.printErrorMsg("需要输入充值金额"); return; } string serverEmployee = string.Empty; if (tb_server.Text.Trim() != "") { var form = new SignForFreeForm(); if (form.ShowDialog() != DialogResult.OK) { BathClass.printErrorMsg("需要输入赠送人姓名"); return; } serverEmployee = form.signature; } string pars = ""; string vals = ""; pars = "memberId"; vals = "'" + id.Text + "'"; if (balance.Text != "") { pars += ",balance"; vals += ",'" + balance.Text + "'"; } double money = 0; if (bank != "") { double b = Convert.ToDouble(bank); pars += ",bankUnion"; vals += ",'" + bank + "'"; money += b; } if (cash != "") { double c = Convert.ToDouble(cash); pars += ",cash"; vals += ",'" + cash + "'"; money += c; } if (server != "") { double s = Convert.ToDouble(server); pars += ",server"; vals += ",'" + server + "'"; money += s; pars += ",serverEmployee"; vals += ",'" + serverEmployee + "'"; } if (tb_seat.Text.Trim() != "") { pars += ",seat"; vals += ",'" + tb_seat.Text + "'"; } pars += ",macAddress"; vals += ",'" + PCUtil.getMacAddr_Local() + "'"; pars += ",explain"; vals += ",'会员充值'"; pars += ",payEmployee"; vals += ",'" + LogIn.m_User.id + "'"; pars += ",payTime"; vals += ",getdate()"; string cmd_str = @"insert into [CardSale](" + pars + ") values(" + vals + ") "; #region 会员充值 pars = "CC_CardNo"; vals = "'" + m_member.CI_CardNo + "'"; pars += ",CC_DebitSum"; vals += "," + money; pars += ",CC_ItemExplain"; vals += ",'会员卡充值-收'"; pars += ",CC_InputOperator"; vals += ",'" + LogIn.m_User.id + "'"; pars += ",CC_InputDate"; vals += ",getdate()"; if (m_Seat != null) { pars += ",systemId"; vals += ",'" + m_Seat.systemId + "'"; } cmd_str += @" insert into [CardCharge](" + pars + ") values(" + vals + ")"; #endregion #region 会员充值送 var sale_money = get_promotion_for_cardPop(money); if (sale_money != 0) { BathClass.printInformation("会员充值送" + sale_money.ToString()); pars = "CC_CardNo"; vals = "'" + m_member.CI_CardNo + "'"; pars += ",CC_DebitSum"; vals += "," + sale_money; pars += ",CC_ItemExplain"; vals += ",'会员卡充值-送'"; pars += ",CC_InputOperator"; vals += ",'" + LogIn.m_User.id + "'"; pars += ",CC_InputDate"; vals += ",getdate()"; if (m_Seat != null) { pars += ",systemId"; vals += ",'" + m_Seat.systemId + "'"; } cmd_str += @" insert into [CardCharge](" + pars + ") values(" + vals + ")"; } #endregion if (!dao.execute_command(cmd_str)) { BathClass.printErrorMsg("会员充值失败,请重试!"); return; } Dictionary <string, string> pay_info = new Dictionary <string, string>(); if (bank != "") { pay_info["银联"] = bank; } if (cash != "") { pay_info["现金"] = cash; } if (server != "") { pay_info["招待"] = server + "$" + serverEmployee; } string bl = dao.get_member_balance(id.Text).ToString(); PrintMemberPopMsg.Print_DataGridView(id.Text, type.Text, bl, LogIn.m_User.id, DateTime.Now.ToString("MM-dd HH:mm"), LogIn.options.companyName, pay_info, tb_seat.Text); this.DialogResult = DialogResult.OK; this.Close(); } }