public List <ThongKe_DTO> ThongKe(DateTime tungay, DateTime denngay)
{
List <ThongKe_DTO> list = new List <ThongKe_DTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_ThongKeDoanhThu @tungay , @denngay", new object[] { tungay, denngay });
foreach (DataRow item in data.Rows)
{
ThongKe_DTO thongke = new ThongKe_DTO(item);
list.Add(thongke);
}
return(list);
}
public List <ThongKe_DTO> GetListThongKe()
{
List <ThongKe_DTO> list = new List <ThongKe_DTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("select IDGiay , TenGiay , SoLuong , DonGia , (SoLuong * DonGia) as N'TongTien' from GIAY");
foreach (DataRow item in data.Rows)
{
ThongKe_DTO tk = new ThongKe_DTO(item);
list.Add(tk);
}
return(list);
}