Разработка подсистемы подготовки адаптивного тестирования в открытой системе дистанционного образования
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
t DSet;DataSet DSVopros;DataRow row;Rand = 0;schet = 0;id_vopr;id_test;lastindx = 0;position = 0;MaxPosition = 0;[] array;[] array3;[] array4;[] array5;void toolStripMenuItem1_Click (object sender, EventArgs e)
{DeletControls();
.groupBox1. Visible = true;.groupBox2. Visible = false;}void toolStripMenuItem2_Click (object sender, EventArgs e)
{if (comboBox3. Text!= ) {
// End = 0;
// position = 0;
//StartTest();. Text = ;
();. Text = ;. SelectedValue = ;
//AddControlsForQuestions();
//BindQuestion();}.groupBox2. Visible = true;.groupBox1. Visible = false;}void DGVBinding()
{try
{if (comboBox2. Items. Count > 0)
{OleDbConnection thisConnection = new OleDbConnection (ConStr. GetConString());. Open();query0 = Select id_test From Test Where (test = @test);cmd0 = new OleDbCommand (query0, thisConnection);. Parameters. AddWithValue (@test, comboBox2. SelectedItem. ToString());thisReader = cmd0. ExecuteReader();(thisReader. Read())
{id_test = thisReader. GetValue(0).ToString();}. Close();query = Select id_vopr, vopr, lev From Vopros Where (id_test = @id_test);
OleDbCommand cmd = new OleDbCommand (query, thisConnection);
cmd. Parameters. AddWithValue (@id_test, id_test);= new OleDbDataAdapter(cmd);= new DataSet();. Fill (DSet, Vopros);. DataSource = DSet. Tables [Vopros];. Close();_test = ;}
{dataGridView1. DataSource = null;. Text = ;}}{
}}void AddValue()
{label1. Text = ;. Items. Clear();num = 0;cnt = count + 1;(int i = 0; i < k; i++)
{if ((groupBox1. Controls [count + num] as TextBox).Text!= )
{check = true;}
{check = false;;}((groupBox1. Controls [cnt + num] as CheckBox).Checked)
{ck = true;}+= 2;}= 0;(textBox1. Text!= && textBox2. Text!= && check == true && ck == true)
{lastindx = 0;
{OleDbConnection thisConnection = new OleDbConnection (ConStr. GetConString());. Open();
(string list in comboBox2. Items)
{if (list == textBox2. Text)
{chkTest = true;;}
{lastindx++;= false;}
}(chkTest == false)
{string qr = INSERT INTO Test (test) VALUES (@test);com = new OleDbCommand (qr, thisConnection);. Parameters. AddWithValue (@test, textBox2. Text);. ExecuteNonQuery();}qr1 = Select id_test From Test Where (test = @test);com1 = new OleDbCommand (qr1, thisConnection);. Parameters. AddWithValue (@test, textBox2. Text);thisRed1 = com1. ExecuteReader();(thisRed1. Read())
{_test = thisRed1. GetValue(0).ToString();} thisRed1. Close();
query = INSERT INTO Vopros (Vopr, id_test, lev) VALUES (@Vopr, @id_test, @lev);cmd = new OleDbCommand (query, thisConnection);. Parameters. AddWithValue (@Vopr, textBox1. Text);. Parameters. AddWithValue (@id_test, id_test);. Parameters. AddWithValue (@lev, comboBox5. SelectedItem. ToString());. ExecuteNonQuery();query1 = Select id_vopr From Vopros Where (id_test = @id_test);cmd1 = new OleDbCommand (query1, thisConnection);. Parameters. AddWithValue (@id_test, id_test);thisReader1 = cmd1. ExecuteReader();(thisReader1. Read())
{id_vopr = thisReader1. GetValue(0).ToString();}. Close();(int i = 0; i < k; i++)
{string query2 = INSERT INTO Otvet (id_vopr, id_test, otv) VALUES (@id_vopr, @id_test, @otv);cmd2 = new OleDbCommand (query2, thisConnection);. Parameters. AddWithValue (@id_vopr, id_vopr);. Parameters. AddWithValue (@id_test, id_test);. Parameters. AddWithValue (@otv, (groupBox1. Controls [count + num] as TextBox).Text);+= 2;. ExecuteNonQuery();
}= 0;(int i = 0; i < k; i++)
{((groupBox1. Controls [cnt + num] as CheckBox).Checked == true)
{string query3 = SELECT id_otv FROM Otvet WHERE (id_vopr = @id_vopr AND id_test = @id_test AND otv = @otv);
cmd3 = new OleDbCommand (query3, thisConnection);. Parameters. AddWithValue (@id_vopr, id_vopr);. Parameters. AddWithValue (@id_test, id_test);. Parameters. AddWithValue (@otv, groupBox1. Controls [count + num].Text);thisReader3 = cmd3. ExecuteReader();(thisReader3. Read())
{comboBox1. Items. Add (thisReader3. GetValue(0).ToString());
}. Close();
}+= 2;
}(string LI in comboBox1. Items)
{query4 = INSERT INTO Rez (id_vopr, id_otv, id_test) VALUES (@id_vopr, @id_otv, @id_test);cmd4 = new OleDbCommand (query4, thisConnection);. Parameters. AddWithValue (@id_vopr, id_vopr);. Parameters. AddWithValue (id_otv, LI. ToString());. Parameters. AddWithValue (@id_test, id_test);. ExecuteNonQuery();
}. Close();= 0;();
}
{
}= false;= false;
}
{. Text = Вы заполнили не все поля!!!;
}
}void DeletControls()
{. Text = ;kv = groupBox1. Controls. Count - 1;(groupBox1. Controls. Count > count)
{groupBox1. Controls. RemoveAt(kv);-;
}= 0;= 10;= 225;(int i = 0; i < 2; i++)
{AddControls();}}void AddControls()
{if (Y + 100 <= this. Size. Height)
{tx = new TextBox();. Width = 930;. Multiline = true;. Height = 50;. Location = new Point (X, Y);. Name = tx + this.groupBox1. Controls. Count. ToString();. MaxLength = 255;
= new CheckBox();. Location = new Point (X + 960, Y + 10);. Name = cb + this.groupBox1. Controls. Count. ToString();.groupBox1. Controls. Add(tx);.groupBox1. Controls. Add(cb);+= 60;++;}}void button3_Click (object sender, EventArgs e)
{AddControls();}void button4_Click (object sender, EventArgs e)
{if (count + 4 <= this.groupBox1. Controls. Count - 1)
{this.groupBox1. Controls. RemoveAt (this.groupBox1. Controls. Count - 1);.groupBox1. Controls. RemoveAt (this.groupBox1. Controls. Count - 1);-= 60;;}}void Form1_Load (object sender, EventArgs e)
0)">{. SelectedIndex = 0;= this.groupBox1. Controls. Count;();(comboBox2. Items. Count > 0)
{textBox2. Text = comboBox2. SelectedItem. ToString();}(int i = 0; i < 2; i++)
{AddControls();}();}void BindTests()
{comboBox2. Items. Clear();. Items. Clear();. Text = ;thisConnection = new OleDbConnection (ConStr. GetConString());. Open();query = Select test From Test;cmd = new OleDbCommand (query, thisConnection);thisReader = cmd. ExecuteReader();(thisReader. Read())
{comboBox2. Items. Add (thisReader. GetValue(0).ToString());. Items. Add (thisReader. GetValue(0).ToString());}. Close();. Close();(comboBox2. Items. Count > 0)
{try
{comboBox2. SelectedIndex = lastindx;}
{
}
}
}void groupBox1_Enter (object sender, EventArgs e)
{
}void button5_Click (object sender, EventArgs e)
{= false;();();();
}void dataGridView1_UserDeletingRow (object sender, DataGridViewRowCancelEventArgs e)
{try
{thisConnection = new OleDbConnection (ConStr. GetConString());. Open();query = Delete From Vopros Where (id_vopr = @id_vopr);cmd = new OleDbCommand (query, thisConnection);. Parameters. AddWithValue (@id_vopr, dataGridView1. Rows[index].Cells[0].Value. ToString());. ExecuteNonQuery();. Close();
}
{
}
}void dataGridView1_RowEnter (object sender, DataGridViewCellEventArgs e)
{index = e. RowIndex;}void dataGridView1_ColumnAdded (object sender, DataGridViewColumnEventArgs e)
{if (e. Column. Name == id_vopr)
{e. Column. Visible = false;}(e. Column. Name == vopr)
{e. Column. HeaderText = ВОПРОСЫ:;. Column. MinimumWidth = 850;}(e. Column. Name == lev)
{e. Column. HeaderText = СЛОЖНОСТЬ:;}}void comboBox2_SelectedIndexChanged (object sender, EventArgs e)
{textBox2. Text = comboBox2. SelectedItem. ToString();= comboBox2. SelectedIndex;();}void button1_Click (object sender, EventArgs e)
{try
{(click == false && comboBox2. Text!= )
{MessageBox. Show (Повторное нажатие клавиши приведет к удалению выбранного вами теста!!!);= true;
}
{(click == true)
{OleDbConnection thisConnection = new OleDbConnection (ConStr. GetConString());. Open();query = Delete From Test Where (test = @test);cmd = new OleDbCommand (query, thisConnection);. Parameters. AddWithValue (@test, comboBox2. SelectedItem. ToString());. ExecuteNonQuery();. Close();. Text = ;();();= false;
}
}
}
{
}
}
void StartTest()
{
{thisConnection = new OleDbConnection (ConStr. GetConString());. Open();qr1 = Select id_test From Test Where (test = @test);com1 = new OleDbCommand (qr1, thisConnection);. Parameters. AddWithValue (@test, comboBox3. SelectedItem. ToString());thisRed1 = com1. ExecuteReader();(thisRed1. Read())
{id_test = thisRed1. GetValue(0).ToString();}. Close();query = Select id_vopr, vopr From Vopros Where (id_test = @id_test);cmd = new OleDbCommand (query, thisConnection);. Parameters. AddWithValue (@id_test, id_test);AdapterForVopros = new OleDbDataAdapter(cmd);= new DataSet();. Fill (DSVopros, Vopros);. Close();= 0;(DataRow rw in DSVop