public List <ThongKeModels> sp_danhthutheothang(int thang)
{
var query = from hd in db.HOADONs
join ban in db.BANs on hd.MABAN equals ban.MABAN
join kv in db.KHUVUCs on ban.MAKHUVUC equals kv.MAKHUVUC
where hd.TRANGTHAIHOADON == 1 && hd.NGAYLAP.Value.Year.Equals(DateTime.Now.Year) && hd.NGAYLAP.Value.Month.Equals(thang)
select new { kv.TENKHUVUC, ban.TENBAN, hd.TONGTIEN, hd.NGAYLAP, hd.GIOLAP, hd.IDHOADON };
List <ThongKeModels> list = new List <ThongKeModels>();
foreach (var i in query)
{
ThongKeModels t = new ThongKeModels(i.TENKHUVUC, i.TENBAN, i.TONGTIEN, i.NGAYLAP, i.GIOLAP, i.IDHOADON);
list.Add(t);
}
return(list);
}
public List <ThongKeModels> sp_loaddanhsachthucdoncuaban_thongke(int MAHOADON)
{
var query = from hd in db.HOADONs
join cthd in db.CTHDs on hd.IDHOADON equals cthd.IDHOADON
join td in db.THUCDONs on cthd.MATHUCDON equals td.MATHUCDON
where hd.IDHOADON == MAHOADON
select new { td.TENTHUCDON, DONGIA = td.DONGIA * ((100 - (double)cthd.GIAMGIA)) / 100, cthd.SOLUONG, td.MATHUCDON, cthd.GIAMGIA };
List <ThongKeModels> list = new List <ThongKeModels>();
foreach (var i in query)
{
ThongKeModels t = new ThongKeModels(i.TENTHUCDON, i.DONGIA, i.SOLUONG, i.MATHUCDON, i.GIAMGIA);
list.Add(t);
}
return(list);
}
public List <ThongKeModels> sp_thongkemontheonam(object nam)
{
var query = from hd in db.HOADONs
join cthd in db.CTHDs on hd.IDHOADON equals cthd.IDHOADON
join td in db.THUCDONs on cthd.MATHUCDON equals td.MATHUCDON
where hd.TRANGTHAIHOADON == 1 && hd.NGAYLAP.Value.Equals(nam)
select new { td.TENTHUCDON, cthd.SOLUONG, td.DONGIA, cthd.GIAMGIA } into x
group x by new { x.TENTHUCDON, x.DONGIA } into newgroup
orderby newgroup.Key
select new { TENTHUCDON = newgroup.Key.TENTHUCDON, SOLUONG = newgroup.Sum(i => i.SOLUONG), TongTien = newgroup.Sum((i => i.DONGIA * ((100 - (double)i.GIAMGIA) / 100) * i.SOLUONG)) };
List <ThongKeModels> list = new List <ThongKeModels>();
foreach (var i in query)
{
ThongKeModels t = new ThongKeModels(i.TENTHUCDON, i.SOLUONG, i.TongTien);
list.Add(t);
}
return(list);
}
