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));
}
