protected void Page_Load(object sender, EventArgs e) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); if (ck != null) { string strDeptID = ck.d_code; //Redirect Login users to pending page //redirectToPendingPage(); //string strDeptID = "01001"; string strProjectStatus = ck.pj_status; //keep project code in cookie for usage in follwing pages mgCookie.UpdateCookies("pj_status", strProjectStatus); string strSQL1 = "select * from dbo.department d, dbo.ministry m where d.mi_id = m.mi_id and d.d_code = '" + strDeptID + "'"; SqlDataSource4.SelectCommand = strSQL1; SqlDataSource4.DataBind(); DataView dv1 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty); foreach (DataRow dRow in dv1.Table.Rows) { lblDeptCode.Text = dRow["mi_code"].ToString(); lblDeptName.Text = dRow["mi_name"].ToString(); lblDivisionCode.Text = dRow["d_code"].ToString(); lblDivisionName.Text = dRow["d_name"].ToString(); mgCookie.UpdateCookies("mi_id", dRow["mi_id"].ToString()); } if (!Page.IsPostBack) { string strSQL = "SELECT * from dbo.projects where pj_id = " + ck.pj_id; SqlDataSource2.SelectCommand = strSQL; SqlDataSource2.DataBind(); DataView dv = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); lblProjectCode.Text = dv.Table.Rows[0]["pj_code"].ToString(); txtProjectName.Text = dv.Table.Rows[0]["pj_name"].ToString(); ddlYudtasad.SelectedValue = dv.Table.Rows[0]["pj_yut_id"].ToString(); ddlYear.SelectedValue = dv.Table.Rows[0]["pj_year"].ToString(); txtBudget.Text = dv.Table.Rows[0]["pj_budget"].ToString(); DropDownList2.SelectedValue = dv.Table.Rows[0]["pj_budget_type"].ToString(); //txtIntegrate.Text = dv.Table.Rows[0]["pj_integrateproject"].ToString(); //txtRelate.Text = dv.Table.Rows[0]["pj_relateDept"].ToString(); } } }
protected void btnNextToQ2_2_Click(object sender, EventArgs e) { //บันทักข้อมูล แล้วแสดงประเด็นที่ 2 ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = ans.insertOrUpdateAnswerQ2(radanswer2_1.SelectedValue, ck.pj_id, ck.q2_id, ck.qset_id); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); int ret2 = 0; if (radanswer2_1.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 1.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1.Text, ck.pj_id, "1", ret.ToString()); // คำถามย่อยข้อ 1.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_2.Text, ck.pj_id, "2", ret.ToString()); // คำถามย่อยข้อ 1.3 //ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_3.Text, ck.pj_id, "3", ret.ToString()); } else { // คำถามย่อยข้อ 1.1 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "1", ret.ToString()); // คำถามย่อยข้อ 1.2 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "2", ret.ToString()); // คำถามย่อยข้อ 1.3 //ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "3", ret.ToString()); } mgCookie.UpdateCookies("q1_id", "2"); //ประเด็นที่สอง mgCookie.UpdateCookies("q2_id", "2"); if (ret2 > 0) { //บันทึกสำเร็จ litfinish.Text = "เสร็จสิ้นการแก้ไขประเมินชุด ค: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ"; litfinish.Visible = true; btnToQB.Visible = true; panel1.Visible = false; } else { //บันทึกไม่สำเร็จ } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["pj_id"] != null) { string strPJ_ID = Request.QueryString["pj_id"]; ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); mgCookie.UpdateCookies("pj_id", strPJ_ID); mgCookie.UpdateCookies("qset_id", ans.getLatestAnswerQSetID(strPJ_ID)); mgCookie.UpdateCookies("q2_id", ans.getLatestAnswerQ2(ck.pj_id, ck.qset_id)); if (Request.QueryString["fm"] == "submitted") { Response.Redirect("project_summary_submitted.aspx"); } else if (Request.QueryString["fm"] == "simnotsubmitted" || Request.QueryString["fm"] == "realnotsubmitted") { Response.Redirect("project_summary.aspx"); } else if (Request.QueryString["fm"] == "simnotcomplete" || Request.QueryString["fm"] == "realnotcomplete") { projects pj = new projects(); if (pj.redirectToPendingProjectDetails(ck.pj_id).Contains(".aspx")) { Response.Redirect(pj.redirectToPendingProjectDetails(ck.pj_id)); } } else if (Request.QueryString["fm"] == "notReqApproval") { Response.Redirect("project_summary.aspx?fm=notReqApproval"); } else { switch (ck.q2_id) { default: Response.Redirect("project_pickquestion.aspx"); break; } } } }
protected void btnToQ9_6_Click(object sender, EventArgs e) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = ans.insertOrUpdateAnswerQ2(radanswer8_5.SelectedValue, ck.pj_id, "14", "4"); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); int ret2 = 0; if (radanswer8_5.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 8.5 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion8_5_1.Text, ck.pj_id, "28", ret.ToString()); } else if (radanswer8_5.SelectedIndex == 1) { // คำถามย่อยข้อ 8.5 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "28", ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ Response.Redirect("question_set_D.aspx?q1=3&q2=6"); } else { //บันทึกไม่สำเร็จ } }
protected void lbt_proj_name_Click(object sender, EventArgs e) { LinkButton lbt_temp = sender as LinkButton; //option 1 pass with cookies ManageCookie mgCookie = new ManageCookie(); mgCookie.UpdateCookies("pj_id", lbt_temp.CommandArgument); // option 2 pass with QueryString. There are problem with '+' in url //Server.Transfer(Global_config.RootURL + "project_approval_1.aspx" + "?id=" + ton.Encryption.Encrypt(lbt_temp.CommandArgument, ton.Encryption.keyword)); string approval_status = tonUtilities.cleanQueryString(Request.QueryString["status"]); string prefix = "1"; if (approval_status == "1") { prefix = "4"; } else if ((approval_status == "2") || (approval_status == "3") || (approval_status == "4")) { prefix = "5"; } else { prefix = "1"; } Response.Redirect(Global_config.RootURL + "project_approval_" + prefix + ".aspx" + "?id=" + ton.Encryption.Encrypt(lbt_temp.CommandArgument, ton.Encryption.keyword)); }
protected void btnNext_Click(object sender, EventArgs e) { //บันทักข้อมูล ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = ans.insertOrUpdateAnswerQ2(radQ2.SelectedValue, ck.pj_id, ck.q2_id, ck.qset_id); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); int ret2 = 0; if (radQ2.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 1.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_6.Text, ck.pj_id, "6", ret.ToString()); // คำถามย่อยข้อ 1.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_7.Text, ck.pj_id, "7", ret.ToString()); // คำถามย่อยข้อ 1.3 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_8.Text, ck.pj_id, "8", ret.ToString()); } else { // คำถามย่อยข้อ 1.1 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "6", ret.ToString()); // คำถามย่อยข้อ 1.2 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "7", ret.ToString()); // คำถามย่อยข้อ 1.3 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "8", ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ //Response.Redirect("project_edit.aspx"); litfinish.Text = "เสร็จสิ้นการแก้ไขประเมินชุด ก: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ"; litfinish.Visible = true; btnToQB.Visible = true; panel2.Visible = false; } else { //บันทึกไม่สำเร็จ } }
protected void btnToQ8_4_Click(object sender, EventArgs e) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = ans.insertOrUpdateAnswerQ2(radanswer7_3.SelectedValue, ck.pj_id, "12", "4"); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); int ret2 = 0; if (radanswer7_3.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 7.3 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion7_3_1.Text, ck.pj_id, "26", ret.ToString()); } else if (radanswer7_3.SelectedIndex == 1) { // คำถามย่อยข้อ 7.3 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "26", ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ pnl7_1.Visible = false; pnl7_2.Visible = false; pnl7_3.Visible = false; Response.Redirect("question_set_D.aspx?q1=2&q2=4"); //panel1.Visible = false; //panel2.Visible = true; //panel3.Visible = false; //pnl8_4.Visible = true; //pnl8_5.Visible = false; } else { //บันทึกไม่สำเร็จ } }
protected void btnNext_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } else { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); SqlParameter pj_cate = new SqlParameter("@pj_type", SqlDbType.NVarChar, 100); pj_cate.Direction = ParameterDirection.Input; pj_cate.Value = radProjectCate.SelectedValue.ToString(); SqlParameter pj_id = new SqlParameter("@pj_id", SqlDbType.Int); pj_id.Direction = ParameterDirection.Input; pj_id.Value = ck.pj_id; insertParameters.Add(pj_cate); insertParameters.Add(pj_id); //try //{ SqlDataSource1.Update(); mgCookie.UpdateCookies("pj_type", this.radProjectCate.SelectedValue); Response.Redirect("project_pickquestion.aspx?fm=type"); //} //catch (Exception ex) //{ // //ELMA Log // Elmah.ErrorSignal.FromCurrentContext().Raise(ex); //} } }
protected void btnToQ7_3_Click(object sender, EventArgs e) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = ans.insertOrUpdateAnswerQ2(radanswer7_1.SelectedValue, ck.pj_id, "11", "4"); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); int ret2 = 0; if (radanswer7_2.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 7.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion7_2_1.Text, ck.pj_id, "25", ret.ToString()); } else if (radanswer7_2.SelectedIndex == 1) { // คำถามย่อยข้อ 7.2 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "25", ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ pnl7_1.Visible = false; pnl7_2.Visible = false; pnl7_3.Visible = true; } else { //บันทึกไม่สำเร็จ } }
protected void btnSaveQL1(object sender, EventArgs e) { if (!Page.IsValid) { return; } Button btn_temp = sender as Button; string arg = btn_temp.CommandArgument; ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = -1; int ret2 = 0; if (ck == null) { ton.JavaScript.MessageBox(" ข้อมูลโปรเจค ว่างเปล่า \r\n กรุณาเข้าสู่ระบบ "); return; } if (arg == "3.2.1") { //ประเด็น3 #region 3.2.1 ret = ans.insertOrUpdateAnswerQ2(radanswer2_1.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[0].q2_id, ck.qset_id); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); // มี หรือ ไม่มี if (radanswer2_1.SelectedValue == "มี") // ตอบว่า มี { // คำถามย่อยข้อ 1.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_id, ret.ToString()); // คำถามย่อยข้อ 1.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_2.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_id, ret.ToString()); // คำถามย่อยข้อ 1.3 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_3.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_id, ret.ToString()); } else { // คำถามย่อยข้อ 1.1 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_id, ret.ToString()); // คำถามย่อยข้อ 1.2 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_id, ret.ToString()); // คำถามย่อยข้อ 1.3 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_id, ret.ToString()); } #endregion if (ret2 > 0) { //บันทึกสำเร็จ 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 { //บันทึกไม่สำเร็จ ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ"); } } else if (arg == "3.2.2") { //ประเด็น3 #region 3.2.2 ret = ans.insertOrUpdateAnswerQ2(radanswer2_2.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[1].q2_id, ck.qset_id); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); if (radanswer2_2.SelectedValue == "มี") // ตอบว่า มี { // คำถามย่อยข้อ 2.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_2_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_id, ret.ToString()); } else { // คำถามย่อยข้อ 2.1 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_id, ret.ToString()); } #endregion if (ret2 > 0) { //บันทึกสำเร็จ 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 { //บันทึกไม่สำเร็จ ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ"); } } else if (arg == "3.2.3") { //ประเด็น3 #region 3.2.3 ret = ans.insertOrUpdateAnswerQ2(radanswer2_3.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[2].q2_id, ck.qset_id); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); if (radanswer2_3.SelectedValue == "มี") // ตอบว่า มี { // คำถามย่อยข้อ 3.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_3_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_id, ret.ToString()); } else { ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_id, ret.ToString()); } #endregion if (ret2 > 0) { //บันทึกสำเร็จ 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 { //บันทึกไม่สำเร็จ ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ"); } } else if (arg == "3.2.4") { //ประเด็น3 #region 3.2.4 ret = ans.insertOrUpdateAnswerQ2(radanswer2_4.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[3].q2_id, ck.qset_id); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); if (radanswer2_4.SelectedValue == "มี") { // คำถามย่อยข้อ 4.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_id, ret.ToString()); // คำถามย่อยข้อ 4.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_2.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_id, ret.ToString()); // คำถามย่อยข้อ 4.3 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_3.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_id, ret.ToString()); // คำถามย่อยข้อ 4.4 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_4.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_id, ret.ToString()); } else { ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_id, ret.ToString()); ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_id, ret.ToString()); ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_id, ret.ToString()); ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_id, ret.ToString()); } #endregion if (ret2 > 0) { //บันทึกสำเร็จ 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 { //บันทึกไม่สำเร็จ ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ"); } } else if (arg == "4") { //ประเด็น4 ret = ans.insertOrUpdateAnswerQ2(radanswer2_5_1.SelectedValue, ck.pj_id, qset.qL1_list[1].qL2_list[0].q2_id, ck.qset_id); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); // มี หรือ ไม่มี if ((radanswer2_5_1.SelectedValue == "มี") || (radanswer2_5_1.SelectedValue == "มีบางส่วน")) // ตอบว่า มี { // คำถามย่อยข้อ 5.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_1_1.Text, ck.pj_id, qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_id, ret.ToString()); } else { // คำถามย่อยข้อ 5.1 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_id, ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ pnlQL1_3.Visible = false; pnlQL1_4.Visible = false; pnlQL1_5.Visible = true; } else { //บันทึกไม่สำเร็จ ton.JavaScript.MessageBox("บันทึก ประเด็น4 ไม่สำเร็จ"); } } else if (arg == "5") { //ประเด็น5 ret = ans.insertOrUpdateAnswerQ2(radanswer2_6_1.SelectedValue, ck.pj_id, qset.qL1_list[2].qL2_list[0].q2_id, ck.qset_id); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); // มี หรือ ไม่มี if (radanswer2_6_1.SelectedValue == "มี") // ตอบว่า มี { // คำถามย่อยข้อ 6.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_5_1_1.Text, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_id, ret.ToString()); // คำถามย่อยข้อ 6.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_5_1_2.Text, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_id, ret.ToString()); } else { // คำถามย่อยข้อ 6.1 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_id, ret.ToString()); // คำถามย่อยข้อ 6.2 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_id, ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ litfinish.Text = "เสร็จสิ้นการแก้ไขประเมิน" + qset.qset_text; litfinish.Visible = true; btnToQB.Visible = true; pnlQL1_3.Visible = false; pnlQL1_4.Visible = false; pnlQL1_5.Visible = false; } else { //บันทึกไม่สำเร็จ ton.JavaScript.MessageBox("บันทึก ประเด็น5 ไม่สำเร็จ"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); string max = ""; if (ck != null) { answer ans = new answer(); max = ans.getLatestAnswerQ2(ck.pj_id, ans.getLatestAnswerQSetID(ck.pj_id)); string strSQL1 = string.Format(@"select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 3 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id;"); SqlDataSource1.SelectCommand = strSQL1; SqlDataSource1.DataBind(); DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); //ประเด็นที่หนึ่ง lblQuestion1.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString(); lblAssumption.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString(); lblQuestion2_1.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString(); lblQuestion3_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString(); lblQuestion3_2.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString(); //lblQuestion3_3.Text = dv1.Table.Rows[2]["q3_order"].ToString() + " " + dv1.Table.Rows[2]["q3_text"].ToString(); mgCookie.UpdateCookies("qset_id", "3"); //คำถามชุด ค. #region ต้น string strQ2ID = max; //ton.JavaScript.MessageBox(strQ2ID); if (strQ2ID != null) { if (strQ2ID == "8") { panel1.Visible = true; litfinish.Visible = false; btnToQB.Visible = false; } else if (strQ2ID == "9") { panel1.Visible = false; litfinish.Text = "เสร็จสิ้นการประเมินชุด ค: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ"; litfinish.Visible = true; btnToQB.Visible = true; } else { panel1.Visible = false; litfinish.Visible = false; btnToQB.Visible = false; } } #endregion if (panel1.Visible == true) { mgCookie.UpdateCookies("q1_id", "3"); //ประเด็นที่หนึ่ง mgCookie.UpdateCookies("q2_id", dv1.Table.Rows[0]["q2_id"].ToString()); } } else { Response.Redirect(ton.config.Global_config.RootURL); } } }
protected void Page_Load(object sender, EventArgs e) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); if (!Page.IsPostBack) { if (ck != null) { //ประเด็นที่หนึ่ง คำถาม string strSQL1 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 1 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 1"; SqlDataSource1.SelectCommand = strSQL1; SqlDataSource1.DataBind(); DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); lblQuestion1.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString(); lblAssumption.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString(); lblQuestion2_1.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString(); lblQuestion3_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString(); lblQuestion3_2.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString(); lblQuestion3_3.Text = dv1.Table.Rows[2]["q3_order"].ToString() + " " + dv1.Table.Rows[2]["q3_text"].ToString(); lblQuestion3_4.Text = dv1.Table.Rows[3]["q3_order"].ToString() + " " + dv1.Table.Rows[3]["q3_text"].ToString(); lblQuestion3_5.Text = dv1.Table.Rows[4]["q3_order"].ToString() + " " + dv1.Table.Rows[4]["q3_text"].ToString(); //ประเด็นที่หนึ่ง คำตอบ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 " + " where q2.qset_id = 1 and " + "q2.pj_id = " + ck.pj_id + " and " + "q2.q2_id = 1 and " + "q2.answer_q2_id = q3.answer_q2_id"; SqlDataSource1.SelectCommand = strSQL1; SqlDataSource1.DataBind(); dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); if (dv1.Table.Rows[0]["answer_q2_text"].ToString() == "มี" || dv1.Table.Rows[0]["answer_q2_text"].ToString() == "ใช่") { radanswer2_1.SelectedIndex = 0; } else { radanswer2_1.SelectedIndex = 1; } txtAnswerQuestion3_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString(); txtAnswerQuestion3_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString(); txtAnswerQuestion3_3.Text = dv1.Table.Rows[2]["answer_q3_text"].ToString(); txtAnswerQuestion3_4.Text = dv1.Table.Rows[3]["answer_q3_text"].ToString(); txtAnswerQuestion3_5.Text = dv1.Table.Rows[4]["answer_q3_text"].ToString(); //ประเด็นที่สอง คำถาม string strSQL2 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 1 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 2"; SqlDataSource2.SelectCommand = strSQL2; SqlDataSource2.DataBind(); DataView dv2 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); lblQuestion2.Text = "ประเด็นที่ " + dv2.Table.Rows[0]["q1_order"].ToString() + " " + dv2.Table.Rows[0]["q1_text"].ToString(); lblAssumption2.Text = "สมมุติฐาน " + dv2.Table.Rows[0]["q1_order"].ToString() + " " + dv2.Table.Rows[0]["q1_assumption"].ToString(); lblQuestion2_2.Text = "คำถามที่ " + dv2.Table.Rows[0]["q2_order"].ToString() + " " + dv2.Table.Rows[0]["q2_text"].ToString(); lblQuestion3_6.Text = dv2.Table.Rows[0]["q3_order"].ToString() + " " + dv2.Table.Rows[0]["q3_text"].ToString(); lblQuestion3_7.Text = dv2.Table.Rows[1]["q3_order"].ToString() + " " + dv2.Table.Rows[1]["q3_text"].ToString(); lblQuestion3_8.Text = dv2.Table.Rows[2]["q3_order"].ToString() + " " + dv2.Table.Rows[2]["q3_text"].ToString(); //ประเด็นที่สอง คำตอบ strSQL2 = "select * from dbo.answer_q2 q2, answer_q3 q3 " + " where q2.qset_id = 1 and " + "q2.pj_id = " + ck.pj_id + " and " + "q2.q2_id = 2 and " + "q2.answer_q2_id = q3.answer_q2_id"; SqlDataSource2.SelectCommand = strSQL2; SqlDataSource2.DataBind(); dv2 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); radQ2.SelectedValue = dv2.Table.Rows[0]["answer_q2_text"].ToString(); txtAnswerQuestion3_6.Text = dv2.Table.Rows[0]["answer_q3_text"].ToString(); txtAnswerQuestion3_7.Text = dv2.Table.Rows[1]["answer_q3_text"].ToString(); txtAnswerQuestion3_8.Text = dv2.Table.Rows[2]["answer_q3_text"].ToString(); mgCookie.UpdateCookies("qset_id", "1"); //คำถามชุด ก. if (panel1.Visible == true) { mgCookie.UpdateCookies("q1_id", "1"); //ประเด็นที่หนึ่ง mgCookie.UpdateCookies("q2_id", dv1.Table.Rows[0]["q2_id"].ToString()); } else if (panel2.Visible == true) { mgCookie.UpdateCookies("q1_id", "2"); //ประเด็นที่สอง mgCookie.UpdateCookies("q2_id", dv2.Table.Rows[0]["q2_id"].ToString()); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); if (ck != null) { String strPJid = Request.QueryString["pjid"]; //Add by Itsada Jitchot 2014/04/30 เนื่องจากในการออกรายงานต้องการ pj_id ที่กดมาจากลิ้ง mgCookie.UpdateCookies("pj_id", strPJid); StringBuilder strSQL = new StringBuilder(); strSQL.Append("select d.d_code, d.d_name, m.mi_code, m.mi_name, p.pj_code, p.d_id, p.pj_name, y.yut_name, p.pj_year, p.pj_budget, pj_integrateProject, pj_relateDept, pj_background, pj_urgency, pj_type, pj_complete_status "); strSQL.Append(" from projects p, department d, ministry m, yutasad y"); strSQL.Append(" where p.d_id = d.d_id and p.mi_id = m.mi_id and p.pj_yut_id = y.yut_id and p.pj_id = '" + strPJid + "'"); SqlDataSource4.SelectCommand = strSQL.ToString(); SqlDataSource4.DataBind(); DataView dv1 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty); foreach (DataRow dRow in dv1.Table.Rows) { lblDeptCode.Text = dRow["mi_code"].ToString(); lblDeptName.Text = dRow["mi_name"].ToString(); lblDivisionCode.Text = dRow["d_code"].ToString(); lblDivisionName.Text = dRow["d_name"].ToString(); lblProjectName.Text = dRow["pj_name"].ToString(); lblProjectCode.Text = dRow["pj_code"].ToString(); lblYutasard.Text = dRow["yut_name"].ToString(); lblBudget.Text = dRow["pj_budget"].ToString(); lblYear.Text = dRow["pj_year"].ToString(); } gUtilities gt = new gUtilities(); if (dv1.Table.Rows[0]["pj_complete_status"].ToString() == "ไม่อยู่ในเกณฑ์การประเมิน/กรอกสมบูรณ์") { linkreport2.Visible = false; linkreport3.Visible = false; litHeader.Text = " โครงการกรอกสมบูรณ์ที่ไม่อยู่ในข่ายที่ต้องวิเคราะห์ความเสี่ยง"; litRisk1.Text = "-"; litRisk2.Text = "-"; } else { linkreport2.Visible = true; linkreport3.Visible = true; litHeader.Text = "โครงการที่เข้าข่ายการวิเคราะห์ความเสี่ยงตามหลักธรรมาภิบาล"; litRisk1.Text = gt.getReportTammaTotal(ck.pj_id); litRisk2.Text = gt.getReportFactorRiskTotal(ck.pj_id); } } else { //redirect //Response.Redirect("project_summary.aspx"); } } }
protected void btnToSetE_Click(object sender, EventArgs e) { //บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่ ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4"); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); int ret2 = 0; if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 9.6 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_1.Text, ck.pj_id, "29", ret.ToString()); } else if (radanswer9_6.SelectedIndex == 1) { // คำถามย่อยข้อ 9.6 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "29", ret.ToString()); } ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4"); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 6.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_2.Text, ck.pj_id, "30", ret.ToString()); } else if (radanswer9_6.SelectedIndex == 1) { // คำถามย่อยข้อ 6.2 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "30", ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ //บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่ projects pj = new projects(); string pjType = pj.getProjectInfo(ck.pj_id, "pj_type"); if (pjType == "โครงการใหม่") { ////Response.Redirect("factor_risk.aspx"); //Response.Redirect("project_pickquestion.aspx"); } else { ////Response.Redirect("question_set_E.aspx"); //Response.Redirect("project_pickquestion.aspx"); } // Go To Quest E จ panel1.Visible = false; panel2.Visible = false; panel3.Visible = false; pnl7_1.Visible = false; pnl7_2.Visible = false; pnl7_3.Visible = false; pnl8_4.Visible = false; pnl8_5.Visible = false; pnl9_6.Visible = false; litfinish.Text = "เสร็จสิ้นการประเมินชุด ง: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ"; pnl_fin.Visible = true; litfinish.Visible = true; btnToQB.Visible = true; } else { //บันทึกไม่สำเร็จ } }
protected void btnToSetE_Click(object sender, EventArgs e) { //บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่ ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4"); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); int ret2 = 0; if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 9.6 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_1.Text, ck.pj_id, "29", ret.ToString()); } else if (radanswer9_6.SelectedIndex == 1) { // คำถามย่อยข้อ 9.6 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "29", ret.ToString()); } ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4"); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 6.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_2.Text, ck.pj_id, "30", ret.ToString()); } else if (radanswer9_6.SelectedIndex == 1) { // คำถามย่อยข้อ 6.2 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "30", ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ //บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่ projects pj = new projects(); string pjType = pj.getProjectInfo(ck.pj_id, "pj_type"); if (pjType == "โครงการใหม่") { //Response.Redirect("factor_risk.aspx"); Response.Redirect("project_edit.aspx"); } else { //Response.Redirect("question_set_E.aspx"); Response.Redirect("project_edit.aspx"); } } else { //บันทึกไม่สำเร็จ } }
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; } }
protected void btnNextToQ2_2_Click(object sender, EventArgs e) { //บันทักข้อมูล แล้วแสดงประเด็นที่ 2 ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); answer ans = new answer(); int ret = ans.insertOrUpdateAnswerQ2(radanswer2_1.SelectedValue, ck.pj_id, "1", "1"); mgCookie.UpdateCookies("answer_q2_id", ret.ToString()); int ret2 = 0; if (radanswer2_1.SelectedIndex == 0) // ตอบว่า ใช่ { // คำถามย่อยข้อ 1.1 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1.Text, ck.pj_id, "1", ret.ToString()); // คำถามย่อยข้อ 1.2 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_2.Text, ck.pj_id, "2", ret.ToString()); // คำถามย่อยข้อ 1.3 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_3.Text, ck.pj_id, "3", ret.ToString()); // คำถามย่อยข้อ 1.4 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4.Text, ck.pj_id, "4", ret.ToString()); // คำถามย่อยข้อ 1.5 ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_5.Text, ck.pj_id, "5", ret.ToString()); } else { // คำถามย่อยข้อ 1.1 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "1", ret.ToString()); // คำถามย่อยข้อ 1.2 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "2", ret.ToString()); // คำถามย่อยข้อ 1.3 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "3", ret.ToString()); // คำถามย่อยข้อ 1.4 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "4", ret.ToString()); // คำถามย่อยข้อ 1.5 ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "5", ret.ToString()); } if (ret2 > 0) { //บันทึกสำเร็จ panel1.Visible = false; panel2.Visible = true; } else { //บันทึกไม่สำเร็จ } }
protected void Page_Load(object sender, EventArgs e) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); string max = ""; if (ck != null) { string strSQL1 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 1 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 1"; SqlDataSource1.SelectCommand = strSQL1; SqlDataSource1.DataBind(); DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty); //ประเด็นที่หนึ่ง lblQuestion1.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString(); lblAssumption.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString(); lblQuestion2_1.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString(); lblQuestion3_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString(); lblQuestion3_2.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString(); lblQuestion3_3.Text = dv1.Table.Rows[2]["q3_order"].ToString() + " " + dv1.Table.Rows[2]["q3_text"].ToString(); lblQuestion3_4.Text = dv1.Table.Rows[3]["q3_order"].ToString() + " " + dv1.Table.Rows[3]["q3_text"].ToString(); lblQuestion3_5.Text = dv1.Table.Rows[4]["q3_order"].ToString() + " " + dv1.Table.Rows[4]["q3_text"].ToString(); //ประเด็นที่สอง string strSQL2 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 1 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 2"; SqlDataSource2.SelectCommand = strSQL2; SqlDataSource2.DataBind(); DataView dv2 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); lblQuestion2.Text = "ประเด็นที่ " + dv2.Table.Rows[0]["q1_order"].ToString() + " " + dv2.Table.Rows[0]["q1_text"].ToString(); lblAssumption2.Text = "สมมุติฐาน " + dv2.Table.Rows[0]["q1_order"].ToString() + " " + dv2.Table.Rows[0]["q1_assumption"].ToString(); lblQuestion2_2.Text = "คำถามที่ " + dv2.Table.Rows[0]["q2_order"].ToString() + " " + dv2.Table.Rows[0]["q2_text"].ToString(); lblQuestion3_6.Text = dv2.Table.Rows[0]["q3_order"].ToString() + " " + dv2.Table.Rows[0]["q3_text"].ToString(); lblQuestion3_7.Text = dv2.Table.Rows[1]["q3_order"].ToString() + " " + dv2.Table.Rows[1]["q3_text"].ToString(); lblQuestion3_8.Text = dv2.Table.Rows[2]["q3_order"].ToString() + " " + dv2.Table.Rows[2]["q3_text"].ToString(); mgCookie.UpdateCookies("qset_id", "1"); //คำถามชุด ก. if (!Page.IsPostBack) { // ต้น comment //string strQ2ID = ck.q2_id; #region ต้น answer ans = new answer(); max = ans.getLatestAnswerQ2(ck.pj_id, ans.getLatestAnswerQSetID(ck.pj_id)); string strQ2ID = string.IsNullOrEmpty(max) ? "0" : max; #endregion if (strQ2ID != null) { // ค่า max ที่ได้คือข้อล่าสุดที่ได้ทำไป ดังนั้นข้อต่อไปคือ max + 1 if (strQ2ID == "0") { panel1.Visible = true; panel2.Visible = false; } else if (strQ2ID == "1") { panel1.Visible = false; panel2.Visible = true; } else if (strQ2ID == "2") { litfinish.Text = "เสร็จสิ้นการประเมินชุด ก: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ"; litfinish.Visible = true; btnToQB.Visible = true; panel1.Visible = false; panel2.Visible = false; } else { litfinish.Visible = false; btnToQB.Visible = false; panel1.Visible = false; panel2.Visible = false; } } } if (panel1.Visible == true) { mgCookie.UpdateCookies("q1_id", "1"); //ประเด็นที่หนึ่ง //mgCookie.UpdateCookies("q2_id", dv1.Table.Rows[0]["q2_id"].ToString()); mgCookie.UpdateCookies("q2_id", "1"); } else if (panel2.Visible == true) { mgCookie.UpdateCookies("q1_id", "2"); //ประเด็นที่สอง //mgCookie.UpdateCookies("q2_id", dv2.Table.Rows[0]["q2_id"].ToString()); mgCookie.UpdateCookies("q2_id", "2"); } } }
protected void Page_Load(object sender, EventArgs e) { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); if (ck != null) { string strDeptID = ck.d_code; //Redirect Login users to pending page //redirectToPendingPage(); //string strDeptID = "01001"; string strProjectStatus = Request.QueryString["status"]; //keep project code in cookie for usage in follwing pages mgCookie.UpdateCookies("pj_status", strProjectStatus); string strSQL1 = "select * from dbo.department d, dbo.ministry m where d.mi_id = m.mi_id and d.d_code = '" + strDeptID + "'"; SqlDataSource4.SelectCommand = strSQL1; SqlDataSource4.DataBind(); DataView dv1 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty); foreach (DataRow dRow in dv1.Table.Rows) { lblDeptCode.Text = dRow["mi_code"].ToString(); lblDeptName.Text = dRow["mi_name"].ToString(); lblDivisionCode.Text = dRow["d_code"].ToString(); lblDivisionName.Text = dRow["d_name"].ToString(); mgCookie.UpdateCookies("mi_id", dRow["mi_id"].ToString()); mgCookie.UpdateCookies("d_id", dRow["d_id"].ToString()); } if (!Page.IsPostBack) { string strSQL = string.Empty; strSQL = "SELECT pj_code from dbo.projects where d_id = " + strDeptID + " and pj_isinuse = 1 and pj_status = '" + strProjectStatus + "' and p_id = " + ck.p_id + " and mi_id is null and pj_name is null and pj_yut_id is null and pj_year is null"; SqlDataSource2.SelectCommand = strSQL; SqlDataSource2.DataBind(); DataView dv = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); if (dv.Count > 0) { strSQL = "SELECT max(cast(substring(pj_code, 7, 3) as int)) from dbo.projects where d_id = " + strDeptID + " and pj_isinuse = 1 and pj_status = '" + strProjectStatus + "' and p_id = " + ck.p_id + " and mi_id is null and pj_name is null and pj_yut_id is null and pj_year is null"; } else { strSQL = "SELECT max(cast(substring(pj_code, 7, 3) as int)) + 1 from dbo.projects where d_id = " + strDeptID + " and pj_isinuse = 1 and pj_status = '" + strProjectStatus + "'"; } SqlDataSource2.SelectCommand = strSQL; SqlDataSource2.DataBind(); dv = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty); if (dv.Count > 0) { foreach (DataRow dRow in dv.Table.Rows) { if (dRow[0] != null && dRow[0].ToString() != string.Empty) { if (dRow[0].ToString().Length == 1) { lblProjectCode.Text = strDeptID + "-00" + dRow[0].ToString(); } else if (dRow[0].ToString().Length == 2) { lblProjectCode.Text = strDeptID + "-0" + dRow[0].ToString(); } else { lblProjectCode.Text = strDeptID + "-" + dRow[0].ToString(); } } else { lblProjectCode.Text = strDeptID + "-" + "001"; } } mgCookie.UpdateCookies("pj_code", lblProjectCode.Text); string strUID = ck.p_id; /************************************************************************************************** * insert projects table by setting projects.p_isinuse = 1, * this is to avoid conflict when creating more than 1 project at the same time by multiple users **************************************************************************************************/ SqlParameter pj_code = new SqlParameter("@pj_code", SqlDbType.NVarChar, 15); pj_code.Direction = ParameterDirection.Input; pj_code.Value = lblProjectCode.Text; SqlParameter p_id = new SqlParameter("@p_id", SqlDbType.Int); p_id.Direction = ParameterDirection.Input; p_id.Value = ck.p_id; SqlParameter pj_status = new SqlParameter("@pj_status", SqlDbType.NVarChar); pj_status.Direction = ParameterDirection.Input; pj_status.Value = strProjectStatus; SqlParameter d_id = new SqlParameter("@d_id", SqlDbType.NVarChar); d_id.Direction = ParameterDirection.Input; d_id.Value = strDeptID; insertParameters.Add(pj_code); insertParameters.Add(p_id); insertParameters.Add(pj_status); insertParameters.Add(d_id); try { //not insert when the existing record does not have input string strSQL11 = "select pj_id from projects where pj_code = '" + lblProjectCode.Text + "' and pj_status = '" + Request.QueryString["status"] + "'"; SqlDataSource7.SelectCommand = strSQL11; SqlDataSource7.DataBind(); DataView dv7 = (DataView)SqlDataSource7.Select(DataSourceSelectArguments.Empty); if (dv7.Table.Rows.Count == 0) { SqlDataSource3.Insert(); } else { mgCookie.UpdateCookies("pj_id", dv7.Table.Rows[0]["pj_id"].ToString()); } } catch (Exception ex) { //Elmah Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } } } } }
protected void btnNext_Click(object sender, EventArgs e) { //save project code to cookie if (!Page.IsValid) { return; } else { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); // update to database SqlParameter p_id = new SqlParameter("@p_id", SqlDbType.Int); p_id.Direction = ParameterDirection.Input; p_id.Value = ck.p_id; SqlParameter d_id = new SqlParameter("@d_id", SqlDbType.NVarChar, 20); d_id.Direction = ParameterDirection.Input; d_id.Value = ck.d_code; SqlParameter mi_id = new SqlParameter("@mi_id", SqlDbType.NVarChar, 25); mi_id.Direction = ParameterDirection.Input; mi_id.Value = ck.mi_id; SqlParameter pj_name = new SqlParameter("@pj_name", SqlDbType.NVarChar, 500); pj_name.Direction = ParameterDirection.Input; pj_name.Value = txtProjectName.Text; SqlParameter pj_yut_id = new SqlParameter("@pj_yut_id", SqlDbType.Int); pj_yut_id.Direction = ParameterDirection.Input; pj_yut_id.Value = ddlYudtasad.SelectedValue; SqlParameter pj_year = new SqlParameter("@pj_year", SqlDbType.NVarChar, 4); pj_year.Direction = ParameterDirection.Input; pj_year.Value = ddlYear.SelectedValue; SqlParameter pj_budget = new SqlParameter("@pj_budget", SqlDbType.NVarChar, 50); pj_budget.Direction = ParameterDirection.Input; pj_budget.Value = txtBudget.Text; SqlParameter pj_budget_money = new SqlParameter("@pj_budget_money", SqlDbType.Float); pj_budget_money.Direction = ParameterDirection.Input; pj_budget_money.Value = txtBudget.Text.Replace(",", ""); SqlParameter pj_budget_category = new SqlParameter("@pj_budget_category", SqlDbType.NVarChar, 200); pj_budget_category.Direction = ParameterDirection.Input; pj_budget_category.Value = DropDownList2.SelectedValue; SqlParameter pj_id = new SqlParameter("@pj_id", SqlDbType.Int); pj_id.Direction = ParameterDirection.Input; pj_id.Value = ck.pj_id; //SqlParameter pj_integrateProject = new SqlParameter("@pj_integrateProject", SqlDbType.NVarChar); //pj_integrateProject.Direction = ParameterDirection.Input; //pj_integrateProject.Value = txtIntegrate.Text; //SqlParameter pj_relateDept = new SqlParameter("@pj_relateDept", SqlDbType.NVarChar); //pj_relateDept.Direction = ParameterDirection.Input; //pj_relateDept.Value = txtRelate.Text; insertParameters.Add(p_id); insertParameters.Add(d_id); insertParameters.Add(mi_id); insertParameters.Add(pj_name); insertParameters.Add(pj_yut_id); insertParameters.Add(pj_year); insertParameters.Add(pj_budget); insertParameters.Add(pj_budget_money); insertParameters.Add(pj_id); insertParameters.Add(pj_budget_category); //insertParameters.Add(pj_integrateProject); //insertParameters.Add(pj_relateDept); try { SqlDataSource44.Update(); //keep project code in cookie for usage in follwing pages mgCookie.UpdateCookies("pj_code", lblProjectCode.Text); } catch (Exception ex) { //ELMA Log Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } //Response.Redirect("project_filter_edit.aspx"); Response.Redirect("project_edit.aspx"); } }
protected void btnNext_Click(object sender, EventArgs e) { //save project code to cookie if (!Page.IsValid) { return; } else { ManageCookie mgCookie = new ManageCookie(); users ck = mgCookie.ReadCookies(); // update to database SqlParameter pj_code = new SqlParameter("@pj_code", SqlDbType.NVarChar, 15); pj_code.Direction = ParameterDirection.Input; pj_code.Value = lblProjectCode.Text; SqlParameter p_id = new SqlParameter("@p_id", SqlDbType.Int); p_id.Direction = ParameterDirection.Input; p_id.Value = ck.p_id; SqlParameter d_id = new SqlParameter("@d_id", SqlDbType.NVarChar, 20); d_id.Direction = ParameterDirection.Input; d_id.Value = ck.d_id; SqlParameter mi_id = new SqlParameter("@mi_id", SqlDbType.NVarChar, 25); mi_id.Direction = ParameterDirection.Input; mi_id.Value = ck.mi_id; SqlParameter pj_name = new SqlParameter("@pj_name", SqlDbType.NVarChar, 500); pj_name.Direction = ParameterDirection.Input; pj_name.Value = txtProjectName.Text; SqlParameter pj_yut_id = new SqlParameter("@pj_yut_id", SqlDbType.Int); pj_yut_id.Direction = ParameterDirection.Input; pj_yut_id.Value = ddlYudtasad.SelectedValue; SqlParameter pj_year = new SqlParameter("@pj_year", SqlDbType.NVarChar, 4); pj_year.Direction = ParameterDirection.Input; pj_year.Value = ddlYear.SelectedValue; SqlParameter pj_budget_money = new SqlParameter("@pj_budget_money", SqlDbType.Float); pj_budget_money.Direction = ParameterDirection.Input; pj_budget_money.Value = txtBudget.Text.Replace(",", ""); SqlParameter pj_budget = new SqlParameter("@pj_budget", SqlDbType.NVarChar, 50); pj_budget.Direction = ParameterDirection.Input; pj_budget.Value = txtBudget.Text; SqlParameter pj_budget_category = new SqlParameter("@pj_budget_category", SqlDbType.NVarChar, 200); pj_budget_category.Direction = ParameterDirection.Input; pj_budget_category.Value = DropDownList2.SelectedValue; //SqlParameter pj_integrateProject = new SqlParameter("@pj_integrateProject", SqlDbType.NVarChar); //pj_integrateProject.Direction = ParameterDirection.Input; ////pj_integrateProject.Value = txtIntegrate.Text; //pj_integrateProject.Value = string.Empty; //SqlParameter pj_relateDept = new SqlParameter("@pj_relateDept", SqlDbType.NVarChar); //pj_relateDept.Direction = ParameterDirection.Input; ////pj_relateDept.Value = txtRelate.Text; //pj_relateDept.Value = string.Empty; SqlParameter pj_status = new SqlParameter("@pj_status", SqlDbType.NVarChar); pj_status.Direction = ParameterDirection.Input; pj_status.Value = Request.QueryString["status"]; insertParameters.Add(pj_code); insertParameters.Add(p_id); insertParameters.Add(d_id); insertParameters.Add(mi_id); insertParameters.Add(pj_name); insertParameters.Add(pj_yut_id); insertParameters.Add(pj_year); insertParameters.Add(pj_budget); insertParameters.Add(pj_budget_money); //insertParameters.Add(pj_integrateProject); //insertParameters.Add(pj_relateDept); insertParameters.Add(pj_status); insertParameters.Add(pj_budget_category); try { SqlDataSource44.Update(); //keep project code in cookie for usage in follwing pages mgCookie.UpdateCookies("pj_code", lblProjectCode.Text); } catch (Exception ex) { //ELMA Log Elmah.ErrorSignal.FromCurrentContext().Raise(ex); } SqlDataSource6.SelectCommand = "SELECT pj_id FROM [projects] where pj_code = '" + lblProjectCode.Text + "' and pj_status = '" + Request.QueryString["status"] + "'"; SqlDataSource6.DataBind(); DataView dv1 = (DataView)SqlDataSource6.Select(DataSourceSelectArguments.Empty); //keep project code in cookie for usage in follwing pages mgCookie.UpdateCookies("pj_id", dv1.Table.Rows[0]["pj_id"].ToString()); Response.Redirect("project_filter.aspx"); } }