1using 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;
12using System.Text;
13
14public partial class Controls_LeftTem : System.Web.UI.UserControl
15...{
16    protected void Page_Load(object sender, EventArgs e)
17    ...{
18        if (!Page.IsPostBack) ...{
19
20            BindBinessAffiche();
21            BindFavourableInfo();
22            BindVote();
23        
24        }
25    }
26    protected void BindBinessAffiche() ...{
27
28        StringBuilder builder = new StringBuilder();
29        builder.Append("<ul>");
30        SqlDataReader dr = SqlHelper.ExcuteRead("SELECT TOP 10 Id,Name FROM [New] WHERE Types=0 AND Vis=1", CommandType.Text, null);
31        while (dr.Read()) ...{
32
33            builder.Append("<li><a href=\"gonggaoweiye.aspx?Id=" + dr["Id"].ToString() + "\">" + SubName(dr["Name"].ToString()) + "</a></li>");
34        
35        }
36        builder.Append("</ul>");
37        BinessAffiche.InnerHtml = builder.ToString();
38        dr.Close();
39    
40    }
41    protected void BindFavourableInfo()
42    ...{
43
44        StringBuilder builder = new StringBuilder();
45        builder.Append("<ul>");
46        SqlDataReader dr = SqlHelper.ExcuteRead("SELECT TOP 10 Id,Name FROM [New] WHERE Types=1 AND Vis=1", CommandType.Text, null);
47        while (dr.Read())
48        ...{
49
50            builder.Append("<li><a href=\"gonggaoweiye.aspx?Id=" + dr["Id"].ToString() + "\">" + SubName(dr["Name"].ToString()) + "</a></li>");
51
52        }
53        builder.Append("</ul>");
54        FavourableInfo.InnerHtml = builder.ToString();
55        dr.Close();
56
57    }
58    protected void BindVote() ...{
59
60        RadioVote.DataSource = SqlHelper.ExcuteRead("SelectVote", CommandType.StoredProcedure, null);
61        RadioVote.DataTextField = "Name";
62        RadioVote.DataValueField = "Id";
63        RadioVote.DataBind();
64
65    
66    }
67    protected string SubName(string inputName) ...{
68
69        string txtName = string.Empty;
70        if (inputName.Length < 14)
71        ...{
72
73            txtName = inputName;
74
75        }
76        else ...{
77
78            txtName = inputName.Substring(0, 14);
79        
80        }
81        return txtName;
82    }
83
84    protected void ButtonVote_Click(object sender, EventArgs e)
85    ...{
86        SqlParameter[] paras =...{ new SqlParameter("@Id", SqlDbType.Int, 4) };
87        paras[0].Value = int.Parse(RadioVote.SelectedValue.ToString());
88        SqlHelper.ExcuteNonQurey("UserVote", CommandType.StoredProcedure, paras);
89        Response.Write("<script>alert('投票成功')</script>");
90        Response.Redirect("Default.aspx");
91        
92    }
93}
94