public Infrastructure.DataTables <Models.Reviewss> MicroMallQuery(Requests.ReviewRequest request)
{
SqlParameter[] param =
{
new SqlParameter("@CommodityId", request.CommodityId),
new SqlParameter("@State", request.State),
new SqlParameter("@UserId", request.UserId),
new SqlParameter("@pageIndex", request.PageIndex),
new SqlParameter("@pageSize", request.PageSize),
};
StoreProcedure sp = new StoreProcedure("P_getMicroMallReviews", param);
return(_databaseInstance.GetTables <Reviewss>(sp));
}
public DataTables <Reviewss> Query(Requests.ReviewRequest request)
{
SqlParameter[] param =
{
//new SqlParameter("@CommodityId",request.CommodityId),
new SqlParameter("@UserName", request.UserName),
new SqlParameter("@CommodityNo", request.CommodityNo),
new SqlParameter("@State", request.State),
//new SqlParameter("@UserId",request.UserId),
new SqlParameter("@pageIndex", request.PageIndex),
new SqlParameter("@pageSize", request.PageSize),
};
StoreProcedure sp = new StoreProcedure("P_getReviews", param);
return(_databaseInstance.GetTables <Reviewss>(sp));
}
