rule.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 rule_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");
			dataBind();
		}
    }

	private void dataBind()
	{
		sql = "select * from rule";
		DataGrid1.DataSource = du.getDataTable(sql, "rule");
		DataGrid1.DataBind();
	}

	protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e)
	{
		Session["ID"] = e.Item.Cells[0].Text;
		DataGrid1.EditItemIndex = e.Item.ItemIndex;
		dataBind();
	}
	protected void DataGrid1_CancelCommand(object source, DataGridCommandEventArgs e)
	{
		DataGrid1.EditItemIndex = -1;
		dataBind();
	}
	protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
	{
		sql = "update rule set one=" +((TextBox)e.Item.Cells[1].Controls[0]).Text + ", two="
            + ((TextBox)e.Item.Cells[2].Controls[0]).Text+ ", three=" 
            + ((TextBox)e.Item.Cells[3].Controls[0]).Text + " where ID='" 
            + Session["ID"].ToString() + "';";
		scr(du.commit(sql));
		DataGrid1.EditItemIndex = -1;
		dataBind();
	}
	protected void add_Click(object sender, EventArgs e)
	{
		sql = "insert into rule (ID) values ('" + TextBox1.Text.Trim() + "')";
		scr(du.commit(sql));
		dataBind();
	}

	private void scr(bool temp)
	{
		if (temp)
			Response.Write("<script language=JavaScript>alert(\"操作成功！\")</script>");
		else
			Response.Write("<script language=JavaScript>alert(\"操作失败！\")</script>");
	}
}