/// <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);
}
