/// <summary>
/// 获取某一条新闻类型
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public NewsType GetItem(string id)
{
NewsType newsType = new NewsType();
string sql = "select * from NewsType where Id=" + id;
DataTable dt = DataMake.DataTableRead(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
newsType.Id = (int)dt.Rows[i]["Id"];
newsType.NewsTypeName_zh = dt.Rows[i]["NewsTypeName_zh"].ToString();
newsType.NewsTypeName_en = dt.Rows[i]["NewsTypeName_en"].ToString();
newsType.NewsTypeRemark = dt.Rows[i]["NewsType_Remark"].ToString();
}
}
return newsType;
}
/// <summary>
/// 获取所有新闻类型
/// </summary>
/// <returns></returns>
public List<NewsType> GetItems()
{
List<NewsType> newsTypeList = new List<NewsType>();
string sql = "select * from NewsType";
DataTable dt = DataMake.DataTableRead(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
NewsType newsType = new NewsType();
newsType.Id = (int)dt.Rows[i]["Id"];
newsType.NewsTypeName_zh = dt.Rows[i]["NewsTypeName_zh"].ToString();
newsType.NewsTypeName_en = dt.Rows[i]["NewsTypeName_en"].ToString();
newsType.NewsTypeRemark = dt.Rows[i]["NewsType_Remark"].ToString();
newsTypeList.Add(newsType);
}
}
return newsTypeList;
}
/// <summary>
/// 获取所有新闻类型
/// </summary>
/// <returns></returns>
public List<NewsType> GetItems(int pageIndex,int pageSize)
{
List<NewsType> newsTypeList = new List<NewsType>();
string sql = "SELECT TOP "+pageSize+" * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY Id) AS RowNumber,* FROM NewsType) A WHERE RowNumber > "+pageSize+"*("+pageIndex+"-1)";
DataTable dt = DataMake.DataTableRead(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
NewsType newsType = new NewsType();
newsType.Id = (int)dt.Rows[i]["Id"];
newsType.NewsTypeName_zh = dt.Rows[i]["NewsTypeName_zh"].ToString();
newsType.NewsTypeName_en = dt.Rows[i]["NewsTypeName_en"].ToString();
newsType.NewsTypeRemark = dt.Rows[i]["NewsType_Remark"].ToString();
newsTypeList.Add(newsType);
}
}
return newsTypeList;
}
