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

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

    }
    private void DataBind_teacher()
    {
        int teacherID = Convert.ToInt32(Request.QueryString["teacherID"]);
        string sql = "select * from teacher_info where teacher_ID=" + teacherID;
        SqlDataReader dr = DB.RunGetReader(sql);
        if (dr.Read())
        {
            tt_name.Text = dr["teacher_name"].ToString();
            tt_sex.SelectedItem.Text = dr["teacher_sex"].ToString();
            tt_age.Text = dr["teacher_age"].ToString();
            tt_phone.Text = dr["teacher_phone"].ToString();
            tt_address.Text = dr["teacher_address"].ToString();
            tt_mail.Text = dr["teacher_email"].ToString();
            tt_fea.Text = dr["teacher_feature"].ToString();
            tt_intru.Text = dr["teacher_intru"].ToString();
            tt_IDcard.Text = dr["teacher_IDcard"].ToString();
            if (dr["IS_teacherhead"].ToString() == "1") ttIS_head.Checked = true;
            if (dr["IS_work"].ToString() == "1") ttIS_work.Checked = true;
            if (dr["IS_fire"].ToString() == "1") ttIS_fire.Checked = true;
            tt_image.ImageUrl = dr["teacher_image"].ToString();
            ttwork_time.Text = dr["work_time"].ToString();
            ttfire_work.Text = dr["fire_time"].ToString();
            tt_born.Text = dr["teacher_born"].ToString();
            int rateID = Convert.ToInt32(dr["rate_ID"].ToString());
            string ratesql = "select rate_name from rate where rate_ID="+rateID;
            SqlDataReader dr_rate = DB.RunGetReader(ratesql);
            if (dr_rate.Read())
                teacher_rate.Text = dr_rate["rate_name"].ToString();
            int deptID = Convert.ToInt32(dr["dept_ID"].ToString());
            string deptsql = "select dept_name from dept where dept_ID=" + deptID;
            SqlDataReader dr_dept = DB.RunGetReader(deptsql);
            if (dr_dept.Read())
                teacher_dept.Text = dr_dept["dept_name"].ToString();

        }

    }
    
    protected void btn_altteacher_Click(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            int teacherID = Convert.ToInt32(Request.QueryString["teacherID"]);
            string teacher_name = this.tt_name.Text.Trim();
            string teacher_sex = tt_sex.SelectedValue;
            int teacher_age = Convert.ToInt32(tt_age.Text.Trim());
            string teacher_phone = tt_phone.Text;
            string teacher_address = tt_address.Text;
            string teacher_mail = tt_mail.Text;
            string teacher_intru = tt_intru.Text;
            string teacher_fea = tt_fea.Text.Trim();
            string teacher_IDcard = tt_IDcard.Text.Trim();
            int rate_ID = Convert.ToInt32(trate.SelectedValue);
            int dept_ID = Convert.ToInt32(tdept.SelectedValue);
            int IS_head = 0;
            if (ttIS_head.Checked) IS_head = 1;
            int IS_work = 0;
            if (ttIS_work.Checked) IS_work = 1;
            int IS_fire = 0;
            if (ttIS_fire.Checked) IS_fire = 1;
            string work_time = ttwork_time.Text;
            string fire_time = ttfire_work.Text;
            string filename;
            if (tupload_image.PostedFile.ContentLength != 0)
            {
                filename = tupload_image.PostedFile.FileName;
                filename = filename.Substring(filename.LastIndexOf("\\") + 1);
            }
            else
              filename = "no.jpg";
            
            filename = Server.MapPath("image\\") + filename;
            Response.Write(filename);
            tupload_image.PostedFile.SaveAs(filename);
            string teacher_born = tt_born.Text;
            teacher tc = new teacher(teacherID,teacher_name, dept_ID, rate_ID, teacher_sex, teacher_age, teacher_phone, teacher_address, teacher_IDcard, teacher_fea, teacher_mail, IS_head, IS_work, IS_fire, work_time, fire_time, filename, teacher_born, teacher_intru);
            Boolean flag = teacher.alt_teacher(tc);
            if (flag) Response.Write("<script>alert('修改成功');</script>");
            else Response.Write("<script>alert('修改失败');</script>");
           

      
        }
    }
    protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {

    }
}