public JMSShouKuan UpdateSingle(int id, JMSShouKuanReq data) { JMSShouKuan model = db.JMSShouKuan.Find(id); SetJMSShouKuan(model, data); db.SaveChanges(); return(model); }
/// <summary> /// 设置model,如果不为空就设置,如果为空则和之前一样 /// </summary> /// <param name="target"></param> /// <param name="source"></param> /// <returns></returns> public JMSShouKuan SetJMSShouKuan(JMSShouKuan model, JMSShouKuanReq data) { if (data.JmsShouKuanRuleId != null) { model.JmsShouKuanRuleId = data.JmsShouKuanRuleId.Value; } if (!string.IsNullOrEmpty(data.ShouKuanType)) { model.ShouKuanType = data.ShouKuanType; } if (data.ShouKuanMoney != null) { model.ShouKuanMoney = data.ShouKuanMoney.Value; } if (data.ShouKuanTime != null && data.ShouKuanTime != DateTime.MinValue && data.ShouKuanTime != SqlDateTime.MinValue.Value) { model.ShouKuanTime = data.ShouKuanTime.Value; } if (!string.IsNullOrEmpty(data.ShouKuanState)) { model.ShouKuanState = data.ShouKuanState; } if (data.ShouKuanConfirmerId != null) { model.ShouKuanConfirmerId = data.ShouKuanConfirmerId.Value; } if (!string.IsNullOrEmpty(data.ShouKuanConfirmerName)) { model.ShouKuanConfirmerName = data.ShouKuanConfirmerName; } if (data.ShouKuanConfirmDate != null && data.ShouKuanConfirmDate != DateTime.MinValue && data.ShouKuanConfirmDate != SqlDateTime.MinValue.Value) { model.ShouKuanConfirmDate = data.ShouKuanConfirmDate.Value; } if (data.OptId != null) { model.OptId = data.OptId.Value; } if (!string.IsNullOrEmpty(data.OptName)) { model.OptName = data.OptName; } if (data.Createdate != null && data.Createdate != DateTime.MinValue && data.Createdate != SqlDateTime.MinValue.Value) { model.Createdate = data.Createdate.Value; } return(model); }
/// <summary> /// 查询JMSShouKuan /// </summary> /// <param name="req"></param> /// <returns></returns> public SearchListResult <ShouKuanInfo> SearchList(JMSShouKuanReq req) { var query = from source in db.JMSShouKuan join rule in db.JMSShouKuanRule on source.JmsShouKuanRuleId equals rule.id select new ShouKuanInfo { JMSShouKuan = source, JMSShouKuanRule = rule }; if (!string.IsNullOrEmpty(req.JmsIds)) { List <int> intJids = req.JmsIds.Split(","[0]).Select(d => Convert.ToInt32(d)).ToList(); query = from source in db.JMSShouKuan join rule in db.JMSShouKuanRule on source.JmsShouKuanRuleId equals rule.id where intJids.Contains(rule.JmsId.Value) select new ShouKuanInfo { JMSShouKuan = source, JMSShouKuanRule = rule }; } if (req.JmsShouKuanRuleId != null) { query = query.Where(d => d.JMSShouKuan.JmsShouKuanRuleId == req.JmsShouKuanRuleId); } if (!string.IsNullOrEmpty(req.ShouKuanType)) { List <string> shoukuanTypes = req.ShouKuanType.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList(); query = query.Where(d => shoukuanTypes.Contains(d.JMSShouKuan.ShouKuanType)); } if (req.ShouKuanMoney != null) { query = query.Where(d => d.JMSShouKuan.ShouKuanMoney == req.ShouKuanMoney); } if (req.ShouKuanTimeStart != DateTime.MinValue && req.ShouKuanTimeStart != SqlDateTime.MinValue.Value) { query = query.Where(d => d.JMSShouKuan.ShouKuanTime >= req.ShouKuanTimeStart); } if (req.ShouKuanTimeEnd != DateTime.MinValue && req.ShouKuanTimeEnd != SqlDateTime.MinValue.Value) { query = query.Where(d => d.JMSShouKuan.ShouKuanTime >= req.ShouKuanTimeEnd); } if (!string.IsNullOrEmpty(req.ShouKuanState)) { query = query.Where(d => d.JMSShouKuan.ShouKuanState.Contains(req.ShouKuanState)); } if (req.ShouKuanConfirmerId != null) { query = query.Where(d => d.JMSShouKuan.ShouKuanConfirmerId == req.ShouKuanConfirmerId); } if (!string.IsNullOrEmpty(req.ShouKuanConfirmerName)) { query = query.Where(d => d.JMSShouKuan.ShouKuanConfirmerName.Contains(req.ShouKuanConfirmerName)); } if (req.ShouKuanConfirmDateStart != DateTime.MinValue && req.ShouKuanConfirmDateStart != SqlDateTime.MinValue.Value) { query = query.Where(d => d.JMSShouKuan.ShouKuanConfirmDate >= req.ShouKuanConfirmDateStart); } if (req.ShouKuanConfirmDateEnd != DateTime.MinValue && req.ShouKuanConfirmDateEnd != SqlDateTime.MinValue.Value) { query = query.Where(d => d.JMSShouKuan.ShouKuanConfirmDate >= req.ShouKuanConfirmDateEnd); } if (!string.IsNullOrEmpty(req.OptName)) { query = query.Where(d => d.JMSShouKuan.OptName.Contains(req.OptName)); } if (req.CreatedateStart != DateTime.MinValue && req.CreatedateStart != SqlDateTime.MinValue.Value) { query = query.Where(d => d.JMSShouKuan.Createdate >= req.CreatedateStart); } if (req.CreatedateEnd != DateTime.MinValue && req.CreatedateEnd != SqlDateTime.MinValue.Value) { query = query.Where(d => d.JMSShouKuan.Createdate >= req.CreatedateEnd); } #region 数据权限 if (req.OptId != null && req.OptId.Value != 0) { //组长能看到所有, List <int> subUserIds = DepartmentBLL.GetSubSystemUsers(req.OptId.Value); query = query.Where(d => d.JMSShouKuan.OptId == null || subUserIds.Contains(d.JMSShouKuan.OptId.Value)); } #endregion if (string.IsNullOrEmpty(req.sidx)) { req.sidx = "JMSShouKuan"; req.sord = "desc"; } SearchListResult <ShouKuanInfo> retListResult = query.ToSearchShouKuanInfoList(req); return(retListResult); }