public IQueryable <BOMenuMon> GetAll(int GroupID, bool IsBanHang, bool IsSoLuongChoPhepTonKho, bool IsSoLuongKhongChoPhepTonKho, bool IsVisual, Transit mTransit) { frmMon.Refresh(); var lsArray = from m in frmMon.Query() join n in frmNhom.Query() on(int) m.NhomID equals(int) n.NhomID select new BOMenuMon { MenuMon = m, MenuNhom = n }; if (GroupID > -1) { lsArray = lsArray.Where(s => s.MenuMon.NhomID == GroupID && s.MenuMon.Deleted == false); } if (IsBanHang) { if (IsSoLuongChoPhepTonKho && IsSoLuongKhongChoPhepTonKho) { lsArray = lsArray.Where(s => s.MenuMon.SLMonKhongChoPhepTonKho > 0 || s.MenuMon.SLMonChoPhepTonKho > 0); } else if (IsSoLuongChoPhepTonKho) { lsArray = lsArray.Where(s => s.MenuMon.SLMonChoPhepTonKho > 0); } else if (IsSoLuongKhongChoPhepTonKho) { lsArray = lsArray.Where(s => s.MenuMon.SLMonKhongChoPhepTonKho > 0); } } else { if (!IsSoLuongChoPhepTonKho) { lsArray = lsArray.Where(s => s.MenuMon.SLMonKhongChoPhepTonKho > 0); } if (!IsSoLuongKhongChoPhepTonKho) { lsArray = lsArray.Where(s => s.MenuMon.SLMonChoPhepTonKho > 0); } } if (IsVisual) { lsArray = lsArray.Where(s => s.MenuMon.Visual == true); } return(lsArray.OrderBy(s => s.MenuMon.SapXep)); }
public IQueryable <BAN> GetAllTablePerArea(KHU khu) { frBan.Refresh(); return(frBan.Query().Where(o => o.KhuID == khu.KhuID && o.Deleted == false)); }