protected void Page_Load(object sender, EventArgs e)
{
using (SiteBLL bll = new SiteBLL())
{
//友情链接
this.rpt_list_link.DataSource = bll.GetList<EmptyTable>("select * from Com_FrendLink where YN_State=0 order by YN_FlSortNumber desc,YN_id desc");
this.rpt_list_link.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sql = @" select top 3 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and CategoryID={0} and Imgurl<>'' and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc
";
sql = string.Format(sql, ClassID);
using (SiteBLL bll = new SiteBLL())
{
List<EmptyTable> ls = bll.GetList<EmptyTable>(sql);
string ids = string.Empty;
if (ls != null && ls.Count > 0)
{
foreach (EmptyTable et in ls)
{
ids += et.Get<string>("ArticleID") + ",";
}
}
this.rpt_List_Photo.DataSource = ls;
sql = @" select top 2 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and CategoryID={0} {1} and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc
";
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
ids = " and ArticleID not in("+ids+")";
}
sql = string.Format(sql, ClassID,ids);
this.rpt_List_News.DataSource = bll.GetList<EmptyTable>(sql);
this.Page.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.ChkAdminLevel("sys_CreatePage", "view");
SiteBLL bll = new SiteBLL();
StringBuilder sb = new StringBuilder();
string f = "<option value=\"{0}\">{1}</option>";
//获取频道信息
List<EmptyTable> ls = bll.GetList<EmptyTable>("select CL_ID, CL_Name,CL_Title from SYS_channel where CL_TypeID=1 order by CL_Sort desc");
List<EmptyTable> inLs = null;
List<EmptyTable> sls = null;
if (ls != null && ls.Count > 0)
{
foreach (EmptyTable ety in ls)
{
sb.AppendLine(string.Format(f, ety.Get<string>("CL_Name") + "|" + ety.Get<int>("CL_ID"), ety.Get<string>("CL_Title")));
//获取频道下的类别
inLs = bll.GetList<EmptyTable>("select CateID,CateCallIndex,Catetitle from SYS_Category where ChannelID=" + ety.Get<int>("CL_ID") + " and CateParentID=0 order by CateSortID desc,CateID desc");
if (inLs != null && inLs.Count > 0)
{
foreach (EmptyTable inety in inLs)
{
sb.AppendLine(string.Format(f, inety.Get<string>("CateCallIndex") + "|" + ety.Get<int>("CL_ID") + "|" + inety.Get<int>("CateID"), "├" + inety.Get<string>("Catetitle")));
sls = bll.GetList<EmptyTable>("select CateID,CateCallIndex,Catetitle from SYS_Category where CateParentID=" + inety.Get<int>("CateID") + " and CateParentID=0 order by CateSortID desc,CateID desc");
if (sls != null && sls.Count > 0)
{
foreach (EmptyTable et in sls)
{
sb.AppendLine(string.Format(f, et.Get<string>("CateCallIndex") + "|" + ety.Get<int>("CL_ID") + "|" + et.Get<int>("CateID"), " ├" + et.Get<string>("Catetitle")));
}
}
}
}
}
}
this.ChannelList = sb.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
using (SiteBLL bll = new SiteBLL())
{
string sql = @" select Catetitle, CateCallIndex,CL_Name from SYS_Category,SYS_channel
where SYS_Category.ChannelID=SYS_channel.CL_ID
and ChannelID={0} and CateClassLayer=1
order by CateSortID desc,CateID desc
";
sql = string.Format(sql, ChannelID);
this.rpt_List.DataSource = bll.GetList<EmptyTable>(sql);
this.rpt_List.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (SiteBLL bll = new SiteBLL())
{
string sql = @" select top {0} CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and CategoryID={1} and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc
";
sql = string.Format(sql, TopCount, ClassID);
this.rpt_List.DataSource = bll.GetList<EmptyTable>(sql);
this.rpt_List.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
ChannelList = GetChanelList();
if (!IsPostBack)
{
base.ChkAdminLevel("export_userarticle", "view");
using (SiteBLL bll = new SiteBLL())
{
ddUserList.DataSource = bll.GetList<EmptyTable>("select MI_ID, MI_UserName from SYS_ManageInfo");
ddUserList.DataTextField = "MI_UserName";
ddUserList.DataValueField = "MI_ID";
ddUserList.DataBind();
ddUserList.Items.Insert(0, new ListItem("请选择", ""));
ddUserList.Items.FindByText("请选择").Selected = true;
}
if(Web9long.Web.Util.Query("exp")=="1")
ExportData();
}
}
/// <summary>
/// 获取频道类别名称
/// </summary>
/// <param name="chid"></param>
/// <returns></returns>
public string getClassLink(int chid, int count)
{
StringBuilder strbuilder = new StringBuilder();
string sql = "select top " + count + " CateCallIndex,Catetitle from SYS_Category where ChannelID=" + chid + " and CateParentID=0 order by CateSortID desc,CateID desc";
using (SiteBLL bll = new SiteBLL())
{
List<EmptyTable> ls = bll.GetList<EmptyTable>(sql);
if (ls != null && ls.Count > 0)
{
foreach (EmptyTable et in ls)
{
strbuilder.AppendFormat("<a href=\"http://" + Web9long.Web.Util.GetHttpUrl() + "{0}/\" target=\"_blank\">{1}</a>", et.Get<string>("CateCallIndex"), et.Get<string>("Catetitle"));
}
}
}
return strbuilder.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
webconfig = Loneu.BLL.Config.WebSiteConfig.Info();
string sql = string.Empty;
string ids = string.Empty;
List<EmptyTable> ls = null;
using (SiteBLL bll = new SiteBLL())
{
#region 今日发布
sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and Islock<>1 and title<>''
order by Addtime desc,Sortid desc,ArticleID desc
";
ls = bll.GetList<EmptyTable>(sql);
if (ls != null && ls.Count > 0)
{
topNews = ls[0];
ls.Remove(topNews);
}
this.rpt_New_9NewsList.DataSource = ls;
#endregion
#region 热点排行
sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao,Imgurl from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and Islock<>1 and title<>'' and Imgurl<>'' and Isred=1
order by Sortid desc,ArticleID desc
";
ls = new List<EmptyTable>();
ls = bll.GetList<EmptyTable>(sql);
if (ls != null && ls.Count > 0)
{
hotNews = ls[0];
ls.Remove(hotNews);
}
this.rpt_Hits_NewsList.DataSource = ls;
#endregion
#region 图文精华
sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao,Imgurl from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and Islock<>1 and title<>'' and Imgurl<>'' and Zhaiyao<>''
order by Addtime desc,ArticleID desc
";
this.rpt_List_PhotoNews.DataSource = bll.GetList<EmptyTable>(sql);
#endregion
//夷木百科及纵览
sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and sys_article.ChannelID=45 and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc";
this.rpt_list_yimu.DataSource = bll.GetList<EmptyTable>(sql);
//数据发布纵横
sql = @" select top 8 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and sys_article.ChannelID=39 and Imgurl<>'' and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc";
rpt_list_PostData.DataSource = bll.GetList<EmptyTable>(sql);
//空气净化器纵览
sql = @" select top 2 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and sys_article.ChannelID=51 and Imgurl<>'' and Islock<>1
order by ArticleID desc
";
ls = bll.GetList<EmptyTable>(sql);
ids = string.Empty;
if (ls != null && ls.Count > 0)
{
foreach (EmptyTable et in ls)
{
ids += et.Get<string>("ArticleID") + ",";
}
}
this.rpt_List_Photo_kongqi.DataSource = ls;
sql = @" select top 5 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and sys_article.ChannelID=51 {0} and Islock<>1
order by ArticleID desc
";
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
ids = " and ArticleID not in(" + ids + ")";
}
sql = string.Format(sql, ids);
this.rpt_List_News_kongqi.DataSource = bll.GetList<EmptyTable>(sql);
//甲醛清除纵览
sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and sys_article.ChannelID=56 and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc";
this.rpt_List_jiaquan.DataSource = bll.GetList<EmptyTable>(sql);
#region 社区生活纵览
sql = @" select top 2 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Imgurl from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and sys_article.ChannelID=2 and Imgurl<>'' and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc";
ls = bll.GetList<EmptyTable>(sql);
this.rpt_list_shenghuo_Photo.DataSource = ls;
ids = string.Empty;
if (ls != null && ls.Count > 0)
{
foreach (EmptyTable et in ls)
{
ids += et.Get<string>("ArticleID") + ",";
}
}
sql = @" select top 5 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and sys_article.ChannelID=2 {0} and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc
";
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
ids = " and ArticleID not in(" + ids + ")";
}
sql = string.Format(sql, ids);
this.rpt_List_shenghuo_news.DataSource = bll.GetList<EmptyTable>(sql);
#endregion
//热点纵览
sql = @" select top 10 CategoryID,title, ArticleID,CateCallIndex,CL_Name from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and sys_article.ChannelID=63 and Islock<>1
order by Istop desc,Sortid desc,ArticleID desc";
rpt_list_Hot.DataSource = bll.GetList<EmptyTable>(sql);
}
this.Page.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
using (SiteBLL bll = new SiteBLL())
{
int newid;
if (!int.TryParse(Web9long.Web.Util.Query("id"), out newid))
Web9long.Web.Clew.AlertBack("参数错误");
etyInfo = bll.GetOnlyRow<EmptyTable>("select * from SYS_Article where ArticleID=" + newid);
etyInfo.Set("content",GetInnerlink(etyInfo.Get<string>("content")));
if (etyInfo == null) Web9long.Web.Clew.AlertBack("查找的信息不存在");
etyChannel = bll.GetOnlyRow<EmptyTable>("select * from SYS_channel where CL_ID=" + etyInfo.Get<string>("ChannelID"));
etyClass = bll.GetOnlyRow<EmptyTable>("select * from SYS_Category where CateID=" + etyInfo.Get<string>("CategoryID"));
string sql = @" select top 11 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao,Catetitle from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and Islock<>1 and Isred=1
order by Addtime desc,Sortid desc,ArticleID desc
";
List<EmptyTable> ls = bll.GetList<EmptyTable>(sql);
if (ls != null && ls.Count > 0)
{
topety = ls[0];
ls.Remove(topety);
}
this.rpt_list_tuijian.DataSource = ls;
//频道精华
sql = @" select top 11 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and Islock<>1 and Isred=1 {0}
order by Sortid desc,Addtime desc,ArticleID desc
";
sql = string.Format(sql, " and sys_article.ChannelID=" + etyInfo.Get<string>("ChannelID"));
this.rpt_topNew.DataSource = bll.GetList<EmptyTable>(sql);
//相关文章
sql = @" select top 6 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao,Imgurl,Seokeywords from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and Islock<>1 and Imgurl<>'' {0}
order by Sortid desc,Addtime desc,ArticleID desc
";
StringBuilder sb = new StringBuilder();
string keywwords=etyInfo.Get<string>("Seokeywords");
if(string.IsNullOrEmpty(keywwords))
{
string[] a = keywwords.Split(',');
if (a.Length > 0)
{
sb.Append(" and (");
int i = 0;
foreach (string s in a)
{
if(i==0)
sb.Append(" Seokeywords like '%" + s + ",'");
else
sb.Append(" or Seokeywords like '%" + s + ",'");
}
sb.Append(")");
}
}
sql = string.Format(sql,sb.ToString());
ls = bll.GetList<EmptyTable>(sql);
rpt_list_6More.DataSource = ls;
this.Page.DataBind();
}
}
/// <summary>
/// 添加站内链接
/// </summary>
/// <param name="strcontent"></param>
/// <returns></returns>
public string GetInnerlink(string strcontent)
{
string rs = strcontent;
using (SiteBLL bll = new SiteBLL())
{
List<EmptyTable> ls = bll.GetList<EmptyTable>("select * from Com_InnerLink where YN_State=0");
string inlink = string.Empty;
foreach (EmptyTable et in ls)
{
inlink = et.Get<string>("YN_LinkTitle");
if (strcontent.IndexOf(inlink)!=-1)
{
inlink = " <a style=\"color:Blue\" href=\"" + et.Get<string>("YN_FLSiteURL") + "\" title=\"" + et.Get<string>("YN_LinkDesc") + "\" target=\"_blank\">" + et.Get<string>("YN_LinkTitle") + "</a> ";
rs = rs.Replace(et.Get<string>("YN_LinkTitle"),inlink);
}
}
}
return rs;
}
protected void Page_Load(object sender, EventArgs e)
{
using (SiteBLL bll = new SiteBLL())
{
if (!int.TryParse(Web9long.Web.Util.Query("channelid"), out channelid)) Web9long.Web.Clew.AlertBack("参数错误");
if (!int.TryParse(Web9long.Web.Util.Query("classid"), out categoryid)) categoryid = 0;
//绑定频道下的类别
List<EmptyTable> ls = bll.GetList<EmptyTable>("select CateID,CateCallIndex,Catetitle,Cateseotitle,Cateseokeywords,Cateseodescription from SYS_Category where ChannelID=" + this.channelid + " order by CateSortID desc,CateID desc");
if (ls != null && ls.Count > 0)
{
foreach (EmptyTable et in ls)
{
if (et.Get<int>("CateID") == categoryid)
etyClass = et;
break;
}
}
etyChannel = bll.GetOnlyRow<EmptyTable>("select * from SYS_channel where CL_ID=" + channelid);
seotitle = etyChannel.Get<string>("CL_SeoTitle");
seokeywords = etyChannel.Get<string>("CL_Keywords");
seodes = etyChannel.Get<string>("CL_Description");
if (categoryid > 0)
{
etyClass = bll.GetOnlyRow<EmptyTable>("select * from SYS_Category where CateID=" + categoryid);
seotitle = etyClass.Get<string>("Cateseotitle");
seokeywords = etyClass.Get<string>("Cateseokeywords");
seodes = etyClass.Get<string>("Cateseodescription");
}
Com_Config webconfig = Loneu.BLL.Config.WebSiteConfig.Info();
this.rpt_class.DataSource = ls;
this.rpt_class.DataBind();
//内容列表
HtmlPageUrl1.Pagesize = 15;
HtmlPageUrl1.Nowpage = int.Parse(Web9long.Web.Util.Query("AsPage"));
HtmlPageUrl1.Allcount = int.Parse(Web9long.Web.Util.Query("AsCount"));
if (categoryid > 0)
{
HtmlPageUrl1.Pagename = "List_" + categoryid.ToString();
}
else
{
HtmlPageUrl1.Pagename = "List_" + channelid.ToString();
}
Web9long.DB.SqlCreate strsql = new Web9long.DB.MSSQL().GetSqlCreate();
strsql.Table = "(select ArticleID,SYS_Article.ChannelID,CategoryID,title,Sortid,Addtime,Ismsg,Istop,Isred,Ishot,Isslide,Catetitle,CateCallIndex,Zhaiyao from SYS_Article,SYS_Category where CategoryID=CateID ) t";
strsql.Fild = "ArticleID,ChannelID,CategoryID,title,Sortid,Addtime,Ismsg,Istop,Isred,Ishot,Isslide,Catetitle,CateCallIndex,Zhaiyao";
strsql.Order = "order by Istop desc,Sortid desc,ArticleID desc";
strsql.AddAndWhere(" ChannelID=" + this.channelid);
if (this.categoryid > 0)
strsql.AddAndWhere("CategoryID=" + this.categoryid);
if (AsGet2.Count == 0)
AsGet2.Count = bll.GetCount(AsGet2.MakeCountSql(strsql.Table, strsql.Where));
AsGet2.Compute();
this.rpt_ContentList.DataSource = bll.GetList<EmptyTable>(AsGet2.MakeSql(strsql.Fild, strsql.Table, strsql.Where, "ArticleID", strsql.Order));
this.rpt_ContentList.DataBind();
string sql = @" select top 10 CategoryID,Catetitle, title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and Islock<>1 {0}
order by ClickHits desc,Sortid desc,ArticleID desc
";
if (this.categoryid > 0)
{
sql = string.Format(sql, " and sys_article.ChannelID=" + this.channelid + " and SYS_Article.CategoryID=" + this.categoryid);
}
else
{
sql = string.Format(sql, " and sys_article.ChannelID=" + this.channelid);
}
this.rpt_list_hot.DataSource = bll.GetList<EmptyTable>(sql);
sql = @" select top 11 CategoryID,title, ArticleID,CateCallIndex,CL_Name,Addtime,Zhaiyao,Catetitle from SYS_Article,SYS_Category,SYS_channel
where SYS_Article.CategoryID=SYS_Category.CateID and sys_article.ChannelID=SYS_channel.CL_ID
and Islock<>1 and Isred=1
order by Addtime desc,Sortid desc,ArticleID desc
";
ls = bll.GetList<EmptyTable>(sql);
if (ls != null && ls.Count > 0)
{
topety = ls[0];
ls.Remove(topety);
}
this.rpt_list_tuijian.DataSource = ls;
this.Page.DataBind();
}
}
/// <summary>
/// 获取频道中的栏目列表
/// </summary>
/// <returns></returns>
public string GetChanelList()
{
StringBuilder sb = new StringBuilder();
string f = "<option value=\"{0}\">{1}</option>";
sb.AppendLine("<option value=\"\" selected=\"selected\">请选择</option>");
using (SiteBLL bll = new SiteBLL())
{
//获取频道信息
List<EmptyTable> ls = bll.GetList<EmptyTable>("select CL_ID, CL_Name,CL_Title from SYS_channel where CL_TypeID=1 order by CL_Sort desc");
List<EmptyTable> inLs = null;
List<EmptyTable> sls = null;
if (ls != null && ls.Count > 0)
{
foreach (EmptyTable ety in ls)
{
sb.AppendLine(string.Format(f, ety.Get<int>("CL_ID"), ety.Get<string>("CL_Title")));
//获取频道下的类别
inLs = bll.GetList<EmptyTable>("select CateID,CateCallIndex,Catetitle from SYS_Category where ChannelID=" + ety.Get<int>("CL_ID") + " and CateParentID=0 order by CateSortID desc,CateID desc");
if (inLs != null && inLs.Count > 0)
{
foreach (EmptyTable inety in inLs)
{
sb.AppendLine(string.Format(f, ety.Get<int>("CL_ID") + "|" + inety.Get<int>("CateID"), "├" + inety.Get<string>("Catetitle")));
sls = bll.GetList<EmptyTable>("select CateID,CateCallIndex,Catetitle from SYS_Category where CateParentID=" + inety.Get<int>("CateID") + " and CateParentID=0 order by CateSortID desc,CateID desc");
if (sls != null && sls.Count > 0)
{
foreach (EmptyTable et in sls)
{
sb.AppendLine(string.Format(f, ety.Get<int>("CL_ID") + "|" + et.Get<int>("CateID"), " ├" + et.Get<string>("Catetitle")));
}
}
}
}
}
}
}
return sb.ToString();
}
public void CreateSiteHtml()
{
string strFileName = Loneu.Common.File.CommFile.ReadFile(Server.MapPath("newbar.html"));
Response.Write(strFileName);
string pagePath = string.Empty;
string webUrl = string.Empty;
string newPageName = string.Empty;
bool rs;
//文件夹
string contentpath = string.Empty;
List<EmptyTable> lsety = null;
int allcount, pagesize=15,allpages=1, pagecount=5;
//生成内容页
string sql = "select ArticleID,CateCallIndex from SYS_Article as a inner join SYS_Category as b on a.CategoryID=b.CateID where a.Islock=0 {0} order by Addtime desc ";
string spandate = ContentSpan();
sql = string.Format(sql,spandate);
using (SiteBLL bll = new SiteBLL())
{
lsety = bll.GetList<EmptyTable>(sql);
if (lsety != null && lsety.Count > 0)
{
int count = lsety.Count;
for (int i = 1; i <= lsety.Count; i++)
{
if (i == 1)
{
Response.Write("<script>SetTitle('开始生成内容页');</script>");
}
Response.Write("<script>loadBar(" + i + "," + lsety.Count + ");</script>");
contentpath = Server.MapPath("../../" + lsety[i - 1].Get<string>("CateCallIndex") + "/");
if (!System.IO.Directory.Exists(contentpath)) System.IO.Directory.CreateDirectory(contentpath);
webUrl = websiteurl + "NewsShow.aspx?id=" + lsety[i - 1].Get<int>("ArticleID");
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(webUrl, contentpath, lsety[i - 1].Get<int>("ArticleID") + ".html");
Thread.Sleep(100);
}
}
else
{
Response.Write("<b>恭喜，一键生成完成！</b>");
Response.End();
}
}
string weburls = string.Empty;
string pagename = "List_{0}_{1}.html";
string pagenames = string.Empty;
//生成列表页
// sql = "select a.CateCallIndex,a.CateID,b.CL_ID,b.CL_Name from SYS_Category as a inner join SYS_Channel as b on a.ChannelID=b.CL_ID";
#region 生成频道列表页
sql = "select CL_ID,CL_Name from SYS_Channel order by CL_ID desc";
using (SiteBLL bll = new SiteBLL())
{
lsety = bll.GetList<EmptyTable>(sql);
if (lsety != null && lsety.Count > 0)
{
//生成列表
foreach (EmptyTable et in lsety)
{
contentpath = Server.MapPath("../../" + et.Get<string>("CL_Name") + "/");
if (!System.IO.Directory.Exists(contentpath)) System.IO.Directory.CreateDirectory(contentpath);
//生成频道列表
allcount = bll.GetCount("select count(1) from SYS_Article where Islock=0 and ChannelID=" + et.Get<int>("CL_ID"));
webUrl = websiteurl + "NewsList.aspx?channelid=" + et.Get<int>("CL_ID") + "&AsPage={0}&AsCount=" + allcount;
if (allcount % pagesize == 0)
{
allpages = allcount / pagesize;
}
else
{
allpages = (allcount / pagesize) + 1;
}
//添加最大页数限制
if (pagecount != 0 && pagecount < allpages)
allpages = pagecount;
for (int i = 1; i <= allpages; i++)
{
weburls = string.Format(webUrl, i);
pagenames = string.Format(pagename, et.Get<int>("CL_ID"),i);
if (i == 1)
{
//Response.Write(System.DateTime.Now.ToString("g") + ":开始生成频道列表页...");
//Response.Write(strFileName);
Response.Write("<script>SetTitle('开始生成频道列表页');</script>");
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(weburls, contentpath, pagenames);
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(weburls, contentpath, "index.html");
}
else
{
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(weburls, contentpath, pagenames);
}
Response.Write("<script>loadBar(" + i + "," + allpages + ");</script>");
Thread.Sleep(100);
}
}
}
//生成首页
pagePath = Server.MapPath("../../");
webUrl = websiteurl + "Index.aspx";
newPageName = "index.html";
rs = Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(webUrl, pagePath, newPageName);
Response.Write("<script>SetTitle('开始生成首页');</script>");
Response.Write("<script>loadBar(1,1);</script>");
}
#endregion
#region 生成类别列表
sql = "select a.CateCallIndex,a.CateID,b.CL_ID,b.CL_Name from SYS_Category as a inner join SYS_Channel as b on a.ChannelID=b.CL_ID";
using (SiteBLL bll = new SiteBLL())
{
lsety = bll.GetList<EmptyTable>(sql);
if (lsety != null && lsety.Count > 0)
{
//生成列表
foreach (EmptyTable et in lsety)
{
contentpath = Server.MapPath("../../" + et.Get<string>("CateCallIndex") + "/");
if (!System.IO.Directory.Exists(contentpath)) System.IO.Directory.CreateDirectory(contentpath);
//生类别列表
allcount = bll.GetCount("select count(1) from SYS_Article where Islock=0 and CategoryID=" + et.Get<int>("CateID"));
webUrl = websiteurl + "NewsList.aspx?channelid=" + et.Get<int>("CL_ID") + "&classid=" + et.Get<int>("CateID") + "&AsPage={0}&AsCount=" + allcount;
if (allcount % pagesize == 0)
{
allpages = allcount / pagesize;
}
else
{
allpages = (allcount / pagesize) + 1;
}
//添加最大页数限制
if (pagecount != 0 && pagecount < allpages)
allpages = pagecount;
for (int i = 1; i <= allpages; i++)
{
weburls = string.Format(webUrl, i);
pagenames = string.Format(pagename, et.Get<int>("CL_ID"), i);
if (i == 1)
{
//Response.Write(System.DateTime.Now.ToString("g") + ":开始生成栏目列表页...");
//Response.Write(strFileName);
Response.Write("<script>SetTitle('开始生成栏目列表页');</script>");
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(weburls, contentpath, pagenames);
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(weburls, contentpath, "index.html");
}
else
{
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(weburls, contentpath, pagenames);
}
Response.Write("<script>loadBar(" + i + "," + allpages + ");</script>");
Thread.Sleep(100);
}
}
}
}
#endregion
Response.Write("<b>恭喜，一键生成完成！</b>");
}
void CreateContentHtml()
{
string dir = string.Empty;
string cateid = string.Empty;
string chid = string.Empty;
bool ischanel = false;
List<EmptyTable> lsety = null;
string sql = string.Empty;
string strFileName = Loneu.Common.File.CommFile.ReadFile(Server.MapPath("bar.htm"));
string weburl = string.Empty;
//获取生成参数
string strclass = Web9long.Web.Util.Query("newslist");
string[] a = strclass.Split('|');
if (a.Length == 2)
{
dir = a[0];
chid = a[1];
ischanel = true;
}
else
{
dir = a[0];
chid = a[1];
cateid = a[2];
}
//生成文件夹
string contentpath = Server.MapPath("../../" + dir + "/");
if (!System.IO.Directory.Exists(contentpath)) System.IO.Directory.CreateDirectory(contentpath);
//频道内容生成
if (ischanel)
{
sql = "select ArticleID,CateCallIndex from SYS_Article,SYS_Category where SYS_Article.CategoryID=SYS_Category.CateID and Islock<>1 " + ContentSpan() + " {0} order by Addtime desc ";
sql = string.Format(sql, " and SYS_Article.ChannelID=" + chid);
using (SiteBLL bll = new SiteBLL())
{
lsety = bll.GetList<EmptyTable>(sql);
if (lsety != null && lsety.Count > 0)
{
int count = lsety.Count;
for (int i = 1; i <= lsety.Count; i++)
{
contentpath = Server.MapPath("../../" + lsety[i - 1].Get<string>("CateCallIndex") + "/");
if (!System.IO.Directory.Exists(contentpath)) System.IO.Directory.CreateDirectory(contentpath);
if (i == 1)
{
Response.Write(strFileName);
}
Response.Write("<script>loadBar(" + i + "," + count + ");</script>");
weburl = websiteurl + "NewsShow.aspx?id=" + lsety[i - 1].Get<int>("ArticleID");
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(weburl, contentpath, lsety[i - 1].Get<int>("ArticleID") + ".html");
Thread.Sleep(100);
}
}
}
}
else
{
sql = "select ArticleID ,CateCallIndex from SYS_Article,SYS_Category where SYS_Article.CategoryID=SYS_Category.CateID and Islock<>1 " + ContentSpan() + " and CategoryID=" + cateid + " and SYS_Article.ChannelID=" + chid + " order by Addtime desc ";
using (SiteBLL bll = new SiteBLL())
{
//类别内容生成
lsety = bll.GetList<EmptyTable>(sql);
if (lsety != null && lsety.Count > 0)
{
int count = lsety.Count;
for (int i = 1; i <= lsety.Count; i++)
{
contentpath = Server.MapPath("../../" + lsety[i - 1].Get<string>("CateCallIndex") + "/");
if (!System.IO.Directory.Exists(contentpath)) System.IO.Directory.CreateDirectory(contentpath);
if (i == 1)
{
Response.Write(strFileName);
}
Response.Write("<script>loadBar(" + i + "," + count + ");</script>");
weburl = websiteurl + "NewsShow.aspx?id=" + lsety[i - 1].Get<int>("ArticleID");
Loneu.Web.UI.ComPage.CreatePage.CreateOnePage(weburl, contentpath, lsety[i - 1].Get<int>("ArticleID") + ".html");
Thread.Sleep(100);
}
}
}
}
}