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