/// <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>
/// 获取数据
/// </summary>
public JsonResult GetUser(TestTableParam param)
{
var result = new TestTableLogic().GetUser(param);
var test = Json(result);
return(test);
}
/// <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>
/// 获取数据。此数据会持续增长，所以不建议一次性缓存。建议单个Model实体缓存。
/// </summary>
public BaseResult GetUser(TestTableParam param)
{
var where = new Where <TestTable>();
#region 模糊搜索条件
if (!string.IsNullOrWhiteSpace(param.SearchName))
{
where.And(d => d.Name.Like(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 = TestTableRepository.Count(where);//.SetCacheTimeOut(10)
}
#endregion
var list = TestTableRepository.Query(where, d => d.CreateTime, "desc", null, param._PageSize, param._PageIndex);
return(new BaseResult(true, list, "", dateCount));
}
/// <summary>
/// 获取数据。
/// </summary>
public BaseResult GetUser(TestTableParam param)
{
var where = new Where <TestTable>();
#region 模糊搜索条件
if (!string.IsNullOrWhiteSpace(param.SearchName))
{
where.And(d => d.Name.Like(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
var fs = DB.MySql.From <TestTable>()
.Where(where)
//.OrderByDescending(TableMysql._.CreateTime, TableMysql._.Id)
.OrderByDescending(d => new { d.CreateTime, d.Id });
#region 是否分页
var dateCount = 0;
if (param._PageIndex != null && param._PageSize != null)
{
//取总数，以计算共多少页。自行考虑将总数缓存。
dateCount = fs.Count();//.SetCacheTimeOut(10)
fs.Page(param._PageSize.Value, param._PageIndex.Value);
}
#endregion
var list = fs.ToList();
return(new BaseResult(true, list, "", dateCount));
}
/// <summary>
/// 获取数据。此数据会持续增长，所以不建议一次性缓存。建议单个Model实体缓存。
/// </summary>
public BaseResult GetUser(TestTableParam param)
{
var where = new Where<TestTable>();
#region 模糊搜索条件
if (!string.IsNullOrWhiteSpace(param.SearchName))
{
where.And(d => d.Name.Like(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 = TestTableRepository.Count(where);//.SetCacheTimeOut(10)
}
#endregion
var list = TestTableRepository.Query(where, d => d.CreateTime, "desc", null, param._PageSize, param._PageIndex);
return new BaseResult(true, list, "", dateCount);
}
/// <summary>
/// 删除数据。必须传入Id
/// </summary>
public BaseResult DelUser(TestTableParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, "参数错误！"));
}
var count = Db.MySql.Delete <TestTable>(d => d.Id == param.Id);
return(new BaseResult(count > 0, count, count > 0 ? "" : "数据库受影响行数为0！"));
}
/// <summary>
/// 删除数据。必须传入Id
/// </summary>
public BaseResult DelUser(TestTableParam param)
{
if (param.Id == null)
{
return new BaseResult(false, null, Msg.ParamError);
}
var count = TableMysqlRepository.Delete(param.Id);
//更新缓存
TableMysqlCache.DelUserModel(param.Id.Value);
return new BaseResult(count > 0, count, count > 0 ? "" : Msg.Line0);
}
/// <summary>
/// 获取数据
/// </summary>
public JsonResult GetUser(TestTableParam param)
{
var bs = new TestTableLogic().GetUser(param);
#region 以下逻辑可以重写Json()在内部实现
var data = bs.Data as List<TestTable>;
//Map目的是过滤前端不需要的字段，如一张表有100个字段，但是前端grid只需要显示10个字段，那么就有90个字段前端其实是不需要的，所以需要在这里过滤掉那90个字段，即在TableMysql_Page1设置前端需要的字段。
var result = Common.Common.Map<TestTable, TestTable_Page1>(data);
bs.Data = result;
//var test = Json(result);
#endregion
return Json(bs);
}
/// <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));
}
/// <summary>
/// 获取数据
/// </summary>
public JsonResult GetUser(TestTableParam param)
{
var bs = new TestTableLogic().GetUser(param);
#region 以下逻辑可以重写Json()在内部实现
var data = bs.Data as List <TestTable1>;
//Map目的是过滤前端不需要的字段，如一张表有100个字段，但是前端grid只需要显示10个字段，那么就有90个字段前端其实是不需要的，所以需要在这里过滤掉那90个字段，即在TableMysql_Page1设置前端需要的字段。
var result = Common.Common.Map <TestTable1, TestTable_Page1>(data);
bs.Data = result;
//var test = Json(result);
#endregion
return(Json(bs));
}
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);
}
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));
}
/// <summary>
/// 修改数据。必须传入Id
/// </summary>
public BaseResult UptUser(TestTableParam param)
{
if (param.Id == null)
{
return(new BaseResult(false, null, "参数错误！"));
}
var model = Db.MySql.From <TestTable>().Where(d => d.Id == param.Id).First();
if (model == null)
{
return(new BaseResult(false, null, "不存在要修改的数据！"));
}
model.Name = param.Name ?? model.Name;
model.IDNumber = param.IDNumber ?? model.IDNumber;
model.MobilePhone = param.MobilePhone ?? model.MobilePhone;
var count = Db.MySql.Update <TestTable>(model);
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, "参数错误！"));
}
var model = new TestTable
{
Id = Guid.NewGuid(),
Name = param.Name,
IDNumber = param.IDNumber,
MobilePhone = param.MobilePhone,
CreateTime = DateTime.Now
};
var count = DB.MySql.Insert <TestTable>(model);
return(new BaseResult(count > 0, count, count > 0 ? "" : "数据库受影响行数为0！"));
}
/// <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 TestTable
{
Id = Guid.NewGuid(),
Name = param.Name,
IDNumber = param.IDNumber,
MobilePhone = param.MobilePhone,
CreateTime = DateTime.Now
};
var count = TestTableRepository.Insert(model);
//设置缓存
TestTableCache.SetUserModel(model);
return new BaseResult(count > 0, count, count > 0 ? "" : Msg.Line0);
}
/// <summary>
/// 获取数据。
/// </summary>
public BaseResult GetUser(TestTableParam param)
{
var where = new Where <TestTable>();
#region 模糊搜索条件
if (!string.IsNullOrWhiteSpace(param.SearchName))
{
where.And(d => d.Name.Like(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
var fs = Db.MySql.From <TestTable>()
.Where(where)
.OrderByDescending(d => new { d.CreateTime, d.Id });
#region 是否分页
var dateCount = 0;
if (param._PageIndex != null && param._PageSize != null)
{
//取总数，以计算共多少页。
dateCount = fs.Count();
fs.Page(param._PageSize.Value, param._PageIndex.Value);
}
#endregion
var list = fs.ToList();
#region 测试自连接
var ll = Db.MySql.From <TestTable>()
.LeftJoin <TestTable>((a, b) => a.Id == b.Id)
.ToList();
#endregion
return(new BaseResult(true, list, "", dateCount));
}
/// <summary>
/// 获取数据。此数据会持续增长，所以不建议一次性缓存。建议单个Model实体缓存。
/// </summary>
public BaseResult GetUser(TestTableParam param)
{
var where = new Where <TestTable1>();
#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 = TestTableRepository.Count(where);//.SetCacheTimeOut(10)
}
#endregion
var list = TestTableRepository.Query(where, d => d.CreateTime, "desc", null, param._PageSize, param._PageIndex);
//list[0].Id = Guid.NewGuid();
//list[0].AttachAll();
//var a = list[0].GetModifyFields();
//var b = list[1].GetModifyFields();
//list[0].Id = Guid.NewGuid();
//var aaaa = TestTableRepository.Insert(list[0]);
#region 测试事务
var trans = Db.Context.BeginTransaction();
var mmmm = new TestTable1();
try
{
trans.Delete(new List <TestTable1>());
Db.Context.Delete(trans, new List <TestTable1>());
trans.Update(mmmm);
throw new Exception("xxxxxxxx");
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
finally
{
trans.Close();
}
#endregion
//var aaaaaa = GetAaa();
Aaa(new List <TestTable1>());
Aaa(trans, new List <TestTable1>());
//Aaa(aaaaaa);
return(new BaseResult(true, list, "", dateCount));
}
/// <summary>
/// 删除数据
/// </summary>
public JsonResult DelUser(TestTableParam param)
{
var result = new TestTableLogic().DelUser(param);
return(Json(result));
}
/// <summary>
/// 修改数据。必须传入Id
/// </summary>
public BaseResult UptUser(TestTableParam param)
{
if (param.Id == null)
{
return new BaseResult(false, null, Msg.ParamError);
}
//取缓存
var model = TableMysqlCache.GetUserModel(param.Id.Value);
if (model == null)
{
//如果缓存不存在，则从数据库获取
model = TableMysqlRepository.First(d => d.Id == param.Id);
}
if (model == null)
{
return new BaseResult(false, null, Msg.NoExist);
}
model.Name = param.Name ?? model.Name;
model.IDNumber = param.IDNumber ?? model.IDNumber;
model.MobilePhone = param.MobilePhone ?? model.MobilePhone;
var count = TableMysqlRepository.Update(model);
//更新缓存
TableMysqlCache.DelUserModel(param.Id.Value);
return new BaseResult(true);
}
/// <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>
/// 删除数据
/// </summary>
public JsonResult DelUser(TestTableParam param)
{
var result = new TestTableLogic().DelUser(param);
return Json(result);
}
