/// <summary>
/// 获取用户借款列表
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public PagedResult <MemberLoanList> GetMemberLoanList(MemberLoanParameter parameter)
{
string innersqlstr = $"select Members.MemberID,Members.MemberName,members.MemberPhone,MemberLoan.TotalAmount,memberloan.AlreadyUsedAmount,memberloan.AvailableAmount from MemberLoan left join Members on members.MemberID= MemberLoan.MemberID where Members.MemberName like '%{parameter.MemberName}%'";
string sqlstr = "select * from (select ROW_NUMBER() OVER(ORDER BY t.MemberID )AS Row,t.* from"
+ $" ({innersqlstr}) t) tt"
+ " where tt.Row BETWEEN @StartIndex AND @EndIndex";
List <MemberLoanList> memberLoanList = DbHelper.Query <MemberLoanList>(sqlstr, new
{
StartIndex = parameter.SkipCount,
EndIndex = parameter.TakeCount
});
int totalCount = DbHelper.QuerySingle <int>($"select count(0) from ({innersqlstr}) t");
return(new PagedResult <MemberLoanList>
{
PageIndex = parameter.PageIndex,
PageSize = parameter.PageSize,
TotalItemCount = totalCount,
Items = memberLoanList
});
}
/// <summary>
/// 获取借款用户列表
/// </summary>
/// <returns></returns>
public ActionResult GetLoanMemberList(MemberLoanParameter parameter)
{
PagedResult <MemberLoanList> memberLoanList = _LoanMemberService.GetMemberLoanList(parameter);
return(View("/Views/Loan/LoanMember/GetLoanMemberList.cshtml", memberLoanList));
}
