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