<%@ Page Language="C#" Debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="eMIS" %> <% string wwwroot = Request.ApplicationPath; if (wwwroot == "/") wwwroot = ""; DataManager dm = new DataManager(); string questionId = Request.QueryString["id"].ToString(); DataTable result = dm.Operator.ExecuteTable("select * from wj_ques_result where qid=?", CommandType.Text, questionId); DataTable dt = dm.Operator.ExecuteTable("select * from wj_ques where id=?", CommandType.Text, questionId); int total = int.Parse(dt.Rows[0]["r_number"].ToString()); string totalstr = total.ToString(); if (total == 0) total = 1; dt = dm.Operator.ExecuteTable("select * from wj_ques_items where qid=?", CommandType.Text, questionId); StringBuilder sb = new StringBuilder(); int l = dt.Rows.Count; DataRow[] rows = null; DataRow[] rows6 = null; sb.Append(""); string itemId,itemType; string item6id; int ii,iii; int num; string percent; for (int i = 0; i < l; i++) { itemId = dt.Rows[i]["id"].ToString(); itemType = dt.Rows[i]["itemtype"].ToString(); if (itemType != "3") { sb.Append(""); if (itemType != "6") { sb.Append(""); } else { rows = result.Select("itemid=" + itemId + ""); for (ii = 0; ii < rows.Length; ii++) { item6id = rows[ii]["id"].ToString(); sb.Append(""); sb.Append(""); } } } } sb.Append("
" + (i + 1).ToString() + "" + dt.Rows[i]["title"].ToString() + "
 "); rows = result.Select("itemid=" + itemId + ""); for (ii = 0; ii < rows.Length; ii++) { num = int.Parse(rows[ii]["num"].ToString()); percent = (num / total * 100).ToString(); sb.Append(""); } sb.Append("
" + rows[ii]["title"].ToString() + " ("+num.ToString()+")
" + percent + "%
 " + rows[ii]["title"].ToString() + "
 "); rows6 = result.Select("itemid=" + item6id + ""); for (iii = 0; iii < rows6.Length; iii++) { num = int.Parse(rows6[iii]["num"].ToString()); percent = (num / total * 100).ToString(); sb.Append(""); } sb.Append("
" + rows6[iii]["title"].ToString() + "("+num.ToString()+")
" + percent + "%
"); %> 调查结果
参与人数：<%=totalstr%>
<%=sb.ToString() %>