protected void SaveChoose() { string strId = Request.QueryString.Get("id"); string strEndId = ViewState["ChooseId"].ToString(); //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 (strEndId == "") { strEndId = "0"; } 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(); examArrangeBLL.AddRandomExamArrange(examArrange); ViewState["UpdateMode"] = 1; SessionSet.PageMessage = "保存成功!"; return; } if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "1") { RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL(); examArrangeBLL.UpdateRandomExamArrange(int.Parse(strId), strEndId); SessionSet.PageMessage = "保存成功!"; return; } }
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; } 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(); examArrangeBLL.AddRandomExamArrange(examArrange); ViewState["UpdateMode"] = 1; SessionSet.PageMessage = "保存成功!"; return; } if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "1") { RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL(); examArrangeBLL.UpdateRandomExamArrange(int.Parse(strId), strEndId); SessionSet.PageMessage = "保存成功!"; return; } }
private void SaveRandomExamArrange(string strExamID, string strTrainClassID, string strPostID) { string strSql = ""; Hashtable htUserID = new Hashtable(); string strUserIDs = string.Empty; OracleAccess db = new OracleAccess(); string[] str = strTrainClassID.Split(','); for (int j = 0; j < str.Length; j++) { strSql = "select a.Employee_ID " + "from ZJ_Train_Plan_Employee a " + " inner join Employee b on a.Employee_ID=b.Employee_ID " + " where a.Train_Class_ID=" + str[j] + " and b.Post_ID in (" + strPostID + ")"; DataSet ds = db.RunSqlDataSet(strSql); foreach (DataRow dr in ds.Tables[0].Rows) { if (!htUserID.ContainsKey(dr["Employee_ID"].ToString())) { if (strUserIDs == string.Empty) { strUserIDs = dr["Employee_ID"].ToString(); } else { strUserIDs = strUserIDs + "," + dr["Employee_ID"]; } htUserID.Add(dr["Employee_ID"].ToString(), dr["Employee_ID"].ToString()); } } } RandomExamArrangeBLL objArrangeBll = new RandomExamArrangeBLL(); RandomExamArrange objArrange = new RandomExamArrange(); objArrange.RandomExamId = Convert.ToInt32(strExamID); objArrange.Memo = ""; objArrange.UserIds = strUserIDs; objArrangeBll.AddRandomExamArrange(objArrange); }
protected void btnOK_Click(object sender, EventArgs e) { try { string examId = Request.QueryString.Get("examID"); RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam objRandomExam = objBll.GetExam(Convert.ToInt32(examId)); if (objRandomExam.IsStart != 2) { SessionSet.PageMessage = "考试还未结束不能生成补考试卷!"; return; } //OrganizationBLL OrgBll = new OrganizationBLL(); //Organization org = OrgBll.GetOrganization(objRandomExam.OrgId); //if (org.SuitRange != 1 && !objRandomExam.IsUpload) //{ // Grid1.DataBind(); // SessionSet.PageMessage = "考试为站段考试,还未上传考试成绩不能生成补考试卷!"; // return; //} if (objRandomExam.HasTrainClass) { string strTrainClassID = ""; RandomExamTrainClassBLL trainClassBLL = new RandomExamTrainClassBLL(); IList <RandomExamTrainClass> trainClasses = trainClassBLL.GetRandomExamTrainClassByRandomExamID(Convert.ToInt32(examId)); foreach (RandomExamTrainClass trainClass in trainClasses) { if (strTrainClassID == "") { strTrainClassID = "'" + trainClass.TrainClassID + "'"; } else { strTrainClassID = strTrainClassID + ",'" + trainClass.TrainClassID + "'"; } } } string OrganizationName = ""; string strExamineeName = ""; decimal dScoreLower = 0; decimal dScoreUpper = 1000; IList <RandomExamResult> examResults = null; RandomExamResultBLL bllExamResult = new RandomExamResultBLL(); examResults = bllExamResult.GetRandomExamResults(objRandomExam.RandomExamId, OrganizationName, "", strExamineeName, string.Empty, dScoreLower, dScoreUpper, objRandomExam.OrgId); string strID = string.Empty; string strNoPass = string.Empty; foreach (RandomExamResult result in examResults) { if (strID == string.Empty) { strID = result.ExamineeId.ToString(); } else { strID = strID + "," + result.ExamineeId; } //当补考考生不为未参加考试考生时 if (ddlSelect.SelectedValue != "2") { if (result.Score < objRandomExam.PassScore) { if (strNoPass == string.Empty) { strNoPass = result.ExamineeId.ToString(); } else { strNoPass = strNoPass + "," + result.ExamineeId; } } } } RandomExamArrangeBLL objArrangebll = new RandomExamArrangeBLL(); IList <RandomExamArrange> objArrangeList = objArrangebll.GetRandomExamArranges(objRandomExam.RandomExamId); string strChooseID = string.Empty; if (objArrangeList.Count > 0) { strChooseID = objArrangeList[0].UserIds; } string[] str = strChooseID.Split(','); string strNoResult = string.Empty; //当补考考生不为不及格考生时 if (ddlSelect.SelectedValue != "1") { for (int i = 0; i < str.Length; i++) { if (("," + strID + ",").IndexOf(("," + str[i] + ",")) < 0) { if (strNoResult == string.Empty) { strNoResult = str[i]; } else { strNoResult = strNoResult + "," + str[i]; } } } } string strTotal = string.Empty; if (strNoResult == string.Empty && strNoPass == string.Empty) { strTotal = string.Empty; } else if (strNoResult == string.Empty && strNoPass != string.Empty) { strTotal = strNoPass; } else if (strNoResult != string.Empty && strNoPass == string.Empty) { strTotal = strNoResult; } else if (strNoResult != string.Empty && strNoPass != string.Empty) { strTotal = strNoPass + "," + strNoResult; } if (strTotal == string.Empty) { SessionSet.PageMessage = "所选考试无考试不及格和未参加考试学员,不需生成补考考试!"; return; } int nowExamID = objBll.AddResetRandomExam(objRandomExam.RandomExamId); if (nowExamID == 0) { SessionSet.PageMessage = "复制失败!"; return; } RandomExamArrange objArrange = new RandomExamArrange(); objArrange.RandomExamId = nowExamID; objArrange.UserIds = strTotal; objArrange.Memo = string.Empty; int newArrangeId = objArrangebll.AddRandomExamArrange(objArrange); OracleAccess db = new OracleAccess(); string strSql = "select * from Random_Exam_Arrange_Detail where Random_Exam_ID=" + objRandomExam.RandomExamId; DataSet ds = db.RunSqlDataSet(strSql); str = strTotal.Split(','); foreach (DataRow dr in ds.Tables[0].Rows) { string strArrange = string.Empty; for (int i = 0; i < str.Length; i++) { if (("," + dr["User_Ids"] + ",").IndexOf("," + str[i] + ",") >= 0) { if (strArrange == string.Empty) { strArrange = str[i]; } else { strArrange += "," + str[i]; } } } if (strArrange != string.Empty) { 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_random_exam_arrange_de_id", OracleType.Number); para2.Direction = ParameterDirection.Output; OracleParameter para3 = new OracleParameter("p_random_exam_arrange_Id", OracleType.Number); para3.Value = newArrangeId; OracleParameter para4 = new OracleParameter("p_random_Exam_ID", OracleType.Number); para4.Value = nowExamID; OracleParameter para5 = new OracleParameter("p_computer_room_id", OracleType.Number); para5.Value = Convert.ToInt32(dr["Computer_Room_ID"].ToString()); IDataParameter[] paras = new IDataParameter[] { para1, para2, para3, para4, para5 }; id = Pub.RunAddProcedure(false, "USP_RANDOM_EXAM_ARRANGE_DE_I", paras, System.Text.Encoding.Unicode.GetBytes(strArrange)); } } } //向Random_Exam_Computer_Server 机房考试状态表 插入记录 strSql = "select c.Computer_Server_No from Random_Exam_Arrange_Detail a " + " inner join Computer_Room b on a.Computer_Room_ID=b.Computer_Room_ID " + " inner join Computer_Server c on c.Computer_Server_ID=b.Computer_Server_ID " + " where a.Random_Exam_ID=" + nowExamID; DataSet dsComputer = db.RunSqlDataSet(strSql); string serverNo = ""; foreach (DataRow dr in dsComputer.Tables[0].Rows) { if (serverNo != dr["Computer_Server_No"].ToString()) { serverNo = dr["Computer_Server_No"].ToString(); strSql = "insert into Random_Exam_Computer_Server" + "(Random_Exam_ID,Computer_Server_No,Status_ID,Is_Start,Has_Paper," + "Random_Exam_Code,Is_Upload,DownLoaded) " + "values (" + nowExamID + "," + serverNo + ",0,0,0,'',0,0)"; db.ExecuteNonQuery(strSql); } } Response.Write("<script>top.returnValue='true';top.close();</script>"); } catch { SessionSet.PageMessage = "复制失败!"; } }
private void SaveArrange() { OracleAccess db = new OracleAccess(); // 根据 ProgressBar.htm 显示进度条界面 string templateFileName = Path.Combine(Server.MapPath("../RandomExam/"), "ProgressBar.htm"); StreamReader reader = new StreamReader(@templateFileName, System.Text.Encoding.GetEncoding("gb2312")); string html = reader.ReadToEnd(); reader.Close(); Response.Write(html); Response.Flush(); System.Threading.Thread.Sleep(200); string jsBlock; string strExamID = Request.QueryString.Get("examID"); string strTrainClassID = Request.QueryString.Get("trainclassID"); string strPostID = Request.QueryString.Get("PostID"); string[] str = strTrainClassID.Split(','); string strArchivesID = string.Empty; for (int j = 0; j < str.Length; j++) { if (strArchivesID == string.Empty) { strArchivesID = "'" + str[j] + "'"; } else { strArchivesID = strArchivesID + ",'" + str[j] + "'"; } } string strSql = ""; Hashtable htUserID = new Hashtable(); string strUserIDs = string.Empty; int i = 1; strSql = "select distinct b.Employee_ID " + "from CheckRoll_Info a " + " inner join Employee@LINK_RAILEXAM b on a.Employee_ID=b.Employee_ID" + " where a.Archives_ID in (" + strArchivesID + ") and b.Post_ID in (" + strPostID + ")"; int count = db.RunSqlDataSet(strSql).Tables[0].Rows.Count; for (int j = 0; j < str.Length; j++) { strSql = "select b.Employee_ID " + "from CheckRoll_Info a " + " inner join Employee@LINK_RAILEXAM b on a.Employee_ID=b.Employee_ID" + " where a.Archives_ID='" + str[j] + "' and b.Post_ID in (" + strPostID + ")"; DataSet ds = db.RunSqlDataSet(strSql); foreach (DataRow dr in ds.Tables[0].Rows) { if (!htUserID.ContainsKey(dr["Employee_ID"].ToString())) { if (strUserIDs == string.Empty) { strUserIDs = dr["Employee_ID"].ToString(); } else { strUserIDs = strUserIDs + "," + dr["Employee_ID"]; } htUserID.Add(dr["Employee_ID"].ToString(), dr["Employee_ID"].ToString()); System.Threading.Thread.Sleep(10); jsBlock = "<script>SetPorgressBar('正在添加考生','" + ((i * 100) / ((double)count)).ToString("0.00") + "'); </script>"; Response.Write(jsBlock); Response.Flush(); i++; } } } RandomExamArrangeBLL objArrangeBll = new RandomExamArrangeBLL(); RandomExamArrange objArrange = new RandomExamArrange(); objArrange.RandomExamId = Convert.ToInt32(strExamID); objArrange.Memo = ""; objArrange.UserIds = strUserIDs; objArrangeBll.AddRandomExamArrange(objArrange); jsBlock = "<script>SetCompleted('处理完成。'); </script>"; Response.Write(jsBlock); Response.Flush(); Response.Write("<script>top.returnValue='true';window.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; } }
protected void btnInput_Click(object sender, EventArgs e) { if (ViewState["EmptyFlag"].ToString() != null && ViewState["EmptyFlag"].ToString() == "1") { return; } string strId = Request.QueryString.Get("id"); string strAllId = hfrbnID.Value; IList <RailExam.Model.Employee> Employees = null; EmployeeBLL psBLL = new EmployeeBLL(); Employees = psBLL.GetEmployeesSelect(Convert.ToInt32(ddlOrg.SelectedValue), ViewState["PinYin"].ToString(), ViewState["WorkNo"].ToString(), ViewState["EmployeeName"].ToString(), "a.employee_Name"); for (int i = 0; i < Employees.Count; i++) { string strEmId = Employees[i].EmployeeID.ToString(); string strOldAllId = strAllId; if (strOldAllId == strEmId) { strAllId = strEmId; } } ViewState["ChooseId"] = strAllId; if (strAllId == "") { SessionSet.PageMessage = "请选择考生!"; return; } else { RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam random = objBll.GetExam(int.Parse(strId)); if (random.RandomExamModularTypeID > 1) { OracleAccess db = new OracleAccess(); string strSql = "select * from Random_Exam_Modular_Type where Random_Exam_Modular_Type_ID=" + random.RandomExamModularTypeID; DataRow dr = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; strSql = "select * from Random_Exam_Modular_Type where Level_Num=" + (Convert.ToInt32(dr["Level_NUM"]) - 1); DataRow drPre = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; strSql = " select a.* " + "from Random_Exam_Result a " + " inner join Random_Exam b on a.Random_Exam_ID=b.Random_Exam_ID " + " left join Random_Exam_Modular_Type c on b.Random_Exam_Modular_Type_ID=c.Random_Exam_Modular_Type_ID " + " where c.Level_Num=" + (Convert.ToInt32(dr["Level_NUM"]) - 1); DataSet ds = db.RunSqlDataSet(strSql); strSql = "select * from Employee where Employee_ID = " + strAllId; DataRow drEmp = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; string strErrorMessage = string.Empty; DataRow[] drs = ds.Tables[0].Select("EXAMINEE_ID=" + strAllId); if (drs.Length == 0) { strErrorMessage = "所选考生【" + drEmp["Employee_Name"] + "】未能通过【" + drPre["Random_Exam_Modular_Type_Name"] + "】考试,不能参加【" + dr["Random_Exam_Modular_Type_Name"] + "】考试!"; } if (!string.IsNullOrEmpty(strErrorMessage)) { SessionSet.PageMessage = strErrorMessage; return; } } } if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "0") { RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL(); IList <RandomExamArrange> objList = examArrangeBLL.GetRandomExamArranges(int.Parse(strId)); if (objList.Count == 0) { RandomExamArrange examArrange = new RandomExamArrange(); examArrange.RandomExamId = int.Parse(strId); examArrange.UserIds = strAllId; examArrange.Memo = ""; examArrangeBLL.AddRandomExamArrange(examArrange); ViewState["UpdateMode"] = 1; if (txtWorkNo.Text != "") { txtWorkNo.Text = ""; txtWorkNo.Focus(); } if (txtPinYin.Text != "") { txtPinYin.Text = ""; txtPinYin.Focus(); } if (txtEmployeeName.Text != "") { txtEmployeeName.Text = ""; txtEmployeeName.Focus(); } BindEmptyGrid1(); SessionSet.PageMessage = "添加成功!"; return; } else { ViewState["UpdateMode"] = "1"; } } if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "1") { RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL(); string strEndId = examArrangeBLL.GetRandomExamArranges(int.Parse(strId))[0].UserIds; if (("," + strEndId + ",").IndexOf("," + strAllId + ",") >= 0) { SessionSet.PageMessage = "该学员已添加!"; return; } if (strEndId == "") { examArrangeBLL.UpdateRandomExamArrange(int.Parse(strId), strAllId); } else { examArrangeBLL.UpdateRandomExamArrange(int.Parse(strId), strEndId + "," + strAllId); } if (txtWorkNo.Text != "") { txtWorkNo.Text = ""; txtWorkNo.Focus(); } if (txtPinYin.Text != "") { txtPinYin.Text = ""; txtPinYin.Focus(); } if (txtEmployeeName.Text != "") { txtEmployeeName.Text = ""; txtEmployeeName.Focus(); } BindEmptyGrid1(); SessionSet.PageMessage = "添加成功!"; ClientScript.RegisterClientScriptBlock(GetType(), "", " window.opener.form1.Refresh.value = 'true',window.opener.form1.submit();", true); return; } }
protected void SaveChoose() { string strId = Request.QueryString.Get("id"); string strEndId = ViewState["ChooseId"].ToString(); if (strEndId == "") { strEndId = "0"; } else { RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam random = objBll.GetExam(int.Parse(strId)); if (random.RandomExamModularTypeID > 1) { OracleAccess db = new OracleAccess(); string strSql = "select * from Random_Exam_Modular_Type where Random_Exam_Modular_Type_ID=" + random.RandomExamModularTypeID; DataRow dr = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; strSql = "select * from Random_Exam_Modular_Type where Level_Num=" + (Convert.ToInt32(dr["Level_NUM"]) - 1); DataRow drPre = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; strSql = " select a.* " + "from Random_Exam_Result a " + " inner join Random_Exam b on a.Random_Exam_ID=b.Random_Exam_ID " + " left join Random_Exam_Modular_Type c on b.Random_Exam_Modular_Type_ID=c.Random_Exam_Modular_Type_ID " + " where c.Level_Num=" + (Convert.ToInt32(dr["Level_NUM"]) - 1); DataSet ds = db.RunSqlDataSet(strSql); strSql = "select * from Employee where Employee_ID in (" + strEndId + ")"; DataSet dsEmp = db.RunSqlDataSet(strSql); string[] str = strEndId.Split(','); string strErrorMessage = string.Empty; for (int i = 0; i < str.Length; i++) { DataRow[] drs = ds.Tables[0].Select("EXAMINEE_ID=" + str[i]); if (drs.Length == 0) { DataRow[] drsEmp = dsEmp.Tables[0].Select("Employee_ID=" + str[i]); strErrorMessage = "所选考生【" + drsEmp[0]["Employee_Name"] + "】未能通过【" + drPre["Random_Exam_Modular_Type_Name"] + "】考试,不能参加【" + dr["Random_Exam_Modular_Type_Name"] + "】考试!"; break; } } if (!string.IsNullOrEmpty(strErrorMessage)) { SessionSet.PageMessage = strErrorMessage; return; } } } if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "0") { RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL(); IList <RandomExamArrange> objList = examArrangeBLL.GetRandomExamArranges(int.Parse(strId)); if (objList.Count == 0) { RandomExamArrange examArrange = new RandomExamArrange(); examArrange.RandomExamId = int.Parse(strId); examArrange.UserIds = strEndId; examArrange.Memo = ""; if (!string.IsNullOrEmpty(Request.QueryString.Get("selectType")) && !PrjPub.IsServerCenter) { examArrangeBLL.AddRandomExamArrangeToServer(examArrange); } else { examArrangeBLL.AddRandomExamArrange(examArrange); } ViewState["UpdateMode"] = 1; if (!string.IsNullOrEmpty(Request.QueryString.Get("selectType"))) { Response.Write("<script>alert('添加成功!');window.opener.form1.Refresh.value='true';window.opener.form1.submit();window.close();</script>"); } else { string strSql = ""; OracleAccess db = new OracleAccess(); strSql = "update Random_Exam set Is_All_Arrange = 0 where Random_Exam_ID=" + strId; db.ExecuteNonQuery(strSql); SessionSet.PageMessage = "添加成功!"; return; } } else { ViewState["UpdateMode"] = "1"; } } if (ViewState["UpdateMode"] != null && ViewState["UpdateMode"].ToString() == "1") { RandomExamArrangeBLL examArrangeBLL = new RandomExamArrangeBLL(); IList <RandomExamArrange> objList = examArrangeBLL.GetRandomExamArranges(int.Parse(strId)); string strNew = objList[0].UserIds; string[] str = strEndId.Split(','); for (int i = 0; i < str.Length; i++) { if (("," + strNew + ",").IndexOf("," + str[i] + ",") < 0) { strNew += strNew == string.Empty ? str[i] : "," + str[i]; } } if (!string.IsNullOrEmpty(Request.QueryString.Get("selectType"))) { //examArrangeBLL.UpdateRandomExamArrangeToServer(int.Parse(strId), strAdd); string strAddIds = string.Empty; for (int i = 0; i < str.Length; i++) { if (("," + objList[0].UserIds + ",").IndexOf("," + str[i] + ",") < 0) { strAddIds += strAddIds == string.Empty ? str[i] : "," + str[i]; } } OracleAccess db = new OracleAccess(); OracleAccess dbCenter = new OracleAccess(System.Configuration.ConfigurationManager.ConnectionStrings["OracleCenter"].ConnectionString); 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_random_Exam_ID", OracleType.Number); para2.Value = int.Parse(strId); IDataParameter[] paras = new IDataParameter[] { para1, para2 }; examArrangeBLL.RunUpdateProcedure(true, "USP_random_Exam_Arrange_U", paras, System.Text.Encoding.Unicode.GetBytes(strEndId)); } string strSql = "select a.* from Random_Exam_Arrange_Detail a " + " inner join Computer_Room b on a.Computer_Room_ID=b.Computer_Room_ID" + " inner join Computer_Server c on c.Computer_server_ID=b.Computer_Server_ID" + " where c.Computer_Server_No='" + PrjPub.ServerNo + "' " + " and Random_Exam_ID=" + strId; DataSet ds = db.RunSqlDataSet(strSql); strSql = "update Random_Exam_Arrange_Detail " + "set User_ids = User_ids || '," + strAddIds + "' " + "where Random_Exam_Arrange_Detail_ID =" + ds.Tables[0].Rows[0]["Random_Exam_Arrange_Detail_ID"]; dbCenter.ExecuteNonQuery(strSql); if (!PrjPub.IsServerCenter) { examArrangeBLL.RefreshRandomExamArrange(); } } else { examArrangeBLL.UpdateRandomExamArrange(int.Parse(strId), strNew); } if (!string.IsNullOrEmpty(Request.QueryString.Get("selectType"))) { //SessionSet.PageMessage = "添加成功!"; Response.Write("<script>alert('添加成功!');window.opener.form1.Refresh.value='true';window.opener.form1.submit();window.close();</script>"); } else { string strSql = ""; OracleAccess db = new OracleAccess(); strSql = "update Random_Exam set Is_All_Arrange = 0 where Random_Exam_ID=" + strId; db.ExecuteNonQuery(strSql); SessionSet.PageMessage = "添加成功!"; return; } } }