public static IDataReader GetPageNewsComments(int newsId, int pageNumber, int pageSize, out int totalPages)
{
totalPages = 1;
IDataReader reader = DBNews.GetPageNewsComments(newsId, pageNumber, pageSize, out totalPages);
return(reader);
}
/// <summary>
/// 文章分类置顶排序
/// </summary>
/// <param name="context"></param>
private void ReadNewsCidTop(HttpContext context)
{
int intTop = RequestHelper.RequestInt("c", 1);
int intCid = RequestHelper.RequestInt("cid", 0);
Newtonsoft.Json.JavaScriptObject jsResult = new Newtonsoft.Json.JavaScriptObject();
Newtonsoft.Json.JavaScriptObject jsList = new Newtonsoft.Json.JavaScriptObject();
DataSet ds = new DBNews().WebGetDataListByCidOrderByTopWeight(intCid, intTop);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int i = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
Newtonsoft.Json.JavaScriptObject jsItem = new Newtonsoft.Json.JavaScriptObject();
jsItem.Add("id", dr["ID"]);
jsItem.Add("title", dr["Title"]);
jsList.Add(i.ToString(), jsItem);
i++;
}
jsResult.Add("list", jsList);
jsResult.Add("msg", "获取数据成功");
jsResult.Add("result", "1");
}
else
{
jsResult.Add("msg", "没有数据");
jsResult.Add("result", "0");
}
context.Response.Write(Newtonsoft.Json.JavaScriptConvert.SerializeObject(jsResult));
}
public bool SaveState(int lastWorkflowStateId = -1)
{
bool result = DBNews.UpdateState(this.newsID, this.StateId, this.approvedUtc, this.approvedUserGuid, this.approvedBy, this.rejectedNotes);
if (result)
{
if (this.stateID == lastWorkflowStateId)
{
if (!this.isPublished)
{
this.isPublished = true;
this.Save();
}
}
else if (this.isPublished)
{
this.isPublished = false;
this.Save();
}
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
/// <summary>
/// Gets a news
/// </summary>
/// <param name="NewsID">The news identifier</param>
/// <returns>News</returns>
public static News GetNewsByID(int NewsID)
{
if (NewsID == 0)
{
return(null);
}
string key = string.Format(NEWS_BY_ID_KEY, NewsID);
object obj2 = NopCache.Get(key);
if (NewsManager.CacheEnabled && (obj2 != null))
{
return((News)obj2);
}
DBNews dbItem = DBProviderManager <DBNewsProvider> .Provider.GetNewsByID(NewsID);
News news = DBMapping(dbItem);
if (NewsManager.CacheEnabled)
{
NopCache.Max(key, news);
}
return(news);
}
public static void DisplayNews(GameClient client)
{
// N,chanel(0/1/2),index(0-4),string time,\"news\"
for (int type = 0; type <= 2; type++)
{
int index = 0;
string realm = string.Empty;
// we can see all captures
IList <DBNews> newsList;
if (type > 0)
{
newsList = GameServer.Database.SelectObjects <DBNews>(
"`Type` = @Type AND (`Realm` = @DefaultRealm OR `Realm` = @Realm)",
new[] { new QueryParameter("@Type", type), new QueryParameter("@DefaultRealm", 0), new QueryParameter("@Realm", realm) });
}
else
{
newsList = GameServer.Database.SelectObjects <DBNews>("`Type` = @Type", new QueryParameter("@Type", type));
}
newsList = newsList.OrderByDescending(it => it.CreationDate).Take(5).ToArray();
int n = newsList.Count;
while (n > 0)
{
n--;
DBNews news = newsList[n];
client.Out.SendMessage(string.Format("N,{0},{1},{2},\"{3}\"", news.Type, index++, RetElapsedTime(news.CreationDate), news.Text), eChatType.CT_SocialInterface, eChatLoc.CL_SystemWindow);
}
}
}
internal static void DeleteNew(int id)
{
int count1 = newStack.Count;
using (SampleContext context = new SampleContext())
{
DBNews rowNews = context.news.SingleOrDefault(x => x.newsId == id);
if (rowNews != null)
{
context.news.Remove(rowNews);
context.SaveChanges();
List <DBNews> newsList = new List <DBNews>();
foreach (var item in newStack)
{
newsList.Add(item);
}
int countstart = newsList.Count;
newsList.RemoveAll(x => x.newsId == rowNews.newsId);
newStack.Clear();
foreach (var item in newsList)
{
newStack.Push(item);
}
int count2 = newStack.Count;
}
}
}
public static void CreateNews(string message, eRealm realm, eNewsType type, bool sendMessage)
{
if (sendMessage)
{
foreach (GameClient client in WorldMgr.GetAllClients())
{
if (client.Player == null)
{
continue;
}
if ((client.Account.PrivLevel != 1 || realm == eRealm.None) || client.Player.Realm == realm)
{
client.Out.SendMessage(message, eChatType.CT_System, eChatLoc.CL_SystemWindow);
}
}
}
if (ServerProperties.Properties.RECORD_NEWS)
{
DBNews news = new DBNews();
news.Type = (byte)type;
news.Realm = (byte)realm;
news.Text = message;
GameServer.Database.AddObject(news);
GameEventMgr.Notify(DatabaseEvent.NewsCreated, new NewsEventArgs(news));
}
}
public static void DisplayNews(GameClient client)
{
// N,chanel(0/1/2),index(0-4),string time,\"news\"
for (int type = 0; type <= 2; type++)
{
int index = 0;
string realm = "";
//we can see all captures
IList <DBNews> newsList;
if (type > 0)
{
newsList = DOLDB <DBNews> .SelectObjects(DB.Column(nameof(DBNews.Type)).IsEqualTo(type).And(DB.Column(nameof(DBNews.Realm)).IsEqualTo(0).Or(DB.Column(nameof(DBNews.Realm)).IsEqualTo(realm))));
}
else
{
newsList = DOLDB <DBNews> .SelectObjects(DB.Column(nameof(DBNews.Type)).IsEqualTo(type));
}
newsList = newsList.OrderByDescending(it => it.CreationDate).Take(5).ToArray();
int n = newsList.Count;
while (n > 0)
{
n--;
DBNews news = newsList[n];
client.Out.SendMessage(string.Format("N,{0},{1},{2},\"{3}\"", news.Type, index++, RetElapsedTime(news.CreationDate), news.Text), eChatType.CT_SocialInterface, eChatLoc.CL_SystemWindow);
}
}
}
public static void DisplayNews(GameClient client)
{
// N,chanel(0/1/2),index(0-4),string time,\"news\"
for (int type = 0; type <= 2; type++)
{
int index = 0;
string realm = "";
//we can see all captures
if (type > 0)
{
realm = " AND (Realm = 0 OR Realm = " + ((int)client.Player.Realm).ToString() + " ) ";
}
var newsList = GameServer.Database.SelectObjects <DBNews>("`Type` = '" + type + "'" + realm + " ORDER BY `CreationDate` DESC LIMIT 5");
int n = newsList.Count;
while (n > 0)
{
n--;
DBNews news = newsList[n];
client.Out.SendMessage(string.Format("N,{0},{1},{2},\"{3}\"", news.Type, index++, RetElapsedTime(news.CreationDate), news.Text), eChatType.CT_SocialInterface, eChatLoc.CL_SystemWindow);
}
}
}
public static News GetOneByZone(int zoneId, int languageId)
{
News news = new News();
PopulateNews(news, DBNews.GetSingleNews(zoneId, DateTime.UtcNow, languageId));
return(news);
}
private void BindData()
{
List<string> values = new DBNews().GetNewsTypeId(intNewTypeId);
if (values.Count >= 2)
{
txtCategoryName.Text = values[1];
}
}
public static List <News> GetByGuids(
int siteId,
string newsGuids,
int publishStatus = -1,
int languageId = -1)
{
return(LoadListFromReader(DBNews.GetByGuids(siteId, newsGuids, publishStatus, languageId)));
}
public static int GetCountByListZone(
int siteId,
string listZoneId,
int newsType,
int position,
int languageId)
{
return(DBNews.GetCountByListZone(siteId, listZoneId, newsType, position, languageId));
}
public static int GetCount(
int siteId,
int zoneId,
int languageId,
int newsType,
int position)
{
return(DBNews.GetCount(siteId, zoneId, DateTime.UtcNow, languageId, newsType, position));
}
/// <summary>
/// Persists a new instance of New. Returns true on success.
/// </summary>
/// <returns></returns>
private bool Create()
{
int newID = 0;
newsGuid = Guid.NewGuid();
createdUtc = DateTime.UtcNow;
newID = DBNews.Create(
this.siteID,
this.zoneID,
this.title,
this.subTitle,
this.url,
this.code,
this.openInNewWindow,
this.includeInSearch,
this.includeInSiteMap,
this.includeInFeed,
this.briefContent,
this.fullContent,
this.newsType,
this.position,
this.showOption,
this.isPublished,
this.startDate,
this.endDate,
this.displayOrder,
this.viewed,
this.isDeleted,
this.allowCommentsForDays,
this.commentCount,
this.metaTitle,
this.metaKeywords,
this.metaDescription,
this.additionalMetaTags,
this.compiledMeta,
this.fileAttachment,
this.newsGuid,
this.userGuid,
this.createdUtc,
this.lastModUtc,
this.lastModUserGuid);
this.newsID = newID;
bool result = (newID > 0);
//IndexHelper.IndexItem(this);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
public static bool AddNewsComment(
int newsId,
String name,
String title,
String url,
String comment,
String address,
String email,
String phone,
String attachFile1,
String attachFile2,
DateTime dateCreated)
{
if (name == null)
{
name = "unknown";
}
if (name.Length < 1)
{
name = "unknown";
}
if ((title != null) && (url != null) && (comment != null))
{
if (title.Length > 100)
{
title = title.Substring(0, 100);
}
if (name.Length > 100)
{
name = name.Substring(0, 100);
}
if (url.Length > 200)
{
url = url.Substring(0, 200);
}
return(DBNews.AddNewsComment(
newsId,
name,
title,
url,
comment,
address,
email,
phone,
attachFile1,
attachFile2,
dateCreated));
}
return(false);
}
public static List <News> GetPage(
int siteId,
int zoneId,
int languageId,
int newsType,
int position,
int pageNumber,
int pageSize)
{
return(LoadListFromReader(DBNews.GetPage(siteId, zoneId, DateTime.UtcNow, languageId, newsType, position, pageNumber, pageSize)));
}
public static List <News> GetPageNewsOther(
int zoneId,
int newsId,
int languageId,
int newsType,
int pageNumber,
int pageSize,
out int totalPages)
{
return(LoadListFromReader(DBNews.GetPageNewsOther(zoneId, newsId, DateTime.UtcNow, languageId, newsType, pageNumber, pageSize, out totalPages)));
}
public static List <News> GetPageByListZone(
int siteId,
string listZoneId,
int newsType,
int position,
int languageId,
int pageNumber,
int pageSize)
{
return(LoadListFromReader(DBNews.GetPageByListZone(siteId, listZoneId, newsType, position, languageId, pageNumber, pageSize)));
}
protected void btSave_Click(object sender, EventArgs e)
{
if (txtNewsTitle.Text.Trim().Length == 0) { Alert("请填写文章标题"); return; }
int newsType = int.Parse(ddlNewsType.SelectedValue);
int isShow = int.Parse(DropDownListIsShow.SelectedValue);
if (new DBNews().NewsSave(intNewsId, newsType, isShow, txtNewsTitle.Text.Trim(), txtNewsTitleColor.Text.Trim(), txtNewsPicture.Text.Trim(), txtNewsFrom.Text.Trim(), txtNewsAuthor.Text.Trim(), TypeHelper.ToInt(txtNewsTopWeight.Text.Trim()), TypeHelper.ToInt(txtNewsEilWeigth.Text.Trim()), TypeHelper.ToInt(txtNewsDisplayOrder.Text.Trim()), txtNewsMessage.Text.Trim()))
{
if (isShow == 1)
{
#region 文件生成
string tempPath = Server.MapPath("templates/view.html");
StringBuilder sb = new StringBuilder(1000);
if (File.Exists(tempPath))
sb.Append(File.ReadAllText(tempPath, Encoding.UTF8));
if (intNewsId == 0) { intNewsId = new DBNews().GetNewsMaxId(); }
if (intNewsId > 0)
{
Dictionary<string, string> dic = new DBNews().GetNewsById(intNewsId);
foreach (string key in dic.Keys)
sb.Replace("{" + key + "}", dic[key]);
string FileDir = Server.MapPath("/news/");
try
{
File.WriteAllText(FileDir + "/" + intNewsId + ".html", sb.ToString());
}
catch
{
}
}
#endregion
}
else if(intNewsId>0)
{
#region 删除原来的文件
string FileDir = Server.MapPath("/news/");
try
{
File.Delete(FileDir + "/" + intNewsId + ".html");
}
catch { }
#endregion
}
ExecuteJs("parent.CloseDialog();");
return;
}
else
{
Alert("保存失败");
}
}
public bool SaveDeleted()
{
bool result = DBNews.UpdateDeleted(this.newsID, this.isDeleted);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
e.IsDeleted = this.isDeleted;
OnContentChanged(e);
}
return(result);
}
public void LoadNextPrevious(int languageId)
{
using (IDataReader reader = DBNews.GetNextPreviousNews(this.newsID, this.zoneID, languageId))
{
if (reader.Read())
{
if (reader["PreviousNewsID"] != DBNull.Value)
{
this.previousNewsId = Convert.ToInt32(reader["PreviousNewsID"].ToString());
}
if (reader["NextNewsID"] != DBNull.Value)
{
this.nextNewsId = Convert.ToInt32(reader["NextNewsID"].ToString());
}
if (reader["PreviousZoneID"] != DBNull.Value)
{
this.previousZoneId = Convert.ToInt32(reader["PreviousZoneID"].ToString());
}
if (reader["NextZoneID"] != DBNull.Value)
{
this.nextZoneId = Convert.ToInt32(reader["NextZoneID"].ToString());
}
if (reader["PreviousNewsUrl"] != DBNull.Value)
{
this.previousNewsUrl = reader["PreviousNewsUrl"].ToString();
}
if (reader["PreviousNewsTitle"] != DBNull.Value)
{
this.previousNewsTitle = reader["PreviousNewsTitle"].ToString();
}
if (reader["NextNewsUrl"] != DBNull.Value)
{
this.nextNewsUrl = reader["NextNewsUrl"].ToString();
}
if (reader["NextNewsTitle"] != DBNull.Value)
{
this.nextNewsTitle = reader["NextNewsTitle"].ToString();
}
if (reader["IsFirstNews"] != DBNull.Value)
{
this.isFirstNews = Convert.ToBoolean(reader["IsFirstNews"]);
}
if (reader["IsLastNews"] != DBNull.Value)
{
this.isLastNews = Convert.ToBoolean(reader["IsLastNews"]);
}
}
}
}
public bool Delete()
{
DBNews.DeleteAllCommentsForNews(this.newsID);
bool result = DBNews.DeleteNews(this.newsID);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
e.IsDeleted = true;
OnContentChanged(e);
}
return(result);
}
public string BindNewTypeName(int intNewTypeId)
{
string s = "";
List<string> values = new DBNews().GetNewsTypeId(intNewTypeId);
if (values.Count >= 2)
{
s = values[1];
}
else
{
s ="暂无";
}
return s;
}
public static bool AddNewsComment(
int newsId,
String name,
String title,
String url,
String comment,
DateTime dateCreated)
{
if (name == null)
{
name = "unknown";
}
if (name.Length < 1)
{
name = "unknown";
}
if ((title != null) && (url != null) && (comment != null))
{
if (title.Length > 255)
{
title = title.Substring(0, 255);
}
if (name.Length > 255)
{
name = name.Substring(0, 255);
}
if (url.Length > 255)
{
url = url.Substring(0, 255);
}
return(DBNews.AddNewsComment(
newsId,
name,
title,
url,
comment,
null,
null,
null,
null,
null,
dateCreated));
}
return(false);
}
internal static void InsertRating(DBNews news, int evaluat)
{
using (SampleContext context = new SampleContext())
{
try
{
foreach (var index in context.ratings)
{
if (UserService.user.userId == index.userId && news.newsId == index.newsId)
{
return;
}
}
}
catch { }
Rating rating = new Rating();
rating.userId = UserService.user.userId;
rating.newsId = news.newsId;
rating.rating = evaluat;
context.ratings.Add(rating);
context.SaveChanges();
float sum = 0;
float count = 0;
foreach (var index in context.ratings)
{
if (index.newsId == news.newsId)
{
sum += index.rating;
++count;
}
}
float middleRating = sum / count;
context.SaveChanges();
foreach (var index in context.news)
{
if (index.newsId == news.newsId)
{
index.rating = (float)Math.Round(middleRating, 2);
}
}
news.rating = middleRating;
context.SaveChanges();
}
}
/// <summary>
/// Updates the news item
/// </summary>
/// <param name="NewsID">The news identifier</param>
/// <param name="LanguageID">The language identifier</param>
/// <param name="Title">The news title</param>
/// <param name="Short">The short text</param>
/// <param name="Full">The full text</param>
/// <param name="Published">A value indicating whether the entity is published</param>
/// <param name="AllowComments">A value indicating whether the entity allows comments</param>
/// <param name="CreatedOn">The date and time of instance creation</param>
/// <returns>News item</returns>
public static News UpdateNews(int NewsID, int LanguageID, string Title, string Short,
string Full, bool Published, bool AllowComments, DateTime CreatedOn)
{
CreatedOn = DateTimeHelper.ConvertToUtcTime(CreatedOn);
DBNews dbItem = DBProviderManager <DBNewsProvider> .Provider.UpdateNews(NewsID, LanguageID, Title, Short,
Full, Published, AllowComments, CreatedOn);
News news = DBMapping(dbItem);
if (NewsManager.CacheEnabled)
{
NopCache.RemoveByPattern(NEWS_PATTERN_KEY);
}
return(news);
}
public static int GetCountBySearch(
int siteId,
string listZoneId,
int newsType,
int isPublished,
string listStateId,
int languageId,
int position,
int showOption,
DateTime?startDateFrom,
DateTime?startDateTo,
DateTime?endDateFrom,
DateTime?endDateTo,
Guid?userGuid,
string keyword)
{
return(DBNews.GetCountBySearch(siteId, listZoneId, newsType, isPublished, listStateId, languageId, position, showOption, startDateFrom, startDateTo, endDateFrom, endDateTo, userGuid, keyword));
}
public static int GetCountBySearch2(
int siteId = -1,
string zoneIds = null,
int publishStatus = -1,
int languageId = -1,
int newsType = -1,
int position = -1,
int showOption = -1,
string newsIds = null,
string excludeNewsIds = null,
DateTime?startDate = null,
DateTime?endDate = null,
string keyword = null,
string stateIds = null,
Guid?userGuid = null)
{
return(DBNews.GetCountBySearch2(siteId, zoneIds, publishStatus, languageId, newsType, position, showOption, newsIds, excludeNewsIds, startDate, endDate, keyword, stateIds, userGuid));
}
internal static Stack <Comment> GetListComments(DBNews news)
{
Stack <Comment> commentsList = new Stack <Comment>();
Dictionary <int, bool> CommentIdIsLike = new Dictionary <int, bool>();
using (SampleContext context = new SampleContext())
{
try
{
List <int> key = (from x in context.likes where x.userId == UserService.user.userId select x.commendId).ToList();
List <bool> value = (from x in context.likes where x.userId == UserService.user.userId select x.isLike).ToList();
for (int i = 0; i <= key.Count - 1; ++i)
{
CommentIdIsLike.Add(key[i], value[i]);
}
}
catch { }
try
{
foreach (var item in context.comments)
{
if (news.newsId == item.newId)
{
if (CommentIdIsLike.ContainsKey(item.commentId))
{
item.isLikeComment = CommentIdIsLike[item.commentId];
}
else
{
item.isLikeComment = false;
}
commentsList.Push(item);
}
}
context.SaveChanges();
}
catch { }
try
{
}
catch { }
}
return(commentsList);
}
private bool Update()
{
this.lastModUtc = DateTime.UtcNow;
bool result = DBNews.Update(
this.newsID,
this.zoneID,
this.title,
this.subTitle,
this.url,
this.code,
this.openInNewWindow,
this.includeInSearch,
this.includeInSiteMap,
this.includeInFeed,
this.briefContent,
this.fullContent,
this.newsType,
this.position,
this.showOption,
this.isPublished,
this.startDate,
this.endDate,
this.displayOrder,
this.viewed,
this.isDeleted,
this.allowCommentsForDays,
this.metaTitle,
this.metaKeywords,
this.metaDescription,
this.additionalMetaTags,
this.compiledMeta,
this.fileAttachment,
this.lastModUtc,
this.lastModUserGuid);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
private static News DBMapping(DBNews dbItem)
{
if (dbItem == null)
{
return(null);
}
News item = new News();
item.NewsID = dbItem.NewsID;
item.LanguageID = dbItem.LanguageID;
item.Title = dbItem.Title;
item.Short = dbItem.Short;
item.Full = dbItem.Full;
item.Published = dbItem.Published;
item.AllowComments = dbItem.AllowComments;
item.CreatedOn = dbItem.CreatedOn;
return(item);
}
public static List <News> GetPageBySearch(
int siteId,
string listZoneId,
int newsType,
int isPublished,
string listStateId,
int languageId,
int position,
int showOption,
DateTime?startDateFrom,
DateTime?startDateTo,
DateTime?endDateFrom,
DateTime?endDateTo,
Guid?userGuid,
string keyword,
int pageNumber,
int pageSize)
{
return(LoadListFromReader(DBNews.GetPageBySearch(siteId, listZoneId, newsType, isPublished, listStateId, languageId, position, showOption, startDateFrom, startDateTo, endDateFrom, endDateTo, userGuid, keyword, pageNumber, pageSize)));
}
internal static DBNews GetNew(int id)
{
DBNews news = new DBNews();
using (SampleContext context = new SampleContext())
{
try
{
foreach (var item in context.news)
{
if (item.newsId == id)
{
news = item;
}
}
}
catch { }
}
return(news);
}
/// <summary>
/// 文章查看次数
/// </summary>
/// <param name="context"></param>
private void ReadNewsCount(HttpContext context)
{
int intId = RequestHelper.RequestInt("id");
Newtonsoft.Json.JavaScriptObject jsResult = new Newtonsoft.Json.JavaScriptObject();
if (intId > 0)
{
#region 更新查看次数
string cookieName = "read-news-" + intId;
HttpCookie cookie = context.Request.Cookies[cookieName];
if (cookie == null) //判断cookie,如果存在就不更新查看次数
{
int intCount = new DBNews().GetNewsDisplayOrder(intId, true);
cookie = new HttpCookie(cookieName);
cookie.Expires = DateTime.Now.AddDays(1);
cookie.Value = intCount.ToString();
context.Response.Cookies.Add(cookie);
jsResult.Add("count", intCount);
}
else
{
jsResult.Add("count", cookie.Value);
}
#endregion
jsResult.Add("result", 1);
}
else
{
jsResult.Add("result", 0);
jsResult.Add("msg", "错误的参数");
}
context.Response.Write(Newtonsoft.Json.JavaScriptConvert.SerializeObject(jsResult));
}
/// <summary>
/// 文章查看
/// </summary>
/// <param name="context"></param>
private void ReadNewsView(HttpContext context)
{
int intId = RequestHelper.RequestInt("id");
Newtonsoft.Json.JavaScriptObject jsResult = new Newtonsoft.Json.JavaScriptObject();
if (intId > 0)
{
List<string> values = new DBNews().WebGetNewsId(intId);
if (values.Count >= 3)
{
#region 更新查看次数
string cookieName = "read-news-" + intId;
HttpCookie cookie = context.Request.Cookies[cookieName];
if (cookie == null) //判断cookie,如果存在就不更新查看次数
{
if (new DBNews().UpdateNewsDisplayOrder(intId))
{
cookie = new HttpCookie(cookieName);
cookie.Expires = DateTime.Now.AddDays(1);
cookie.Value = intId.ToString();
context.Response.Cookies.Add(cookie);
}
}
#endregion
#region 邦定数据
Newtonsoft.Json.JavaScriptObject jsItem = new Newtonsoft.Json.JavaScriptObject();
jsItem.Add("title", values[1]);
jsItem.Add("message", values[2]);
jsItem.Add("addtime", values[3]);
jsItem.Add("count", values[4]);
jsItem.Add("from", values[5]);
jsResult.Add("data", jsItem);
#endregion
jsResult.Add("result", 1);
jsResult.Add("msg", "请求成功");
}
else
{
jsResult.Add("result", "-1");
jsResult.Add("msg", "请求的信息不存在");
}
}
else
{
jsResult.Add("result", 0);
jsResult.Add("msg", "错误的参数");
}
context.Response.Write(Newtonsoft.Json.JavaScriptConvert.SerializeObject(jsResult));
}
/// <summary>
/// 文章首页列表 2013-04-13
/// </summary>
/// <param name="cotext"></param>
private void ReadNewsList(HttpContext context)
{
int intPageIndex = RequestHelper.RequestInt("p", 1);
int intCid = RequestHelper.RequestInt("cid", 0);
int intPageSize = RequestHelper.RequestInt("pagesize", 20);
int count = 0;
if (intPageIndex <= 0) intPageIndex = 1;
Newtonsoft.Json.JavaScriptObject jsResult = new Newtonsoft.Json.JavaScriptObject();
Newtonsoft.Json.JavaScriptObject jsList = new Newtonsoft.Json.JavaScriptObject();
DataSet ds = new DBNews().WebGetDataListByNews(intPageIndex, intPageSize,intCid, out count);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int i = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
Newtonsoft.Json.JavaScriptObject jsItem = new Newtonsoft.Json.JavaScriptObject();
jsItem.Add("id", dr["ID"]);
jsItem.Add("title", dr["Title"]);
jsItem.Add("date", Convert.ToDateTime(dr["AddTime"]).ToShortDateString());
jsList.Add(i.ToString(), jsItem);
i++;
}
int pageCount = (count + intPageSize - 1) / intPageSize;
if (intPageIndex > pageCount) { intPageIndex = pageCount; }
jsResult.Add("list", jsList);
jsResult.Add("count", count);
jsResult.Add("page", intPageIndex);
jsResult.Add("pagecount", pageCount);
jsResult.Add("msg", "获取数据成功");
jsResult.Add("result", "1");
}
else
{
jsResult.Add("msg", "没有数据");
jsResult.Add("result", "0");
}
context.Response.Write(Newtonsoft.Json.JavaScriptConvert.SerializeObject(jsResult));
}
private void BindData()
{
ddlNewsType.DataSource = new DBNews().GetDataListByNewsType();
ddlNewsType.DataValueField = "ID";
ddlNewsType.DataTextField = "TypeName";
ddlNewsType.DataBind();
List<string> values = new DBNews().GetNewsId(intNewsId);
Console.WriteLine(values.Count);
if (values.Count >=13)
{
ddlNewsType.Text = values[0];
DropDownListIsShow.Text = values[1];
txtNewsTitle.Text = values[2];
txtNewsTitleColor.Text = values[3];
txtNewsPicture.Text = values[4];
txtNewsFrom.Text = values[5];
txtNewsAuthor.Text = values[6];
txtNewsTopWeight.Text = values[7];
txtNewsEilWeigth.Text = values[8];
txtNewsDisplayOrder.Text = values[9];
txtNewsMessage.Text = values[10];
}
}
/// <summary>
/// 文章分类 2013-04-13
/// </summary>
/// <param name="context"></param>
private void ReadNewstypeList(HttpContext context)
{
Newtonsoft.Json.JavaScriptObject jsResult = new Newtonsoft.Json.JavaScriptObject();
Newtonsoft.Json.JavaScriptObject jsList = new Newtonsoft.Json.JavaScriptObject();
DataSet ds = new DBNews().GetDataListByNewsType();
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
int i = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
Newtonsoft.Json.JavaScriptObject jsItem = new Newtonsoft.Json.JavaScriptObject();
jsItem.Add("cid", dr["ID"]);
jsItem.Add("cname", dr["TypeName"]);
jsList.Add(i.ToString(), jsItem);
i++;
}
jsResult.Add("list", jsList);
jsResult.Add("msg", "获取数据成功");
jsResult.Add("result", "1");
}
else
{
jsResult.Add("msg", "没有数据");
jsResult.Add("result", "0");
}
context.Response.Write(Newtonsoft.Json.JavaScriptConvert.SerializeObject(jsResult));
}
