leibietianjia.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;

public partial class Web_Leibietianjia : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        //this.btnC.Attributes.Add("onclick", "window.close()");
        if (!IsPostBack)
        {
            SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["db_KnowledgeConnectionString"].ToString());
            conn.Open();

            //父类别下拉


            SqlDataAdapter sdal = new SqlDataAdapter("SELECT Category_id, Category_name FROM tb_Category ", conn);
            DataSet dsl = new DataSet();
            sdal.Fill(dsl, "tb_Category");

            this.DropDownList1.DataValueField = "Category_id";
            this.DropDownList1.DataTextField = "Category_name";
            this.DropDownList1.DataSource = dsl;
            this.DropDownList1.DataBind();
            this.DropDownList1.Items.Insert(0, new ListItem("<--请选择父类-->", ""));
        }
    }
    protected void btnU_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["db_KnowledgeConnectionString"].ToString());
        conn.Open();

        //get the level 
        string strParentId = DropDownList1.SelectedValue.ToString();
        int intLevel = getNewLevel(conn, strParentId);

        string strsql = "insert into tb_Category(Category_name,Category_parent_id,category_level) values('" + this.TextBox1.Text.Trim() + "','" + this.DropDownList1.SelectedValue + "'," + intLevel.ToString() + ")";
        bc.ExecSQL(strsql);

        Response.Write(bc.MessageBox("数据添加成功！"));
        Response.Write("<script>window.close()</script>");
        Page.Response.Redirect("~/Web/ListCate.aspx");
    }

    private static int getNewLevel(SqlConnection sqlCon, string strParentId)
    {
        string strSqlGetLevel = "select category_level from tb_category where category_id = '" + strParentId + "'";
        SqlDataAdapter sdaParentId = new SqlDataAdapter(strSqlGetLevel, sqlCon);
        DataSet dsParentId = new DataSet();
        sdaParentId.Fill(dsParentId);

        int intLevel;
        intLevel = int.Parse(dsParentId.Tables[0].Rows[0]["category_level"].ToString());

        intLevel++;
        return intLevel;
    }



    protected void btnC_Click(object sender, EventArgs e)
    {

        //Response.Write("<script language:javascript>javascript:window.close();</script>");
        Page.Response.Redirect("~/Web/ListCate.aspx");
    }
}