createitem.cs

中国海洋大学211工程网站的全部源码

using System;
using System.Data;

namespace _211
{
	/// <summary>
	/// CreateItem 的摘要说明。
	/// </summary>
	public class CreateItem:CreateHtml
	{
		private int ItemId;
		private int pagesize=10;
		private string ItemName;

		public CreateItem(int IID):base("contentitem")
		{
			ItemId=IID;
			ItemName=DBQuery.ExecuteScalar("select top 1 ItemName from [Item] where ItemId="+IID).ToString();
		}

		protected override void setContent()
		{
			base.setContent ();
			setConnect();
			setEnter();
			setLink();
			setBlank();
		}

		public void setItemId(int IID)
		{
			ItemId=IID;
			ItemName=DBQuery.ExecuteScalar("select top 1 ItemName from [Item] where ItemId="+IID).ToString();
			ReSet();
		}

		public void Add()
		{
			int pagecount=0;
			int temp=(int)DBQuery.ExecuteScalar("select count(ArticleId) from [Article] where Article.ItemId="+ItemId);
			if(temp%pagesize==0)pagecount=temp/pagesize-1;
			else pagecount=temp/pagesize;
			if(pagecount>0)
			{
				for(int i=0;i<=pagecount;i++)
				{
					AddItemPage (ItemName, "Item_"+ItemId+"_"+i,i,pagecount);
					ReSet();
				}
			}
			else
			{
				AddItemPage (ItemName, "Item_"+ItemId+"_0",0,pagecount);
			}
		}

		protected void AddItemPage(string title,string FileName,int page,int pagecount)
		{
			DataTable dt=TableQuery.ArticleItemByPageQuery(pagesize,page,ItemId.ToString());
			string temp="";

			if(dt.Rows.Count>0)
			{
				temp+="<table width=540 border=0 cellpadding=0 cellspacing=0 bgcolor=#F3F0E7>\n";
				for(int i=0;i<dt.Rows.Count;i++)
				{
					temp+="<tr><td width=40 align=center><img src='images/icon.gif' width=10 height=20></td>";
					temp+="<td background='images/bg_line.gif'><a href='"+dt.Rows[i][0].ToString()+".htm' title='"+dt.Rows[i][1].ToString()+"'>"+StringManager.StringCut(dt.Rows[i][1].ToString(),30)+"</a>&nbsp;&nbsp;["+StringManager.TimeMessage(dt.Rows[i][2].ToString())+"]</td></tr>\n";
				}
				temp+="<tr><td align=right colspan=2>";
				for(int i=0;i<=pagecount;i++)
				{
					if(page==i)
						temp+="<strong>"+(i+1)+"</strong>&nbsp;";
					else
						temp+="<a href='Item_"+ItemId+"_"+i+".htm'>"+(i+1)+"</a>&nbsp;";
				}
				temp+="</td></tr><tr><td height=2 align=center colspan=2></td></tr></table>\n";
			}

			setHead(title);
			setBody();
			HtmlWeb.Replace("[$$$itemlist$$$]",FileOperate.ReadModel("item").Replace("[$$$list$$$]",temp).Replace("[$$$more$$$]","").Replace("[$$$name$$$]",ItemName));
			FileOperate.AddStaticWeb(HtmlWeb,FileName);
		}
	}
}