/// <summary>
/// 获取数据。此数据会持续增长，所以不建议一次性缓存。建议单个Model实体缓存。
/// </summary>
public BaseResult GetUser(TStudentParam param)
{
var where = new Where <TStudent>();
#region 模糊搜索条件
if (!string.IsNullOrWhiteSpace(param.SearchName))
{
where.And(d => !d.Name.Equals(param.SearchName));
}
if (!string.IsNullOrWhiteSpace(param.SearchIDNumber))
{
where.And(d => d.IDNumber.Like(param.SearchIDNumber));
}
if (!string.IsNullOrWhiteSpace(param.SearchMobilePhone))
{
where.And(d => d.MobilePhone.Like(param.SearchMobilePhone));
}
#endregion
#region 是否分页
var dateCount = 0;
if (param._PageIndex != null && param._PageSize != null)
{
//取总数，以计算共多少页。自行考虑将总数缓存。
dateCount = TStudentRepository.Count(where);//.SetCacheTimeOut(10)
}
#endregion
var list = TStudentRepository.Query(where, d => d.CreateTime, "desc", null, param._PageSize, param._PageIndex);
return(new BaseResult(true, list, "", dateCount));
}
/// <summary>
/// 修改数据。必须传入Id
/// </summary>
public BaseResult UptUser(TStudentParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, Msg.ParamError));
}
var model = new TStudent();
if (param.Name != null)
{
model.Name = param.Name;
}
if (param.IDNumber != null)
{
model.IDNumber = param.IDNumber;
}
if (param.MobilePhone != null)
{
model.MobilePhone = param.MobilePhone;
}
var count = TStudentRepository.Update(model, d => d.Id == param.Id);
//更新缓存
TStudentCache.DelUserModel(param.Id.Value);
return(new BaseResult(true));
}
/// <summary>
/// 删除数据。必须传入Id
/// </summary>
public BaseResult DelUser(TStudentParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, Msg.ParamError));
}
var count = TStudentRepository.Delete(param.Id);
//更新缓存
TStudentCache.DelUserModel(param.Id.Value);
return(new BaseResult(count > 0, count, count > 0 ? "" : Msg.Line0));
}
public BaseResult GetUserModel(TStudentParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, Msg.ParamError));
}
//取缓存
var model = TStudentCache.GetUserModel(param.Id.Value);
if (model == null)
{
//如果缓存不存在，则从数据库获取
model = TStudentRepository.First(d => d.Id == param.Id);
TStudentCache.SetUserModel(model);
}
return(new BaseResult(true, model));
}
/// <summary>
/// 新增数据。必须传入姓名Name，手机号MobilePhone，身份证号IDNumber
/// </summary>
public BaseResult AddUser(TStudentParam param)
{
if (string.IsNullOrWhiteSpace(param.Name) || string.IsNullOrWhiteSpace(param.MobilePhone) ||
string.IsNullOrWhiteSpace(param.IDNumber))
{
return(new BaseResult(false, null, Msg.ParamError));
}
var model = new TStudent
{
Id = Guid.NewGuid(),
Name = param.Name,
IDNumber = param.IDNumber,
MobilePhone = param.MobilePhone,
CreateTime = DateTime.Now
};
var count = TStudentRepository.Insert(model);
//设置缓存
TStudentCache.SetUserModel(model);
return(new BaseResult(count > 0, count, count > 0 ? "" : Msg.Line0));
}
