public guDingZiChanMX UpdateSingle(int id, guDingZiChanMXReq data)
{
guDingZiChanMX model = db.guDingZiChanMX.Find(id);
SetguDingZiChanMX(model, data);
db.SaveChanges();
return(model);
}
/// <summary>
/// 设置model，如果不为空就设置,如果为空则和之前一样
/// </summary>
/// <param name="target"></param>
/// <param name="source"></param>
/// <returns></returns>
public guDingZiChanMX SetguDingZiChanMX(guDingZiChanMX model, guDingZiChanMXReq data)
{
if (data.GuDingId != null)
{
model.GuDingId = data.GuDingId.Value;
}
if (!string.IsNullOrEmpty(data.zichanNum))
{
model.zichanNum = data.zichanNum;
}
if (!string.IsNullOrEmpty(data.zichanName))
{
model.zichanName = data.zichanName;
}
if (!string.IsNullOrEmpty(data.zichanPinPai))
{
model.zichanPinPai = data.zichanPinPai;
}
if (!string.IsNullOrEmpty(data.zichanChangJia))
{
model.zichanChangJia = data.zichanChangJia;
}
if (!string.IsNullOrEmpty(data.changjiaNum))
{
model.changjiaNum = data.changjiaNum;
}
if (data.zichanShulia != null)
{
model.zichanShulia = data.zichanShulia.Value;
}
if (data.zichanSingle != null)
{
model.zichanSingle = data.zichanSingle.Value;
}
if (data.zichanJi != null)
{
model.zichanJi = data.zichanJi.Value;
}
if (!string.IsNullOrEmpty(data.zichanDiDian))
{
model.zichanDiDian = data.zichanDiDian;
}
if (!string.IsNullOrEmpty(data.zichanUserName))
{
model.zichanUserName = data.zichanUserName;
}
if (data.zichanUserId != null)
{
model.zichanUserId = data.zichanUserId.Value;
}
if (!string.IsNullOrEmpty(data.zichanCaiGouName))
{
model.zichanCaiGouName = data.zichanCaiGouName;
}
if (data.zichanCaiGouId != null)
{
model.zichanCaiGouId = data.zichanCaiGouId.Value;
}
if (data.zichanGouRuDate != null && data.zichanGouRuDate != DateTime.MinValue && data.zichanGouRuDate != SqlDateTime.MinValue.Value)
{
model.zichanGouRuDate = data.zichanGouRuDate.Value;
}
if (!string.IsNullOrEmpty(data.zichanBeiZhu))
{
model.zichanBeiZhu = data.zichanBeiZhu;
}
if (!string.IsNullOrEmpty(data.zichanBuChong))
{
model.zichanBuChong = data.zichanBuChong;
}
if (!string.IsNullOrEmpty(data.optName))
{
model.optName = data.optName;
}
if (data.optId != null)
{
model.optId = data.optId.Value;
}
if (data.createDateTime != null && data.createDateTime != DateTime.MinValue && data.createDateTime != SqlDateTime.MinValue.Value)
{
model.createDateTime = data.createDateTime.Value;
}
if (!string.IsNullOrEmpty(data.state))
{
model.state = data.state;
}
return(model);
}
public SearchListResult <guDingZiChanMXBig> SearchListBig(guDingZiChanMXReq req)
{
var query = from mx in db.guDingZiChanMX
join zc in db.guDingZiChan on mx.GuDingId equals zc.id orderby mx.id descending
select new guDingZiChanMXBig {
guDingZiChanMX = mx, guDingZiChan = zc
};
if (req.GuDingId != null)
{
query = query.Where(d => d.guDingZiChanMX.GuDingId == req.GuDingId);
}
if (!string.IsNullOrEmpty(req.zichanNum))
{
query = query.Where(d => d.guDingZiChanMX.zichanNum.Contains(req.zichanNum));
}
if (!string.IsNullOrEmpty(req.zichanName))
{
query = query.Where(d => d.guDingZiChanMX.zichanName.Contains(req.zichanName));
}
if (!string.IsNullOrEmpty(req.zichanPinPai))
{
query = query.Where(d => d.guDingZiChanMX.zichanPinPai.Contains(req.zichanPinPai));
}
if (!string.IsNullOrEmpty(req.zichanChangJia))
{
query = query.Where(d => d.guDingZiChanMX.zichanChangJia.Contains(req.zichanChangJia));
}
if (!string.IsNullOrEmpty(req.changjiaNum))
{
query = query.Where(d => d.guDingZiChanMX.changjiaNum.Contains(req.changjiaNum));
}
if (req.zichanShulia != null)
{
query = query.Where(d => d.guDingZiChanMX.zichanShulia == req.zichanShulia);
}
if (req.zichanSingle != null)
{
query = query.Where(d => d.guDingZiChanMX.zichanSingle == req.zichanSingle);
}
if (req.zichanJi != null)
{
query = query.Where(d => d.guDingZiChanMX.zichanJi == req.zichanJi);
}
if (!string.IsNullOrEmpty(req.zichanDiDian))
{
query = query.Where(d => d.guDingZiChanMX.zichanDiDian.Contains(req.zichanDiDian));
}
if (!string.IsNullOrEmpty(req.zichanUserName))
{
query = query.Where(d => d.guDingZiChanMX.zichanUserName.Contains(req.zichanUserName));
}
if (req.zichanUserId != null)
{
query = query.Where(d => d.guDingZiChanMX.zichanUserId == req.zichanUserId);
}
if (!string.IsNullOrEmpty(req.zichanCaiGouName))
{
query = query.Where(d => d.guDingZiChanMX.zichanCaiGouName.Contains(req.zichanCaiGouName));
}
if (req.zichanCaiGouId != null)
{
query = query.Where(d => d.guDingZiChanMX.zichanCaiGouId == req.zichanCaiGouId);
}
if (req.zichanGouRuDateStart != DateTime.MinValue && req.zichanGouRuDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.guDingZiChanMX.zichanGouRuDate >= req.zichanGouRuDateStart);
}
if (req.zichanGouRuDateEnd != DateTime.MinValue && req.zichanGouRuDateEnd != SqlDateTime.MinValue.Value)
{
DateTime zichanGouRuDateTemp = req.zichanGouRuDateEnd.AddDays(1);
query = query.Where(d => d.guDingZiChanMX.zichanGouRuDate < zichanGouRuDateTemp);
}
if (!string.IsNullOrEmpty(req.zichanBeiZhu))
{
query = query.Where(d => d.guDingZiChanMX.zichanBeiZhu.Contains(req.zichanBeiZhu));
}
if (!string.IsNullOrEmpty(req.zichanBuChong))
{
query = query.Where(d => d.guDingZiChanMX.zichanBuChong.Contains(req.zichanBuChong));
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.guDingZiChanMX.optName.Contains(req.optName));
}
if (req.optId != null)
{
query = query.Where(d => d.guDingZiChanMX.optId == req.optId);
}
if (req.createDateTimeStart != DateTime.MinValue && req.createDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.guDingZiChanMX.createDateTime >= req.createDateTimeStart);
}
if (req.createDateTimeEnd != DateTime.MinValue && req.createDateTimeEnd != SqlDateTime.MinValue.Value)
{
DateTime createDateTimeTemp = req.createDateTimeEnd.AddDays(1);
query = query.Where(d => d.guDingZiChanMX.createDateTime < createDateTimeTemp);
}
if (!string.IsNullOrEmpty(req.state))
{
query = query.Where(d => d.guDingZiChanMX.state.Contains(req.state));
}
//if (string.IsNullOrEmpty(req.sidx))
//{
// req.sidx = "guDingZiChanMX.id";
// req.sord = "desc";
//}
//query = query.OrderByDescending(n => n.guDingZiChanMX.id);
SearchListResult <guDingZiChanMXBig> retListResult = query.ToSearchList(req, false);
return(retListResult);
}
/// <summary>
/// 查询guDingZiChanMX
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <guDingZiChanMX> SearchList(guDingZiChanMXReq req)
{
var query = from source in db.guDingZiChanMX select source;
if (req.GuDingId != null)
{
query = query.Where(d => d.GuDingId == req.GuDingId);
}
if (!string.IsNullOrEmpty(req.zichanNum))
{
query = query.Where(d => d.zichanNum.Contains(req.zichanNum));
}
if (!string.IsNullOrEmpty(req.zichanName))
{
query = query.Where(d => d.zichanName.Contains(req.zichanName));
}
if (!string.IsNullOrEmpty(req.zichanPinPai))
{
query = query.Where(d => d.zichanPinPai.Contains(req.zichanPinPai));
}
if (!string.IsNullOrEmpty(req.zichanChangJia))
{
query = query.Where(d => d.zichanChangJia.Contains(req.zichanChangJia));
}
if (!string.IsNullOrEmpty(req.changjiaNum))
{
query = query.Where(d => d.changjiaNum.Contains(req.changjiaNum));
}
if (req.zichanShulia != null)
{
query = query.Where(d => d.zichanShulia == req.zichanShulia);
}
if (req.zichanSingle != null)
{
query = query.Where(d => d.zichanSingle == req.zichanSingle);
}
if (req.zichanJi != null)
{
query = query.Where(d => d.zichanJi == req.zichanJi);
}
if (!string.IsNullOrEmpty(req.zichanDiDian))
{
query = query.Where(d => d.zichanDiDian.Contains(req.zichanDiDian));
}
if (!string.IsNullOrEmpty(req.zichanUserName))
{
query = query.Where(d => d.zichanUserName.Contains(req.zichanUserName));
}
if (req.zichanUserId != null)
{
query = query.Where(d => d.zichanUserId == req.zichanUserId);
}
if (!string.IsNullOrEmpty(req.zichanCaiGouName))
{
query = query.Where(d => d.zichanCaiGouName.Contains(req.zichanCaiGouName));
}
if (req.zichanCaiGouId != null)
{
query = query.Where(d => d.zichanCaiGouId == req.zichanCaiGouId);
}
if (req.zichanGouRuDateStart != DateTime.MinValue && req.zichanGouRuDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.zichanGouRuDate >= req.zichanGouRuDateStart);
}
if (req.zichanGouRuDateEnd != DateTime.MinValue && req.zichanGouRuDateEnd != SqlDateTime.MinValue.Value)
{
DateTime zichanGouRuDateTemp = req.zichanGouRuDateEnd.AddDays(1);
query = query.Where(d => d.zichanGouRuDate < zichanGouRuDateTemp);
}
if (!string.IsNullOrEmpty(req.zichanBeiZhu))
{
query = query.Where(d => d.zichanBeiZhu.Contains(req.zichanBeiZhu));
}
if (!string.IsNullOrEmpty(req.zichanBuChong))
{
query = query.Where(d => d.zichanBuChong.Contains(req.zichanBuChong));
}
if (!string.IsNullOrEmpty(req.optName))
{
query = query.Where(d => d.optName.Contains(req.optName));
}
if (req.optId != null)
{
query = query.Where(d => d.optId == req.optId);
}
if (req.createDateTimeStart != DateTime.MinValue && req.createDateTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.createDateTime >= req.createDateTimeStart);
}
if (req.createDateTimeEnd != DateTime.MinValue && req.createDateTimeEnd != SqlDateTime.MinValue.Value)
{
DateTime createDateTimeTemp = req.createDateTimeEnd.AddDays(1);
query = query.Where(d => d.createDateTime < createDateTimeTemp);
}
if (!string.IsNullOrEmpty(req.state))
{
query = query.Where(d => d.state.Contains(req.state));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <guDingZiChanMX> retListResult = query.ToSearchList(req);
return(retListResult);
}
