public async Task <dynamic> thongKeNhapHangTheoNam(string nam) { //ThongKeDoanhThu thongKe = new ThongKeDoanhThu(); IEnumerable <chiphiThang> dsNhapHang = null; using (var connection = new SqlConnection(connectionstr)) { string query = @"select DATEPART(Month, NgayTao) thang, SUM(DonGia) tongTien from CHITIETPHIEUNHAP CT INNER JOIN PHIEUNHAP PN ON CT.MaPN = PN.MaPN WHERE DATEPART(Year, NgayTao)='" + nam + @"' GROUP BY DATEPART(Year, NgayTao),DATEPART(Month, NgayTao) ORDER BY Thang "; dsNhapHang = await connection.QueryAsync <chiphiThang>(query, commandType : CommandType.Text); chiphiThang[] ds = new chiphiThang[12]; for (int i = 0; i < 12; i++) { ds[i] = new chiphiThang(); ds[i].thang = (i + 1).ToString(); ds[i].tongTien = 0; } foreach (var item in dsNhapHang) { ds[int.Parse(item.thang) - 1] = item; } return(ds); } }
public async Task <dynamic> thongKeDoanhThuTheoNam(string nam) { //ThongKeDoanhThu thongKe = new ThongKeDoanhThu(); using (var connection = new SqlConnection(connectionstr)) { IEnumerable <chiphiThang> dsDoanhThu = null; string query = @"select DATEPART(Month, NgayDat) thang, SUM(DonGia) tongTien from CHITIETDONDATHANG CT INNER JOIN DONDATHANG DDH ON CT.MaDDH = DDH.MaDDH WHERE DATEPART(Year, NgayDat)='" + nam + @"' AND TinhTrang=1 GROUP BY DATEPART(Year, NgayDat),DATEPART(Month, NgayDat) ORDER BY Thang "; dsDoanhThu = await connection.QueryAsync <chiphiThang>(query, commandType : CommandType.Text); chiphiThang[] ds = new chiphiThang[12]; for (int i = 0; i < 12; i++) { ds[i] = new chiphiThang(); ds[i].thang = (i + 1).ToString(); ds[i].tongTien = 0; } foreach (var item in dsDoanhThu) { ds[int.Parse(item.thang) - 1] = item; } return(ds); } }