protected DataSet GetDataSet()
{
string qsTypeId = Request.QueryString.Get("type");
string qsExamId = Request.QueryString.Get("eid");
int orgID = Convert.ToInt32(Request.QueryString.Get("OrgID"));
DataSet ds = new DataSet();
if (!string.IsNullOrEmpty(qsTypeId) && !string.IsNullOrEmpty(qsExamId))
{
int nOrganizationId = string.IsNullOrEmpty(hfOrganizationId.Value) ? PrjPub.DEFAULT_INT_IN_DB : int.Parse(hfOrganizationId.Value);
string strExamineeName = string.IsNullOrEmpty(txtExamineeName.Text) ? string.Empty : txtExamineeName.Text;
string strWorkNo = string.IsNullOrEmpty(txtWorkNo.Text) ? string.Empty : txtWorkNo.Text;
decimal dScoreLower = string.IsNullOrEmpty(txtScoreLower.Text) ? 0 : decimal.Parse(txtScoreLower.Text);
decimal dScoreUpper = string.IsNullOrEmpty(txtScoreUpper.Text) ? 500 : decimal.Parse(txtScoreUpper.Text);
int nExamStatusId = string.IsNullOrEmpty(ddlStatusId.SelectedValue) ? PrjPub.DEFAULT_INT_IN_DB : int.Parse(ddlStatusId.SelectedValue);
string strOrganizationName = string.IsNullOrEmpty(txtOrganizationName.Text) ? string.Empty : txtOrganizationName.Text;
IList <RailExam.Model.ExamResult> examResults = null;
ExamResultBLL bllExamResult = new ExamResultBLL();
try
{
if (orgID == 1)
{
examResults = bllExamResult.GetExamResults(int.Parse(qsExamId), strOrganizationName, strExamineeName, strWorkNo, dScoreLower,
dScoreUpper, nExamStatusId);
}
else
{
examResults = bllExamResult.GetExamResultsByOrgID(
int.Parse(qsExamId), strOrganizationName, strExamineeName, strWorkNo, dScoreLower,
dScoreUpper, nExamStatusId, orgID);
}
}
catch
{
Pub.ShowErrorPage("无法连接站段服务器，请检查站段服务器是否打开以及网络连接是否正常！");
}
ExamResultStatusBLL bllExamResultStatus = new ExamResultStatusBLL();
IList <RailExam.Model.ExamResultStatus> examResultStatuses = bllExamResultStatus.GetExamResultStatuses();
DataTable dtExamResults = ConvertToDataTable((IList)examResults);
DataTable dtExamResultStatuses = ConvertToDataTable((IList)examResultStatuses);
if (dtExamResults != null)
{
ds.Tables.Add(dtExamResults);
}
else
{
ds.Tables.Add(ConvertToDataTable(typeof(RailExam.Model.ExamResult)));
}
ds.Tables.Add(dtExamResultStatuses);
ds.Relations.Add(ds.Tables["ExamResultStatus"].Columns["ExamResultStatusId"],
ds.Tables["ExamResult"].Columns["StatusId"]);
}
return(ds);
}
