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