private void ThemDanhSachBan() { IQueryable <Data.LOAIBAN> lsLoaiBan = Data.BOLoaiBan.GetAllNoTracking(mTransit, (int)_Mon.MenuMon.DonViID); if (lsLoaiBan.Count() > 0) { _Mon.MenuMon.SapXepKichThuocMon = 2; _Mon.MenuMon.SLMonChoPhepTonKho = 1; _Mon.MenuMon.SLMonKhongChoPhepTonKho = 0; Data.LOAIBAN item = lsLoaiBan.OrderByDescending(s => s.KichThuocBan).FirstOrDefault(); _Mon.MenuKichThuocMon = new Data.MENUKICHTHUOCMON() { TenLoaiBan = "", LoaiBanID = item.LoaiBanID, DonViID = item.DonViID, GiaBanMacDinh = _Mon.MenuMon.Gia, ChoPhepTonKho = true, ThoiGia = false, KichThuocLoaiBan = item.KichThuocBan, SoLuongBanBan = 1, SapXep = 1, Visual = true, Edit = false, Deleted = false }; } }
private void GetValues() { if (_Item == null) { _Item = new Data.BOMenuKichThuocMon(); } _Item.MenuKichThuocMon.MonID = mMon.MenuMon.MonID; _Item.MenuKichThuocMon.LoaiBanID = (int)cbbLoaiBan.SelectedValue; Data.LOAIBAN loaiBan = (Data.LOAIBAN)cbbLoaiBan.SelectedItem; _Item.LoaiBan = loaiBan; _Item.MenuKichThuocMon.DonViID = _Item.LoaiBan.DonViID; _Item.MenuKichThuocMon.TenLoaiBan = txtTenLoaiBan.Text; _Item.MenuKichThuocMon.KichThuocLoaiBan = System.Convert.ToInt32(txtKichThuocLoaiBan.Text); _Item.MenuKichThuocMon.KichThuocLoaiBan = (int)_Item.MenuKichThuocMon.KichThuocLoaiBan * (int)loaiBan.KichThuocBan; _Item.MenuKichThuocMon.GiaBanMacDinh = Utilities.MoneyFormat.ConvertToDecimal(txtGiaMacDinh.Text); _Item.MenuKichThuocMon.SoLuongBanBan = System.Convert.ToInt32(txtSoLuongBan.Text); _Item.MenuKichThuocMon.Visual = (bool)ckBan.IsChecked; _Item.MenuKichThuocMon.ChoPhepTonKho = (bool)ckChoPhepTonKho.IsChecked; _Item.MenuKichThuocMon.ThoiGia = false; _Item.MenuKichThuocMon.Deleted = false; }
private void cbbLoaiBan_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (cbbLoaiBan.SelectedValue != null) { Data.LOAIBAN lb = (Data.LOAIBAN)cbbLoaiBan.SelectedItem; switch (lb.LoaiBanID) { case (int)Data.EnumLoaiBan.Cai: case (int)Data.EnumLoaiBan.DinhLuong: txtKichThuocLoaiBan.Text = "1"; break; case (int)Data.EnumLoaiBan.Gram: case (int)Data.EnumLoaiBan.Millilit: case (int)Data.EnumLoaiBan.Kg: case (int)Data.EnumLoaiBan.Lit: case (int)Data.EnumLoaiBan.Gio: case (int)Data.EnumLoaiBan.Phut: case (int)Data.EnumLoaiBan.Giay: if (_Item == null) { txtKichThuocLoaiBan.Text = "1"; } //else if (_Item.MenuKichThuocMon.LoaiBanID == lb.LoaiBanID) // //txtKichThuocLoaiBan.Text = ((int)(_Item.MenuKichThuocMon.KichThuocLoaiBan / lb.KichThuocBan)).ToString(); // txtSoLuongBan.Text = txtKichThuocLoaiBan.Text = lb.KichThuocBan.ToString(); else { txtKichThuocLoaiBan.Text = lb.KichThuocBan.ToString(); } break; default: break; } } }
public void ImportItem(string url) { _OnImportExport("----------------------------", false); _OnImportExport(String.Format("Đọc tập tin excel..."), false); var listItem = ExcelReader.GetDataToList(url, MON, ImportExportItem.GetProductData); List <Data.MENUNHOM> listNhom = new List <Data.MENUNHOM>(); //List<Data.MENUMON> listMon = new List<Data.MENUMON>(); _OnImportExport(String.Format("Xóa dữ liệu cũ..."), false); mKaraokeEntities.ExecuteStoreCommand("SP_DELETE_ALL_MENU"); _OnImportExport(String.Format("Tạo {0}...", MAYIN), false); Data.MAYIN mayin = new Data.MAYIN(); mayin.TenMayIn = "Test"; mayin.TieuDeIn = "BẾP"; mayin.SoLanIn = 1; mayin.Visual = true; mKaraokeEntities.MAYINs.AddObject(mayin); _OnImportExport(String.Format("Tạo {0}...", MAYIN), false); Data.MAYIN mayinBill = new Data.MAYIN(); mayinBill.TenMayIn = "Test"; mayinBill.TieuDeIn = "HÓA ĐƠN"; mayinBill.SoLanIn = 1; mayinBill.MayInHoaDon = true; mayinBill.Visual = true; mKaraokeEntities.MAYINs.AddObject(mayinBill); _OnImportExport(String.Format("Tạo {0}...", DONVI), false); Data.DONVI donvi = mKaraokeEntities.DONVIs.Where(o => o.DonViID == 1).FirstOrDefault(); if (donvi == null) { donvi = new Data.DONVI(); donvi.TenDonVi = "Số lượng"; donvi.Visual = true; mKaraokeEntities.DONVIs.AddObject(donvi); } _OnImportExport(String.Format("Tạo {0}...", LOAIDONVIBAN), false); Data.LOAIBAN loaiban = mKaraokeEntities.LOAIBANs.Where(o => o.LoaiBanID == 1).FirstOrDefault(); if (loaiban == null) { loaiban.TenLoaiBan = "Cái"; loaiban.KichThuocBan = 1; loaiban.Visual = true; mKaraokeEntities.LOAIBANs.AddObject(loaiban); donvi.LOAIBANs.Add(loaiban); } foreach (var item in listItem) { var nhom = (from a in listNhom where a.TenNgan == item.TenNhom select a).FirstOrDefault(); if (nhom == null) { _OnImportExport(String.Format("Tạo {0}---{1}", NHOM, item.TenNhom), false); nhom = new Data.MENUNHOM(); nhom.TenDai = nhom.TenNgan = item.TenNhom; nhom.Visual = true; mKaraokeEntities.MENUNHOMs.AddObject(nhom); listNhom.Add(nhom); } var mon = (from a in nhom.MENUMONs where a.TenNgan == item.TenMon select a).FirstOrDefault(); if (mon == null) { _OnImportExport(String.Format("Tạo {0}---{1}", MON, item.TenMon), false); mon = new Data.MENUMON(); mon.TenNgan = mon.TenDai = item.TenMon; mon.Gia = item.DonGia; mon.Visual = true; nhom.MENUMONs.Add(mon); donvi.MENUMONs.Add(mon); nhom.SLMonChoPhepTonKho++; Data.MENUITEMMAYIN monmayin = new Data.MENUITEMMAYIN(); mon.MENUITEMMAYINs.Add(monmayin); mayin.MENUITEMMAYINs.Add(monmayin); mKaraokeEntities.MENUMONs.AddObject(mon); //listMon.Add(mon); } _OnImportExport(String.Format("Tạo {0}---{1}", CHITIETMON, item.ChiTietMon), false); Data.MENUKICHTHUOCMON ktm = new Data.MENUKICHTHUOCMON(); ktm.TenLoaiBan = item.ChiTietMon; ktm.GiaBanMacDinh = item.DonGia; ktm.SoLuongBanBan = item.SoLuongBanMacDinh; ktm.KichThuocLoaiBan = 1; ktm.Visual = true; ktm.ChoPhepTonKho = true; mon.SLMonChoPhepTonKho++; mon.MENUKICHTHUOCMONs.Add(ktm); loaiban.MENUKICHTHUOCMONs.Add(ktm); donvi.MENUKICHTHUOCMONs.Add(ktm); mKaraokeEntities.MENUKICHTHUOCMONs.AddObject(ktm); } _OnImportExport(String.Format("Lưu dữ liệu..."), false); mKaraokeEntities.SaveChanges(); _OnImportExport(String.Format("Lưu dữ liệu thành công ...{0}", url), false); }