private Entities.ExamPerson LoadSingleExamPerson(DataRow row)
{
Entities.ExamPerson model = new Entities.ExamPerson();
if (row["EPID"].ToString() != "")
{
model.EPID = long.Parse(row["EPID"].ToString());
}
if (row["EIID"].ToString() != "")
{
model.EIID = long.Parse(row["EIID"].ToString());
}
if (row["MEIID"].ToString() != "")
{
model.MEIID = int.Parse(row["MEIID"].ToString());
}
if (row["ExamPerSonID"].ToString() != "")
{
model.ExamPerSonID = int.Parse(row["ExamPerSonID"].ToString());
}
if (row["ExamType"].ToString() != "")
{
model.ExamType = int.Parse(row["ExamType"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.ExamPerson model)
{
SqlParameter[] parameters =
{
new SqlParameter("@EPID", SqlDbType.BigInt, 8),
new SqlParameter("@EIID", SqlDbType.BigInt, 8),
new SqlParameter("@MEIID", SqlDbType.Int, 4),
new SqlParameter("@ExamPerSonID", SqlDbType.Int, 4),
new SqlParameter("@ExamType", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.EPID;
parameters[1].Value = model.EIID;
parameters[2].Value = model.MEIID;
parameters[3].Value = model.ExamPerSonID;
parameters[4].Value = model.ExamType;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUserID;
return(SqlHelper.ExecuteNonQuery(sqltran, CONNECTIONSTRINGS, CommandType.StoredProcedure, P_EXAMPERSON_UPDATE, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(SqlTransaction sqltran, Entities.ExamPerson model)
{
SqlParameter[] parameters =
{
new SqlParameter("@EPID", SqlDbType.BigInt, 8),
new SqlParameter("@EIID", SqlDbType.BigInt, 8),
new SqlParameter("@MEIID", SqlDbType.Int, 4),
new SqlParameter("@ExamPerSonID", SqlDbType.Int, 4),
new SqlParameter("@ExamType", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.EIID;
parameters[2].Value = model.MEIID;
parameters[3].Value = model.ExamPerSonID;
parameters[4].Value = model.ExamType;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUserID;
SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_EXAMPERSON_INSERT, parameters);
return(Convert.ToInt32(parameters[0].Value));
}
public bool checkData(out string meg)
{
meg = "";
#region 普通考试验证
#region 常规验证
if (Action == "complate")
{
examObj.Status = 1;
}
else
{
examObj.Status = 0;
}
if (examObj.Name == "")
{
meg = "考试名称不可为空！";
return(false);
}
if (examObj.Description == "")
{
meg = "考试说明不可为空！";
return(false);
}
int epID = 0;
//试卷ID
if (!int.TryParse(HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["EPID"].ToString()), out epID))
{
meg = "试卷ID转化失败，请重试。";
return(false);
}
else
{
examObj.EPID = epID;
}
//参考人员
string examPersonIDs = BLL.Util.removeLastComma(ExamPersonIDs);
string[] examPersonIDsArr = examPersonIDs.Split(',');
foreach (string EmID in examPersonIDsArr)
{
int emID = 0;
if (int.TryParse(EmID, out emID))
{
Entities.ExamPerson examPersion = new Entities.ExamPerson();
examPersion.CreateTime = DateTime.Now;
examPersion.CreateUserID = BLL.Util.GetLoginUserID();
//examPersion.EIID
examPersion.ExamPerSonID = emID;
examPersion.ExamType = 0;
examPersionList.Add(examPersion);
}
else
{
meg = "参考（普通）人员ID装换失败！";
return(false);
}
}
#endregion
#region 考试时间验证
DateTime time;
if (!DateTime.TryParse(ExamStartTime, out time))
{
meg = "考试开始时间格式不正确！";
return(false);
}
else
{
examObj.ExamStartTime = time;
}
if (!DateTime.TryParse(ExamEndTime, out time))
{
meg = "考试开始时间格式不正确！";
return(false);
}
else
{
examObj.ExamEndTime = time;
}
if (examObj.EIID == 0)
{
if (examObj.ExamStartTime < DateTime.Now)
{
meg = "考试开始时不得晚于当前时间！";
return(false);
}
}
if (examObj.ExamStartTime > examObj.ExamEndTime)
{
meg = "考试结束时不得早于开考时间！";
return(false);
}
#endregion
#endregion
#region 补考验证
if (examObj.IsMakeUp == 1)
{
if (!DateTime.TryParse(MakeStartTime, out time))
{
meg = "考试开始时间格式不正确！";
return(false);
}
else
{
makeExamOjb.MakeUpExamStartTime = time;
}
if (!DateTime.TryParse(MakeEndTime, out time))
{
meg = "考试开始时间格式不正确！";
return(false);
}
else
{
makeExamOjb.MakeupExamEndTime = time;
}
if (examObj.EIID == 0 || examObj.Status == 0)
{
if (makeExamOjb.MakeUpExamStartTime < DateTime.Now)
{
meg = "补考考试开始时不得晚于当前时间！";
return(false);
}
}
if (makeExamOjb.MakeupExamEndTime < makeExamOjb.MakeUpExamStartTime)
{
meg = "补考考试结束时不得晚于开考时间！";
return(false);
}
if (makeExamOjb.MakeUpExamStartTime < examObj.ExamEndTime)
{
meg = "补考开始时间不得早于正常考试结束时间！";
return(false);
}
makeExamOjb.MakeUpEPID = Convert.ToInt32(HttpContext.Current.Server.UrlDecode(HttpContext.Current.Request["makeUpEcid"].ToString()));
//
//参考人员
string makeExamPersonIDs = BLL.Util.removeLastComma(MakeExamPersonIDs);
string[] makeExamPersonIDsArr = makeExamPersonIDs.Split(',');
foreach (string EmID in makeExamPersonIDsArr)
{
int emID = 0;
if (int.TryParse(EmID, out emID))
{
Entities.ExamPerson examPersion = new Entities.ExamPerson();
examPersion.CreateTime = DateTime.Now;
examPersion.CreateUserID = BLL.Util.GetLoginUserID();
//examPersion.EIID
examPersion.ExamPerSonID = emID;
examPersion.ExamType = 1;
makeExamPersionList.Add(examPersion);
}
else
{
meg = "参考（补考）人员ID装换失败！";
return(false);
}
}
}
#endregion
return(true);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.ExamPerson model)
{
return(Dal.ExamPerson.Instance.Update(sqltran, model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.ExamPerson model)
{
return(Dal.ExamPerson.Instance.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.ExamPerson model)
{
return(Dal.ExamPerson.Instance.Insert(model));
}
