private string BindQuizable(string testid)
{
//string htmltext = ChecekMode?"<table class=\"History_Quiz_tabel\">":"<table class=\"Quiz_table\">";
string htmltext = "";
DataSet Ds = new DataSet();
string SelectCmd_Q = "Select TTRelationship.RelationshipID,Topic.TopicID,Topic.TopicContent,Topic.HaveContent,Topic.MoreContent From TTRelationship inner join Topic on TTRelationship.TopicID=Topic.TopicID where TTRelationship.TestID=" + testid;
using (MySqlConnection Sc = new MySqlConnection(Diya.ConectionString))
{
Sc.Open(); MySqlDataAdapter Da = new MySqlDataAdapter(SelectCmd_Q, Sc);
Da.Fill(Ds);
}
int TestCount = 0;
DataTable Dt = Ds.Tables[0];
using (MySqlDataReader read = new Diya().RowReader("select TestCount from TestInfo where TestID=" + testid))
{
if (read.Read())
{
TestCount = read.GetInt32(0);
}
else
{
TestCount = 0;
}
read.Close();
}
for (int i = 0; i < TestCount; i++)
{
htmltext = "<tr class=\"item_Quiz\"><td style=\text-align:left\"><label>" + (i + 1) + " ." + Dt.Rows[i]["TopicContent"] + "</label></td></tr>";
DataSet Dso = new DataSet();
using (MySqlConnection Sc = new MySqlConnection(Diya.ConectionString))
{
Sc.Open(); MySqlDataAdapter da = new MySqlDataAdapter("Select Options.OptionID,Options.OptionContent From Options inner join OTRelationship on OTRelationship.OptionID=Options.OptionID Where OTRelationship.TTRelationshipID=" + Dt.Rows[i]["RelationshipID"].ToString(), Sc);
da.Fill(Dso);
}
DataTable Options = Dso.Tables[0];
for (int j = 0; j < Options.Rows.Count; j++)
{
htmltext += "<tr style=\"height:2%\"><td> </td></tr>";
htmltext += "<tr><td><div class=\"item_Options\"> title=\"\" id=\"" + Options.Rows[j]["OptionID"] + "n\"><input type=\"checkbox\" runat=\"server\" id=\"" + Options.Rows[j]["OptionID"] + "\" onserverchange=\"test_ServerChange\" disabled=\"disabled\" style=\"border:1px solid Black\">" + Convert.ToChar(65 + j) + ". " + Options.Rows[j]["OptionContent"] + "</div></td></tr>";
if (j == Options.Rows.Count - 1)
{
htmltext += "<tr style=\"height:5%\"><td> </td></tr>";
}
}
Dst.Addstate(htmltext);
}
return(htmltext);
}
protected void ChecekChanged(object sender, EventArgs e)
{
CheckBox checkbox = sender as CheckBox;
if (checkbox.Checked)
{
string id = checkbox.Text;
Dst_id.Addstate(id);
}
else
{
Dst_id.DeleteOneData(checkbox.Text);
}
}
public void BindQuizes(string TestID)
{
indexList.Columns.Add("Index");
dt.Columns.Add("TopicID");
dt.Columns.Add("OptionID");
dt.Columns.Add("Selected");
dt.Columns.Add("Index");
dt.Columns["Index"].DefaultValue = 0;
dt.Columns["Selected"].DefaultValue = 0;
string SelectCmd = "Select TTRelationship.RelationshipID,Topic.TopicID,Topic.TopicContent,Topic.HaveContent,Topic.MoreContent From TTRelationship inner join Topic on TTRelationship.TopicID=Topic.TopicID where TTRelationship.TestID=" + TestID;
char OptionC = Convert.ToChar(20);
char TopicC = Convert.ToChar(17);
char OPidC = Convert.ToChar(19);
char Op = Convert.ToChar(21);
char TopicIDc = Convert.ToChar(18);
string buf = "";
using (MySqlConnection Sc = new MySqlConnection(Diya.ConectionString))
{
Sc.Open();
DataSet Ds = new DataSet();
MySqlDataAdapter Da = new MySqlDataAdapter(SelectCmd, Sc);
Da.Fill(Ds);
int index = 0;
foreach (DataRow Dr in Ds.Tables[0].Rows) //获取所有题目
{
//QuizCount++;
buf += UpdateEnter(Dr["TopicContent"].ToString());
if (Dr["HaveContent"].ToString() == "1")
{
buf += UpdateEnter("\n" + Dr["MoreContent"].ToString());
}
buf += TopicIDc;
buf += Dr["TopicID"].ToString();
buf += OptionC;
using (MySqlConnection Scq = new MySqlConnection(Diya.ConectionString))
{
Scq.Open();
MySqlCommand Scmd1 = new MySqlCommand("Select Options.OptionID,Options.OptionContent From Options inner join OTRelationship on OTRelationship.OptionID=Options.OptionID Where OTRelationship.TTRelationshipID=" + Dr["RelationshipID"].ToString(), Scq);//选项查询
MySqlDataReader read2 = Scmd1.ExecuteReader();
indexList.Rows.Add(indexList.NewRow());
indexList.Rows[indexList.Rows.Count - 1][0] = index;
while (read2.Read())//选项
{
buf += UpdateEnter(read2["OptionID"].ToString() + Convert.ToChar(19) + read2["OptionContent"].ToString() + Convert.ToChar(21));
dt.Rows.Add(dt.NewRow());
dt.Rows[dt.Rows.Count - 1]["TopicID"] = Dr["TopicID"];
dt.Rows[dt.Rows.Count - 1]["OptionID"] = read2["OptionID"];
index++;
}
buf += TopicC;
}
}
string[] Topics = buf.Split(new char[] { Convert.ToChar(17) });
//int[] TopicsIndex = new int[Topics.Length-1];
//for (int i = 0; i < TopicsIndex.Length; i++) //随机
//{
// Random r = new Random();
// TopicsIndex[i] = r.Next(0, Topics.Length-1);
// for (int j = 0; j <= i - 1; j++)
// {
// if (TopicsIndex[i] == TopicsIndex[j])
// {
// TopicsIndex[i] = r.Next(0, Topics.Length-1);
// j = -1;
// }
// }
//}
//开始写页面
int TestCount;
using (MySqlConnection inSc = new MySqlConnection(Diya.ConectionString))
{
inSc.Open();
MySqlCommand Scmd = new MySqlCommand("select TestCount from TestInfo where TestID=" + TestID, inSc);
MySqlDataReader read = Scmd.ExecuteReader();
if (read.Read())
{
TestCount = read.GetInt32(0);
}
else
{
TestCount = 0;
}
QuizCount = TestCount;
}
if (TestCount > Topics.Length - 1)
{
TestCount = Topics.Length - 1;
}
for (int i = 0; i < TestCount; i++)
{
string Quizes = "";
//string[] Topic = Topics[TopicsIndex[i]].Split(new char[] { Convert.ToChar(20) });
string[] Topic = Topics[i].Split(new char[] { Convert.ToChar(20) });
string TopicID = Topic[0].Split(new char[] { Convert.ToChar(18) })[1];
string _Topic = Topic[0].Split(new char[] { Convert.ToChar(18) })[0];
Quizes += "<tr class=\"item_Quiz\"><td style=\"text-align:left\"><label>" + (i + 1) + " ." + _Topic + "</label></td></tr>"; //题目
string[] Options = Topic[1].Split(new char[] { Convert.ToChar(21) });
int[] OptionsIndex = new int[Options.Length - 1];
//RandomArray(OptionsIndex);//随机
for (int j = 0; j < Options.Length - 1; j++)
{
//string[] idorop = Options[OptionsIndex[j]].Split(new char[] { Convert.ToChar(19) });//随机
string[] idorop = Options[j].Split(new char[] { Convert.ToChar(19) });
Quizes += "<tr style=\"height:2%\"><td> </td></tr>";
if (j != Options.Length - 2)
{
Quizes += "<tr> <td ><div class=\"item_Options\" title=\"\" onclick=\"Getid(" + idorop[0] + "," + TopicID + ")\" id=\"" + idorop[0] + "n\" ><input type=\"checkbox\" runat=\"server\" id=\"" + idorop[0] + "\" onchange=\"test_ServerChange(this)\" >" + Convert.ToChar(65 + j) + ". " + idorop[1] + "</div></td></tr>";
}
else
{
Quizes += "<tr> <td ><div class=\"item_Options\" title=\"\" onclick=\"Getid(" + idorop[0] + "," + TopicID + ")\" id=\"" + idorop[0] + "n\" ><input type=\"checkbox\" runat=\"server\" id=\"" + idorop[0] + "\" onchange=\"test_ServerChange(this)\">" + Convert.ToChar(65 + j) + ". " + idorop[1] + "</div></td></tr>";
Quizes += "<tr style=\"height:5%\"><td> </td></tr>";
}
}
Dst.Addstate(Quizes);
}
}
buf = "";
}
