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)); }