public JMSShouKuanRule UpdateSingle(int id, JMSShouKuanRuleReq data)
{
JMSShouKuanRule model = db.JMSShouKuanRule.Find(id);
SetJMSShouKuanRule(model, data);
db.SaveChanges();
return(model);
}
/// <summary>
/// 设置model，如果不为空就设置,如果为空则和之前一样
/// </summary>
/// <param name="target"></param>
/// <param name="source"></param>
/// <returns></returns>
public JMSShouKuanRule SetJMSShouKuanRule(JMSShouKuanRule model, JMSShouKuanRuleReq data)
{
if (data.JmsId != null)
{
model.JmsId = data.JmsId.Value;
}
if (!string.IsNullOrEmpty(data.JmsName))
{
model.JmsName = data.JmsName;
}
if (!string.IsNullOrEmpty(data.JmsClassName))
{
model.JmsClassName = data.JmsClassName;
}
if (!string.IsNullOrEmpty(data.ShouKuanType))
{
model.ShouKuanType = data.ShouKuanType;
}
if (data.ShouKuanMoney != null)
{
model.ShouKuanMoney = data.ShouKuanMoney.Value;
}
if (data.StartTime != null && data.StartTime != DateTime.MinValue && data.StartTime != SqlDateTime.MinValue.Value)
{
model.StartTime = data.StartTime.Value;
}
if (data.ShouKuanTime != null && data.ShouKuanTime != DateTime.MinValue && data.ShouKuanTime != SqlDateTime.MinValue.Value)
{
model.ShouKuanTime = data.ShouKuanTime.Value;
}
if (!string.IsNullOrEmpty(data.State))
{
model.State = data.State;
}
if (data.OptId != null)
{
model.OptId = data.OptId.Value;
}
if (!string.IsNullOrEmpty(data.OptName))
{
model.OptName = data.OptName;
}
if (data.Createtime != null && data.Createtime != DateTime.MinValue && data.Createtime != SqlDateTime.MinValue.Value)
{
model.Createtime = data.Createtime.Value;
}
return(model);
}
/// <summary>
/// 查询JMSShouKuanRule
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <JMSShouKuanRule> SearchList(JMSShouKuanRuleReq req)
{
var query = from source in db.JMSShouKuanRule select source;
if (req.JmsId != null)
{
query = query.Where(d => d.JmsId == req.JmsId);
}
if (!string.IsNullOrEmpty(req.JmsName))
{
query = query.Where(d => d.JmsName.Contains(req.JmsName));
}
if (!string.IsNullOrEmpty(req.JmsClassName))
{
query = query.Where(d => d.JmsClassName.Contains(req.JmsClassName));
}
if (!string.IsNullOrEmpty(req.ShouKuanType))
{
query = query.Where(d => d.ShouKuanType.Contains(req.ShouKuanType));
}
if (req.ShouKuanMoney != null)
{
query = query.Where(d => d.ShouKuanMoney == req.ShouKuanMoney);
}
if (req.StartTimeStart != DateTime.MinValue && req.StartTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.StartTime >= req.StartTimeStart);
}
if (req.StartTimeEnd != DateTime.MinValue && req.StartTimeEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.StartTime >= req.StartTimeEnd);
}
if (req.ShouKuanTimeStart != DateTime.MinValue && req.ShouKuanTimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ShouKuanTime >= req.ShouKuanTimeStart);
}
if (req.ShouKuanTimeEnd != DateTime.MinValue && req.ShouKuanTimeEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.ShouKuanTime >= req.ShouKuanTimeEnd);
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
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.CreatetimeStart != DateTime.MinValue && req.CreatetimeStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.Createtime >= req.CreatetimeStart);
}
if (req.CreatetimeEnd != DateTime.MinValue && req.CreatetimeEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.Createtime >= req.CreatetimeEnd);
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <JMSShouKuanRule> retListResult = query.ToSearchList(req);
return(retListResult);
}
