public List<CTHoaDon> loadCTHoaDon_with_MaHoaDon(string mahoadon) { int param = 1; string[] names = new string[param]; Object[] values = new Object[param]; names[0] = "@maHoaDon"; values[0] = mahoadon; DataTable dt = db.LoadData("CTHOADON_proc_load_with_MaHoaDon", names, values, param); List<CTHoaDon> list = new List<CTHoaDon>(); foreach (DataRow row in dt.Rows) { CTHoaDon cthd = new CTHoaDon(); MonAn ma = new MonAn(); HoaDon hd = new HoaDon(); ma.MaMonAn = row["MaMonAn"].ToString(); ma.TenMonAn = row["TenMonAn"].ToString(); ma.DonGia = decimal.Parse(row["DonGia"].ToString()); cthd.MonAn = ma; cthd.MaCTHoaDon = row["MaCTHoaDon"].ToString(); hd.MaHoaDon = row["MaHoaDon"].ToString(); cthd.HoaDon = hd; cthd.SoLuong = int.Parse(row["SoLuong"].ToString()); cthd.DaChuanBi = bool.Parse(row["DaChuanBi"].ToString()); cthd.GhiChu = row["GhiChu"].ToString(); list.Add(cthd); } return list; }
private void btnDongY_Click(object sender, EventArgs e) { if(txtTenMonAn.Text == "") { MessageBox.Show("Nhập tên món ăn", " Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); txtTenMonAn.Focus(); return; } if (dipDonGia.Text == "0") { MessageBox.Show("Nhập lại đơn giá", " Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); dipDonGia.Focus(); return; } MonAn monAn = new MonAn(); monAn.MaMonAn = txtMaMon.Text.Trim(); monAn.TenMonAn = txtTenMonAn.Text.Trim(); monAn.DonGia = (decimal)dipDonGia.Value; monAn.HinhAnh = ""; monAn.DonViTinh = cbxDonViTinh.SelectedItem as DonViTinh; monAn.LoaiMon = cbLoaiMon.SelectedItem as LoaiMon; if( monAnBus.insertMonAn(monAn) != 0) { this.Close(); MessageBox.Show("Đã thêm món ăn mới", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); Global.thucDon.refreshMonAnList(); } }
public YeuCauMon(MonAn monAn) { monan = monAn; InitializeComponent(); txtTenMon.Text = monan.TenMonAn; txtDonGia.Text = monan.DonGia.ToString("#,###"); dipSoLuong.Value = 1; thanhTien = monan.DonGia * (decimal)dipSoLuong.Value; txtThanhTien.Text = thanhTien.ToString("#,###"); }
public int findMonAn(MonAn monAn) { int param = 1; string[] names = new string[param]; Object[] values = new Object[param]; names[0] = "@tenMonAn"; values[0] = monAn.TenMonAn; return db.Update("MONAN_proc_find", names, values, param); }
public SuaMonAn(MonAn monAn) { InitializeComponent(); txtMaMon.Text = monAn.MaMonAn; txtTenMonAn.Text = monAn.TenMonAn; dipDonGia.Value = (double)monAn.DonGia; cbLoaiMon.DataSource = loaiMonBus.getLoaiMonList(); cbxDonViTinh.DataSource = donvitinhBUS.getDonViTinhList(); cbxDonViTinh.SelectedItem = monAn.DonViTinh; cbLoaiMon.SelectedItem = monAn.LoaiMon; }
public int updateMonAn(MonAn monAn) { int param = 6; string[] names = new string[param]; Object[] values = new Object[param]; names[0] = "@maMonAn"; names[1] = "@tenMonAn"; names[2] = "@hinhAnh"; names[3] = "@donGia"; names[4] = "@maDonVi"; names[5] = "@maLoaiMon"; values[0] = monAn.MaMonAn; values[1] = monAn.TenMonAn; values[2] = monAn.HinhAnh; values[3] = monAn.DonGia; values[4] = monAn.DonViTinh.MaDonVi; values[5] = monAn.LoaiMon.MaLoaiMon; return db.Update("MONAN_proc_update", names, values, param); }
public int updateMonAn(MonAn monan) { return monAnDAO.updateMonAn(monan); }
public int insertMonAn(MonAn monan) { return monAnDAO.insertMonAn(monan); }
public List<MonAn> getMonAnList_With_MaLoaiMon(string maLoaiMon) { int param = 1; string[] names = new string[param]; Object[] values = new Object[param]; names[0] = "@maLoaiMon"; values[0] = maLoaiMon; DataTable tb = db.LoadData("MONAN_proc_load_with_MaLoaiMon", names, values, param); List<MonAn> list = new List<MonAn>(); foreach (DataRow row in tb.Rows) { MonAn monan = new MonAn(); LoaiMon loaimon = new LoaiMon(); DonViTinh donvi = new DonViTinh(); loaimon.MaLoaiMon = row["MaLoaiMon"].ToString(); loaimon.TenLoaiMon = row["TenLoaiMon"].ToString(); monan.LoaiMon = loaimon; monan.MaMonAn = row["MaMonAn"].ToString(); monan.TenMonAn = row["TenMonAn"].ToString(); donvi.MaDonVi = row["MaDonVi"].ToString(); donvi.TenDonVi = row["TenDonVi"].ToString(); monan.DonViTinh = donvi; monan.HinhAnh = row["HinhAnh"].ToString(); monan.DonGia = decimal.Parse(row["DonGia"].ToString()); list.Add(monan); } return list; }