public DataSet SearchGroup(SearchGroupProductRequest model, ref int pTotal) { try { var spParameter = new SqlParameter[5]; #region Set param var parameter = new SqlParameter("@P_ORDER_BY", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.OrderBy }; spParameter[0] = parameter; parameter = new SqlParameter("@P_ORDER_TYPE", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.OrderByType }; spParameter[1] = parameter; parameter = new SqlParameter("@P_START", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.Start }; spParameter[2] = parameter; parameter = new SqlParameter("@P_END", SqlDbType.VarChar) { Direction = ParameterDirection.Input, Value = model.End }; spParameter[3] = parameter; parameter = new SqlParameter("@P_TOTAL", SqlDbType.Int) { Direction = ParameterDirection.Output, Value = -1 }; spParameter[4] = parameter; #endregion var ds = SqlHelper.ExecuteDataset(ConfigInfo.ConnectString, CommandType.StoredProcedure, "PROC_GROUP_PRO_SEARCH", spParameter); pTotal = Convert.ToInt32(spParameter[4].Value); return(ds); } catch (Exception ex) { Logger.Log.Error(ex.ToString()); return(new DataSet()); } }
public ActionResult GroupList() { if (DataMemory.CurrentUser == null) { return(RedirectToAction("Logout", "Admin")); } var request = new SearchGroupProductRequest { CurrentPage = 1, Start = 1, End = ConfigInfo.RecordOnPage, OrderBy = "GroupName", OrderByType = "Asc" }; return(View(SearchGroupProduct(request))); }
private ListGroupProducts SearchGroupProduct(SearchGroupProductRequest request) { var total = 0; var ds = _productDa.SearchGroup(request, ref total); var lstGroupProduct = CBO.Fill2ListFromDataSet <GroupProducts>(ds, typeof(GroupProducts)); decimal totalPage = Math.Ceiling(((decimal)total / ConfigInfo.RecordOnPage)); var paging = HtmlControllHelpers.WritePaging(totalPage, request.CurrentPage, total, ConfigInfo.RecordOnPage, "nhóm sản phẩm"); var listGroupProducts = new ListGroupProducts { Start = request.Start, Collection = lstGroupProduct, Paging = paging, TotalRecord = total, TotalPage = totalPage, CurrentPage = request.CurrentPage }; return(listGroupProducts); }
public ActionResult SearchGroup(SearchGroupProductRequest request) { return(PartialView("~/Areas/Admin/Views/Product/_listGroupProduct.cshtml", SearchGroupProduct(request))); }