alt_teacherall.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 XTeamBBL;
using System.Data.SqlClient;
using XTeamDBL;

public partial class human_manage_system_teacher_manage_teacher_all_set_alt_teacherall : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            DataBind_teacherall();
    }

    private void DataBind_teacherall()
    {
        int teacher_allID = Convert.ToInt32(Request.QueryString["teacherallID"].ToString());
        string sql = "select * from teacher_allinfo where teacher_allID="+teacher_allID;
        SqlDataReader dr = DB.RunGetReader(sql);
        if (dr.Read())
        {
            tl_type.Text=dr["teacher_alltype"].ToString();
            tl_content.Text=dr["teacher_allcontent"].ToString();
            int tlnum = Convert.ToInt32(dr["teacher_ID"].ToString());
            string teacher_sql = "select teacher_name from teacher_info where teacher_ID="+tlnum;
            SqlDataReader teacher_dr = DB.RunGetReader(teacher_sql);
            if(teacher_dr.Read())
                tl_name.Text=teacher_dr["teacher_name"].ToString();
        }
        dr.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        int teacher_allID = Convert.ToInt32(Request.QueryString["teacherallID"].ToString());
        string teacherall_type = tl_type.SelectedItem.Text.ToString();
        string   content = tl_content.Text.ToString();
        
        teacherall tcl = new teacherall(teacher_allID,teacher_allID,teacherall_type, content);
        Boolean flag = teacherall.alt_teacherall(tcl);
        if (flag) Response.Write("<script>alert('修改成功');</script>");
        else Response.Write("<script>alert('修改失败');</script>"); 
        
    }
}