public decimal TinhToanSLPhatTheoDaiLy(string MaDaiLy, string MaLoaiVeSo, System.DateTime NgayNhan)
{
var dao = new QLVESODbContext();
decimal SLDK = dao.SoLuongDKs.OrderByDescending(m => m.NgayDK).Where(m => m.MaDaiLy == MaDaiLy & System.DateTime.Compare(m.NgayDK, NgayNhan) <= 0).Select(m => (int)m.SoLuongDK1).FirstOrDefault();
System.DateTime NgayDK = dao.SoLuongDKs.OrderByDescending(m => m.NgayDK).Where(m => m.MaDaiLy == MaDaiLy & System.DateTime.Compare(m.NgayDK, NgayNhan) <= 0).Select(m => m.NgayDK).FirstOrDefault();
var listTop3 = dao.PhatHanhs.Where(m => m.MaDaiLy == MaDaiLy & System.DateTime.Compare(m.NgayNhan, NgayNhan) <= 0 & m.SLBan != null).OrderByDescending(m => m.NgayNhan).Take(3);
int count = listTop3.Count();
if (count == 0)
{
return(SLDK);
}
else
{
decimal?sum = 0;
foreach (var item in listTop3)
{
sum += item.SLBan / item.SoLuong;
}
decimal?getReturn = Math.Round((decimal)sum / count * SLDK);
return(getReturn ?? default(decimal));
}
}
public PhieuChiDao()
{
db = new QLVESODbContext();
}
public KetQuaDao()
{
db = new QLVESODbContext();
}
public SoLuongDKDao()
{
db = new QLVESODbContext();
}
public PhatHanhDao()
{
db = new QLVESODbContext();
}
public PhieuThuDao()
{
db = new QLVESODbContext();
}
public GiaiDao()
{
db = new QLVESODbContext();
}
public DaiLyDao()
{
db = new QLVESODbContext();
}
public LoaiVeSoDao()
{
db = new QLVESODbContext();
}