public async Task <TableDataModel> LoadDataAsync(ManagerRequestModel model)
{
string conditions = "where IsDelete=0 ";//未删除的
if (!model.Key.IsNullOrWhiteSpace())
{
conditions += $"and (UserName like '%@Key%' or NickName like '%@Key%' or Remark like '%@Key%' or Mobile like '%@Key%' or Email like '%@Key%')";
}
var data = await _repository.GetListPagedAsync(model.Page, model.Limit, conditions, "id desc", model);
var list = data.ToList();
var viewList = new List <ManagerListModel>();
list?.ForEach(x =>
{
var item = _mapper.Map <ManagerListModel>(x);
item.RoleName = _roleRepository.GetNameById(x.RoleId);
viewList.Add(item);
});
return(new TableDataModel
{
count = await _repository.RecordCountAsync(conditions),
data = viewList,
});
}
public async Task <string> AddOne(ManagerRequestModel managerRequestModel)
{
try
{
managerRequestModel._id = ObjectId.GenerateNewId();
managerRequestModel.Created = DateTime.UtcNow;
managerRequestModel.Modified = DateTime.UtcNow;
managerRequestModel.Uid = GenerateIdUtils.GenerateId();
await _mongoCollection.InsertOneAsync(managerRequestModel);
return(managerRequestModel.Uid);
}
catch (Exception)
{
throw;
}
}
public async Task <IActionResult> UpdateAsync(int id, ManagerRequestModel managerRequestModel)
{
try
{
return(Ok(await _services.UpdateOne(id, managerRequestModel)));
}
catch (FXSException fxse)
{
return(StatusCode(Int32.Parse(fxse.Code), new ExceptionModel {
Message = fxse.Message, Code = fxse.Code
}));
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
public async Task <IActionResult> AddOneAsync(ManagerRequestModel managerRequestModel)
{
try
{
if (ModelState.IsValid)
{
return(Ok(await _services.AddOne(managerRequestModel)));
}
throw new FXSException("Model is invalid", "401");
}
catch (FXSException fxse)
{
return(StatusCode(Int32.Parse(fxse.Code), new ExceptionModel {
Message = fxse.Message, Code = fxse.Code
}));
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
public TableDataModel LoadData(ManagerRequestModel model)
{
string conditions = "where IsDelete=0 ";
if (!model.Key.IsNullOrWhiteSpace())
{
conditions += $" and (username like '%@Key%' or NickName like '%@Key%' or Remark like '%@Key%' or Mobile like '%@Key%' or Email like '%@Key%')";
}
var list = _repository.GetListPaged(model.Page, model.Limit, conditions, " Id desc", model).ToList();
var viewList = new List <ManagerListModel>();
list.ForEach(x =>
{
var item = _mapper.Map <ManagerListModel>(x);
item.RoleName = _roleRepository.GetNameById(x.ROLEID);
viewList.Add(item);
});
return(new TableDataModel
{
count = _repository.RecordCount(conditions),
data = viewList
});
}
public async Task <object> UpdateOne(int id, ManagerRequestModel managerRequestModel)
{
try
{
var update = Builders <ManagerRequestModel> .Update.Set("created", DateTime.UtcNow);
foreach (BsonElement item in managerRequestModel.ToBsonDocument())
{
if (item.Name != "modified" && item.Name != "created" && item.Name != "_id" && item.Value.GetType() != typeof(BsonNull))
{
update = update.Set(item.Name, item.Value);
}
}
update = update.Set("modified", DateTime.UtcNow);
await _mongoCollection.UpdateOneAsync(Builders <ManagerRequestModel> .Filter.Eq("uid", id.ToString()), update);
return(string.Format("{0} update success", id));
}
catch (Exception)
{
throw;
}
}
public string LoadData([FromQuery] ManagerRequestModel model)
{
return(JsonHelper.ObjectToJSON(_service.LoadData(model)));
}
public async Task <string> LoadData([FromQuery] ManagerRequestModel model)
{
return(JsonHelper.ObjectToJSON(await _service.LoadDataAsync(model)));
}
/// <summary>
/// 加载列表数据
/// </summary>
/// <param name="requestModel"></param>
/// <returns></returns>
public IActionResult LoadData([FromQuery] ManagerRequestModel requestModel)
{
var table = new TableDataModel();
return(Json(table));
}
