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