public static DataSet SPBanChayNhatTheoThang(int thang, int year)
{
SqlParameter[] sqlP = new SqlParameter[2];
sqlP[0] = new SqlParameter("@Thang", thang);
sqlP[1] = new SqlParameter("@Year", year);
return(GenericDAL.execRPQuery("sp_SPBanChayNhatTheoThang", sqlP, Conn));
}
// REPORT QUES
public static DataSet SPBanChayNhat(int truoc, int sau)
{
SqlParameter[] sqlP = new SqlParameter[2];
sqlP[0] = new SqlParameter("@Truoc", truoc);
sqlP[1] = new SqlParameter("@Sau", sau);
return(GenericDAL.execRPQuery("sp_SPBanChayNhat", sqlP, Conn));
}
public static DataSet KhachMuaItHangNhat(int truoc, int sau, int year)
{
SqlParameter[] sqlP = new SqlParameter[3];
sqlP[0] = new SqlParameter("@ThangTruoc", truoc);
sqlP[1] = new SqlParameter("@ThangSau", sau);
sqlP[2] = new SqlParameter("@Nam", year);
return(GenericDAL.execRPQuery("sp_KhachHang_MuaItHangNhat", sqlP, Conn));
}
public static DataSet HDBTheoNV(string maNV)
{
SqlParameter[] sqlP = new SqlParameter[1];
sqlP[0] = new SqlParameter("@MaNV", maNV);
return(GenericDAL.execRPQuery("sp_rpBillHDB", sqlP, Conn));
}