disaplymessage.ascx.cs

很不错的公文流转系统

namespace OI.UserControls
{
	using System; 
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
    
	/// <summary>
	///		DisaplyMessage 的摘要说明。
	/// </summary>
	public class DisaplyMessage : System.Web.UI.UserControl
	{
        private string sql="select top 5 * from kindsmessage order by PublicizeDate desc";
		private string title ="title";
		private string sid="MessageID" ;
		private string url="View_MessageManage.aspx?id=";
		private int maxtitlelength=12;
		protected System.Web.UI.WebControls.Table TableMessage;
		DataSet ds ;
		OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		/// <summary>
		/// Sql:操作数据库语句
		/// </summary>
		public string Sql
		{
			set { sql=value;}
		}
		/// <summary>
		/// Title:标题字段名称
		/// </summary>
		public string Title
		{
			set {title=value;}
		}
		/// <summary>
		/// KeyID:唯一标识的id号
		/// </summary>
		public string KeyID
		{
			set {sid=value;}
		}
		/// <summary>
		/// Url:连接路径,例如:View_MessageManage.aspx?id=
		/// </summary>
		public string Url
		{
			set {url=value;}
		}
		/// <summary>
		/// MaxTitleLength:标题最大长度
		/// </summary>
		public int MaxTitleLength
		{
			set {maxtitlelength=value;}
		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (!Page.IsPostBack )
			{
				CreateDataSource();
				dispay();
			}

		}
		private void CreateDataSource()
		{
			ds=new DataSet ();
			ds=Dbc.getBinding (sql,"t");
		}

		private void dispay()
		{
			foreach (DataRow dr in ds.Tables[0].Rows )
			{
				TableRow tr=new TableRow ();
				TableCell tdW=new TableCell ();
				tdW.Text ="·";
				tr.Cells .Add (tdW);
				TableCell td=new TableCell ();
				if (dr["title"].ToString ().Length >maxtitlelength)
				{
				    td.Text  ="<a href=\""+url+dr[sid].ToString ()+"\"  title=\""+dr[title].ToString () +"\">" +dr[title].ToString ().Substring (0,maxtitlelength) +"...</a>";
				}
				else
				{
					td.Text  ="<a href=\""+url+dr[sid].ToString ()+"\" >" +dr[title].ToString () +"</a>";
				}
				tr.Cells .Add (td);
				TableMessage.Rows .Add (tr);
			}
		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		///		设计器支持所需的方法 - 不要使用代码编辑器
		///		修改此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}