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