当前文件路径：KeXinCrm/CompanyManages.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 CompanyManages : System.Web.UI.Page
 19    ...{
 20        private string sql="";
 21        data hsjdata=new data();
 22        protected void Page_Load(object sender, System.EventArgs e)
 23        ...{
 24            // 在此处放置用户代码以初始化页面
 25            
 26            //Response.Write(sql);
 27            //Response.End();
 28            
 29            if (Session["managerin"]!=null)
 30            ...{
 31                if(Session["MemberState"].ToString()=="关闭")
 32                ...{
 33                    Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您的帐号已经被停止使用！");
 34                }
 35                if(Session["MemberAuthority"].ToString()!="系统管理员")
 36                ...{
 37                    Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您无权访问！");
 38                }
 39                if(!Page.IsPostBack)
 40                ...{
 41                    
 42                    bind();
 43                    
 44                }
 45            }
 46            else
 47            ...{
 48                Response.Redirect("login.aspx");
 49            }
 50        }
 51        public void binddata(string sql)
 52        ...{
 53            sql="SELECT Operation,CompanyName,CompanyContact,Telephone,Cellphone,MemberName,RealName,addtime,CompanyID,datediff(day,ProtectionTime,getdate()) as DayCount FROM VIEW_Company WHERE  Operation='申请保护' order by CompanyId desc";
 54            DataSet ds=hsjdata.dbbind(sql);
 55            dg1.DataSource=ds.Tables["mytable"].DefaultView;
 56            dg1.DataBind();
 57            
 58        }
 59    
 60        public void bind()
 61        ...{
 62            binddata(sql);
 63        }
 64        private void dg1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
 65        ...{
 66            try
 67            ...{
 68                this.dg1.CurrentPageIndex = e.NewPageIndex;
 69            }
 70            catch
 71            ...{
 72                this.dg1.CurrentPageIndex = 0;
 73            }
 74            bind();
 75        }
 76
 77        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 78        override protected void OnInit(EventArgs e)
 79        ...{
 80            //
 81            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 82            //
 83            InitializeComponent();
 84            base.OnInit(e);
 85        }
 86        
 87        /**//// <summary>
 88        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 89        /// 此方法的内容。
 90        /// </summary>
 91        private void InitializeComponent()
 92        ...{    
 93            this.dg1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dg1_PageIndexChanged);
 94
 95        }
 96        #endregion
 97
 98    }
 99}
100