index.aspx.cs

asp.net1.1编写的办公自动化系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.SqlTypes;


namespace bgzdhxt
{
	/// <summary>
	/// index 的摘要说明。
	/// </summary>
	public class index : System.Web.UI.Page
	{
		public string 访问次数="15836";
		public string 滚动新闻="";
		public string 图片新闻2="";
		public string 新闻图片="";
		public string 新闻图片相关文字="";
		public string 新闻图片相关文字id="";
		public string 港口新闻="";
		public string 公告栏="";
		public string 领导致辞="";
		public string strUserName="dd";
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
			{
				// 用户名
				try
				{
					strUserName = "欢迎您， "+Session["yonghuming"].ToString();
				}
				catch
				{
					strUserName="您尚未登陆！";
				}
				//图片新闻，图片新闻相关文字
				DataAccess Das1 = new DataAccess();
				SqlDataReader read = Das1.GetDataReader("select top 1  * from 动态新闻表 where 类型=5 order by 时间 desc");
				if(read.Read())
				{
					新闻图片相关文字id=read[0].ToString();
					新闻图片=read[1].ToString();
					//新闻图片相关文字="<TABLE class=text1 cellSpacing=1 cellPadding=0 width=160  align=center border=0><TBODY>";

					新闻图片相关文字="<TR><TD><A href='#' onclick =openwin('news.aspx?id=2&tid=" + 新闻图片相关文字id +"')>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"+read[2].ToString()+".....</A></TD></TR>";
				}
				read.Close();

				//公告栏
				DataAccess Das2 = new DataAccess();
				SqlDataReader read2 = Das2.GetDataReader("select top 1  * from 动态新闻表 where 类型=3 order by 时间 desc");
				if(read2.Read())
				{
					公告栏="&nbsp;<A href='#' onclick =openwin('news.aspx?id=3&tid="+read2[0].ToString()+"')>"+read2[2].ToString()+"</A>";
				}
				read2.Close();

				//领导致辞
				DataAccess Das3 = new DataAccess();
				SqlDataReader read3 = Das3.GetDataReader("select top 1  * from 动态新闻表 where 类型=1 order by 时间 desc");
				if(read3.Read())
				{
					领导致辞="<A href='#' onclick =openwin('news.aspx?id=1&tid="+read3[0].ToString()+"')>"+read3[1].ToString()+"<br>"+read3[2].ToString()+"</A>";
				}
				read3.Close();
			
				// 滚动新闻
				DataAccess Das4 = new DataAccess();
				SqlDataReader read4 = Das4.GetDataReader("select top 1  * from 动态新闻表 where 类型=0 order by 时间 desc");
				if(read4.Read())
				{
					滚动新闻=read4[1].ToString();
				}
				read4.Close();
				// 访问次数
				访问次数=Application["GlobalCounter"].ToString();

				
			}

		}

		#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
		public void Get图片新闻()
		{
			DataAccess Das = new DataAccess();
			//Common Cmon = new Common();
			//Response.Write("<table class='tableborder1' align='center' height='66' cellSpacing='0' cellPadding='0' border='0'>");//<TABLE  cellSpacing="1" cellPadding="3" >
			SqlDataReader read = Das.GetDataReader("select top 5  * from 动态新闻表 where 类型=2 order by 时间 desc");
			if(read.Read())
			{

			}
			Response.Write("<TABLE class=text1 cellSpacing=0 cellPadding=0 width=370 border=0 >"+
				"<TBODY><TR><TD><TABLE width='100%'><TBODY>");
			while(read.Read())
			{

				//Response.Write("<tr><td class='tablebody1' height ='20' vAlign='top'>·<A href='#' onclick =openwin('xinwenxiangxixinxi.aspx?id=" + read[0].ToString() +"')>" + read[1].ToString() + "</A></td></tr>");
				Response.Write("<TR><TD class='text1'>&nbsp;<FONT color='#2a78c3'>□</FONT>&nbsp;<A href='#' onclick =openwin('news.aspx?id=2&tid=" + read[0].ToString() +"')>" + read[1].ToString() + "</A>&nbsp;["+read[3].ToString()+"]</TD></TR>");
							//	Response.Write("<TR><TD class='text1'>&nbsp;<FONT color='#2a78c3'>□</FONT>&nbsp;"+<A href=xinwenxiangxixinxi.aspx?id=+read[0].ToString()+">宁波港集团第四届职工运动会隆重开幕</A>&nbsp;["+read[3].ToString()+"]</TD></TR>");
			}
			Response.Write("</TBODY></TABLE>");
			read.Close();
		}
		public void Get港口新闻()
		{
			DataAccess Das = new DataAccess();
			SqlDataReader read = Das.GetDataReader("select top 5  * from 动态新闻表 where 类型=4 order by 时间 desc");
			Response.Write("<TABLE width='100%'><TBODY>");
			while(read.Read())
			{
				Response.Write("<TR><TD class=text1>&nbsp;<FONT color=#2a78c3>□</FONT>&nbsp;");
				Response.Write("<A href='#' onclick =openwin('news.aspx?id=4&tid=" + read[0].ToString() +"')>" + read[1].ToString() + "</A>&nbsp;["+read[3].ToString()+"]</TD></TR>");
			}
			Response.Write("</TBODY></TABLE>");
			read.Close();

		}
	}
}