cst_customer_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_Customer_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
        { 
          dataCustometBind();
        }
       
    }

    private void dataCustometBind()
    {
        Ccustomer oCous = new Ccustomer();
        DataTable dt = oCous.showtab();
        GridView1.DataSource = dt;
        GridView1.DataBind();
        drlID.DataSource = dt;
        drlID.DataTextField = "cust_id";
        drlID.DataBind();

        drlname.DataSource = dt;
        drlname.DataTextField = "name";
        drlname.DataBind();
    }

    protected void ButAdd_Click(object sender, EventArgs e)
    {

    }
    
    protected void ButSelect_Click(object sender, EventArgs e)
    {
        Ccustomer oCous = new Ccustomer();
        GridView1.DataSource = oCous.GetTable(this.TxtInputID.Text, this.TxtInputname.Text);
        GridView1.DataBind();
    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string strID = GridView1.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Write("<script>window.open('CST_customer_add.aspx?getID=" + 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)
    {

        Ccustomer oCous = new Ccustomer();
        string ID = GridView1.DataKeys[e.RowIndex].Value.ToString();

        if (oCous.delete(ID))
        {
            Response.Write("<script>alert('删除成功!')</script>");
            this.dataCustometBind();
        }
        else
        {
            Response.Write("<script>alert('删除失败!')</script>");
            this.dataCustometBind();
        }

    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        this.dataCustometBind();
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        string FileName = Server.MapPath("../xml/CST_Ccustomer.xml");
        XML_Ccustomer oXcust = new XML_Ccustomer();
        int count_numeul = GridView1.Rows.Count;
        for (int i=1; i <count_numeul; i++)
        {
            string ID = GridView1.Rows[i].Cells[0].Text.ToString();
            string Xm = GridView1.Rows[i].Cells[1].Text.ToString();
            string pwd = GridView1.Rows[i].Cells[2].Text.ToString();
            string emamel = GridView1.Rows[i].Cells[3].Text.ToString();

            oXcust.WriteXml(FileName, ID, Xm,pwd, emamel);
          
        }

        
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        try
        {


            string FileName = Server.MapPath("../xml/CST_Ccustomer.xml");
            XML_Ccustomer oXcust = new XML_Ccustomer();
            GridView1.DataSource = oXcust.ReaderXml(FileName);
            GridView1.DataBind();


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

            string xdd = GridView1.Rows[i].Cells[0].Text.ToString().Trim();
            int ss = int.Parse(xdd) + 2;
            string ID = ss.ToString();
                string Xm = GridView1.Rows[i].Cells[1].Text.ToString();
                string pwd = GridView1.Rows[i].Cells[2].Text.ToString();
                string emamel = GridView1.Rows[i].Cells[3].Text.ToString();
                Ccustomer oCous = new Ccustomer();
                oCous.Add(ID, Xm, pwd, emamel);
            }

        }
        catch 
        {
 
        }

    }
}