产品类的操作

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

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

    private void SessionTF()
    {
        if (Session["user"] != null)
        {
            Response.Write("<script language=javascript>window.top.location.href='../index.aspx'</script>");
        }
    }

    private void InsertRecord()
    {
        DataTable dt = Method.Return_DataTable("select * from bigtype",CommandType.Text);
        DropDownList1.DataSource = dt;
        DropDownList1.DataTextField = "name";
        DropDownList1.DataValueField = "id";
        DropDownList1.DataBind();
   
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        Method.ExecuteNonQuery_DataTable("insert type values(@pid,@name,@memo)",CommandType.Text,
            new SqlParameter("@pid",DropDownList1.SelectedValue),
            new SqlParameter("@name",Product.Text.Trim()),
            new SqlParameter("@memo",TextBox1.Text.Trim())
            );
        Server.Transfer("ProductBit.aspx");
    }

    private void Databind_Data()
    {

        GridView1.DataSource = Method.Return_DataTable("select b.id id ,a.name classbig,b.name classbit,b.memo memo from bigtype a join type b on a.id=b.parentid", CommandType.Text);
        GridView1.DataBind();
    }

    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
       
        GridView1.PageIndex = e.NewPageIndex;

        Databind_Data(); ;
        DataBind();
      
    }
    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
      
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;

        Databind_Data();

    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        DropDownList drop = GridView1.Rows[e.RowIndex].Cells[1].FindControl("DropDownList2") as DropDownList;  //所属大类
        TextBox textbox = GridView1.Rows[e.RowIndex].Cells[2].FindControl("txtclassbit") as TextBox;           //小类
        TextBox memo = GridView1.Rows[e.RowIndex].Cells[3].FindControl("TextBox2") as TextBox;                 //memo
        Label label = GridView1.Rows[e.RowIndex].Cells[0].FindControl("Label3") as Label;

        if (textbox != null && drop != null && memo != null)
        {
            Method.ExecuteNonQuery_DataTable("update type set parentid=@pid,name=@name,memo=@memo where id=@id", CommandType.Text,
                new SqlParameter("@pid", drop.SelectedValue),
                new SqlParameter("@name", textbox.Text.Trim()),
                new SqlParameter("@memo", memo.Text.Trim()),
                new SqlParameter("@id", label.Text)
                );
        }

        GridView1.EditIndex = -1;
        Databind_Data();
       
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Label  label = GridView1.Rows[e.RowIndex].Cells[0].FindControl("Label2") as Label;
        if (label==null)
        {
            return;
        }
        Method.ExecuteNonQuery_DataTable("delete from type where id=@id",CommandType.Text,new SqlParameter("@id",label.Text.Trim()));
        ClientScript.RegisterClientScriptBlock(GetType(),"aaa","<script>alert('删除成功!')</script>");
        Databind_Data();

    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        Databind_Data();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {

    }
}