score.aspx.cs

勤工俭学的管理系统 记录学生资料

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using sues_data;

public partial class score_aspx : System.Web.UI.Page
{
    // Page events are wired up automatically to methods 
    // with the following names:
    // Page_Load, Page_AbortTransaction, Page_CommitTransaction,
    // Page_DataBinding, Page_Disposed, Page_Error, Page_Init, 
    // Page_Init Complete, Page_Load, Page_LoadComplete, Page_PreInit
    // Page_PreLoad, Page_PreRender, Page_PreRenderComplete, 
    // Page_SaveStateComplete, Page_Unload

	DataUse du = new DataUse();
	string sql;
 
    protected void Page_Load(object sender, EventArgs e)
    {
		if (!Page.IsPostBack)
			if (Session["admin"].ToString() != "admin")
				Response.Redirect("../Default.aspx");
    }

	protected void score_Click(object sender, EventArgs e)
	{
		sql = "select * from st_score where ID like '" + stNo.Text + "%' and Name like '" + stName.Text + "%'";
		DataGrid1.Visible = true;
		DataGrid1.DataSource = du.getDataTable(sql, "score");
		DataGrid1.DataBind();
	}

	protected void deal_Click(object sender, EventArgs e)
	{
		sql = "delete from st_score where l1 like '%*%' or l2 like '%*%' or l3 like '%*%' or l4 like '%*%' " +
			"or l5 like '%*%' or l6 like '%*%' or l7 like '%*%' or l8 like '%*%' or l9 like '%*%' or l10 like '%*%' or " +
			"l11 like '%*%' or l12 like '%*%' or l13 like '%*%' or l14 like '%*%' or l15 like '%*%' or l16 like '%*%' or " +
            "l17 like '%*%' or l18 like '%*%' or l19 like '%*%' or l20 like '%*%' or l1 like '%F%' or l2 like '%F%' or l3 like '%F%' or l4 like '%F%' " +
            "or l5 like '%F%' or l6 like '%F%' or l7 like '%F%' or l8 like '%F%' or l9 like '%F%' or l10 like '%F%' or " +
            "l11 like '%F%' or l12 like '%F%' or l13 like '%F%' or l14 like '%F%' or l15 like '%F%' or l16 like '%F%' or " +
            "l17 like '%F%' or l18 like '%F%' or l19 like '%F%' or l20 like '%F%'";
		if (du.commit(sql))
			Response.Write("<script language=JavaScript>alert(\"操作成功！\")</script>");
		else
			Response.Write("<script language=JavaScript>alert(\"操作失败！\")</script>");
	}
}