/// <summary> /// 基数审核列表 /// </summary> /// <returns></returns> public ActionResult GetBaseAuditList(BaseAuditParameter parameter) { PagedResult <BaseAuditList> list = _baseAuditService.GetBaseAuditList(parameter); ViewBag.memberList = _memberService.GetMembersList(); List <SelectListItem> selectList = new List <SelectListItem> { new SelectListItem() { Value = "", Text = "全部" } }; selectList.AddRange(EnumExt.GetSelectList(typeof(BaseAuditEnum))); ViewData["StatusType"] = selectList; return(View(list)); }
/// <summary> /// 获取基数审核列表 /// </summary> /// <param name="Type"></param> /// <returns></returns> public PagedResult <BaseAuditList> GetBaseAuditList(BaseAuditParameter parameter) { StringBuilder strb = new StringBuilder("where 1 = 1"); strb.Append($" and Type = {parameter.Type}"); if (!string.IsNullOrEmpty(parameter.MemberID)) { strb.Append($" and m.MemberID = {parameter.MemberID} "); } strb.Append($" and (ssp.SocialSecurityPeopleName like '%{parameter.SocialSecurityPeopleName}%')"); if (!string.IsNullOrEmpty(parameter.Status)) { strb.Append($" and t.Status = {parameter.Status}"); } string innersqlstr = $@" select ssp.SocialSecurityPeopleName SocialSecurityPeopleName,m.UserType UserType,m.MemberName MemberName, t.* from BaseAudit t left join SocialSecurity ss on t.SocialSecurityPeopleID = ss.SocialSecurityPeopleID left join AccumulationFund af on t.SocialSecurityPeopleID = af.SocialSecurityPeopleID left join SocialSecurityPeople ssp on t.SocialSecurityPeopleID = ssp.SocialSecurityPeopleID left join Members m on ssp.MemberID = m.MemberID {strb.ToString()}"; string sqlstr = $"select * from (select ROW_NUMBER() OVER(ORDER BY t.ApplyDate desc )AS Row,t.* from ({innersqlstr}) t ) tt WHERE tt.Row BETWEEN @StartIndex AND @EndIndex"; List <BaseAuditList> modelList = DbHelper.Query <BaseAuditList>(sqlstr, new { StartIndex = parameter.SkipCount, EndIndex = parameter.TakeCount }); int totalCount = DbHelper.QuerySingle <int>($"select count(0) from ({innersqlstr}) t "); return(new PagedResult <BaseAuditList> { PageIndex = parameter.PageIndex, PageSize = parameter.PageSize, TotalItemCount = totalCount, Items = modelList }); }