/// <summary>
/// 充值记录
/// </summary>
/// <param name="insureSearchFilter"></param>
/// <returns></returns>
public PagerSet GetShareDetailInfo(InsureSearchFilter insureSearchFilter)
{
string whereForAll = string.Format("WHERE UserID={0} AND (ApplyDate BETWEEN '{1}' AND '{2}')", insureSearchFilter.UserID, insureSearchFilter.OperateDateScope[0], insureSearchFilter.OperateDateScope[1]);
string orderQuery = "ORDER By ApplyDate DESC";
PagerParameters pager = new PagerParameters("ShareDetailInfo", orderQuery, whereForAll, insureSearchFilter.PageIndex, insureSearchFilter.PageSize);
pager.CacherSize = 2;
return(GetPagerSet2(pager));
}
/// <summary>
/// 交易记录
/// </summary>
/// <param name="insureSearchFilter"></param>
/// <returns></returns>
public PagerSet GetInsureTradeRecord(InsureSearchFilter insureSearchFilter)
{
string whereForAll = "";
string whereForTradeType = "";
string whereForTradeType2 = "";
if (insureSearchFilter.OperateDateScope != null)
{
whereForAll = string.Format("WHERE (CollectDate BETWEEN '{1}' AND '{2}') AND (SourceUserID={0} OR TargetUserID={0})", insureSearchFilter.UserID, insureSearchFilter.OperateDateScope[0], insureSearchFilter.OperateDateScope[1]);
whereForTradeType = string.Format("WHERE (CollectDate BETWEEN '{2}' AND '{3}') AND TradeType ={1} AND SourceUserID={0}", new object[] { insureSearchFilter.UserID, (int)insureSearchFilter.TradeType, insureSearchFilter.OperateDateScope[0], insureSearchFilter.OperateDateScope[1] });
whereForTradeType2 = string.Format("WHERE (CollectDate BETWEEN '{2}' AND '{3}') AND TradeType ={1} AND TargetUserID={0}", new object[] { insureSearchFilter.UserID, 3, insureSearchFilter.OperateDateScope[0], insureSearchFilter.OperateDateScope[1] });
}
else
{
whereForAll = string.Format("WHERE (SourceUserID={0} OR TargetUserID={0})", insureSearchFilter.UserID);
whereForTradeType = string.Format("WHERE TradeType ={1} AND SourceUserID={0}", insureSearchFilter.UserID, (int)insureSearchFilter.TradeType);
whereForTradeType2 = string.Format("WHERE TradeType ={1} AND TargetUserID={0}", insureSearchFilter.UserID, 3);
}
string orderQuery = "ORDER By CollectDate DESC";
string[] returnField = new string[] { "SourceUserID", "TargetUserID", "SwapScore", "Revenue", "TradeType", "CollectDate", "CollectNote" };
PagerParameters pager = new PagerParameters("RecordInsure", orderQuery, "RecordID", insureSearchFilter.PageIndex, insureSearchFilter.PageSize);
pager.Fields = returnField;
pager.CacherSize = 2;
if (insureSearchFilter.TradeType == InsureTradeType.Unknown)
{
pager.WhereStr = whereForAll;
}
else if (insureSearchFilter.TradeType == InsureTradeType.TransferIn)
{
pager.WhereStr = whereForTradeType2;
}
else
{
pager.WhereStr = whereForTradeType;
}
return(this.GetPagerSet2(pager));
}
/// <summary>
/// 交易记录
/// </summary>
/// <param name="insureSearchFilter"></param>
/// <returns></returns>
public PagerSet GetInsureTradeRecord(InsureSearchFilter insureSearchFilter)
{
return(treasureData.GetInsureTradeRecord(insureSearchFilter));
}
/// <summary>
/// 充值记录
/// </summary>
/// <param name="insureSearchFilter"></param>
/// <returns></returns>
public PagerSet GetShareDetailInfo(InsureSearchFilter insureSearchFilter)
{
return(treasureData.GetShareDetailInfo(insureSearchFilter));
}
