📄 pipeisch.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace kqxt
{
/// <summary>
/// pipeisch 的摘要说明。
/// </summary>
public class pipeisch : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
/*if(!this.IsPostBack)
{
string n=this.TextBox1.Text;
string m=this.TextBox2.Text;
DataSet myds=new DataSet();
string conn=System.Configuration.ConfigurationSettings.AppSettings["connstr"];
SqlConnection objconn=new SqlConnection(conn);
if(n=="旷课"&&m=="迟到")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName from kaoqin,student,teacher where kaoqin.stuID=student.stuID and kaoqin.Absent='1' or kaoqin.Late='1' and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="迟到"&&m=="旷课")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName from kaoqin,student,teacher where kaoqin.stuID=student.stuID and kaoqin.Absent='1' or kaoqin.Late='1' and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="旷课"&&m=="请假")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName from kaoqin,student,teacher where kaoqin.stuID=student.stuID and kaoqin.Absent='1' or kaoqin.Qinjia='1' and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="请假"&&m=="旷课")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName from kaoqin,student,teacher where kaoqin.stuID=student.stuID and kaoqin.Absent='1' or kaoqin.Qinjia='1' and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="请假"&&m=="迟到")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName from kaoqin,student,teacher where kaoqin.stuID=student.stuID and kaoqin.Qinjia='1' or kaoqin.Late='1'and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="迟到"&&m=="请假")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName from kaoqin,student,teacher where kaoqin.stuID=student.stuID and kaoqin.Qinjia='1' or kaoqin.Late='1' and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}*/
//}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string n=this.TextBox1.Text;
string m=this.TextBox2.Text;
DataSet myds=new DataSet();
string conn=System.Configuration.ConfigurationSettings.AppSettings["connstr"];
SqlConnection objconn=new SqlConnection(conn);
if(n=="旷课"&&m=="迟到")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName,status from kaoqin,student,teacher where kaoqin.stuID=student.stuID and status='请假' or status='旷课' and kaoqin.thID=teacher.thID and teacher.thID='"+Session["usersID"]+"'and student.classID in(select classID from classCourse,teacher where class.classID=teacher.classID and teacher.thID='"+Session["usersID"]+"'";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="迟到"&&m=="旷课")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName,status from kaoqin,student,teacher where kaoqin.stuID=student.stuID and status='迟到' or status='旷课' and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="旷课"&&m=="请假")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName,status from kaoqin,student,teacher where kaoqin.stuID=student.stuID and status='请假' or status='旷课' and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="请假"&&m=="旷课")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName,status from kaoqin,student,teacher where kaoqin.stuID=student.stuID and status='请假' or status='旷课' and kaoqin.thID=teacher.thID and stdent.classID in(select classID from classCourse,teacher where class.classID=teacher.classID and teacher.thID='"+Session["usersID"]+"'";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="请假"&&m=="迟到")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName,status from kaoqin,student,teacher where kaoqin.stuID=student.stuID and status='请假' or status='迟到'and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
if(n=="迟到"&&m=="请假")
{
string sqlstr="select kaoqin.stuID,student.stuName,courseName,status from kaoqin,student,teacher where kaoqin.stuID=student.stuID and status='请假' or status='迟到 and kaoqin.thID=teacher.thID";
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,objconn);
mydata.Fill(myds,"kq");
if(myds.Tables["kq"].Rows.Count>0)
{
DataGrid1.DataSource=myds.Tables["kq"].DefaultView;
DataGrid1.DataBind();
}
else
this.Label3.Text="无记录!";
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -