using System;
using System.Data;

namespace _211
{
	/// <summary>
	/// CreateClass 的摘要說明。
	/// </summary>
	public class CreateClass:CreateHtml
	{
		private int ClassId;
		private string ClassName;
		int itemlistcount=3;

		public CreateClass(int CID):base("contentclass")
		{
			ClassId=CID;
			ClassName=DBQuery.ExecuteScalar("select top 1 ClassName from [Class] where ClassId="+CID).ToString();
		}

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

		public void setClassId(int CID)
		{
			ClassId=CID;
			ClassName=DBQuery.ExecuteScalar("select top 1 ClassName from [Class] where ClassId="+CID).ToString();
			ReSet();
		}

		public void Add()
		{
			setHead(ClassName);
			setBody();

			string temp="";
			DataTable dt=TableQuery.ItemQuery(ClassId.ToString());
			for(int i=0;i<dt.Rows.Count;i++)
			{
				temp+=ItemStr(dt.Rows[i][0].ToString(),itemlistcount);
				temp+=BlankStr(5);
			}
			HtmlWeb.Replace("[$$$classlist$$$]",temp);
			FileOperate.AddStaticWeb(HtmlWeb,"Class_"+ClassId);
		}

		protected override string ItemStr(string IID,int count)
		{
			DataTable dt=TableQuery.ArticleItemQuery(IID,count);

			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 height=2 align=center colspan=2></td></tr></table>\n";
			}

			return FileOperate.ReadModel("item").Replace("[$$$list$$$]",temp).Replace("[$$$more$$$]","<a href='Item_"+IID+"_0.htm'>更多...</a>").Replace("[$$$name$$$]",TableQuery.ItemNameQuery(Convert.ToInt32(IID)));
		}
	}
}