温馨提示:代码在线浏览功能只能做为源码浏览参考,不能展示项目的全部,如果想更进一步了解该代码请下载:科信客户关系管理系统源码
当前文件路径:KeXinCrm/CompanyManages.aspx.cs

1using System; 2
using System.Collections; 3
using System.ComponentModel; 4
using System.Data; 5
using System.Drawing; 6
using System.Web; 7
using System.Web.SessionState; 8
using System.Web.UI; 9
using System.Web.UI.WebControls; 10
using System.Web.UI.HtmlControls; 11
using System.Data.SqlClient; 12
13
namespace 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 窗体设计器生成的代码 97
98
} 99
} 100





}