public Caipu UpdateSingle(int id, CaipuReq data) { Caipu model = db.Caipu.Find(id); SetCaipu(model, data); db.SaveChanges(); return(model); }
/// <summary> /// 设置model,如果不为空就设置,如果为空则和之前一样 /// </summary> /// <param name="target"></param> /// <param name="source"></param> /// <returns></returns> public Caipu SetCaipu(Caipu model, CaipuReq data) { if (!string.IsNullOrEmpty(data.Name)) { model.Name = data.Name; } if (!string.IsNullOrEmpty(data.CaiType)) { model.CaiType = data.CaiType; } if (!string.IsNullOrEmpty(data.CanType)) { model.CanType = data.CanType; } if (data.Step != null) { model.Step = data.Step; } if (!string.IsNullOrEmpty(data.Peiliao)) { model.Peiliao = data.Peiliao; } if (data.ServerDate != null && data.ServerDate != DateTime.MinValue && data.ServerDate != SqlDateTime.MinValue.Value) { model.ServerDate = data.ServerDate.Value; } if (data.Createdate != null && data.Createdate != DateTime.MinValue && data.Createdate != SqlDateTime.MinValue.Value) { model.Createdate = data.Createdate.Value; } if (data.OptId != null) { model.OptId = data.OptId.Value; } if (!string.IsNullOrEmpty(data.OptName)) { model.OptName = data.OptName; } if (!string.IsNullOrEmpty(data.Gongxiao)) { model.Gongxiao = data.Gongxiao; } if (data.projectid != null) { model.ProjectId = data.projectid.Value; } if (!string.IsNullOrEmpty(data.ProjectName)) { model.ProjectName = data.ProjectName; } if (data.SaveId != null) { model.SaveId = data.SaveId.Value; } if (!string.IsNullOrEmpty(data.SaveName)) { model.SaveName = data.SaveName; } if (data.StartPersonId != null) { model.StartPersonId = data.StartPersonId.Value; } if (!string.IsNullOrEmpty(data.StartPersonName)) { model.StartPersonName = data.StartPersonName; } if (data.SpecialCustomerId != null) { model.SpecialCustomerId = data.SpecialCustomerId.Value; } if (!string.IsNullOrEmpty(data.ValidState)) { model.ValidState = data.ValidState; } return(model); }
/// <summary> /// 查询Caipu /// </summary> /// <param name="req"></param> /// <returns></returns> public SearchListResult <Caipu> SearchList(CaipuReq req) { var query = from source in db.Caipu select source; if (!string.IsNullOrEmpty(req.Name)) { query = query.Where(d => d.Name.Contains(req.Name)); } if (!string.IsNullOrEmpty(req.CaiType)) { query = query.Where(d => d.CaiType.Contains(req.CaiType)); } if (!string.IsNullOrEmpty(req.CanType)) { query = query.Where(d => d.CanType.Contains(req.CanType)); } if (null != req.Step) { query = query.Where(d => d.Step.Equals(req.Step)); } if (!string.IsNullOrEmpty(req.Peiliao)) { query = query.Where(d => d.Peiliao.Contains(req.Peiliao)); } if (req.ServerDateStart != DateTime.MinValue && req.ServerDateStart != SqlDateTime.MinValue.Value) { query = query.Where(d => d.ServerDate >= req.ServerDateStart); } if (req.ServerDateEnd != DateTime.MinValue && req.ServerDateEnd != SqlDateTime.MinValue.Value) { query = query.Where(d => d.ServerDate >= req.ServerDateEnd); } 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.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.Gongxiao)) { query = query.Where(d => d.Gongxiao.Contains(req.Gongxiao)); } 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 (!string.IsNullOrEmpty(req.StartPersonName)) { query = query.Where(d => d.StartPersonName.Contains(req.StartPersonName)); } if (null != req.StartPersonId) { query = query.Where(d => d.StartPersonId.Equals(req.StartPersonId)); } if (!string.IsNullOrEmpty(req.SaveName)) { query = query.Where(d => d.SaveName.Contains(req.SaveName)); } if (null != req.SaveId) { query = query.Where(d => d.SaveId.Equals(req.SaveId)); } if (string.IsNullOrEmpty(req.sidx)) { req.sidx = "id"; req.sord = "desc"; } SearchListResult <Caipu> retListResult = query.ToSearchList(req); return(retListResult); }