cst_items_select.aspx.cs

小型的一个简单的系统开发的实现了简---添加--删除--修改---（vs2005和SQl2005）用到了一些JS脚本

/*
File Name	:  

Description	: 商品管理页面的类文件

Programmer 	 : wucibo
 
Make Date  	 : 2009.02.15

Change     	 : wucibo... 2009.02.15... 增加XML导入和导出功能... V 0.1…
             
*/

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;

public partial class Admin_CST_items_select : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Convert.ToString(Session["name"]) == "")
        {
            Response.Write("<script language=javascript>alert('请登陆!');location='../login.aspx'</script>");
        }
        else
        {
        DataBind();
        Items oItem = new Items();

        drlItem.DataSource = oItem.showtable() ;
        drlItem.DataTextField = "item_id";
        drlItem.DataBind();

        drlCat.DataSource = oItem.showtable();
        drlCat.DataTextField = "category_id";
        drlCat.DataBind();
        }
       

    }
    private void DataBind()
    {
        Items oItem = new Items();
        GridView1.DataSource = oItem.showtables();
        GridView1.DataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string strItem = null;

        Response.Write("<script>window.open('CST_items_add.aspx?id=" + strItem + "','','width=300,height=350,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=300,left=300, resizable=no,location=no, status=no')</script>");
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //Items oItem = new Items();
        //GridView1.DataSource = oItem.Add(this.TxtInputItem.Text  , this.TxtInputCat.Text );
        //GridView1.DataBind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Items oItem = new Items();
        string item_id = GridView1.DataKeys[e.RowIndex].Value.ToString();

        if (oItem.delete(item_id))
        {
            Response.Write("<script>alert('删除成功!')</script>");
            this.DataBind();
        }
        else
        {
            Response.Write("<script>alert('删除失败!')</script>");
            this.DataBind();
        }
    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string strItem = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Write("<script>window.open('CST_items_add.aspx?id=" + strItem + "','','width=300,height=350,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=300,left=300, resizable=no,location=no,status=no')</script>");
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        this.DataBind();
    }

    protected void Button3_Click(object sender, EventArgs e)
    {

    }
}