public HuoPingRukuDan UpdateSingle(int id, HuoPingRukuDanReq data) { HuoPingRukuDan model = db.HuoPingRukuDan.Find(id); SetHuoPingRukuDan(model, data); db.SaveChanges(); return(model); }
/// <summary> /// 设置model,如果不为空就设置,如果为空则和之前一样 /// </summary> /// <param name="target"></param> /// <param name="source"></param> /// <returns></returns> public HuoPingRukuDan SetHuoPingRukuDan(HuoPingRukuDan model, HuoPingRukuDanReq data) { if (!string.IsNullOrEmpty(data.RuKuDanBianHao)) { model.RuKuDanBianHao = data.RuKuDanBianHao; } if (data.HPCount != null) { model.HPCount = data.HPCount.Value; } if (data.HPZhongLei != null) { model.HPZhongLei = data.HPZhongLei.Value; } if (data.HPZongJia != null) { model.HPZongJia = data.HPZongJia.Value; } if (!string.IsNullOrEmpty(data.RuKuDanState)) { model.RuKuDanState = data.RuKuDanState; } if (data.RuKuDate != null && data.RuKuDate != DateTime.MinValue && data.RuKuDate != SqlDateTime.MinValue.Value) { model.RuKuDate = data.RuKuDate.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 (data.RuKuDanLeiXing != null) { model.RuKuDanLeiXing = data.RuKuDanLeiXing.Value; } if (data.CaiGouDanId != null) { model.CaiGouDanId = data.CaiGouDanId.Value; } return(model); }
/// <summary> /// 查询HuoPingRukuDan /// </summary> /// <param name="req"></param> /// <returns></returns> public SearchListResult <HuoPingRukuDan> SearchList(HuoPingRukuDanReq req) { var query = from source in db.HuoPingRukuDan select source; if (!string.IsNullOrEmpty(req.RuKuDanBianHao)) { query = query.Where(d => d.RuKuDanBianHao.Contains(req.RuKuDanBianHao)); } if (req.HPCount != null) { query = query.Where(d => d.HPCount == req.HPCount); } if (req.HPZhongLei != null) { query = query.Where(d => d.HPZhongLei == req.HPZhongLei); } if (req.HPZongJia != null) { query = query.Where(d => d.HPZongJia == req.HPZongJia); } if (!string.IsNullOrEmpty(req.RuKuDanState)) { query = query.Where(d => d.RuKuDanState.Contains(req.RuKuDanState)); } if (req.RuKuDateStart != DateTime.MinValue && req.RuKuDateStart != SqlDateTime.MinValue.Value) { query = query.Where(d => d.RuKuDate >= req.RuKuDateStart); } if (req.RuKuDateEnd != DateTime.MinValue && req.RuKuDateEnd != SqlDateTime.MinValue.Value) { DateTime RuKuDateTemp = req.RuKuDateEnd.AddDays(1); query = query.Where(d => d.RuKuDate < RuKuDateTemp); } 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 (req.RuKuDanLeiXing != null) { query = query.Where(d => d.RuKuDanLeiXing == req.RuKuDanLeiXing); } if (req.CaiGouDanId != null) { query = query.Where(d => d.CaiGouDanId == req.CaiGouDanId); } if (req.RuKuDanLeiXing != null) { query = query.Where(d => d.RuKuDanLeiXing == req.RuKuDanLeiXing); } if (string.IsNullOrEmpty(req.sidx)) { req.sidx = "Id"; req.sord = "desc"; } SearchListResult <HuoPingRukuDan> retListResult = query.ToSearchList(req); return(retListResult); }