/// <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)); }