public HttpResponseMessage GetBrokerWithdrawDetailListByUserId(string userId = null, int page = 1, int pageSize = 10)
{
if (string.IsNullOrEmpty(userId))
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据错误！")));
}
var brokerwithdrawdetailcon = new BrokerWithdrawDetailSearchCondition
{
Brokers = _brokerService.GetBrokerById(Convert.ToInt32(userId)),
Page = Convert.ToInt32(page),
PageCount = pageSize
};
var PointDetailList = _brokerwithdrawdetailService.GetBrokerWithdrawDetailsByCondition(brokerwithdrawdetailcon).Select(p => new
{
Id = p.Id,
bankname = p.BankCard.Bank.Codeid,
banknumber = p.BankCard.Num,
Withdrawnum = p.Withdrawnum,
Withdrawtime = p.Withdrawtime
}).ToList().Select(p => new
{
Id = p.Id,
bankname = p.bankname,
banknumber = p.banknumber,
Withdrawnum = p.Withdrawnum,
Withdrawtime = p.Withdrawtime.ToString("yyyy-MM-dd")
});
var PointDetailListCount = _brokerwithdrawdetailService.GetBrokerWithdrawDetailCount(brokerwithdrawdetailcon);
return(PageHelper.toJson(new { List = PointDetailList, Condition = brokerwithdrawdetailcon, totalCount = PointDetailListCount }));
}
/// <summary>
/// 根据提现ID查询提现明细信息
/// chen
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
//[Description("根据经纪人查询提现明细")]
//[HttpGet]
public HttpResponseMessage GetBrokerWithdrawDetailByBrokerWithdrawId(string id)
{
if (string.IsNullOrEmpty(id))
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据错误！")));
}
var seach = new BrokerWithdrawDetailSearchCondition
{
OrderBy = EnumBrokerWithdrawDetailSearchOrderBy.OrderById,
BrokerWithdraw = _brokerwithdrawService.GetBrokerWithdrawById(Convert.ToInt32(id)),
};
var list = _brokerwithdrawdetailService.GetBrokerWithdrawDetailsByCondition(seach).Select(b => new
{
b.Id,
b.Withdrawnum,
b.BrokeAccount_Id,
b.Withdrawtime,
b.Type,
b.BrokerWithdraw.WithdrawDesc,
}).ToList().Select(a => new
{
a.Id,
a.Withdrawnum,
a.BrokeAccount_Id,
a.Type,
WithdrawDesc = a.WithdrawDesc,
Withdrawtime = a.Withdrawtime.ToString("yyy-MM-dd"),
});
//取出所有提现明细的ID
StringBuilder SB = new StringBuilder();
foreach (var p in list)
{
SB.Append(p.Id.ToString() + ",");
}
////////////取出账户明细ID
StringBuilder stb = new StringBuilder();
foreach (var b in list)
{
stb.Append(b.BrokeAccount_Id.Id.ToString() + ",");
}
return(PageHelper.toJson(new { List = list, Ids = SB.ToString(), BrokeAccountId = stb.ToString() }));
}
public IQueryable <BrokerWithdrawDetailEntity> GetBrokerWithdrawDetailsByCondition(BrokerWithdrawDetailSearchCondition condition)
{
var query = _brokerwithdrawdetailRepository.Table;
try
{
if (condition.WithdrawtimeBegin.HasValue)
{
query = query.Where(q => q.Withdrawtime >= condition.WithdrawtimeBegin.Value);
}
if (condition.WithdrawtimeEnd.HasValue)
{
query = query.Where(q => q.Withdrawtime < condition.WithdrawtimeEnd.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 (condition.Withdrawnum.HasValue)
{
query = query.Where(q => q.Withdrawnum == condition.Withdrawnum.Value);
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.Brokers != null)
{
query = query.Where(q => (q.Broker.Id == condition.Brokers.Id));
}
if (condition.BankCards != null && condition.BankCards.Any())
{
query = query.Where(q => condition.BankCards.Contains(q.BankCard));
}
if (condition.Addusers != null && condition.Addusers.Any())
{
query = query.Where(q => condition.Addusers.Contains(q.Adduser));
}
if (!string.IsNullOrEmpty(condition.Type))
{
query = query.Where(q => q.Type == condition.Type);
}
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 EnumBrokerWithdrawDetailSearchOrderBy.OrderById:
query = condition.isDescending?query.OrderByDescending(q => q.Id):query.OrderBy(q => q.Id);
break;
case EnumBrokerWithdrawDetailSearchOrderBy.OrderByTime:
query = condition.isDescending ? query.OrderBy(q => q.Uptime) : query.OrderByDescending(q => q.Uptime);
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);
}
}
public int GetBrokerWithdrawDetailCount(BrokerWithdrawDetailSearchCondition condition)
{
var query = _brokerwithdrawdetailRepository.Table;
try
{
if (condition.WithdrawtimeBegin.HasValue)
{
query = query.Where(q => q.Withdrawtime >= condition.WithdrawtimeBegin.Value);
}
if (condition.WithdrawtimeEnd.HasValue)
{
query = query.Where(q => q.Withdrawtime < condition.WithdrawtimeEnd.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 (!string.IsNullOrEmpty(condition.Type))
{
query = query.Where(q => q.Type == condition.Type);
}
if (condition.UptimeEnd.HasValue)
{
query = query.Where(q => q.Uptime < condition.UptimeEnd.Value);
}
if (condition.Withdrawnum.HasValue)
{
query = query.Where(q => q.Withdrawnum == condition.Withdrawnum.Value);
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (condition.Brokers != null)
{
query = query.Where(q => condition.Brokers.Id == (q.Broker.Id));
}
if (condition.BankCards != null && condition.BankCards.Any())
{
query = query.Where(q => condition.BankCards.Contains(q.BankCard));
}
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);
}
}
public HttpResponseMessage SetPay([FromBody] PayModel payModel)
{
var user = (UserBase)_workContext.CurrentUser;
var broker = new BrokerEntity {
};
var BrokeAccount = new BrokeAccountEntity {
};
var BrokerWithdraw = new BrokerWithdrawEntity {
};
var BrokerWithDrawDetail = new BrokerWithdrawDetailEntity {
};
//var condition = new BrokerWithdrawDetailSearchCondition
//{
// BrokerWithdraw = payModel.Id
//};
if (user == null)
{
//broker = _brokerService.GetBrokerByUserId(user.Id); //获取当前经纪人
//if (broker == null)
//{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败，请检查是否登陆")));
//}
}
if (string.IsNullOrEmpty(payModel.Id))
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据不能为空")));
}
//根据经纪人提现ID查询经纪人体现信息
BrokerWithdraw = _brokerwithdrawService.GetBrokerWithdrawById(Convert.ToInt32(payModel.Id));
// 判断提现状态，如果状态为一，则表示已经提现
if (BrokerWithdraw.State == 1)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "财务已经打款")));
}
////////////////////////////////////////////////////////////////////////////////////////////////
//if (string.IsNullOrEmpty(payModel.Ids))
//{
// return PageHelper.toJson(PageHelper.ReturnValue(false, "数据不能为空"));
//}
//if (string.IsNullOrEmpty(payModel.BrokeAccountId))
//{
// return PageHelper.toJson(PageHelper.ReturnValue(false,"数据不能为空"));
//}
//构建查询实体
var seach = new BrokerWithdrawDetailSearchCondition
{
OrderBy = EnumBrokerWithdrawDetailSearchOrderBy.OrderByTime,
BrokerWithdraw = _brokerwithdrawService.GetBrokerWithdrawById(Convert.ToInt32(payModel.Id)),
};
var list = _brokerwithdrawDetailService.GetBrokerWithdrawDetailsByCondition(seach).Select(b => new
{
b.Id,
b.Withdrawnum,
b.BrokeAccount_Id,
b.Withdrawtime,
b.Type,
b.BrokerWithdraw.WithdrawDesc,
b.BrokerWithdraw.BankCard.Num,
}).ToList().Select(a => new
{
a.Id,
a.Withdrawnum,
a.BrokeAccount_Id,
a.Type,
a.Num,
WithdrawDesc = a.WithdrawDesc,
Withdrawtime = a.Withdrawtime.ToString("yyy-MM-dd"),
});
foreach (var p in list)
{
if (p == null)
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据错误")));
}
if (Convert.ToInt32(p.Type) == 0)
{
var blModel = new BLPayEntity
{
Name = payModel.Name,
Describe = payModel.Describe,
BankCard = p.Num,
Accountantid = user.Id,
Amount = p.Withdrawnum,
Adduser = user.Id,
Upuser = user.Id,
Addtime = DateTime.Now,
Uptime = DateTime.Now,
};
_blPayService.Create(blModel);
}
if (Convert.ToInt32(p.Type) == 1)
{
var breModel = new BRECPayEntity
{
Name = payModel.Name,
Describe = payModel.Describe,
BankCard = p.Num,
Accountantid = user.Id,
Amount = p.Withdrawnum,
Adduser = user.Id,
Upuser = user.Id,
Addtime = DateTime.Now,
Uptime = DateTime.Now,
};
_brecPayService.Create(breModel);
}
BrokeAccount = _brokerAcountService.GetBrokeAccountById(p.BrokeAccount_Id.Id);
BrokeAccount.State = 1;
BrokeAccount.Uptime = DateTime.Now;
BrokeAccount.Upuser = user.Id;
_brokerAcountService.Update(BrokeAccount);
}
//string[] strBrokeAccountId = payModel.BrokeAccountId.Split(',');
//foreach (var BrokeAccountId in strBrokeAccountId)
//{
// if (string.IsNullOrEmpty(BrokeAccountId))
// {
// return PageHelper.toJson(PageHelper.ReturnValue(false, "数据错误"));
// }
// BrokeAccount = _brokerAcountService.GetBrokeAccountById(Convert.ToInt32(BrokeAccountId));
// if (BrokeAccount.State == 1)
// {
// break;
// }
//}
//string[] strIds = payModel.Ids.Split(',');
//foreach (var id in strIds)
//{
// if(string.IsNullOrEmpty(id))
// {
// break;
// }
// var model = _brokerwithdrawDetailService.GetBrokerWithdrawDetailById(Convert.ToInt32(id));
// if (Convert.ToInt32(model.Type) == 0)
// {
// var blModel = new BLPayEntity
// {
// Name = payModel.Name,
// Describe = payModel.Describe,
// BankCard = Convert.ToInt32(model.BankCard.Num),
// Accountantid = broker.Id,
// Amount = model.Withdrawnum,
// Adduser = broker.Id,
// Upuser = broker.Id,
// Addtime = DateTime.Now,
// Uptime = DateTime.Now,
// };
// _blPayService.Create(blModel);
// }
// if (Convert.ToInt32(model.Type) == 1)
// {
// var breModel = new BRECPayEntity
// {
// Name = payModel.Name,
// Describe = payModel.Describe,
// BankCard = Convert.ToInt32(model.BankCard.Num),
// Accountantid = broker.Id,
// Amount = model.Withdrawnum,
// Adduser = broker.Id,
// Upuser = broker.Id,
// Addtime = DateTime.Now,
// Uptime = DateTime.Now,
// };
// _brecPayService.Create(breModel);
// }
//}
BrokerWithdraw.State = 1;
//BrokerWithdraw.AccAccountantId.UserId = user.Id;
BrokerWithdraw.Uptime = DateTime.Now;
BrokerWithdraw.Upuser = user.Id;
BrokerWithdraw.WithdrawDesc = payModel.Describe;
BrokerWithdraw.BankSn = payModel.BankSn;
_brokerwithdrawService.Update(BrokerWithdraw);
return(PageHelper.toJson(PageHelper.ReturnValue(true, "打款成功")));
}
