class_kuaisudenglu.ascx.cs

利用远程控制进行上课

namespace free
{
	using System;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
	using System.Data.SqlClient;

	/// <summary>
	///		Summary description for class_kuaisudenglu.
	/// </summary>
	public class class_kuaisudenglu : System.Web.UI.UserControl
	{
		protected System.Web.UI.WebControls.TextBox xingming;
		protected System.Web.UI.WebControls.TextBox mima;
		protected System.Web.UI.WebControls.Button denglu;
		protected System.Data.SqlClient.SqlConnection myconn;
		protected System.Data.SqlClient.SqlCommand mycomm;

		private void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		///		Required method for Designer support - do not modify
		///		the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			this.denglu.Click += new System.EventHandler(this.denglu_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void denglu_Click(object sender, System.EventArgs e)
		{
			if(xingming.Text==""||mima.Text=="")
			{
				Response.Write("<script>alert('用户名或密码不能为空')</script>");				
			}
			else
			{
				string sqlstr="SELECT  * FROM class_student_information  where stu_name='"+xingming.Text.Trim()+"'and stu_password='"+mima.Text.Trim()+"'";
				myconn=new SqlConnection(Session["str_connection"].ToString());
				myconn.Open();
				//Try
				SqlDataAdapter mydada;
				mydada=new SqlDataAdapter(sqlstr,myconn);
				DataTable mytable;
				mytable=new DataTable();
				mydada.Fill(mytable);
				mytable.TableName="wenti";
							
				if(mytable.Rows.Count>0)
				{
					sqlstr="SELECT  sign FROM class_student_buybook  where stu_name='"+xingming.Text.Trim()+"'";
					//					SqlDataAdapter mydada;
					mydada=new SqlDataAdapter(sqlstr,myconn);
					mytable=new DataTable();
					mydada.Fill(mytable);
					mytable.TableName="shu";
					for(int i=0;i<=mytable.Rows.Count-1;i++)
					{
						if(mytable.Rows[i]["sign"].ToString()=="1")
						{
							Response.Cookies["free_xueyuan"].Value = xingming.Text.Trim();
							Response.Redirect("class_study.aspx");
						}
						if (i>=mytable.Rows.Count)
							Response.Write("<script>alert('对不起，您的帐好还未激活！')</script>");		

						
					}
					Response.Write("<script>alert('对不起，您的帐好还未激活！')</script>");		
               
				}
				else
				{
					Response.Write("<script>alert('对不起，您的用户名或密码有误！')</script>");	
				}
				myconn.Close();
			}
			
		
		}
	}
}