public void LoadBanAn() { BanHang.Model.Load load = new Model.Load(); DataTable dt = load.LoadBanAn(); comboTree1.DataSource = dt; comboTree1.ValueMember = "MaBan"; }
private void SuaBan_Load(object sender, EventArgs e) { BanHang.Model.Load load = new Model.Load(); DataTable dt = load.LoadKhuVucTheoMaKhuVuc(MaKhuVuc); lblKhuVuc.Text = dt.Rows[0][1].ToString(); DataTable dt1 = load.LoadBanAnTheoMaBan(MaBan); textBoxX1.Text = dt1.Rows[0][1].ToString(); }
private void SuaKhuVuc_Load(object sender, EventArgs e) { BanHang.Model.Load load = new Model.Load(); DataTable dt = load.LoadKhuVuc(); comboTree1.DataSource = dt; comboTree1.DisplayMembers = "TenKhuVuc"; comboTree1.ValueMember = "MaKhuVuc"; }
private void buttonX1_Click(object sender, EventArgs e) { int MaBanTiep = Convert.ToInt32(comboTree1.SelectedValue.ToString()); HoaDon.model.Load load1 = new HoaDon.model.Load(); DataTable dt1 = load1.LoadHoaDonChuaThanhToanCanChon(MaBanTiep); if (dt1.Rows.Count == 0) { BanHang.Model.Load load = new Model.Load(); DataTable dt = load.LoadBanAnTheoMaBan(MaBanTiep); string Ten = dt.Rows[0][1].ToString(); BanHang.Model.Update update = new Model.Update(); update.UpdateChuyenBanAn(MaBanAn, MaBanTiep, Ten); this.Close(); } else { MessageBox.Show("Bàn đã có người ngồi"); } }
private void btnTKTT_Click(object sender, EventArgs e) { BanHang.Model.Load load = new BanHang.Model.Load(); DataTable dt = new DataTable(); dt = load.LoadHoaDonBanHangThongKe(dateTimeInputThongKeTuNgay.Value, dateTimeInputThongKeDenNgay.Value); CrystalReportThongKeDoanhThuTheoThang cry = new CrystalReportThongKeDoanhThuTheoThang(); cry.SetDataSource(dt); crystalReportViewer1.ReportSource = cry; crystalReportViewer1.Refresh(); }
public DataTable LoadListBanAnTheoKhuVuc(int MaKhuVuc) { BanHang.Model.Load load = new BanHang.Model.Load(); return load.LoadBanAn(MaKhuVuc); }
public void LoadHoaDonBanHang() { BanHang.Model.Load load = new BanHang.Model.Load(); DataTable dt = new DataTable(); ; KiemTraHoaDon = 1; if (!checkBoxX2.Checked) { dt = load.LoadHoaDonBanHang(dateTimeInput1.Value, dateTimeInput2.Value); } else { dt = load.LoadHoaDonBanHangNo(dateTimeInput1.Value, dateTimeInput2.Value); } loadDataHoaDon(dt); lblHoaDon.Text = dt.Rows.Count.ToString(); int Tong = 0; for (int i = 0; i < dt.Rows.Count; i++) { Tong = Convert.ToInt32(dt.Rows[i][7].ToString()) + Tong; } txtTongTien.Text = Tong.ToString(); }
private void toolStripMenuItemThemBan_Click(object sender, EventArgs e) { try { //check khu vuc int MaBanAn = Convert.ToInt32(listViewExKhuVuc.SelectedItems[0].Name.ToString()); BanHang.Model.Load load = new BanHang.Model.Load(); DataTable dt = load.LoadKhuVucTheoMaBanAn(MaBanAn); int MaKhuVuc = Convert.ToInt32(dt.Rows[0][2].ToString()); BanHang.ThemBan them = new BanHang.ThemBan(MaKhuVuc); them.ShowDialog(); LoadKhuVuc(); } catch (Exception) { } }
private DataTable LoadListKhuVuc() { BanHang.Model.Load load = new BanHang.Model.Load(); return load.LoadKhuVuc(); }
private void ThemBan_Load(object sender, EventArgs e) { BanHang.Model.Load load = new Model.Load(); DataTable dt = load.LoadKhuVucTheoMaKhuVuc(MaKhuVuc); lblKhuVuc.Text = dt.Rows[0][1].ToString(); }