/// 查询列表信息
/// </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));
}
