예제 #1
0
        public HttpResponseMessage SearchBankCardsByUserID(string userId = null, int page = 1, int pageSize = 10)
        {
            if (string.IsNullOrEmpty(userId) || !PageHelper.ValidateNumber(userId))
            {
                return PageHelper.toJson(PageHelper.ReturnValue(false, "数据验证错误!"));
            }

            var bankcardSearchCon = new BankCardSearchCondition
            {
                Brokers = _brokerService.GetBrokerById(Convert.ToInt32(userId)),
                Page = Convert.ToInt32(page),
                PageCount = pageSize
            };

            var bankList = _bankcardService.GetBankCardsByCondition(bankcardSearchCon).Select(p => new
            {
                Id = p.Id,
                bankName = p.Bank.Codeid,
                p.Num,
                p.Addtime

            }).ToList();
            var bankListCount = _bankcardService.GetBankCardCount(bankcardSearchCon);
            return PageHelper.toJson(new { List = bankList, Condition = bankcardSearchCon, totalCount1 = bankListCount });

        }
예제 #2
0
		public IQueryable<BankCardEntity> GetBankCardsByCondition(BankCardSearchCondition condition)
		{
			var query = _bankcardRepository.Table;
			try
			{
				if (condition.DeadlineBegin.HasValue)
                {
                    query = query.Where(q => q.Deadline>= condition.DeadlineBegin.Value);
                }
                if (condition.DeadlineEnd.HasValue)
                {
                    query = query.Where(q => q.Deadline < condition.DeadlineEnd.Value);
                }
				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 (condition.UptimeBegin.HasValue)
                {
                    query = query.Where(q => q.Uptime>= condition.UptimeBegin.Value);
                }
                if (condition.UptimeEnd.HasValue)
                {
                    query = query.Where(q => q.Uptime < condition.UptimeEnd.Value);
                }
				if (!string.IsNullOrEmpty( condition.Type))
                {
                    query = query.Where(q =>q.Type ==condition.Type);
                }
				if (condition.Ids != null && condition.Ids.Any())
                {
                    query = query.Where(q => condition.Ids.Contains(q.Id));
                }
				if (condition.Banks != null)
                {
                    query = query.Where(q => condition.Banks==q.Bank);
                }
				if (condition.Brokers != null)
                {
                    query = query.Where(q => (q.Broker.Id == condition.Brokers.Id));
                }
				if (!string.IsNullOrEmpty( condition.Nums) )
                {
                    query = query.Where(q => (q.Num == condition.Nums));
                }
				if (condition.Addusers != null && condition.Addusers.Any())
                {
                    query = query.Where(q => condition.Addusers.Contains(q.Adduser));
                }
				if (condition.Upusers != null && condition.Upusers.Any())
                {
                    query = query.Where(q => condition.Upusers.Contains(q.Upuser));
                }
				if(condition.OrderBy.HasValue)
				{
					switch (condition.OrderBy.Value)
                    {
						case EnumBankCardSearchOrderBy.OrderById:
							query = condition.isDescending?query.OrderByDescending(q=>q.Id):query.OrderBy(q=>q.Id);
							break;
                    }
					
				}
				else
				{
					query = query.OrderBy(q=>q.Id);
				}

				if (condition.Page.HasValue && condition.PageCount.HasValue)
                {
                    query = query.Skip((condition.Page.Value - 1)*condition.PageCount.Value).Take(condition.PageCount.Value);
                }
				return query;
			}
			catch(Exception e)
			{
				_log.Error(e,"数据库操作出错");
                return null;
			}
		}
예제 #3
0
		public int GetBankCardCount (BankCardSearchCondition condition)
		{
			var query = _bankcardRepository.Table;
			try
			{
				if (condition.DeadlineBegin.HasValue)
                {
                    query = query.Where(q => q.Deadline>= condition.DeadlineBegin.Value);
                }
                if (condition.DeadlineEnd.HasValue)
                {
                    query = query.Where(q => q.Deadline < condition.DeadlineEnd.Value);
                }
				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 (condition.UptimeBegin.HasValue)
                {
                    query = query.Where(q => q.Uptime>= condition.UptimeBegin.Value);
                }
                if (condition.UptimeEnd.HasValue)
                {
                    query = query.Where(q => q.Uptime < condition.UptimeEnd.Value);
                }
				if (!string.IsNullOrEmpty(condition.Type))
                {
                    query = query.Where(q => q.Type == condition.Type);
                }
				if (condition.Ids != null && condition.Ids.Any())
                {
                    query = query.Where(q => condition.Ids.Contains(q.Id));
                }
				if (condition.Banks != null )
                {
                    query = query.Where(q => condition.Banks==(q.Bank));
                }
				if (condition.Brokers != null )
                {
                    query = query.Where(q => condition.Brokers.Id ==(q.Broker.Id ));
                }
                if (!string.IsNullOrEmpty(condition.Nums))
                {
                    query = query.Where(q => (q.Num == condition.Nums));
                }
				if (condition.Addusers != null && condition.Addusers.Any())
                {
                    query = query.Where(q => condition.Addusers.Contains(q.Adduser));
                }
				if (condition.Upusers != null && condition.Upusers.Any())
                {
                    query = query.Where(q => condition.Upusers.Contains(q.Upuser));
                }
				return query.Count();
			}
			catch(Exception e)
			{
				_log.Error(e,"数据库操作出错");
                return -1;
			}
		}
예제 #4
0
        public HttpResponseMessage SearchAllBankByUser()
        {
            var user = (UserBase)_workContext.CurrentUser;
            if (user != null)
            {
                var broker = _brokerService.GetBrokerByUserId(user.Id);//获取当前经纪人
                if (broker == null)
                {
                    return PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败,请检查是否登陆"));
                }
                else
                {
                    var bankcardSearchCon = new BankCardSearchCondition
                    {
                        Brokers = broker
                    };
                    var bankList = _bankcardService.GetBankCardsByCondition(bankcardSearchCon).Select(p => new
                    {
                        Id = p.Id,
                        bankName = p.Bank.Codeid,
                        Num = p.Num.ToString().Substring(p.Num.ToString().Length - 4, 4)
                    }).ToList();

                    return PageHelper.toJson(new { List = bankList, AmountMoney = broker.Amount });
                }
            }
            return PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败,请检查是否登陆"));

        }
예제 #5
0
        public HttpResponseMessage DeleteBankCard([FromBody] string id)
        {
            if (!string.IsNullOrEmpty(id) && id!="0")
           {
             int Id;
             if (!Int32.TryParse(id, out Id))
             {
                 return PageHelper.toJson(PageHelper.ReturnValue(false, "数据异常"));
             }
             var user = (UserBase)_workContext.CurrentUser;
             if (user != null)
             {
                 var broker = _brokerService.GetBrokerByUserId(user.Id);//获取当前经纪人
                 if (broker == null)
                 {

                     return PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败,请检查是否登陆"));
                 }
                 else
                 {
                      
                     
                     int [] ids={Id};                 
                     var bankcardSearchCon = new BankCardSearchCondition
                     {
                         Brokers = broker,
                         Ids=ids
                     };
                    if( _bankcardService.GetBankCardCount(bankcardSearchCon)>0)//判断是否是自己的卡
                    {
                        var Bank=_bankcardService.GetBankCardById(Id);
                        if (Bank==null)
                        {
                          return PageHelper.toJson(PageHelper.ReturnValue(false, "数据异常"));
                        }
                        BankCardEntity[] banks={Bank};
                      BrokerWithdrawSearchCondition bwithSearchCon=new BrokerWithdrawSearchCondition{
                           Brokers=broker,
                           BankCards=banks
                      };
                      if (_brokerwithdrawService.GetBrokerWithdrawCount(bwithSearchCon) > 0)//判断用户提现表是否使用此卡
                    {
                        return PageHelper.toJson(PageHelper.ReturnValue(false, "有该银行相关提现数据不能删除"));
                    }
                      _bankcardService.Delete(Bank);
                      return PageHelper.toJson(PageHelper.ReturnValue(true, "删除成功"));

                    }
                    else
                    {
                        return PageHelper.toJson(PageHelper.ReturnValue(false, "数据异常"));
                    }
                                     
                 }
             }
           
           }
           return PageHelper.toJson(PageHelper.ReturnValue(false, "数据异常"));
        }