//构造函数 public DepositForm(CSeat seat) { db = new BathDBDataContext(LogIn.connectionString); m_Seat = seat; dao = new DAO(LogIn.connectionString); //m_Seat = db.Seat.FirstOrDefault(x => x.systemId == seat.systemId); InitializeComponent(); }
//构造函数 public OrderCheckForm(CSeat seat, string con_str, COptions options) { m_con_str = con_str; m_Seat = seat; m_options = options; dao = new DAO(con_str); InitializeComponent(); }
//构造函数 public MemberFingerForm(CCardInfo member) { InitializeComponent(); try { dao = new DAO(LogIn.connectionString); m_member = member; } catch (System.Exception e) { BathClass.printErrorMsg(e.Message); } }
//构造函数 public MemberPromotionForm(List<CSeat> seat, string systemid) { InitializeComponent(); try { dao = new DAO(LogIn.connectionString); m_systemId = systemid; m_Seats = seat; } catch (System.Exception e) { BathClass.printErrorMsg(e.Message); } }
public OpenSeatForm(CSeat seat, bool open) { m_open = open; //var db = new BathDBDataContext(LogIn.connectionString); m_Seats.Add(seat); seat_length = seat.text.Length; dao = new DAO(LogIn.connectionString); chainId = dao.chainId(); seatlock = LogIn.options.启用手牌锁.Value; lock_type = LogIn.options.手牌锁类型; auto_seat_card = MConvert<bool>.ToTypeOrDefault(LogIn.options.自动感应手牌, false); InitializeComponent(); seatBox.Enabled = MConvert<bool>.ToTypeOrDefault(LogIn.options.允许手工输入手牌号开牌, false); dgv_show(); }
private bool _close = false; //线程终止标志 #endregion Fields #region Constructors //构造函数 public SeatExpenseForm(CSeat seat, int _seat_length, bool _seatLock, bool _auto_seat_card, DAO _dao) { seatLock = _seatLock; auto_seat_card = _auto_seat_card; seat_length = _seat_length; dao = _dao; if (seatLock) { m_Seats.Add(dao.get_seat("text", seat.text)); } else { string cmd_str = "((chainId is null and text='" + seat.text + "') or (chainId is not null and chainId='" + seat.chainId + "'))" + @" and (status=2 or status=6 or status=7 or status=8)"; var seats = dao.get_seats(cmd_str); m_Seats.AddRange(seats); } var pars = new List<string>(); pars.Add("paying"); var vals = new List<string>(); vals.Add("True"); int count = m_Seats.Count; string update_str = @"update [Seat] set paying='True' where "; for (int i = 0; i < count; i++ ) { update_str += "text='" + m_Seats[i].text + "'"; if (i != count - 1) update_str += " or "; } if (!dao.execute_command(update_str)) { BathClass.printErrorMsg("手牌状态更新失败,如有超时浴资,请删除手牌重新载入"); } InitializeComponent(); }
//对话框载入 private void MemberPopForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); cardType = MemberForm.memberSetting.cardType; id.ReadOnly = !(cardType == "CT"); if (cardType != "CT") get_member(); else id.Focus(); }
//��ӡ̨λ������Ϣ public static void print_seat_information(System.Drawing.Printing.PrintPageEventArgs e) { DAO dao=new DAO(LogIn.connectionString); List<string> infor = new List<string>(); string str = "�� �� ��:" + m_Act.id; infor.Add(str); str = "̨��/�����:"; string s_str = "\n "; bool first = true; int i = 0; foreach (var t in m_seats) { if (m_room != null) { if (first) str += t.text + " " + m_room[i]; else str += s_str + t.text + " " + m_room[i]; } else { if (first) str += t.text ; else str += s_str + t.text; } if (t.note != null && t.note.Contains("������")) str += "(������)"; i++; first = false; } infor.Add(str); str = "����ʱ��:" + m_Act.openTime.Split('|')[0]; infor.Add(str); str = "��ʱ��:" + DateTime.Now.ToString(); infor.Add(str); str = "��ҵԱ��:" + LogIn.m_User.name; infor.Add(str); foreach (string st in infor) { print_str(e, st, 11F, e.MarginBounds.Left, tmpTop); //ԭ����13F���壬���ڸ�Ϊ11F tmpTop += str_h(e, 11F, st); } }
//对话框载入 private void MemberReadForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); get_member(); }
public ReserveOverDueForm(Seat seat) { dao = new DAO(LogIn.connectionString); m_seat = dao.get_seat("text='" + seat.text + "'"); InitializeComponent(); }
//监控台位数据库改变 /*private void watchSeat() { if (m_connection == null) m_connection = new SqlConnection(LogIn.connectionString); if (m_connection.State != ConnectionState.Open) m_connection.Open(); SqlCommand cmd = m_connection.CreateCommand(); cmd.Notification = null;//清除 cmd.CommandText = "select id, oId, text, typeId, systemId, openTime, openEmployee, payTime, payEmployee, chainId, status From dbo.Seat"; //监控台位数据库 SqlDependency dependency = new SqlDependency(cmd); dependency.OnChange += new OnChangeEventHandler(seat_OnChange); //SqlDependency绑定的SqlCommand对象必须要执行一下,才能将SqlDependency对象的HasChange属性设为true SqlDataAdapter thisAdapter = new SqlDataAdapter(cmd); DataSet posDataSet = new DataSet(); thisAdapter.Fill(posDataSet, "Seat"); //刷新台位信息 if (this.WindowState != FormWindowState.Minimized) update_seats(); //刷新状态栏 setStatus(); } private delegate void watchSeatDelegate(); //监控台位数据库改变 private void seat_OnChange(object sender, SqlNotificationEventArgs e) { //因为是子线程,需要用invoke方法更新ui if (this.InvokeRequired) { this.Invoke(new watchSeatDelegate(watchSeat), null); } else { watchSeat(); } SqlDependency dependency = (SqlDependency)sender; //通知之后,当前dependency失效,需要重新设置通知 dependency.OnChange -= seat_OnChange; }*/ //点击台位按钮 private void btn_Click(object sender, EventArgs e) { var db_new = new BathDBDataContext(LogIn.connectionString); Button btn = sender as Button; btn.Enabled = false; btn.Enabled = true; var seat = db_new.Seat.FirstOrDefault(x => x.text == btn.Text); switch (seat.status) { case 2://正在使用 case 6://警告 case 7://押金离场 case 8://重新结账 var dao = new DAO(LogIn.connectionString); var s = dao.get_seat("text='" + seat.text + "'"); OrderCheckForm orderForm = new OrderCheckForm(s, LogIn.connectionString, LogIn.options); orderForm.ShowDialog(); break; default: break; } }
public static void reprint_bill(CSeat seat, DAO dao, bool use_pad) { if (seat.status != SeatStatus.PAIED) { BathClass.printErrorMsg("已经重新开牌,不能重打账单!"); return; } var account = dao.get_account("abandon is null and systemId like '%" + seat.systemId + "%'"); if (account == null) return; var seats_txt = account.text.Split('|'); string state_str = ""; int count = seats_txt.Count(); for (int i = 0; i < count; i++) { state_str += "text='" + seats_txt[i] + "'"; if (i != count - 1) state_str += " or "; } var seats_reprint = dao.get_seats(state_str); List<string> m_rooms = new List<string>(); foreach (var s in seats_reprint) { m_rooms.Add(dao.get_seat_room(s.text)); } DataGridView dgv = new DataGridView(); DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn(); col.HeaderText = "手牌"; dgv.Columns.Add(col); DataGridViewTextBoxColumn coll = new DataGridViewTextBoxColumn(); coll.HeaderText = "房间"; dgv.Columns.Add(coll); DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn(); col1.HeaderText = "项目名称"; dgv.Columns.Add(col1); DataGridViewTextBoxColumn col2 = new DataGridViewTextBoxColumn(); col2.HeaderText = "技师"; dgv.Columns.Add(col2); DataGridViewTextBoxColumn col3 = new DataGridViewTextBoxColumn(); col3.HeaderText = "单价"; dgv.Columns.Add(col3); DataGridViewTextBoxColumn col4 = new DataGridViewTextBoxColumn(); col4.HeaderText = "数量"; dgv.Columns.Add(col4); DataGridViewTextBoxColumn col5 = new DataGridViewTextBoxColumn(); col5.HeaderText = "金额"; dgv.Columns.Add(col5); List<string> printCols = new List<string>(); printCols.Add("手牌"); if (use_pad) printCols.Add("房间"); printCols.Add("项目名称"); printCols.Add("单价"); printCols.Add("数量"); printCols.Add("金额"); var use_disAssemble = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用大项拆分, false); var co_name = LogIn.options.companyName; if (account != null) { try { var db = new BathDBDataContext(LogIn.connectionString); var orders = db.HisOrders.Where(x => x.deleteEmployee == null && x.accountId == account.id).OrderBy(x => x.text); foreach (var order in orders) { var cmenu = db.Menu.FirstOrDefault(x => x.name == order.menu); var price = ""; if (cmenu != null) { price = cmenu.price.ToString(); if (use_disAssemble && db.BigCombo.FirstOrDefault(x => x.menuid == cmenu.id) != null) { var substIDs = BathClass.disAssemble(db.BigCombo.FirstOrDefault(x => x.menuid == cmenu.id).substmenuid, Constants.SplitChar); for (int i = 0; i < substIDs.Count; i++) { var menu = db.Menu.FirstOrDefault(x => x.id == substIDs[i]); dgv.Rows.Add(order.text, order.roomId, menu.name, order.technician, menu.price, order.number, menu.price * MConvert<double>.ToTypeOrDefault(order.number, 0)); } continue; } } dgv.Rows.Add(order.text, order.roomId, order.menu, order.technician, price, order.number,order.money); } PrintBill.Print_DataGridView(seats_reprint, m_rooms,account, "存根单", dgv, printCols, co_name); } catch (System.Exception ex) { BathClass.printErrorMsg(ex.ToString()); } } else { double money = 0; try { var db = new BathDBDataContext(LogIn.connectionString); var orders = db.Orders.Where(x => x.text == seat.text && x.systemId != seat.systemId && x.deleteEmployee == null).OrderBy(x => x.text); foreach (var order in orders) { var cmenu = db.Menu.FirstOrDefault(x => x.name == order.menu); var price = ""; if (cmenu != null) price = cmenu.price.ToString(); dgv.Rows.Add(order.text, order.roomId, order.menu, order.technician, price, order.number, order.money); } if (dgv.Rows.Count != 0) { BathClass.printErrorMsg("未检测到转账单或者结账单"); return; } PrintSeatBill.Print_DataGridView(seats_reprint, m_rooms,"", "转账确认单", dgv, printCols, money.ToString(), co_name); } catch (System.Exception ex) { BathClass.printErrorMsg(ex.ToString()); } } }
private void MainForm_Load(object sender, EventArgs e) { dgv.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", 18); dgv.RowsDefaultCellStyle.Font = new Font("宋体", 18); dao = new DAO(LogIn.connectionString); dgv_show(); }
//对话框载入 private void MemberForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); memberSetting = dao.get_MemberSetting(); }
//对话框载入 private void ReceptionSeatForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); seatLock = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用手牌锁, false); auto_seat_card = MConvert<bool>.ToTypeOrDefault(LogIn.options.自动感应手牌, false); use_pad = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用客房面板, false); lock_type = LogIn.options.手牌锁类型; tSeat.Visible = !seatLock; this.Text = "咱家店小二-前台系统" + Constants.version + " 欢迎使用:" + LogIn.m_User.id; currentUser.Text = "当前用户: " + LogIn.m_User.id + " " + LogIn.m_User.name; var td = new Thread(new ThreadStart(initial_ui_thread)); td.IsBackground = true; td.Start(); //CFormCreate.createSeat(db, seatPanel, seatTab, new EventHandler(btn_Click), seatContext); //setStatus(db); m_thread = new Thread(new ThreadStart(update_seats_ui)); m_thread.IsBackground = true; m_thread.Start(); m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory)); m_thread_clearMemory.IsBackground = true; m_thread_clearMemory.Start(); if (seatLock && auto_seat_card) { m_thread_seatCard = new Thread(new ThreadStart(seat_card_thread)); m_thread_seatCard.IsBackground = true; m_thread_seatCard.Start(); } }
//对话框载入 private void MemberCardUsingForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); memberSetting = dao.get_MemberSetting(); id.Enabled = (memberSetting.cardType == "CT"); if (!MConvert<bool>.ToTypeOrDefault(LogIn.options.启用会员卡密码, false) || LogIn.options.会员卡密码类型 != "指纹") { m_use_finger_pwd = false; } btnAdd_Click(null, null); money.Text = m_money.ToString(); }
private void tool_open_seat() { var db_new = new BathDBDataContext(LogIn.connectionString); string text = tSeat.Text; m_Seat = db_new.Seat.FirstOrDefault(x => x.text == text); if (m_Seat == null || (m_Seat.status != 2 && m_Seat.status != 6 && m_Seat.status != 7 && m_Seat.status != 8)) { GeneralClass.printErrorMsg("手牌不存在或者不在使用中,不可查看消费!"); return; } var dao = new DAO(LogIn.connectionString); var s = dao.get_seat("text", m_Seat.text); OrderCheckForm orderCheckForm = new OrderCheckForm(s, LogIn.connectionString, LogIn.options); orderCheckForm.ShowDialog(); tSeat.Text = ""; }
//对话框载入 private void InputSeatForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); }
//对话框载入 private void ReceptionSeatForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); //var db = new BathDBDataContext(LogIn.connectionString); this.Text = Constants.appName + "-吧台" + Constants.version + " 欢迎使用:" + LogIn.m_User.id; currentUser.Text = "当前用户:" + LogIn.m_User.id + " " + LogIn.m_User.name; //CFormCreate.createSeat(db, seatPanel, seateTab, new System.EventHandler(btn_Click), null); var td = new Thread(new ThreadStart(initial_ui_thread)); td.IsBackground = true; td.Start(); if (MConvert<bool>.ToTypeOrDefault(LogIn.options.启用客房面板, false)) { msg_delay = LogIn.options.包房等待时限.HasValue ? LogIn.options.包房等待时限.Value : 10; m_thread_msg = new Thread(new ThreadStart(msgTimer_Elapsed)); m_thread_msg.IsBackground = true; m_thread_msg.Start(); m_thread_wait_over = new Thread(new ThreadStart(room_wait_over_detect)); m_thread_wait_over.IsBackground = true; m_thread_wait_over.Start(); btnCab.Visible = false; cabL.Visible = false; } else { roomL.Visible = false; btnRoom.Visible = false; callL.Visible = false; toolCall.Visible = false; toolMsg.Visible = false; msgL.Visible = false; toolWarn.Visible = false; } m_thread_update_seat = new Thread(new ThreadStart(update_seats_ui)); m_thread_update_seat.IsBackground = true; m_thread_update_seat.Start(); m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory)); m_thread_clearMemory.IsBackground = true; m_thread_clearMemory.Start(); }
//对话框载入 private void MemberStopForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); }
public double get_combo_price(DAO dao) { double combo_price = 0; if (this._priceType == "免项目" || this._priceType == "消费满免项目") { var freeIds = disAssemble_freeIds(); var pars = new List<string>(); var vals = new List<string>(); int count = freeIds.Count; for (int i = 0; i < count; i++) { pars.Add("id"); vals.Add(freeIds[i].ToString()); } var freeMenus = dao.get_Menus(pars, vals, "or"); //var freeMenus = db.Menu.Where(x => freeIds.Contains(x.id)); var freeMoney = freeMenus.Sum(x => x.price); combo_price = freeMoney; } else if (this._priceType == "减金额") combo_price = this._originPrice - this._price.Value; return combo_price; }
//对话框载入 private void ReceptionSeatForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); this.Text = "咱家店小二-客房系统" + Constants.version + " 欢迎使用:" + LogIn.m_User.id; currentUser.Text = "当前用户: " + LogIn.m_User.id + " " + LogIn.m_User.name; int rt = RoomProRFL.initializeUSB(1); if (rt != 0) { BathClass.printErrorMsg("打开USB失败!"); //this.Close(); //return; } var td = new Thread(new ThreadStart(initial_ui_thread)); td.IsBackground = true; td.Start(); m_thread = new Thread(new ThreadStart(update_seats_ui)); m_thread.IsBackground = true; m_thread.Start(); }
//��ӡ̨λ������Ϣ public static void print_seat_information(System.Drawing.Printing.PrintPageEventArgs e) { List<string> infor = new List<string>(); List<string> m_rooms=new List<string>(); DAO dao = new DAO(LogIn.connectionString); int i = 0; //string str = "̨ ��:"; string str = "̨��/�����:"; string s_str = "\n "; bool first = true; //var sarray = m_Act.text.Split('|').ToArray(); var sarray = m_seats.Select(x => x.text); foreach ( var s in m_seats) { m_rooms.Add(dao.get_seat_room(s.text)); } foreach (var t in sarray) { if (first) str += t + " " + m_rooms[i]; else str += s_str + t+ " " + m_rooms[i]; first = false; i++; } //+ string.Join("\n", ); infor.Add(str); str = "����ʱ��:" + m_seats[0].openTime; infor.Add(str); str = "��ʱ��:" + BathClass.Now(LogIn.connectionString).ToString(); infor.Add(str); str = "��ҵԱ��:" + LogIn.m_User.name; infor.Add(str); //����ԭ��Ϊ13F,���ڸ�Ϊ11F,��������2014-04-15 foreach (string st in infor) { print_str(e, st, 11F, e.MarginBounds.Left, tmpTop); tmpTop += str_h(e, 11F, st); } }
//对话框载入 private void MemberResumForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); cardType = MemberForm.memberSetting.cardType; id.ReadOnly = !(cardType == "CT"); }
//对话框载入 private void Form1_Load(object sender, EventArgs e) { connectionIP = IOUtil.get_config_by_key(ConfigKeys.KEY_CONNECTION_IP); if (connectionIP == "") { PCListForm pCListForm = new PCListForm(); if (pCListForm.ShowDialog() != DialogResult.OK) { this.Close(); return; } connectionIP = pCListForm.ip; IOUtil.set_config_by_key(ConfigKeys.KEY_CONNECTION_IP, connectionIP); } dao = new DAO(connectionString); if (!dao.check_net()) { BathClass.printErrorMsg("连接IP不对或者网络不通,请重试!"); this.Close(); return; } _options = dao.get_options(); m_company = _options.companyName; print_tech_msg = MConvert<bool>.ToTypeOrDefault(options.打印技师派遣单, false); user_card = MConvert<bool>.ToTypeOrDefault(options.启用员工服务卡, false); IPHostEntry ipe = Dns.GetHostEntry(Dns.GetHostName()); foreach (var ip in ipe.AddressList) { m_ip = ip.ToString(); if (System.Text.RegularExpressions.Regex.IsMatch(m_ip, "[0-9]{1,3}//.[0-9]{1,3}//.[0-9]{1,3}//.[0-9]{1,3}")) break; } setMax(); //dgv.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", 20); //dgv.RowsDefaultCellStyle.Font = new Font("宋体", 20); //dgv_show(); m_thread = new Thread(new ThreadStart(detect_msg)); m_thread.IsBackground = true; m_thread.Start(); m_thread_tech = new Thread(new ThreadStart(detect_tech_index)); m_thread_tech.IsBackground = true; m_thread_tech.Start(); clock_timer = new System.Timers.Timer(); clock_timer.Interval = 1000; clock_timer.Elapsed += new System.Timers.ElapsedEventHandler(clock_timer_Elapsed); clock_timer.Enabled = true; m_player = new SoundPlayer(); techId.Focus(); m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory)); m_thread_clearMemory.IsBackground = true; m_thread_clearMemory.Start(); SplitGender.SplitterDistance = SplitGender.Width*2 / 3; create_tech_panel(); }
private void OpenDepositForm_Load(object sender, EventArgs e) { //db = new BathDBDataContext(LogIn.connectionString); //m_seatType = db.SeatType.FirstOrDefault(x => x.id == m_seat.typeId); dao = new DAO(LogIn.connectionString); m_seatType = dao.get_seattype("id", m_seat.typeId); depositMin.Text = m_seatType.depositeAmountMin.ToString(); }
//对话框载入 private void ReceptionSeatForm_Load(object sender, EventArgs e) { dao = new DAO(LogIn.connectionString); //var db = new BathDBDataContext(LogIn.connectionString); seat_length = dao.get_seat_length(); seat_start = (seat_length == 3) ? 17 : 16; //var ops = db.Options.FirstOrDefault(); seatLock = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用手牌锁, false); auto_seat_card = MConvert<bool>.ToTypeOrDefault(LogIn.options.自动感应手牌, false); use_pad = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用客房面板, false); lock_type = LogIn.options.手牌锁类型; has_double_department = dao.has_hotel_department(); tSeat.Visible = (!seatLock || has_double_department); this.Text = Constants.appName + "-前台系统" + Constants.version + " 欢迎使用:" + LogIn.m_User.id; currentUser.Text = "当前用户: " + LogIn.m_User.id + " " + LogIn.m_User.name; var td = new Thread(new ThreadStart(initial_ui_thread)); td.IsBackground = true; td.Start(); m_thread = new Thread(new ThreadStart(update_seats_ui)); m_thread.IsBackground = true; m_thread.Start(); m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory)); m_thread_clearMemory.IsBackground = true; m_thread_clearMemory.Start(); if (seatLock && auto_seat_card) { m_thread_seatCard = new Thread(new ThreadStart(seat_card_thread)); m_thread_seatCard.IsBackground = true; m_thread_seatCard.Start(); } if (has_double_department) { m_thread_detect_reserve_over_due = new Thread(new ThreadStart(detect_reserve_over_due)); m_thread_detect_reserve_over_due.IsBackground = true; m_thread_detect_reserve_over_due.Start(); } }
private void OpenSeatForm_Load(object sender, EventArgs e) { roomNumber.Text = m_seat.text; TextName.Text = m_seat.name; TextPhone.Text = m_seat.phone; TextDeposit.Text = m_seat.deposit.ToString(); TextDepositBank.Text = m_seat.depositBank.ToString(); days.CustomFormat = "yyyy-MM-dd-HH:mm"; days.Value = m_seat.dueTime.Value; DateOpenTime.Value = m_seat.openTime.Value; //chainId = BathClass.chainId(db, LogIn.connectionString); dao = new DAO(LogIn.connectionString); chainId = dao.chainId(); }
//构造函数 public MemberPromotionOptionForm(List<CSeat> seats) { dao = new DAO(LogIn.connectionString); m_Seats = seats; InitializeComponent(); }
private void OpenSeatForm_Load(object sender, EventArgs e) { roomNumber.Text = m_seat.text; name.Text = m_seat.name; phone.Text = m_seat.phone; days.CustomFormat = "yyyy-MM-dd-HH:mm"; days.Value = Convert.ToDateTime(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " 12:00:00"); //chainId = BathClass.chainId(db, LogIn.connectionString); dao = new DAO(LogIn.connectionString); chainId = dao.chainId(); }