showresearch.aspx.cs

基于C#语言的一个企业客户管理数据库系统开发案例的源代码 ,很实用

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 ShowResearch : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["flag"] == null && Session["TypeValues"]==null)
        {

            Response.Write("../Login.aspx");
        }
        if (!IsPostBack)
        {
            if (Session["TypeValues"].ToString() != "0")
            {
                this.gvBind.Columns[4].Visible = false;
            }
            this.Bind();
        }
    }
    public void Bind()
    {
        DataSet ds = Operation.ReDataSet("BindResearch");
        this.gvBind.DataSource = ds;
        this.gvBind.DataKeyNames=new string[]{"ID"};
        this.gvBind.DataBind();
    }

    protected void gvBind_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int ID =int.Parse( this.gvBind.DataKeys[e.RowIndex].Value.ToString());
        Operation.ExSql("DelResearchInfo",ID);
        this.Bind();
    }
    protected void gvBind_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            string Type=e.Row.Cells[3].Text;
            switch(Type)
            {
                case "0":e.Row.Cells[3].Text="不满意";
                    break;
                case "1":e.Row.Cells[3].Text="满意";
                    break;
                case "2":e.Row.Cells[3].Text="一般";
                    break;
            }
            ((LinkButton)(e.Row.Cells[5].Controls[0])).Attributes.Add("onclick","return confirm('你确定删除吗？')");
            Label l = (Label)e.Row.Cells[4].FindControl("Label1");//找到gvBind控件中的Lable
            l.ToolTip = l.Text;
            if (l.Text.Length > 5)
            {
                l.Text = l.Text.Substring(0, 5) + "…";//只显示Appraise字段的前五个字符及“…”    
            }
            
        }
    }
    protected void gvBind_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.gvBind.PageIndex = e.NewPageIndex;
        this.Bind();
    }
}