public ChildCareDetail UpdateSingle(int id, ChildCareDetailReq data)
{
ChildCareDetail model = db.ChildCareDetail.Find(id);
SetChildCareDetail(model, data);
db.SaveChanges();
return(model);
}
/// <summary>
/// 设置model，如果不为空就设置,如果为空则和之前一样
/// </summary>
/// <param name="target"></param>
/// <param name="source"></param>
/// <returns></returns>
public ChildCareDetail SetChildCareDetail(ChildCareDetail model, ChildCareDetailReq data)
{
if (!string.IsNullOrEmpty(data.Time))
{
model.Time = data.Time;
}
if (data.SelfWeiCount != null)
{
model.SelfWeiCount = data.SelfWeiCount.Value;
}
if (data.MomMilk != null)
{
model.MomMilk = data.MomMilk.Value;
}
if (data.FormulaMilk != null)
{
model.FormulaMilk = data.FormulaMilk.Value;
}
if (!string.IsNullOrEmpty(data.WeiYao))
{
model.WeiYao = data.WeiYao;
}
if (data.WeiShui != null)
{
model.WeiShui = data.WeiShui.Value;
}
if (!string.IsNullOrEmpty(data.DaBian))
{
model.DaBian = data.DaBian;
}
if (!string.IsNullOrEmpty(data.XiaoBian))
{
model.XiaoBian = data.XiaoBian;
}
if (data.SignUserId != null)
{
model.SignUserId = data.SignUserId.Value;
}
if (!string.IsNullOrEmpty(data.SignUserName))
{
model.SignUserName = data.SignUserName;
}
if (!string.IsNullOrEmpty(data.Mark))
{
model.Mark = data.Mark;
}
if (data.OptId != null)
{
model.OptId = data.OptId.Value;
}
if (!string.IsNullOrEmpty(data.OptName))
{
model.OptName = data.OptName;
}
if (data.ServerDate != null && data.ServerDate != DateTime.MinValue && data.ServerDate != SqlDateTime.MinValue.Value)
{
model.ServerDate = data.ServerDate.Value;
}
if (data.projectid != null)
{
model.projectid = data.projectid.Value;
}
if (data.KeHuid != null)
{
model.KeHuid = data.KeHuid.Value;
}
if (!string.IsNullOrEmpty(data.KeHuName))
{
model.KeHuName = data.KeHuName;
}
if (!string.IsNullOrEmpty(data.ChildDesc))
{
model.ChildDesc = data.ChildDesc;
}
if (data.ChildCareId != null)
{
model.ChildCareId = data.ChildCareId.Value;
}
return(model);
}
/// <summary>
/// 查询ChildCareDetail
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <ChildCareDetail> SearchList(ChildCareDetailReq req)
{
var query = from source in db.ChildCareDetail select source;
if (!string.IsNullOrEmpty(req.Time))
{
query = query.Where(d => d.Time.Contains(req.Time));
}
if (req.SelfWeiCount != null)
{
query = query.Where(d => d.SelfWeiCount == req.SelfWeiCount);
}
if (req.MomMilk != null)
{
query = query.Where(d => d.MomMilk == req.MomMilk);
}
if (req.FormulaMilk != null)
{
query = query.Where(d => d.FormulaMilk == req.FormulaMilk);
}
if (!string.IsNullOrEmpty(req.WeiYao))
{
query = query.Where(d => d.WeiYao.Contains(req.WeiYao));
}
if (req.WeiShui != null)
{
query = query.Where(d => d.WeiShui == req.WeiShui);
}
if (!string.IsNullOrEmpty(req.DaBian))
{
query = query.Where(d => d.DaBian.Contains(req.DaBian));
}
if (!string.IsNullOrEmpty(req.XiaoBian))
{
query = query.Where(d => d.XiaoBian.Contains(req.XiaoBian));
}
if (req.SignUserId != null)
{
query = query.Where(d => d.SignUserId == req.SignUserId);
}
if (!string.IsNullOrEmpty(req.SignUserName))
{
query = query.Where(d => d.SignUserName.Contains(req.SignUserName));
}
if (!string.IsNullOrEmpty(req.Mark))
{
query = query.Where(d => d.Mark.Contains(req.Mark));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.ServerDateStart != DateTime.MinValue && req.ServerDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ServerDate >= req.ServerDateStart);
}
if (req.ServerDateEnd != DateTime.MinValue && req.ServerDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ServerDate <= req.ServerDateEnd);
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectid == req.projectid);
}
if (req.KeHuid != null)
{
query = query.Where(d => d.KeHuid == req.KeHuid);
}
if (!string.IsNullOrEmpty(req.KeHuName))
{
query = query.Where(d => d.KeHuName.Contains(req.KeHuName));
}
if (!string.IsNullOrEmpty(req.ChildDesc))
{
query = query.Where(d => d.ChildDesc.Contains(req.ChildDesc));
}
if (req.ChildCareId != null)
{
query = query.Where(d => d.ChildCareId == req.ChildCareId);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <ChildCareDetail> retListResult = query.ToSearchList(req);
return(retListResult);
}