/// <summary> /// 获取数据。 /// </summary> public BaseResult GetUser(TestTableParam param) { var where = new Where<TableMysql>(); #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 = new TableMysqlRepository().Count(where);//.SetCacheTimeOut(10) } #endregion var list = new TableMysqlRepository().Query(where, d => d.CreateTime, EnumService.OrderBy.Desc, null, param.pageSize, param.pageIndex); return new BaseResult(true, list, "", dateCount); }
/// <summary> /// 获取数据 /// </summary> public JsonResult GetUser(TestTableParam param) { var bs = new TableMySqlLogic().GetUser(param); #region 以下逻辑可以重写Json()在内部实现 var data = bs.Data as List<TableMysql>; var result = Common.Common.Map<TableMysql, TableMysql_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, "参数错误!"); } var count = new TableMysqlRepository().Delete(param.Id); //更新缓存 new TableMysqlCache().DelUserModel(param.Id.Value); 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, "参数错误!"); } var model = new TableMysql { Id = Guid.NewGuid(), Name = param.Name, IDNumber = param.IDNumber, MobilePhone = param.MobilePhone, CreateTime = DateTime.Now }; var count = new TableMysqlRepository().Insert(model); //设置缓存 new TableMysqlCache().SetUserModel(model.Id, model); return new BaseResult(count > 0, count, count > 0 ? "" : "数据库受影响行数为0!"); }
/// <summary> /// 删除数据 /// </summary> public JsonResult DelUser(TestTableParam param) { var result = new TableMySqlLogic().DelUser(param); return Json(result); }
/// <summary> /// 获取数据 /// </summary> public JsonResult GetUser(TestTableParam param) { var result = new TableMySqlLogic().GetUser(param); var test = Json(result); return test; }
/// <summary> /// 修改数据。必须传入Id /// </summary> public BaseResult UptUser(TestTableParam param) { if (param.Id == null) { return new BaseResult(false, null, "参数错误!"); } //取缓存 var model = new TableMysqlCache().GetUserModel(param.Id.Value); if (model == null) { //如果缓存不存在,则从数据库获取 model = new TableMysqlRepository().First(d => d.Id == param.Id); } 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 = new TableMysqlRepository().Update(model); //更新缓存 new TableMysqlCache().DelUserModel(param.Id.Value); return new BaseResult(true); }