public GuYuanGroup UpdateSingle(int id, GuYuanGroupReq data) { GuYuanGroup model = db.GuYuanGroup.Find(id); SetGuYuanGroup(model, data); db.SaveChanges(); return(model); }
/// <summary> /// 查询GuYuanGroup /// </summary> /// <param name="req"></param> /// <returns></returns> public SearchListResult <GuYuanGroup> SearchList(GuYuanGroupReq req) { var query = from source in db.GuYuanGroup select source; if (req.Departmentid != null) { query = query.Where(d => d.Departmentid == req.Departmentid); } if (!string.IsNullOrEmpty(req.DepartmentName)) { query = query.Where(d => d.DepartmentName.Contains(req.DepartmentName)); } if (!string.IsNullOrEmpty(req.GroupName)) { query = query.Where(d => d.GroupName.Contains(req.GroupName)); } if (!string.IsNullOrEmpty(req.State)) { query = query.Where(d => d.State.Contains(req.State)); } 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.createdateStart != DateTime.MinValue && req.createdateStart != SqlDateTime.MinValue.Value) { query = query.Where(d => d.createdate >= req.createdateStart); } if (req.createdateEnd != DateTime.MinValue && req.createdateEnd != SqlDateTime.MinValue.Value) { query = query.Where(d => d.createdate >= req.createdateEnd); } if (req.projectid != null && req.projectid != 0) { query = query.Where(d => d.ProjectId == req.projectid); } if (string.IsNullOrEmpty(req.sidx)) { req.sidx = "id"; req.sord = "desc"; } SearchListResult <GuYuanGroup> retListResult = query.ToSearchList(req); return(retListResult); }
/// <summary> /// 设置model,如果不为空就设置,如果为空则和之前一样 /// </summary> /// <param name="target"></param> /// <param name="source"></param> /// <returns></returns> public GuYuanGroup SetGuYuanGroup(GuYuanGroup model, GuYuanGroupReq data) { if (data.Departmentid != null) { model.Departmentid = data.Departmentid.Value; } if (!string.IsNullOrEmpty(data.DepartmentName)) { model.DepartmentName = data.DepartmentName; } if (!string.IsNullOrEmpty(data.GroupName)) { model.GroupName = data.GroupName; } if (!string.IsNullOrEmpty(data.State)) { model.State = data.State; } if (!string.IsNullOrEmpty(data.OptName)) { model.OptName = data.OptName; } if (data.OptId != null) { model.OptId = data.OptId.Value; } if (data.createdate != null && data.createdate != DateTime.MinValue && data.createdate != SqlDateTime.MinValue.Value) { model.createdate = data.createdate.Value; } if (data.projectid != null) { model.ProjectId = data.projectid.Value; } return(model); }