当前文件路径：ComplexVote/voteadmin.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 vote
13
...{
14
/**//// <summary>
15
/// voteadmin 的摘要说明。
16
/// </summary>
17 public partial class voteadmin : System.Web.UI.Page
18 ...{
19
20 private void fill()
21 ...{
22 string query="select * from votemaster";
23 this.DataGrid1.DataSource=db.fill(query);
24 this.DataGrid1.DataKeyField="id";
25 this.DataGrid1.DataBind();
26 }
27 protected void Page_Load(object sender, System.EventArgs e)
28 ...{
29 // 在此处放置用户代码以初始化页面
30
31 if(!Page.IsPostBack)
32 ...{
33 //下面的判断也可以使用Server.Execute("clog.aspx");代替,自己没事瞎琢磨去吧,什么东西都是自己慢慢摸索的
34 if(Session["flag"]==null||Session["qx"].ToString()!="管理员"||Session["flag"].ToString()!="true")//如果session等于空，或者其值不为 ＴＲＵＥ，都是不对的！
35 ...{
36 if(Session["qx"].ToString()=="VIP用户")
37 ...{
38 Response.Redirect("login.aspx");//不说也知道这是返回登录页啦
39 }
40 if(Session["qx"].ToString()=="注册用户")
41 ...{
42 Response.Redirect("login.aspx");//不说也知道这是返回登录页啦
43 }
44 if(Session["qx"].ToString()=="普通用户")
45 ...{
46 Response.Redirect("login.aspx");//不说也知道这是返回登录页啦
47 }
48 }
49 else
50 ...{
51 LinkButton1.Text="退出管理";
52 }
53 this.Label3.Text=Application["line"].ToString();//当前再线人数
54 this.Label4.Text=db.count();//总访问人数
55 this.fill();
56 }
57 }
58
59 Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
60 override protected void OnInit(EventArgs e)
61 ...{
62 //
63 // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
64 //
65 InitializeComponent();
66 base.OnInit(e);
67 }
68
69 /**//// <summary>
70 /// 设计器支持所需的方法 - 不要使用代码编辑器修改
71 /// 此方法的内容。
72 /// </summary>
73 private void InitializeComponent()
74 ...{
75 this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
76 this.DataGrid1.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_CancelCommand);
77 this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
78 this.DataGrid1.SortCommand += new System.Web.UI.WebControls.DataGridSortCommandEventHandler(this.DataGrid1_SortCommand);
79 this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
80 this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
81 this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
82
83 }
84 #endregion
85
86 private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
87 ...{//取消编辑
88 this.DataGrid1.EditItemIndex=-1;
89 this.fill();
90 }
91
92 private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
93 ...{//删除操作
94 string id=this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
95 db.delete("delete from votemaster where id="+id+"");
96 this.fill();
97 }
98
99 private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
100 ...{//鼠标动作
101 if(e.Item.ItemType==ListItemType.AlternatingItem||e.Item.ItemType==ListItemType.Item)
102 ...{
103 e.Item.Attributes.Add("onmouseover","c=this.style.backgroundColor;this.style.backgroundColor='#ff9900'");
104 e.Item.Attributes.Add("onmouseout","this.style.backgroundColor=c;");
105 ((LinkButton)(e.Item.Cells[8].Controls[0])).Attributes.Add("onclick","return confirm('确认删除？')");
106 }
107 }
108
109 private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
110 ...{//选中被编辑行
111 this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
112 this.fill();
113 }
114
115 private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
116 ...{//翻页设置
117 this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
118 this.fill();
119 }
120
121 private void DataGrid1_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
122 ...{//排序操作
123 if(ViewState["Order"]==null)
124 ...{
125 ViewState["Order"]="DESC";
126 }
127 else
128 ...{
129 if(ViewState["Order"].ToString()=="DESC")
130 ...{
131 ViewState["Order"]="ASC";
132 }
133 else
134 ...{
135 ViewState["Order"]="DESC";
136 }
137 }
138 SqlConnection con=db.con();
139 SqlDataAdapter sda=new SqlDataAdapter();
140 sda.SelectCommand=new SqlCommand("Select * from votemaster",con);
141 DataSet ds=new DataSet();
142 sda.Fill(ds,"vote");
143 ds.Tables["vote"].DefaultView.Sort=e.SortExpression+" "+ViewState["Order"].ToString();
144 this.DataGrid1.DataSource=ds.Tables["vote"].DefaultView;
145 this.DataGrid1.DataBind();
146 }
147
148 private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
149 ...{//更新操作
150 string id=this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
151 string xiang=((TextBox)(e.Item.Cells[1].Controls[0])).Text.ToString();
152 int typ=Convert.ToInt32(((TextBox)(e.Item.Cells[3]).Controls[1]).Text);
153 int jgdt=Convert.ToInt32(((TextBox)(e.Item.Cells[4]).Controls[1]).Text);
154 DateTime dt=DateTime.Now;
155 string query="update votemaster set xiang='"+xiang+"',typ="+typ+",jgdt='"+jgdt+"',dt='"+dt+"' where id='"+id+"'";
156 db.update(query);
157 this.DataGrid1.EditItemIndex=-1;
158 this.fill();
159 }
160
161 protected void Button1_Click(object sender, System.EventArgs e)
162 ...{
163 if(this.IsValid)
164 ...{
165 int id=db.cid("select id from votemaster order by id desc")+1;//因为数据库没有把这个字段设置为自增，所以我们取出他现在的，再给他加１，确保ＩＤ不会重复
166 DateTime dt=DateTime.Now;
167 string xiang=this.votename.Text.ToString();
168 int type=Convert.ToInt32(this.type.SelectedValue);
169 int jgdt=Convert.ToInt32(this.jtime.Text);
170 if(db.insert("insert into votemaster values("+id+",'"+xiang+"','"+type+"',0,null,'"+dt+"','"+jgdt+"')"))
171 ...{
172 this.Label2.Text="插入成功";
173 this.fill();
174 }
175 else
176 ...{
177 this.Label2.Text="插入失败";
178 }
179 }
180 }
181
182 protected void LinkButton1_Click(object sender, System.EventArgs e)
183 ...{
184 Session["flag"]="false";
185 Session.Clear();
186 Session.Abandon();
187 Response.Redirect("login.aspx");
188 }
189 }
190
}
191
打包下载该项目完整源码：Asp.net投票系统[单/复选,投票数量/项随意]源码
