public fThemSimple(bool isAdd = true, CKhuVuc kv = null, fKhuVuc.sendMessage send = null)
{
InitializeComponent();
if (isAdd == false && kv == null)
{
XtraMessageBox.Show("ERROR : Dữ liệu không được cung cấp để thực hiện hành động !", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
Close();
}
if (isAdd == true)
{
table = BUS_KhuVuc.KhuVuc();
Text = "Thêm khu vực";
}
else
{
editKV = kv;
Text = "Sửa thông tin khu vực";
}
add = isAdd;
sendKV = send;
flag = 0;
InitKV();
}
private void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (XtraMessageBox.Show("Bạn có chắc chắn muốn xóa ?", "CẢNH BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Warning)
== DialogResult.No)
{
return;
}
int rowIndex = gvMain.FocusedRowHandle;
string colID = "CUSTOMER_GROUP_ID";
string value = gvMain.GetRowCellValue(rowIndex, colID).ToString();
if (BUS_KhuVuc.KiemTraKV(value) == true)
{
BUS_KhuVuc.XoaKV(value);
Action.Module = "Khu Vực";
Action.ActionName = "Xóa";
Action.Reference = value;
Action.LuuThongTin();
LoadData();
}
else
{
return;
}
}
/// <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;
}
private void ThemKV()
{
CKhuVuc kv = new CKhuVuc(txtMa.Text, txtTen.Text, txtGhiChu.Text, ceConQL.Checked);
BUS_KhuVuc.ThemKV(kv);
sendKV?.Invoke();
Action.Module = "Khu Vực";
Action.ActionName = "Thêm";
Action.Reference = txtMa.Text;
Action.LuuThongTin();
this.Close();
}
private void SuaKV()
{
editKV.TenKV = txtTen.Text;
editKV.GhiChu = txtGhiChu.Text;
editKV.ConQL = ceConQL.Checked;
BUS_KhuVuc.SuaKV(editKV);
sendKV();
Action.Module = "Khu Vực";
Action.ActionName = "Sửa";
Action.Reference = editKV.MaKV;
Action.LuuThongTin();
this.Close();
}
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";
}
/// <summary>
/// Hàm xử lý việc thêm đối tượng
/// </summary>
private void xlThem()
{
if (txtTen.Text == "")
{
error.SetError(txtTen, "Vui lòng điền thông tin !");
}
else
{
error.SetError(txtTen, string.Empty);
}
if (txtMa.Text == "")
{
error.SetError(txtMa, "Vui lòng điền thông tin !");
}
else if (BUS_KhuVuc.KiemTraKV(txtMa.Text))
{
error.SetError(txtMa, "Mã đã tồn tại, vui lòng chọn giá trị khác !");
}
else
{
error.SetError(txtMa, string.Empty);
}
if (error.GetError(txtMa) == string.Empty && error.GetError(txtTen) == string.Empty)
{
switch (flag)
{
case 0:
ThemKV(); break;
case 1:
ThemDV(); break;
case 2:
ThemNH(); break;
case 3:
ThemBP(); break;
}
;
}
}
private void LoadDataKV()
{
leKhuVuc.Properties.DataSource = BUS_KhuVuc.KhuVuc();
}
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;
}
}
}
}
private void LoadData()
{
gvcMain.DataSource = BUS_KhuVuc.KhuVuc();
}
