public IQueryable <BOKhachHang> TimKhachHang(string ten, string dienthoai)
{
if (ten != "" && dienthoai == "")
{
return(from k in frmKhachHang.Query()
join l in frmLoaiKhachHang.Query() on k.LoaiKhachHangID equals l.LoaiKhachHangID
where k.TenKhachHang.Contains(ten)
select new BOKhachHang
{
KhachHang = k,
LoaiKhachHang = l
});
}
if (ten == "" && dienthoai != "")
{
return(from k in frmKhachHang.Query()
join l in frmLoaiKhachHang.Query() on k.LoaiKhachHangID equals l.LoaiKhachHangID
where k.Mobile.Contains(dienthoai)
select new BOKhachHang
{
KhachHang = k,
LoaiKhachHang = l
});
}
return(from k in frmKhachHang.Query()
join l in frmLoaiKhachHang.Query() on k.LoaiKhachHangID equals l.LoaiKhachHangID
where k.TenKhachHang.Contains(ten) || k.Mobile.Contains(dienthoai)
select new BOKhachHang
{
KhachHang = k,
LoaiKhachHang = l
});
}
public IQueryable <BOMenuGia> GetAllByKichThuocMon(MENUKICHTHUOCMON ktm)
{
return(from a in frmLoaiGia.Query()
join b in frmMenuGia.Query() on a.LoaiGiaID equals b.LoaiGiaID
where b.KichThuocMonID == ktm.KichThuocMonID
select new BOMenuGia
{
LoaiGia = a,
MenuGia = b
});
}
public IQueryable <BOChiTietQuyen> GetAll(int MaQuyen, Transit mTransit)
{
var res = (from ctq in frmChiTietQuyen.Query()
join q in frmQuyen.Query() on ctq.QuyenID equals q.MaQuyen
join cn in frmChucNang.Query() on ctq.ChucNangID equals cn.ChucNangID
where ctq.Deleted == false && ctq.QuyenID == MaQuyen
select new BOChiTietQuyen
{
ChiTietQuyen = ctq,
Quyen = q,
ChucNang = cn
});
return(res);
}
public IQueryable <BOTonKhoTong> GetAll(Data.Transit mTransit)
{
return(from tkt in frmTonKhoTong.Query()
join m in frmMon.Query() on tkt.MonID equals m.MonID
select new BOTonKhoTong
{
TonKhoTong = tkt,
Mon = m
});
}
public IQueryable <BOChiTietQuyen> LayDanhSachQuyen(Data.NHANVIEN NhanVien)
{
return(from qnv in frmQuyenNhanVien.Query()
join ctq in frmChiTietQuyen.Query() on qnv.QuyenID equals ctq.QuyenID
where qnv.NhanVienID == NhanVien.NhanVienID
select new BOChiTietQuyen
{
QuyenNhanVien = qnv,
ChiTietQuyen = ctq
});
}
private Data.TONKHOTONG KiemTraTonKhoTong(FrameworkRepository <TONKHOTONG> frm, int KhoID, int MonID, int DonViID)
{
Data.TONKHOTONG item = null;
if (frm.Query().Where(s => s.KhoID == KhoID && s.MonID == MonID && s.DonViID == DonViID).Count() == 0)
{
item = new TONKHOTONG();
item.DonViID = DonViID;
item.KhoID = KhoID;
item.MonID = MonID;
item.TenMonBaoCao = "";
item.SoLuongBan = 0;
item.SoLuongDieuChinh = 0;
item.SoLuongHu = 0;
item.SoLuongNhap = 0;
item.SoLuongTon = 0;
item.SoLuongMat = 0;
item.SoLuongChuyen = 0;
return(item);
}
return(frm.Query().Where(s => s.KhoID == KhoID && s.MonID == MonID && s.DonViID == DonViID).FirstOrDefault());
}
public IQueryable <BOMenuItemMayIn> GetAll(int MonID, Transit mTransit)
{
return(from mim in frmMenuItemMayIn.Query()
join mi in frmMayIn.Query() on mim.MayInID equals mi.MayInID
join m in frmMenuMon.Query() on mim.MonID equals m.MonID
where mim.Deleted == false && mim.MonID == MonID
select new BOMenuItemMayIn
{
MenuItemMayIn = mim,
MayIn = mi,
MenuMon = m
});
}
public IQueryable <BOQuyenNhanVien> GetAll(int MaQuyen, Transit mTransit)
{
return(from qnv in frmQuyenNhanVien.Query()
join q in frmQuyen.Query() on qnv.QuyenID equals q.MaQuyen
join nv in frmNhanVien.Query() on qnv.NhanVienID equals nv.NhanVienID
where qnv.Deleted == false && qnv.Deleted == false && qnv.QuyenID == MaQuyen
select new BOQuyenNhanVien
{
QuyenNhanVien = qnv,
Quyen = q,
NhanVien = nv
});
}
public IQueryable <BODinhLuong> GetAll(int KichThuocMonID, Transit mTransit)
{
var res = (from dl in frmDinhLuong.Query()
join mm in frmMenuMon.Query() on dl.MonID equals mm.MonID
join lb in frmLoaiBan.Query() on dl.LoaiBanID equals lb.LoaiBanID
where dl.KichThuocMonChinhID == KichThuocMonID
select new BODinhLuong
{
DinhLuong = dl,
MenuMon = mm,
LoaiBan = lb
});
return(res);
}
public IQueryable <BOXuLyKhoChiTiet> GetAll(int NhapKhoID, Transit mTransit)
{
return(from ctnk in frmChiTietXuLyKho.Query()
join tk in frmTonKho.Query() on ctnk.TonKhoID equals tk.TonKhoID
join lb in frmLoaiBan.Query() on tk.LoaiBanID equals lb.LoaiBanID
join mm in frmMenuMon.Query() on tk.MonID equals mm.MonID
join nk in frmXyLyKho.Query() on ctnk.ChinhKhoID equals nk.ChinhKhoID
select new BOXuLyKhoChiTiet
{
XuLyKhoChiTiet = ctnk,
XuLyKho = nk,
LoaiBan = lb,
TonKho = tk,
MenuMon = mm
});
}
public CAIDATBAN GetAll(Data.Transit transit)
{
CAIDATBAN item = fr.Query().FirstOrDefault();
if (item == null)
{
item = new CAIDATBAN();
item.TableWidth = (decimal)0.0735294000;
item.TableHeight = (decimal)0.0938086000;
item.TableFontStyle = (int)SomeEnum.FontStyles.Normal;
item.TableFontWeights = (int)SomeEnum.FontWeights.Normal;
fr.AddObject(item);
fr.Commit();
}
return(item);
}
public IQueryable <BOXuLyKho> GetAll(Transit mTransit, DateTime dt)
{
return(from xlk in frmXuLyKho.Query()
join k in frmKho.Query() on xlk.KhoID equals k.KhoID
join nv in frmNhanVien.Query() on xlk.NhanVienID equals nv.NhanVienID
join l in frmXuLyKhoLoai.Query() on xlk.LoaiID equals l.ID
where xlk.ThoiGian.Value.Year == dt.Year && xlk.ThoiGian.Value.Month == dt.Month && xlk.ThoiGian.Value.Day == dt.Day
select new BOXuLyKho
{
XuLyKho = xlk,
Kho = k,
NhanVien = nv,
Loai = l
}
);
}
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 <BOMenuNhom> GetAll(int LoaiNhomID, bool IsBanHang, bool IsSoLuongChoPhepTonKho, bool IsSoLuongKhongChoPhepTonKho, bool IsVisual, Transit mTransit)
{
var lsArray = from n in frmNhom.Query().Where(o => o.Deleted == false) select new BOMenuNhom {
MenuNhom = n
};
if (LoaiNhomID > 0)
{
lsArray = lsArray.Where(s => (s.MenuNhom.LoaiNhomID == LoaiNhomID || LoaiNhomID == 0) && s.MenuNhom.Deleted == false);
}
if (IsBanHang)
{
if (IsSoLuongChoPhepTonKho && IsSoLuongKhongChoPhepTonKho)
{
lsArray = lsArray.Where(s => s.MenuNhom.Visual == true && s.MenuNhom.SLMonChoPhepTonKho > 0 || s.MenuNhom.SLMonKhongChoPhepTonKho > 0);
}
else if (IsSoLuongChoPhepTonKho)
{
lsArray = lsArray.Where(s => s.MenuNhom.Visual == true && s.MenuNhom.SLMonChoPhepTonKho > 0);
}
else if (IsSoLuongKhongChoPhepTonKho)
{
lsArray = lsArray.Where(s => s.MenuNhom.Visual == true && s.MenuNhom.SLMonKhongChoPhepTonKho > 0);
}
}
else
{
if (!IsSoLuongChoPhepTonKho)
{
lsArray = lsArray.Where(s => s.MenuNhom.SLMonKhongChoPhepTonKho > 0);
}
if (!IsSoLuongKhongChoPhepTonKho)
{
lsArray = lsArray.Where(s => s.MenuNhom.SLMonChoPhepTonKho > 0);
}
}
if (IsVisual)
{
lsArray = lsArray.Where(s => s.MenuNhom.Visual == true);
}
return(lsArray.OrderBy(s => s.MenuNhom.SapXep));
}
/// <summary>
///
/// </summary>
/// <param name="MonID"></param>
/// <param name="IsDinhLuong">Có cho load định lượng lên không</param>
/// <param name="IsThoiGian">Có cho load thời gian lên không</param>
/// <param name="mTransit"></param>
/// <returns></returns>
public IQueryable <BOMenuKichThuocMon> GetAll(int MonID, bool IsSoLuongChoPhepTonKho, bool IsSoLuongKhongChoPhepTonKho, Transit mTransit)
{
var res = (from k in frmKichThuocMon.Query()
join m in frmmenuMon.Query() on k.MonID equals m.MonID
join l in frmLoaiBan.Query() on k.LoaiBanID equals l.LoaiBanID
where k.MonID == MonID && k.Deleted == false
select new BOMenuKichThuocMon
{
MenuKichThuocMon = k,
MenuMon = m,
LoaiBan = l
});
if (!IsSoLuongChoPhepTonKho)
{
res = res.Where(s => s.MenuKichThuocMon.ChoPhepTonKho == false);
}
else if (!IsSoLuongKhongChoPhepTonKho)
{
res = res.Where(s => s.MenuKichThuocMon.ChoPhepTonKho == true);
}
return(res);
}
public IQueryable <BAN> GetAllTablePerArea(KHU khu)
{
frBan.Refresh();
return(frBan.Query().Where(o => o.KhuID == khu.KhuID && o.Deleted == false));
}
private int ThemMoi(BOXuLyKho item, List <BOXuLyKhoChiTiet> lsArray, Transit mTransit)
{
if (lsArray != null)
{
List <Data.TONKHOTONG> lsTonKhoTong = new List <TONKHOTONG>();
List <Data.TONKHO> lsTonKho = new List <TONKHO>();
foreach (BOXuLyKhoChiTiet line in lsArray)
{
IQueryable <Data.TONKHO> lsArrayLine = null;
switch (item.XuLyKho.LoaiID)
{
case 1:
lsArrayLine = frmTonKho.Query().Where(s => s.DonViID == line.TonKho.DonViID && s.MonID == line.TonKho.MonID && s.KhoID == item.XuLyKho.KhoID && s.SoLuongTon > 0).OrderBy(s => s.NgayHetHan).ThenBy(s => s.TonKhoID);
if (lsArrayLine.Count() > 0 && line.TonKho.SoLuongNhap < lsArrayLine.Sum(s => s.SoLuongTon) && line.TonKho.SoLuongNhap > 0)
{
foreach (var l in lsArrayLine)
{
if (line.TonKho.SoLuongNhap > 0)
{
Data.TONKHOTONG tonkhotong = null;
if (lsTonKhoTong.Exists(s => s.KhoID == item.XuLyKho.KhoID && s.MonID == line.TonKho.MonID && s.DonViID == line.TonKho.DonViID))
{
tonkhotong = lsTonKhoTong.Find(s => s.KhoID == item.XuLyKho.KhoID && s.MonID == line.TonKho.MonID && s.DonViID == line.TonKho.DonViID);
}
else
{
tonkhotong = KiemTraTonKhoTong(frmTonKhoTong, (int)item.XuLyKho.KhoID, (int)line.TonKho.MonID, (int)line.TonKho.DonViID);
lsTonKhoTong.Add(tonkhotong);
}
tonkhotong.SoLuongTon += line.TonKho.SoLuongNhap;
tonkhotong.SoLuongDieuChinh += line.TonKho.SoLuongNhap;
Data.TONKHO tonkho = null;
if (lsTonKho.Exists(s => s.TonKhoID == l.TonKhoID))
{
tonkho = lsTonKho.Find(s => s.TonKhoID == l.TonKhoID);
}
else
{
tonkho = l;
lsTonKho.Add(tonkho);
}
line.XuLyKhoChiTiet.TONKHO = new TONKHO();
line.XuLyKhoChiTiet.TONKHO.PhatSinhTuTonKhoID = tonkho.TonKhoID;
line.XuLyKhoChiTiet.TONKHO.LoaiPhatSinhID = (int)item.XuLyKho.LoaiID;
CopyTonKho(line.XuLyKhoChiTiet.TONKHO, tonkho);
if (tonkho.SoLuongTon > line.TonKho.SoLuongNhap)
{
line.XuLyKhoChiTiet.TONKHO.SoLuongPhatSinh = tonkho.SoLuongTon - line.TonKho.SoLuongNhap;
tonkho.SoLuongTon += line.TonKho.SoLuongNhap;
line.TonKho.SoLuongNhap = 0;
}
else
{
line.XuLyKhoChiTiet.TONKHO.SoLuongPhatSinh = line.TonKho.SoLuongNhap - tonkho.SoLuongTon;
line.TonKho.SoLuongNhap += tonkho.SoLuongTon;
tonkho.SoLuongTon = 0;
}
}
}
}
break;
case 2:
case 3:
lsArrayLine = frmTonKho.Query().Where(s => s.DonViID == line.TonKho.DonViID && s.MonID == line.TonKho.MonID && s.KhoID == item.XuLyKho.KhoID && s.SoLuongTon > 0).OrderBy(s => s.NgayHetHan).ThenBy(s => s.TonKhoID);
if (lsArrayLine.Count() > 0 && line.TonKho.SoLuongNhap < lsArrayLine.Sum(s => s.SoLuongTon) && line.TonKho.SoLuongNhap > 0)
{
foreach (var l in lsArrayLine)
{
if (line.TonKho.SoLuongNhap > 0)
{
Data.TONKHOTONG tonkhotong = null;
if (lsTonKhoTong.Exists(s => s.KhoID == item.XuLyKho.KhoID && s.MonID == line.TonKho.MonID && s.DonViID == line.TonKho.DonViID))
{
tonkhotong = lsTonKhoTong.Find(s => s.KhoID == item.XuLyKho.KhoID && s.MonID == line.TonKho.MonID && s.DonViID == line.TonKho.DonViID);
}
else
{
tonkhotong = KiemTraTonKhoTong(frmTonKhoTong, (int)item.XuLyKho.KhoID, (int)line.TonKho.MonID, (int)line.TonKho.DonViID);
lsTonKhoTong.Add(tonkhotong);
}
tonkhotong.SoLuongTon -= line.TonKho.SoLuongNhap;
if (item.XuLyKho.LoaiID == 2)
{
tonkhotong.SoLuongMat += line.TonKho.SoLuongNhap;
}
if (item.XuLyKho.LoaiID == 3)
{
tonkhotong.SoLuongHu += line.TonKho.SoLuongNhap;
}
Data.TONKHO tonkho = null;
if (lsTonKho.Exists(s => s.TonKhoID == l.TonKhoID))
{
tonkho = lsTonKho.Find(s => s.TonKhoID == l.TonKhoID);
}
else
{
tonkho = l;
lsTonKho.Add(tonkho);
}
line.XuLyKhoChiTiet.TONKHO = new TONKHO();
line.XuLyKhoChiTiet.TONKHO.PhatSinhTuTonKhoID = tonkho.TonKhoID;
line.XuLyKhoChiTiet.TONKHO.LoaiPhatSinhID = (int)item.XuLyKho.LoaiID;
CopyTonKho(line.XuLyKhoChiTiet.TONKHO, tonkho);
if (tonkho.SoLuongTon > line.TonKho.SoLuongNhap)
{
line.XuLyKhoChiTiet.TONKHO.SoLuongPhatSinh = tonkho.SoLuongTon - line.TonKho.SoLuongNhap;
tonkho.SoLuongTon -= line.TonKho.SoLuongNhap;
line.TonKho.SoLuongNhap = 0;
}
else
{
line.XuLyKhoChiTiet.TONKHO.SoLuongPhatSinh = line.TonKho.SoLuongNhap - tonkho.SoLuongTon;
line.TonKho.SoLuongNhap -= tonkho.SoLuongTon;
tonkho.SoLuongTon = 0;
}
}
}
}
break;
default:
break;
}
line.XuLyKho = new XULYKHO();
line.XuLyKho.KhoID = item.XuLyKho.KhoID;
item.XuLyKho.XULYKHOCHITIETs.Add(line.XuLyKhoChiTiet);
}
item.XuLyKho.TongTien = lsArray.Sum(s => s.TonKho.SoLuongNhap * s.TonKho.GiaBan);
foreach (TONKHO i in lsTonKho)
{
frmTonKho.Update(i);
}
foreach (TONKHOTONG i in lsTonKhoTong)
{
frmTonKhoTong.Update(i);
}
frmTonKho.Commit();
frmTonKhoTong.Commit();
}
return(item.XuLyKho.ChinhKhoID);
}