/microsoft/LeeCreek/src/LeeCreek1.0/Web.Lee/sysask/paper1.aspx.cs
C# | 197 lines | 109 code | 25 blank | 63 comment | 14 complexity | 5b2db56070adc6f8d1ce007c4b400aff MD5 | raw file
Possible License(s): GPL-3.0, LGPL-3.0, LGPL-2.1, GPL-2.0
- using System;
- using System.Collections;
- using System.Data;
- using DAL;
- using Utility;
- using System.Text;
- using BLL;
-
- public partial class sysask_paper1 : UserPage
- {
- public string arrQustion = "";
- /// <summary>
- /// ??id
- /// </summary>
- public int Tid=1;
-
- Lee_comm lee = new Lee_comm();
- PapersBll papersbll=new PapersBll();
- protected void Page_Load(object sender, EventArgs e)
- {
- lee.GetPaper(EmpId);
- Tid = Utils.StrToInt(Request["tid"], 1);
- // btnSave.Text = lee.BtnSaveText(CorpId, Tid);
- lee.BtnText(CorpId, Tid,EmpId, btnSave);
- // System.Web.UI.WebControls.Button
- arrQustion = ArrQustion();
- // hidqtype1.Value=DBHelper.GetScalar("select ")
- }
- /// <summary>
- /// ?????
- /// </summary>
- /// <returns></returns>
- public string GetQuestion()
- {
- //select q.cateid,q.catetitle,r.backdrop
- //from lee_qstbackdrop q
- //left join lee_rsltbackdrop r on q.cateid=r.cateid and r.empid=30
- //where q.flag=1
- //string sql = " select q.cateid,q.catetitle,r.backdrop ";
- //sql += " from lee_qstbackdrop q ";
- //sql += " left join lee_rsltbackdrop r on q.cateid=r.cateid and r.empid= " + EmpId;
- //sql += " where q.flag=1 ";
- DataTable dt = DBHelper.GetDataView("select * from lee_qstchoice where flag=1 and TID=" + Tid).Table;
- StringBuilder sb = new StringBuilder();
-
- if (dt.Rows.Count > 0)
- {
- hidqtype1.Value = dt.Rows[0]["TID"].ToString();
- foreach (DataRow dr in dt.Rows)
- {
- sb.AppendFormat("<tr>");
- sb.AppendFormat(" <td colspan=\"3\" height=\"60\">" + "\r\n");
- sb.AppendFormat(" <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">" + "\r\n");
- sb.AppendFormat("<tr height=\"30\">" + "\r\n");
- sb.AppendFormat(" <td width=\"2%\" align=\"center\" class=\"text1\">{0}?</td>" + "\r\n", GetSafeData.ValidateDataRow_S(dr, "QNum").Trim());
- sb.AppendFormat(" <td colspan=\"4\" class=\"text1\">{0}</td>" + "\r\n", dr["Qname"]);
- sb.AppendFormat(" </tr>" + "\r\n");
- sb.AppendFormat(" <tr><td width=\"2%\"> </td><td><div id=qstdiv_{2} class=\"checkbox\"><input type=\"hidden\" id=\"hidnum_{2}\" value=\"{1}\" /><input type=\"hidden\" name=\"hidqst\" id=\"hidqst\" value=\"{0}\" /><ul>" + "\r\n", dr["QID"], dr["OptionNum"], GetSafeData.ValidateDataRow_S(dr, "QNum").Trim());
- sb.Append(GetQOpt(Utils.StrToInt(dr["QID"], 0), Utils.StrToInt(dr["OptionNum"],0)) + "\r\n");
- sb.AppendFormat(" </ul></div></td></tr>" + "\r\n");
- sb.AppendFormat(" </table></td>" + "\r\n");
- sb.AppendFormat(" </tr>" + "\r\n");
- }
- }
- return sb.ToString();
- }
- /// <summary>
- /// ?????
- /// </summary>
- /// <param name="qid">??id</param>
- /// <param name="optionnum">????</param>
- /// <returns></returns>
- public string GetQOpt(int qid,int optionnum)
- {
- StringBuilder sb = new StringBuilder();
- DataTable dt = DBHelper.GetDataView("select * from lee_optchoice where QID=" + qid).Table;
-
- DataTable dt2 = DBHelper.GetDataView("select * from lee_rsltchoice where empid="+EmpId+" and tid="+Tid+" and qid="+qid).Table;
-
- if (dt.Rows.Count > 0)
- {
-
- for (int i = 0; i < dt.Rows.Count; i++)
- {
-
- for (int j = 0; j < dt2.Rows.Count; j++)
- {
- if (Utils.StrToInt(dt.Rows[i]["OID"], -1) == Utils.StrToInt(dt2.Rows[j]["CheckedOpt"], 0))
- {
- sb.AppendFormat("<li><input type=\"checkbox\" name=\"select_{0}\" id=\"select_{0}\" checked=true onClick=\"chooseOne(this,{0},{3});\" value=\"{1}\" />{2}?", qid, dt.Rows[i]["OID"], i + 1,optionnum);
- sb.AppendFormat(" {0}</li>" + "\r\n", dt.Rows[i]["OptionName"]);
- i++;
- }
-
- }
- if(i<dt.Rows.Count){
- sb.AppendFormat("<li><input type=\"checkbox\" name=\"select_{0}\" id=\"select_{0}\" onClick=\"chooseOne(this,{0},{3});\" value=\"{1}\" />{2}?", qid, dt.Rows[i]["OID"], i + 1, optionnum);
- sb.AppendFormat(" {0}</li>" + "\r\n", dt.Rows[i]["OptionName"]);
-
- }
-
- }
- }
- return sb.ToString();
- }
- /// <summary>
- /// ?????????
- /// </summary>
- /// <param name="cateId">??id</param>
- /// <returns></returns>
- public string ArrQustion()
- {
- StringBuilder sb = new StringBuilder();
- DataTable dt = DBHelper.GetDataView("select QID,QNum from lee_qstchoice where flag=1 and TID=" + Tid).Table;
-
- if (dt.Rows.Count > 0)
- {
-
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- arrQustion += "" + GetSafeData.ValidateDataRow_S(dt.Rows[i], "QNum").Trim() + ",";
- }
- if (arrQustion.Length>1)
- {
- arrQustion = arrQustion.Substring(0, arrQustion.Length - 1);
- }
- }
- return arrQustion;
- }
-
- /// <summary>
- /// ??
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- protected void btnSave_Click(object sender, EventArgs e)
- {
-
- bool flag = false;
-
- string qstr = Request["hidqst"];
-
- string[] arrQst = {};// ????
-
- if (qstr.Length > 0)
- {
- arrQst = qstr.Split(',');
- }
-
- if (arrQst.Length > 0)
- {
- #region ????
- //DBHelper.ExecuteNonQuery("delete from lee_rsltchoice where empid=" + EmpId+" and Tid="+Tid);
- //foreach (var s in arrQ)
- //{
- // string strOpt = Request["select_" + s];
-
- // if (!string.IsNullOrEmpty(strOpt))
- // {
- // string[] arrOpt = { };
- // if (strOpt.Length > 0)
- // {
- // arrOpt = strOpt.Split(',');
- // }
-
- // foreach (var opt in arrOpt)
- // {
- // var hash = new Hashtable
- // {
- // {"CorpId", CorpId},
- // {"TID", Tid},
- // {"QID", s},
- // {"EmpId", EmpId},
- // {"CheckedOpt",opt}
- // };
- // if (DB_DML.Insert("lee_rsltchoice", hash) > 0)
- // {
- // flag = true;
- // }
- // }
- // }
- //}
- #endregion
-
- flag = papersbll.SaveChoice(CorpId, EmpId, Tid, arrQst, "select_");
-
- }
-
- if (flag && lee.SetTestStaus(EmpId, 1, Tid) > 0)
- {
- lee.GetNextPaper(CorpId, EmpId, Tid);
- //JsHelper.AlertAndRedirect("????", lee.GetNextPaper(CorpId,EmpId));
- }
-
-
- }
- }