/// <summary>
/// 修改数据。必须传入Id
/// </summary>
public BaseResult UptUser(TestTableParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, Msg.ParamError));
}
var model = new TestTable();
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 = TestTableRepository.Update(model, d => d.Id == param.Id);
//更新缓存
TestTableCache.DelUserModel(param.Id.Value);
return(new BaseResult(true));
}
/// <summary>
/// 新增数据。必须传入姓名Name，手机号MobilePhone，身份证号IDNumber
/// </summary>
public BaseResult AddUser(TestTableParam param)
{
if (string.IsNullOrWhiteSpace(param.Name) || string.IsNullOrWhiteSpace(param.MobilePhone) ||
string.IsNullOrWhiteSpace(param.IDNumber))
{
return(new BaseResult(false, null, Msg.ParamError));
}
var model = new TestTable1
{
Id = Guid.NewGuid(),
Name = param.Name,
IDNumber = param.IDNumber,
MobilePhone = param.MobilePhone,
CreateTime = DateTime.Now,
T2 = 0,
T3 = 0,
T4 = true,
T7 = 0,
T9 = 0
};
var count = TestTableRepository.Insert(model);
//设置缓存
TestTableCache.SetUserModel(model);
return(new BaseResult(count > 0, count, count > 0 ? "" : Msg.Line0));
}
/// <summary>
/// 删除数据。必须传入Id
/// </summary>
public BaseResult DelUser(TestTableParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, Msg.ParamError));
}
var count = TestTableRepository.Delete(param.Id);
//更新缓存
TestTableCache.DelUserModel(param.Id.Value);
return(new BaseResult(count > 0, count, count > 0 ? "" : Msg.Line0));
}
public BaseResult GetUserModel(TestTableParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, Msg.ParamError));
}
//取缓存
var model = TestTableCache.GetUserModel(param.Id.Value);
if (model == null)
{
//如果缓存不存在，则从数据库获取
model = TestTableRepository.First(d => d.Id == param.Id);
TestTableCache.SetUserModel(model);
}
return(new BaseResult(true, model));
}
