protected void btnCancel_Click(object sender, EventArgs e)
{
//移除考生需要清楚考生安排明细
string strID = ViewState["ExamID"].ToString();
OracleAccess db = new OracleAccess();
//查询当前考试所有考生安排明细
string strSql = "select * from Random_Exam_Arrange_Detail where Random_Exam_ID=" + strID;
DataSet dsOther = db.RunSqlDataSet(strSql);
//遍历当前需要移除的考生信息，查询考生安排明细是否存在当前需要移除的考生，如果存在则需修改去除该考生
string[] str = ViewState["AddIds"].ToString().Split('|');
for (int i = 0; i < str.Length; i++)
{
string strReplace = "," + str[i] + ",";
DataRow[] drs = dsOther.Tables[0].Select("','+User_Ids+',' like '%" + strReplace + "%'");
if (drs.Length > 0)
{
strSql = "update Random_Exam_Arrange_Detail "
+ "set User_ids = substr(Replace(','||User_ids||',','" + strReplace +
"',','),2,length(Replace(','||User_ids||',','" + strReplace + "',','))-2) "
+ "where ','|| User_ids || ',' like '%" + strReplace + "%' and Random_Exam_ID=" + strID;
if (PrjPub.IsServerCenter)
{
db.ExecuteNonQuery(strSql);
}
else
{
string strConn = ConfigurationManager.ConnectionStrings["OracleCenter"].ConnectionString;
OracleAccess dbCenter = new OracleAccess(strConn);
dbCenter.ExecuteNonQuery(strSql);
RandomExamArrangeBLL objBll = new RandomExamArrangeBLL();
objBll.RefreshRandomExamArrange();
}
}
}
//查询考试在当前站段考试的考生信息
strSql = "select a.* from Random_Exam_Arrange_Detail a "
+ " inner join Computer_Room b on a.Computer_Room_ID=b.Computer_Room_ID"
+ " where Random_Exam_ID=" + ViewState["ExamID"];
DataSet ds = db.RunSqlDataSet(strSql);
string strEndId = string.Empty;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (strEndId.Length == 0)
{
strEndId += dr["User_Ids"].ToString();
}
else
{
strEndId += "," + dr["User_Ids"];
}
}
RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL();
if (!PrjPub.IsServerCenter)
{
examArrangeBLL.UpdateRandomExamArrangeToServer(int.Parse(ViewState["ExamID"].ToString()), strEndId);
}
else
{
examArrangeBLL.UpdateRandomExamArrange(int.Parse(ViewState["ExamID"].ToString()), strEndId);
}
Response.Write("<script>top.returnValue ='true';top.close();</script>");
}
protected void SaveChoose()
{
string strId = ViewState["ExamID"].ToString();
string strEndId = "";
//for (int i = 0; i < this.gvChoose.Rows.Count; i++)
//{
// string strEmId = ((Label)this.gvChoose.Rows[i].FindControl("LabelEmployeeID")).Text;
// if (strEndId.Length == 0)
// {
// strEndId += strEmId;
// }
// else
// {
// if (strEndId == "0")
// {
// strEndId = strEmId;
// }
// else
// {
// strEndId += "," + strEmId;
// }
// }
//}
//if (ViewState["HasExamId"].ToString() != "" && strEndId != "")
//{
// strEndId = ViewState["HasExamId"].ToString() + "," + strEndId;
//}
//else
//{
// strEndId = "";
//}
//if (strEndId == "")
//{
// strEndId = "0";
//}
OracleAccess db = new OracleAccess();
//查询考试在当前站段考试的考生信息
string strSql = "select a.* from Random_Exam_Arrange_Detail a "
+ " inner join Computer_Room b on a.Computer_Room_ID=b.Computer_Room_ID"
+ " where Random_Exam_ID=" + strId;
DataSet ds = db.RunSqlDataSet(strSql);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (strEndId.Length == 0)
{
strEndId += dr["User_Ids"].ToString();
}
else
{
strEndId += "," + dr["User_Ids"];
}
}
//新增
if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "0")
{
RandomExamArrange examArrange = new RandomExamArrange();
examArrange.RandomExamId = int.Parse(strId);
examArrange.UserIds = strEndId;
examArrange.Memo = "";
RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL();
if (!PrjPub.IsServerCenter)
{
examArrangeBLL.AddRandomExamArrangeToServer(examArrange);
}
else
{
examArrangeBLL.AddRandomExamArrange(examArrange);
}
ViewState["UpdateMode"] = 1;
SessionSet.PageMessage = "保存成功！";
return;
}
//修改
if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "1")
{
RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL();
if (!PrjPub.IsServerCenter)
{
examArrangeBLL.UpdateRandomExamArrangeToServer(int.Parse(strId), strEndId);
}
else
{
examArrangeBLL.UpdateRandomExamArrange(int.Parse(strId), strEndId);
}
SessionSet.PageMessage = "保存成功！";
return;
}
}
