/// <summary>
/// 根据用户id,支付状态，交易类型获取最近一次交易信息
/// </summary>
/// <param name="uid"></param>
/// <param name="state"></param>
/// <param name="changes_type"></param>
/// <returns></returns>
public Hashtable GetLatestUserFinancialInfo(string uid, UserFinancialState state, UserFinancialChangesType changes_type)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"select ID,UserID,OrderNum,ChangesTime,ChangesAmount,ChangesType,CurrentBalance,Remark,OperatorWay,OrderPayID from YR_UserFinancial where State=@State and ChangesType=@ChangesType and UserID=@UserID");
SqlParam[] sqlparams = new SqlParam[] {
new SqlParam("@UserID", uid),
new SqlParam("@State", state.GetHashCode()),
new SqlParam("@ChangesType", changes_type.GetHashCode())
};
sql.Append(" order by ChangesTime desc");
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sql, sqlparams);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
else
{
return(DataTableHelper.DataRowToHashTable(dt.Rows[0]));
}
}
/// <summary>
/// 根据支付状态，交易类型获取交易信息列表
/// </summary>
/// <param name="uid"></param>
/// <param name="begintime"></param>
/// <param name="endtime"></param>
/// <param name="state"></param>
/// <param name="changes_type"></param>
/// <returns></returns>
public DataTable GetUserFinancialList(string uid, DateTime?begintime, DateTime?endtime, UserFinancialState state, UserFinancialChangesType?changes_type)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"select ID,UserID,OrderNum,ChangesAmount,ChangesType,CurrentBalance,Remark,ChangesTime,OperatorWay,OrderPayID from YR_UserFinancial where State=@State");
if (!string.IsNullOrEmpty(uid))
{
sql.Append(" and UserID='" + uid + "'");
}
if (endtime.HasValue)
{
sql.Append(" and ChangesTime>='" + begintime.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'");
}
if (begintime.HasValue)
{
sql.Append(" and ChangesTime<='" + endtime.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'");
}
if (changes_type.HasValue)
{
sql.Append(" and ChangesType=" + changes_type.Value.GetHashCode());
}
SqlParam[] sqlparams = new SqlParam[] {
new SqlParam("@State", state.GetHashCode())
};
sql.Append(" order by ChangesTime asc");
DataTable dt = DataFactory.SqlDataBase().GetDataTableBySQL(sql, sqlparams);
return(dt);
}
