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