public void loadQuestionL2()
{
string sql_str = @"
SELECT q2_id, q2_text, q2_order, stratrisk_id, q1_id, tm_id
FROM question2
WHERE (q1_id = @q1_id)
ORDER BY q2_order
";
SqlCommand cmd = new SqlCommand(sql_str);
cmd.Parameters.AddWithValue("@q1_id", q1_id);
DataSet ds = DBHelper.getDataSet(cmd);
qL2_list = new List <questionL2>();
try
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
questionL2 q2 = new questionL2();
q2.q2_id = ds.Tables[0].Rows[i]["q2_id"].ToString();
q2.q2_text = ds.Tables[0].Rows[i]["q2_text"].ToString();
q2.q2_order = ds.Tables[0].Rows[i]["q2_order"].ToString();
q2.stratrisk_id = ds.Tables[0].Rows[i]["stratrisk_id"].ToString();
q2.q1_id = ds.Tables[0].Rows[i]["q1_id"].ToString();
q2.tm_id = ds.Tables[0].Rows[i]["tm_id"].ToString();
qL2_list.Insert(i, q2);
}
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region loadData
qset.qset_id = "2";
qset.loadQuestionSet();
qset.loadQuestionL1();
lbl_qset_text.Text = qset.qset_text;
for (int q1_i = 0; q1_i < qset.qL1_list.Count; q1_i++)
{
question q1 = qset.qL1_list[q1_i];
q1.loadQuestionL2();
for (int q2_i = 0; q2_i < q1.qL2_list.Count; q2_i++)
{
questionL2 q2 = q1.qL2_list[q2_i];
q2.loadQuestionL3();
}
}
#endregion
#region MapQuestion to Interface
//--------------ประเด็น3---------------------------
lblQuestion_1.Text = qset.qL1_list[0].q1_text;
lblAssumption_1.Text = qset.qL1_list[0].q1_assumption;
lblQuestion_id_1.Text = qset.qL1_list[0].q1_id;
lblQuestion_id_praden_1.Text = lblQuestion_id_1.Text;
//---------------คำถาม----------------------------
lblQuestion2_1.Text = Q2Seq + qset.qL1_list[0].qL2_list[0].q2_order + " " + qset.qL1_list[0].qL2_list[0].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_1_1.Text = qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_text;
lblQuestion3_1_2.Text = qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_text;
lblQuestion3_1_3.Text = qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_2.Text = Q2Seq + qset.qL1_list[0].qL2_list[1].q2_order + " " + qset.qL1_list[0].qL2_list[1].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_2_1.Text = qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_3.Text = Q2Seq + qset.qL1_list[0].qL2_list[2].q2_order + " " + qset.qL1_list[0].qL2_list[2].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_3_1.Text = qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_4.Text = Q2Seq + qset.qL1_list[0].qL2_list[3].q2_order + " " + qset.qL1_list[0].qL2_list[3].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_4_1.Text = qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_text;
lblQuestion3_4_2.Text = qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_text;
lblQuestion3_4_3.Text = qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_text;
lblQuestion3_4_4.Text = qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_text;
//-----------จบ ประเด็น3--------------------------------
//--------------ประเด็น4---------------------------
lblQuestion_2.Text = qset.qL1_list[1].q1_text;
lblAssumption_2.Text = qset.qL1_list[1].q1_assumption;
lblQuestion_id_2.Text = qset.qL1_list[1].q1_id;
lblQuestion_id_praden_2.Text = lblQuestion_id_2.Text;
lblQuestion2_5_1.Text = Q2Seq + qset.qL1_list[1].qL2_list[0].q2_order + " " + qset.qL1_list[1].qL2_list[0].q2_text;
lblQuestion3_4_1_1.Text = qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_text;
//-----------จบ ประเด็น4--------------------------------
//--------------ประเด็น5---------------------------
lblQuestion_3.Text = qset.qL1_list[2].q1_text;
lblAssumption_3.Text = qset.qL1_list[2].q1_assumption;
lblQuestion_id_3.Text = qset.qL1_list[2].q1_id;
lblQuestion_id_praden_3.Text = lblQuestion_id_3.Text;
lblQuestion2_6_1.Text = Q2Seq + qset.qL1_list[2].qL2_list[0].q2_order + " " + qset.qL1_list[2].qL2_list[0].q2_text;
lblQuestion3_5_1_1.Text = qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_text;
lblQuestion3_5_1_2.Text = qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_order + " " + qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_text;
//-----------จบ ประเด็น5--------------------------------
#endregion
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
string max = "";
if (ck != null)
{
mgCookie.UpdateCookies("qset_id", qset.qset_id); //คำถามชุด ข.
answer ans = new answer();
max = ans.getLatestAnswerQ2(ck.pj_id, ans.getLatestAnswerQSetID(ck.pj_id));
//if (pnlQL1_3.Visible == true)
//{
// //ประเด็น 3
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[0].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[0].qL2_list[0].q2_id);
//}
//else if (pnlQL1_4.Visible == true)
//{
// //ประเด็นที่ 4
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[1].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[1].qL2_list[0].q2_id);
//}
//else if (pnlQL1_5.Visible == true)
//{
// //ประเด็นที่ 5
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[2].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[2].qL2_list[0].q2_id);
//}
}
else
{
Response.Redirect(ton.config.Global_config.RootURL);
}
//ไม่ใช่
if ((!Page.IsPostBack) && (ck != null))
{
//-------get latest------
string strQ2ID = max;
//ton.JavaScript.MessageBox(strQ2ID);
if (strQ2ID != null)
{
if (strQ2ID == "2")
{
// Origin Q2_1
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = true;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "3")
{
// Next is Q2_2
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = true;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "4")
{
// Next is Q2_3
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = true;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "5")
{
// Next is Q2_4
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = true;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "6")
{
// Next is Q2_5
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = true;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "7")
{
// Next is Q2_6
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = true;
}
else if (strQ2ID == "8")
{
// Next is QSet C ค.
litfinish.Text = "เสร็จสิ้นการแก้ไขประเมิน" + qset.qset_text;
litfinish.Visible = true;
btnToQB.Visible = true;
pnlQL1_3.Visible = false;
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
// Origin Q2_1
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
}
//------------------
/*
#region LoadData_from_DB
* // Load and Map DB Data For Edit Mode only
* string strSQL1 = "";
* SqlCommand cmd = new SqlCommand();
* DataView dv1 = new DataView();
* // Load and Map Data from DB to interface
* //คำตอบ
* // ประเด็นที่ 3
#region คำตอบ คำถามที่ 1
* strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+
+ radanswer2_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_1_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_1_3.Text = dv1.Table.Rows[2]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 2
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[1].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_2.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_2_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 3
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[2].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_3.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_3_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 4
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[3].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_4.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_4_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_3.Text = dv1.Table.Rows[2]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_4.Text = dv1.Table.Rows[3]["answer_q3_text"].ToString();
#endregion
+
+ //ประเด็นที่ 4
#region คำตอบ คำถามที่ 5
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[1].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_5_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_4_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
+ //ประเด็นที่ 5
#region คำตอบ คำถามที่ 6
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[2].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_6_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_5_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_5_1_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+
#endregion
#endregion
*/
}
// set cookies to keep the lastest question Set , Q2
#region set cookies follow to visible panel
#region ไม่ใช้
//if (pnlQL1_3.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "3"); //ประเด็นที่สาม
// if (pnlQL2_1.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "3"); //คำถามที่1 , IDคำถามเริ่มที่3
// }
// else if (pnlQL2_2.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "4"); //คำถามที่2
// }
// else if (pnlQL2_3.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "5"); //คำถามที่3
// }
// else if (pnlQL2_4.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "6"); //คำถามที่3
// }
//}
//else if (pnlQL1_4.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "4"); //ประเด็นที่สี่
// mgCookie.UpdateCookies("q2_id", "7"); //คำถามที่ห้า
//}
//else if (pnlQL1_5.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "5"); //ประเด็นที่ห้า
// mgCookie.UpdateCookies("q2_id", "8"); //คำถามที่หก
//}
#endregion
#endregion
//----------------------------------------
//คำถามที่ 1
if (radanswer2_1.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_1_1.Enabled = txtAnswerQuestion3_1_2.Enabled = txtAnswerQuestion3_1_3.Enabled = true;
reqvld_3_1_1.Enabled = reqvld_3_1_2.Enabled = reqvld_3_1_3.Enabled = true;
}
else
{
txtAnswerQuestion3_1_1.Enabled = txtAnswerQuestion3_1_2.Enabled = txtAnswerQuestion3_1_3.Enabled = false;
reqvld_3_1_1.Enabled = reqvld_3_1_2.Enabled = reqvld_3_1_3.Enabled = false;
}
//คำถามที่ 2
if (radanswer2_2.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_2_1.Enabled = true;
reqvld_3_2_1.Enabled = true;
}
else
{
txtAnswerQuestion3_2_1.Enabled = false;
reqvld_3_2_1.Enabled = false;
}
//คำถามที่ 3
if (radanswer2_3.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_3_1.Enabled = true;
reqvld_3_3_1.Enabled = true;
}
else
{
txtAnswerQuestion3_3_1.Enabled = false;
reqvld_3_3_1.Enabled = false;
}
//คำถามที่ 4
if (radanswer2_4.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_4_1.Enabled = txtAnswerQuestion3_4_2.Enabled = txtAnswerQuestion3_4_3.Enabled = txtAnswerQuestion3_4_4.Enabled = true;
reqvld_3_4_1.Enabled = reqvld_3_4_2.Enabled = reqvld_3_4_3.Enabled = reqvld_3_4_4.Enabled = true;
}
else
{
txtAnswerQuestion3_4_1.Enabled = txtAnswerQuestion3_4_2.Enabled = txtAnswerQuestion3_4_3.Enabled = txtAnswerQuestion3_4_4.Enabled = false;
reqvld_3_4_1.Enabled = reqvld_3_4_2.Enabled = reqvld_3_4_3.Enabled = reqvld_3_4_4.Enabled = false;
}
//คำถามที่ 5
if ((radanswer2_5_1.SelectedValue == "มี") || (radanswer2_5_1.SelectedValue == "มีบางส่วน")) // ตอบว่า มี หรือ มีบางส่วน
{
txtAnswerQuestion3_4_1_1.Enabled = true;
reqvld3_4_1_1.Enabled = true;
}
else
{
txtAnswerQuestion3_4_1_1.Enabled = false;
reqvld3_4_1_1.Enabled = false;
}
//คำถามที่ 6
if (radanswer2_6_1.SelectedValue == "มี") // ตอบว่า มี หรือ มีบางส่วน
{
txtAnswerQuestion3_5_1_1.Enabled = txtAnswerQuestion3_5_1_2.Enabled = true;
reqvld_3_5_1_1.Enabled = reqvld_3_5_1_2.Enabled = true;
}
else
{
txtAnswerQuestion3_5_1_1.Enabled = txtAnswerQuestion3_5_1_2.Enabled = false;
reqvld_3_5_1_1.Enabled = reqvld_3_5_1_2.Enabled = false;
}
}
