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