/microsoft/LeeCreek/src/LeeCreek1.0/Web.Lee/sysask/paper1.aspx.cs

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%\">&nbsp;</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("&nbsp;{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("&nbsp;{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));

        }

      



    }

}