//时间序号检索 public static List <Model.SeletedModel> GetDataListByDate(string option, int count, int articleType) { List <Model.SeletedModel> dataList = new List <Model.SeletedModel>(); StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select top(@count) * from (select Title,'/Common/ShowDetail/'+cast(ID as varchar(8)) as Url ,CONVERT(varchar(100) ,PubDate, 112)AS PubDate,Content,CoverUrl from News where ArticleType=@ArticleType)a where PubDate like @SelectedID "); SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@count", SqlDbType.Int) { Value = count }, new SqlParameter("@SelectedID", SqlDbType.NVarChar) { Value = option + "%" }, new SqlParameter("@ArticleType", SqlDbType.Int) { Value = articleType } }; SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.SqlConnectionString, CommandType.Text, sqlStr.ToString(), paramList); while (dr.Read()) { Model.SeletedModel oneData = new Model.SeletedModel(); oneData.Title = dr["Title"].ToString(); oneData.ShowUrl = dr["Url"].ToString(); oneData.zhaiyao = dr["Content"].ToString().Substring(0, dr["Content"].ToString().Length < 200?dr["Content"].ToString().Length:200) + "..."; oneData.CoverUrl = dr["CoverUrl"].ToString(); dataList.Add(oneData); } return(dataList); }
//时间序号检索 public static List<Model.SeletedModel> GetDataListByDate(string option, int count, int articleType) { List<Model.SeletedModel> dataList = new List<Model.SeletedModel>(); StringBuilder sqlStr = new StringBuilder(); sqlStr.Append("select top(@count) * from (select Title,'/Common/ShowDetail/'+cast(ID as varchar(8)) as Url ,CONVERT(varchar(100) ,PubDate, 112)AS PubDate,Content,CoverUrl from News where ArticleType=@ArticleType)a where PubDate like @SelectedID "); SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@count",SqlDbType.Int){Value=count}, new SqlParameter("@SelectedID", SqlDbType.NVarChar) { Value=option+"%"}, new SqlParameter("@ArticleType",SqlDbType.Int){Value=articleType} }; SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.SqlConnectionString,CommandType.Text,sqlStr.ToString(),paramList); while (dr.Read()) { Model.SeletedModel oneData = new Model.SeletedModel(); oneData.Title = dr["Title"].ToString(); oneData.ShowUrl = dr["Url"].ToString(); oneData.zhaiyao = dr["Content"].ToString().Substring(0, dr["Content"].ToString().Length <200?dr["Content"].ToString().Length:200)+"..."; oneData.CoverUrl = dr["CoverUrl"].ToString(); dataList.Add(oneData); } return dataList; }