class_denglu.aspx.cs

利用远程控制进行上课

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 free
{
	/// <summary>
	/// Summary description for class_denglu.
	/// </summary>
	public class class_denglu : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox mima;
		protected System.Web.UI.WebControls.TextBox xingming;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.HtmlControls.HtmlTable jiaocheng;
		protected System.Data.SqlClient.SqlConnection myconn;
		protected System.Web.UI.WebControls.Literal tishi;
		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.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			if(xingming.Text==""||mima.Text=="")
			{
				tishi.Text="用户名或密码不能为空";
				tishi.Visible=true;
			}
			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>");

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