public DataTable ThongKeNhapKho(DateTime begin, DateTime end)
{
DataTable result = new CrystalReports.THINKPRODataset.ThongKeNKDataTable().Clone();
foreach (DataRow SP in data.Tables["SANPHAM"].Rows)
{
List <int> GIANHAP = new List <int>();
DataRow NK = result.NewRow();
NK["MASP"] = SP["ID_SP"];
NK["TENSP"] = SP["TENSP"];
NK["SOLUONGNHAP"] = 0;
foreach (DataRow CTPN in _CHITIETPN.Rows)
{
if (NK["MASP"].ToString() == CTPN["ID_SP"].ToString())
{
DataRow PN = _PHIEUNHAP.AsEnumerable().SingleOrDefault(t => t.Field <string>("ID_PN") == CTPN.Field <string>("ID_PN"));
if (PN != null)
{
if (DateTime.Compare(begin, PN.Field <DateTime>("NGAYNHAP")) <= 0 && DateTime.Compare(PN.Field <DateTime>("NGAYNHAP"), end) <= 0)
{
GIANHAP.Add(CTPN.Field <int>("DONGIANHAP"));
NK["SOLUONGNHAP"] = NK.Field <int>("SOLUONGNHAP") + CTPN.Field <int>("SOLUONGNHAP");
}
}
}
}
if (NK.Field <int>("SOLUONGNHAP") > 0)
{
NK["GIANHAP"] = GIANHAP.Average();
result.Rows.Add(NK);
}
}
return(result);
}
