public OperateResult GetPagedMeberCardList(GetPagedMeberCardListViewModel viewModel)
{
//总记录数
int rowCount = 0;
//当用户什么都没有输入的时候默认查询所有的
var query = PredicateExtensions.True <MemCards>();
//根据用户输入的参数信息实现多条件查询
if (!string.IsNullOrWhiteSpace(viewModel.CardId))
{
query = query.And(e => e.MC_CardID == viewModel.CardId);
}
if (!string.IsNullOrWhiteSpace(viewModel.Name))
{
query = query.And(e => e.MC_Name.Contains(viewModel.Name));
}
if (!string.IsNullOrWhiteSpace(viewModel.Mobile))
{
query = query.And(e => e.MC_Mobile == viewModel.Mobile);
}
if (viewModel.CardLevelId > 0)
{
query = query.And(e => e.CL_ID == viewModel.CardLevelId);
}
if (viewModel.State > 0)
{
query = query.And(e => e.MC_State == viewModel.State);
}
var pageData = GetList(viewModel.page, viewModel.rows, ref rowCount, query, e => e.MC_ID, false)
.Select(e => new MeberCardListViewModel()
{
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
}).AsQueryable().ToList();
var dataGridViewModel = new DataGridViewModel()
{
total = rowCount, rows = pageData
};
return(new OperateResult(true, "", dataGridViewModel));
}
public ActionResult GetPagedMeberCardList(GetPagedMeberCardListViewModel viewModel)
{
var result = _MeberCardService.GetPagedMeberCardList(viewModel);
return(Json(result.Data));
}
