/// <summary>
/// 获取UV充值记录
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public Respbase <List <UVChargeHisDto> > GetUVChargeHis(UVRechargeHisReq req)
{
string sql = string.Format(@"select Transid,Amount,Createtime,BalanceAfter1,ShowName from (
select t1.*,t2.balance_after/100 BalanceAfter1,t1.remarks ShowName,ROWNUM AS rowno from Tfin_Billtrans t1
left join tblc_user_purse_his t2 on t1.transferids=t2.transferid
where t1.paytype=4 and t1.status=1 and t1.chargetype=20 and t1.nodeid={0} and t2.ownerid={0} AND ROWNUM <= {2} order by t1.createtime desc)ttt WHERE ttt.rowno > {1}", req.Nodeid, (req.PageIndex - 1) * req.PageCount, req.PageIndex * req.PageCount);
var result = db.Database.SqlQuery <UVChargeHisDto>(sql).ToList();
return(new Respbase <List <UVChargeHisDto> >()
{
Data = result
});
}
public Respbase <List <UVChargeHisDto> > GetUVChargeHis(UVRechargeHisReq req)
{
var result = purseFacade.GetUVChargeHis(req);
return(result);
}
