bulletinDisp.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 OI.DatabaseOper  ;

namespace OI
{
	/// <summary>
	/// bulletinDisp 的摘要说明。
	/// </summary>
	public partial class bulletinDisp : OI.PageBase 
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			DatabaseConnect dc=new DatabaseConnect();
			string sql="SELECT Title,Content,DeptName,beginDate FROM bulletinBar,Staff,departments "+
				"WHERE Staff.Id=bulletinBar.UserID AND Staff.Department=departments.DeptID "
				+"AND endDate>=beginDate AND beginDate<='"+DateTime.Now  +"' AND endDate>='"+DateTime.Now  +"' ORDER BY beginDate DESC";
			ArrayList bulletin=dc.getData (sql);
			DateTime dt;
			//int tempUserID;
			//string tempSql="";
			//DataList dl;
			for (int j=0; j<bulletin.Count ; j++) 
			{          
				TableRow r = new TableRow();
				TableCell c = new TableCell();
				if(j%4==0)
					c.Controls.Add(new LiteralControl("<p align=\"center\"><B><FONT size=\"5\">"+bulletin[j].ToString ()+"</FONT></B></P>"));
				else if(j%4==1)
					c.Controls.Add(new LiteralControl("<p align=\"left\">&nbsp;&nbsp;&nbsp;&nbsp"+bulletin[j].ToString ().Replace("\r\n","<br>")+"</P>"));
				else if(j%4==2)
				{
					c.Controls .Add (new LiteralControl ("<p align=\"right\">"+bulletin[j].ToString ()+"&nbsp;&nbsp&nbsp;&nbsp</p>"));
				}
				else if(j%4==3)
				{
					dt=Convert.ToDateTime (bulletin[j]);
					c.Controls.Add(new LiteralControl("<p align=\"right\">&nbsp;&nbsp"+dt.Year+"年"+dt.Month +"月"+dt.Day +"日</P>"));
				}
				c.Controls.Add(new LiteralControl());
				r.Cells.Add(c);
				bulletinTable.Rows.Add(r);
			}
			TableRow tr=new TableRow ();
			TableCell tc=new TableCell ();
			tc.Controls .Add (new LiteralControl ("<p align=center><input type=button onclick=\"Javascript:window.close()\" value=\"关闭窗口\"></p>"));
			tr.Cells .Add (tc);
			bulletinTable.Rows .Add (tr);
		}