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