public List <PrepayRecord> getRechargeRecordListInfoData(string Uid)
{
List <PrepayRecord> list = null;
try
{
if (string.IsNullOrEmpty(Uid))
{
return(null);
}
IParameterMapper ipmapper = new getPrepayRecordListInfoDataParameterMapper();
DataAccessor <PrepayRecord> tableAccessor;
//string strSql = @"select p.AddMoney,p.BillPayId,p.PayModel,p.PrepayDate,p.PrepayMoney,p.PresentMoney,p.PromotionId,p.RecordId,p.RstId,p.SId,p.Uid,p.UserId
// from PrepayRecord p where p.Uid=@Uid and p.PrepayMoney>0 and p.PrepayDate between dateadd (MM,-1,GETDATE()) and getdate() order by p.PrepayDate desc";
string strSql = @"
select top 10 p.* from PrepayRecord p
left join OrderBillPay b on b.PayId = p.BillPayId
where p.Uid=@Uid and p.PrepayMoney>0 and b.PayState = '0x01'--0x01:支付成功
order by p.PrepayDate desc";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <PrepayRecord> .MapAllProperties()
.Map(t => t.Uid).ToColumn("Uid")
.Map(t => t.AddMoney).ToColumn("AddMoney")
.Map(t => t.PayModel).ToColumn("PayModel")
.Map(t => t.PrepayDate).ToColumn("PrepayDate")
.Map(t => t.PrepayMoney).ToColumn("PrepayMoney")
.Map(t => t.PresentMoney).ToColumn("PresentMoney")
.Map(t => t.PromotionId).ToColumn("PromotionId")
.Map(t => t.RecordId).ToColumn("RecordId")
.Map(t => t.UserId).ToColumn("UserId")
.Map(t => t.BillPayId).ToColumn("BillPayId")
.Map(t => t.RstId).ToColumn("RstId")
.Map(t => t.SId).ToColumn("SId")
.Build());
list = tableAccessor.Execute(new string[] { Uid }).ToList();
return(list);
}
catch (Exception ex)
{
Logger.Log(ex);
throw;
}
}
public List<PrepayRecord> getConsumptionRecordsListInfoData(string Uid)
{
List<PrepayRecord> list = null;
try
{
if (string.IsNullOrEmpty(Uid))
{
return null;
}
IParameterMapper ipmapper = new getPrepayRecordListInfoDataParameterMapper();
DataAccessor<PrepayRecord> tableAccessor;
// string strSql = @"select p.AddMoney,p.BillPayId,p.PayModel,p.PrepayDate,p.PrepayMoney,p.PresentMoney,p.PromotionId,p.RecordId,p.RstId,p.SId,p.Uid,p.UserId
// from PrepayRecord p where p.Uid=@Uid and p.PrepayMoney<0 and p.PrepayDate between dateadd (MM,-1,GETDATE()) and getdate() order by p.PrepayDate desc";
string strSql = @"
select top 10 *
from PrepayRecord p
left join OrderBillPay b on b.PayId = p.BillPayId
where p.Uid=@Uid and p.PrepayMoney<=0 and b.PayState = '0x01'--0x01:支付成功
order by p.PrepayDate desc";
tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<PrepayRecord>.MapAllProperties()
.Map(t => t.Uid).ToColumn("Uid")
.Map(t => t.AddMoney).ToColumn("AddMoney")
.Map(t => t.PayModel).ToColumn("PayModel")
.Map(t => t.PrepayDate).ToColumn("PrepayDate")
.Map(t => t.PrepayMoney).ToColumn("PrepayMoney")
.Map(t => t.PresentMoney).ToColumn("PresentMoney")
.Map(t => t.PromotionId).ToColumn("PromotionId")
.Map(t => t.RecordId).ToColumn("RecordId")
.Map(t => t.UserId).ToColumn("UserId")
.Map(t => t.BillPayId).ToColumn("BillPayId")
.Map(t => t.RstId).ToColumn("RstId")
.Map(t => t.SId).ToColumn("SId")
.Build());
list = tableAccessor.Execute(new string[] { Uid }).ToList();
return list;
}
catch (Exception ex)
{
Logger.Log(ex);
return null;
}
}
