public List<ThreadDetail> GetCSDNThreads()
{
List<ThreadDetail> list = new List<ThreadDetail>();
SqlConnection sql = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = _cmd;
cmd.Connection = sql;
cmd.CommandType = CommandType.Text;
try
{
sql.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
// List<ThreadDetail> threads=reader.autoMa
while (reader.Read())
{
ThreadDetail thread = new ThreadDetail();
thread.Team = (reader["TeamName"] is DBNull) ? "" : reader["TeamName"].ToString();
thread.IsAnswered = (reader["IsAnswered"] is DBNull) ? "" : reader["IsAnswered"].ToString();
thread.Owner = (reader["Alias"] is DBNull) ? "" : (reader["Alias"]).ToString();
thread.Title = (reader["ThreadTitle"] is DBNull) ? "" : (reader["ThreadTitle"]).ToString();
thread.URL = (reader["ThreadLink"] is DBNull) ? "" : (reader["ThreadLink"]).ToString();
thread.TechCategory = (reader["TechCategoryName"] is DBNull) ? "" : (reader["TechCategoryName"]).ToString(); //reader["TechCategoryName"]
thread.IssueType = (reader["IssueTypeName"] is DBNull) ? "" : (reader["IssueTypeName"]).ToString();// reader["IssueTypeName"]
thread.IR = (reader["IRT"] is DBNull) ? "" : (reader["IRT"].ToString());
thread.CreateOn = (reader["ThreadCreateTime"] is DBNull) ? null : (DateTime?)reader["ThreadCreateTime"]; ;// (DateTime?)reader["ThreadCreateTime"];
thread.FirstReply = (reader["FirstReplyTime"] is DBNull) ? null : (DateTime?)reader["FirstReplyTime"];
thread.Labor = (reader["Labors"] is DBNull) ? null : (double?)(reader["Labors"]); //reader["UT"];
thread.Replies = (reader["ReplyNum"] is DBNull) ? 0 : Convert.ToInt16(reader["ReplyNum"] ?? 0);
thread.CssAction = (reader["CSSActionName"] is DBNull) ? "" : (reader["CSSActionName"]).ToString(); //reader["CSSActionName"]
thread.Replied = (reader["IsReplied"] is DBNull) ? "" : reader["IsReplied"].ToString();
thread.Difficulty = (reader["Diffcult"] is DBNull) ? "" : (reader["Diffcult"]).ToString(); //reader["Diffcult"]
thread.CustomLooking = (reader["Labors"] is DBNull) ? "" : (reader["CustomerLookingFor"] ?? "").ToString();// reader["CustomerLookingFor"];
thread.DayToAnswer = "";
thread.Contribution = "";
list.Add(thread);
}
}
}
}
catch(Exception e)
{
}
finally { sql.Close(); }
return list;
}
public ThreadDetail GetThread()
{
ThreadDetail thread = new ThreadDetail();
thread.Team = "1";
thread.IsAnswered = "Yes";
thread.Owner = "v-jayao";
thread.Title = "ADO.NET classes in .NET 2.0 / 3.5哪个在windows azure不被支持？为保证我的程序在windows azure兼容，对于这些版本需要做哪些处理方法";
thread.URL = "http://ask.csdn.net/questions/168465";
thread.TechCategory = "General Discussion";
thread.IssueType = "Mooncake feature - General Discussion";
thread.IR = "359";
thread.CreateOn = Convert.ToDateTime("2015-03-04 17:08:00.000");
thread.FirstReply = null;
thread.Labor = 24;
thread.Replies = 3;
thread.CssAction = "Answered";
thread.Replied = "Yes";
thread.Difficulty = "test";
thread.CustomLooking = "test";
thread.DayToAnswer = "test";
return thread;
}
