当前文件路径：RenKouPuCha/Code/SearchSat.aspx.cs 
1
using System;
2using System.Data;
3using System.Configuration;
4using System.Collections;
5using System.Web;
6using System.Web.Security;
7using System.Web.UI;
8using System.Web.UI.WebControls;
9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class Code_Search : System.Web.UI.Page
14
...{
15
private DataSet _ds = new DataSet();
16 protected CCUtility _utility = new CCUtility();
17 private string _target = ""; //指标
18 private string _area = ""; //乡镇
19 private DataTable generalTb = new DataTable("GeneralTable");
20 protected void Page_Load(object sender, EventArgs e)
21
...{
22 if (!Page.IsPostBack)
23 ...{
24 if (Session["UserID"] == null || Session["RoleID"] == null)
25 ...{
26 Response.Redirect("Login.aspx");
27
}
28 else
29 ...{
30 BindData();
31 }
32 }
33 }
34 public override void VerifyRenderingInServerForm(Control control)
35 ...{
36 //base.VerifyRenderingInServerForm(control);
37 }
38
39 //绑定数据源
40 private void BindData()
41 ...{
42 CreateData();
43 _ds.Tables.Add(generalTb);
44 dg.DataSource = _ds.Tables["GeneralTable"].DefaultView;
45 dg.DataBind();
46 Session.Add("GeneralTable", generalTb);
47 }
48 protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
49 ...{
50 this.MultiView1.ActiveViewIndex= int.Parse(e.Item.Value);
51 }
52
53 统计部分#region 统计部分
54
55 protected void townDropD_SelectedIndexChanged(object sender, EventArgs e)
56 ...{
57 //areaDropD.Items.Clear();
58 if (townDropD.SelectedIndex != -1)
59 ...{
60 string sql = "select countryID,controyName from tCountry where townID=" + townDropD.SelectedValue;
61 _utility.DBOpen();
62 SqlCommand cmd = new SqlCommand(sql, _utility.Connection);
63 SqlDataAdapter da = new SqlDataAdapter();
64 da.SelectCommand = cmd;
65 da.Fill(_ds, "Country");
66 _utility.DBClose();
67 areaDropD.DataSource = _ds.Tables["Country"].DefaultView;
68 areaDropD.DataValueField = "countryID";
69 areaDropD.DataTextField = "controyName";
70 areaDropD.DataBind();
71 }
72 }
73 protected void submitButton_Click(object sender, EventArgs e)
74 ...{
75 _target = targetDropD.SelectedValue;
76 _area = areaDropD.SelectedValue;
77 string sql;
78 if (_target == " "&&areaDropD.DataTextField=="")
79 ...{
80 sql = "select count(idField) as 人数 from tRkry where cityID=" + townDropD.SelectedValue;
81 }
82 else if (_target == " ")
83 ...{
84 sql = "select count(idField) as 人数 from tRkry where townID=" + townDropD.SelectedValue + " and countryID=" + _area;
85 }
86 else if (areaDropD.DataTextField == "")
87 ...{
88 sql = "select count(idField) as 人数 from tRkry where " + _target + " and cityID=" + townDropD.SelectedValue;
89 }
90 else
91 ...{
92 sql = "select count(idField) as 人数 from tRkry where " + _target + " and countryID=" + _area;
93 }
94 _utility.DBOpen();
95 SqlCommand cmd = new SqlCommand(sql, _utility.Connection);
96 int result = Convert.ToInt32(cmd.ExecuteScalar());
97 DataTable dt = new DataTable("Static");
98 DataRow dr;
99 dt.Columns.Add(new DataColumn("指标",typeof(string)));
100 dt.Columns.Add(new DataColumn("单位",typeof(string)));
101 if (areaDropD.DataTextField == "")
102 ...{
103 dt.Columns.Add(new DataColumn(townDropD.SelectedItem.Text, typeof(Int32)));
104 }
105 else
106 ...{
107 dt.Columns.Add(new DataColumn(areaDropD.SelectedItem.Text, typeof(Int32)));
108 }
109 dr=dt.NewRow();
110 dr[0] = targetDropD.SelectedItem.Text;
111 dr[1] = "人";
112 dr[2] = result;
113 dt.Rows.Add(dr);
114 _ds.Tables.Add(dt);
115 dg.DataSource = _ds.Tables["Static"].DefaultView;
116 dg.DataBind();
117
118 }
119
120
121 //统计总表
122 private void CreateData()
123 ...{
124 DataColumn dc1 = new DataColumn("指标", typeof(string));
125 generalTb.Columns.Add(dc1);
126 for (int i = 0; i <townDropD.Items.Count; i++)
127 ...{
128 generalTb.Columns.Add(new DataColumn(townDropD.Items[i].Text, typeof(Int32)));
129 }
130 string sqlPrex = "select count(*) from tRkry where ",sql;
131 _utility.DBOpen();
132 SqlCommand cmd;
133
134 for (int i =0; i < targetDropD.Items.Count; i++)
135 ...{
136 DataRow dr=generalTb.NewRow();
137 dr[0] = targetDropD.Items[i].Text;
138 string link = "<a target=_blank href=GraphicShow.aspx?row="+i+">点击查看图片</a>";
139 dr[0]+=link;
140 for (int j = 1; j < generalTb.Columns.Count; j++)
141 ...{
142 if (i == 0 && j == 1)
143 ...{
144 sql= sqlPrex+"cityID=1";
145
146 }
147 else if (j == 1)
148 ...{
149 sql =sqlPrex+targetDropD.Items[i].Value + " and cityID=1";
150
151 }
152 else if (i == 0)
153 ...{
154 sql = sqlPrex+"townID=" + Convert.ToInt32(townDropD.Items[j-1].Value);
155 }
156 else
157 ...{
158 sql =sqlPrex+targetDropD.Items[i].Value + " and townID=" + Convert.ToInt32(townDropD.Items[j-1].Value);
159 }
160 cmd = new SqlCommand(sql, _utility.Connection);
161 dr[j] = (int)cmd.ExecuteScalar();
162 }
163 generalTb.Rows.Add(dr);
164 }
165 _utility.DBClose();
166 return;
167 }
168
169 #endregion
170
171 # region 查询部分
172
173 //查询模块
174 private string _modeS = "";
175 private string _nameS = "";
176 private string _ageMin="";
177 private string _ageMax="";
178 private string _professionS = "";
179 private string _edgLevelS = "";
180 private string _inMin="", _inMax="";
181 private string _marriageS = "";
182 private string _idFieldS = "";
183 protected void searchButton_Click(object sender, EventArgs e)
184 ...{
185 _modeS = modeDropD.SelectedValue;
186 _nameS = nameTextB.Text;
187 _ageMin = minageTextB.Text;
188 _ageMax = maxTextBox.Text;
189 _professionS = professionTextB.Text;
190 _edgLevelS = edgLevelTextB.Text;
191 _inMin = incomMinextB.Text;
192 _inMax = incomMaxTextB.Text;
193 _marriageS = marriageTextB.Text;
194 _idFieldS = idFieldTextB.Text;
195 string sql;
196 if (_modeS == "精确查询")
197 sql=ExactSearch();
198 else
199 sql=BlurSearch();
200 if (sql == "")
201 Response.Write("<script>alert('请输入关键字！')</script>");
202 else
203 ...{
204 _utility.DBOpen();
205 SqlCommand cmd = new SqlCommand(sql, _utility.Connection);
206 SqlDataAdapter da = new SqlDataAdapter();
207 da.SelectCommand = cmd;
208 da.Fill(_ds, "SearchResult");
209 Session.Add("Set", _ds);
210 Response.Redirect("SrchResult.aspx");
211 }
212 }
213
214 //精确查询
215 private string ExactSearch()
216 ...{
217 string sql;
218 if (_nameS == "" && _ageMin == "" && _professionS == "" &&_edgLevelS == "" && _inMin == "" && _marriageS == "" &&_idFieldS == "" && _edgLevelS == "")
219 ...{
220 sql ="";
221 }
222 else
223 ...{
224 sql = "Select idField as 身份证号码,nameField as 姓名,age as 年龄,profession as 职业,sex as 性别,edgLevel as 最高学历,";
225 sql+="nation as 国家,polity as 政治面貌,marriage as 婚否,incom as 年收入 from tRkry where ";
226 if (_nameS != "")
227 ...{
228 sql+= "namefield='" + _nameS+"'" + " and ";
229 }
230 if (_ageMin != "")
231 ...{
232 sql += "age=" + Convert.ToInt32(_ageMin) + " and ";
233 }
234 if (_professionS != "")
235 ...{
236 sql += "profession='" + _professionS + "'" + " and ";
237 }
238 if (_edgLevelS != "")
239 ...{
240 sql += "edgLevel='" + _edgLevelS + "'" + " and ";
241 }
242 if (_inMin != "")
243 ...{
244 sql += "incom=" + Convert.ToInt32(_inMin) + " and ";
245 }
246 if (_marriageS != "")
247 ...{
248 sql += "marriage='" + _marriageS + "'" + " and ";
249 }
250 if(_idFieldS!="")
251 ...{
252 sql += "idField='" + _idFieldS + "'" + " and ";
253 }
254 sql=sql.Remove(sql.LastIndexOf(" and "));
255 }
256 return sql;
257 }
258 //模糊查询
259 private string BlurSearch()
260 ...{
261 string sql;
262 if (_nameS == "" && _ageMin == "" && _professionS == "" && _edgLevelS == "" && _inMin == "" && _marriageS == "" && _idFieldS == "" && _edgLevelS == "")
263 ...{
264 sql = "Select idField as 身份证号码,nameField as 姓名,age as 年龄,profession as 职业,sex as 性别,edgLevel as 最高学历,";
265 sql += "
