sub_sure.aspx.cs

毕业设计关系b/s系统 毕业设计管理工作 毕业设计管理数据

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.Configuration ;
using System.Data .OleDb ;
using System.Data.SqlClient  ;

namespace graduate.stu
{
	/// <summary>
	/// sure_subject 的摘要说明。
	/// </summary>
	public class sub_sure : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label11;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label lblPageCount1;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label lblCurrentIndex1;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.TextBox txtGoPage1;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Button go_s;
		protected System.Web.UI.WebControls.LinkButton btnPrev1;
		protected System.Web.UI.WebControls.LinkButton btnNext1;
		protected System.Web.UI.WebControls.DataGrid dg_sure;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label lblPageCount;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label lblCurrentIndex;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.TextBox txtGoPage;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Button go_s1;
		protected System.Web.UI.WebControls.LinkButton btnPrev;
		protected System.Web.UI.WebControls.LinkButton btnNext;
		protected System.Web.UI.HtmlControls.HtmlTable table_search;
		protected System.Web.UI.HtmlControls.HtmlTable table2;
		protected System.Web.UI.HtmlControls.HtmlTable table3;
		string myConnString=ConfigurationSettings.AppSettings ["SQLconnectionString"];
		protected System.Web.UI.WebControls.Label lab_mes;
		protected System.Web.UI.HtmlControls.HtmlTable table_message;
		string sql="";
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			
			if(!IsPostBack)
			{
						dg_sure_bind();

						Label3.Text ="共";
						Label4.Text ="页，当前为第";
						Label5.Text ="页，跳转到";
						Label6.Text ="页";
						Label7.Text ="共";
						Label8.Text ="页，当前为第";
						Label9.Text ="页，跳转到";
						Label10.Text ="页";
					
				
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.go_s.Click += new System.EventHandler(this.go_s_Click);
			this.btnPrev1.Click += new System.EventHandler(this.btnPrev_Click);
			this.btnNext1.Click += new System.EventHandler(this.btnNext_Click);
			this.go_s1.Click += new System.EventHandler(this.go_s1_Click);
			this.btnPrev.Click += new System.EventHandler(this.btnPrev_Click);
			this.btnNext.Click += new System.EventHandler(this.btnNext_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		// datagrid中当前页的控制
		public void dg_sure_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			
			dg_sure.CurrentPageIndex = e.NewPageIndex;//获取当前页码
			
		}

		public void dg_sure_bind()
		{
			SqlConnection conn = new SqlConnection(myConnString);
			sql="select subjectname,studentname,teachername,personlimit from bysj.suresubject a ,bysj.studentbaseinfo b,bysj.teacherbaseinfo c ,bysj.submitsubject d where a.subjectid=d.subjectid and a.studentid=b.studentid and d.teacherid=c.teacherid order by suresubjectid desc";
			try
			{
				conn.Open();

				SqlDataAdapter adapter= new  SqlDataAdapter(sql, conn);
				DataSet cla=new DataSet ();
				adapter.Fill(cla);
				if(cla.Tables ["table"].Rows .Count !=0)
				{
					dg_sure.DataSource =cla;
					dg_sure.DataBind ();
					table_search.Visible =true;
					ShowStatsPage();//显示当前页码的信息
					panduan_page();//判断上下页的超连显示
					table_message.Visible =false;
				}
				else
				{
					table_message.Visible =true;
					table_search.Visible =false;
				}
					

					
			}
			catch(SqlException ex)
			{
				Response.Write ("<script>");
				Response.Write ("alert('数据库连接出错！')");
				Response.Write ("</script>");
			}
			finally
			{
				conn.Close ();
			}

		}

		//分页文字的显示
		public  void  ShowStatsPage( )
		{
			lblCurrentIndex.Text =  ((int)dg_sure.CurrentPageIndex+1) +"</font>";
			lblPageCount.Text =  dg_sure.PageCount + "</font>";
			txtGoPage.Text =Convert.ToString ((int)dg_sure.CurrentPageIndex+1);

			lblCurrentIndex1.Text =  ((int)dg_sure.CurrentPageIndex+1) +"</font>";
			lblPageCount1.Text =  dg_sure.PageCount + "</font>";
			txtGoPage1.Text =Convert.ToString ((int)dg_sure.CurrentPageIndex+1);

			lblCurrentIndex.Text =  ((int)dg_sure.CurrentPageIndex+1) +"</font>";
			lblPageCount.Text =  dg_sure.PageCount + "</font>";
			txtGoPage.Text =Convert.ToString ((int)dg_sure.CurrentPageIndex+1);

			lblCurrentIndex1.Text =  ((int)dg_sure.CurrentPageIndex+1) +"</font>";
			lblPageCount1.Text =  dg_sure.PageCount + "</font>";
			txtGoPage1.Text =Convert.ToString ((int)dg_sure.CurrentPageIndex+1);
			
		}


		//控制上下页的显示
		public void panduan_page()
		{
			if(dg_sure.CurrentPageIndex==0 )
			{
				btnPrev.Enabled =false;
				btnPrev1.Enabled =false;
			}
			else 
			{
				btnPrev.Enabled =true;
				btnPrev1.Enabled =true;
			}

			if(dg_sure.CurrentPageIndex==dg_sure.PageCount-1 )
			{
				btnNext.Enabled =false;
				btnNext1.Enabled =false;
			}
			else 
			{
				btnNext.Enabled =true;
				btnNext1.Enabled =true;
			}
		}

		//转到第几页的显示
		private void go_s_Click(object sender, System.EventArgs e)
		{
			
			if(txtGoPage1.Text.Trim()!="")
			{
				int PageI=Int32.Parse(txtGoPage1.Text.Trim())-1;
				if (PageI >=0 && PageI < (dg_sure.PageCount))
					dg_sure.CurrentPageIndex = PageI ;
				else if( PageI >=dg_sure.PageCount)
					dg_sure.CurrentPageIndex = dg_sure.PageCount-1;
				else
					dg_sure.CurrentPageIndex=0;

			} 
			
			
			
			dg_sure_bind();
		
		}

		private void go_s1_Click(object sender, System.EventArgs e)
		{
			
			if(txtGoPage.Text.Trim()!="")
			{
				int PageI=Int32.Parse(txtGoPage.Text.Trim())-1;
				if (PageI >=0 && PageI < (dg_sure.PageCount))
					dg_sure.CurrentPageIndex = PageI ;
				else if( PageI >=dg_sure.PageCount)
					dg_sure.CurrentPageIndex = dg_sure.PageCount-1;
				else
					dg_sure.CurrentPageIndex=0;
			} 
		
			
			dg_sure_bind();
		}


		public void btnPrev_Click(object sender, System.EventArgs e)
		{
			
			if (dg_sure.CurrentPageIndex > 0)
				dg_sure.CurrentPageIndex --;
			
			dg_sure_bind();
		}

		private void btnNext_Click(object sender, System.EventArgs e)
		{
			
			if (dg_sure.CurrentPageIndex < (dg_sure.PageCount - 1))
				dg_sure.CurrentPageIndex ++;
			
			dg_sure_bind();
		}   
	}
}