alt_school_plan.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 teaching_manage_school_plan_alt_school_plan : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
            init_sp();
    }
      private void init_sp()
    {
        int spID = Convert.ToInt32(Request.QueryString["school_pID"].ToString());
        string sql = "select * from school_plan where school_pID="+spID;
        SqlDataReader dr = DB.RunGetReader(sql);
        if (dr.Read())
        {
            sp_stime.Text = dr["school_pstartdate"].ToString();
            sp_etime.Text = dr["school_penddate"].ToString();
            sp_content.Text = dr["school_pcontent"].ToString();

        }

        dr.Close();
     }
    protected void btn_altsp_Click(object sender, EventArgs e)
    {
        int spID = Convert.ToInt32(Request.QueryString["school_pID"].ToString());
        string type = sp_type.Text;
        string start = sp_stime.Text;
        string end = sp_etime.Text;
        string content = sp_content.Text;
        school_plan sp = new school_plan(spID,type, start, end, content);
        Boolean flag = school_plan.alt_school_plan(sp) ;
        if (flag) Response.Write("<script>alert('修改成功');</script>");
        else Response.Write("<script>alert('修改失败');</script>");
    }
}