showresult.aspx.cs

很好的毕业设计拿了可以直接用

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class showResult : System.Web.UI.Page
{
    DB db = new DB();
    protected void Page_Load(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(Request.QueryString["id"].ToString());
        string strresult = "select voteTitle,mode,voteSum from voteMaster where id=" + id;
        SqlDataReader sdr = db.getsdr(strresult);
        sdr.Read();
        int m = sdr.GetInt32(1);
        string t = sdr.GetString(0);
        int s = sdr.GetInt32(2);
        sdr.Close();
        if (m == 0)
        {　
            //单选模式的结果

            Response.Write("&nbsp <BR>&nbsp<BR>&nbsp<BR>&nbsp<BR>&nbsp<BR>" + "<img src='image/bg01.gif'/><BR>" + "总票数<BR>" + "<img src='image/bg01.gif'/><BR>" + t + "&nbsp" + "&nbsp" + "<img src='image/ba.gif' height=20 width=" + 3 * s + "/>" + s + "&nbsp<BR>" + "<a href='index.aspx'>返回</a><BR>" + "<BR> &nbsp<BR>" + "<img src='image/bg01.gif'/><BR>");
        
        
        }
        if (m == 1)
        { 　
            //多选模式的结果
            Response.Write("&nbsp <BR>&nbsp<BR>" + "<img src='image/bg01.gif'/><BR>" + "总票数<BR>" + "<img src='image/bg01.gif'/><BR>" + t + "&nbsp" + "&nbsp" + "<img src='image/ba.gif' height=20 width=" + 3 * s + "/>" + s + "<BR> &nbsp<BR>" + "<img src='image/bg01.gif'/><BR>");
            Response.Write("该标题对应选项的票数:<BR>"+"<img src='image/bg01.gif'/><BR>"+"&nbsp<BR>");

            SqlDataReader sdrIn =db.getsdr("select voteItem,voteNum from voetDetails where id =" + id);

            int first = 0;
            while (sdrIn.Read())
            {
                int n = sdrIn.GetInt32(1);
                string i = sdrIn.GetString(0);
                first += 1;
                Response.Write("&nbsp" + first + "&nbsp" + i + "<img src='image/ba.gif' height=20 width=" + 3 * n + "/>" + n + "&nbsp<BR>" + "<img src='image/bg01.gif'/><BR>");
            }
            if (!sdrIn.IsClosed)
                sdrIn.Close();
            Response.Write("<a href='index.aspx'>返回</a>");
            

           /* if (sdrOut.IsClosed)
            {
                sdrOut = DBManager.getSdr("select id,voteTitle from voteMaster");
                for (int inNum = 0; inNum < flag; inNum++)
                {
                    sdrOut.Read();
                }
            }
            */
        }
        //sdrOut.Close();
        db.clear();

    }
        
           
        
   }