コード例 #1
0
        /*private String text, qType, qClassify, qContent, qOptionalAnswer, qModelAnswer;
         * private Boolean formatFlag, isContent;
         * private Byte difficultyCoefficient;
         * private Int32 score;
         * private StringBuilder errorIds;
         * private List<Question> readyQs;
         *
         * public Dictionary<String, String> ImportDocx(String filePath)
         * {
         *
         *  Dictionary<String, String> dic;
         *
         *  dic = new Dictionary<String, String>();
         *  dic.Add("Status", "0");
         *  dic.Add("Data", "");
         *  dic.Add("Message", "");
         *
         *  try
         *  {
         *
         *      List<DocxParagraph> docxPara;
         *      const String qTypes = "单选题;多选题;判断题;公文改错题;计算题;案例分析题;问答题;";
         *      DateTime now;
         *      Regex typeRegex, contentRegex1, contentRegex2, optionalAnswerRegex, modelAnswerRegex,
         *          difficultyCoefficientRegex, scoreRegex, digitRegex;
         *      Int32 i1, i2, len, qId, qcId;
         *      List<QuestionClassify> qcs;
         *      QuestionClassify classify;
         *
         *      formatFlag = true;
         *      errorIds = new StringBuilder();
         *
         *      docxPara = OpenXmlDocHelper.GetDocxParagraphs(filePath);
         *
         *      now = DateTime.Now;
         *
         *      typeRegex = new Regex(@"^题型[::]{1}");
         *      contentRegex1 = new Regex(@"^\s*\d+[\..、]"); // 示例:1.
         *      contentRegex2 = new Regex(@"^\s*\(.+\)|^\s*(.+)"); // 示例:(一) (一)
         *      optionalAnswerRegex = new Regex(@"^\s*[a-zA-Z]{1}[\..、]{1}"); // 示例:A. B. C.
         *      modelAnswerRegex = new Regex(@"^\s*((答案|参考答案){1}[::]{1})|【答】");
         *      difficultyCoefficientRegex = new Regex(@"^难度系数[::]{1}\d{1}");
         *      scoreRegex = new Regex(@"^分数[::]{1}\d+$");
         *      digitRegex = new Regex(@"\d+");
         *
         *      qType = "";
         *      qClassify = "";
         *      qContent = "";
         *      qOptionalAnswer = "";
         *      qModelAnswer = "";
         *      isContent = true;
         *
         *      readyQs = new List<Question>();
         *      qcs = new List<QuestionClassify>();
         *
         *      // 获取数据编号
         *      qId = GetQId();
         *      qcId = GetQCId();
         *
         *      difficultyCoefficient = 0;
         *      score = 0;
         *
         *      foreach (var para in docxPara)
         *      {
         *
         *          text = para.Text;
         *
         #region 添加试题数据
         *
         *          switch (qType)
         *          {
         *              case "单选题":
         *              case "多选题":
         *
         *                  if (qModelAnswer != "")
         *                  {
         *                      // 格式化单选题/多选题的答案
         *                      qOptionalAnswer = FormatOptionalAnswer(qOptionalAnswer);
         *                      qModelAnswer = FormatModelAnswer(qModelAnswer);
         *
         *                      AddQuestion(qId, qcId);
         *                  }
         *                  break;
         *              case "判断题":
         *              case "计算题":
         *              case "案例分析题":
         *              case "问答题":
         *
         *                  if ((contentRegex1.IsMatch(text) || typeRegex.IsMatch(text))
         *                      && qModelAnswer != "")
         *                  {
         *                      AddQuestion(qId, qcId);
         *                  }
         *
         *                  break;
         *
         *              case "公文改错题":
         *
         *                  if ((contentRegex2.IsMatch(text) || typeRegex.IsMatch(text))
         *                      && qModelAnswer != "")
         *                  {
         *                      AddQuestion(qId, qcId);
         *                  }
         *
         *                  break;
         *
         *              default:
         *                  break;
         *          }
         #endregion
         *
         #region 判断是否为分类行
         *
         *          // 此行为分类行
         *          if (text.IndexOf("分类:") == 0)
         *          {
         *              //TODO:添加分类数据,记录分类编号
         *              qClassify = text.Substring(3);
         *
         *              // 判断分类是否存在
         *              classify = olsEni.QuestionClassifies.SingleOrDefault(model => model.QC_Name == qClassify);
         *
         *              // 如果不存在,则新增
         *              if (null == classify)
         *              {
         *
         *                  qcs.Add(new QuestionClassify()
         *                  {
         *                      QC_Id = qcId,
         *                      QC_Name = qClassify,
         *                      QC_Level = "000" + qcId.ToString(),
         *                      QC_AddTime = now,
         *                      QC_Status = 4
         *                  });
         *                  qcId += 1;
         *              }
         *              else
         *              {
         *                  qcId = classify.QC_Id;
         *              }
         *
         *              continue;
         *          }
         *
         #endregion
         *
         #region 判断是否为题型行
         *
         *          // 此行为题型行
         *          if (typeRegex.IsMatch(text))
         *          {
         *
         *              qType = text.Substring(3);
         *              qType = qType.Replace("单项选择题", "单选题");
         *              qType = qType.Replace("多项选择题", "多选题");
         *
         *              if (qTypes.IndexOf(qType) == -1)
         *              {
         *                  //TODO:返回,提示“当前题型不支持导入”
         *                  dic["Message"] = "题型“" + qType + "”不支持导入。";
         *                  return dic;
         *              }
         *
         *              continue;
         *          }
         *
         #endregion
         *
         #region 判断是否为难度系数行
         *
         *          if (difficultyCoefficientRegex.IsMatch(text))
         *          {
         *              difficultyCoefficient = Convert.ToByte(digitRegex.Match(text).Value);
         *              continue;
         *          }
         *
         #endregion
         *
         #region 判断是否为分数行
         *
         *          if (scoreRegex.IsMatch(text))
         *          {
         *              score = Convert.ToInt32(digitRegex.Match(text).Value);
         *              continue;
         *          }
         *
         #endregion
         *
         #region 判断是否为试题内容行
         *
         *          //TODO:记录试题内容
         *          switch (qType)
         *          {
         *              case "单选题":
         *              case "多选题":
         *              case "判断题":
         *
         *                  if (contentRegex1.IsMatch(text))
         *                  {
         *
         *                      // 提取标准答案
         *                      text = contentRegex1.Replace(text, "");
         *                      qContent = text;
         *                      qContent = qContent.Replace("(", "(");
         *                      qContent = qContent.Replace(")", ")");
         *
         *                      i1 = qContent.LastIndexOf("(");
         *                      i2 = qContent.LastIndexOf(")");
         *
         *                      if (i1 == -1 || i2 == -1)
         *                      {
         *                          //TODO:返回提示格式错误
         *                          dic["Message"] = "题型格式有误。";
         *                          return dic;
         *                      }
         *
         *                      len = i2 - i1 - 1;
         *                      qModelAnswer = qContent.Substring(i1 + 1, len);
         *                      if (qModelAnswer != "")
         *                      {
         *                          qContent = qContent.Replace(qModelAnswer, "  ");
         *                          qModelAnswer = qModelAnswer.Trim();
         *                      }
         *                      else // 避免模板中没有设置答案时不添加试题
         *                      {
         *                          qModelAnswer = " ";
         *                      }
         *
         *                      continue;
         *
         *                  }
         *
         *                  break;
         *
         *              case "公文改错题":
         *              case "计算题":
         *              case "案例分析题":
         *              case "问答题":
         *
         *                  // 公文改错题;计算题;案例分析题;问答题;
         *                  // 判断是否为标准答案行
         *                  if (modelAnswerRegex.IsMatch(text))
         *                  {
         *
         *                      isContent = false;
         *
         *                      text = modelAnswerRegex.Replace(text, "");
         *                  }
         *
         *                  if (isContent)
         *                  {
         *
         *                      if ("公文改错题" == qType)
         *                      {
         *                          text = contentRegex2.Replace(text, "");
         *                      }
         *                      else
         *                      {
         *                          text = contentRegex1.Replace(text, "");
         *                      }
         *                      qContent += text + "\\r\\n";
         *                  }
         *
         *                  break;
         *
         *              default:
         *
         *                  break;
         *          }
         *
         #endregion
         *
         #region 判断是否为试题答案行
         *
         *          switch (qType)
         *          {
         *
         *              case "单选题":
         *              case "多选题":
         *
         *                  // 单选题;多选题;
         *                  // 判断是否为备选答案行
         *                  if (optionalAnswerRegex.IsMatch(text))
         *                  {
         *
         *                      qOptionalAnswer += text + " ";
         *                  }
         *
         *                  break;
         *
         *              case "公文改错题":
         *              case "计算题":
         *              case "案例分析题":
         *              case "问答题":
         *
         *                  if (!isContent)
         *                  {
         *                      //TODO:记录试题答案
         *                      qModelAnswer += text + "\\r\\n";
         *                  }
         *
         *                  break;
         *
         *              default:
         *                  break;
         *          }
         *
         #endregion
         *
         *      }
         *
         *      AddQuestion(qId, qcId);
         *
         *      foreach (var qc in qcs)
         *      {
         *          olsEni.QuestionClassifies.Add(qc);
         *      }
         *
         *      olsEni.SaveChanges();
         *
         *      foreach (var model in readyQs)
         *      {
         *          olsEni.Questions.Add(model);
         *      }
         *
         *      olsEni.SaveChanges();
         *
         *
         *      dic["Status"] = "1";
         *
         *      if (formatFlag)
         *      {
         *          dic["Message"] = "试题模板数据存在错误(" + errorIds.Remove(errorIds.Length - 2, 2).ToString() + ")。";
         *      }
         *
         *      return dic;
         *  }
         *  catch (Exception ex)
         *  {
         *      dic["Message"] = StaticHelper.GetExceptionMessageAndRecord(ex);
         *      return dic;
         *  }
         * }
         *
         * private void AddQuestion(Int32 qId, Int32 qcId)
         * {
         *
         *  qId += 1;
         *
         *  readyQs.Add(new Question()
         *  {
         *      Q_Id = qId,
         *      Q_Type = qType,
         *      QC_Id = qcId,
         *      Q_DifficultyCoefficient = difficultyCoefficient,
         *      Q_Score = SetDefaultScore(qType, score),
         *      Q_Content = qContent,
         *      Q_OptionalAnswer = qOptionalAnswer,
         *      Q_ModelAnswer = qModelAnswer,
         *      Q_AddTime = now,
         *      Q_Status = 4
         *  });
         *
         *  // 标识数据错误
         *  if (qOptionalAnswer == "{}" || qModelAnswer == "[]")
         *  {
         *      formatFlag = true;
         *      errorIds.Append(qId + ", ");
         *  }
         *
         *  difficultyCoefficient = 0;
         *  score = 0;
         *  qContent = "";
         *  qOptionalAnswer = "";
         *  qModelAnswer = "";
         *  isContent = true;
         * }*/

        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest, Int32 qcId)
        {
            DataTablesResponse  dtResponse;
            QuestionClassify    qc;
            UModel <Question>   umodel;
            List <SqlParameter> sps;
            List <Question>     ms;

            umodel = new UModel <Question>(dtRequest, "Questions", "Q_Id");

            sps = new List <SqlParameter>();
            if (0 != qcId)
            {
                sps.Add(new SqlParameter("@QC_Id", qcId));
            }

            dtResponse = umodel.GetList(sps, "Q_Status", new String[] { "QC_Name" });

            ms = (List <Question>)dtResponse.data;
            foreach (var m1 in ms)
            {
                qc = olsEni.QuestionClassifies.SingleOrDefault(m => m.QC_Id == m1.QC_Id);
                if (null == qc)
                {
                    m1.QC_Name = "";
                    continue;
                }

                m1.QC_Name = qc.QC_Name;
            }

            return(dtResponse);
        }
コード例 #2
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest, String taskName, DateTime beginTime, DateTime endTime)
        {
            String             sql;
            DataTablesResponse dtResponse;
            UModel <VMExaminationTaskStatistic> umodel;
            List <SqlParameter> sps;

            umodel = new UModel <VMExaminationTaskStatistic>(dtRequest, "ExaminationTaskStatistic", "ETS_PaperTemplateId");

            sql = "SELECT * FROM ExaminationTaskStatistic ";

            sps = new List <SqlParameter>();
            if (taskName != "")
            {
                sps.Add(new SqlParameter("@LIKE_ETS_TaskName", "%" + taskName + "%"));
            }

            if (beginTime.Year != 1 && endTime.Year != 1)
            {
                endTime   = endTime.AddHours(23).AddMinutes(59).AddSeconds(59);
                beginTime = beginTime.AddSeconds(-1);
                sps.Add(new SqlParameter("@GT_ETS_PaperTemplateDate", beginTime));
                sps.Add(new SqlParameter("@LT_ETS_PaperTemplateDate", endTime));
            }

            dtResponse = umodel.GetList(sql, sps);


            return(dtResponse);
        }
コード例 #3
0
        internal DataTablesResponse ListDetailDataTablesAjax(DataTablesRequest dtRequest, Int32 uId, String taskName, DateTime beginTime, DateTime endTime)
        {
            String                     sql;
            DataTablesResponse         dtResponse;
            List <SqlParameter>        sps;
            UModel <VMUserScoreDetail> umodel;

            umodel = new UModel <VMUserScoreDetail>(dtRequest, "UserScoreDetails", "USD_UserId");

            sql = "SELECT * FROM UserScoreDetails ";

            sps = new List <SqlParameter>();
            sps.Add(new SqlParameter("@EQ_USD_UserId", uId));

            if (taskName != "")
            {
                sps.Add(new SqlParameter("@LIKE_USD_TaskName", "%" + taskName + "%"));
            }

            if (beginTime.Year != 1 && endTime.Year != 1)
            {
                endTime   = endTime.AddHours(23).AddMinutes(59).AddSeconds(59);
                beginTime = beginTime.AddSeconds(-1);
                sps.Add(new SqlParameter("@GT_USD_StartTime", beginTime));
                sps.Add(new SqlParameter("@LT_USD_StartTime", endTime));
            }

            dtResponse = umodel.GetList(sql, sps);

            return(dtResponse);
        }
コード例 #4
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
        {
            DataTablesResponse dtResponse;
            UModel <Duty>      umodel;

            umodel     = new UModel <Duty>(dtRequest, "Duties", "Du_Id");
            dtResponse = umodel.GetList("Du_Status", "Du_Sort");

            return(dtResponse);
        }
コード例 #5
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
        {
            DataTablesResponse       dtResponse;
            UModel <ExaminationTask> umodel;

            umodel     = new UModel <ExaminationTask>(dtRequest, "ExaminationTasks", "ET_Id");
            dtResponse = umodel.GetList("ET_Status");

            return(dtResponse);
        }
コード例 #6
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
        {
            DataTablesResponse        dtResponse;
            UModel <QuestionClassify> umodel;

            umodel     = new UModel <QuestionClassify>(dtRequest, "QuestionClassifies", "QC_Id");
            dtResponse = umodel.GetList("QC_Status");

            return(dtResponse);
        }
コード例 #7
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
        {
            DataTablesResponse            dtResponse;
            UModel <LearningDataCategory> umodel;

            umodel     = new UModel <LearningDataCategory>(dtRequest, "LearningDataCategories", "LDC_Id");
            dtResponse = umodel.GetList("LDC_Status", "LDC_Sort");

            return(dtResponse);
        }
コード例 #8
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
        {
            DataTablesResponse dtResponse;
            UModel <Role>      umodel;

            umodel     = new UModel <Role>(dtRequest, "Roles", "R_Id");
            dtResponse = umodel.GetList("R_Status");

            return(dtResponse);
        }
コード例 #9
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
        {
            DataTablesResponse          dtResponse;
            UModel <PermissionCategory> umodel;

            umodel     = new UModel <PermissionCategory>(dtRequest, "PermissionCategories", "PC_Id");
            dtResponse = umodel.GetList("PC_Status");

            return(dtResponse);
        }
コード例 #10
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
        {
            DataTablesResponse  dtResponse;
            UModel <Department> umodel;

            umodel     = new UModel <Department>(dtRequest, "Departments", "D_Id");
            dtResponse = umodel.GetList("D_Status", "D_Sort");

            return(dtResponse);
        }
コード例 #11
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest, Byte mode)
        {
            DataTablesResponse       dtResponse;
            List <SqlParameter>      sps;
            UModel <ExaminationTask> umodel;

            sps = new List <SqlParameter>();
            sps.Add(new SqlParameter("@ET_Mode", mode));
            umodel     = new UModel <ExaminationTask>(dtRequest, "ExaminationTasks", "ET_Id");
            dtResponse = umodel.GetList(sps, "ET_Status");

            return(dtResponse);
        }
コード例 #12
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
        {
            DataTablesResponse dtResponse;
            UModel <SystemLog> umodel;
            List <SystemLog>   ms;

            umodel     = new UModel <SystemLog>(dtRequest, "SystemLogs", "SL_Id");
            dtResponse = umodel.GetList("SL_Status");

            ms = (List <SystemLog>)dtResponse.data;
            dtResponse.data = ms;

            return(dtResponse);
        }
コード例 #13
0
        internal DataTablesResponse ListDetailDataTablesAjax(DataTablesRequest dtRequest, Int32 uId)
        {
            DataTablesResponse         dtResponse;
            List <SqlParameter>        sps;
            UModel <VMUserScoreDetail> umodel;

            umodel = new UModel <VMUserScoreDetail>(dtRequest, "UserScoreDetails", "USD_UserId");

            sps = new List <SqlParameter>();
            sps.Add(new SqlParameter("@USD_UserId", uId));
            dtResponse = umodel.GetList("SELECT * FROM UserScoreDetails ", sps);

            return(dtResponse);
        }
コード例 #14
0
        public DataTablesResponse ListDataTablesAjaxStudent(DataTablesRequest dtRequest, Int32 uId, Byte etType, Byte pageType)
        {
            DataTablesResponse dtResponse;
            UModel <VMExaminationStudentPaperTemplate> umodel;
            List <SqlParameter> sps;

            umodel = new UModel <VMExaminationStudentPaperTemplate>(dtRequest, "ExaminationStudentPaperTemplates", "ESPT_PaperTemplateId");
            sps    = new List <SqlParameter>();
            sps.Add(new SqlParameter("@EQ_ESPT_UserId", uId));
            sps.Add(new SqlParameter("@EQ_ESPT_TaskType", etType));
            sps.Add(new SqlParameter("@EQ_ESPT_PageType", pageType));
            dtResponse = umodel.GetList(sps);

            return(dtResponse);
        }
コード例 #15
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest, Int32 ldcId)
        {
            DataTablesResponse    dtResponse;
            UModel <LearningData> umodel;
            List <SqlParameter>   sps;

            sps = new List <SqlParameter>();
            if (0 != ldcId)
            {
                sps.Add(new SqlParameter("@LDC_Id", ldcId));
            }

            umodel     = new UModel <LearningData>(dtRequest, "LearningDatas", "LD_Id");
            dtResponse = umodel.GetList(sps, "LD_Status", "LD_Sort");

            return(dtResponse);
        }
コード例 #16
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest, Byte type, Byte enabled, Int32 uId)
        {
            String                   sql;
            DataTablesResponse       dtResponse;
            List <SqlParameter>      sps;
            UModel <ExaminationTask> umodel;

            sql = "SELECT et.* FROM ExaminationTasks et LEFT JOIN ExaminationTaskAttendees eta ON et.ET_Id = eta.ET_Id ";
            sps = new List <SqlParameter>();
            sps.Add(new SqlParameter("@ET_Type", type));
            sps.Add(new SqlParameter("@ET_Enabled", enabled));
            sps.Add(new SqlParameter("@U_Id", uId));
            umodel     = new UModel <ExaminationTask>(dtRequest, "ExaminationTasks", "ET_Id");
            dtResponse = umodel.GetList(sql, sps, "ET_Status");

            return(dtResponse);
        }
コード例 #17
0
        public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest, Int32 departmentId)
        {
            String              sql;
            DataTablesResponse  dtResponse;
            List <SqlParameter> sps;
            UModel <User>       umodel;
            List <User>         ms;

            umodel = new UModel <User>(dtRequest, "Users", "U_Id");

            sps = new List <SqlParameter>();
            if (0 != departmentId)
            {
                sps.Add(new SqlParameter("@D_Id", departmentId));
            }

            sql =
                "SELECT * FROM " +
                "    (" +
                "        SELECT  u.U_Id U_Id, " +
                "                u.U_Name U_Name, " +
                "                u.U_IdCardNumber U_IdCardNumber, " +
                "                u.U_AddTime U_AddTime, " +
                "                '**********' U_Password, " +
                "                u.U_Status U_Status, " +
                "                u.U_Sort U_Sort, " +
                "                d.D_Id D_Id, " +
                "                d.D_Name D_Name, " +
                "                D_Sort, " +
                "                du.Du_Name " +
                "        FROM    Users u " +
                "                LEFT JOIN User_Department ud ON u.U_Id = ud.U_Id" +
                "                LEFT JOIN Departments d ON d.D_Id = ud.D_Id " +
                "                LEFT JOIN Duties du ON du.Du_Id = u.Du_Id " +
                "    ) TmpTable ";
            umodel     = new UModel <User>(dtRequest, "Users", "U_Id");
            dtResponse = umodel.GetList(sql, sps, "U_Status", new String[] { "D_Sort", "U_Sort" }, new String[] { "Du_Name" });

            ms = (List <User>)dtResponse.data;
            dtResponse.data = ms;

            return(dtResponse);
        }
コード例 #18
0
        internal DataTablesResponse ListSummaryDataTablesAjax(DataTablesRequest dtRequest, Int32 dId = 0)
        {
            DataTablesResponse          dtResponse;
            UModel <VMUserScoreSummary> umodel;
            List <SqlParameter>         sps;

            umodel = new UModel <VMUserScoreSummary>(dtRequest, "UserScoreSummaries", "USS_UserId");

            if (dId == 0)
            {
                dtResponse = umodel.GetList();
            }
            else
            {
                sps = new List <SqlParameter>();
                sps.Add(new SqlParameter("@USS_DepartmentId", dId));

                dtResponse = umodel.GetList(sps);
            }

            return(dtResponse);
        }