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;
namespace gllbysj
{
	/// <summary>
	/// WebForm1 的摘要說明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Image Image1;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.HyperLink HyperLink3;
		protected System.Web.UI.WebControls.HyperLink HyperLink4;
		protected System.Web.UI.WebControls.HyperLink HyperLink5;
		protected System.Web.UI.WebControls.HyperLink HyperLink6;
		protected System.Web.UI.WebControls.HyperLink HyperLink7;
		protected System.Web.UI.WebControls.HyperLink HyperLink8;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.HyperLink HyperLink9;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Panel Panel1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
			string str=System.DateTime.Now.DayOfWeek.ToString();
			string str2=this.date(str);
			string str3=Convert.ToString(System.DateTime.Now);
			str3=str3.Substring(0,9);
		    this.Label1.Text=str3+str2;
			Session["playid"]="";
		//	Session["name"]="";
			SqlConnection con=db.createcon();
			con.Open();
			SqlCommand cmm=new SqlCommand("select topmess from publ where id=1",con);
			SqlDataReader sda=cmm.ExecuteReader();
			sda.Read();  
						
			this.Label2.Text=sda["topmess"].ToString();
			con.Close();


			
			
		}

		#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 string date(string str)
		{
			string[] a={"星期一","星期二","星期三","星期四","星期五","星期六","星期日"};
			string str1="";
						switch(str)
			{
				                    case "Monday":
				str1=a[0].ToString();
				break;
							case "Thursday":
				str1=a[1].ToString();
				break;
							case "Wednesday":
				str1=a[2].ToString();
				break;
							case "Tuesday":
				str1=a[3].ToString();
				break;
							case "Friday":
				str1=a[4].ToString();
                break;
			
							case "Saturday":
				str1=a[5].ToString();

				break;
				
							case "Sunday" :
				str1=a[6].ToString();
				break;
			}
          return str1;
		}
	}
}