/// <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; }