public int GetEventOrderCount(EventOrderSearchCondition condition) { var query = _eventorderRepository.Table; try { if (condition.AddtimeBegin.HasValue) { query = query.Where(q => q.Addtime >= condition.AddtimeBegin.Value); } if (condition.AddtimeEnd.HasValue) { query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value); } if (!string.IsNullOrEmpty(condition.AcDetail)) { query = query.Where(q => q.AcDetail.Contains(condition.AcDetail)); } if (condition.MoneyCount.HasValue) { query = query.Where(q => q.MoneyCount == condition.MoneyCount.Value); } if (condition.Brokers.Id > 0) { query = query.Where(q => q.Broker.Id == condition.Brokers.Id); } return(query.Count()); } catch (Exception e) { _log.Error(e, "数据库操作出错"); return(-1); } }
public IQueryable <EventOrderEntity> GetEventOrderByCondition(EventOrderSearchCondition condition) { var query = _eventorderRepository.Table; try { if (condition.AddtimeBegin.HasValue) { query = query.Where(q => q.Addtime >= condition.AddtimeBegin.Value); } if (condition.AddtimeEnd.HasValue) { query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value); } if (!string.IsNullOrEmpty(condition.AcDetail)) { query = query.Where(q => q.AcDetail.Contains(condition.AcDetail)); } if (condition.MoneyCount.HasValue) { query = query.Where(q => q.MoneyCount == condition.MoneyCount.Value); } return(query); } catch (Exception e) { _log.Error(e, "数据库操作出错"); return(null); } }
public HttpResponseMessage GetBrokerByUserId(string userId) { int IsInvite = 1; //是否使用邀请码(0使用 1未使用) if (string.IsNullOrEmpty(userId) || !PageHelper.ValidateNumber(userId)) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据验证错误!"))); } var model = _brokerService.GetBrokerByUserId(Convert.ToInt32(userId)); if (model == null) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "该用户不存在!"))); } #region 判断经纪人是否使用过邀请码 或者参与过活动 InviteCodeSearchCondition icodeseCon = new InviteCodeSearchCondition { NumUser = model.Id }; var a = _inviteCodeService.GetInviteCodeByCount(icodeseCon); EventOrderSearchCondition eveCon = new EventOrderSearchCondition { Brokers = model }; var b = _eventOrderService.GetEventOrderCount(eveCon); if (a > 0 || b > 0) { IsInvite = 0; //判断有无使用过邀请码 或者参与过活动 或该活动下架 } #endregion var brokerInfo = new BrokerModel { Id = model.Id, Brokername = model.Brokername, Realname = model.Realname, Nickname = model.Nickname, Sexy = model.Sexy, Sfz = model.Sfz, Email = model.Email, Phone = model.Phone, Headphoto = model.Headphoto, WeiXinNumber = model.WeiXinNumber, IsInvite = IsInvite }; return(PageHelper.toJson(brokerInfo)); }