private void BindData() { Entities.ExamScoreManageQuery query = new Entities.ExamScoreManageQuery(); #region 条件 DateTime dateVal = new DateTime(); if (PaperName != string.Empty) { query.PaperName = PaperName; } if (ExamProjectName != string.Empty) { query.ProjectName = ExamProjectName; } if (ExamPerson != string.Empty) { query.TrueName = ExamPerson; } if (Catage != string.Empty) { query.ExamCategory = Catage; } if (BeginTime != string.Empty && DateTime.TryParse(BeginTime, out dateVal)) { query.BeginTime = dateVal; } if (EndTime != string.Empty && DateTime.TryParse(EndTime, out dateVal)) { query.EndTime = dateVal; } if (CommonFunction.ObjectToInteger(Bgid) > 0) { query.BGIDS = Bgid; } #endregion DataTable dt = BLL.ExamOnline.Instance.GetExamScoreManage(query, " BeginTime Desc", BLL.PageCommon.Instance.PageIndex, PageSize, out RecordCount); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["isMarking"].ToString() == "0") { dt.Rows[i]["zhuguan"] = ""; } else { if (dt.Rows[i]["zhuguan"] == DBNull.Value) { dt.Rows[i]["zhuguan"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 1) == false) { dt.Rows[i]["Onlyselect"] = "-"; } else { if (dt.Rows[i]["Onlyselect"] == DBNull.Value) { dt.Rows[i]["Onlyselect"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 2) == false) { dt.Rows[i]["moreselect"] = "-"; } else { if (dt.Rows[i]["moreselect"] == DBNull.Value) { dt.Rows[i]["moreselect"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 4) == false) { dt.Rows[i]["panduan"] = "-"; } else { if (dt.Rows[i]["panduan"] == DBNull.Value) { dt.Rows[i]["panduan"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 3) == false) { dt.Rows[i]["zhuguan"] = "-"; } } repeaterTableList.DataSource = dt; repeaterTableList.DataBind(); } AjaxPager_Custs.PageSize = PageSize; AjaxPager_Custs.InitPager(RecordCount); }
private void BindData() { Entities.ExamScoreManageQuery query = new Entities.ExamScoreManageQuery(); #region 条件 DateTime dateVal = new DateTime(); if (PaperName != string.Empty) { query.PaperName = PaperName; } if (ExamProjectName != string.Empty) { query.ProjectName = ExamProjectName; } if (ExamPerson != string.Empty) { query.TrueName = ExamPerson; } if (Catage != string.Empty) { query.ExamCategory = Catage; } if (BeginTime != string.Empty && DateTime.TryParse(BeginTime, out dateVal)) { query.BeginTime = dateVal; } if (EndTime != string.Empty && DateTime.TryParse(EndTime, out dateVal)) { query.EndTime = dateVal; } if (CommonFunction.ObjectToInteger(Bgid) > 0) { query.BGIDS = Bgid; } #endregion int RecordCount = 0; DataTable dt = BLL.ExamOnline.Instance.GetExamScoreManage(query, " BeginTime Desc", 1, -1, out RecordCount); if (dt != null) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["isMarking"].ToString() == "0") { dt.Rows[i]["zhuguan"] = ""; } else { if (dt.Rows[i]["zhuguan"] == DBNull.Value) { dt.Rows[i]["zhuguan"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 1) == false) { dt.Rows[i]["Onlyselect"] = "-"; } else { if (dt.Rows[i]["Onlyselect"] == DBNull.Value) { dt.Rows[i]["Onlyselect"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 2) == false) { dt.Rows[i]["moreselect"] = "-"; } else { if (dt.Rows[i]["moreselect"] == DBNull.Value) { dt.Rows[i]["moreselect"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 4) == false) { dt.Rows[i]["panduan"] = "-"; } else { if (dt.Rows[i]["panduan"] == DBNull.Value) { dt.Rows[i]["panduan"] = "0"; } } if (BLL.ExamBigQuestion.Instance.HaveAskCategoryByEPID(dt.Rows[i]["epid"].ToString(), 3) == false) { dt.Rows[i]["zhuguan"] = "-"; } } } //要导出的字段 Dictionary <string, string> ExportColums = new Dictionary <string, string>(); ExportColums.Add("truename", "考生姓名"); ExportColums.Add("bgname", "业务组"); ExportColums.Add("projectname", "考试项目"); ExportColums.Add("papername", "试卷名称"); ExportColums.Add("onlyselect", "单选题"); ExportColums.Add("moreselect", "复选题"); ExportColums.Add("panduan", "判断题"); ExportColums.Add("zhuguan", "主观题"); ExportColums.Add("sumscore", "考试成绩"); ExportColums.Add("begintime", "考试时间"); ExportColums.Add("lack", "是否缺考"); //字段排序 dt.Columns["Truename"].SetOrdinal(0); dt.Columns["BGName"].SetOrdinal(1); dt.Columns["ProjectName"].SetOrdinal(2); dt.Columns["Papername"].SetOrdinal(3); dt.Columns["Onlyselect"].SetOrdinal(4); dt.Columns["moreselect"].SetOrdinal(5); dt.Columns["panduan"].SetOrdinal(6); dt.Columns["zhuguan"].SetOrdinal(7); dt.Columns["sumscore"].SetOrdinal(8); dt.Columns["begintime"].SetOrdinal(9); dt.Columns["lack"].SetOrdinal(10); for (int i = dt.Columns.Count - 1; i >= 0; i--) { if (ExportColums.ContainsKey(dt.Columns[i].ColumnName.ToLower())) { //字段时要导出的字段,改名 dt.Columns[i].ColumnName = ExportColums[dt.Columns[i].ColumnName.ToLower()]; } else { //不是要导出的字段,删除 dt.Columns.RemoveAt(i); } } BLL.Util.ExportToCSV("考试成绩", dt); } }