meditchapter.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 System.Data.SqlClient;
using TQMS;

public partial class Manager_MEditChapter : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UserName"] == null)
        {
            Page.Response.Redirect("~/Default.aspx");
        }
        else
        {
            if (!IsPostBack)
            {

                if (Request.QueryString["action"].ToString() == "edit")
                {
                    FormView1.DefaultMode = FormViewMode.Edit;
                }
                else
                {
                    FormView1.DefaultMode = FormViewMode.Insert;
                }
               
            }
        }
    }


    ///// <summary>
    ///// 绑定下拉列表框
    ///// </summary>
    //protected void BindDdlCourse()
    //{
      
        
    //}
    
    ///// <summary>
    ///// 编辑章信息
    ///// </summary>
    ///// <param name="sender"></param>
    ///// <param name="e"></param>
    //protected void btnEdit_Click(object sender, EventArgs e)
    //{
    //    if (ddlCourse.SelectedValue == "0")
    //    {
    //        Response.Write("<script language='javascript'>alert('科目必须选择!!!');</script>");

    //        return;
    //    }
    //    else
    //    {
    //        if (tbxChapterName.Text.Trim() == "")
    //        {
    //            Response.Write("<script language='javascript'>alert('请输入章名称!!!');</script>");
    //            return;
    //        }
    //        else if (tbxChapterName.Text.Length >= 30)
    //        {
    //            Response.Write("<script language='javascript'>alert('名称太长了，不能大于30个字符!!!');</script>");
    //            return;
    //        }
    //    }
    //    //SqlConnection conn = DB.CreateConnection();
    //    //conn.Open();
    //    //SqlCommand cmd = new SqlCommand("up_EditChapter", conn);
    //    //cmd.CommandType = CommandType.StoredProcedure;
    //    //cmd.Parameters.Add("@ChapterID", SqlDbType.Int);
    //    //cmd.Parameters.Add("@ChapterName", SqlDbType.NVarChar, 30);
    //    //cmd.Parameters.Add("@CourseID", SqlDbType.Int);
    //    //cmd.Parameters["@ChapterID"].Value = int.Parse(this.lblChapterID.Text);
    //    //cmd.Parameters["@ChapterName"].Value = this.tbxChapterName.Text.Trim();
    //    //cmd.Parameters["@CourseID"].Value = int.Parse(this.ddlCourse.SelectedValue);
    //    try
    //    {
    //        //cmd.ExecuteNonQuery();
    //        this.lblMaessege.Text = "修改成功!";
    //        this.lblMaessege.Style["Color"] = "Green";
    //        //Response.Redirect("MChapterAndSection.aspx");
    //    }
    //    catch(SqlException error)
    //    {
    //        this.lblMaessege.Text = "修改章目信息失败，请稍后再试,原因："+error.Message;
    //        this.lblMaessege.Style["Color"] = "red";
    //    }
    //    finally
    //    {
    //        //conn.Close();
            
    //    }
        
    //}



    protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e)
    {
        if (e.AffectedRows > 0)
        {
            this.lblMessege.Text = "添加成功!!!";
            this.lblMessege.Style["color"] = "green";
        }
        else
        {
            this.lblMessege.Text = "添加失败!!!";
            this.lblMessege.Style["color"] = "red";
        }
    }
}