private void QuanLyBan_Load(object sender, EventArgs e) { using (HangHoaBUS bus = new HangHoaBUS()) dataGridView2.DataSource = bus.ListHangHoa2(); using (KhuVucBUS bus = new KhuVucBUS()) { foreach (DataRow row in bus.ListKhuVuc().Rows) { var group = new ListViewGroup(row["TenKhuVuc"].ToString()); listView1.Groups.Add(group); foreach (DataRow r in bus.ListBan(row["TenKhuVuc"].ToString()).Rows) { listView1.Items.Add(new ListViewItem(r["TenBan"].ToString(), bus.IsAvailable(r["MaSoBan"].ToString()) ? 0 : 1, group)).Tag = r["MaSoBan"]; } listView1.Items[0].Selected = true; } } using (QuanLyBanBUS bus = new QuanLyBanBUS()) txtSoHoaDon.Text = bus.GetSoHoaDon().ToString(); }
private void btnLuu_Click(object sender, EventArgs e) { KhuVucDTO kv = new KhuVucDTO(); kv.TenKhuVuc = txtTen.Text; kv.GhiChu = txtGhiChu.Text; if (chxConQuanLy.Checked == true) { kv.ConQuanLy = true; } else { kv.ConQuanLy = false; } bool check = KhuVucBUS.KiemTraThem(kv); if (check) { if (eventThemXong != null) { eventThemXong(); } Interaction.MsgBox("Thêm thành công!"); Log_BUS.ThemNhatKy("Khu vực", "Thêm khu vực"); } else { Interaction.MsgBox("Thêm thất bại!"); } }
private void simpleButton3_Click(object sender, EventArgs e) { int vitri = gridView1.GetFocusedDataSourceRowIndex(); KhuVucBUS.Xoa(gridView1.GetRowCellValue(vitri, "MaKhuVuc").ToString()); gridControl1.DataSource = LayDanhSach(); }
private void btnLuu_Click(object sender, EventArgs e) { KhuVucDTO kv = new KhuVucDTO(); kv.MaKhuVuc = txtMaKhuVuc.Text.Trim(); kv.TenKhuVuc = txtTen.Text.Trim(); kv.GhiChu = txtGhiChu.Text.Trim(); if (chxConQuanLy.Checked == true) { kv.ConQuanLy = true; } else { kv.ConQuanLy = false; } bool check = KhuVucBUS.KiemTraSua(kv); if (check) { if (eventSuaXong != null) { eventSuaXong(); } Log_BUS.ThemNhatKy("Khu vực", "Sửa thông tin khu vực"); Interaction.MsgBox("Sửa thành công!"); } else { Interaction.MsgBox("Sửa thất bại!"); } }
public BanHangReport(BanHangDTO info) { Thread.CurrentThread.CurrentCulture = new CultureInfo("vi-VN"); InitializeComponent(); var materialSkinManager = MaterialSkinManager.Instance; materialSkinManager.AddFormToManage(this); materialSkinManager.Theme = MaterialSkinManager.Themes.LIGHT; materialSkinManager.ColorScheme = new ColorScheme(Primary.Teal500, Primary.Teal700, Primary.Teal500, Accent.Red700, TextShade.WHITE); using (KhuVucBUS bus = new KhuVucBUS()) { HoaDonBanHang hdbh = new HoaDonBanHang(); var lblSoPhieu = hdbh.ReportDefinition.ReportObjects["lblSoPhieu"] as TextObject; lblSoPhieu.Text = "Số phiếu: " + info.SoHoaDon; var lblKhu = hdbh.ReportDefinition.ReportObjects["lblKhu"] as TextObject; lblKhu.Text = "Khu: " + bus.GetChiTiet(info.MaSoBan).Rows[0].Field <string>("TenKhuVuc"); var lblBan = hdbh.ReportDefinition.ReportObjects["lblBan"] as TextObject; lblBan.Text = "Bàn: " + bus.GetChiTiet(info.MaSoBan).Rows[0].Field <string>("TenBan"); var lblGioRa = hdbh.ReportDefinition.ReportObjects["lblGioRa"] as TextObject; lblGioRa.Text = "Giờ ra: " + info.GioRa.ToString("dd/MM/yyyy H:mm"); var lblTongCong = hdbh.ReportDefinition.ReportObjects["lblTongCong"] as TextObject; lblTongCong.Text = info.ChuaThue.ToString("N0"); var lblKhuyenMai = hdbh.ReportDefinition.ReportObjects["lblKhuyenMai"] as TextObject; lblKhuyenMai.Text = info.KhuyenMai + " %"; var lblThanhToan = hdbh.ReportDefinition.ReportObjects["lblThanhToan"] as TextObject; lblThanhToan.Text = info.TongTien.ToString("N0"); hdbh.SetDataSource(info.ChiTiet); crystalReportViewer1.ReportSource = hdbh; crystalReportViewer1.Refresh(); } }
private void btnThemKV_Click(object sender, System.EventArgs e) { if (string.IsNullOrWhiteSpace(txtTenKhuVuc.Text)) { errorProvider1.SetError(txtTenKhuVuc, "Vui lòng điền tên khu vực muốn thêm"); return; } errorProvider1.SetError(txtTenKhuVuc, string.Empty); try { using (KhuVucBUS bus = new KhuVucBUS()) bus.InsertKhuVuc(txtTenKhuVuc.Text); } catch (SqlException ex) { if (ex.Number == DbConnection.MssqlEng002627) { errorProvider1.SetError(txtTenKhuVuc, "Khu vực đã tồn tại"); } else { throw; } } RefreshKhuVuc(); }
private void btnThemBan_Click(object sender, System.EventArgs e) { if (string.IsNullOrWhiteSpace(txtTenBan.Text)) { errorProvider1.SetError(txtTenBan, "Vui lòng điền tên bàn muốn thêm"); return; } errorProvider1.SetError(txtTenBan, string.Empty); try { using (KhuVucBUS bus = new KhuVucBUS()) bus.InsertBan(treeView1.SelectedNode.Text, txtTenBan.Text); } catch (SqlException ex) { if (ex.Number == DbConnection.MssqlEng002627) { errorProvider1.SetError(txtTenBan, "Bàn đã tồn tại trong khu vực"); } else { throw; } } RefreshBan(); }
public frmSuaKhachHang() { InitializeComponent(); gridLookupKhuVuc.Properties.DataSource = KhuVucBUS.DanhSach(); gridLookupKhuVuc.Properties.DisplayMember = "TenKhuVuc"; gridLookupKhuVuc.Properties.ValueMember = "MaKhuVuc"; }
public void LoadBanTrongKhuVuc() { m_tabCtrKhuVuc.Tabs.Clear(); int maNhaHang = m_cBoxNhaHang.SelectedIndex == 0 ? 0 : ((NhaHangDTO)m_cBoxNhaHang.SelectedItem).MaNhaHang; List <KhuVucDTO> dsKhuVuc = KhuVucBUS.LayDanhSachKhuVuc(maNhaHang); foreach (KhuVucDTO kv in dsKhuVuc) { if (KiemTraKhuVuc(kv.MaKhuVuc)) { TabItem tabI = new TabItem(); TabControlPanel tabCtrP = new TabControlPanel(); tabI.Name = "m_tabIKhuVuc" + kv.MaKhuVuc; tabI.Text = kv.TenKhuVuc; tabCtrP.Name = "m_tabCtrP" + kv.MaKhuVuc; tabCtrP.AutoScroll = true; tabCtrP.AutoSize = true; tabCtrP.Dock = System.Windows.Forms.DockStyle.Fill; tabCtrP.TabItem = tabI;// chỗ này là gán tabI.AttachedControl = tabCtrP; uCtr_KhuVuc khuvuc = new uCtr_KhuVuc(this, kv.MaKhuVuc); khuvuc.MaximumSize = new Size(m_tabCtrKhuVuc.Width, 0); tabCtrP.Controls.Add(khuvuc); m_tabCtrKhuVuc.Controls.Add(tabCtrP); // chỗ này là add m_tabCtrKhuVuc.Tabs.Add(tabI); } } }
public void btnLuu_Click(object sender, EventArgs e) { KhuVucDTO kv = new KhuVucDTO(); kv.MaKhuVuc = int.Parse(txtMaKhuVuc.Text.Trim()); kv.TenKhuVuc = txtTen.Text.Trim(); kv.GhiChu = txtGhiChu.Text.Trim(); if (chxConQuanLy.Checked == true) { kv.ConQuanLy = true; } else { kv.ConQuanLy = false; } bool check = KhuVucBUS.KiemTraSua(kv); if (check) { if (eventSuaXongEvent != null) { eventSuaXongEvent(); } Log_BUS.ThemNhatKy("Khu vực", "Sửa thông tin khu vực"); MessageBox.Show("Sửa thành công!"); } else { MessageBox.Show("Sửa thất bại!"); } }
public FormKhuVuc(int themOrSua, KhuVucO kv) { this.themOrSua = themOrSua; khuVucBUS = new KhuVucBUS(); //KV = new KhuVucO(); KV = kv; InitializeComponent(); }
public void LoadKhuVuc() { List <KhuVucDTO> lKV = KhuVucBUS.LayToanBoKhuVuc(); lkpKhuVuc.Properties.DataSource = lKV; lkpKhuVuc.Properties.DisplayMember = "TenKhuVuc"; lkpKhuVuc.Properties.ValueMember = "MaKhuVuc"; }
public frmThemNCC() { InitializeComponent(); txtMaNCC.Text = NhaCungCapBUS.LayMaNCC(); gridlookupKhuVuc.Properties.DataSource = KhuVucBUS.DanhSach(); gridlookupKhuVuc.Properties.DisplayMember = "TenKhuVuc"; gridlookupKhuVuc.Properties.ValueMember = "MaKhuVuc"; }
public FormKhachHang() { InitializeComponent(); themOrSua = 1; khuVucBUS = new KhuVucBUS(); // load lookupEdit khu vuc lueKhuVuc.Properties.DataSource = khuVucBUS.getAllKhuVuc(); lueKhuVuc.Properties.DisplayMember = "TenKhuVuc"; lueKhuVuc.Properties.ValueMember = "MaKhuVuc"; }
private void RefreshBan() { listView1.Items.Clear(); using (KhuVucBUS bus = new KhuVucBUS()) { foreach (DataRow row in bus.ListBan(treeView1.SelectedNode.Text).Rows) { listView1.Items.Add(row[1].ToString(), 1).Tag = row[0]; } } }
public FormNhaCungCap() { InitializeComponent(); themOrSua = 1; nhaCungCapBUS = new NhaCungCapBUS(); NCC = new NhaCungCapO(); khuVucBUS = new KhuVucBUS(); // load lookupEdit khu vuc lueKhuVuc.Properties.DataSource = khuVucBUS.getAllKhuVuc(); lueKhuVuc.Properties.DisplayMember = "TenKhuVuc"; lueKhuVuc.Properties.ValueMember = "MaKhuVuc"; }
private void btnXoaKV_Click(object sender, System.EventArgs e) { using (KhuVucBUS bus = new KhuVucBUS()) { if (new XacNhan { Text = @"Bạn có chắc chắn muốn xóa khu vực " + treeView1.SelectedNode.Text }.ShowDialog() == DialogResult.Yes) { bus.DeleteKhuVuc(treeView1.SelectedNode.Text); } } RefreshKhuVuc(); }
private void RefreshKhuVuc() { treeView1.Nodes.Clear(); using (KhuVucBUS bus = new KhuVucBUS()) { foreach (DataRow row in bus.ListKhuVuc().Rows) { treeView1.Nodes.Add(row[0].ToString()); } } treeView1.SelectedNode = treeView1.TopNode; }
private void LoadKhuVuc(int maNhaHang) { m_cBoxKhuVuc.Items.Clear(); m_cBoxKhuVuc.Items.Add("Chọn khu vực"); List <KhuVucDTO> khuVuc = KhuVucBUS.LayDanhSachKhuVuc(maNhaHang); foreach (KhuVucDTO oKhuVuc in khuVuc) { m_cBoxKhuVuc.Items.Add(oKhuVuc); } m_cBoxKhuVuc.SelectedIndex = 0; m_cBoxKhuVuc.ValueMember = "MaKhuVuc"; m_cBoxKhuVuc.DisplayMember = "TenKhuVuc"; }
private void simpleButton1_Click(object sender, EventArgs e) { bool ConQuanLy; if (checkBox1.Checked) { ConQuanLy = true; } else { ConQuanLy = false; } KhuVucBUS.Sua(txtMaKhuVuc.Text, txtTen.Text, txtGhiChu.Text, ConQuanLy); this.Close(); }
private void BarButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int[] i = GridView1.GetSelectedRows(); int makv = Convert.ToInt32(GridView1.GetRowCellValue(i[0], "MaKhuVuc")); bool check = KhuVucBUS.KiemTraXoa(makv); if (check) { LoadTatCaKhuVuc(); Interaction.MsgBox("Xóa thành công!"); Log_BUS.ThemNhatKy("Khu vực", "Xóa khu vực"); } else { Interaction.MsgBox("Xóa thất bại!"); } }
private void simpleButton1_Click(object sender, EventArgs e) { bool ConQuanLy; if (checkBox1.Checked == true) { ConQuanLy = true; } else { ConQuanLy = false; } KhuVucBUS.Them(txtMaKhuVuc.Text, txtTen.Text, txtGhiChu.Text, ConQuanLy); txtMaKhuVuc.Text = KhuVucBUS.MaKhuVuc(); txtTen.Text = null; txtGhiChu.Text = null; checkBox1.Checked = true; }
private void btnXoaBan_Click(object sender, System.EventArgs e) { if (listView1.SelectedItems.Count == 0) { return; } using (KhuVucBUS bus = new KhuVucBUS()) { if (new XacNhan { Text = @"Bạn có chắc chắn muốn xóa bàn " + listView1.SelectedItems[0].Text }.ShowDialog() == DialogResult.Yes) { bus.DeleteBan(listView1.SelectedItems[0].Tag.ToString()); } } RefreshBan(); }
private void frmThemKhuVuccs_Load(object sender, EventArgs e) { txtMaKhuVuc.Text = KhuVucBUS.MaKhuVuc(); }
public void LoadCotKhuVuc() { RepositoryItemCheckedComboBoxEdit1.DataSource = KhuVucBUS.LayToanBoKhuVuc(); RepositoryItemCheckedComboBoxEdit1.DisplayMember = "TenKhuVuc"; RepositoryItemCheckedComboBoxEdit1.ValueMember = "MaKhuVuc"; }
void Tao_Ban() { flowLayoutBan.Controls.Clear(); DataTable dt = KhuVucBUS.KhuVuc_LoadTheoTrangThai("Đang sử dụng"); GroupBox grkhuvucCu = new GroupBox() { Width = 0, Location = new Point(0, 0) }; // lưu vị trí của groupbox cũ for (int i = 0; i < dt.Rows.Count; i++) { int makv = int.Parse(dt.Rows[i]["kv_id"].ToString()); string tenkv = dt.Rows[i]["kv_ten"].ToString(); GroupBox grkhuvuc = new GroupBox() // tạo groupbox(khu vực) chứa các button(bàn) { Width = 450, Height = 300, Location = new Point(grkhuvucCu.Location.X + grkhuvucCu.Width, grkhuvucCu.Location.Y), Text = tenkv, Tag = makv, }; FlowLayoutPanel flowKhuVuc = new FlowLayoutPanel(); // tạo FlowLayoutPanel add vào grKhuVuc flowKhuVuc.Dock = DockStyle.Fill; flowKhuVuc.AutoScroll = true; grkhuvuc.Controls.Add(flowKhuVuc); // add button vao flow // tao danh sach ban theo khu vuc List <BanDTO> ban = new List <BanDTO>(); ban = BanBUS.Ban_List_KhuVuc(makv); Button oldbtn = new Button() { Width = 0, Location = new Point(0, 0) }; foreach (BanDTO item in ban) { Button btn = new Button() { Width = 80, Height = 80, Location = new Point(oldbtn.Location.X + oldbtn.Width, oldbtn.Location.Y), Text = item.Ban_ten, Tag = item.Ban_id }; // gán màu cho bàn theo trạng thái Trống - xanh, Có khách - Đỏ, Đặt trước - Hồng if (item.Ban_trangthai == "Trống") { btn.BackColor = Color.Blue; } else if (item.Ban_trangthai == "Có khách") { btn.BackColor = Color.Red; } else { btn.BackColor = Color.Pink; } flowKhuVuc.Controls.Add(btn); btn.MouseDown += new MouseEventHandler(bt_MouseDown); // tạo sự kiện click cho các button } flowLayoutBan.Controls.Add(grkhuvuc); } }
public void LoadTatCaKhuVuc() { GridControl1.DataSource = KhuVucBUS.KiemTraLoad(); }
private void LoadCotKhuVuc() { RepositoryItemCheckedComboBoxEdit_2.DataSource = KhuVucBUS.KiemTraLoad(); RepositoryItemCheckedComboBoxEdit_2.ValueMember = "MaKhuVuc"; RepositoryItemCheckedComboBoxEdit_2.DisplayMember = "TenKhuVuc"; }
public UCKhuVuc() { InitializeComponent(); khuVucBUS = new KhuVucBUS(); kv = new KhuVucO(); }
private List <KhuVucDTO> LayDanhSach() { return(KhuVucBUS.DanhSach()); }