public static List<P_DonDatHangCT> get_DonDatHangCT_of_DonDatHang(objCondition.oDonDatHang obj) { using (var model = ModelConnector.Connector()) { var list = from lst in model.P_DonDatHangCT join lstDDH in model.P_DonDatHang on lst.SoDonDatHang equals lstDDH.SoDonDatHang //where lstDDH.NgayDatHang.Value.Year >= obj.F_NgayDatHang.Value.Year && lstDDH.NgayDatHang.Value.Year <= obj.T_NgayDatHang.Value.Year // && lstDDH.NgayDatHang.Value.Month >= obj.F_NgayDatHang.Value.Month && lstDDH.NgayDatHang.Value.Month <= obj.T_NgayDatHang.Value.Month // && lstDDH.NgayDatHang.Value.Day >= obj.F_NgayDatHang.Value.Day && lstDDH.NgayDatHang.Value.Day <= obj.T_NgayDatHang.Value.Day select new { P_DonDatHangCT = lst, P_DonDatHang = lstDDH }; if(!string.IsNullOrEmpty(obj.F_NgayDatHang.ToString())) { list = list.Where(lstDDH => lstDDH.P_DonDatHang.NgayDatHang.Value.Year > obj.F_NgayDatHang.Value.Year && lstDDH.P_DonDatHang.NgayDatHang.Value.Month > obj.F_NgayDatHang.Value.Month && lstDDH.P_DonDatHang.NgayDatHang.Value.Day >= obj.F_NgayDatHang.Value.Day); } if(!string.IsNullOrEmpty(obj.T_NgayDatHang.ToString())) { list = list.Where(lstDDH => lstDDH.P_DonDatHang.NgayDatHang.Value.Year < obj.T_NgayDatHang.Value.Year && lstDDH.P_DonDatHang.NgayDatHang.Value.Month < obj.T_NgayDatHang.Value.Month && lstDDH.P_DonDatHang.NgayDatHang.Value.Day < obj.T_NgayDatHang.Value.Day); } return list.Select(a => a.P_DonDatHangCT).ToList(); } }
public static List<P_BienBan_CT_Phieu> find(objCondition.oBienBan_CT_Phieu obj) { using (var model = ModelConnector.Connector()) { var list = from l in model.P_BienBan_CT_Phieu select l; if (!string.IsNullOrEmpty(obj.SoBienBan.ToString())) list = list.Where(l => l.SoBienBan == obj.SoBienBan); return list.ToList(); } }
public static List<P_HoaDon> find(objCondition.oHoaDon obj) { using (var model= ModelConnector.Connector()) { var list = from lst in model.P_HoaDon select lst; if (!string.IsNullOrEmpty(obj.SoHoaDon)) list = list.Where(a => a.SoHoaDon.Contains(obj.SoHoaDon)); if (!string.IsNullOrEmpty(obj.F_NgayHD.ToString())) list = list.Where(a => a.NgayHD >= obj.F_NgayHD); if (!string.IsNullOrEmpty(obj.T_NgayHD.ToString())) list = list.Where(a => a.NgayHD <= obj.T_NgayHD); return list.ToList(); } }
public static List<P_BienBanGiaoNhan> find(objCondition.oBienBanGiaoNhan obj) { using(var model= ModelConnector.Connector()) { var list = from l in model.P_BienBanGiaoNhan select l; if (!string.IsNullOrEmpty(obj.SoBienBan.ToString())) list = list.Where(l => l.SoBienBan.ToString().Contains(obj.SoBienBan.ToString())); if (!string.IsNullOrEmpty(obj.F_NgayGiaoDich.ToString())) list = list.Where(l => l.NgayGiaoDich > obj.F_NgayGiaoDich); if (!string.IsNullOrEmpty(obj.T_NgayGiaoDich.ToString())) list = list.Where(l => l.NgayGiaoDich < obj.T_NgayGiaoDich); return list.ToList(); } }
public static List<P_BienBan_CT_Phieu> get_BienBan_CT_Phieu_of_BienBan(objCondition.oBienBanGiaoNhan obj) { using (var model = ModelConnector.Connector()) { var list = from l in model.P_BienBan_CT_Phieu join bb in model.P_BienBanGiaoNhan on l.SoBienBan equals bb.SoBienBan select new { P_BienBan_CT_Phieu = l, P_BienBanGiaoNhan = bb }; if (!string.IsNullOrEmpty(obj.F_NgayGiaoDich.ToString())) list = list.Where(l => l.P_BienBanGiaoNhan.NgayGiaoDich.Value.Year > obj.F_NgayGiaoDich.Value.Year && l.P_BienBanGiaoNhan.NgayGiaoDich.Value.Month > obj.F_NgayGiaoDich.Value.Month && l.P_BienBanGiaoNhan.NgayGiaoDich.Value.Day > obj.F_NgayGiaoDich.Value.Day); if (!string.IsNullOrEmpty(obj.T_NgayGiaoDich.ToString())) list = list.Where(l => l.P_BienBanGiaoNhan.NgayGiaoDich.Value.Year < obj.T_NgayGiaoDich.Value.Year && l.P_BienBanGiaoNhan.NgayGiaoDich.Value.Month < obj.T_NgayGiaoDich.Value.Month && l.P_BienBanGiaoNhan.NgayGiaoDich.Value.Day < obj.T_NgayGiaoDich.Value.Day); return list.Select(a => a.P_BienBan_CT_Phieu).ToList(); } }