当前文件路径：KeXinCrm/CompanyManages1.aspx.cs

		            
  1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Drawing;
  6using System.Web;
  7using System.Web.SessionState;
  8using System.Web.UI;
  9using System.Web.UI.WebControls;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12
 13namespace CRMS
 14...{
 15    /**//// <summary>
 16    /// MyCompany 的摘要说明。
 17    /// </summary>
 18    public partial class CompanyManages1 : System.Web.UI.Page
 19    ...{
 20        private string sql="";
 21        protected System.Web.UI.WebControls.Button Button1;
 22        data hsjdata=new data();
 23        protected void Page_Load(object sender, System.EventArgs e)
 24        ...{
 25            // 在此处放置用户代码以初始化页面
 26            
 27            //Response.Write(sql);
 28            //Response.End();
 29            
 30            if (Session["managerin"]!=null)
 31            ...{
 32                if(Session["MemberState"].ToString()=="关闭")
 33                ...{
 34                    Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您的帐号已经被停止使用！");
 35                }
 36                if(Session["MemberAuthority"].ToString()!="系统管理员")
 37                ...{
 38                    Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您不是系统管理员不能管理意向客户！");
 39                }
 40                if(!Page.IsPostBack)
 41                ...{
 42                    
 43                    bind();
 44                    
 45                }
 46            }
 47            else
 48            ...{
 49                Response.Redirect("login.aspx");
 50            }
 51        }
 52        public void binddata(string sql)
 53        ...{
 54            sql="SELECT Operation,CompanyName,CompanyContact,Telephone,Cellphone,MemberName,RealName,addtime,CompanyID FROM VIEW_Company WHERE Operation='意向客户' order by CompanyId desc";
 55            DataSet ds=hsjdata.dbbind(sql);
 56            dg1.DataSource=ds.Tables["mytable"].DefaultView;
 57            dg1.DataBind();
 58            
 59        }
 60    
 61        public void bind()
 62        ...{
 63            binddata(sql);
 64        }
 65        private void dg1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
 66        ...{
 67            try
 68            ...{
 69                this.dg1.CurrentPageIndex = e.NewPageIndex;
 70            }
 71            catch
 72            ...{
 73                this.dg1.CurrentPageIndex = 0;
 74            }
 75            bind();
 76        }
 77
 78        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 79        override protected void OnInit(EventArgs e)
 80        ...{
 81            //
 82            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 83            //
 84            InitializeComponent();
 85            base.OnInit(e);
 86        }
 87        
 88        /**//// <summary>
 89        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 90        /// 此方法的内容。
 91        /// </summary>
 92        private void InitializeComponent()
 93        ...{    
 94            //this.Button1.Click += new System.EventHandler(this.Button1_Click);
 95            this.dg1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dg1_PageIndexChanged);
 96
 97        }
 98        #endregion
 99
100
101    }
102}
103