public List <ThongKeBEAN> getListThongKeTheoThang(long thang, long nam) { string sql = "SELECT * FROM Qtk WHERE MONTH(NgayBan) = @thang AND YEAR(NgayBan) = @nam"; SqlCommand cmd = new SqlCommand(sql, DungChung.cn); SqlParameter ts = new SqlParameter("@thang", thang); SqlParameter ts2 = new SqlParameter("@nam", nam); cmd.Parameters.Add(ts); cmd.Parameters.Add(ts2); SqlDataReader rs = cmd.ExecuteReader(); List <ThongKeBEAN> ds = new List <ThongKeBEAN>(); while (rs.Read()) { string tenHang = rs["TenHang"].ToString(); string gia = rs["Gia"].ToString(); string soLuongMua = rs["SoLuongMua"].ToString(); string thanhTien = rs["ThanhTien"].ToString(); string ngayBan = rs["NgayBan"].ToString(); ThongKeBEAN thongKe = new ThongKeBEAN(tenHang, long.Parse(gia), long.Parse(soLuongMua), long.Parse(thanhTien), DateTime.Parse(ngayBan)); ds.Add(thongKe); } rs.Close(); return(ds); }
public List <ThongKeBEAN> getListThongKe(string ma) { string sql = "SELECT * FROM ThongKe WHERE MaHang = @maHang "; SqlCommand cmd = new SqlCommand(sql, DungChung.cn); cmd.Parameters.Add(new SqlParameter("@maHang", ma)); SqlDataReader rs = cmd.ExecuteReader(); List <ThongKeBEAN> ds = new List <ThongKeBEAN>(); while (rs.Read()) { string TenHang = rs["TenHang"].ToString(); string SoLuongMua = rs["SoLuongMua"].ToString(); string ThanhTien = rs["ThanhTien"].ToString(); ThongKeBEAN ban = new ThongKeBEAN(TenHang, long.Parse(SoLuongMua), long.Parse(ThanhTien)); ds.Add(ban); } rs.Close(); return(ds); }