//插入账单数据库 /*private void insert_account() * { * if (bankUnion.Text != "") * account.bankUnion = Convert.ToDouble(bankUnion.Text); * * if (creditCard.Text != "") * { * account.memberId = string.Join("|", m_Member_List.Keys.ToArray()); * account.creditCard = Convert.ToDouble(creditCard.Text); * } * * if (coupon.Text != "") * { * account.coupon = Convert.ToDouble(coupon.Text); * } * * if (groupBuy.Text != "") * { * account.groupBuy = Convert.ToDouble(groupBuy.Text); * } * * if (zero.Text != "") * { * account.name = customerId; * account.zero = Convert.ToDouble(zero.Text); * } * * if (cash.Text != "") * { * account.changes = Convert.ToDouble(changes.Text); * account.cash = Convert.ToDouble(cash.Text); * } * * if (wipeZero.Text != "") * { * account.wipeZero = Convert.ToDouble(wipeZero.Text); * } * * if (sign.Text != "") * { * account.server = Convert.ToDouble(sign.Text); * account.serverEmployee = signature; * } * }*/ //实时更新找零 private void money_TextChanged(object sender, EventArgs e) { string msg = validateTextFilds(); if (msg != "OK") { BathClass.printErrorMsg(msg); return; } double moneyPaid = 0; if (bankUnion.Text != "" && bankUnion.Text != "-") { moneyPaid += Convert.ToDouble(bankUnion.Text); } if (creditCard.Text != "" && creditCard.Text != "-") { moneyPaid += Convert.ToDouble(creditCard.Text); } if (coupon.Text != "" && coupon.Text != "-") { moneyPaid += Convert.ToDouble(coupon.Text); } if (groupBuy.Text != "" && groupBuy.Text != "-") { moneyPaid += Convert.ToDouble(groupBuy.Text); } if (zero.Text != "" && zero.Text != "-") { moneyPaid += Convert.ToDouble(zero.Text); } if (cash.Text != "" && cash.Text != "-") { moneyPaid += Convert.ToDouble(cash.Text); } if (wipeZero.Text != "" && wipeZero.Text != "-") { moneyPaid += Convert.ToDouble(wipeZero.Text); } if (sign.Text != "" && sign.Text != "-") { moneyPaid += Convert.ToDouble(sign.Text); } changes.Text = Math.Round((moneyPaid - Convert.ToDouble(moneyPayable.Text)), 2).ToString(); }
private void dgvPays_show(Customer c) { dgvCustomerPays.Rows.Clear(); var pays = db.CustomerPays.Where(x => x.customerId == c.id); foreach (var p in pays) { dgvCustomerPays.Rows.Add(p.id, p.cash, p.bank, p.date, p.payEmployee, p.note); } BathClass.set_dgv_fit(dgvCustomerPays); }
//发卡 public static bool destribute_card_M1(string company_code, string cardCode) { if (!connect_card_machine("M1")) { return(false); } ulong snr = 0; char mode = '1'; ICRF.rf_card(icdev, mode, ref snr); byte[] key1 = new byte[20]; byte[] key2 = new byte[20]; string skey = "6a3530303033"; int keylen = skey.Length; key1 = Encoding.ASCII.GetBytes(skey); ICRF.a_hex(key1, key2, 12); int st = ICRF.rf_load_key(icdev, 1, 2, key2); if (st != 0) { MessageBox.Show("装载密码失败"); ICRF.rf_exit(icdev); return(false); } st = ICRF.rf_authentication(icdev, 1, 2); if (st != 0) { MessageBox.Show("验证密码失败"); ICRF.rf_exit(icdev); return(false); } string str = company_code + cardCode; byte[] data = Encoding.ASCII.GetBytes(str); //byte[] buff = new byte[16]; //st = IC4442.my_encrypt(data, buff); st = ICRF.rf_write(icdev, 9, data); if (st != 0) { BathClass.printErrorMsg("写卡失败!"); return(false); } st = ICRF.rf_beep(icdev, 20); st = ICRF.rf_exit(icdev); return(true); }
private bool check_if_combined() { foreach (Control c in panel2.Controls) { if (c.GetType() == typeof(TextBox) && c.Text != "") { BathClass.printErrorMsg("请输入金额后,点击确定以混合方式结账!"); return(true); } } return(false); }
private void dgvActs_show(Customer c) { dgvActs.Rows.Clear(); var acts = db.Account.Where(x => x.zero != null && x.abandon == null && x.name == c.id.ToString()); foreach (var a in acts) { dgvActs.Rows.Add(a.id, a.text, a.payTime, a.payEmployee, a.zero); } BathClass.set_dgv_fit(dgvActs); }
//对话框载入 private void MonthTableForm_Load(object sender, EventArgs e) { int year = BathClass.Now(LogIn.connectionString).Year; yearBox.Items.Add(year); for (int i = 1; i < 11; i++) { yearBox.Items.Add(year - i); } yearBox.SelectedIndex = 0; monthBox.Text = BathClass.Now(LogIn.connectionString).Month.ToString(); }
//显示信息 private void setStatus(BathDBDataContext dc) { double money = 0; population.Text = m_Seats.Sum(x => x.population).ToString(); money = BathClass.get_rooms_expenses(dc, m_Seats, LogIn.connectionString); seatText.Text = ""; openTime.Text = ""; timeSpan.Text = ""; expense.Text = money.ToString(); moneyPayable.Text = money.ToString(); }
//连接读卡机 private static bool connect_card_machine(string cardType) { if (icdev > 0) { if (cardType == "SLE4442") { IC.ic_exit(icdev); } else if (cardType == "M1") { ICRF.rf_exit(icdev); } } string card_port = IOUtil.get_config_by_key(ConfigKeys.KEY_CARD_PORT); string card_baud = IOUtil.get_config_by_key(ConfigKeys.KEY_CARD_BAUD); string no_hint = IOUtil.get_config_by_key(ConfigKeys.KEY_CARD_NOHINT); if ((card_port == "" || card_baud == "") && (no_hint == "" || no_hint == "false")) { CardPortBaudForm cardPortBaudForm = new CardPortBaudForm(); if (cardPortBaudForm.ShowDialog() != DialogResult.OK) { return(false); } card_port = cardPortBaudForm.card_port.ToString(); card_baud = cardPortBaudForm.card_baud.ToString(); } if (card_port == "" || card_baud == "") { return(false); } Int16 port = Convert.ToInt16(card_port); int baud = Convert.ToInt32(card_baud); if (cardType == "SLE4442") { icdev = IC.ic_init(port, baud); } else if (cardType == "M1") { icdev = ICRF.rf_init(port, baud); } if (icdev <= 0) { BathClass.printErrorMsg("连接读卡器失败,请重试!"); return(false); } return(true); }
//定位 private void BtnPos_Click(object sender, EventArgs e) { int i = MConvert <int> .ToTypeOrDefault(TextMsgStart.Text.Trim(), 0); if (i >= dgv.Rows.Count) { BathClass.printErrorMsg("会员正在加载中,请稍等!"); return; } dgv.Rows[i].DefaultCellStyle.BackColor = Color.Cyan; }
private void dgv_show() { //var db = new BathDBDataContext(LogIn.connectionString); //var ct = db.ClearTable.OrderByDescending(x => x.clearTime).FirstOrDefault(); var ct = dao.get_last_clear_time(); var lastTime = DateTime.Parse("2013-01-01 00:00:00"); if (ct != null) { lastTime = ct.Value; } //var acts = db.Account.Where(x => x.text.Contains(m_seat_text) && x.payTime > lastTime && x.abandon == null); //dgv.DataSource = from x in acts // orderby x.payTime // select new // { // 账单号 = x.id, // 手牌号 = x.text, // 结账时间 = x.payTime, // 结账员工 = x.payEmployee // }; SqlConnection sqlCn = null; string cmd_str = ""; try { sqlCn = new SqlConnection(LogIn.connectionString); sqlCn.Open(); cmd_str = "Select * from [Account] where (abandon is null and payTime>'" + lastTime.ToString() + "' and text like" + "'%" + m_seat_text + "%')"; SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn); using (SqlDataReader dr = cmdSelect.ExecuteReader()) { while (dr.Read()) { dgv.Rows.Add(dr["id"], dr["text"], dr["payTime"], dr["payEmployee"]); } } } catch (System.Exception e) { IOUtil.insert_file(DateTime.Now.ToString() + "=" + cmd_str); BathClass.printErrorMsg(e.ToString()); } finally { dao.close_connection(sqlCn); } BathClass.set_dgv_fit(dgv); }
//确定 private void okBtn_Click(object sender, EventArgs e) { if (TextBigMenuName.Text == "") { BathClass.printErrorMsg("请选择一个要替换的项目!"); return; } if (SubstIDList.Count == 0) { BathClass.printErrorMsg("请选择要替换的项目!"); return; } if (newBigCombo) { string substIDs = ""; var menu = db.Menu.FirstOrDefault(x => x.name == TextBigMenuName.Text); if (db.BigCombo.Where(x => x.menuid == menu.id).Any()) { MessageBox.Show("该项目已存在,不能继续添加!"); return; } m_BigCombo.menuid = menu.id; m_BigCombo.price = menu.price; foreach (var s in SubstIDList) { substIDs += s; substIDs += Constants.SplitChar; } m_BigCombo.substmenuid = substIDs.Remove(substIDs.Length - 1); db.BigCombo.InsertOnSubmit(m_BigCombo); db.SubmitChanges(); this.DialogResult = DialogResult.OK; this.Close(); } else { string substIDs = ""; foreach (var s in SubstIDList) { substIDs += s; substIDs += Constants.SplitChar; } m_BigCombo.substmenuid = substIDs.Remove(substIDs.Length - 1); db.SubmitChanges(); this.DialogResult = DialogResult.OK; this.Close(); } }
//补卡 private void btnResume_Click(object sender, EventArgs e) { if (!BathClass.getAuthority(db, LogIn.m_User, "补卡")) { BathClass.printErrorMsg("权限不够!"); return; } MemberResumForm memberResumForm = new MemberResumForm(); memberResumForm.ShowDialog(); }
//添加 private void toolAdd_Click(object sender, EventArgs e) { GroupBuyItemAddForm f = new GroupBuyItemAddForm(db, m_Promotion); if (f.ShowDialog() == DialogResult.OK) { m_Offer.Add(f.m_Offer, f.m_discoutType + "#" + f.m_discout.ToString()); m_Promotion.menuIds = BathClass.assemble(m_Offer); db.SubmitChanges(); dgvDetails_show(); } }
//确定 private void btnOk_Click(object sender, EventArgs e) { if (ptList.SelectedIndex == -1) { BathClass.printErrorMsg("需要选择打印机 "); return; } printer = ptList.SelectedItem.ToString(); //write_printer(); IOUtil.set_config_by_key(ConfigKeys.KEY_PRINTER, printer); this.DialogResult = DialogResult.OK; }
//构造函数 public PromotionForm(BathDBDataContext dc, Promotion promotion) { db = dc; if (promotion != null) { newPromotion = false; m_Promotion = promotion; m_Offer = BathClass.disAssemble(db, m_Promotion); } InitializeComponent(); dgv_show(); }
//绑定快捷键 private void Form_KeyDown(object sender, KeyEventArgs e) { switch (e.KeyCode) { case Keys.Escape: this.Close(); break; case Keys.F1: addOfficer_Click(null, null); break; case Keys.F2: delOfficer_Click(null, null); break; case Keys.F3: editOfficer_Click(null, null); break; case Keys.F4: BathClass.exportDgvToExcel(dgv); break; case Keys.F5: PrintDGV.Print_DataGridView(dgv, "员工管理", false, ""); break; case Keys.F6: addTool_Click(null, null); break; case Keys.F7: delTool_Click(null, null); break; case Keys.F8: editTool_Click(null, null); break; case Keys.F9: authoTool_Click(null, null); break; case Keys.F10: modifyPwdTool_Click(null, null); break; default: break; } }
//单项项目统计 private void find_0() { dgv.Columns.Clear(); add_cols_to_dgv(dgv, "编号"); add_cols_to_dgv(dgv, "发生时间"); add_cols_to_dgv(dgv, "项目名称"); add_cols_to_dgv(dgv, "手牌号"); add_cols_to_dgv(dgv, "数量"); add_cols_to_dgv(dgv, "金额"); add_cols_to_dgv(dgv, "输入员工"); add_cols_to_dgv(dgv, "技师号"); add_cols_to_dgv(dgv, "账单号"); add_cols_to_dgv(dgv, "单据号"); var orderLst = db.Orders.Where(x => x.menu == menu.Text && x.inputTime >= lastTime && x.inputTime <= thisTime && x.deleteEmployee == null); var paid_orderLst = db.HisOrders.Where(x => x.menu == menu.Text && x.inputTime >= lastTime && x.inputTime <= thisTime && x.deleteEmployee == null); if (cboxBill.Checked && tbBill.Text != "") { orderLst = db.Orders.Where(x => x.billId == tbBill.Text); paid_orderLst = db.HisOrders.Where(x => x.billId == tbBill.Text); if (!orderLst.Any() && !paid_orderLst.Any()) { BathClass.printErrorMsg("输入单据号不存在!"); return; } } double number = 0; double money = 0; foreach (Orders order in orderLst) { number += order.number; money += Convert.ToDouble(order.money); dgv.Rows.Add(order.id, order.inputTime, order.menu, order.text, order.number, order.money, order.inputEmployee, order.technician, order.accountId, order.billId); } foreach (var order in paid_orderLst) { number += order.number; money += Convert.ToDouble(order.money); dgv.Rows.Add(order.id, order.inputTime, order.menu, order.text, order.number, order.money, order.inputEmployee, order.technician, order.accountId, order.billId); } dgv.Rows.Add("合计", "", menu.Text, "", number, money); BathClass.set_dgv_fit(dgv); }
//获取会员卡 private void get_member() { string card_data = ""; string company_code = db.Options.FirstOrDefault().companyCode; bool st = false; var cardType = db.MemberSetting.FirstOrDefault().cardType; if (cardType == "SLE4442") { st = ICCard.read_data_4442(company_code, ref card_data); } else if (cardType == "M1") { st = ICCard.read_data_M1(company_code, ref card_data); } if (!st) { return; } m_member = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == card_data); //m_member = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == "05302"); if (m_member == null) { BathClass.printErrorMsg("非本公司卡!"); return; } id.Text = m_member.CI_CardNo; name.Text = m_member.CI_Name; phone.Text = m_member.CI_Telephone; var t = db.MemberType.FirstOrDefault(x => x.id == m_member.CI_CardTypeNo); if (t != null) { memberType.Text = t.name; } var cc = db.CardCharge.Where(x => x.CC_CardNo == m_member.CI_CardNo); double debit = BathClass.ToInt(cc.Sum(x => x.CC_DebitSum)); double lend = BathClass.ToInt(cc.Sum(x => x.CC_LenderSum)); balance.Text = (debit - lend).ToString(); var c = BathClass.ToInt(m_member.CI_CreditsUsed); var cu = BathClass.ToInt(db.MemberSetting.FirstOrDefault().money); int cs = (int)(lend / cu - c); credits.Text = cs.ToString(); btnOk.Text = "会员打折"; }
//减少 private void btnDec_Click(object sender, EventArgs e) { if (m_room.seatIds == null) { BathClass.printErrorMsg("已经为0!"); return; } var ids = m_room.seatIds.Split('|').ToList(); if (ids.Count == 0) { BathClass.printErrorMsg("已经为0!"); return; } if (ids.Count == 1) { m_room.seatIds = null; dc.SubmitChanges(); this.Close(); return; } List <int> s = new List <int>(); s.Add(2); s.Add(6); s.Add(7); InputSeatForm form = new InputSeatForm(s); if (form.ShowDialog() != DialogResult.OK) { return; } var t = form.m_Seat.text; if (!ids.Contains(t)) { BathClass.printErrorMsg("手牌:" + t + "不在该房间"); return; } ids.Remove(t); if (ids.Count == 0) { m_room.seatIds = null; } else { m_room.seatIds = string.Join("|", ids.ToArray()); } curPop.Text = m_room.seatIds; }
//加收过夜费 private void order_guoye(HotelRoom seat, BathDBDataContext dc) { if (!BathClass.ToBool(m_Options.自动加收过夜费)) { return; } if (dc.Orders.FirstOrDefault(x => x.systemId == seat.systemId && x.menu == "过夜费") != null || dc.HisOrders.FirstOrDefault(x => x.systemId == seat.systemId && x.menu == "过夜费") != null) { return; } var m_OverMenu = dc.Menu.FirstOrDefault(x => x.name == "过夜费"); if (m_OverMenu == null) { return; } DateTime now = DateTime.Now; string year = now.Year.ToString(); string month = now.Month.ToString(); string day = now.Day.ToString(); string date = year + "-" + month + "-" + day + " "; string time = ":00:00"; DateTime st = DateTime.Parse(date + m_Options.过夜费起点 + time); DateTime et = DateTime.Parse(date + m_Options.过夜费终点 + time); DateTime open_time = seat.openTime.Value; if ((now >= et && open_time >= et) || (open_time <= st && now <= st)) { return; } Orders order = new Orders(); order.menu = m_OverMenu.name; order.text = seat.text; order.systemId = seat.systemId; order.number = 1; order.money = m_OverMenu.price; order.inputTime = now; order.inputEmployee = "过夜费"; order.departmentId = 1; order.paid = false; dc.Orders.InsertOnSubmit(order); dc.SubmitChanges(); find_combo(dc, order); }
//技师管理 private void toolTech_Click(object sender, EventArgs e) { //var db_new = new BathDBDataContext(LogIn.connectionString); if (!dao.get_authority(LogIn.m_User, "技师管理")) { BathClass.printErrorMsg("不具有权限"); return; } TechnicianSeclectForm technicianForm = new TechnicianSeclectForm(); technicianForm.ShowDialog(); }
//显示清单 public void dgv_show() { dgv.DataSource = from x in db.WaiterItem orderby x.id select new { 编号 = x.id, 称 = x.name, 备注 = x.note }; BathClass.set_dgv_fit(dgv); }
//确定 private void btnOk_Click(object sender, EventArgs e) { btnOk.Enabled = false; btnOk.Enabled = true; if (text.Text == "") { BathClass.printErrorMsg("需要输入内容!"); return; } str = text.Text; this.DialogResult = DialogResult.OK; }
//显示信息 private void dgv_show() { dgv.DataSource = from x in db.BarMsg where x.time >= startTime.Value && x.time <= endTime.Value select new { 编号 = x.id, 时间 = x.time, 包厢 = x.roomId, 信息 = x.msg }; BathClass.set_dgv_fit(dgv); }
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (dgv.CurrentCell == null) { BathClass.printErrorMsg("未选择行"); return; } var memberId = dgv.CurrentRow.Cells[0].Value.ToString(); var form = new MemberItemChart(memberId); form.ShowDialog(); }
//录单汇总 private void toolAllOrder_Click(object sender, EventArgs e) { //var db_new = new BathDBDataContext(LogIn.connectionString); if (!dao.get_authority(LogIn.m_User, "录单汇总")) { BathClass.printErrorMsg("不具有权限"); return; } TableOrderTableForm orderTableForm = new TableOrderTableForm(LogIn.connectionString, LogIn.m_User); orderTableForm.ShowDialog(); }
private bool validateTextFields() { foreach (Control c in groupBox1.Controls) { if (c.GetType() != typeof(Label) && c.Name != "cost" && c.Name != "note" && c.Text == "") { c.Focus(); BathClass.printErrorMsg("需要输入内容"); return(false); } } return(true); }
//客房 private void btnRoom_Click(object sender, EventArgs e) { //BathDBDataContext db_new = new BathDBDataContext(LogIn.connectionString); if (!dao.get_authority(LogIn.m_User, "包房管理")) { BathClass.printErrorMsg("权限不够!"); return; } RoomViewForm rmvForm = new RoomViewForm(); rmvForm.ShowDialog(); }
private void dgv_show() { get_timeSpan(); if (details) { find_details(); } else { find_summery(); } BathClass.set_dgv_fit(dgv); }
//构造函数 public MemberFingerForm(CCardInfo member) { InitializeComponent(); try { dao = new DAO(LogIn.connectionString); m_member = member; } catch (System.Exception e) { BathClass.printErrorMsg(e.Message); } }