//时间序号检索
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;
}
