cms.cs

一阵子

			foreach(DataRow dr in dt.Rows)
			{
				sb.Append(String.Format(" <table align='center' width='210' border='0' cellspacing='0' cellpadding='0'><tr align='center' ><td width='54' height='40' align='right' valign='middle'> <img src='images/head1.gif' width='40' height='40'> </td><td><table width='150' border='0' align='center' cellpadding='0' cellspacing='0'><tr><td height='18'><a href='viewuser.aspx?username={0}'>{0}</a> <FONT color='#808080'>{2}</font>说：</td></tr><tr><td height='4'><img src='images/7.gif' width='140' height='3'></td></tr><tr><td height='18'>{1}</td></tr></table></td></tr></table>",
					dr["UserName"].ToString(), dr["body"].ToString(), dr["CreatedDate"].ToString()));
			}

			return sb.ToString();
		}

		public static string GenerateMessageList2(DataTable dt)
		{
			if(dt.Rows.Count ==0)
				return "<table align='left' width='290' border='0' cellspacing='0' cellpadding='0'><tr align='center'><td></td></tr></table>";

			StringBuilder sb = new StringBuilder();
			foreach(DataRow dr in dt.Rows)
			{
				sb.Append(String.Format(" <table align='center' width='290' border='0' cellspacing='0' cellpadding='0'><tr align='center' ><td width='54' height='40' align='right' valign='middle'> <img src='images/head1.gif' width='40' height='40'> </td><td><table width='220' border='0' align='center' cellpadding='0' cellspacing='0'><tr><td height='18'><a href='viewuser.aspx?username={0}'>{0}</a> <FONT color='#808080'>{2}</font>说：</td></tr><tr><td height='4'><img src='images/7.gif' width='140' height='3'></td></tr><tr><td height='18'>{1}</td></tr></table></td></tr></table>",
					dr["UserName"].ToString(), dr["body"].ToString(), dr["CreatedDate"].ToString()));
			}

			return sb.ToString();
		}

		public static string GenerateRecentComments(DataTable dt)
		{
			StringBuilder sb = new StringBuilder();
			
			foreach(DataRow dr in dt.Rows)
			{
				sb.Append("<table width='190' border='0' align='center' cellpadding='0' cellspacing='0'>");
				sb.Append(String.Format("<tr><td width='30' height='20' align='center'><img src='images/newwin.gif' width='14' height='11'></td><td width='170'><a href='viewitem.aspx?itemid={1}'>{0}</a></td></tr>",
					dr["Body"].ToString(), dr["ItemID"].ToString()));
				sb.Append("</table>");
			}

			return sb.ToString();
		}
		
		#region RSS
		public static void GetUserRSS(XmlTextWriter writer, string userID)
		{
			DataTable dt = Framework.GetUserItems(userID);
			CMS.GetRSS(writer,dt);
		}

		public static void GetRSS(XmlTextWriter writer, int number)
		{
			DataTable dt = Framework.GetTopItems(20);
			CMS.GetRSS(writer,dt);
		}
		
		public static void GetRSS(XmlTextWriter writer, DataTable dt)
		{
			string author = "[e-mail]";
			string lang = "zh-cn";
			string generator = "powered by podlook.com";

			//StartDocument()
			writer.Formatting = Formatting.Indented;
			writer.WriteStartDocument();						
			writer.WriteStartElement("rss");			
			writer.WriteAttributeString("version","2.0");
					
			//SetNamespaces()
			writer.WriteAttributeString("xmlns:dc","http://purl.org/dc/elements/1.1/");
			writer.WriteAttributeString("xmlns:trackback","http://madskills.com/public/xml/rss/module/trackback/");
			writer.WriteAttributeString("xmlns:wfw","http://wellformedweb.org/CommentAPI/");
			writer.WriteAttributeString("xmlns:slash","http://purl.org/rss/1.0/modules/slash/");

			//StartChannel()
			writer.WriteStartElement("channel");

			//WriteChannel()
			writer.WriteElementString("title","节目RSS");			
			writer.WriteElementString("link","http://www.podlook.com");
			writer.WriteElementString("description","节目RSS");
			writer.WriteElementString("managingEditor",author);
			writer.WriteElementString("dc:language",lang);
			writer.WriteElementString("generator",generator);

			//WalkEntries()
			if(dt !=null)
			{
				foreach(DataRow dr in dt.Rows)
				{
					string itemTitle = dr["ItemTitle"].ToString();

					//Need to to changed
					string itemLink = "http://psp.podlook.com/viewitem.aspx?itemid="+ dr["ItemID"].ToString();

					string pubDate = Convert.ToDateTime(dr["CreatedDate"].ToString()).ToString("r");
					string desc = dr["ItemDesc"].ToString();
					string audioLink = dr["ItemLink"].ToString();
					string length = "-1";
					if(length == "-1")	length = "1";

					writer.WriteStartElement("item");									
					writer.WriteElementString("title",itemTitle);
					writer.WriteStartElement("description");
					writer.WriteCData(desc);
					writer.WriteEndElement();

					try
					{
						writer.WriteElementString("link",itemLink);		
					}
					catch{writer.WriteElementString("link","http://www.podlook.com");}
					writer.WriteElementString("pubDate",pubDate);									

					writer.WriteStartElement("enclosure");
					try
					{
						writer.WriteAttributeString("url",audioLink);
					}
					catch{writer.WriteAttributeString("url","http://www.podlook.com");}
					writer.WriteAttributeString("length",length);
					string type = "application/x-shockwave-flash"; 

					writer.WriteAttributeString("type",type);
					writer.WriteEndElement();

					writer.WriteEndElement();					
				}
			}
			else
			{
				writer.WriteStartElement("item");				
				
				writer.WriteElementString("title","No Content");
				writer.WriteStartElement("description");
				writer.WriteCData("No Desciption");
				writer.WriteEndElement();
				writer.WriteElementString("link","http://www.podlook.com");
				writer.WriteElementString("pubDate",DateTime.Now.ToString());

				writer.WriteEndElement();
			}

			//EndChannel()
			writer.WriteEndElement();

			//EndDocument()
			writer.WriteEndElement();			
			writer.WriteEndDocument();
		}
		#endregion	


		#region Utilities
		public static string GetPageFooter(string url, int pageIndex, int pageSize, int totalCount)
		{
			int totalPages = totalCount/pageSize;
			if(totalCount%pageSize != 0)
			{
				totalPages +=1;
			}

			if(totalPages == 1)
				return "";

			if(totalPages > 120)
				totalPages = 120;

			StringBuilder sb= new StringBuilder();
			string constr = "?";
			if(url.IndexOf('?') != -1 || ! url.ToLower().EndsWith(".aspx"))
				constr = "&";

			sb.Append("<div align='right' style='width:100%'>");
				
			if(pageIndex>1)
			{
				sb.Append(String.Format("<a href={0}{1}page={2}>上一页</a> ",url,constr,pageIndex-1));
			}

			int start = 1;
			if(pageIndex>10)
				start = pageIndex - 10;

			int end = totalPages;
			if(totalPages > pageIndex+9)
				end = pageIndex+9;

			for(int i=start; i<=end; i++)
			{
				if(pageIndex != i)
				{
					sb.Append(String.Format("<a href={0}{1}page={2}>{2}</a> ",url,constr,i));
				}
				else
				{
					sb.Append(String.Format("<b>{0}</b> ", i));
				}
			}
			if(pageIndex < totalPages)
			{
				sb.Append(String.Format("<a href={0}{1}page={2}>下一页</a>",url,constr,pageIndex+1));									
			}
			sb.Append("</div>");
			return sb.ToString();
		}

		public static string HandleString(string s)
		{
			string ss = s.Replace("'", "");
			ss = ss.Replace(";", "");
			ss = ss.Replace("-", "");
			return ss;
		}
		#endregion
		
	}
}