/// <summary>
/// 初始化修改页面
/// </summary>
/// <param name="newsId">新闻id</param>
private void ShowInfo(int newsId)
{
BLL.CCOM.News bll = new BLL.CCOM.News();
Model.CCOM.News model = bll.GetModel(newsId);
if (model != null)
{
this.txtTitle.Text = model.News_title;
//this.hidNewsType.Value = model.News_type_id.ToString();
this.txtReleaseTime.Text = model.News_date.ToString();
this.hidEditorCnt.Value = model.News_content;
if (model.News_top != null)
{
this.optTop.Checked = (bool)model.News_top;
this.txtTopTime.Text = model.News_top_time.ToString();
//this.trTop.Style.Add("display", "");
}
List <Model.CCOM.News_attach> attach_model = new BLL.CCOM.News_attach().GetModelList(" News_id=" + newsId);
if (attach_model != null && attach_model.Count > 0)
{
rptAttach.DataSource = attach_model;
rptAttach.DataBind();
}
}
else
{
JscriptMsg("资讯不存在或已被删除！", "back", "Error");
}
}
//单个删除
protected void lbtSingleDelete_Click(object sender, EventArgs e)
{
var lbtn = sender as LinkButton;
BLL.CCOM.News_type bll = new BLL.CCOM.News_type();
BLL.CCOM.News news_bll = new BLL.CCOM.News();
if (lbtn != null)
{
bool result = false;
int newsTypeId = Int32.Parse(DESEncrypt.Decrypt(lbtn.ToolTip.ToString()));
if (newsTypeId > 0)
{
Model.CCOM.News_type model = bll.GetModel(newsTypeId);
if (model.News_type_creator_id == GetAdminInfo_CCOM().User_id)
{
news_bll.Delete(" News_type_id=" + newsTypeId);
result = bll.Delete(newsTypeId);
}
int page = MyRequest.GetQueryInt("page", 1);
if (result)
{
JscriptMsg("删除成功！", Utils.CombUrlTxt("News_type_manage.aspx", "&keywords={0}&page={1}&fun_id={2}",
keywords, page.ToString(), DESEncrypt.Encrypt(this.fun_id)), "Success");
}
}
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//按时间先后
DataTable dt = new BLL.CCOM.News().GetList(0, "", " News_date DESC").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
var class_media = "media";
var class_span = "label pull-left news-bg";
var class_img_circle = "img-circle";
var img_src = "/admin/images/water.jpg";
var class_media_body = "media-body";
var p_title = "text news-title";
var img_style = "width:40px; height:40px;";
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
sb.Append("<li><div class=\"" + class_media + "\"><span class=\"" + class_span + "\"><img class=\"" +
class_img_circle + "\" src=\"" + img_src + "\" alt=\"资讯\" style=\"" + img_style + "\"/></span>");
sb.Append("<div class=\"" + class_media_body + "\"><p class=\"" + p_title + "\"><a href=\"" + dr["News_URL"] + "\">" +
dr["News_title"] + "</a></p><span>" + dr["News_date"] + "</span></div></div></li>");
}
context.Response.Write(sb.ToString());
}
else
{
context.Response.Write("暂无资讯");
}
//不按时间先后
//var news_list = new BLL.CCOM.News().GetModelList("");
//if (news_list != null && news_list.Count > 0)
//{
// var class_media = "media";
// var class_span = "label pull-left news-bg";
// var class_img_circle = "img-circle";
// var img_src = "/admin/images/water.jpg";
// var class_media_body = "media-body";
// var p_title = "text news-title";
// var img_style = "width:40px; height:40px;";
// StringBuilder sb = new StringBuilder();
// for (int i = 0; i < news_list.Count; i++)
// {
// Model.CCOM.News model = news_list[i];
// sb.Append("<li><div class=\"" + class_media + "\"><span class=\"" + class_span + "\"><img class=\"" +
// class_img_circle + "\" src=\"" + img_src + "\" alt=\"资讯\" style=\"" + img_style + "\"/></span>");
// sb.Append("<div class=\"" + class_media_body + "\"><p class=\"" + p_title + "\"><a href=\"" + model.News_URL + "\">" +
// model.News_title + "</a></p><span>" + model.News_date + "</span></div></div></li>");
// //context.Response.Write(sb.ToString());
// }
// context.Response.Write(sb.ToString());
//}
//else
//{
// context.Response.Write("暂无资讯");
//}
}
/// <summary>
/// 获取页码
/// </summary>
/// <param name="context"></param>
private void GetNewsPage(HttpContext context, int typeId, string strWhere, int page)
{
//var response = new HttpBaseResponse();
int total_count = new BLL.CCOM.News().GetRecordCount(strWhere);
string pageStr = Utils.OutPageList(pageSize, page, total_count, "javascript:gotoNewsPage(__id__);", 8, true);
context.Response.Write(pageStr);
}
/// <summary>
/// 获取通知信息
/// </summary>
/// <param name="typeId"></param>
/// <param name="page">返回页码</param>
/// <returns></returns>
protected string InitialPage(Int32 typeId, int page)
{
string sqlWhere = string.Empty;
if (typeId != 0)
{
sqlWhere = " News_type_id='" + typeId + "'";
}
//不按时间
//var list = new BLL.CCOM.News().GetModelList(sqlWhere);
//if (list != null && list.Count > 0)
//{
// List<string> page_item = new List<string>();
// StringBuilder sb = new StringBuilder();
// for (int i = 1; i <= list.Count; i++)
// {
// Model.CCOM.News model = list[0];
// sb.Append("<li class='notice-li'>" + "<a href='" + model.News_URL + "'>" + i + "、" + model.News_title + "<a/>" + "<li/>");
// if (i % 10 == 0)
// {
// page_item.Add(sb.ToString());
// sb = new StringBuilder();
// }
// }
// if(page_item.Count==0)
// {
// page_item.Add(sb.ToString());
// }
// this.news_list.InnerHtml = page_item[page];
//}
//按时间
DataTable dt = new BLL.CCOM.News().GetList(0, sqlWhere, " News_date DESC").Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
int i = 1;
StringBuilder sb = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
sb.Append("<li class=\"notice-li\">" + "<a href=\"" + dr["News_URL"] + "\">" + i + "、" + dr["News_title"] + "<a/>" + "<li/>");
if (i % 10 == 0)
{
page_item.Add(sb.ToString());
sb = new StringBuilder();
}
i++;
}
if (sb != null && sb.ToString().Length > 0)
{
page_item.Add(sb.ToString());
}
return(page_item[page - 1]);
}
return(null);
}
public static void UpdateNewsReadNum(int newsId)
{
if (HttpContext.Current.Session[newsId.ToString()] == null)
{
var news = new BLL.CCOM.News().GetModel(newsId);
news.News_readnumber++;
new BLL.CCOM.News().Update(news);
HttpContext.Current.Session[newsId.ToString()] = 1;
}
}
public static void CreateWebNewsHtml(String newsId, String fileName, bool checkExists)
{
if ((!checkExists) || (!System.IO.File.Exists(fileName)))
{
var news = new BLL.CCOM.News().GetModel(Int32.Parse(newsId));
if (news != null)
{
// 读取模板文件
string temp = HttpContext.Current.Server.MapPath("news_temp.html");
String newsStr = FileOperate.ReadFile(temp);
newsStr = newsStr.Replace("titlexxx", news.News_title);
StringBuilder sb = new StringBuilder();
int creator_id = news.News_creator_id;
string realname = new BLL.CCOM.User_information().GetModel(creator_id).User_realname;
if (realname != "请填写真实姓名")
{
sb.Append("<span>发布者：").Append(realname).Append("</span>");
}
sb.Append(" ");
sb.Append(news.News_date);
//sb.Append(" ").Append("阅读次数：").Append(news.NI_ReadNum);
newsStr = newsStr.Replace("desxxx", sb.ToString());
String content = HttpContext.Current.Server.HtmlDecode(news.News_content);
newsStr = newsStr.Replace("contentxxx", content);
sb.Clear();
//var newsAttach = new BLL.news.News_NewsInfo().GetModel(Int64.Parse(newsId)).NewsAttach;
string strWhere = " News_id=" + newsId;
var newsAttach = new BLL.CCOM.News_attach().GetModelList(strWhere);
if (newsAttach != null && newsAttach.Count > 0)
{
sb.Append("<p class='attachTitle'>附件：</p>");
var itemCnt = 1;
foreach (var item in newsAttach)
{
sb.Append("<p class='attachItem'>(").Append(itemCnt).Append(") <a href='")
.Append("/home/news/Attach.aspx?id=").Append(DESEncrypt.Encrypt(item.News_attach_id.ToString()))
.Append("&address=").Append(HttpUtility.UrlEncode(item.News_attach_address))
.Append("&name=").Append(HttpUtility.UrlEncode(item.News_attach_name))
.Append("' target='_blank' >")
.Append(item.News_attach_name)
.Append("</a>")
.Append(OnlineViewHelper.GetOnlineViewWrapLink(item.News_attach_address, item.News_attach_name))
.Append("</p>");
itemCnt++;
}
}
newsStr = newsStr.Replace("attachxxx", sb.ToString());
////写文件
FileOperate.WriteNewFile(fileName, newsStr);
}
}
}
/// <summary>
/// 置顶
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lbtTop_Click(object sender, EventArgs e)
{
var bll = new BLL.CCOM.News();
var lbtn = sender as LinkButton;
if (lbtn != null)
{
int news_id = Int32.Parse(DESEncrypt.Decrypt(lbtn.ToolTip.ToString()));
bool isTop = false;
bool result = true;
try
{
var model = bll.GetModel(news_id);
if (model.News_top != null && !(bool)model.News_top)
{
isTop = false;
model.News_top = true;
DateTime date = Convert.ToDateTime(model.News_date);
TimeSpan time_span = DateTime.Now - date;
int day = time_span.Days;
model.News_top_time = day + 3;
bll.Update(model);
}
else
{
isTop = true;
model.News_top = false;
model.News_top_time = 0;
bll.Update(model);
}
result = true;
}
catch
{
result = false;
}
//string keywords = MyRequest.GetQueryString("keywords");
int page = MyRequest.GetQueryInt("page", 1);
if (result == true)
{
JscriptMsg(isTop ? "取消置顶成功！" : "置顶成功！", Utils.CombUrlTxt("News_list_manager.aspx", "keywords={0}&page={1}&fun_id={2}",
keywords, page.ToString(), DESEncrypt.Encrypt(this.fun_id)), "Success");
}
else
{
JscriptMsg(isTop ? "取消置顶失败！" : "置顶失败！", Utils.CombUrlTxt("News_list_manager.aspx", "keywords={0}&page={1}&fun_id={2}",
keywords, page.ToString(), DESEncrypt.Encrypt(this.fun_id)), "Error");
}
}
}
/// <summary>
/// 获取新闻生成的日期目录
/// </summary>
/// <param name="newsId">新闻Id</param>
private static string GetNewsDatePath(int newsId)
{
//var m = new BLL.news.News_NewsInfo().GetModel(newsId);
var model = new BLL.CCOM.News().GetModel(newsId);
if (model == null || model.News_date == null)
{
return("");
}
//按年月/日存入不同的文件夹
DateTime dt = Convert.ToDateTime(model.News_date);
return(dt.ToString("yyyyMM") + "/" + dt.ToString("dd") + "/");
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string id = context.Request.Params["newsId"];
int newsId = int.Parse(DESEncrypt.Decrypt(id));
Model.CCOM.News model = new BLL.CCOM.News().GetModel(newsId);
if (model != null)
{
context.Response.Write(model.News_readnumber);
}
else
{
context.Response.Write("0");
}
}
/// <summary>
/// 获取所有新闻
/// </summary>
/// <param name="context"></param>
private void GetAllNewList(HttpContext context, int typeId, string strWhere, int page)
{
//初始化置顶数据
if (page == 1)
{
var bll = new BLL.CCOM.News();
var list = bll.GetModelList("News_top=1");
for (int i = 0; i < list.Count; i++)
{
if (list[i].News_date != null)
{
DateTime date = Convert.ToDateTime(list[i].News_date);
if (list[i].News_top_time != null)
{
if (date.AddDays((double)list[i].News_top_time) < DateTime.Now)
{
var model = bll.GetModel(list[i].News_id);
model.News_top = false;
model.News_top_time = 0;
bll.Update(model);
}
}
else
{
//若为空，默认为3天
if (date.AddDays(3.0) < DateTime.Now)
{
var model = bll.GetModel(list[i].News_id);
model.News_top = false;
model.News_top_time = 0;
bll.Update(model);
}
}
}
}
}
int start_index = pageSize * (page - 1) + 1;
int end_index = pageSize * page;
DataTable dt = new BLL.CCOM.News().GetListByPage(strWhere, "News_top DESC ,News_date DESC ", start_index, end_index).Tables[0];
string json = ToJson(dt);
context.Response.Write(json);
}
private int DoAdd()
{
var model = new Model.CCOM.News();
model.News_title = this.txtTitle.Text.Trim();
model.News_URL = "/AdminMetro/index.aspx";
model.News_creator_id = (int)GetAdminInfo_CCOM().User_id;
if (this.txtReleaseTime.Text.Trim() != null && this.txtReleaseTime.Text.Trim().Length > 0)
{
model.News_date = Convert.ToDateTime(this.txtReleaseTime.Text.Trim());
}
else
{
model.News_date = DateTime.Now;
}
model.News_readnumber = 1;
model.News_type_id = int.Parse(DESEncrypt.Decrypt(this.hidNewsType.Value));
model.News_content = this.hidEditorCnt.Value.Replace("'", "");
model.News_top = false;
if (this.optTop.Checked)
{
model.News_top = true;
string time = this.txtTopTime.Text.Trim();
if (time != null && time.Length > 0)
{
int last_time = int.Parse(time);
model.News_top_time = last_time;
}
else
{
model.News_top_time = 3;//默认置顶3天
}
}
Int32 newsId = 0;
newsId = new BLL.CCOM.News().Add(model);
if (newsId > 0)
{
#region ====================附件
//保存附件
string hidFileList = Request.Params["hidFileName"];
if (!string.IsNullOrEmpty(hidFileList))
{
string[] fileListArr = hidFileList.Split(',');
//var list = new List<Model.CCOM.News_attach>();
for (int i = 0; i < fileListArr.Length; i++)
{
string[] fileArr = fileListArr[i].Split('|');
if (fileArr.Length == 3)
{
int attach_id = Int32.Parse(fileArr[0]);
String toFilePath = DataDic.News_Attach_Path + DateTime.Now.Ticks.ToString() + i.ToString() +
FileOperate.GetPostfixStr(fileArr[2]);
try
{
FileOperate.FileMove(Server.MapPath(fileArr[2]),
Server.MapPath(toFilePath));
//上传附件至文件服务器
UI.UpLoad.UploadFileThread(toFilePath);
}
catch (Exception ex)
{
toFilePath = fileArr[2];
}
Model.CCOM.News_attach model_attach = new Model.CCOM.News_attach();
model_attach.News_id = newsId;
model_attach.News_attach_name = fileArr[1];
model_attach.News_attach_address = toFilePath;
new BLL.CCOM.News_attach().Add(model_attach);
}
}
}
#endregion
//修改URL
Model.CCOM.News model1 = new BLL.CCOM.News().GetModel(newsId);
model1.News_URL = "/AdminMetro/CCOM/notification/ViewNews.aspx?id=" + DESEncrypt.Encrypt(newsId.ToString());
new BLL.CCOM.News().Update(model1);
//生成静态页
NewsHtml.CreateHtml(newsId, false);
}
return(newsId);
}
/// <summary>
/// 初始化资讯类别
/// </summary>
private void InitialNewsType()
{
var news_type_list = new BLL.CCOM.News_type().GetModelList("");
StringBuilder sb = new StringBuilder();
if (news_type_list != null && news_type_list.Count > 0)
{
string news_id = MyRequest.GetQueryString("id");
var className = "btn btn-success";
var className1 = "btn";
if (news_id != null && news_id.Length > 0)//编辑
{
Model.CCOM.News model = new BLL.CCOM.News().GetModel(int.Parse(DESEncrypt.Decrypt(news_id)));
if (model != null)
{
int news_type_id = model.News_type_id;
if (news_type_id != 0)
{
sb.Append("<a href=\"javascript:;\" class='btn' onclick='newsTypeTabs(\"" + DESEncrypt.Encrypt("0") + "\",this)'>未分类</a> ");
for (int i = 0; i < news_type_list.Count; i++)
{
if (news_type_list[i].News_type_id == news_type_id)
{
sb.Append("<a href=\"javascript:;\" class='" + className +
"' onclick='newsTypeTabs(\"" +
DESEncrypt.Encrypt(news_type_list[i].News_type_id.ToString()) + "\",this)'>");
this.hidNewsType.Value = DESEncrypt.Encrypt(news_type_list[i].News_type_id.ToString());
}
else
{
sb.Append("<a href=\"javascript:;\" class='" + className1 +
"' onclick='newsTypeTabs(\"" +
DESEncrypt.Encrypt(news_type_list[i].News_type_id.ToString()) + "\",this)'>");
}
sb.Append(news_type_list[i].News_type_name + "</a> ");
}
}
else
{
this.hidNewsType.Value = DESEncrypt.Encrypt("0");
sb.Append("<a href=\"javascript:;\" class='btn btn-success' onclick='newsTypeTabs(\"" + DESEncrypt.Encrypt("0") + "\",this)'>未分类</a> ");
for (int i = 0; i < news_type_list.Count; i++)
{
sb.Append("<a href=\"javascript:;\" class='" + className1 +
"' onclick='newsTypeTabs(\"" +
DESEncrypt.Encrypt(news_type_list[i].News_type_id.ToString()) + "\",this)'>");
sb.Append(news_type_list[i].News_type_name + "</a> ");
}
}
}
}
else//发布
{
this.hidNewsType.Value = DESEncrypt.Encrypt("0");
sb.Append("<a href=\"javascript:;\" class='btn btn-success' onclick='newsTypeTabs(\"" + DESEncrypt.Encrypt("0") + "\",this)'>未分类</a> ");
for (int i = 0; i < news_type_list.Count; i++)
{
sb.Append("<a href=\"javascript:;\" class='" + className1 +
"' onclick='newsTypeTabs(\"" +
DESEncrypt.Encrypt(news_type_list[i].News_type_id.ToString()) + "\",this)'>");
sb.Append(news_type_list[i].News_type_name + "</a> ");
}
}
}
else
{
sb.Append("<a href=\"javascript:;\" class='btn btn-success' onclick='newsTypeTabs(\"" + DESEncrypt.Encrypt("0") + "\",this)'>未分类</a> ");
this.hidNewsType.Value = DESEncrypt.Encrypt("0");
}
sb.Append("<a href=\"javascript:;\" class='btn' style='font-size: 18px;' onclick='addPushType()'><i class=\"icon-plus\"></i></a>");
this.NewsTypeDiv.InnerHtml = sb.ToString();
}
/// <summary>
///
/// </summary>
/// <param name="_id">资讯ID</param>
/// <returns></returns>
private bool DoEdit(int _id)
{
#region =====================================附件
string hidFileList = Request.Params["hidFileName"];
string strWhere = " News_id=" + _id;
var news_attach = new BLL.CCOM.News_attach().GetModelList(strWhere);
if (!string.IsNullOrEmpty(hidFileList))
{
string[] fileListArr = hidFileList.Split(',');
//附件发生变化，重新上传(从无到有，数目发生变化，内容发生变化)
if (news_attach != null && news_attach.Count > 0 && news_attach.Count != fileListArr.Length || this.attachChange.Value == "1" || news_attach.Count == 0)
{
var bll = new BLL.CCOM.News_attach();
for (int i = 0; i < news_attach.Count; i++)
{
string str = " News_attach_id=" + news_attach[i].News_attach_id;
bll.Delete(str);
}
for (int i = 0; i < fileListArr.Length; i++)
{
string[] fileArr = fileListArr[i].Split('|');
if (fileArr.Length == 3)
{
long attach_id = Int64.Parse(fileArr[0]);
String toFilePath = DataDic.News_Attach_Path + DateTime.Now.Ticks.ToString() + i.ToString() +
FileOperate.GetPostfixStr(fileArr[2]);
//新增文件
if (attach_id == 0)
{
try
{
FileOperate.FileMove(Server.MapPath(fileArr[2]),
Server.MapPath(toFilePath));
//上传附件至文件服务器
UI.UpLoad.UploadFileThread(toFilePath);
}
catch
{
toFilePath = fileArr[2];
}
}
else
{
toFilePath = fileArr[2]; //原有附件地址不变
}
Model.CCOM.News_attach model_attach = new Model.CCOM.News_attach();
model_attach.News_id = newsId;
model_attach.News_attach_name = fileArr[1];
model_attach.News_attach_address = toFilePath;
new BLL.CCOM.News_attach().Add(model_attach);
}
}
}
}
else
{
//从有到无，删除数据库数据
if (news_attach != null && news_attach.Count > 0)
{
var bll = new BLL.CCOM.News_attach();
for (int i = 0; i < news_attach.Count; i++)
{
string str = " News_attach_id=" + news_attach[i].News_attach_id;
bll.Delete(str);
}
}
}
#endregion
//var model = new Model.CCOM.News();
var model = new BLL.CCOM.News().GetModel(_id);
model.News_title = this.txtTitle.Text.Trim();
if (this.txtReleaseTime.Text.Trim() != null && this.txtReleaseTime.Text.Trim().Length > 0)
{
model.News_date = Convert.ToDateTime(this.txtReleaseTime.Text.Trim());
}
model.News_last_editor = (int)GetAdminInfo_CCOM().User_id;
model.News_type_id = int.Parse(DESEncrypt.Decrypt(this.hidNewsType.Value));
model.News_content = this.hidEditorCnt.Value.Replace("'", "");
model.News_top = false;//默认不置顶
if (this.optTop.Checked)
{
model.News_top = true;
string time = this.txtTopTime.Text.Trim();
if (time != null && time.Length > 0)
{
int last_time = int.Parse(time);
model.News_top_time = last_time;
}
else
{
model.News_top_time = 3;//默认置顶3天
}
}
if (new BLL.CCOM.News().Update(model))
{
NewsHtml.CreateHtml(_id, false);
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
BLL.CCOM.News bll = new BLL.CCOM.News();
BLL.CCOM.News_attach bll1 = new BLL.CCOM.News_attach();
int count = 0;
bool result = false;
for (int i = 0; i < this.rptList.Items.Count; i++)
{
System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)rptList.Items[i].FindControl("chkId");
if (!cb.Checked)
{
continue;
}
else
{
int newsId = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
if (newsId > 0)
{
Model.CCOM.News model = bll.GetModel(newsId);
if (model.News_creator_id == GetAdminInfo_CCOM().User_id)
{
//删除附件
var list = bll1.GetModelList(" News_id=" + newsId);
if (list != null && list.Count > 0)
{
for (int j = 0; j < list.Count; j++)
{
string path = list[j].News_attach_address;
if (File.Exists(Server.MapPath(path)))
{
FileInfo fi = new FileInfo(path);
if (fi.Attributes.ToString().IndexOf("ReadOnly") != -1)
{
fi.Attributes = FileAttributes.Normal;
}
File.Delete(Server.MapPath(path));
}
bll1.Delete(list[j].News_attach_id);
}
}
//删除静态页
String name = NewsHtml.GetWebNewsPath(newsId);
if (File.Exists(Server.MapPath(name)))
{
FileInfo fi = new FileInfo(name);
if (fi.Attributes.ToString().IndexOf("ReadOnly") != -1)
{
fi.Attributes = FileAttributes.Normal;
}
string path_name = Server.MapPath(name);
File.Delete(Server.MapPath(name));
}
//删除记录
result = bll.Delete(model.News_id);
}
if (result)
{
count++;
}
}
}
}
if (count < 1)
{
JscriptMsg("请您选择需要删除的新闻！", "", "Error");
return;
}
string keywords = MyRequest.GetQueryString("keywords");
int page = MyRequest.GetQueryInt("page", 1);
if (result == true)
{
JscriptMsg("批量删除成功！", Utils.CombUrlTxt("News_list_manager.aspx", "&keywords={0}&page={1}&fun_id={2}",
keywords, page.ToString(), DESEncrypt.Encrypt(this.fun_id)), "Success");
}
else
{
JscriptMsg("批量删除失败！", Utils.CombUrlTxt("News_list_manager.aspx", "keywords={0}&page={1}&fun_id={2}",
keywords, page.ToString(), DESEncrypt.Encrypt(this.fun_id)), "Error");
}
}
/// <summary>
/// 单个删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lbtSingleDelete_Click(object sender, EventArgs e)
{
BLL.CCOM.News bll = new BLL.CCOM.News();
BLL.CCOM.News_attach bll1 = new BLL.CCOM.News_attach();
var lbtn = sender as LinkButton;
if (lbtn != null)
{
int news_id = Int32.Parse(DESEncrypt.Decrypt(lbtn.ToolTip.ToString()));
if (news_id > 0)
{
Model.CCOM.News model = bll.GetModel(news_id);
bool result = false;
if (model != null)
{
if (model.News_creator_id == GetAdminInfo_CCOM().User_id)
{
//删除附件
var list = bll1.GetModelList(" News_id=" + news_id);
if (list != null && list.Count > 0)
{
for (int j = 0; j < list.Count; j++)
{
string path = list[j].News_attach_address;
if (File.Exists(Server.MapPath(path)))
{
FileInfo fi = new FileInfo(path);
if (fi.Attributes.ToString().IndexOf("ReadOnly") != -1)
{
fi.Attributes = FileAttributes.Normal;
}
File.Delete(Server.MapPath(path));
}
bll1.Delete(list[j].News_attach_id);
}
}
//删除静态页
String name = NewsHtml.GetWebNewsPath(news_id);
if (File.Exists(Server.MapPath(name)))
{
FileInfo fi = new FileInfo(name);
if (fi.Attributes.ToString().IndexOf("ReadOnly") != -1)
{
fi.Attributes = FileAttributes.Normal;
}
string path_name = Server.MapPath(name);
File.Delete(Server.MapPath(name));
}
result = bll.Delete(model.News_id);
}
}
string keywords = MyRequest.GetQueryString("keywords");
int page = MyRequest.GetQueryInt("page", 1);
if (result == true)
{
JscriptMsg("删除成功！", Utils.CombUrlTxt("News_list_manager.aspx", "&keywords={0}&page={1}&fun_id={2}",
keywords, page.ToString(), get_fun_id("CCOM/notification/News_list_manager.aspx")), "Success");
}
else
{
JscriptMsg("删除失败！", Utils.CombUrlTxt("News_list_manager.aspx", "keywords={0}&page={1}&fun_id={2}",
keywords, page.ToString(), get_fun_id("CCOM/notification/News_list_manager.aspx")), "Error");
}
}
}
}
/// <summary>
/// 绑定资讯内容
/// </summary>
private void bindNewsData()
{
//更新置顶数据
var bll = new BLL.CCOM.News();
var list = bll.GetModelList("News_top=1");
for (int i = 0; i < list.Count; i++)
{
if (list[i].News_date != null)
{
DateTime date = Convert.ToDateTime(list[i].News_date);
if (list[i].News_top_time != null)
{
if (date.AddDays((double)list[i].News_top_time) < DateTime.Now)
{
var model = bll.GetModel(list[i].News_id);
model.News_top = false;
model.News_top_time = 0;
bll.Update(model);
}
}
else
{
//若为空，默认为3天
if (date.AddDays(3.0) < DateTime.Now)
{
var model = bll.GetModel(list[i].News_id);
model.News_top = false;
model.News_top_time = 0;
bll.Update(model);
}
}
}
}
string strWhere = string.Empty;
int pageSize = GetPageSize(15); //每页数量
int page = MyRequest.GetQueryInt("page", 1);
keywords = MyRequest.GetQueryString("keywords");
string news_type_id = MyRequest.GetQueryString("news_type_id");
if (news_type_id != null && news_type_id.Length > 0)
{
string news_type = DESEncrypt.Decrypt(news_type_id);
if (news_type != "0")
{
strWhere += " News_type_id=" + news_type;
}
}
if (keywords != null && keywords.Length > 0)
{
if (strWhere != "")
{
strWhere = strWhere + " and News_title like '%" + keywords + "%' ";
}
else
{
strWhere = " News_title like '%" + keywords + "%' ";
}
}
int start_index = pageSize * (page - 1) + 1;
int end_index = pageSize * page;
//计算数量
int totalCount = bll.GetRecordCount("");
//绑定当页
this.rptList.DataSource = bll.GetListByPage(strWhere, " News_date DESC ", start_index, end_index);
this.rptList.DataBind();
//for (int i = 0; i < rptList.Items.Count; i++)
//{
// LinkButton lbt = (LinkButton)rptList.Items[i].FindControl("lbtDelete");
// HiddenField hide = (HiddenField)rptList.Items[i].FindControl("hideCreatorId");
// int CreatorId = int.Parse(hide.Value);
// if(CreatorId==GetAdminInfo_CCOM().User_id)
// {
// }
//}
//绑定页码
this.txtPageNum.Text = pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("News_list_manager.aspx", "keywords={0}&page={1}&fun_id={2}", keywords, "__id__", DESEncrypt.Encrypt(this.fun_id));
this.PageContent.InnerHtml = Utils.OutPageList(pageSize, page, totalCount, pageUrl, 8, true);
}
/// <summary>
/// 初始化资讯
/// </summary>
/// <param name="typeId"></param>
protected void InitialPage(int page)
{
//更新置顶数据
var bll = new BLL.CCOM.News();
var list = bll.GetModelList("News_top=1");
for (int i = 0; i < list.Count; i++)
{
if (list[i].News_date != null)
{
DateTime date = Convert.ToDateTime(list[i].News_date);
if (list[i].News_top_time != null)
{
if (date.AddDays((double)list[i].News_top_time) < DateTime.Now)
{
var model = bll.GetModel(list[i].News_id);
model.News_top = false;
model.News_top_time = 0;
bll.Update(model);
}
}
else
{
//若为空，默认为3天
if (date.AddDays(3.0) < DateTime.Now)
{
var model = bll.GetModel(list[i].News_id);
model.News_top = false;
model.News_top_time = 0;
bll.Update(model);
}
}
}
}
int start_index = 1;
int end_index = 10;
DataTable dt = bll.GetListByPage("", "News_top DESC ,News_date DESC ", start_index, end_index).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
string li = string.Empty;
foreach (DataRow dr in dt.Rows)
{
bool top = false;
try
{
top = Convert.ToBoolean(dr["News_top"]);
}
catch
{
top = false;
}
finally
{
DateTime date = Convert.ToDateTime(dr["News_date"]);
string time = date.ToString("yyyy/MM/dd");
if (top)
{
li += "<li class=\"notice-li\">" + "<a href=\"" +
dr["News_URL"] + "\" target=\"_blank\">" + "<img src=\"/images/news/news_logo2.png\" class=\"img_logo\"/>" + "<span style=\"color:red;\">[置顶] </span>" +
dr["News_title"] + "</a>" + "<span class=\"date\">" +
time + "</span>" + "</li>";
}
else
{
li += "<li class=\"notice-li\">" + "<a href=\"" +
dr["News_URL"] + "\" target=\"_blank\">" + "<img src=\"/images/news/news_logo2.png\" class=\"img_logo\"/>" +
dr["News_title"] + "</a>" + "<span class=\"date\">" +
time + "</span>" + "</li>";
}
}
}
this.news_list.InnerHtml = li;
}
int newsNum = bll.GetRecordCount("");
int pageNum = 0;
if (newsNum % 10 == 0)
{
pageNum = newsNum / 10;
}
else
{
pageNum = newsNum / 10 + 1;
}
this.page_num.Value = pageNum + "";
}
