private Object[] GetUserStatistics(DataTablesRequest dtRequest, Int32 eptId)
{
Int32 total, filter;
String sql, countSql;
DataTable dataTable;
Object[] sqlConditions;
List <VMExaminationTaskUserStatistic> ms;
List <SqlParameter> sps;
sql = "SELECT * FROM ExaminationTaskUserStatistic WHERE ETUS_PaperTemplateId = @eptId ";
sqlConditions = GetSqlCondition(sql, dtRequest);
sql = (String)sqlConditions[0];
sps = (List <SqlParameter>)sqlConditions[1];
sps.Add(new SqlParameter("@eptid", eptId));
dataTable = olsDbo.GetDataTableWithStart(sql, sps, dtRequest.Length, dtRequest.Start);
ms = (List <VMExaminationTaskUserStatistic>) ModelConvert <VMExaminationTaskUserStatistic> .ConvertToModel(dataTable);
countSql = sql.Replace("SELECT * FROM ", "SELECT COUNT(ETUS_TaskId) FROM ");
total = Convert.ToInt32(olsDbo.ExecuteSqlScalar(countSql, sps));
filter = Convert.ToInt32(olsDbo.ExecuteSqlScalar(countSql, sps));
return(new Object[] { ms, total, filter });
}
/*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, 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;
}
private Object[] GetModels(DataTablesRequest dtRequest)
{
Int32 total, filter;
String sql, orderSql, countSql;
DataTable dataTable;
Object[] sqlConditions;
List <T> ms;
List <SqlParameter> sps;
sql = "SELECT * FROM " + tableName + " ";
sqlConditions = GetSqlCondition(sql);
sql = (String)sqlConditions[0];
sps = (List <SqlParameter>)sqlConditions[1];
orderSql = (String)sqlConditions[2];
dataTable = olsDbo.GetDataTableWithStart(sql + orderSql, sps, dtRequest.Length, dtRequest.Start);
ms = (List <T>) ModelConvert <T> .ConvertToModel(dataTable);
countSql = sql.Replace("SELECT * FROM ", "SELECT COUNT(" + idFieldName + ") FROM ");
total = Convert.ToInt32(olsDbo.ExecuteSqlScalar(countSql, sps));
filter = Convert.ToInt32(olsDbo.ExecuteSqlScalar(countSql, sps));
return(new Object[] { ms, total, filter });
}
public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest, Int32 uId, Byte type, Byte paperTemplateStatus)
{
DataTablesResponse dtResponse;
Int32 recordsTotal, recordsFiltered;
String orderColumn;
Object[] modelData;
dtResponse = new DataTablesResponse();
dtResponse.draw = dtRequest.Draw;
recordsTotal = olsEni.ExaminationPaperTemplates.Count();
dtResponse.recordsTotal = recordsTotal;
orderColumn = dtRequest.Columns[dtRequest.OrderColumn].Name;
modelData = GetModels(dtRequest, uId, type, paperTemplateStatus);
recordsFiltered = (Int32)modelData[0];
dtResponse.recordsFiltered = recordsFiltered;
dtResponse.data = (List <ExaminationPaperTemplate>)modelData[1];
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);
}
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);
}
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 <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 <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 <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 <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 <Department> umodel;
umodel = new UModel <Department>(dtRequest, "Departments", "D_Id");
dtResponse = umodel.GetList("D_Status", "D_Sort");
return(dtResponse);
}
public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest)
{
DataTablesResponse dtResponse;
Int32 recordsTotal, recordsFiltered;
String whereSql, orderColumn;
List <ExaminationPaper> ms;
dtResponse = new DataTablesResponse();
dtResponse.draw = dtRequest.Draw;
recordsTotal = olsEni.ExaminationPapers.Count();
dtResponse.recordsTotal = recordsTotal;
//TODO:指定筛选条件
whereSql = "";
foreach (var col in dtRequest.Columns)
{
if ("" != col.Name)
{
whereSql += col.Name + "||";
}
}
//TODO:指定排序列
orderColumn = dtRequest.Columns[dtRequest.OrderColumn].Name;
ms =
olsEni
.ExaminationPapers
.OrderBy(model => model.EP_Id)
.Where(model =>
model.EP_UserName.Contains(dtRequest.SearchValue) &&
model.EP_Status != (Byte)Status.Delete)
.ToList();
recordsFiltered = ms.Count();
dtResponse.recordsFiltered = recordsFiltered;
if (-1 != dtRequest.Length)
{
ms =
ms
.Skip(dtRequest.Start).Take(dtRequest.Length)
.ToList();
}
dtResponse.data = ms;
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);
}
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);
}
protected DataTablesRequest GetDataTablesRequest()
{
DataTablesRequest dtRequest;
Int32 i;
String data, orderable, searchable, searchRegex, orderDir;
List<DataTablesColumn> columns;
dtRequest = new DataTablesRequest();
dtRequest.Draw = Convert.ToInt32(Request["draw"]);
i = 0;
columns = new List<DataTablesColumn>();
while (null != Request["columns[" + i + "][name]"])
{
data = Request["columns[" + i + "][data]"];
orderable = Request["columns[" + i + "][orderable]"];
searchable = Request["columns[" + i + "][searchable]"];
searchRegex = Request["columns[" + i + "][search][regex]"];
columns.Add(new DataTablesColumn()
{
Data = data,
Name = Request["columns[" + i + "][name]"],
Orderable = orderable == "true" ? true : false,
Searchable = searchable == "true" ? true : false,
SearchValue = Request["columns[" + i + "][search][value]"],
SearchRegex = searchRegex == "true" ? true : false
});
i += 1;
}
dtRequest.Columns = columns;
dtRequest.Start = Convert.ToInt32(Request["start"]);
dtRequest.Length = Convert.ToInt32(Request["length"]);
dtRequest.OrderColumn = Convert.ToInt32(Request["order[0][column]"]);
orderDir = Request["order[0][dir]"];
dtRequest.OrderDir = "asc" == orderDir ? 0 : 1;
dtRequest.SearchValue = Request["search[value]"];
searchRegex = Request["search[regex]"];
dtRequest.SearchRegex = "true" == searchRegex ? true : false;
dtRequest.Status = null == Request["status"] ? Convert.ToByte(1) : Convert.ToByte(Request["status"]);
return dtRequest;
}
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 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, 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);
}
public DataTablesResponse ListUserDataTablesAjax(DataTablesRequest dtRequest, Int32 eptId)
{
DataTablesResponse dtResponse;
Int32 recordsTotal, recordsFiltered;
Object[] modelData;
List<VMExaminationTaskUserStatistic> ms;
modelData = GetUserStatistics(dtRequest, eptId);
ms = (List<VMExaminationTaskUserStatistic>)modelData[0];
recordsTotal = (Int32)modelData[1];
recordsFiltered = (Int32)modelData[2];
dtResponse = new DataTablesResponse();
dtResponse.draw = dtRequest.Draw;
dtResponse.recordsTotal = recordsTotal;
dtResponse.recordsFiltered = recordsFiltered;
dtResponse.data = ms;
return dtResponse;
}
public DataTablesResponse ListUserDataTablesAjax(DataTablesRequest dtRequest, Int32 eptId)
{
DataTablesResponse dtResponse;
Int32 recordsTotal, recordsFiltered;
Object[] modelData;
List <VMExaminationTaskUserStatistic> ms;
modelData = GetUserStatistics(dtRequest, eptId);
ms = (List <VMExaminationTaskUserStatistic>)modelData[0];
recordsTotal = (Int32)modelData[1];
recordsFiltered = (Int32)modelData[2];
dtResponse = new DataTablesResponse();
dtResponse.draw = dtRequest.Draw;
dtResponse.recordsTotal = recordsTotal;
dtResponse.recordsFiltered = recordsFiltered;
dtResponse.data = ms;
return(dtResponse);
}
protected Object[] GetSqlCondition(String sql, DataTablesRequest dtRequest)
{
String whereSql, orderSql;
List <SqlParameter> sps;
whereSql = "";
sps = new List <SqlParameter>();
//TODO:指定筛选条件
if ("" != dtRequest.SearchValue)
{
foreach (var col in dtRequest.Columns)
{
if ("" != col.Name)
{
whereSql += col.Name + " LIKE @" + col.Name + " OR ";
sps.Add(new SqlParameter("@" + col.Name, "%" + dtRequest.SearchValue + "%"));
}
}
}
if ("" != whereSql)
{
whereSql = whereSql.Substring(0, whereSql.Length - 3);
sql += sql.IndexOf("WHERE ") == -1 ? "WHERE " + whereSql : "AND (" + whereSql + ")";
}
//TODO:指定排序列
orderSql = dtRequest.Columns[dtRequest.OrderColumn].Name;
if ("" != orderSql)
{
orderSql += dtRequest.OrderDir == 0 ? " ASC" : " DESC";
sql += "ORDER BY " + orderSql;
}
return(new Object[] { sql, sps });
}
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);
}
/*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;
}
private Object[] GetUserStatistics(DataTablesRequest dtRequest, Int32 eptId)
{
Int32 total, filter;
String sql, countSql;
DataTable dataTable;
Object[] sqlConditions;
List<VMExaminationTaskUserStatistic> ms;
List<SqlParameter> sps;
sql = "SELECT * FROM ExaminationTaskUserStatistic WHERE ETUS_PaperTemplateId = @eptId ";
sqlConditions = GetSqlCondition(sql, dtRequest);
sql = (String)sqlConditions[0];
sps = (List<SqlParameter>)sqlConditions[1];
sps.Add(new SqlParameter("@eptid", eptId));
dataTable = olsDbo.GetDataTableWithStart(sql, sps, dtRequest.Length, dtRequest.Start);
ms = (List<VMExaminationTaskUserStatistic>)ModelConvert<VMExaminationTaskUserStatistic>.ConvertToModel(dataTable);
countSql = sql.Replace("SELECT * FROM ", "SELECT COUNT(ETUS_TaskId) FROM ");
total = Convert.ToInt32(olsDbo.ExecuteSqlScalar(countSql, sps));
filter = Convert.ToInt32(olsDbo.ExecuteSqlScalar(countSql, sps));
return new Object[] { ms, total, filter };
}
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;
Int32 recordsTotal, recordsFiltered;
String whereSql, orderColumn;
List<ExaminationPaper> ms;
dtResponse = new DataTablesResponse();
dtResponse.draw = dtRequest.Draw;
recordsTotal = olsEni.ExaminationPapers.Count();
dtResponse.recordsTotal = recordsTotal;
//TODO:指定筛选条件
whereSql = "";
foreach (var col in dtRequest.Columns)
{
if ("" != col.Name)
{
whereSql += col.Name + "||";
}
}
//TODO:指定排序列
orderColumn = dtRequest.Columns[dtRequest.OrderColumn].Name;
ms =
olsEni
.ExaminationPapers
.OrderBy(model => model.EP_Id)
.Where(model =>
model.EP_UserName.Contains(dtRequest.SearchValue)
&& model.EP_Status != (Byte)Status.Delete)
.ToList();
recordsFiltered = ms.Count();
dtResponse.recordsFiltered = recordsFiltered;
if (-1 != dtRequest.Length)
{
ms =
ms
.Skip(dtRequest.Start).Take(dtRequest.Length)
.ToList();
}
dtResponse.data = ms;
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;
}
protected Object[] GetSqlCondition(String sql, DataTablesRequest dtRequest)
{
String whereSql, orderSql;
List<SqlParameter> sps;
whereSql = "";
sps = new List<SqlParameter>();
//TODO:指定筛选条件
if ("" != dtRequest.SearchValue)
{
foreach (var col in dtRequest.Columns)
{
if ("" != col.Name)
{
whereSql += col.Name + " LIKE @" + col.Name + " OR ";
sps.Add(new SqlParameter("@" + col.Name, "%" + dtRequest.SearchValue + "%"));
}
}
}
if ("" != whereSql)
{
whereSql = whereSql.Substring(0, whereSql.Length - 3);
sql += sql.IndexOf("WHERE ") == -1 ? "WHERE " + whereSql : "AND (" + whereSql + ")";
}
//TODO:指定排序列
orderSql = dtRequest.Columns[dtRequest.OrderColumn].Name;
if ("" != orderSql)
{
orderSql += dtRequest.OrderDir == 0 ? " ASC" : " DESC";
sql += "ORDER BY " + orderSql;
}
return new Object[] { sql, sps };
}
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<PermissionCategory> umodel;
umodel = new UModel<PermissionCategory>(dtRequest, "PermissionCategories", "PC_Id");
dtResponse = umodel.GetList("PC_Status");
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 uId, Byte type, Byte paperTemplateStatus)
{
DataTablesResponse dtResponse;
Int32 recordsTotal, recordsFiltered;
String orderColumn;
Object[] modelData;
dtResponse = new DataTablesResponse();
dtResponse.draw = dtRequest.Draw;
recordsTotal = olsEni.ExaminationPaperTemplates.Count();
dtResponse.recordsTotal = recordsTotal;
orderColumn = dtRequest.Columns[dtRequest.OrderColumn].Name;
modelData = GetModels(dtRequest, uId, type, paperTemplateStatus);
recordsFiltered = (Int32)modelData[0];
dtResponse.recordsFiltered = recordsFiltered;
dtResponse.data = (List<ExaminationPaperTemplate>)modelData[1];
return dtResponse;
}
public Object[] GetModels(DataTablesRequest dtRequest, Int32 uId, Byte type, Byte paperTemplateStatus)
{
Int32 count;
ExaminationTask et;
ExaminationPaper ep;
Int32[] userIds;
List <Int32> usableEtIds;
List <ExaminationTask> ets;
List <ExaminationPaperTemplate> ms;
usableEtIds = new List <Int32>();
ets = olsEni
.ExaminationTasks
.Where(m =>
m.ET_Status == (Byte)Status.Available)
.ToList();
foreach (var et1 in ets)
{
userIds = JsonConvert.DeserializeObject <Int32[]>(et1.ET_Attendee);
if (userIds.Contains(uId))
{
usableEtIds.Add(et1.ET_Id);
}
}
count =
olsEni
.ExaminationPaperTemplates
.OrderBy(model => model.EPT_Id)
.Where(model =>
model.EPT_Status == (Byte)Status.Available &&
usableEtIds.Contains(model.ET_Id) &&
model.ET_Type == type &&
model.EPT_PaperTemplateStatus == paperTemplateStatus)
.Count();
ms =
olsEni
.ExaminationPaperTemplates
.OrderBy(model => model.EPT_Id)
.Where(model =>
model.EPT_Status == (Byte)Status.Available &&
usableEtIds.Contains(model.ET_Id) &&
model.ET_Type == type &&
model.EPT_PaperTemplateStatus == paperTemplateStatus)
.Skip(dtRequest.Start).Take(dtRequest.Length)
.ToList();
foreach (var m1 in ms)
{
et = ets.Single(m => m.ET_Id == m1.ET_Id);
m1.ET_Name = et.ET_Name;
m1.ET_Type = et.ET_Type;
// 获取已考试、已评分的试卷成绩
ep = olsEni.ExaminationPapers.SingleOrDefault(m => m.EPT_Id == m1.EPT_Id && m.EP_UserId == uId);
if (null == ep)
{
m1.EP_Score = "[未参与]";
continue;
}
else if (-1 == ep.EP_Score)
{
m1.EP_Score = "[未评分]";
m1.EP_PaperStatus = ep.EP_PaperStatus;
continue;
}
if ((Byte)StatisticType.Score == et.ET_StatisticType)
{
m1.EP_Score = ep.EP_Score + "分";
}
else if ((Byte)StatisticType.Number == et.ET_StatisticType)
{
m1.EP_Score = ep.EP_Score + "%";
}
}
return(new Object[] { count, ms });
}
public Object[] GetModels(DataTablesRequest dtRequest, Int32 uId, Byte type, Byte paperTemplateStatus)
{
Int32 count;
ExaminationTask et;
ExaminationPaper ep;
Int32[] userIds;
List<Int32> usableEtIds;
List<ExaminationTask> ets;
List<ExaminationPaperTemplate> ms;
usableEtIds = new List<Int32>();
ets = olsEni
.ExaminationTasks
.Where(m =>
m.ET_Status == (Byte)Status.Available)
.ToList();
foreach (var et1 in ets)
{
userIds = JsonConvert.DeserializeObject<Int32[]>(et1.ET_Attendee);
if (userIds.Contains(uId))
{
usableEtIds.Add(et1.ET_Id);
}
}
count =
olsEni
.ExaminationPaperTemplates
.OrderBy(model => model.EPT_Id)
.Where(model =>
model.EPT_Status == (Byte)Status.Available
&& usableEtIds.Contains(model.ET_Id)
&& model.ET_Type == type
&& model.EPT_PaperTemplateStatus == paperTemplateStatus)
.Count();
ms =
olsEni
.ExaminationPaperTemplates
.OrderBy(model => model.EPT_Id)
.Where(model =>
model.EPT_Status == (Byte)Status.Available
&& usableEtIds.Contains(model.ET_Id)
&& model.ET_Type == type
&& model.EPT_PaperTemplateStatus == paperTemplateStatus)
.Skip(dtRequest.Start).Take(dtRequest.Length)
.ToList();
foreach (var m1 in ms)
{
et = ets.Single(m => m.ET_Id == m1.ET_Id);
m1.ET_Name = et.ET_Name;
m1.ET_Type = et.ET_Type;
// 获取已考试、已评分的试卷成绩
ep = olsEni.ExaminationPapers.SingleOrDefault(m => m.EPT_Id == m1.EPT_Id && m.EP_UserId == uId);
if (null == ep)
{
m1.EP_Score = "[未参与]";
continue;
}
else if (-1 == ep.EP_Score)
{
m1.EP_Score = "[未评分]";
m1.EP_PaperStatus = ep.EP_PaperStatus;
continue;
}
if ((Byte)StatisticType.Score == et.ET_StatisticType)
{
m1.EP_Score = ep.EP_Score + "分";
}
else if ((Byte)StatisticType.Number == et.ET_StatisticType)
{
m1.EP_Score = ep.EP_Score + "%";
}
}
return new Object[] { count, ms };
}
public UModel(DataTablesRequest dtRequest, String tableName, String idFieldName)
{
this.dtRequest = dtRequest;
this.tableName = tableName;
this.idFieldName = idFieldName;
}
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;
}
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<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<Department> umodel;
umodel = new UModel<Department>(dtRequest, "Departments", "D_Id");
dtResponse = umodel.GetList("D_Status", "D_Sort");
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 ListDataTablesAjax(DataTablesRequest dtRequest, Int32 etId)
{
DataTablesResponse dtResponse;
Int32 recordsTotal, recordsFiltered;
String whereSql, orderColumn;
List <ExaminationPaperTemplate> ms;
ExaminationTask et;
// 获取练习模板列表数据
et = olsEni.ExaminationTasks.Single(m => m.ET_Id == etId);
if (et.ET_Type == (Byte)ExaminationTaskType.Exercise)
{
return(ListDataTablesAjaxStudent(etId, dtRequest, (Byte)ExaminationTaskType.Exercise, 2 /* 2:已考完 */));
}
dtResponse = new DataTablesResponse();
dtResponse.draw = dtRequest.Draw;
recordsTotal = olsEni.ExaminationPaperTemplates.Count();
dtResponse.recordsTotal = recordsTotal;
//TODO:指定筛选条件
whereSql = "";
foreach (var col in dtRequest.Columns)
{
if ("" != col.Name)
{
whereSql += col.Name + "||";
}
}
//TODO:指定排序列
orderColumn = dtRequest.Columns[dtRequest.OrderColumn].Name;
ms =
olsEni
.ExaminationPaperTemplates
.OrderBy(model => model.EPT_Id)
.Where(model =>
model.EPT_Status != (Byte)Status.Delete &&
model.ET_Id == etId)
.ToList();
recordsFiltered = ms.Count();
dtResponse.recordsFiltered = recordsFiltered;
if (-1 != dtRequest.Length)
{
ms =
ms
.Skip(dtRequest.Start).Take(dtRequest.Length)
.ToList();
}
foreach (var m1 in ms)
{
m1.ET_Name = olsEni.ExaminationTasks.Single(m => m.ET_Id == m1.ET_Id).ET_Name;
}
dtResponse.data = ms;
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;
}
public DataTablesResponse ListDataTablesAjax(DataTablesRequest dtRequest, Byte type, Byte enabled)
{
DataTablesResponse dtResponse;
List<SqlParameter> sps;
UModel<ExaminationTask> umodel;
sps = new List<SqlParameter>();
sps.Add(new SqlParameter("@ET_Type", type));
sps.Add(new SqlParameter("@ET_Enabled", enabled));
umodel = new UModel<ExaminationTask>(dtRequest, "ExaminationTasks", "ET_Id");
dtResponse = umodel.GetList(sps, "ET_Status");
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, Int32 etId)
{
DataTablesResponse dtResponse;
Int32 recordsTotal, recordsFiltered;
String whereSql, orderColumn;
List<ExaminationPaperTemplate> ms;
ExaminationTask et;
// 获取练习模板列表数据
et = olsEni.ExaminationTasks.Single(m => m.ET_Id == etId);
if (et.ET_Type == (Byte)ExaminationTaskType.Exercise)
{
return ListDataTablesAjaxStudent(etId, dtRequest, (Byte)ExaminationTaskType.Exercise, 2 /* 2:已考完 */);
}
dtResponse = new DataTablesResponse();
dtResponse.draw = dtRequest.Draw;
recordsTotal = olsEni.ExaminationPaperTemplates.Count();
dtResponse.recordsTotal = recordsTotal;
//TODO:指定筛选条件
whereSql = "";
foreach (var col in dtRequest.Columns)
{
if ("" != col.Name)
{
whereSql += col.Name + "||";
}
}
//TODO:指定排序列
orderColumn = dtRequest.Columns[dtRequest.OrderColumn].Name;
ms =
olsEni
.ExaminationPaperTemplates
.OrderBy(model => model.EPT_Id)
.Where(model =>
model.EPT_Status != (Byte)Status.Delete
&& model.ET_Id == etId)
.ToList();
recordsFiltered = ms.Count();
dtResponse.recordsFiltered = recordsFiltered;
if (-1 != dtRequest.Length)
{
ms =
ms
.Skip(dtRequest.Start).Take(dtRequest.Length)
.ToList();
}
foreach (var m1 in ms)
{
m1.ET_Name = olsEni.ExaminationTasks.Single(m => m.ET_Id == m1.ET_Id).ET_Name;
}
dtResponse.data = ms;
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;
}
