62,242
社区成员




<script type="text/javascript" src="Javascript/FusionCharts.js"></script>
<asp:Label ID="Label2" runat="server" Text=""></asp:Label>
using InfoSoftGlobal;
Label2.Text = CreatChart();
public string CreatChart()
{
string strXML;
strXML = "";
string T = "";
string Charts = "";
if (DropDownList1.SelectedValue == "1" || DropDownList1.SelectedValue == "10")
{
string SelectAll = string.Format("select * from qa2012");
strXML += "<graph caption='" + this.DropDownList1.SelectedItem.Text + "' xAxisName='选项' yAxisName='数目(总数:" + cs.ReturnDataSet(SelectAll).Tables[0].Rows.Count + ")' BaseFontSize='17' decimalPrecision='0' formatNumberScale='0'>";
if (DropDownList1.SelectedValue == "1")
{
for (int i = 0; i < 11; i++)
{
char A = 'A';
int S = Convert.ToInt32(A) + i;
T = Convert.ToChar(S).ToString();
string Sql = string.Format("SELECT * FROM QA2012 WHERE {0} LIKE '%{1}%'", "a" + DropDownList1.SelectedValue.ToString(), T.ToString());
string Result = string.Format("<set name='{0}' value='{1}'/>", T, cs.ReturnDataSet(Sql).Tables[0].Rows.Count);
strXML += Result;
}
strXML += "</graph>";
Charts = FusionCharts.RenderChart("FusionCharts/Column3D.swf", "", strXML, "My", "700", "433", false, false);
}
else
{
for (int i = 0; i < 4; i++)
{
char A = 'A';
int S = Convert.ToInt32(A) + i;
T = Convert.ToChar(S).ToString();
string Sql = string.Format("SELECT * FROM QA2012 WHERE {0} LIKE '%{1}%'", "a" + DropDownList1.SelectedValue.ToString(), T.ToString());
string Result = string.Format("<set name='{0}' value='{1}'/>", T, cs.ReturnDataSet(Sql).Tables[0].Rows.Count);
strXML += Result;
}
strXML += "</graph>";
Charts = FusionCharts.RenderChart("FusionCharts/Column3D.swf", "", strXML, "My", "700", "433", false, false);
}
}
else
{
string SelectAll = string.Format("select * from qa2012");
strXML += "<graph caption='" + this.DropDownList1.SelectedItem.Text + "' xAxisName='选项' yAxisName='数目(总数:" + cs.ReturnDataSet(SelectAll).Tables[0].Rows.Count + ")' BaseFontSize='17' decimalPrecision='0' formatNumberScale='0'>";
if (DropDownList1.SelectedValue == "2" || DropDownList1.SelectedValue == "3")
{
for (int i = 0; i < 5; i++)
{
char A = 'A';
int S = Convert.ToInt32(A) + i;
T = Convert.ToChar(S).ToString();
string Sql = string.Format("SELECT * FROM QA2012 WHERE {0} LIKE '%{1}%'", "a" + DropDownList1.SelectedValue.ToString(), T.ToString());
string Result = string.Format("<set name='{0}' value='{1}'/>", T, cs.ReturnDataSet(Sql).Tables[0].Rows.Count);
strXML += Result;
}
strXML += "</graph>";
Charts = FusionCharts.RenderChart("FusionCharts/Pie3D.swf", "", strXML, "My", "700", "433", false, false);
}
else if (DropDownList1.SelectedValue == "4")
{
for (int i = 0; i < 3; i++)
{
char A = 'A';
int S = Convert.ToInt32(A) + i;
T = Convert.ToChar(S).ToString();
string Sql = string.Format("SELECT * FROM QA2012 WHERE {0} LIKE '%{1}%'", "a" + DropDownList1.SelectedValue.ToString(), T.ToString());
string Result = string.Format("<set name='{0}' value='{1}'/>", T, cs.ReturnDataSet(Sql).Tables[0].Rows.Count);
strXML += Result;
}
strXML += "</graph>";
Charts = FusionCharts.RenderChart("FusionCharts/Pie3D.swf", "", strXML, "My", "700", "433", false, false);
}
else if (DropDownList1.SelectedValue == "20")
{
for (int i = 0; i < 2; i++)
{
char A = 'A';
int S = Convert.ToInt32(A) + i;
T = Convert.ToChar(S).ToString();
string Sql = string.Format("SELECT * FROM QA2012 WHERE {0} LIKE '%{1}%'", "a" + DropDownList1.SelectedValue.ToString(), T.ToString());
string Result = string.Format("<set name='{0}' value='{1}'/>", T, cs.ReturnDataSet(Sql).Tables[0].Rows.Count);
strXML += Result;
}
strXML += "</graph>";
Charts = FusionCharts.RenderChart("FusionCharts/Pie3D.swf", "", strXML, "My", "700", "433", false, false);
}
else
{
if (DropDownList1.SelectedValue.ToString() != "26")
{
for (int i = 0; i < 4; i++)
{
char A = 'A';
int S = Convert.ToInt32(A) + i;
T = Convert.ToChar(S).ToString();
string Sql = string.Format("SELECT * FROM QA2012 WHERE {0} LIKE '%{1}%'", "a" + DropDownList1.SelectedValue.ToString(), T.ToString());
string Result = string.Format("<set name='{0}' value='{1}'/>", T, cs.ReturnDataSet(Sql).Tables[0].Rows.Count);
strXML += Result;
}
strXML += "</graph>";
Charts = FusionCharts.RenderChart("FusionCharts/Pie3D.swf", "", strXML, "My", "700", "433", false, false);
}
}
}
return Charts;
}