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