/// <summary> /// danh sách bàn theo IDChiNhanh done /// </summary> public void DanhSachBan() { ClearTabControl(); DataTable dt = BUS_KhuVuc.DanhSachBanTheoKhuVuc(frmDangNhap.NguoiDung.Idchinhanh); if (dt.Rows.Count > 0) { ThongKe(dt); } else { MessageBox.Show("Danh sách bàn trống", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } foreach (DataRow dr in dt.Rows) { string TenKhuVucNull = dr["TenKhuVuc"].ToString(); string IDKhuVucNull = dr["ID"].ToString(); FlowLayoutPanel layout = new FlowLayoutPanel(); layout.Dock = DockStyle.Fill; layout.AutoScroll = true; AddTabControl(TenKhuVucNull, IDKhuVucNull, layout); BanKhuVuc(IDKhuVucNull, layout); } xtraTabControlDanhSach.SelectedTabPageIndex = TabActive; }
public void LamMoi() { DanhSachHangHoaA(); int IDBan = DAO_Setting.KiemtraGiaDien(frmDangNhap.NguoiDung.Idchinhanh) == 0 ? frmBanHang.IDBan : frmBanHang2.IDBan; cmbBanA.Properties.NullText = DAO_ChuyenBan.LayTenBan(IDBan); int IDkhuVuc = DAO_ChuyenBan.LayIDKhuVuc(IDBan); cmbKhuVucA.Properties.NullText = DAO_ChuyenBan.LayTenKhuVuc(IDkhuVuc).ToString(); DataTable dt = BUS_KhuVuc.DanhSachBanTheoKhuVuc(IDChiNhanh); cmbKhuVucB.Properties.DataSource = dt; cmbKhuVucB.Properties.ValueMember = "ID"; cmbKhuVucB.Properties.DisplayMember = "TenKhuVuc"; }
private void frmChuyenBan_Load(object sender, EventArgs e) { DanhSachHangHoaA(); gridViewA.OptionsSelection.EnableAppearanceFocusedRow = false; // Ẩn dòng đầu... gridViewB.OptionsSelection.EnableAppearanceFocusedRow = false; // Ẩn dòng đầu... cmbBanA.Properties.NullText = DAO_ChuyenBan.LayTenBan(DAO_Setting.KiemtraGiaDien(frmDangNhap.NguoiDung.Idchinhanh) == 0 ? frmBanHang.IDBan : frmBanHang2.IDBan); int IDkhuVuc = DAO_ChuyenBan.LayIDKhuVuc(DAO_Setting.KiemtraGiaDien(frmDangNhap.NguoiDung.Idchinhanh) == 0 ? frmBanHang.IDBan : frmBanHang2.IDBan); cmbKhuVucA.Properties.NullText = DAO_ChuyenBan.LayTenKhuVuc(IDkhuVuc).ToString(); DataTable dt = BUS_KhuVuc.DanhSachBanTheoKhuVuc(IDChiNhanh); cmbKhuVucB.Properties.DataSource = dt; cmbKhuVucB.Properties.ValueMember = "ID"; cmbKhuVucB.Properties.DisplayMember = "TenKhuVuc"; }
public void DanhSachBan() { IDBan = 0; tblTable1.Controls.Clear(); string IDChiNhanh = frmDangNhap.NguoiDung.Idchinhanh; DataTable dt = BUS_KhuVuc.DanhSachBanTheoKhuVuc(IDChiNhanh); DataRow dr11 = dt.Rows[0]; btnTrong.Text = "Trống (" + BUS_BAN.DanhSachThongKe(dr11["ID"].ToString(), 0) + ")"; btnDatTruoc.Text = "Đã Đặt (" + BUS_BAN.DanhSachThongKe(dr11["ID"].ToString(), 1) + ")"; btnDatTruoc.ForeColor = Color.OrangeRed; btnDatTruoc.StyleController = null; btnDatTruoc.LookAndFeel.UseDefaultLookAndFeel = false; btnDatTruoc.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Skin; btnCoNguoi.Text = "Có Người (" + BUS_BAN.DanhSachThongKe(dr11["ID"].ToString(), 2) + ")"; btnCoNguoi.ForeColor = Color.Red; btnCoNguoi.StyleController = null; btnCoNguoi.LookAndFeel.UseDefaultLookAndFeel = false; btnCoNguoi.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Office2003; float SLPhucVu = BUS_BAN.DanhSachThongKe(dr11["ID"].ToString(), 2); float TongSLBan = BUS_BAN.DanhSachThongKe(dr11["ID"].ToString(), 2) + BUS_BAN.DanhSachThongKe(dr11["ID"].ToString(), 0) + BUS_BAN.DanhSachThongKe(dr11["ID"].ToString(), 1); float TyLePhucVu = SLPhucVu / (float)TongSLBan; txtTyLyPhucVu.Text = "Tỷ lệ phục vụ: " + Math.Round(TyLePhucVu, 2) * 100 + "%"; foreach (DataRow dr in dt.Rows) { string TenKhuVuc = dr["TenKhuVuc"].ToString(); string IDKhuVuc = dr["ID"].ToString(); List <DTO_BAN> tablelist = DAO_BAN.Instance.LoadTableList(IDKhuVuc); foreach (DTO_BAN item in tablelist) { int TrangThai = item.Trangthai; string TenBan = item.Tenban; SimpleButton btn = new SimpleButton(); btn.Width = 80; btn.Height = 80; btn.Text = TenBan; btn.Click += btn_Click; btn.MouseDown += btn_MouseDown; btn.Tag = item; switch (TrangThai) { case 0: tblTable1.Controls.Add(btn); btn.ToolTip = "Bàn trống"; break; case 1: btn.ForeColor = Color.OrangeRed; btn.StyleController = null; btn.LookAndFeel.UseDefaultLookAndFeel = false; List <DTO_DatBan> thongtinnguoidat = DAO_DatBan.Instance.LoadTableList(item.Id); foreach (DTO_DatBan dr1 in thongtinnguoidat) { btn.ToolTip = dr1.TenKhachHang + Environment.NewLine + dr1.DienThoai + Environment.NewLine + dr1.GioDat; } btn.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Skin; tblTable1.Controls.Add(btn); break; case 2: btn.ForeColor = Color.Red; btn.StyleController = null; btn.LookAndFeel.UseDefaultLookAndFeel = false; btn.ToolTip = "Bàn có người ngồi"; btn.LookAndFeel.Style = DevExpress.LookAndFeel.LookAndFeelStyle.Office2003; tblTable1.Controls.Add(btn); break; } } } }