/// <summary>
/// 编辑状态
/// 创建人：lwj
/// 时间：2015-6-16
/// </summary>
/// <param name="context"></param>
private void UpdateStatus(HttpContext context)
{
string status = context.Request["status"] ?? "";
string id = context.Request["id"] ?? "";
string result = new Site_News_BLL().UpdateNewsStatus(id, status, DateTimeHelper.GetNow());
context.Response.Write(result);
}
/// <summary>
/// 添加新闻
/// 创建人：lwj
/// 时间：2015-6-15
/// </summary>
/// <param name="context"></param>
private void AddNews(HttpContext context)
{
string title = context.Request["title"] ?? "";
string content = context.Request["content"] ?? "";
string source = context.Request["source"] ?? "";
string subtitle = context.Request["subtitle"] ?? "";
string draftbox = context.Request["draftbox"] ?? "0";//是否保存草稿箱 0 否 1是 add by fuzhenzhen
Site_News news = new Cmt_News();
news.ID = Guid.NewGuid();
news.N_Content = content;
news.Title = title;
news.UserID = new Guid(userid);
news.CreateDate = dt;
news.N_Source = source;
news.CreateDate = DateTime.Now;
news.isTop = 0;
news.N_Type = 0;
news.ReadCount = 0;
if (draftbox == 1)
{
news.Status = 2;//草稿箱状态
}
else
{
news.Status = 1;
}
news.UpdateTime = DateTime.Now;
news.SubTitle = subtitle;
string result = new Site_News_BLL().InsertNews(title, content, RequestSession.GetSessionUser().UserId, DateTime.Now, Site_News_Pic.ImgPath, source, subtitle, Convert.ToInt32(draftbox));
//if (result != "")
//{
// //添加日志
// LogHelper.InserLog((int)EnumClass.OperateType.新增操作, PageBase.CurrentOperatName, "添加了标题为" + title + "的新闻");
//}
//清空公共变量
Site_News_Pic.ImgPath.Clear();
Site_News_Pic.Count = 0;
context.Response.Write(result);
}
/// <summary>
/// 设置头条
/// 创建人：lwj
/// 时间：2015-7-18
/// </summary>
/// <param name="context"></param>
private void TopImgAdd(HttpContext context)
{
string remark = context.Request["remark"] ?? "";
string id = context.Request["id"] ?? "";
string status = context.Request["status"] ?? "";
string div = context.Request["div"] ?? "";
Site_News_BLL bll = new Site_News_BLL();
if (status == "1")
{
//取消头条
string result = bll.UpdateTop(id, DateTimeHelper.GetNow(), status);
context.Response.Write(result);
}
else
{
if (div == "none")
{
context.Response.Write("-2");
return;
}
System.Web.HttpFileCollection _file = System.Web.HttpContext.Current.Request.Files;
if (_file.Count > 0)
{
string retflag = UploadImg(context, _file);
if (retflag != "-3" && retflag != "-1")
{
//图片保存成功
string result = bll.UpdateTop(id, DateTimeHelper.GetNow(), status, remark, retflag);
context.Response.Write(result);
}
else
{
context.Response.Write(retflag);
}
}
else
{
context.Response.Write("-2");
}
}
}
/// <summary>
/// 查询列表
/// 创建人：lwj
/// 时间：2015-6-16
/// </summary>
/// <param name="context"></param>
private void NewsList(HttpContext context)
{
string pageIndex = context.Request["pageIndex"] ?? "";
string pageSize = context.Request["pageSize"] ?? "";
string sname = StringHelper.SqlSpecialConvert(context.Request["sname"] ?? "", StringConverTypeEnum.Like);
string status = context.Request["status"] ?? "";
int pageCount = 0;
List <Cmt_VW_NewsAdminUser> newslist = new Site_News_BLL().SelectNewsUser(Convert.ToInt32(pageIndex), Convert.ToInt32(pageSize), sname, status, ref pageCount);
StringBuilder sb = new StringBuilder();
string revert = string.Empty;
string top = string.Empty;
int topcount = 0;
if (newslist.Count > 0)
{
sb.Append("<tr><th></th><th style='width:50px;'>序号</th><th style='width:250px;'>标题</th><th style='width:90px;'>阅读数量</th><th style='width:100px;'>提交人</th><th style='width:150px;'>发布时间</th><th>操作</th></tr>");
foreach (var item in newslist)
{
if (item.isTop == 1)
{
topcount++;
}
}
for (int i = 0; i < newslist.Count; i++)
{
if (newslist[i].Status == 1)
{
revert = "取消发布";
}
else if (newslist[i].Status == 2)
{
revert = "草稿箱";
}
else
{
revert = "发布";
}
if (newslist[i].isTop == 1)
{
top = "取消头条";
}
else
{
top = "设置头条";
}
sb.Append("<tr>");
sb.Append("<td><input name='MySelect' value='" + newslist[i].ID + "' type='checkbox'></td>");
sb.Append("<td>" + (i + 1) + "</td>");
sb.Append("<td title='" + StringHelper.SqlInsertEncode(newslist[i].Title) + "'><a href='/SiteManager/NewsPreview.aspx?id=" + newslist[i].ID + "'>" + StringHelper.SubString(newslist[i].Title, 35).Replace(" ", " ").Replace(" ", " ") + "</a></td>");
sb.Append("<td>" + newslist[i].ReadCount.ToString() + "</td>");
sb.Append("<td>" + newslist[i].Name + "</td>");
sb.Append("<td>" + newslist[i].CreateDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "</td>");
sb.Append("<td class='level'>");
//sb.Append("<a href='/SiteManager/NewsEdit.aspx?id=" + newslist[i].ID + "'>编辑</a>");
//sb.Append("<a href=\"javascript:Delete('" + newslist[i].ID + "')\">删除</a>");
if (newslist[i].Status == 2)
{
sb.Append("<a href='/SiteManager/NewsEdit.aspx?action=edit&id=" + newslist[i].ID + "'>编辑草稿箱</a>");
sb.Append("<a href=\"javascript:Delete('" + newslist[i].ID + "')\">删除</a>");
}
else
{
sb.Append("<a href='/SiteManager/NewsEdit.aspx?action=edit&id=" + newslist[i].ID + "'>编辑</a>");
sb.Append("<a href=\"javascript:Delete('" + newslist[i].ID + "')\">删除</a>");
sb.Append("<a href=\"javascript:EditState('" + newslist[i].ID + "','" + newslist[i].Status + "')\">" + revert + "</a>");
if (newslist[i].Status == 1)
{
sb.Append("<a href=\"javascript:Top('" + newslist[i].ID + "','" + newslist[i].isTop + "','" + topcount + "')\">" + top + "</a>");
}
else
{
sb.Append("<a href=\"#\" style=\"color:#A6a6a6;\">" + top + "</a>");
}
}
sb.Append("</td>");
sb.Append("</tr>");
}
context.Response.Write(JsonConvert.SerializeObject(new { count = pageCount, data = sb.ToString() }));
}
else
{
context.Response.Write(JsonConvert.SerializeObject(new { count = pageCount, data = "" }));
}
}
/// <summary>
/// 编辑新闻
/// 创建人：lwj
/// 时间：2015-6-16
/// </summary>
/// <param name="context"></param>
private void EditNews(HttpContext context)
{
string title = context.Request["title"] ?? "";
string content = context.Request["content"] ?? "";
string id = context.Request["id"] ?? "";
string deletepic = context.Request["deletepic"] ?? "";//要删除的图片的id
string source = context.Request["source"] ?? "";
string subtitle = context.Request["subtitle"] ?? "";
string draftbox = context.Request["draftbox"] ?? "0";//是否保存草稿箱 0 否 1是 add by fuzhenzhen
Site_News_BLL newsbll = new Site_News_BLL();
Site_News news = newsbll.SelectNews(id);
string oldContent = news.N_Content;
List <Site_News_Pic> pic = new List <Site_News_Pic>();
//记录要删除的新闻轮播图片
if (!string.IsNullOrEmpty(deletepic))
{
pic = newsbll.SelectNewsPic(deletepic.Remove(deletepic.Length - 1));
}
//编辑新闻内容和图片 //deit by fuzhenzhen 09-15
string result = newsbll.UpdateNews(id, title, content, Site_News_Pic.imgPath, deletepic, source, subtitle, Convert.ToInt32(draftbox));
if (result == "1")
{
#region 剔除新闻内容里的文件夹图片
string regex = "<img.*?/>";
MatchCollection notu = StringHelper.GetValue(regex, content);
MatchCollection oldtu = StringHelper.GetValue(regex, oldContent);
for (int j = 0; j < oldtu.Count; j++)
{
if (!content.Contains(oldtu[j].Value))
{
//现在的不包含以前的
int place = oldtu[j].Value.IndexOf("src=") + 5;
string hou = oldtu[j].Value.Substring(place);
int yin = hou.IndexOf("\"");
string src = hou.Substring(0, yin);//图片路径
if (!string.IsNullOrEmpty(src))
{
try
{
string pa = System.Web.HttpContext.Current.Server.MapPath("~/" + src);
if (File.Exists(pa))
{
File.Delete(pa);
}
}
catch
{
continue;
}
}
}
}
#endregion
#region 除文件夹里的图片
if (pic.Count > 0)
{
foreach (var item in pic)
{
try
{
string pa = System.Web.HttpContext.Current.Server.MapPath("~/" + item.PicPath);
if (File.Exists(pa))
{
File.Delete(pa);
}
}
catch
{
continue;
}
}
}
#endregion
//添加日志
LogHelper.InserLog((int)EnumClass.OperateType.编辑操作, PageBase.CurrentOperatName, "编辑了标题为" + title + "的新闻");
}
//重置公共变量
Site_News_Pic.imgPath = new List <Site_News_Pic>();
Site_News_Pic.count = 0;
context.Response.Write(result);
}
/// <summary>
/// 删除新闻
/// 创建人：lwj
/// 时间：2015-6-16
/// </summary>
/// <param name="context"></param>
private void DeleteNews(HttpContext context)
{
string deleteids = context.Request["id"] ?? "";
//记录要删除的新闻以及图片
List <Cmt_VW_NewPicInfo> DeletNews = new List <Cmt_VW_NewPicInfo>();
if (!string.IsNullOrEmpty(deleteids))
{
DeletNews = new Cmt_VW_NewPicInfo_BLL().GetListInfos(deleteids.Remove(deleteids.Length - 1));
}
string result = new Site_News_BLL().DeleteNews(deleteids);//删除后的返回值
if (result == "1")
{
foreach (var item in DeletNews)
{
#region 剔除文件夹中新闻内容里的图片
string regex = "<img.*?/>";
MatchCollection notu = StringHelper.GetValue(regex, item.N_Content);
if (notu.Count > 0)
{
for (int j = 0; j < notu.Count; j++)
{
int place = notu[j].Value.IndexOf("src=") + 5;
string hou = notu[j].Value.Substring(place);
int yin = hou.IndexOf("\"");
string src = hou.Substring(0, yin);//图片路径
if (!string.IsNullOrEmpty(src))
{
try
{
string pa = System.Web.HttpContext.Current.Server.MapPath("~/" + src);
if (File.Exists(pa))
{
File.Delete(pa);
}
}
catch
{
continue;
}
}
}
}
#endregion
#region 除文件夹中的轮播图片
try
{
string pa = System.Web.HttpContext.Current.Server.MapPath("~/" + item.PicPath);
if (File.Exists(pa))
{
File.Delete(pa);
}
}
catch
{
continue;
}
#endregion
#region 除文件夹中的头条图片
if (item.isTop == 1)
{
try
{
string path = System.Web.HttpContext.Current.Server.MapPath("~/" + item.BannerPic);
if (File.Exists(path))
{
File.Delete(path);
}
}
catch
{
continue;
}
}
#endregion
//添加日志
LogHelper.InserLog((int)EnumClass.OperateType.除操作, PageBase.CurrentOperatName, "删除了标题为" + item.Title + "的新闻");
}
}
context.Response.Write(result);
}
