public HuoPingRuku UpdateSingle(int id, HuoPingRukuReq data)
{
HuoPingRuku model = db.HuoPingRuku.Find(id);
SetHuoPingRuku(model, data);
db.SaveChanges();
return(model);
}
/// <summary>
/// 设置model，如果不为空就设置,如果为空则和之前一样
/// </summary>
/// <param name="target"></param>
/// <param name="source"></param>
/// <returns></returns>
public HuoPingRuku SetHuoPingRuku(HuoPingRuku model, HuoPingRukuReq data)
{
if (data.HPId != null)
{
model.HPId = data.HPId.Value;
}
if (!string.IsNullOrEmpty(data.HPName))
{
model.HPName = data.HPName;
}
if (data.SinglePrice != null)
{
model.SinglePrice = data.SinglePrice.Value;
}
if (!string.IsNullOrEmpty(data.Supplier))
{
model.Supplier = data.Supplier;
}
if (!string.IsNullOrEmpty(data.ChangjiaXinghao))
{
model.ChangjiaXinghao = data.ChangjiaXinghao;
}
if (!string.IsNullOrEmpty(data.RuKuDanBianHao))
{
model.RuKuDanBianHao = data.RuKuDanBianHao;
}
if (data.rukuShuLiang != null)
{
model.rukuShuLiang = data.rukuShuLiang.Value;
}
if (!string.IsNullOrEmpty(data.rukuRen))
{
model.rukuRen = data.rukuRen;
}
if (data.rukuDate != null && data.rukuDate != DateTime.MinValue && data.rukuDate != SqlDateTime.MinValue.Value)
{
model.rukuDate = data.rukuDate.Value;
}
if (!string.IsNullOrEmpty(data.rukuState))
{
model.rukuState = data.rukuState;
}
if (data.caigouId != null)
{
model.caigouId = data.caigouId.Value;
}
if (!string.IsNullOrEmpty(data.CaiGouDanBianHao))
{
model.CaiGouDanBianHao = data.CaiGouDanBianHao;
}
if (data.rukuJinEr != null)
{
model.rukuJinEr = data.rukuJinEr.Value;
}
return(model);
}
/// <summary>
/// 查询HuoPingRuku
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <HuoPingRuku> SearchList(HuoPingRukuReq req)
{
var query = from source in db.HuoPingRuku select source;
if (req.HPId != null)
{
query = query.Where(d => d.HPId == req.HPId);
}
if (!string.IsNullOrEmpty(req.HPName))
{
query = query.Where(d => d.HPName.Contains(req.HPName));
}
if (req.SinglePrice != null)
{
query = query.Where(d => d.SinglePrice == req.SinglePrice);
}
if (!string.IsNullOrEmpty(req.Supplier))
{
query = query.Where(d => d.Supplier.Contains(req.Supplier));
}
if (!string.IsNullOrEmpty(req.ChangjiaXinghao))
{
query = query.Where(d => d.ChangjiaXinghao.Contains(req.ChangjiaXinghao));
}
if (!string.IsNullOrEmpty(req.RuKuDanBianHao))
{
query = query.Where(d => d.RuKuDanBianHao.Contains(req.RuKuDanBianHao));
}
if (req.rukuShuLiang != null)
{
query = query.Where(d => d.rukuShuLiang == req.rukuShuLiang);
}
if (!string.IsNullOrEmpty(req.rukuRen))
{
query = query.Where(d => d.rukuRen.Contains(req.rukuRen));
}
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.rukuState))
{
query = query.Where(d => d.rukuState.Contains(req.rukuState));
}
if (req.caigouId != null)
{
query = query.Where(d => d.caigouId == req.caigouId);
}
if (!string.IsNullOrEmpty(req.CaiGouDanBianHao))
{
query = query.Where(d => d.CaiGouDanBianHao.Contains(req.CaiGouDanBianHao));
}
if (req.rukuJinEr != null)
{
query = query.Where(d => d.rukuJinEr == req.rukuJinEr);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <HuoPingRuku> retListResult = query.ToSearchList(req);
return(retListResult);
}
