public void UpdateRandomExamTrainClass(RandomExamTrainClass trainClass)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Random_Exam_Train_Class_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddOutParameter(dbCommand, "p_id", DbType.Int32, trainClass.RandomExamTrainClassID);
db.AddInParameter(dbCommand, "p_exam_id", DbType.Int32, trainClass.RandomExamID);
db.AddInParameter(dbCommand, "p_class_id", DbType.Int32, trainClass.TrainClassID);
db.AddInParameter(dbCommand, "p_subject_id", DbType.Int32, trainClass.TrainClassSubjectID);
db.ExecuteNonQuery(dbCommand);
}
public RandomExamTrainClass GetRandomExamsTrainClassByRandomExamTrainClassID(int id)
{
RandomExamTrainClass trainClass = new RandomExamTrainClass();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Random_Exam_Train_Class_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_id", DbType.Int32, id);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
trainClass = CreateModelObject(dataReader);
}
}
return(trainClass);
}
public IList <RandomExamTrainClass> GetRandomExamsTrainClassByRandomExamID(int randomExamID)
{
IList <RandomExamTrainClass> exams = new List <RandomExamTrainClass>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Random_Exam_G_RailEdu";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_exam_id", DbType.Int32, randomExamID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
RandomExamTrainClass exam = CreateModelObject(dataReader);
exams.Add(exam);
}
}
return(exams);
}
public IList <RandomExamTrainClass> GetRandomExamTrainClassCount(int trainclassID, int trainclasssubjectID, int postID)
{
IList <RandomExamTrainClass> exams = new List <RandomExamTrainClass>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_Random_Exam_Train_Class_Q";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_train_class_id", DbType.Int32, trainclassID);
db.AddInParameter(dbCommand, "p_subject_id", DbType.Int32, trainclasssubjectID);
db.AddInParameter(dbCommand, "p_post_id", DbType.Int32, postID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
RandomExamTrainClass exam = CreateModelObject(dataReader);
exams.Add(exam);
}
}
return(exams);
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
DataTable dataTable = BindGrid();
if (txtMET2.Text == "")
{
txtMET2.Text = "1";
}
if (chkHasTrainClass.Checked)
{
if (hfPostID.Value == "")
{
SessionSet.PageMessage = "带有培训班的考试，必须选择职名！";
return;
}
}
RandomExamBLL examBLL = new RandomExamBLL();
RailExam.Model.RandomExam exam = new RailExam.Model.RandomExam();
string strID = string.Empty;
string strMode = ViewState["mode"].ToString();
string strStartMode = ViewState["startmode"].ToString();
RandomExamTrainClassBLL objTrainClassBll = new RandomExamTrainClassBLL();
string[] strPost = hfPostID.Value.Split(',');
string strErrorMessage = "";
OracleAccess db = new OracleAccess();
if (strMode == "Insert")
{
string strExam = "select * from Random_Exam where Exam_Name='" + txtExamName.Text + "'";
if (db.RunSqlDataSet(strExam).Tables[0].Rows.Count > 0)
{
SessionSet.PageMessage = "该考试名称在系统中已经存在，请重新输入！";
txtExamName.Focus();
return;
}
if (chkHasTrainClass.Checked)
{
foreach (DataRow dr in dataTable.Rows)
{
for (int i = 0; i < strPost.Length; i++)
{
IList <RandomExamTrainClass> objList =
objTrainClassBll.GetRandomExamTrainClassCount(Convert.ToInt32(dr["TrainClassID"].ToString()),
Convert.ToInt32(dr["TrainClassSubjectID"].ToString()),
Convert.ToInt32(strPost[i]));
if (objList.Count > 0)
{
strErrorMessage = "培训班“" + dr["TrainClassName"] + "”的考试科目“" + dr["TrainClassSubjectName"] + "”已新增当前所选职名的试卷！";
}
}
}
}
if (strErrorMessage != "")
{
SessionSet.PageMessage = strErrorMessage;
return;
}
exam.CategoryId = int.Parse(hfCategoryId.Value);
exam.ExamName = txtExamName.Text;
exam.Memo = txtMemo.Text;
exam.CreatePerson = PrjPub.CurrentLoginUser.EmployeeName;
exam.ExamModeId = 1;
exam.PassScore = Convert.ToDecimal(txtPassScore.Text);
if (rbnExamMode1.Checked)
{
exam.IsComputerExam = true;
}
else
{
exam.IsComputerExam = false;
}
if (rbnStartMode1.Checked)
{
exam.StartMode = 1;
}
else
{
exam.StartMode = 2;
}
if (rbnStyle1.Checked)
{
exam.ExamStyle = 1;
}
else
{
exam.ExamStyle = 2;
}
exam.IsAutoScore = chAutoScore.Checked;
exam.CanSeeAnswer = chkCanSeeAnswer.Checked;
exam.CanSeeScore = chSeeScore.Checked;
exam.IsPublicScore = chPublicScore.Checked;
exam.IsUnderControl = chUD.Checked;
exam.MaxExamTimes = int.Parse(txtMET2.Text);
exam.MinExamTimes = 1;
exam.BeginTime = DateTime.Parse(dateBeginTime.DateValue.ToString());
exam.EndTime = DateTime.Parse(dateEndTime.DateValue.ToString());
exam.ExamTypeId = 1;
exam.CreateTime = DateTime.Now;
exam.Description = txtDescription.Text;
exam.ExamTime = int.Parse(txtExamTime.Text);
exam.StatusId = 1;
exam.PostID = hfPostID.Value;
exam.RandomExamModularTypeID = Convert.ToInt32(ddlModularType.SelectedValue);
exam.IsReduceError = chkIsReduceScore.Checked;
exam.AutoSaveInterval = chkAllItem.Checked ? 1 : 0;
if (saveTd.Visible)
{
exam.SaveStatus = Convert.ToInt32(ddlDate.SelectedValue);
if (dateSaveDate.Visible)
{
if (dateSaveDate.DateValue == null)
{
SessionSet.PageMessage = "请选择一个存档时间！";
return;
}
exam.SaveDate = Convert.ToDateTime(dateSaveDate.DateValue);
}
}
else
{
exam.SaveStatus = 0;
exam.SaveDate = null;
}
//exam.AutoSaveInterval = 0;
exam.OrgId = PrjPub.CurrentLoginUser.StationOrgID;
exam.HasTrainClass = chkHasTrainClass.Checked;
int id = examBLL.AddExam(exam);
strID = id.ToString();
if (_isWuhanOnly)
{
//当考试来源为培训班时，需自动添加考生。
if (chkHasTrainClass.Checked)
{
foreach (DataRow dr in dataTable.Rows)
{
RandomExamTrainClass obj = new RandomExamTrainClass();
obj.RandomExamID = Convert.ToInt32(strID);
obj.TrainClassID = Convert.ToInt32(dr["TrainClassID"].ToString());
obj.TrainClassSubjectID = Convert.ToInt32(dr["TrainClassSubjectID"].ToString());
objTrainClassBll.AddRandomExamTrainClass(obj);
}
//ClientScript.RegisterStartupScript(GetType(),
// "jsSelectFirstNode",
// @"SaveArrange(" + strID + ",'" + strStartMode + "','" + strMode + "');",
// true);
//string strClause = strID + "|" + strStartMode + "|" + strMode;
//ClientScript.RegisterStartupScript(GetType(), "import", "inputCallback.callback('" + strClause + "');", true);
try
{
SaveRandomExamArrange(strID, hfTrainClassID.Value, hfPostID.Value);
}
catch
{
SessionSet.PageMessage = "添加考生失败";
return;
}
Response.Redirect("RandomExamManageSecond.aspx?startmode=" + strStartMode + "&mode=" + strMode + "&id=" + strID);
}
else
{
Response.Redirect("RandomExamManageSecond.aspx?startmode=" + strStartMode + "&mode=" + strMode + "&id=" + strID);
}
}
else
{
Response.Redirect("RandomExamManageSecond.aspx?startmode=" + strStartMode + "&mode=" + strMode + "&id=" + strID);
}
}
else if (strMode == "Edit")
{
strID = Request.QueryString.Get("id");
if (Pub.HasPaper(Convert.ToInt32(strID)))
{
Response.Write("<script>alert('该考试已生成试卷，不能被编辑！');window.close();</script>");
return;
}
string strExam = "select * from Random_Exam where Random_Exam_ID!=" + strID + " and Exam_Name='" + txtExamName.Text + "'";
if (db.RunSqlDataSet(strExam).Tables[0].Rows.Count > 0)
{
SessionSet.PageMessage = "该考试名称在系统中已经存在，请重新输入！";
txtExamName.Focus();
return;
}
string strSql = "select * from Random_Exam_Computer_Server where Has_Paper=1 and Random_Exam_ID=" + strID;
DataTable dt = db.RunSqlDataSet(strSql).Tables[0];
if (dt.Rows.Count > 0)
{
SessionSet.PageMessage = "当前考试已经生成试卷，不能继续编辑！";
return;
}
if (chkHasTrainClass.Checked && ViewState["TrainClass"].ToString() != hfTrainClassID.Value)
{
foreach (DataRow dr in dataTable.Rows)
{
for (int i = 0; i < strPost.Length; i++)
{
IList <RandomExamTrainClass> objList =
objTrainClassBll.GetRandomExamTrainClassCount(Convert.ToInt32(dr["TrainClassID"].ToString()),
Convert.ToInt32(dr["TrainClassSubjectID"].ToString()),
Convert.ToInt32(strPost[i]));
if (objList.Count > 0)
{
if (objList[0].RandomExamID.ToString() != strID)
{
strErrorMessage = "培训班“" + dr["TrainClassName"] + "”的考试科目“" + dr["TrainClassSubjectName"] + "”已新增当前所选职名的试卷！";
}
}
}
}
}
if (strErrorMessage != "")
{
SessionSet.PageMessage = strErrorMessage;
return;
}
exam.CategoryId = Convert.ToInt32(hfCategoryId.Value);
exam.ExamName = txtExamName.Text;
exam.Memo = txtMemo.Text;
exam.RandomExamId = int.Parse(strID);
exam.ExamTime = int.Parse(txtExamTime.Text);
exam.ExamModeId = 1;
exam.PassScore = Convert.ToDecimal(txtPassScore.Text);
if (rbnExamMode1.Checked)
{
exam.IsComputerExam = true;
}
else
{
exam.IsComputerExam = false;
}
if (rbnStartMode1.Checked)
{
exam.StartMode = 1;
}
else
{
exam.StartMode = 2;
}
if (rbnStyle1.Checked)
{
exam.ExamStyle = 1;
}
else
{
exam.ExamStyle = 2;
}
exam.BeginTime = DateTime.Parse(dateBeginTime.DateValue.ToString());
exam.EndTime = DateTime.Parse(dateEndTime.DateValue.ToString());
exam.IsAutoScore = chAutoScore.Checked;
exam.CanSeeAnswer = chkCanSeeAnswer.Checked;
exam.CanSeeScore = chSeeScore.Checked;
exam.IsPublicScore = chPublicScore.Checked;
exam.IsUnderControl = chUD.Checked;
exam.MaxExamTimes = int.Parse(txtMET2.Text);
exam.MinExamTimes = 1;
exam.ExamTypeId = 1;
exam.Description = txtDescription.Text;
//exam.AutoSaveInterval = 0;
exam.RandomExamModularTypeID = Convert.ToInt32(ddlModularType.SelectedValue);
exam.IsReduceError = chkIsReduceScore.Checked;
exam.AutoSaveInterval = chkAllItem.Checked ? 1 : 0;
if (saveTd.Visible)
{
exam.SaveStatus = Convert.ToInt32(ddlDate.SelectedValue);
if (dateSaveDate.Visible)
{
if (dateSaveDate.DateValue == null)
{
SessionSet.PageMessage = "请选择一个存档时间！";
return;
}
exam.SaveDate = Convert.ToDateTime(dateSaveDate.DateValue);
}
}
else
{
exam.SaveStatus = 0;
exam.SaveDate = null;
}
RandomExamArrangeBLL objArrangeBll = new RandomExamArrangeBLL();
//当是否为培训班改变或则培训班改变时，需删除考试安排
if (Convert.ToBoolean(ViewState["HasTrainClass"].ToString()) != chkHasTrainClass.Checked ||
ViewState["TrainClass"].ToString() != hfTrainClassID.Value || ViewState["PostID"].ToString() != hfPostID.Value)
{
objArrangeBll.DeleteRandomExamArrangeByRandomExamID(Convert.ToInt32(strID));
}
if ((Convert.ToBoolean(ViewState["HasTrainClass"].ToString()) != chkHasTrainClass.Checked && !chkHasTrainClass.Checked) || ViewState["TrainClass"].ToString() != hfTrainClassID.Value)
{
objTrainClassBll.DeleteRandomExamTrainClassByRandomExamID(Convert.ToInt32(strID));
}
exam.HasTrainClass = chkHasTrainClass.Checked;
exam.PostID = hfPostID.Value;
exam.Version = exam.Version + 1;
examBLL.UpdateExam(exam);
if (_isWuhanOnly)
{
if (chkHasTrainClass.Checked)
{
//当培训班或职名发生变化时，更改考生名单
if (ViewState["TrainClass"].ToString() != hfTrainClassID.Value || ViewState["PostID"].ToString() != hfPostID.Value)
{
objTrainClassBll.DeleteRandomExamTrainClassByRandomExamID(Convert.ToInt32(strID));
foreach (DataRow dr in dataTable.Rows)
{
RandomExamTrainClass obj = new RandomExamTrainClass();
obj.RandomExamID = Convert.ToInt32(strID);
obj.TrainClassID = Convert.ToInt32(dr["TrainClassID"].ToString());
obj.TrainClassSubjectID = Convert.ToInt32(dr["TrainClassSubjectID"].ToString());
objTrainClassBll.AddRandomExamTrainClass(obj);
}
//ClientScript.RegisterStartupScript(GetType(),
//"jsSelectFirstNode",
//@"SaveArrange(" + strID + ",'" + strStartMode + "','" + strMode + "');",
//true);
//string strClause = strID + "|" + strStartMode + "|" + strMode;
//ClientScript.RegisterStartupScript(GetType(), "import", "inputCallback.callback('" + strClause + "');", true);
try
{
SaveRandomExamArrange(strID, hfTrainClassID.Value, hfPostID.Value);
}
catch
{
SessionSet.PageMessage = "添加考生失败";
return;
}
Response.Redirect("RandomExamManageSecond.aspx?startmode=" + strStartMode + "&mode=" + strMode + "&id=" + strID);
}
else
{
Response.Redirect("RandomExamManageSecond.aspx?startmode=" + strStartMode + "&mode=" + strMode + "&id=" + strID);
}
}
else
{
Response.Redirect("RandomExamManageSecond.aspx?startmode=" + strStartMode + "&mode=" + strMode + "&id=" + strID);
}
}
else
{
Response.Redirect("RandomExamManageSecond.aspx?startmode=" + strStartMode + "&mode=" + strMode + "&id=" + strID);
}
}
else
{
strID = Request.QueryString.Get("id");
Response.Redirect("RandomExamManageSecond.aspx?startmode=" + strStartMode + "&mode=" + strMode + "&id=" + strID);
}
}
public void UpdateRandomExamTrainClass(RandomExamTrainClass trainClass)
{
dal.UpdateRandomExamTrainClass(trainClass);
}
public void AddRandomExamTrainClass(RandomExamTrainClass trainClass)
{
dal.AddRandomExamTrainClass(trainClass);
}
