public HeTongServiceModel UpdateSingle(int id, HeTongServiceModelReq data)
{
HeTongServiceModel model = db.HeTongServiceModel.Find(id);
SetHeTongServiceModel(model, data);
db.SaveChanges();
return(model);
}
/// <summary>
/// 查询HeTongServiceModel
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <HeTongServiceModel> SearchList(HeTongServiceModelReq req)
{
var query = from source in db.HeTongServiceModel select source;
if (!string.IsNullOrEmpty(req.projectids))
{
List <int> projectids = req.projectids.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(s => Convert.ToInt32(s)).ToList();
query = query.Where(d => d.projectid != null && projectids.Contains(d.projectid.Value));
}
if (req.projectid != null && req.projectid != 0)
{
query = query.Where(d => d.projectid == req.projectid);
}
if (!string.IsNullOrEmpty(req.ProjectName))
{
query = query.Where(d => d.ProjectName.Contains(req.ProjectName));
}
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 (!string.IsNullOrEmpty(req.state))
{
query = query.Where(d => d.state.Contains(req.state));
}
if (!string.IsNullOrEmpty(req.ServerName))
{
query = query.Where(d => d.ServerName.Contains(req.ServerName));
}
if (req.lastupdateid != null)
{
query = query.Where(d => d.lastupdateid == req.lastupdateid);
}
if (!string.IsNullOrEmpty(req.Mark))
{
query = query.Where(d => d.Mark.Contains(req.Mark));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <HeTongServiceModel> retListResult = query.ToSearchList(req);
return(retListResult);
}
/// <summary>
/// 设置model，如果不为空就设置,如果为空则和之前一样
/// </summary>
/// <param name="target"></param>
/// <param name="source"></param>
/// <returns></returns>
public HeTongServiceModel SetHeTongServiceModel(HeTongServiceModel model, HeTongServiceModelReq data)
{
if (data.projectid != null)
{
model.projectid = data.projectid.Value;
}
if (!string.IsNullOrEmpty(data.ProjectName))
{
model.ProjectName = data.ProjectName;
}
if (data.optid != null)
{
model.optid = data.optid.Value;
}
if (!string.IsNullOrEmpty(data.optName))
{
model.optName = data.optName;
}
if (!string.IsNullOrEmpty(data.state))
{
model.state = data.state;
}
if (!string.IsNullOrEmpty(data.ServerName))
{
model.ServerName = data.ServerName;
}
if (data.lastupdateid != null)
{
model.lastupdateid = data.lastupdateid.Value;
}
if (!string.IsNullOrEmpty(data.Mark))
{
model.Mark = data.Mark;
}
return(model);
}
