public Task <List <NewsContentInfo> > GetNewsDetail(int newsID, int userID) { return(Task.Run(() => { using (MIUEntities db = new MIUEntities()) { List <NewsContent> dataList = db.NewsContents.Where(a => a.NewsId == newsID).ToList(); List <NewsContentInfo> infoList = new List <NewsContentInfo>(); foreach (var data in dataList) { NewsContentInfo info = new NewsContentInfo(); PropertyCopier <NewsContent, NewsContentInfo> .Copy(data, info); if (!string.IsNullOrEmpty(info.TextContent)) { info.ContentType = "Text"; } else if (!string.IsNullOrEmpty(info.PhotoPath)) { info.ContentType = "Photo"; info.ContentPath = MIUFileServer.GetFileUrl("News/ContentPhoto", info.PhotoPath); } else { info.ContentType = "File"; info.ContentPath = MIUFileServer.GetFileUrl("News/ContentFile", info.DocPath); } infoList.Add(info); } return infoList; } })); }
/// <summary> /// Newses the content_ selectbync_n_gid. /// </summary> /// <param name="nc_n_gid">The nc_n_gid.</param> /// <returns></returns> public List <NewsContentInfo> NewsContent_Selectbync_n_gid(string nc_n_gid) { string SQL = string.Format(@"Select * From NewsContent_{0} WHERE nc_n_gid=@nc_n_gid Order by nc_order,nc_id", getContentTableBy(nc_n_gid)); DbCommand dbCommandWrapper = Db_0.GetSqlStringCommand(SQL); Db_0.AddInParameter(dbCommandWrapper, "@nc_n_gid", DbType.String, nc_n_gid); try { List <NewsContentInfo> lst = new List <NewsContentInfo>(); using (IDataReader reader = Db_0.ExecuteReader(dbCommandWrapper)) { while (reader.Read()) { NewsContentInfo obj = new NewsContentInfo(); obj.nc_id = (int)reader["nc_id"]; obj.nc_title = reader["nc_title"].ToString(); obj.nc_simg_url = reader["nc_simg_url"].ToString(); obj.nc_bimg_url = reader["nc_bimg_url"].ToString(); obj.nc_content = reader["nc_content"].ToString(); obj.nc_createTime = (DateTime)reader["nc_createTime"]; obj.nc_shortcreateTime = ((DateTime)reader["nc_createTime"]).ToShortDateString(); obj.nc_createUser = reader["nc_createUser"].ToString(); obj.nc_order = (int)reader["nc_order"]; obj.nc_n_gid = reader["nc_n_gid"].ToString(); lst.Add(obj); } reader.NextResult(); } return(lst); } catch (Exception e) { throw new Exception(e.Message); } }