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);
}
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);
}
/*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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}
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);
}