public KeHuJieDianClassModel UpdateSingle(int id, KeHuJieDianClassModelReq data) { KeHuJieDianClassModel model = db.KeHuJieDianClassModel.Find(id); SetKeHuJieDianClassModel(model, data); db.SaveChanges(); return(model); }
/// <summary> /// 查询KeHuJieDianClassModel /// </summary> /// <param name="req"></param> /// <returns></returns> public SearchListResult <KeHuJieDianClassModel> SearchList(KeHuJieDianClassModelReq req) { var query = from source in db.KeHuJieDianClassModel select source; if (!string.IsNullOrEmpty(req.JdClassName)) { query = query.Where(d => d.JdClassName.Contains(req.JdClassName)); } if (req.JdClassPaiXu != null) { query = query.Where(d => d.JdClassPaiXu == req.JdClassPaiXu); } if (req.JdClassStateID != null) { query = query.Where(d => d.JdClassStateID == req.JdClassStateID); } if (!string.IsNullOrEmpty(req.optName)) { query = query.Where(d => d.optName.Contains(req.optName)); } if (req.optDateTimeStart != DateTime.MinValue && req.optDateTimeStart != SqlDateTime.MinValue.Value) { query = query.Where(d => d.optDateTime >= req.optDateTimeStart); } if (req.optDateTimeEnd != DateTime.MinValue && req.optDateTimeEnd != SqlDateTime.MinValue.Value) { DateTime optDateTimeTemp = req.optDateTimeEnd.AddDays(1); query = query.Where(d => d.optDateTime < optDateTimeTemp); } if (!string.IsNullOrEmpty(req.JdSpecialState)) { query = query.Where(d => d.JdSpecialState.Contains(req.JdSpecialState)); } if (string.IsNullOrEmpty(req.sidx)) { req.sidx = "id"; req.sord = "desc"; } SearchListResult <KeHuJieDianClassModel> retListResult = query.ToSearchList(req); return(retListResult); }
/// <summary> /// 设置model,如果不为空就设置,如果为空则和之前一样 /// </summary> /// <param name="target"></param> /// <param name="source"></param> /// <returns></returns> public KeHuJieDianClassModel SetKeHuJieDianClassModel(KeHuJieDianClassModel model, KeHuJieDianClassModelReq data) { if (!string.IsNullOrEmpty(data.JdClassName)) { model.JdClassName = data.JdClassName; } if (data.JdClassPaiXu != null) { model.JdClassPaiXu = data.JdClassPaiXu.Value; } if (data.JdClassStateID != null) { model.JdClassStateID = data.JdClassStateID.Value; } if (!string.IsNullOrEmpty(data.optName)) { model.optName = data.optName; } if (data.optDateTime != null && data.optDateTime != DateTime.MinValue && data.optDateTime != SqlDateTime.MinValue.Value) { model.optDateTime = data.optDateTime.Value; } if (!string.IsNullOrEmpty(data.JdSpecialState)) { model.JdSpecialState = data.JdSpecialState; } return(model); }