Ejemplos de DuLieu_DoThiCot en C# (CSharp)

Ejemplo n.º 1

 public DataTable DoanhThuTheLoaiMuaItNhat_SelectAll(DuLieu_DoThiCot dlc)
 {
     return(xlc.table_Select("select top 9 TheLoai,sum(Tong) as [Tong] from ChiTietBanHang group by TheLoai order by sum(Tong) "));
 }

Ejemplo n.º 2

 public DataTable DoanhThuSachNhieuNhat_SelectAll(DuLieu_DoThiCot dlc)
 {
     return(xlc.table_Select("select top 9 TenSach,sum(Tong) as [Tong] from ChiTietBanHang group by TenSach order by sum(Tong) desc"));
 }

Ejemplo n.º 3

 public DataTable TheLoaiMuaNhieuNhat_SelectAll(DuLieu_DoThiCot dlc)
 {
     return(xlc.table_Select("select top 9 TheLoai,sum(Sl) as [Sl] from ChiTietBanHang group by TheLoai order by sum(Sl) desc"));
 }

Ejemplo n.º 4

 public DataTable SlSachItNhat_SelectAll(DuLieu_DoThiCot dlc)
 {
     return(xlc.table_Select("select top 9 TenSach,sum(Sl) as [Sl] from ChiTietBanHang group by TenSach order by sum(Sl) "));
 }

Ejemplo n.º 5

 public DataTable DoanhThuNam_SelectAll(DuLieu_DoThiCot dlc)
 {
     return(xlc.table_Select("select year(Ngay)as[Nam], sum(Tong)as[Tong] from ChiTietBanHang group by year(Ngay)"));
 }

Ejemplo n.º 6

 public DataTable SlBanNam_SelectAll(DuLieu_DoThiCot dlc)
 {
     return(xlc.table_Select("select year(Ngay)as[Nam], sum(Sl)as[Sl] from ChiTietBanHang group by year(Ngay)"));
 }

Ejemplo n.º 7

 public DataTable DoanhThuThang_SelectAll(DuLieu_DoThiCot dlc)
 {
     return(xlc.table_Select("select month(Ngay)as[Thang], sum(Tong)as[Tong] from ChiTietBanHang group by month(Ngay)"));
 }

Ejemplo n.º 8

 public DataTable SlBanThang_SelectAll(DuLieu_DoThiCot dlc)
 {
     return(xlc.table_Select("select month(Ngay)as[Thang], sum(Sl)as[Sl] from ChiTietBanHang group by month(Ngay)"));
 }