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