📄 sjt_sel.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.Configuration ;
using System.Data .OleDb ;
using System.Data.SqlClient ;
namespace graduate.stu
{
/// <summary>
/// sjt_sel 的摘要说明。
/// </summary>
public class sjt_sel : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.DropDownList drp_sel;
protected System.Web.UI.WebControls.Button bt_sel;
protected System.Web.UI.WebControls.DataGrid dg_sel;
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_search;
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_sel;
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"];
string sql="";
protected System.Web.UI.WebControls.Label lab_mes;
protected System.Web.UI.HtmlControls.HtmlTable table_message;
string studentid="";
//按学生每次选择一个课题设计
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
studentid=Convert.ToString (Session["studentid"]);
table_sel.Visible = true;
if(!IsPostBack)
{
SqlConnection conn = new SqlConnection(myConnString);
sql="select * from BYSJ.submitsubject order by submittime desc";
try
{
conn.Open();
SqlDataAdapter adapter= new SqlDataAdapter(sql, conn);
DataSet cla=new DataSet ();
adapter.Fill(cla);
drp_sel.DataSource =cla.Tables ["table"].DefaultView ;
drp_sel.DataValueField ="subjectid";
drp_sel.DataTextField ="subjectname";
drp_sel.DataBind ();
drp_sel.Items.Insert(0, new ListItem("请选择课题","0"));
dg_search_bind();
Label3.Text ="共";
Label4.Text ="页，当前为第";
Label5.Text ="页，跳转到";
Label6.Text ="页";
Label7.Text ="共";
Label8.Text ="页，当前为第";
Label9.Text ="页，跳转到";
Label10.Text ="页";
table_message.Visible =false;
sql="select * from BYSJ.preselectsubject where studentid='"+studentid+"'";
SqlDataAdapter adapter1 = new SqlDataAdapter(sql, conn);
DataSet cla1=new DataSet ();
adapter1.Fill(cla1);
if (cla1.Tables ["table"].Rows.Count !=0)
{
dg_sel_bind();
}
else
{
dg_sel.Visible =false;
}
}
catch(SqlException ex)
{
Response.Write ("<script>");
Response.Write ("alert('数据库连接出错！')");
Response.Write ("</script>");
}
finally
{
conn.Close ();
}
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.bt_sel.Click += new System.EventHandler(this.bt_sel_Click);
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.dg_search.SelectedIndexChanged += new System.EventHandler(this.dg_search_SelectedIndexChanged);
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
public void dg_sel_bind()
{
SqlConnection conn = new SqlConnection(myConnString);
try
{
conn.Open();
sql=" select a.studentid as studentid,a.subjectid as subjectid ,teachername,subjectname,requesttechnic,personlimit from bysj.preselectsubject a ,bysj.submitsubject b,bysj.studentbaseinfo c,teacherbaseinfo d where a.studentid=c.studentid and a.subjectid=b.subjectid and b.teacherid=d.teacherid and a.studentid='"+studentid+"'";
SqlDataAdapter adapter4 = new SqlDataAdapter(sql, conn);
DataSet grid4=new DataSet ();
adapter4.Fill(grid4);
dg_sel.DataSource =grid4;
dg_sel.DataBind ();
dg_sel.Visible =true;
//grid的界面控制
foreach(DataGridItem item in dg_sel.Items)
{
LinkButton linkbutton2=(LinkButton)item.Cells [6].Controls [0];
linkbutton2.Attributes .Add ("onclick","return confirm('确定删除吗？')");
}
}
catch(SqlException ex)
{
Response.Write ("<script>");
Response.Write ("alert('数据库连接出错！')");
Response.Write ("</script>");
}
finally
{
conn.Close ();
}
}
public void dg_search_bind()
{
SqlConnection conn = new SqlConnection(myConnString);
try
{
conn.Open();
sql="SELECT b.subjectid, b.subjectname, a. COUNT AS COUNT ,c.teachername,b.personlimit,b.requesttechnic FROM (SELECT subjectid, COUNT(*) AS COUNT FROM bysj.preselectsubject GROUP BY subjectid) AS a, bysj.submitsubject b ,bysj.teacherbaseinfo c WHERE a.subjectid = b.subjectid and b.teacherid=c.teacherid";
SqlDataAdapter adapter5 = new SqlDataAdapter(sql, conn);
DataSet grid5=new DataSet ();
adapter5.Fill(grid5);
if(grid5.Tables ["table"].Rows.Count !=0)
{
dg_search.DataSource =grid5;
dg_search.DataBind ();
dg_search.Visible =true;
//grid的界面控制
foreach(DataGridItem item in dg_sel.Items)
{
LinkButton linkbutton2=(LinkButton)item.Cells [6].Controls [0];
linkbutton2.Attributes .Add ("onclick","return confirm('确定删除吗？')");
}
ShowStatsPage();//显示当前页码的信息
panduan_page();//判断上下页的超连显示
}
else
{
show_no();
}
}
catch(SqlException ex)
{
Response.Write ("<script>");
Response.Write ("alert('数据库连接出错！')");
Response.Write ("</script>");
}
finally
{
conn.Close ();
}
}
public void dg_sel_command(object sender, DataGridCommandEventArgs e)
{
if(e.CommandName =="Delete")
{
SqlConnection conn = new SqlConnection(myConnString);
try
{
conn.Open();
sql="delete from bysj.preselectsubject where studentid='"+((Label)e.Item .FindControl ("lab_stu")).Text.Trim () +"' and subjectid='"+((Label)e.Item .FindControl ("lab_sub")).Text.Trim ()+"'";
SqlCommand cmd = new SqlCommand (sql,conn);
cmd.ExecuteNonQuery ();
//学生课题选择表隐藏
dg_sel.Visible =false;
}
catch(SqlException ex)
{
Response.Write ("<script>");
Response.Write ("alert('数据库连接出错！')");
Response.Write ("</script>");
}
finally
{
conn.Close ();
}
}
}
public void dg_search_command(object sender, DataGridCommandEventArgs e)
{
}
// datagrid中当前页的控制
public void dg_search_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dg_search.CurrentPageIndex = e.NewPageIndex;//获取当前页码
}
private void bt_sel_Click(object sender, System.EventArgs e)
{
string sel_id=drp_sel.SelectedItem .Value ;
if (sel_id == "0")
{
Response.Write ("<script>");
Response.Write ("alert('请选择课题！')");
Response.Write ("</script>");
}
else
{
SqlConnection conn = new SqlConnection(myConnString);
try
{
conn.Open();
DateTime dt=new DateTime ();
dt=DateTime.Today ;
if(dg_sel.Visible == true)
{
Response.Write ("<script>");
Response.Write ("confirm('你已选择课题，该操作将修改原选课题！')");
Response.Write ("</script>");
sql="update bysj.preselectsubject set subjectid='"+sel_id+"',selecttime='"+dt+"' where studentid='"+studentid+"'";
}
else
sql="insert into bysj.preselectsubject (subjectid,studentid,selecttime) values('"+sel_id+"','"+studentid+"','"+dt+"')";
SqlCommand cmd = new SqlCommand (sql,conn);
cmd.CommandText =sql;
cmd.ExecuteNonQuery ();
Response.Write ("<script>");
Response.Write ("alert('提交成功！');");
Response.Write("</script>");
dg_sel_bind();
}
catch(SqlException ex)
{
Response.Write ("<script>");
Response.Write ("alert('数据库连接出错！')");
Response.Write ("</script>");
}
finally
{
conn.Close ();
}
}
}
//分页文字的显示
public void ShowStatsPage( )
{
lblCurrentIndex.Text = ((int)dg_search.CurrentPageIndex+1) +"</font>";
lblPageCount.Text = dg_search.PageCount + "</font>";
txtGoPage.Text =Convert.ToString ((int)dg_search.CurrentPageIndex+1);
lblCurrentIndex1.Text = ((int)dg_search.CurrentPageIndex+1) +"</font>";
lblPageCount1.Text = dg_search.PageCount + "</font>";
txtGoPage1.Text =Convert.ToString ((int)dg_search.CurrentPageIndex+1);
lblCurrentIndex.Text = ((int)dg_search.CurrentPageIndex+1) +"</font>";
lblPageCount.Text = dg_search.PageCount + "</font>";
txtGoPage.Text =Convert.ToString ((int)dg_search.CurrentPageIndex+1);
lblCurrentIndex1.Text = ((int)dg_search.CurrentPageIndex+1) +"</font>";
lblPageCount1.Text = dg_search.PageCount + "</font>";
txtGoPage1.Text =Convert.ToString ((int)dg_search.CurrentPageIndex+1);
}
//控制上下页的显示
public void panduan_page()
{
if(dg_search.CurrentPageIndex==0 )
{
btnPrev.Enabled =false;
btnPrev1.Enabled =false;
}
else
{
btnPrev.Enabled =true;
btnPrev1.Enabled =true;
}
if(dg_search.CurrentPageIndex==dg_search.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_search.PageCount))
dg_search.CurrentPageIndex = PageI ;
else if( PageI >=dg_search.PageCount)
dg_search.CurrentPageIndex = dg_search.PageCount-1;
else
dg_search.CurrentPageIndex=0;
}
dg_search_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_search.PageCount))
dg_search.CurrentPageIndex = PageI ;
else if( PageI >=dg_search.PageCount)
dg_search.CurrentPageIndex = dg_search.PageCount-1;
else
dg_search.CurrentPageIndex=0;
}
dg_search_bind();
}
public void btnPrev_Click(object sender, System.EventArgs e)
{
if (dg_search.CurrentPageIndex > 0)
dg_search.CurrentPageIndex --;
dg_search_bind();
}
private void btnNext_Click(object sender, System.EventArgs e)
{
if (dg_search.CurrentPageIndex < (dg_search.PageCount - 1))
dg_search.CurrentPageIndex ++;
dg_search_bind();
}
public void show_no()
{
table_search.Visible =false;
table_message.Visible =true;
lab_mes.Text="目前还不能查看课题！";
table_sel.Visible =false;
}
private void dg_search_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -