cst_orders_selecte.aspx.cs

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

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_Orders_selecte : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        DataBind();
        Orders oOrd = new Orders();
        if (!IsPostBack)
        {
            this.DorpDownList();
        }
    }
    //
    //数据绑定
    //
    private void DataBind()
    {
        Orders oOrd = new Orders();
        GridView1.DataSource = oOrd.xs();
        GridView1.DataBind();

    }
    //
    //下拉列表绑定值
    //
    public void DorpDownList() 
    {
        Orders oOrd = new Orders();
        DataTable DT = oOrd.TD();
        this.ddlOrderid.DataSource = DT;
        this.ddlOrderid.DataTextField = "order_id";
        this.ddlOrderid.DataValueField = "order_id";
        this.ddlitemid.DataSource = DT;
        this.ddlitemid.DataTextField = "item_id";
        this.ddlitemid.DataValueField = "item_id";
        this.ddlOrderid.DataBind();
        this.ddlitemid.DataBind();

    }

    //
    //弹出新添加窗口
    //

    protected void Button4_Click(object sender, EventArgs e)
    {
        ////Response.Write("<script type='text/javascript'>  window.open('CST_orders_add.aspx', 'newwindow', 'height=300, width=300, top=300,left=300, menubar=no, scrollbars=no,');</script>");
        ////Response.Write("<script type='test/javascript'> window.open('CST_orders_selecte.aspx','newwindow','width=300,height=250,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=300,left=300, resizable=no,location=no, status=no');</script>");
        string strID = null;

        Response.Write("<script>window.open('CST_orders_add.aspx?id=" + strID + "','','width=300,height=280,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=290,left=300, resizable=no,location=no, status=no')</script>");
    }
    //
    //刷新
    //
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.DataBind();
    }
    //
    //删除订单
    //
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Orders oOrd = new Orders();
        string ID = GridView1.DataKeys[e.RowIndex].Value.ToString();
        //string ID = Convert.ToString(GridView1.DataKeys[e.RowIndex]);
        if (oOrd.delete(ID))
        {
            Response.Write("<script>alert(删除成功！)</script>");
            this.DataBind();
        }
        else
        {
            Response.Write("<script>alert('删除失败!')</script>");
            this.DataBind();

        }
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
       
         
    }
    //
    //修改订单信息
    //
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string strID = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Write("<script>window.open('CST_orders_add.aspx?id=" + strID + "','','width=300,height=280,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=290,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)
    {
        Xml_Order oOrd = new Xml_Order();
        oOrd.ReadXML();
        this.DataBind();
    }

    protected void Button5_Click(object sender, EventArgs e)
    {
        Xml_Order oOrd = new Xml_Order();
        oOrd.WriteXML();
        this.DataBind();
    }
}