Esempi in C# (CSharp) per DoanhThu_BUS.Top3MuaMonth

Esempio n. 1

File: Frm_ThongKe.cs Progetto: nguyenkhanh2003/DATN

 public void Top3SPMuaNhieuTrongThang(string condition)
 {
     dataGridView1.DataSource = bus.Top3MuaMonth("SELECT TOP(3) lk.TenLK As'Tên Sản Phẩm', SUM(ct.SoLuong) AS 'Số Lượng'" +
                                                 " FROM CT_HoaDonNhapHang ct, HoaDonNhapHang hd, LinhKien lk " +
                                                 "where ct.MaHDNH = hd.MaHDNH and lk.MaLK = ct.MaLK  and Month(hd.NgayLapHDNH) =" + condition + " " +
                                                 "GROUP BY lk.TenLK ORDER BY SUM(ct.SoLuong) DESC");
 }