/// <summary> /// 代理商表 /// wuyf 2015-9-24 /// </summary> /// <param name="searchModel"></param> /// <returns></returns> public JsonResult List(SearchYH_AgentModel searchModel) { searchModel.PagedIndex = searchModel.PagedIndex == 0 ? 0 : searchModel.PagedIndex; searchModel.PagedSize = searchModel.PagedSize == 0 ? 10 : searchModel.PagedSize; var result = _yh_AgentService.GetPagingYH_Agent(searchModel); var data = new { rows = result.Data, total = result.Data.TotalCount, }; return(Json(data, JsonRequestBehavior.AllowGet)); }
public ResultModel GetPagingYH_Agent(SearchYH_AgentModel model) { var tb = _database.Db.YH_Agent; var where = new SimpleExpression(1, 1, SimpleExpressionType.Equal); // if (model.UserID > 0) { //用户ID where = new SimpleExpression(where, tb.UserID == model.UserID, SimpleExpressionType.And); } if (model.AgentType > 0) { //用户ID where = new SimpleExpression(where, tb.AgentType == model.AgentType, SimpleExpressionType.And); } if (model.Phone != null) { where = new SimpleExpression(where, _database.Db.YH_User.Phone.Like("%" + model.Phone.Trim() + "%"), SimpleExpressionType.And); } if (!string.IsNullOrEmpty(model.Email)) { where = new SimpleExpression(where, _database.Db.YH_User.Email.Like("%" + model.Email.Trim() + "%"), SimpleExpressionType.And); } if (model.IsLock != -1) { where = new SimpleExpression(where, _database.Db.YH_User.IsLock == model.IsLock, SimpleExpressionType.And); } if (model.RegisterDateBegin != null) { where = new SimpleExpression(where, tb.CreateDT >= model.RegisterDateBegin, SimpleExpressionType.And); } if (model.RegisterDateEnd != null) { where = new SimpleExpression(where, tb.CreateDT < Convert.ToDateTime(model.RegisterDateEnd).AddDays(1), SimpleExpressionType.And); } dynamic pc; var query = tb .Query() .LeftJoin(_database.Db.YH_User, out pc) .On(_database.Db.YH_User.UserID == tb.UserID) .Select( tb.AgentID, tb.UserID, tb.AgentType, tb.InitialFee, tb.CreateBy, tb.CreateDT, tb.UpdateBy, tb.UpdateDT, pc.Phone, pc.Email, pc.IsLock, pc.Account ) .Where(where) .OrderByUserIDDescending(); var result = new ResultModel { Data = new SimpleDataPagedList <YH_AgentModel>(query, model.PagedIndex, model.PagedSize) }; return(result); }