protected void btnAdd_Click(object sender, EventArgs e) { string strId = Request.QueryString.Get("id"); int i = Grid1.Rows.Count; ExamArrange examArrange = new ExamArrange(); ExamBLL examBLL = new ExamBLL(); RailExam.Model.Exam exam = examBLL.GetExam(int.Parse(strId)); if (exam != null) { examArrange.ExamId = int.Parse(strId); examArrange.PaperId = exam.paperId; examArrange.UserIds = "选择考生!"; examArrange.JudgeIds = "选择评卷人!"; examArrange.BeginTime = DateTime.Now; examArrange.EndTime = DateTime.Now.AddHours(1); examArrange.OrderIndex = 1; examArrange.Memo = ""; ExamArrangeBLL examArrangeBLL = new ExamArrangeBLL(); examArrangeBLL.AddExamArrange(examArrange); Grid1.DataBind(); } }
public ExamArrange GetExamArrange(int ExamArrangeId) { ExamArrange item = null; Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "USP_Exam_Arrange_G"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "p_Exam_Arrange_id", DbType.Int32, ExamArrangeId); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { item = CreateModelObject(dataReader); break; } } return(item); }
protected void btnSave_Click(object sender, EventArgs e) { if (Grid1.Rows.Count == 0) { SessionSet.PageMessage = "请选择考生、指定评卷人!"; return; } string strId = Request.QueryString.Get("id"); IList <ExamArrange> examArranges = new List <ExamArrange>(); for (int i = 0; i < Grid1.Rows.Count; i++) { string strExamArrangeId = ((HiddenField)Grid1.Rows[i].FindControl("hfExamArrangeId")).Value; string strBeginTime = ((DateTimeUC)Grid1.Rows[i].FindControl("dateBeginTime")).DateValue.ToString(); string strEndTime = ((DateTimeUC)Grid1.Rows[i].FindControl("dateEndtime")).DateValue.ToString(); string strUserIds = ((TextBox)Grid1.Rows[i].FindControl("txtUserIds")).Text; string strJudgeIds = ((TextBox)Grid1.Rows[i].FindControl("txtJudgeIds")).Text; ExamArrange examArrange = new ExamArrange(); examArrange.ExamId = int.Parse(strId); examArrange.ExamArrangeId = int.Parse(strExamArrangeId); examArrange.UserIds = strUserIds; examArrange.JudgeIds = strJudgeIds; examArrange.BeginTime = DateTime.Parse(strBeginTime); examArrange.EndTime = DateTime.Parse(strEndTime); examArranges.Add(examArrange); } ExamArrangeBLL examArrangeBLL = new ExamArrangeBLL(); examArrangeBLL.UpdateExamArrange(examArranges); Response.Write("<script>top.window.opener.form1.Refresh.value='true';top.window.opener.form1.submit();top.window.close();</script>"); }
//public int AddExamArrange(ExamArrange examArrange) //{ // Database db = DatabaseFactory.CreateDatabase(); // string sqlCommand = "USP_Exam_Arrange_I"; // DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); // db.AddOutParameter(dbCommand, "p_Exam_Arrange_Id", DbType.Int32, 4); // db.AddInParameter(dbCommand, "p_Exam_Id", DbType.Int32, examArrange.ExamId); // db.AddInParameter(dbCommand, "p_paper_Id", DbType.Int32, examArrange.PaperId); // db.AddInParameter(dbCommand, "p_order_Index", DbType.Int32, examArrange.OrderIndex); // db.AddInParameter(dbCommand, "p_Begin_Time", DbType.DateTime, examArrange.BeginTime); // db.AddInParameter(dbCommand, "p_End_Time", DbType.DateTime, examArrange.EndTime); // db.AddInParameter(dbCommand, "p_User_Ids", DbType.String, examArrange.UserIds); // db.AddInParameter(dbCommand, "p_Judge_Ids", DbType.String, examArrange.JudgeIds); // db.AddInParameter(dbCommand, "p_memo", DbType.String, examArrange.Memo); // int nRecordAffected = db.ExecuteNonQuery(dbCommand); // examArrange.ExamArrangeId = (int)db.GetParameterValue(dbCommand, "p_Exam_Arrange_Id"); // return nRecordAffected; //} public int AddExamArrange(ExamArrange examArrange) { XmlDocument doc = new XmlDocument(); //Request.PhysicalApplicationPath取得config文件路径 doc.Load(Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, "web.config")); XmlNode node = doc.SelectSingleNode("configuration/dataConfiguration/@defaultDatabase"); string value = node.Value; int id = 0; if (value == "Oracle") { OracleParameter para1 = new OracleParameter("p_User_Ids", OracleType.Clob); OracleParameter para2 = new OracleParameter("p_Exam_Arrange_Id", OracleType.Number); para2.Direction = ParameterDirection.Output; OracleParameter para3 = new OracleParameter("p_Exam_Id", OracleType.Number); para3.Value = examArrange.ExamId; OracleParameter para4 = new OracleParameter("p_paper_Id", OracleType.Number); para4.Value = examArrange.PaperId; OracleParameter para5 = new OracleParameter("p_order_Index", OracleType.Number); para5.Value = examArrange.OrderIndex; OracleParameter para6 = new OracleParameter("p_Begin_Time", OracleType.DateTime); para6.Value = examArrange.BeginTime; OracleParameter para7 = new OracleParameter("p_End_Time", OracleType.DateTime); para7.Value = examArrange.EndTime; OracleParameter para8 = new OracleParameter("p_Judge_Ids", OracleType.NVarChar); para8.Value = examArrange.JudgeIds; OracleParameter para9 = new OracleParameter("p_memo", OracleType.NVarChar); para9.Value = examArrange.Memo; IDataParameter[] paras = new IDataParameter[] { para1, para2, para3, para4, para5, para6, para7, para8, para9 }; id = RunAddProcedure("USP_Exam_Arrange_I", paras, System.Text.Encoding.Unicode.GetBytes(examArrange.UserIds)); } return(id); }
//public int UpdateExamArrange(ExamArrange examArrange) //{ // Database db = DatabaseFactory.CreateDatabase(); // string sqlCommand = "USP_Exam_Arrange_U"; // DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); // db.AddInParameter(dbCommand, "p_Exam_Arrange_Id", DbType.Int32, examArrange.ExamArrangeId); // db.AddInParameter(dbCommand, "p_Begin_Time", DbType.DateTime, examArrange.BeginTime); // db.AddInParameter(dbCommand, "p_End_Time", DbType.DateTime, examArrange.EndTime); // db.AddInParameter(dbCommand, "p_User_Ids", DbType.String, examArrange.UserIds); // db.AddInParameter(dbCommand, "p_Judge_Ids", DbType.String, examArrange.JudgeIds); // return db.ExecuteNonQuery(dbCommand); //} public void UpdateExamArrange(ExamArrange examArrange) { XmlDocument doc = new XmlDocument(); //Request.PhysicalApplicationPath取得config文件路径 doc.Load(Path.Combine(HttpContext.Current.Request.PhysicalApplicationPath, "web.config")); XmlNode node = doc.SelectSingleNode("configuration/dataConfiguration/@defaultDatabase"); string value = node.Value; if (value == "Oracle") { OracleParameter para1 = new OracleParameter("p_User_Ids", OracleType.Clob); OracleParameter para2 = new OracleParameter("p_Exam_Arrange_Id", OracleType.Number); para2.Value = examArrange.ExamArrangeId; OracleParameter para3 = new OracleParameter("p_Begin_Time", OracleType.DateTime); para3.Value = examArrange.BeginTime; OracleParameter para4 = new OracleParameter("p_End_Time", OracleType.DateTime); para4.Value = examArrange.EndTime; OracleParameter para5 = new OracleParameter("p_Judge_Ids", OracleType.NVarChar); para5.Value = examArrange.JudgeIds; IDataParameter[] paras = new IDataParameter[] { para1, para2, para3, para4, para5 }; RunUpdateProcedure("USP_Exam_Arrange_U", paras, System.Text.Encoding.Unicode.GetBytes(examArrange.UserIds)); } }
public void UpdateExamArrange(ExamArrange examArrange) { dal.UpdateExamArrange(examArrange); }
public int AddExamArrange(ExamArrange examArrange) { return(dal.AddExamArrange(examArrange)); }
protected void ButtonSave_Click(object sender, ImageClickEventArgs e) { string strId = Request.QueryString.Get("id"); string strEndId = ""; for (int i = 0; i < this.Grid2.Rows.Count; i++) { string strEmId = ((Label)this.Grid2.Rows[i].FindControl("LabelEmployeeID")).Text; if (strEndId.Length == 0) { strEndId += strEmId; } else { strEndId += "," + strEmId; } } if (strEndId == "" || strEndId == "0") { SessionSet.PageMessage = "请选择考生!"; return; } int PaperId = 0; ExamBLL examBLL = new ExamBLL(); RailExam.Model.Exam exam = examBLL.GetExam(int.Parse(strId)); if (exam != null) { PaperId = exam.paperId; } if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "0") { ExamArrange examArrange = new ExamArrange(); examArrange.ExamId = int.Parse(strId); examArrange.PaperId = PaperId; examArrange.UserIds = strEndId; examArrange.JudgeIds = "1"; examArrange.BeginTime = DateTime.Now; examArrange.EndTime = DateTime.Now; examArrange.OrderIndex = 1; examArrange.Memo = ""; ExamArrangeBLL examArrangeBLL = new ExamArrangeBLL(); examArrangeBLL.AddExamArrange(examArrange); ViewState["UpdateMode"] = 1; SessionSet.PageMessage = "保存成功!"; return; } if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "1") { ExamArrangeBLL examArrangeBLL = new ExamArrangeBLL(); examArrangeBLL.UpdateExamUser(int.Parse(strId), strEndId); SessionSet.PageMessage = "保存成功!"; return; } }