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