/// <summary> /// 获取我的余额 /// 平扬 /// 2015年3月23日 11:40:56 /// </summary> /// <param name="model"></param> /// <returns></returns> public PageInfo <IncomeModel> GetMyIncomeList(MyIncomeSearchCriteria model) { //string sqlwhere = " Amount > 0 "; if (string.IsNullOrEmpty(model.phoneNo)) { return(null); } StringBuilder where = new StringBuilder(); where.AppendFormat(" C.PhoneNo= '{0}' AND IsDel = 0 ", model.phoneNo.Trim()); string column = @"Amount as MyInComeAmount, (CASE WHEN Amount>0 THEN '收入' ELSE '支出' END ) AS MyIncome1, CreateTime as InsertTime"; return(new PageHelper().GetPages <IncomeModel>(SuperMan_Read, model.PagingRequest.PageIndex, where.ToString(), " r.id desc ", column, " Records R (nolock) join clienter C (nolock) on R.UserId=C.Id ", model.PagingRequest.PageSize, true)); }
public ResultModel <MyBalanceListResultModel[]> GetMyBalanceDynamic(string phoneNo, int?pagedSize, int?pagedIndex) { int pIndex = ParseHelper.ToInt(pagedIndex.HasValue, 1); int pSize = ParseHelper.ToInt(pagedSize.HasValue, PageSizeType.App_PageSize.GetHashCode()); var criteria = new MyIncomeSearchCriteria() { PagingRequest = new PagingResult(pIndex, pSize), phoneNo = phoneNo }; var withrecord = new WtihdrawRecordsProvider(); var pagedList = withrecord.GetMyIncomeList(criteria); var lists = MyBalanceListResultModelTranslator.Instance.Translate(pagedList); return(ResultModel <MyBalanceListResultModel[]> .Conclude(RushOrderStatus.Success, lists.ToArray())); }
/// <summary> /// 获取我的余额 平扬 2015.3.23 /// </summary> /// <param name="criteria"></param> /// <returns></returns> public Model.Common.NewPagedList <IncomeModel> GetMyIncomeList(MyIncomeSearchCriteria criteria) { try { var withDao = new WtihdrawRecordsDao(); var reslut = withDao.GetMyIncomeList(criteria); var list = new NewPagedList <IncomeModel>(reslut.Records); var pageresult = new NewPagingResult(criteria.PagingRequest.PageIndex, criteria.PagingRequest.PageSize) { TotalCount = reslut.All, RecordCount = reslut.Records.Count }; list.PagingResult = pageresult; return(list); } catch (Exception ex) { LogHelper.LogWriterFromFilter(ex); return(null); } return(null); }