public override void QueryForBeforeRequestIn3M(out TopicStatusCollection experiesTopicStatus, out List<int> autoFinalQuestionThreadIds, out Dictionary<int, Dictionary<int, int>> autoFinalQuestionForumIDAndRewards)
{
//供放置查出的已经过期的提问
//List<Question> expiresQuestions = new List<Question>();
List<QuestionThread> expiresQuestions = new List<QuestionThread>();
Dictionary<int, int> threadIDAndPostUserIDs = new Dictionary<int, int>();
Dictionary<int, int> threadIDAndForumIDs = new Dictionary<int, int>();
autoFinalQuestionThreadIds = new List<int>();
using (SqlQuery query = new SqlQuery())
{
query.CommandText = "bx_QueryForBeforeRequestIn3M";
query.CommandType = CommandType.StoredProcedure;
query.CommandTimeout = 30;
try
{
if (IsAutoFinalQuestion == true)
{
experiesTopicStatus = new TopicStatusCollection();
autoFinalQuestionForumIDAndRewards = new Dictionary<int, Dictionary<int, int>>();
return;
}
IsAutoFinalQuestion = true;
using (XSqlDataReader reader = query.ExecuteReader())
{
experiesTopicStatus = new TopicStatusCollection(reader);
reader.NextResult();
while (reader.Read())
{
//Question question = ConvertData.ConvertToQuestion(reader);
QuestionThread question = new QuestionThread();
question.ThreadID = reader.Get<int>(reader.GetOrdinal("ThreadID"));
question.FillQuestion(reader);
expiresQuestions.Add(question);
int forumID = reader.Get<int>("ForumID");
threadIDAndForumIDs.Add(question.ThreadID, forumID);
threadIDAndPostUserIDs.Add(question.ThreadID, reader.GetInt32(reader.GetOrdinal("PostUserID")));
}
}
query.CommandText = "bx_AutoFinalQuestion";
query.CommandType = CommandType.StoredProcedure;
query.CommandTimeout = 30;
autoFinalQuestionForumIDAndRewards = new Dictionary<int, Dictionary<int, int>>();
foreach (QuestionThread q in expiresQuestions)
{
int forumID;
if (threadIDAndForumIDs.ContainsKey(q.ThreadID))
forumID = threadIDAndForumIDs[q.ThreadID];
else
continue;
query.Parameters.Clear();
query.CreateParameter<int>("@ThreadID", q.ThreadID, SqlDbType.Int);
query.CreateParameter<int>("@UserID", threadIDAndPostUserIDs[q.ThreadID], SqlDbType.Int);
query.CreateParameter<int>("@RewardCount", q.RewardCount, SqlDbType.Int);
query.CreateParameter<int>("@TotalReward", q.Reward, SqlDbType.Int);
if (autoFinalQuestionForumIDAndRewards.ContainsKey(forumID) == false)
autoFinalQuestionForumIDAndRewards.Add(forumID, new Dictionary<int, int>());
using (XSqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
int userID = reader.Get<int>("UserID");
int reward = reader.Get<int>("Reward");
if (autoFinalQuestionForumIDAndRewards[forumID].ContainsKey(userID))
{
autoFinalQuestionForumIDAndRewards[forumID][userID] = autoFinalQuestionForumIDAndRewards[forumID][userID] + reward;
}
else
{
autoFinalQuestionForumIDAndRewards[forumID].Add(userID, reward);
}
}
}
if (!autoFinalQuestionThreadIds.Contains(q.ThreadID))
autoFinalQuestionThreadIds.Add(q.ThreadID);
}
IsAutoFinalQuestion = false;
}
catch (Exception ex)
{
IsAutoFinalQuestion = false;
throw ex;
}
}
}
