当前文件路径：KeXinCrm/ContractList.aspx.cs 
1
using 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;
12namespace CRMS
13
...{
14
/**//// <summary>
15
/// ContractList 的摘要说明。
16
/// </summary>
17 public partial class ContractList : System.Web.UI.Page
18 ...{
19 private string sql="";
20 private string sql2="";
21 protected System.Web.UI.WebControls.DataGrid DataGrid1;
22 protected System.Web.UI.WebControls.HyperLink Hyperlink11;
23 protected System.Web.UI.WebControls.HyperLink Hyperlink2;
24 protected System.Web.UI.WebControls.HyperLink Hyperlink4;
25 protected System.Web.UI.WebControls.HyperLink Hyperlink5;
26 protected System.Web.UI.WebControls.HyperLink Hyperlink6;
27 data hsjdata=new data();
28 protected void Page_Load(object sender, System.EventArgs e)
29 ...{
30 // 在此处放置用户代码以初始化页面
31 if (Session["managerin"]!=null)
32 ...{
33 if(Session["MemberState"].ToString()=="关闭")
34 ...{
35 Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您的帐号已经被停止使用！");
36 }
37 if(Session["MemberAuthority"].ToString()!="系统管理员")
38 ...{
39 Response.Redirect("ErrorPage.aspx?ErrMms=对不起，您无权访问！");
40 }
41 if(!Page.IsPostBack)
42 ...{
43 //显示合同分类数目
44 /**//*
45 string sqlT1="SELECT COUNT(*) FROM Contract Where ContractClass='域名合同'";
46 SqlDataReader dr1=hsjdata.readrow(sqlT1);
47 T1.Text=dr1.GetValue(0).ToString();
48 string sqlT2="SELECT COUNT(*) FROM Contract Where ContractClass='网站合同'";
49 SqlDataReader dr2=hsjdata.readrow(sqlT2);
50 T2.Text=dr2.GetValue(0).ToString();
51 string sqlT3="SELECT COUNT(*) FROM Contract Where ContractClass='推广合同'";
52 SqlDataReader dr3=hsjdata.readrow(sqlT3);
53 T3.Text=dr3.GetValue(0).ToString();
54 string sqlT4="SELECT COUNT(*) FROM Contract Where ContractClass='短信合同'";
55 SqlDataReader dr4=hsjdata.readrow(sqlT4);
56 T4.Text=dr4.GetValue(0).ToString();
57 string sqlT5="SELECT COUNT(*) FROM Contract Where ContractClass='空间邮箱'";
58 SqlDataReader dr5=hsjdata.readrow(sqlT5);
59 T5.Text=dr5.GetValue(0).ToString();
60 //显示合同状态数目
61 string sqlZ1="SELECT COUNT(*) FROM Contract Where zt='执行'";
62 SqlDataReader dr6=hsjdata.readrow(sqlZ1);
63 Z1.Text=dr6.GetValue(0).ToString();
64 string sqlZ2="SELECT COUNT(*) FROM Contract Where zt='终止'";
65 SqlDataReader dr7=hsjdata.readrow(sqlZ2);
66 Z2.Text=dr7.GetValue(0).ToString();
67 string sqlZ3="SELECT COUNT(*) FROM Contract Where zt='到期'";
68 SqlDataReader dr8=hsjdata.readrow(sqlZ3);
69 Z3.Text=dr8.GetValue(0).ToString();
70 */
71
72 bind();
73 //合同详细页面控制
74 string action=Request.QueryString["action"];
75 string ContractClass=Request.QueryString["ContractClass"];
76 if (action=="")
77 ...{
78 ErrMages.Text="暂时无内容！";
79 }
80 else
81 ...{
82 int CompanyID=Convert.ToInt16(Request.QueryString["CompanyID"]);
83 if (action=="shows" && CompanyID!=0)
84 ...{
85 string sqlC0="SELECT CompanyName FROM Company Where CompanyID="+CompanyID+"";
86 SqlDataReader drc0=hsjdata.readrow(sqlC0);
87 c0Name.Text="公司名称：【"+drc0.GetValue(0).ToString()+"】";
88 if (ContractClass==null)
89 ...{
90 ErrMages.Text="请选择合同类型";
91 }
92 else
93 ...{
94 bind2();
95 }
96 }
97 else
98 ...{
99 ErrMages.Text="暂时无内容！";
100 }
101 if(action=="del")
102 ...{
103 int ContractID=Convert.ToInt16(Request.QueryString["ContractID"]);
104 string SQL="Delete Contract WHERE ContractID="+ContractID+"";
105 try
106 ...{
107 hsjdata.moddata(SQL);
108 Response.Write("<script>alert('删除合同成功！');window.location.href='Javascript:history.go(-2)'</script>");
109 return;
110 }
111 catch
112 ...{
113 Response.Redirect("ErrorPage.aspx?ErrMms=对不起，删除合同时发生错误！");
114 }
115 }
116 }
117 }
118 }
119 else
120 ...{
121 Response.Redirect("login.aspx");
122 }
123 }
124 public void binddata(string sql)
125 ...{
126 sql="SELECT Operation,CompanyName,CompanyContact,Telephone,Cellphone,MemberName,RealName,addtime,CompanyID FROM VIEW_Company WHERE Operation='签订合同' order by CompanyId desc";
127 DataSet ds=hsjdata.dbbind(sql);
128 dg1.DataSource=ds.Tables["mytable"].DefaultView;
129 dg1.DataBind();
130
131 }
132 public void binddata2(string sql)
133 ...{
134 int CompanyID=Convert.ToInt16(Request.QueryString["CompanyID"]);
135 string ContractClass=Request.QueryString["ContractClass"];
136 sql2="SELECT * FROM VIEW_Contract WHERE Operation='签订合同' and CompanyID="+CompanyID+" and ContractClass='"+ContractClass+"' order by CompanyId desc";
137 DataSet ds2=hsjdata.dbbind(sql2);
138 dg2.DataSource=ds2.Tables["mytable"].DefaultView;
139 dg2.DataBind();
140
141 }
142
143 public void bind()
144 ...{
145 binddata(sql);
146 }
147 public void bind2()
148 ...{
149 binddata2(sql);
150 }
151
152 private void dg1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
153 ...{
154 try
155 ...{
156 this.dg1.CurrentPageIndex = e.NewPageIndex;
157 }
158 catch
159 ...{
160 this.dg1.CurrentPageIndex = 0;
161 }
162 bind();
163 }
164
165 Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
166 override protected void OnInit(EventArgs e)
167 ...{
168 //
169 // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
170 //
171 InitializeComponent();
172 base.OnInit(e);
173 }
174
175 /**//// <summary>
176 /// 设计器支持所需的方法 - 不要使用代码编辑器修改
177 /// 此方法的内容。
178 /// </summary>
179 private void InitializeComponent()
180 ...{
181 this.dg1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dg1_PageIndexChanged);
182
183 }
184 #endregion
185
186
187 }
188
}
189
打包下载该项目完整源码：科信客户关系管理系统源码
