csmanage.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 csmanage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
         
            edit cla = new edit();
           DataSet dr = cla.GetCustomertypefo("customer");
            CustomerView.DataSource = dr;
            CustomerView.DataBind();
           
          //  dr.Close();
        }
    }
    protected void linkbutton_Click(object sender, EventArgs e)
    {
        result.Text = null;
        string code = ccode.Text.Trim().ToString();
         String cmdtext = "select customertypecode,customertypename from customer,customertype where customercode=" + "'" + code + "'";
        edit cla = new edit();
        SqlDataReader dr = cla.GetSingleCTCode(cmdtext);
        if (dr.Read())
        {
        string temp = "\t\n";
              result.Text="Type:"+  dr["customertypecode"].ToString()+temp+"Name:"+dr["customertypename"].ToString();
        }
        dr.Close();

    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        result.Text = null;
        String code = ccode.Text.Trim().ToString();
        String cmdtext = "select address,phone,mobile,birthday,hobby from customer where customercode=" + "'" + code + "'";
        edit cla = new edit();
        SqlDataReader dr = cla.GetSingleCTCode(cmdtext);
        if (dr.Read())
        {
            string temp = "\t\n";
            result.Text = "地址:" + dr["address"].ToString() + temp + "电话:" + dr["phone"].ToString() + temp + "手机:" + dr["mobile"].ToString() + temp + "生日:" + dr["birthday"].ToString() +temp + "兴趣:" + dr["hobby"].ToString();
        }
        dr.Close();
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        result.Text = null;
        String code = ccode.Text.Trim().ToString();
        String cmdtext = "select relationcode,relationname from customer,relation where customer.customercode=" + "'" + code +  "'and customer.customercode=relation.customercode ";
        edit cla = new edit();
        SqlDataReader dr = null;
        dr = cla.GetSingleCTCode(cmdtext);
        if (dr.Read())
        {
            string temp = "\t\n";
            result.Text = "负责人编号:" + dr["relationcode"].ToString() + temp + "负责人姓名:" + dr["relationname"].ToString();
        }
        else
        {
            result.Text = "没有相关纪录！";
        }
        dr.Close();
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        result.Text = null;
        String code = ccode.Text.Trim().ToString();
        String cmdtext = "select tracecontent,tracedate from customer,trace where customer.customercode=" + "'" + code + "'and customer.customercode=trace.customercode ";
        SqlConnection myconnect = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);
        SqlCommand mycommand = new SqlCommand(cmdtext, myconnect);
        SqlDataReader dr = null;
        try
        {
            myconnect.Open();
            dr = mycommand.ExecuteReader(); ;
        }
        catch (SqlException ex)
        {
            throw new Exception(ex.Message, ex);
        }
         while (dr.Read())
        {
            string temp = "\t\n";
            result.Text += "客户消费内容:" + dr["tracecontent"].ToString() + temp + "登记日期:" + dr["tracedate"].ToString();
        }
        if (!dr.Read())
        {
            result.Text = "你所查询的客户尚无此类信息！";
        }
       dr.Close();

    }
    protected void CustomerView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        String  ctcodeID = null;
        ctcodeID = CustomerView.Rows[e.NewEditIndex].Cells[0].Text;
        Response.Redirect("update2.aspx?ctcodeID=" + ctcodeID);
    }
    protected void CustomerView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string temp = CustomerView.Rows[e.RowIndex].Cells[0].Text;
        edit cla = new edit();
        String cmdtext = "delete from customer   where customercode=" + "'" + temp + "'";
        cla.execute(cmdtext);
        Response.Write("<script>alert('" + "更新数据成功，请妥善保管好数据！" + "');</script>");
        Response.Redirect("csmanage.aspx");
    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        Response.Redirect("Addcustomer.aspx");
    }
    protected void CustomerView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        CustomerView.PageIndex = e.NewPageIndex;
        edit cla = new edit();
        DataSet dr = cla.GetCustomertypefo("customer");
        CustomerView.DataSource = dr;
        CustomerView.DataBind();
    }
}