basedata.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 baseData_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 stAdd_Click(object sender, EventArgs e)
	{
		if (stName.Text != "" || stClass.Text != "")
		{
			sql = "insert into student (Name,Class,Part,ID,Poor) values ('" + stName.Text.Trim() + "','" + stClass.Text.Trim() + "','" + stID.Text.Trim() + "','" + stID.Text.Trim() + "','否')";
			scr(du.commit(sql));
		}
		else
			Response.Write("<script language=JavaScript>alert(\"请填写完整！\")</script>");
	}
	protected void stDel_Click(object sender, EventArgs e)
	{
		sql = "delete from student where ID='" + stID.Text.Trim() + "'";
		scr(du.commit(sql));
	}

	private void scr(bool temp)
	{
		if (temp)
			Response.Write("<script language=JavaScript>alert(\"操作成功！\")</script>");
		else
			Response.Write("<script language=JavaScript>alert(\"操作失败！\")</script>");
	}
	protected void stCh_Click(object sender, EventArgs e)
	{
		if(sql==null)
			sql = "select * from student where Name like '" + stName.Text.Trim() +
			"%' and Class like '" + stClass.Text + "%' and Part like '" + stPart.Text +
			"%' and ID like '"+stID.Text+"%' order by Class";
		DataGrid1.Visible = true;
		DataGrid1.DataSource = du.getDataTable(sql, "baseData");
		DataGrid1.DataBind();
	}

	protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e)
	{
		DataGrid1.EditItemIndex = e.Item.ItemIndex;
		stCh_Click(source, e);
	}
	protected void DataGrid1_CancelCommand(object source, DataGridCommandEventArgs e)
	{
		DataGrid1.EditItemIndex = -1;
		stCh_Click(source, e);
	}
	protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
	{
		sql = "update student set Part='" + ((TextBox)e.Item.Cells[3].Controls[0]).Text.Trim() +
			"', Phone='" + ((TextBox)e.Item.Cells[4].Controls[0]).Text.Trim() + "', Poor='" +
			((TextBox)e.Item.Cells[5].Controls[0]).Text.Trim() + "', Address='" + ((TextBox)e.Item.Cells[6].Controls[0]).Text
			+ "', Spare='" + ((TextBox)e.Item.Cells[7].Controls[0]).Text + "'  where ID='" + e.Item.Cells[0].Text + "'";
		scr(du.commit(sql));
		DataGrid1.EditItemIndex = -1;
		stCh_Click(source, e);
	}
	protected void teaAdd_Click(object sender, EventArgs e)
	{
		sql = "insert into teacher (Part,teacher,phone) values ('" + teaPart.Text.Trim() + "','" + teaName.Text.Trim() + "','" + teaPhone.Text.Trim() + "')";
		scr(du.commit(sql));
	}
	protected void teaDel_Click(object sender, EventArgs e)
	{
		sql = "delete from teacher where teacher='" + teaName.Text + "'";
		scr(du.commit(sql));
	}
	protected void stSh_Click(object sender, EventArgs e)
	{
		sql = "select * from student where Address like '%" + address.Text +
			"%' and Spare like '%" + spare.Text + "%' and Part like '" + stPart.Text + "%'";
		DataGrid1.Visible = true;
		DataGrid1.DataSource = du.getDataTable(sql, "baseData");
		DataGrid1.DataBind();
	}
}