addrst.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 addRst_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(); 
    protected void Page_Load(object sender, EventArgs e)
    {
		if (!Page.IsPostBack)
		{
			if (Session["admin"].ToString() != "admin")
				Response.Redirect("../Default.aspx");
			TextBox1.Text = Session["name"].ToString();
			TextBox2.Text = Session["class"].ToString();
			TextBox5.Text = Session["bak"].ToString();
		}
    }
	protected void Button1_Click(object sender, EventArgs e)
	{
		string sql = null;
		if (TextBox1.Text != "" || TextBox2.Text != "")
		{
			sql = "insert into work_rst (Name,Class,Date_rst,Time_rst) values ('" + TextBox1.Text.Trim() + "','" + TextBox2.Text.Trim() + "','" + TextBox3.Text.Trim() + "'," + TextBox4.Text.Trim() + ")";
			scr(du.commit(sql));
			bak();
		}
		else
			Response.Write("<script language=JavaScript>alert(\"请填写完整！\")</script>");
	}

	private void scr(bool temp)
	{
		if (temp)
			Response.Write("<script language=JavaScript>alert(\"操作成功！\")</script>");
		else
			Response.Write("<script language=JavaScript>alert(\"操作失败！\")</script>");
	}
	protected void Button2_Click(object sender, EventArgs e)
	{
		if (TextBox3.Text != "" && TextBox4.Text != "")
		{
			string sql = "update work_rst set Time_rst=" + TextBox4.Text.Trim() + " where Name='" + TextBox1.Text.Trim() + "' and Class='" + TextBox2.Text.Trim() + "' and Date_rst='" + TextBox3.Text.Trim() + "'";
			scr(du.commit(sql));
		}
		bak();
	}

	private void bak()
	{
		if (TextBox5.Text != Session["bak"].ToString())
		{
			string sql = "update student set Bak='" + TextBox5.Text.Trim() + "' where Name='" + TextBox1.Text.Trim() + "' and Class='" + TextBox2.Text.Trim() + "'";
			du.commit(sql);
		}
	}
}