//网站公告右侧列表 /**/
public void Notice_List(int cateid)
{
int page = tools.CheckInt(Request["page"]);
if (page < 1)
{
page = 1;
}
NoticeCateInfo CateInfo = MyNoticeCate.GetNoticeCateByID(cateid, pub.CreateUserPrivilege("fb3e87ba-3d4d-480d-934e-80048bcc0100"));
if (CateInfo != null)
{
Response.Write("<div id=\"help-right\">");
Response.Write(" <h3>" + CateInfo.Notice_Cate_Name + "</h3>");
Response.Write(" <div id=\"help-rightwen1\">");
Response.Write(" <ul>");
QueryInfo Query = new QueryInfo();
Query.PageSize = 20;
Query.CurrentPage = page;
Query.ParamInfos.Add(new ParamInfo("AND", "int", "NoticeInfo.Notice_IsAudit", "=", "1"));
Query.ParamInfos.Add(new ParamInfo("AND", "str", "NoticeInfo.Notice_Site", "=", "CN"));
Query.ParamInfos.Add(new ParamInfo("AND", "int", "NoticeInfo.Notice_Cate", "=", CateInfo.Notice_Cate_ID.ToString()));
Query.OrderInfos.Add(new OrderInfo("NoticeInfo.Notice_ID", "DESC"));
IList <NoticeInfo> notices = Webnotice.GetNotices(Query, pub.CreateUserPrivilege("9d4d1366-35ab-4eb6-b88e-e49e6bfae9d7"));
if (notices != null)
{
foreach (NoticeInfo entity in notices)
{
Response.Write("<li><span style=\"color:#535353;\">[ " + entity.Notice_Addtime.ToString("yy-MM-dd") + " ]</span><a href=\"/notice/detail.aspx?notice_id=" + entity.Notice_ID + "\">" + tools.CutStr(entity.Notice_Title, 35) + "</a></li>");
}
}
else
{
Response.Write("<div height=\"50\" style=\" height:50px; text-align:center;line-height:50px; color:#707070;\">信息正在维护中...</div>");
}
Response.Write("</ul>");
PageInfo pageinfo = Webnotice.GetPageInfo(Query, pub.CreateUserPrivilege("9d4d1366-35ab-4eb6-b88e-e49e6bfae9d7"));
if (pageinfo != null && pageinfo.RecordCount >= 1)
{
string url = "/notice/index.aspx?cate_id=" + CateInfo.Notice_Cate_ID;
Response.Write("<div style=\" float:right; padding-right:30px; padding-bottom:5px;\">");
pub.Page(pageinfo.PageCount, pageinfo.CurrentPage, url, pageinfo.PageSize, pageinfo.RecordCount);
Response.Write("</div>");
}
Response.Write(" </div>");
Response.Write("</div>");
}
else
{
Response.Write("<div id=\"help-right\">");
Response.Write(" <h3>热点公告</h3>");
Response.Write(" <div id=\"help-rightwen1\">");
Response.Write(" <ul>");
QueryInfo Query = new QueryInfo();
Query.PageSize = 20;
Query.CurrentPage = 1;
Query.ParamInfos.Add(new ParamInfo("AND", "int", "NoticeInfo.Notice_IsAudit", "=", "1"));
Query.ParamInfos.Add(new ParamInfo("AND", "int", "NoticeInfo.Notice_IsHot", "=", "1"));
Query.ParamInfos.Add(new ParamInfo("AND", "str", "NoticeInfo.Notice_Site", "=", "CN"));
Query.OrderInfos.Add(new OrderInfo("NoticeInfo.Notice_ID", "DESC"));
IList <NoticeInfo> notices = Webnotice.GetNotices(Query, pub.CreateUserPrivilege("9d4d1366-35ab-4eb6-b88e-e49e6bfae9d7"));
if (notices != null)
{
foreach (NoticeInfo entity in notices)
{
Response.Write("<li><span>[ " + entity.Notice_Addtime.ToString("yy-MM-dd") + " ]</span><a href=\"/notice/detail.aspx?notice_id=" + entity.Notice_ID + "\">" + tools.CutStr(entity.Notice_Title, 35) + "</a></li>");
}
}
else
{
Response.Write("<div height=\"50\" style=\" height:50px; text-align:center;line-height:50px; color:#707070;\">信息正在维护中...</div>");
}
Response.Write(" </ul>");
PageInfo pageinfo = Webnotice.GetPageInfo(Query, pub.CreateUserPrivilege("9d4d1366-35ab-4eb6-b88e-e49e6bfae9d7"));
if (pageinfo != null && pageinfo.RecordCount > 0)
{
string url = "/notice/index.aspx?cate_id=0";
Response.Write("<div style=\" float:right; padding-right:30px; padding-bottom:5px;\">");
pub.Page(pageinfo.PageCount, pageinfo.CurrentPage, url, pageinfo.PageSize, pageinfo.RecordCount);
Response.Write("</div>");
}
Response.Write(" </div>");
Response.Write("</div>");
}
}
public string GetNotices()
{
string keyword = tools.CheckStr(Request["keyword"]);
int CateID = tools.CheckInt(Request["CateID"]);
QueryInfo Query = new QueryInfo();
Query.PageSize = tools.CheckInt(Request["rows"]);
Query.CurrentPage = tools.CheckInt(Request["page"]);
if (CateID > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "NoticeInfo.Notice_Cate", "=", CateID.ToString()));
}
if (keyword.Length > 0)
{
Query.ParamInfos.Add(new ParamInfo("AND", "str", "NoticeInfo.Notice_Title", "like", keyword));
}
Query.ParamInfos.Add(new ParamInfo("AND", "str", "NoticeInfo.Notice_Site", "=", Public.GetCurrentSite()));
Query.OrderInfos.Add(new OrderInfo(tools.CheckStr(Request["sidx"]), tools.CheckStr(Request["sord"])));
PageInfo pageinfo = MyBLL.GetPageInfo(Query, Public.GetUserPrivilege());
NoticeCateInfo CateInfo;
IList <NoticeInfo> entitys = MyBLL.GetNotices(Query, Public.GetUserPrivilege());
if (entitys != null)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"page\":" + pageinfo.CurrentPage + ",\"total\":" + pageinfo.PageCount + ",\"records\":" + pageinfo.RecordCount + ",\"rows\"");
jsonBuilder.Append(":[");
foreach (NoticeInfo entity in entitys)
{
CateInfo = noticeCate.GetNoticeCateByID(entity.Notice_Cate);
jsonBuilder.Append("{\"NoticeInfo.Notice_ID\":" + entity.Notice_ID + ",\"cell\":[");
//各字段
jsonBuilder.Append("\"");
jsonBuilder.Append(entity.Notice_ID);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append(Public.JsonStr(entity.Notice_Title));
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (CateInfo != null)
{
jsonBuilder.Append(Public.JsonStr(CateInfo.Notice_Cate_Name));
}
else
{
jsonBuilder.Append(entity.Notice_Cate);
}
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
if (Public.CheckPrivilege("34e5a2e1-5126-4a1f-ad23-dbe7f9e7528a"))
{
jsonBuilder.Append("<img src=\\\"/images/icon_edit.gif\\\" alt=\\\"修改\\\"> <a href=\\\"notice_edit.aspx?notice_id=" + entity.Notice_ID + "\\\" title=\\\"修改\\\">修改</a>");
}
if (Public.CheckPrivilege("2c551863-a2bd-44a8-aef9-512784f0f4a0"))
{
jsonBuilder.Append(" <img src=\\\"/images/icon_del.gif\\\" alt=\\\"删除\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"confirmdelete('notice_do.aspx?action=move¬ice_id=" + entity.Notice_ID + "')\\\" title=\\\"删除\\\">删除</a>");
}
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
else
{
return(null);
}
}
