/// <summary>
/// 获取符合查询条件的订单
/// </summary>
/// <param name="pageIndex">页码</param>
/// <param name="status">订单状态（0：未付款 1：已付款，卖家未发货 2：交易成功）</param>
/// <param name="orderId">订单id</param>
/// <param name="tradeNo">支付宝订单号</param>
/// <param name="buyer">买家用户名</param>
/// <param name="submitStartTime">查询提交开始时间</param>
/// <param name="submitLastTime">查询提交结束时间</param>
/// <param name="confirmStartTime">查询确认开始时间</param>
/// <param name="confirmLastTime">查询确认结束时间</param>
/// <returns></returns>
public static ASEWH.Common.Generic.List<CreditOrderInfo> GetCreditOrderList(int pageIndex, int status, int orderId, string tradeNo, string buyer, string submitStartTime, string submitLastTime, string confirmStartTime, string confirmLastTime)
{
ASEWH.Common.Generic.List<CreditOrderInfo> list = new ASEWH.Common.Generic.List<CreditOrderInfo>();
IDataReader reader = DatabaseProvider.GetInstance().GetCreditOrderList(pageIndex, status, orderId, tradeNo, buyer, submitStartTime, submitLastTime, confirmStartTime, confirmLastTime);
if (reader != null)
{
while (reader.Read())
{
list.Add(LoadCreditOrderInfo(reader));
}
reader.Close();
}
return list;
}
/// <summary>
/// 根据主题的Tag获取相关主题(游客可见级别的)
/// </summary>
/// <param name="topicid">主题Id</param>
/// <returns></returns>
public static ASEWH.Common.Generic.List<TopicInfo> GetRelatedTopicList(int topicId, int count)
{
IDataReader reader = DatabaseProvider.GetInstance().GetRelatedTopics(topicId, count);
ASEWH.Common.Generic.List<TopicInfo> topics = new ASEWH.Common.Generic.List<TopicInfo>();
while (reader.Read())
{
TopicInfo topic = new TopicInfo();
topic.Tid = TypeConverter.ObjectToInt(reader["linktid"]);
topic.Title = reader["linktitle"].ToString();
topics.Add(topic);
}
reader.Close();
return topics;
}
/// <summary>
/// 获取用户拥有的邀请码列表(封闭)
/// </summary>
/// <param name="creatorid"></param>
/// <param name="pageindex"></param>
/// <param name="pagesize"></param>
/// <returns></returns>
public static ASEWH.Common.Generic.List<InviteCodeInfo> GetUserInviteCodeList(int creatorId, int pageIndex)
{
ASEWH.Common.Generic.List<InviteCodeInfo> list = new ASEWH.Common.Generic.List<InviteCodeInfo>();
IDataReader reader = DatabaseProvider.GetInstance().GetUserInviteCodeList(creatorId, pageIndex);
while (reader.Read())
{
list.Add(LoadInviteCode(reader));
}
reader.Close();
return list;
}
