/// 查询列表信息 /// </summary> /// <param name="viewModel"></param> /// <returns></returns> public OperateResult GetMemCards(GetPagedMemberCardListViewModel viewModel) { var query = PredicateExtensions.True <MemCards>(); if (!string.IsNullOrWhiteSpace(viewModel.Name)) { query = query.And(e => e.MC_Name == viewModel.Name); } int rowCount = 0; var pageData = GetList(viewModel.page, viewModel.rows, ref rowCount, query, e => e.MC_ID, true) .Select(e => new MemberCardListViewModel { CardId = e.MC_CardID, CardLevelName = e.CardLevels.CL_LevelName, CreateTime = (DateTime)e.MC_CreateTime, Id = e.MC_ID, Mobile = e.MC_Mobile, Name = e.MC_Name, Point = (int)e.MC_Point, Sex = ((SexTypeEnum)e.MC_Sex).ToString(), State = ((CardStateTypeEnum)e.MC_State).ToString(), TotalMoney = (float)e.MC_TotalMoney, Money = (float)e.MC_Money }).ToList(); var pageViewModel = new DataGridViewModel { total = rowCount, rows = pageData }; return(new OperateResult(ResultStatus.Success, "", pageViewModel)); }
public ActionResult GetPagedMemberCardList(GetPagedMemberCardListViewModel pageModel) { var result = _MemberCardService.GetMemCards(pageModel); return(Json(result.Data)); #region 原本加载页面 //using (var db = new MemberPointModel()) //{ // var query = db.MemCards.AsQueryable(); // if (!string.IsNullOrEmpty(pageModel.Mobile)) // { // query = query.Where(e => e.MC_Mobile.Contains(pageModel.Mobile)); // } // if (!string.IsNullOrEmpty(pageModel.Name)) // { // query = query.Where(e => e.MC_Name.Contains(pageModel.Name)); // } // if (pageModel.State != 0) // { // query = query.Where(e => e.MC_Name.Contains(pageModel.Name)); // } // int rowsCount = query.Count(); // pageModel.page = pageModel.page - 1 < 1 ? 1 : pageModel.page; // var mcList = query.OrderBy(e => e.MC_ID).Skip((pageModel.page - 1) * pageModel.rows).Take(pageModel.rows) // .Select(e => new MemberCardListViewModel() // { // CardId = e.MC_CardID, // CardLevelName = e.CardLevels.CL_LevelName, // CreateTime = (DateTime)e.MC_CreateTime, // Id = e.MC_ID, // Mobile = e.MC_Mobile, // Name = e.MC_Name, // Point = (int)e.MC_Point, // Sex = ((SexTypeEnum)e.MC_Sex).ToString(), // State = ((CardStateTypeEnum)e.MC_State).ToString(), // TotalMoney = (float)e.MC_TotalMoney // }).ToList(); // var dataGrid = new DataGridViewModel { total = rowsCount, rows = mcList }; // return Json(dataGrid); //} #endregion }
public ActionResult GetMenCardsList(GetPagedMemberCardListViewModel viewModel) { var result = _MemCardsService.GetMemCards(viewModel); return(Json(result.Data)); }