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);
}