cst_categories_select.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_categories_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();

        Catories oCat = new Catories();
        
        drlname.DataSource = oCat.ShowTable();
        drlname.DataTextField = "name";
        drlname.DataBind();
 
        drlID.DataSource = oCat.ShowTable();
        drlID.DataTextField = "category_id";
        drlID.DataBind(); 
        }
    } 

    private void DataBind()
    {
        Catories oCat = new Catories();
        GridView1.DataSource = oCat.ShowTable();
        GridView1.DataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string strID = null;

        Response.Write("<script>window.open('CST_categories_add.aspx?id=" + strID + "','','width=300,height=250,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=300,left=300, resizable=no,location=no, status=no')</script>");
    }
   
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string strID = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Write("<script>window.open('CST_categories_add.aspx?id=" + strID + "','','width=300,height=250,Resizable=no,toolbar=no, menubar=no, scrollbars=no,top=300,left=300, resizable=no,location=no,status=no')</script>");
    }
   
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {   
         Catories oCat = new Catories();
         string ID = GridView1.DataKeys[e.RowIndex].Value.ToString();
         
         if (oCat.delete(ID))
         {
             Response.Write("<script>alert('删除成功!')</script>");
             this.DataBind();
         }
         else
         {
             Response.Write("<script>alert('删除失败!')</script>");
             this.DataBind();
         }
    }
   
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        this.DataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
         Catories oCat = new Catories();
         GridView1.DataSource = oCat.GetTable( this.TxtInputID.Text,this.TxtInputname.Text);
         GridView1.DataBind();
        
    }

    protected void Button3_Click(object sender, EventArgs e)
    {

        string FileName = Server.MapPath("../xml/CST_Catories.xml");

        XML_Catories oXcato = new XML_Catories();

        int count_numeul = GridView1.Rows.Count;
        for (int i = 1; i < count_numeul; i++)
        {
            string ID = GridView1.Rows[i].Cells[1].Text.ToString();
            string Xm = GridView1.Rows[i].Cells[0].Text.ToString();
           

            oXcato.WriteXml(FileName,ID, Xm );

        }
    }
   
    protected void Butok_Click1(object sender, EventArgs e)
    {
      try
        {
             XML_Catories oXcato = new XML_Catories();

            string FileName = Server.MapPath("../xml/CST_Catories.xml");
            GridView1.DataSource = oXcato.ReaderXml(FileName);
            GridView1.DataBind();

           
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
            

                string xdd = GridView1.Rows[i].Cells[1].Text.ToString().Trim();
                int ss = int.Parse(xdd)+2;
                string ID = ss.ToString();
                string Xm = GridView1.Rows[i].Cells[0].Text.ToString();
                Catories oCat = new Catories();
                oCat.Add(ID, Xm);
            }
        }
        catch
        { 
        }
    }
}