protected void Page_Load(object sender, EventArgs e)
{
string orgID = Request.QueryString.Get("orgid");
string strId = Request.QueryString.Get("id");
ViewState["NowOrgID"] = Convert.ToInt32(ConfigurationManager.AppSettings["StationID"]);
if (!string.IsNullOrEmpty(strId))
{
FillHeading(strId, orgID);
}
if (!IsPostBack)
{
if (PrjPub.CurrentLoginUser != null)
{
hfLoginEmployeeID.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString();
}
else
{
RandomExamResultBLL bll = new RandomExamResultBLL();
RandomExamResult result = bll.GetRandomExamResult(Convert.ToInt32(strId));
hfLoginEmployeeID.Value = result.ExamineeId.ToString();
if (hfLoginEmployeeID.Value == "0")
{
RandomExamResult result1 = bll.GetRandomExamResultTemp(Convert.ToInt32(strId));
hfLoginEmployeeID.Value = result1.ExamineeId.ToString();
}
}
}
}
private void ReplyExam(string strId)
{
RandomExamResultBLL objResultBll = new RandomExamResultBLL();
RandomExamResult result = objResultBll.GetRandomExamResult(Convert.ToInt32(strId));
RandomExamResultCurrentBLL objBll = new RandomExamResultCurrentBLL();
objBll.ReplyRandomExamResultCurrentByResultID(result.ExamineeId, Convert.ToInt32(strId));
examsGrid.DataSource = objBll.GetRandomExamResultInfoByExamID(result.RandomExamId, GetSql());
examsGrid.DataBind();
}
protected void Grid1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string resultID = ((HiddenField)Grid1.Rows[e.RowIndex].FindControl("hfID")).Value;
string employeeID = ((HiddenField)Grid1.Rows[e.RowIndex].FindControl("hfExamineeID")).Value;
string score = ((TextBox)Grid1.Rows[e.RowIndex].FindControl("txtScore")).Text;
RandomExamResultBLL objResultBll = new RandomExamResultBLL();
if (resultID == "0")
{
RandomExamResult objResult = new RandomExamResult();
objResult.OrganizationId = Convert.ToInt32(ViewState["ExamOrgID"]);
objResult.RandomExamId = Convert.ToInt32(ViewState["ExamID"]);
objResult.ExamineeId = Convert.ToInt32(employeeID);
objResult.BeginDateTime = DateTime.Now;
objResult.EndDateTime = DateTime.Now;
objResult.CurrentDateTime = DateTime.Now;
objResult.ExamTime = 0;
objResult.AutoScore = 0;
objResult.Score = Convert.ToDecimal(score);
objResult.CorrectRate = Convert.ToDecimal(score);
objResult.IsPass = Convert.ToDecimal(score) >= 60 ? true : false;
objResult.StatusId = 2;
objResultBll.AddRandomExamResult(objResult);
}
else
{
RandomExamResult objResult = objResultBll.GetRandomExamResult(Convert.ToInt32(resultID));
objResult.Score = Convert.ToDecimal(score);
objResult.CorrectRate = Convert.ToDecimal(score);
objResult.IsPass = Convert.ToDecimal(score) >= 60 ? true : false;
objResultBll.UpdateRandomExamResultOther(objResult);
}
Grid1.EditIndex = -1;
BindGrid();
}
protected void FillHeading(string strId, string orgid)
{
RandomExamResultBLL randomExamResultBLL = new RandomExamResultBLL();
RandomExamResult randomExamResult = new RandomExamResult();
if (ViewState["NowOrgID"].ToString() != orgid)
{
randomExamResult = randomExamResultBLL.GetRandomExamResultByOrgID(int.Parse(strId), int.Parse(orgid));
}
else
{
randomExamResult = randomExamResultBLL.GetRandomExamResult(int.Parse(strId));
}
string strOrgName = randomExamResult.OrganizationName;
string strStationName = "";
string strOrgName1 = "";
int n = strOrgName.IndexOf("-");
if (n != -1)
{
strStationName = strOrgName.Substring(0, n);
strOrgName1 = strOrgName.Substring(n + 1);
}
else
{
strStationName = strOrgName;
strOrgName1 = "";
}
lblOrg.Text = strStationName;
lblWorkShop.Text = strOrgName1;
lblPost.Text = randomExamResult.PostName;
lblName.Text = randomExamResult.ExamineeName;
lblTime.Text = randomExamResult.BeginDateTime.ToString("yyyy-MM-dd HH:mm");
lblScore.Text = System.String.Format("{0:0.##}", randomExamResult.Score);
int RandomExamId = randomExamResult.RandomExamId;
RandomExamBLL randomExamBLL = new RandomExamBLL();
RailExam.Model.RandomExam randomExam = randomExamBLL.GetExam(RandomExamId);
if (randomExam != null)
{
lblTitle.Text = randomExam.ExamName;
}
RandomExamSubjectBLL randomExamSubjectBLL = new RandomExamSubjectBLL();
IList <RailExam.Model.RandomExamSubject> RandomExamSubjects = randomExamSubjectBLL.GetRandomExamSubjectByRandomExamId(RandomExamId);
int nItemCount = 0;
decimal nTotalScore = 0;
for (int i = 0; i < RandomExamSubjects.Count; i++)
{
nItemCount += RandomExamSubjects[i].ItemCount;
nTotalScore += RandomExamSubjects[i].ItemCount * RandomExamSubjects[i].UnitScore;
}
lblTitleRight.Text = "总共" + nItemCount + "题，共" + System.String.Format("{0:0.##}", nTotalScore) + "分";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
string strExamType = Request.QueryString.Get("ExamType");
string strExamResultID = Request.QueryString.Get("ExamResultID");
if (strExamType == "1")
{
RandomExamResultBLL objBll = new RandomExamResultBLL();
RailExam.Model.RandomExamResult obj = new RandomExamResult();
if (string.IsNullOrEmpty(Request.QueryString.Get("IsResult")))
{
//正常提交
obj =
objBll.GetRandomExamResultTemp(Convert.ToInt32(strExamResultID));
}
else
{
//后台终止考试或结束考试
obj =
objBll.GetRandomExamResult(Convert.ToInt32(strExamResultID));
}
RandomExamBLL objExamBll = new RandomExamBLL();
RailExam.Model.RandomExam objRandomExam = objExamBll.GetExam(obj.RandomExamId);
if (objRandomExam.CanSeeScore)
{
hfIsShowResult.Value = "1";
lblScore.Text = "成绩：" + System.String.Format("{0:0.##}", obj.Score) + "分";
if (objRandomExam.CanSeeAnswer)
{
hfIsShowAnswer.Value = "1";
}
//if (lblScore.Text == string.Empty)
//{
// lblScore.Text = "成绩：" + String.Format("{0:0.##}", Request.QueryString.Get("nowScore")) + "分";
//}
}
if (objRandomExam.IsPublicScore)
{
if (obj.Score >= objRandomExam.PassScore)
{
lblPass.Text = "祝贺您本次考试合格通过！";
}
else
{
lblPass.Text = "您本次考试未合格未通过！";
}
}
else
{
lblPass.Text = "";
}
if (string.IsNullOrEmpty(Request.QueryString.Get("IsResult")))
{
//正常提交
try
{
OracleAccess dbPhoto = new OracleAccess();
string strSql = "select * from Random_Exam_Result_Detail_Temp where Random_Exam_Result_ID=" +
strExamResultID + " and Random_Exam_ID=" + obj.RandomExamId;
DataSet dsPhoto = dbPhoto.RunSqlDataSet(strSql);
if (dsPhoto.Tables[0].Rows.Count > 0)
{
DataRow drPhoto = dsPhoto.Tables[0].Rows[0];
int employeeId = Convert.ToInt32(drPhoto["Employee_ID"]);
if (drPhoto["FingerPrint"] != DBNull.Value)
{
Pub.SavePhotoToLocal(obj.RandomExamId, employeeId, (byte[])drPhoto["FingerPrint"], 0, Convert.ToInt32(strExamResultID));
}
if (drPhoto["Photo1"] != DBNull.Value)
{
Pub.SavePhotoToLocal(obj.RandomExamId, employeeId, (byte[])drPhoto["Photo1"], 1, Convert.ToInt32(strExamResultID));
}
if (drPhoto["Photo2"] != DBNull.Value)
{
Pub.SavePhotoToLocal(obj.RandomExamId, employeeId, (byte[])drPhoto["Photo2"], 2, Convert.ToInt32(strExamResultID));
}
if (drPhoto["Photo3"] != DBNull.Value)
{
Pub.SavePhotoToLocal(obj.RandomExamId, employeeId, (byte[])drPhoto["Photo3"], 3, Convert.ToInt32(strExamResultID));
}
}
}
catch
{
hfOrgID.Value = ConfigurationManager.AppSettings["StationID"];
}
}
}
hfOrgID.Value = ConfigurationManager.AppSettings["StationID"];
}
catch
{
lblPass.Text = "";
}
}
}