cstraceinfr.aspx.cs

掌握计算机管理信息系统设计的一般方法

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;
using System.Data.SqlClient;

public partial class cstraceinfr : System.Web.UI.Page
{
    public string temp1;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            BindClassData();
            
        }
    }
    private void BindClassData()
    {
        ///获取用户数据
        String s = "trace";
        edit cla = new edit();
        DataSet dr = cla.GetCustomertypefo(s);
        ///设置GridView的数据源，并绑定数据
        traceView.DataSource = dr;
        traceView.DataBind();//数据绑定
        ///关闭数据读取器
    //    dr.Close();
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Response.Redirect("Addcusinfro.aspx");
    }
    protected void traceView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        TextBox2.Enabled = true;
        TextBox3.Enabled = true;
        TextBox4.Enabled = true;
        TextBox5.Enabled = true;
        TextBox6.Enabled = true;
       TextBox1.Text = traceView.Rows[e.NewEditIndex].Cells[0].Text;
        TextBox2.Text = traceView.Rows[e.NewEditIndex].Cells[1].Text;
        TextBox3.Text = traceView.Rows[e.NewEditIndex].Cells[2].Text;
        TextBox4.Text = traceView.Rows[e.NewEditIndex].Cells[3].Text;
        TextBox5.Text = traceView.Rows[e.NewEditIndex].Cells[4].Text;
        TextBox6.Text = traceView.Rows[e.NewEditIndex].Cells[5].Text;
    }
    protected void traceView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string temp = traceView.Rows[e.RowIndex].Cells[0].Text;
        edit cla = new edit();
        String cmdtext = "delete from trace   where tracecode=" + "'" + temp + "'";
        cla.execute(cmdtext);
        Response.Write("<script>alert('" + "更新数据成功，请妥善保管好数据！" + "');</script>");
        BindClassData();
    }
  
    protected void LinkButton2_Click1(object sender, EventArgs e)
    {
      edit cla = new edit();
        temp1 = TextBox1.Text.Trim();
        String cmdtext = "update trace set tracecode='" + TextBox1.Text.Trim() +
            "',relationcode='" + TextBox2.Text.Trim() +
            "',customercode='" + TextBox3.Text.Trim() +
            "',tracedate='" + TextBox4.Text.Trim() +
            "',tracecontent='" + TextBox5.Text.Trim() +
            "',note='" + TextBox6.Text.Trim() +
             "'where tracecode=" + "'" + temp1 + "'";
        int nResult = -1;
        cla.execute(cmdtext);
        if (nResult != -1)
        {
            Response.Write("<script>alert('" + "更新数据成功，请妥善保管好数据！" + "');</script>");
            BindClassData();
         
        }
        else
        {
            Response.Write("<script>alert('" + "更新数据失败，请妥善保管好数据！" + "');</script>");
        }    
    }
    protected void traceView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        traceView.PageIndex = e.NewPageIndex;
        BindClassData();
    }
}