protected void btnOk_Click(object sender, EventArgs e) { OracleAccess db = new OracleAccess(); string strSql = "select * from Employee where Employee_ID=" + ViewState["EmployeeID"]; DataRow dr = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; int orgID; if (ddlWorkgroup.SelectedValue != "0") { orgID = Convert.ToInt32(ddlWorkgroup.SelectedValue); } else { orgID = Convert.ToInt32(ddlWorkshop.SelectedValue); } OrganizationBLL organizationBLL = new OrganizationBLL(); EmployeeBLL objEmployeeBll = new EmployeeBLL(); IList <RailExam.Model.Employee> objView = objEmployeeBll.GetEmployeeByWhereClause("GetStationOrgID(a.Org_ID)=" + organizationBLL.GetStationOrgID(orgID) + " and Work_No='" + txtWorkNo.Text.Trim() + "'"); if (objView.Count > 0) { SessionSet.PageMessage = "该员工编码在本单位已经存在!"; return; } strSql = "update Employee " + " set Employee_Name='" + txtName.Text + "'," + "Org_ID=" + orgID + "," + "Work_No='" + txtWorkNo.Text + "'," + "identity_CardNo='" + txtPostNo.Text + "'," + "PinYin_Code='" + Pub.GetChineseSpell(txtName.Text) + "' " + " where Employee_ID=" + ViewState["EmployeeID"]; db.ExecuteNonQuery(strSql); strSql = "insert into ZJ_Employee_Work " + " values(Employee_Work_Seq.nextval, " + dr["EMPLOYEE_ID"] + ", to_char(sysdate,'yyyy-mm-dd')," + dr["org_id"] + "," + orgID + "," + dr["Post_ID"] + "," + dr["Post_ID"] + "," + "'',sysdate,'" + PrjPub.CurrentLoginUser.EmployeeName + "'," + "to_date('" + dr["Post_Date"] + "','YYYY-MM-DD HH24:MI:SS'))"; db.ExecuteNonQuery(strSql); string transferID = Request.QueryString.Get("transferID"); EmployeeTransferBLL objTransferBll = new EmployeeTransferBLL(); objTransferBll.DeleteEmployeeTransfer(Convert.ToInt32(transferID)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("将" + dr["Employee_Name"] + "调至" + lblOrg.Text); Response.Write("<script>window.returnValue='true';window.close();</script>"); }
protected void DownloadItem() { string srcPath = @"\\" + ConfigurationManager.AppSettings["ServerIP"] + "\\Item\\"; string aimPath = Server.MapPath("../Online/Item/"); CopyItem(srcPath, aimPath); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("下载最新电子教材"); }
//保存数据 private void saveData() { string type = Request.QueryString["Type"];//1为修改 2为新增 string id = Request.QueryString["ID"]; OracleAccess db = new OracleAccess(); string strSql = ""; if (!string.IsNullOrEmpty(txtIDENTITY_CARDNO.Text.Trim())) { if (type == "1") { strSql = "select a.*,GetOrgName(GetStationOrgID(a.Org_ID)) OrgName from Employee a where Identity_CardNo='" + txtIDENTITY_CARDNO.Text.Trim() + "' and Employee_ID<>" + id; } else { strSql = "select a.*,GetOrgName(GetStationOrgID(a.Org_ID)) OrgName from Employee a where Identity_CardNo='" + txtIDENTITY_CARDNO.Text.Trim() + "'"; } DataSet ds = db.RunSqlDataSet(strSql); if (ds.Tables[0].Rows.Count > 0) { string strName = ds.Tables[0].Rows[0]["Employee_Name"].ToString(); string orgName = ds.Tables[0].Rows[0]["OrgName"].ToString(); SessionSet.PageMessage = "该身份证号码在系统中已存在,与【" + orgName + "】的【" + strName + "】身份证号相同!"; return; } } if (!string.IsNullOrEmpty(txtWORK_NO.Text.Trim())) { if (type == "1") { strSql = "select a.*,GetOrgName(GetStationOrgID(a.Org_ID)) OrgName from Employee a where Work_No='" + txtWORK_NO.Text.Trim() + "' and Employee_ID<>" + id; } else { strSql = "select a.*,GetOrgName(GetStationOrgID(a.Org_ID)) OrgName from Employee a where Work_No='" + txtWORK_NO.Text.Trim() + "'"; } DataSet ds = db.RunSqlDataSet(strSql); if (ds.Tables[0].Rows.Count > 0) { string strName = ds.Tables[0].Rows[0]["Employee_Name"].ToString(); string orgName = ds.Tables[0].Rows[0]["OrgName"].ToString(); SessionSet.PageMessage = "该岗位培训合格证书编号在系统中已存在,与【" + orgName + "】的【" + strName + "】岗位培训合格证书编号相同!"; //ClientScript.RegisterStartupScript(GetType(), "OK", "alert('该岗位培训合格证书编号在系统中已存在,\r\n与【" + orgName + "】的【" + strName + "】岗位培训合格证书编号相同!');", true); return; } } string sqlStr = string.Empty; DateTime isnulldate = new DateTime(0001, 01, 01); DateTime birthday, begin_date, join_rail_date, workgroupleader_order_date, award_date; DateTime postDate, //任现职名时间 technicalTitleDate, //技术职称聘任时间 technicalDate, //技能等级取得时间 graduateDate; //毕业时间 string graduateUniversity, //毕业院校 studyMajor, //所学专业 universityType; //学校类别 if (!DateTime.TryParse(this.dateBIRTHDAY.DateValue.ToString(), out birthday)) { birthday = isnulldate; } if (!DateTime.TryParse(this.dateBEGIN_DATE.DateValue.ToString(), out begin_date)) { begin_date = isnulldate; } if (!DateTime.TryParse(this.dateJOIN_RAIL_DATE.DateValue.ToString(), out join_rail_date)) { join_rail_date = isnulldate; } if (ddlWORKGROUPLEADER_TYPE_ID.SelectedValue != "-1") { if (!DateTime.TryParse(this.dateWORKGROUPLEADER_ORDER_DATE.DateValue.ToString(), out workgroupleader_order_date)) { workgroupleader_order_date = isnulldate; } } else { workgroupleader_order_date = isnulldate; } if (!DateTime.TryParse(this.dateAWARD_DATE.DateValue.ToString(), out award_date)) { award_date = isnulldate; } if (!DateTime.TryParse(this.datePost.DateValue.ToString(), out postDate)) { postDate = isnulldate; } if (!DateTime.TryParse(this.dateTechnicalDate.DateValue.ToString(), out technicalDate)) { technicalDate = isnulldate; } if (!DateTime.TryParse(this.dateTechnicalTitle.DateValue.ToString(), out technicalTitleDate)) { technicalTitleDate = isnulldate; } if (!DateTime.TryParse(this.dateGraduate.DateValue.ToString(), out graduateDate)) { graduateDate = isnulldate; } if (this.txtMEMO.Text.ToString().Length > 50) { ClientScript.RegisterStartupScript(GetType(), "OK", "alert('备注不能超过50个字符!');", true); return; } OracleAccess ora = new OracleAccess(); int ISONPOST = this.cbISONPOST.Checked == true ? 1 : 0; if (!string.IsNullOrEmpty(type)) { int typeBool = int.Parse(type); if (typeBool == 1) { sqlStr = "update employee set org_id= '" + Convert.ToInt32(hfOrgID.Value) + "',"; sqlStr += "post_no= '" + this.txtPOST_NO.Text.Trim() + "',"; sqlStr += "employee_name= '" + this.txtEMPLOYEE_NAME.Text.Trim() + "',"; sqlStr += "pinyin_code= '" + this.txtPinYin.Text.Trim() + "',"; sqlStr += "post_id= '" + Convert.ToInt32(this.hfPostID.Value) + "',"; sqlStr += "now_post_id= " + (hfNowPostID.Value == "" ? "null" : "'" + hfNowPostID.Value + "'") + ","; sqlStr += "sex= '" + this.ddlSex.SelectedValue + "',"; sqlStr += "birthday=to_date('" + birthday + "','yyyy-mm-dd hh24:mi:ss'),"; sqlStr += "native_place= '" + this.txtNATIVE_PLACE.Text.Trim() + "',"; sqlStr += "folk= '" + this.txtFOLK.Text.Trim() + "',"; sqlStr += "wedding= '" + Convert.ToInt32(this.rblWEDDING.SelectedValue) + "',"; sqlStr += "begin_date= to_date('" + begin_date + "','yyyy-mm-dd hh24:mi:ss'),"; sqlStr += "IsOnPost= '" + ISONPOST + "',"; sqlStr += "memo= '" + this.txtMEMO.Text.Trim() + "',"; sqlStr += "is_group_leader= '" + Convert.ToInt32(this.ddlIsGroup.SelectedValue) + "',"; sqlStr += "technician_type_id = '" + int.Parse(this.ddlTECHNICIAN_TYPE_ID.SelectedValue) + "',"; sqlStr += "technical_title_id='" + int.Parse(this.ddlTECHNICAL_TITLE_ID.SelectedValue) + "',"; sqlStr += "work_no='" + this.txtWORK_NO.Text.Trim() + "',"; sqlStr += "identity_cardno='" + this.txtIDENTITY_CARDNO.Text.Trim() + "',"; sqlStr += "political_status_id='" + int.Parse(this.ddlPOLITICAL_STATUS.SelectedValue) + "',"; sqlStr += "join_rail_date=to_date('" + join_rail_date + "','yyyy-mm-dd hh24:mi:ss'),"; sqlStr += "education_level_id='" + int.Parse(this.DDLeducation_level_id.SelectedValue) + "',"; sqlStr += "employee_type_id='" + int.Parse(this.ddlEMPLOYEE_TYPE_ID.SelectedValue) + "',"; sqlStr += "second_post_id=" + (this.hfSECOND_POST_ID.Value == "" ? "NULL" : hfSECOND_POST_ID.Value) + ","; sqlStr += "third_post_id=" + (this.hfTHIRD_POST_ID.Value == "" ? "NULL" : hfTHIRD_POST_ID.Value) + ","; sqlStr += "workgroupleader_type_id='" + int.Parse(this.ddlWORKGROUPLEADER_TYPE_ID.SelectedValue) + "'," + "workgroupleader_order_date=to_date('" + workgroupleader_order_date + "','yyyy-mm-dd hh24:mi:ss')," + "education_employee_type_id='" + int.Parse(this.ddlEDUCATION_EMPLOYEE_TYPE_ID.SelectedValue) + "'," + "committee_head_ship_id='" + int.Parse(this.ddlCOMMITTEE_HEAD_SHIP_ID.SelectedValue) + "'," + "isregistered='" + int.Parse(this.ddlISREGISTERED.SelectedValue) + "'," + "employee_transport_type_id='" + int.Parse(this.ddlEMPLOYEE_TRANSPORT_TYPE_ID.SelectedValue) + "'," + "award_date=to_date('" + award_date + "','yyyy-mm-dd hh24:mi:ss')," + "could_post_id='" + this.hfCOULD_POST_ID.Value.Trim().ToString() + "'," + "TECHNICAL_DATE = to_date('" + technicalDate + "','yyyy-mm-dd hh24:mi:ss')," + "TECHNICAL_TITLE_DATE = to_date('" + technicalTitleDate + "','yyyy-mm-dd hh24:mi:ss')," + "POST_DATE = to_date('" + postDate + "','yyyy-mm-dd hh24:mi:ss')," + "GRADUATE_DATE = to_date('" + graduateDate + "','yyyy-mm-dd hh24:mi:ss')," + "GRADUATE_UNIVERSITY = '" + this.txtFinishSchool.Text + "'," + "STUDY_MAJOR = '" + this.txtMajor.Text + "'," + "UNIVERSITY_TYPE = '" + this.dropSchoolCategory.SelectedValue + "'," + "TECHNICAL_CODE = '" + this.txtTechnicalCode.Text + "'," + "Safe_Level_ID=" + (ddlSafe.SelectedValue == "" ? "NULL" : ddlSafe.SelectedValue) + " where employee_id = " + id; } else if (typeBool == 2) { sqlStr = "select EMPLOYEE_SEQ.NEXTVAL from dual"; id = ora.RunSqlDataSet(sqlStr).Tables[0].Rows[0][0].ToString(); sqlStr = "insert into employee (employee_id," + "org_id," + "post_no," + "employee_name," + "pinyin_code," + "post_id," + "sex," + "birthday," + "native_place," + "folk," + "wedding," + "begin_date," + "IsOnPost," + "memo," + "is_group_leader," + "technician_type_id," + "technical_title_id," + "work_no," + //"photo," + "identity_cardno," + "political_status_id," + "join_rail_date," + "education_level_id," + "employee_type_id," + "second_post_id," + "third_post_id," + "workgroupleader_type_id," + "workgroupleader_order_date," + "education_employee_type_id," + "committee_head_ship_id," + "isregistered," + "employee_transport_type_id," + "award_date," + "could_post_id," + "TECHNICAL_DATE," + "TECHNICAL_TITLE_DATE," + "POST_DATE," + "GRADUATE_UNIVERSITY," + "GRADUATE_DATE," + "STUDY_MAJOR," + "UNIVERSITY_TYPE," + "TECHNICAL_CODE,Safe_Level_ID,Now_Post_ID)" + " values(" + id + "," + Convert.ToInt32(this.hfOrgID.Value) + ",'" + this.txtPOST_NO.Text.Trim().ToString() + "','" + this.txtEMPLOYEE_NAME.Text.Trim().ToString() + "','" + Pub.GetChineseSpell(this.txtEMPLOYEE_NAME.Text.Trim().ToString()) + "'," + Convert.ToInt32(this.hfPostID.Value) + ",'" + this.ddlSex.SelectedValue + "'," + "to_date('" + birthday + "','yyyy-mm-dd hh24:mi:ss'),'" + this.txtNATIVE_PLACE.Text.Trim().ToString() + "','" + this.txtFOLK.Text.Trim().ToString() + "'," + Convert.ToInt32(this.rblWEDDING.SelectedValue) + "," + "to_date('" + begin_date + "','yyyy-mm-dd hh24:mi:ss')," + ISONPOST + ",'" + this.txtMEMO.Text.Trim().ToString() + "'," + Convert.ToInt32(this.ddlIsGroup.SelectedValue) + "," + int.Parse(this.ddlTECHNICIAN_TYPE_ID.SelectedValue) + "," + int.Parse(this.ddlTECHNICAL_TITLE_ID.SelectedValue) + ",'" + this.txtWORK_NO.Text.Trim().ToString() + "','" + this.txtIDENTITY_CARDNO.Text.Trim().ToString() + "'," + int.Parse(this.ddlPOLITICAL_STATUS.SelectedValue) + "," + "to_date('" + join_rail_date + "','yyyy-mm-dd hh24:mi:ss')," + int.Parse(this.DDLeducation_level_id.SelectedValue) + "," + int.Parse(this.ddlEMPLOYEE_TYPE_ID.SelectedValue) + "," + (this.hfSECOND_POST_ID.Value == "" ? "NULL" : hfSECOND_POST_ID.Value) + "," + (this.hfTHIRD_POST_ID.Value == "" ? "NULL" : hfSECOND_POST_ID.Value) + "," + int.Parse(this.ddlWORKGROUPLEADER_TYPE_ID.SelectedValue) + "," + "to_date('" + workgroupleader_order_date + "','yyyy-mm-dd hh24:mi:ss')," + int.Parse(this.ddlEDUCATION_EMPLOYEE_TYPE_ID.SelectedValue) + "," + int.Parse(this.ddlCOMMITTEE_HEAD_SHIP_ID.SelectedValue) + "," + int.Parse(this.ddlISREGISTERED.SelectedValue) + "," + int.Parse(this.ddlEMPLOYEE_TRANSPORT_TYPE_ID.SelectedValue) + "," + "to_date('" + award_date + "','yyyy-mm-dd hh24:mi:ss'),'" + this.hfCOULD_POST_ID.Value.Trim().ToString() + "'," + "to_date('" + technicalDate + "','yyyy-mm-dd hh24:mi:ss')," + "to_date('" + technicalTitleDate + "','yyyy-mm-dd hh24:mi:ss')," + "to_date('" + postDate + "','yyyy-mm-dd hh24:mi:ss')," + "'" + this.txtFinishSchool.Text + "'," + "to_date('" + graduateDate + "','yyyy-mm-dd hh24:mi:ss')," + "'" + this.txtMajor.Text + "'," + "'" + this.dropSchoolCategory.SelectedValue + "'," + "'" + this.txtTechnicalCode.Text + "'," + (ddlSafe.SelectedValue == "" ? "NULL" : ddlSafe.SelectedValue) + "," + (hfNowPostID.Value == "" ? "null" : "'" + hfNowPostID.Value + "'") + ")"; } try { ora.ExecuteNonQuery(sqlStr); if (typeBool == 2) { sqlStr = "insert into Employee_Photo values(" + id + ",null)"; ora.ExecuteNonQuery(sqlStr); } SystemUserBLL objSystemBll = new SystemUserBLL(); if (type == "1") { RailExam.Model.SystemUser objSystem = objSystemBll.GetUserByEmployeeID(Convert.ToInt32(id)); if (objSystem != null) { objSystem.UserID = txtWORK_NO.Text.Trim() == string.Empty ? txtIDENTITY_CARDNO.Text.Trim() : txtWORK_NO.Text.Trim(); objSystemBll.UpdateUser(objSystem); } else { objSystem = new SystemUser(); objSystem.EmployeeID = Convert.ToInt32(id); objSystem.Memo = ""; objSystem.Password = "******"; objSystem.RoleID = 0; objSystem.UserID = txtWORK_NO.Text.Trim() == string.Empty ? txtIDENTITY_CARDNO.Text.Trim() : txtWORK_NO.Text.Trim(); objSystemBll.AddUser(objSystem); } } else { RailExam.Model.SystemUser objSystem = new SystemUser(); objSystem.EmployeeID = Convert.ToInt32(id); objSystem.Memo = ""; objSystem.Password = "******"; objSystem.RoleID = 0; objSystem.UserID = txtWORK_NO.Text.Trim() == string.Empty ? txtIDENTITY_CARDNO.Text.Trim() : txtWORK_NO.Text.Trim(); objSystemBll.AddUser(objSystem); } if (!string.IsNullOrEmpty(fileUpload1.PostedFile.FileName)) { string str = Server.MapPath("/RailExamBao/Excel/image"); if (!Directory.Exists(str)) { Directory.CreateDirectory(str); } string strFileName = Path.GetFileName(fileUpload1.PostedFile.FileName); string strPath = Server.MapPath("/RailExamBao/Excel/image/" + strFileName); if (File.Exists(strPath)) { File.Delete(strPath); } FileInfo fi = new FileInfo(fileUpload1.PostedFile.FileName); string extensions = ".jpg,.jpeg,.gif"; if (!extensions.Contains(fi.Extension.ToLower())) { this.ClientScript.RegisterStartupScript(this.GetType(), "OK", "alert('只能上传GIF, JPEG(JPG)格式的图片!');", true); return; } ((HttpPostedFile)fileUpload1.PostedFile).SaveAs(strPath); this.myImagePhoto.ImageUrl = strPath; AddImage(Int32.Parse(id), strPath); } SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("保存职工:" + txtEMPLOYEE_NAME.Text + "的档案信息!"); } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "OK", "alert('" + ex.Message + "');", true); return; } string OrgID = this.hfOrgID.Value; OrganizationBLL objBll = new OrganizationBLL(); string idpath = Request.QueryString.Get("idpath"); if (string.IsNullOrEmpty(Request.QueryString.Get("style"))) { string strQuery = Request.QueryString.Get("strQuery"); this.ClientScript.RegisterStartupScript(this.GetType(), "OK", "this.location.href='EmployeeInfo.aspx?ID=" + OrgID + "&idpath=" + idpath + "&type=Org&strQuery=" + strQuery + "';", true); } else { this.ClientScript.RegisterStartupScript(this.GetType(), "OK", "top.returnValue='true';top.close();", true); } } }
private void GetPaper() { // 根据 ProgressBar.htm 显示进度条界面 string templateFileName = Path.Combine(Server.MapPath("."), "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; ViewState["BeginTime"] = DateTime.Now.ToString(); string strId = Request.QueryString.Get("RandomExamID"); //获取当前考试的生成试卷的状态和次数 RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam obj = objBll.GetExam(Convert.ToInt32(strId)); int year = obj.BeginTime.Year; int ExamCount = obj.MaxExamTimes; RandomExamArrangeBLL eaBll = new RandomExamArrangeBLL(); IList <RailExam.Model.RandomExamArrange> ExamArranges = eaBll.GetRandomExamArranges(int.Parse(strId)); string strChooseID = ""; OracleAccess db = new OracleAccess(); OracleAccess dbCenter = new OracleAccess(System.Configuration.ConfigurationManager.ConnectionStrings["OracleCenter"].ConnectionString); string strSql; if (ExamArranges.Count > 0) { 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); foreach (DataRow dr in ds.Tables[0].Rows) { if (string.IsNullOrEmpty(strChooseID)) { strChooseID += dr["User_Ids"].ToString(); } else { strChooseID += "," + dr["User_Ids"]; } } } else { strChooseID = ""; } if (strChooseID == "") { Response.Write("<script>top.returnValue='本场考试未在本单位安排考生!';window.close();</script>"); return; } if (db.GetCount("RANDOM_EXAM_ITEM_TEMP_" + year, "TABLE") == 0) { strSql = "create table RANDOM_EXAM_ITEM_TEMP_" + year + " as select * from RANDOM_EXAM_ITEM_" + year + " where 1=2 "; db.ExecuteNonQuery(strSql); } strSql = "insert into RANDOM_EXAM_ITEM_TEMP_" + year + " select * from RANDOM_EXAM_ITEM_" + year + " where Random_Exam_ID=" + strId; db.ExecuteNonQuery(strSql); if (!PrjPub.IsServerCenter) { if (dbCenter.GetCount("RANDOM_EXAM_ITEM_TEMP_" + year, "TABLE") == 0) { strSql = "create table RANDOM_EXAM_ITEM_TEMP_" + year + " as select * from RANDOM_EXAM_ITEM_" + year + " where 1=2 "; dbCenter.ExecuteNonQuery(strSql); } strSql = "insert into RANDOM_EXAM_ITEM_TEMP_" + year + " select * from RANDOM_EXAM_ITEM_" + year + " where Random_Exam_ID=" + strId; dbCenter.ExecuteNonQuery(strSql); } System.Threading.Thread.Sleep(10); jsBlock = "<script>SetPorgressBar('正在计算生成试卷数量,请等待......','" + ((1 * 100) / ((double)2) + "'); </script>"); Response.Write(jsBlock); Response.Flush(); //每次生成试卷之前删除已生成的考试试卷 RandomExamResultCurrentBLL randomExamResultBLL = new RandomExamResultCurrentBLL(); randomExamResultBLL.DelRandomExamResultCurrent(Convert.ToInt32(strId)); System.Threading.Thread.Sleep(10); jsBlock = "<script>SetPorgressBar('正在计算生成试卷数量,请等待......','" + ((2 * 100) / ((double)2) + "'); </script>"); Response.Write(jsBlock); Response.Flush(); System.Threading.Thread.Sleep(200); jsBlock = string.Empty; string[] str = strChooseID.Split(','); RandomExamResultAnswerCurrentBLL randomExamResultAnswerBLL = new RandomExamResultAnswerCurrentBLL(); //定义全局答卷对象List IList <RandomExamResultAnswerCurrent> randomExamResultAnswersCurrentAll = new List <RandomExamResultAnswerCurrent>(); //定义一个考生一次答卷对象List IList <RandomExamResultAnswerCurrent> randomExamResultAnswers = null; int progressNum = 1; for (int n = 1; n <= ExamCount; n++) { for (int m = 0; m < str.Length; m++) { RandomExamResultCurrent randomExamResult = new RandomExamResultCurrent(); randomExamResult.RandomExamId = int.Parse(strId); randomExamResult.AutoScore = 0; randomExamResult.BeginDateTime = DateTime.Parse(ViewState["BeginTime"].ToString()); randomExamResult.CurrentDateTime = DateTime.Parse(ViewState["BeginTime"].ToString()); randomExamResult.ExamTime = 0; randomExamResult.EndDateTime = DateTime.Parse(ViewState["BeginTime"].ToString()); randomExamResult.Score = 0; randomExamResult.OrganizationId = int.Parse(ConfigurationManager.AppSettings["StationID"]); randomExamResult.Memo = ""; randomExamResult.StatusId = 0; randomExamResult.AutoScore = 0; randomExamResult.CorrectRate = 0; randomExamResult.ExamineeId = int.Parse(str[m]); randomExamResult.ExamSeqNo = n; int nRandomExamResultPK = randomExamResultBLL.AddRandomExamResultCurrent(randomExamResult); ViewState["RandomExamResultPK"] = nRandomExamResultPK; strSql = "select a.* from Random_Exam_Arrange_Detail a " + " where ','||User_Ids||',' like '%," + str[m] + ",%' " + " and Random_Exam_ID=" + strId; DataRow dr = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; //strSql = "insert into Random_Exam_Result_Detail(Random_Exam_Result_Detail_ID," // + "Random_Exam_Result_ID,Random_Exam_ID,Employee_ID,Computer_Room_SEAT,Computer_Room_ID) " // + "values(Random_Exam_Result_Detail_SEQ.NextVal," // + nRandomExamResultPK + "," // + randomExamResult.RandomExamId + "," // + randomExamResult.ExamineeId + "," // + "0," + dr["Computer_Room_ID"] + ") "; //db.ExecuteNonQuery(strSql); strSql = "insert into Random_Exam_Result_Detail_Temp(Random_Exam_Result_Detail_ID," + "Random_Exam_Result_ID,Random_Exam_ID,Employee_ID,Computer_Room_SEAT,Computer_Room_ID,Is_Remove) " + "values(Random_Exam_Result_Detail_SEQ.NextVal," + nRandomExamResultPK + "," + randomExamResult.RandomExamId + "," + randomExamResult.ExamineeId + "," + "0," + dr["Computer_Room_ID"] + ",0) "; db.ExecuteNonQuery(strSql); RandomExamItemBLL randomItemBLL = new RandomExamItemBLL(); RandomExamSubjectBLL subjectBLL = new RandomExamSubjectBLL(); RandomExamStrategyBLL strategyBLL = new RandomExamStrategyBLL(); IList <RandomExamSubject> randomExamSubjects = subjectBLL.GetRandomExamSubjectByRandomExamId(int.Parse(strId)); if (randomExamSubjects != null) { Hashtable hashTableItemIds = new Hashtable(); Hashtable htSubjectItemIds = new Hashtable(); for (int i = 0; i < randomExamSubjects.Count; i++) { RandomExamSubject paperSubject = randomExamSubjects[i]; int nSubjectId = paperSubject.RandomExamSubjectId; // int nItemCount = paperSubject.ItemCount; IList <RandomExamStrategy> strategys = strategyBLL.GetRandomExamStrategys(nSubjectId); for (int j = 0; j < strategys.Count; j++) { int nStrategyId = strategys[j].RandomExamStrategyId; int nItemCount = strategys[j].ItemCount; IList <RandomExamItem> itemList = randomItemBLL.GetItemsByStrategyId(nStrategyId, year); // IList<RandomExamItem> itemList = randomItemBLL.GetItemsBySubjectId(nSubjectId); Random ObjRandom = new Random(); Hashtable hashTable = new Hashtable(); Hashtable hashTableCount = new Hashtable(); int index = 0; while (hashTable.Count < nItemCount) { int k = ObjRandom.Next(itemList.Count); hashTableCount[index] = k; index = index + 1; int itemID = itemList[k].ItemId; int examItemID = itemList[k].RandomExamItemId; if (!hashTableItemIds.ContainsKey(itemID)) { hashTable[examItemID] = examItemID; hashTableItemIds[itemID] = itemID; htSubjectItemIds[examItemID] = examItemID; } //if (hashTableCount.Count == itemList.Count && hashTable.Count < nItemCount) //{ // SessionSet.PageMessage = "随机考试在设定的取题范围内的试题量不够,请重新设置取题范围!"; // return; //} } } } foreach (int key in htSubjectItemIds.Keys) { string strItemId = htSubjectItemIds[key].ToString(); RandomExamItem item = randomItemBLL.GetRandomExamItem(Convert.ToInt32(strItemId), year); string nowSelectAnswer = string.Empty; string nowStandardAnswer = string.Empty; if (item.TypeId != PrjPub.ITEMTYPE_FILLBLANK) { Pub.GetNowAnswer(item, out nowSelectAnswer, out nowStandardAnswer); } RandomExamResultAnswerCurrent randomExamResultAnswer = new RandomExamResultAnswerCurrent(); randomExamResultAnswer.RandomExamResultId = nRandomExamResultPK; randomExamResultAnswer.RandomExamItemId = int.Parse(strItemId); randomExamResultAnswer.JudgeStatusId = 0; randomExamResultAnswer.JudgeRemark = string.Empty; randomExamResultAnswer.ExamTime = 0; randomExamResultAnswer.Answer = string.Empty; randomExamResultAnswer.SelectAnswer = nowSelectAnswer; randomExamResultAnswer.StandardAnswer = nowStandardAnswer; randomExamResultAnswerBLL.AddExamResultAnswerCurrent(randomExamResultAnswer); //完型填空子题 IList <RandomExamItem> randomExamItems = randomItemBLL.GetItemsByParentItemID(item.ItemId, obj.RandomExamId, year); foreach (RandomExamItem randomExamItem in randomExamItems) { Pub.GetNowAnswer(randomExamItem, out nowSelectAnswer, out nowStandardAnswer); randomExamResultAnswer = new RandomExamResultAnswerCurrent(); randomExamResultAnswer.RandomExamResultId = nRandomExamResultPK; randomExamResultAnswer.RandomExamItemId = randomExamItem.RandomExamItemId; randomExamResultAnswer.JudgeStatusId = 0; randomExamResultAnswer.JudgeRemark = string.Empty; randomExamResultAnswer.ExamTime = 0; randomExamResultAnswer.Answer = string.Empty; randomExamResultAnswer.SelectAnswer = nowSelectAnswer; randomExamResultAnswer.StandardAnswer = nowStandardAnswer; randomExamResultAnswerBLL.AddExamResultAnswerCurrent(randomExamResultAnswer); } System.Threading.Thread.Sleep(10); jsBlock = "<script>SetPorgressBar('正在生成试卷,请等待......','" + ((progressNum * 100) / ((double)ExamCount * str.Length * htSubjectItemIds.Count)).ToString("0.00") + "'); </script>"; Response.Write(jsBlock); Response.Flush(); progressNum++; } } else { SessionSet.PageMessage = "未找到记录!"; } } } bool isRefresh = true; try { objBll.UpdateHasPaper(Convert.ToInt32(strId), PrjPub.ServerNo, true); } catch { strSql = @" update Random_Exam_Computer_Server set has_paper=1 where random_exam_id=" + strId + @" and Computer_server_no='" + PrjPub.ServerNo + @"'"; dbCenter.ExecuteNonQuery(strSql); strSql = @"select count(*) from Random_Exam_Computer_Server where has_paper=1 and random_exam_id=" + strId; int count = Convert.ToInt32(dbCenter.RunSqlDataSet(strSql).Tables[0].Rows[0][0]); if (count > 0) { strSql = @"update Random_Exam set has_paper=1 where random_exam_id=" + strId; dbCenter.ExecuteNonQuery(strSql); } else { strSql = @"update Random_Exam set has_paper=0 where random_exam_id=" + strId; dbCenter.ExecuteNonQuery(strSql); } } //如果考试是随到随考,考试状态自动变为正在进行 if (obj.StartMode == 1) { try { objBll.UpdateIsStart(Convert.ToInt32(strId), PrjPub.ServerNo, 1); isRefresh = false; } catch { strSql = @" update Random_Exam_Computer_Server set Is_Start=1 where random_exam_id=" + strId + @" and Computer_server_no='" + PrjPub.ServerNo + @"'"; dbCenter.ExecuteNonQuery(strSql); strSql = @"select count(*) from Random_Exam_Computer_Server where random_exam_id=" + strId; int totalcount = Convert.ToInt32(dbCenter.RunSqlDataSet(strSql).Tables[0].Rows[0][0]); strSql = @"select count(*) from Random_Exam_Computer_Server where Is_Start=0 and random_exam_id=" + strId; int count = Convert.ToInt32(dbCenter.RunSqlDataSet(strSql).Tables[0].Rows[0][0]); if (totalcount == count) { strSql = @"update Random_Exam set Is_Start=0 where random_exam_id=" + strId; dbCenter.ExecuteNonQuery(strSql); } else { strSql = @"select count(*) from Random_Exam_Computer_Server where Is_Start=1 and random_exam_id=" + strId; count = Convert.ToInt32(dbCenter.RunSqlDataSet(strSql).Tables[0].Rows[0][0]); if (count > 0) { strSql = @"update Random_Exam set Is_Start=1 where random_exam_id=" + strId; dbCenter.ExecuteNonQuery(strSql); } else { strSql = @"select count(*) from Random_Exam_Computer_Server where Is_Start=2 and random_exam_id=" + strId; count = Convert.ToInt32(dbCenter.RunSqlDataSet(strSql).Tables[0].Rows[0][0]); if (count == totalcount) { strSql = @"update Random_Exam set Is_Start=2 where random_exam_id=" + strId; dbCenter.ExecuteNonQuery(strSql); } } } } } else { isRefresh = false; } if (isRefresh) { objBll.RandomExamRefresh(); } SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("“" + obj.ExamName + "”生成所有考试试卷"); Response.Write("<script>top.returnValue='true';top.close();</script>"); }
private void GetPaperAfter() { // 根据 ProgressBar.htm 显示进度条界面 string templateFileName = Path.Combine(Server.MapPath("."), "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); ViewState["BeginTime"] = DateTime.Now.ToString(); string strId = Request.QueryString.Get("RandomExamID"); //获取当前考试的生成试卷的状态和次数 RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam obj = objBll.GetExam(Convert.ToInt32(strId)); int year = obj.BeginTime.Year; int ExamCount = obj.MaxExamTimes; System.Threading.Thread.Sleep(10); string jsBlock = "<script>SetPorgressBar('正在计算生成试卷数量,请等待......','" + ((1 * 100) / ((double)1) + "'); </script>"); Response.Write(jsBlock); Response.Flush(); if (!PrjPub.IsServerCenter) { RandomExamArrangeBLL objArrangeBll = new RandomExamArrangeBLL(); objArrangeBll.RefreshRandomExamArrange(); } //RandomExamArrangeBLL eaBll = new RandomExamArrangeBLL(); //IList<RailExam.Model.RandomExamArrange> ExamArranges = eaBll.GetRandomExamArranges(int.Parse(strId)); //string strChooseID = ""; //if (ExamArranges.Count > 0) //{ // strChooseID = ExamArranges[0].UserIds; //} //else //{ // strChooseID = ""; //} //RandomExamResultCurrentBLL objResultCurrentBll = new RandomExamResultCurrentBLL(); //IList<RandomExamResultCurrent> examResults = objResultCurrentBll.GetRandomExamResultInfo(Convert.ToInt32(strId)); //for (int i = 0; i < examResults.Count; i++) //{ // strChooseID = ("," + strChooseID + ",").Replace("," + examResults[i].ExamineeId + ",", ","); //} //strChooseID = strChooseID.TrimStart(',').TrimEnd(','); string strChooseID = Request.QueryString.Get("addIds"); if (strChooseID == string.Empty) { return; } string[] str = strChooseID.Split('|'); System.Threading.Thread.Sleep(10); jsBlock = "<script>SetPorgressBar('正在计算生成试卷数量,请等待......','" + ((2 * 100) / ((double)2) + "'); </script>"); Response.Write(jsBlock); Response.Flush(); OracleAccess db = new OracleAccess(); string strSql; RandomExamResultAnswerCurrentBLL randomExamResultAnswerBLL = new RandomExamResultAnswerCurrentBLL(); //定义全局答卷对象List IList <RandomExamResultAnswerCurrent> randomExamResultAnswersCurrentAll = new List <RandomExamResultAnswerCurrent>(); //定义一个考生一次答卷对象List IList <RandomExamResultAnswerCurrent> randomExamResultAnswers = null; System.Threading.Thread.Sleep(200); jsBlock = string.Empty; int progressNum = 1; for (int n = 1; n <= ExamCount; n++) { for (int m = 0; m < str.Length; m++) { RandomExamResultCurrentBLL randomExamResultBLL = new RandomExamResultCurrentBLL(); RandomExamResultCurrent randomExamResult = new RandomExamResultCurrent(); randomExamResult.RandomExamId = int.Parse(strId); randomExamResult.AutoScore = 0; randomExamResult.BeginDateTime = DateTime.Parse(ViewState["BeginTime"].ToString()); randomExamResult.CurrentDateTime = DateTime.Parse(ViewState["BeginTime"].ToString()); randomExamResult.ExamTime = 0; randomExamResult.EndDateTime = DateTime.Parse(ViewState["BeginTime"].ToString()); randomExamResult.Score = 0; randomExamResult.OrganizationId = int.Parse(ConfigurationManager.AppSettings["StationID"]); randomExamResult.Memo = ""; randomExamResult.StatusId = 0; randomExamResult.AutoScore = 0; randomExamResult.CorrectRate = 0; randomExamResult.ExamineeId = int.Parse(str[m]); randomExamResult.ExamSeqNo = n; int nRandomExamResultPK = randomExamResultBLL.AddRandomExamResultCurrent(randomExamResult); ViewState["RandomExamResultPK"] = nRandomExamResultPK; strSql = "select a.* from Random_Exam_Arrange_Detail a " + " where ','||User_Ids||',' like '%," + str[m] + ",%' " + " and Random_Exam_ID=" + strId; DataRow dr = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; //strSql = "insert into Random_Exam_Result_Detail(Random_Exam_Result_Detail_ID," // + "Random_Exam_Result_ID,Random_Exam_ID,Employee_ID,Computer_Room_SEAT,Computer_Room_ID) " // + "values(Random_Exam_Result_Detail_SEQ.NextVal," // + nRandomExamResultPK + "," // + randomExamResult.RandomExamId + "," // + randomExamResult.ExamineeId + "," // + "0," + dr["Computer_Room_ID"] + ") "; //db.ExecuteNonQuery(strSql); strSql = "insert into Random_Exam_Result_Detail_Temp(Random_Exam_Result_Detail_ID," + "Random_Exam_Result_ID,Random_Exam_ID,Employee_ID,Computer_Room_SEAT,Computer_Room_ID,Is_Remove) " + "values(Random_Exam_Result_Detail_SEQ.NextVal," + nRandomExamResultPK + "," + randomExamResult.RandomExamId + "," + randomExamResult.ExamineeId + "," + "0," + dr["Computer_Room_ID"] + ",0) "; db.ExecuteNonQuery(strSql); RandomExamItemBLL randomItemBLL = new RandomExamItemBLL(); RandomExamSubjectBLL subjectBLL = new RandomExamSubjectBLL(); RandomExamStrategyBLL strategyBLL = new RandomExamStrategyBLL(); IList <RandomExamSubject> randomExamSubjects = subjectBLL.GetRandomExamSubjectByRandomExamId(int.Parse(strId)); if (randomExamSubjects != null) { Hashtable hashTableItemIds = new Hashtable(); Hashtable htSubjectItemIds = new Hashtable(); for (int i = 0; i < randomExamSubjects.Count; i++) { RandomExamSubject paperSubject = randomExamSubjects[i]; int nSubjectId = paperSubject.RandomExamSubjectId; // int nItemCount = paperSubject.ItemCount; IList <RandomExamStrategy> strategys = strategyBLL.GetRandomExamStrategys(nSubjectId); for (int j = 0; j < strategys.Count; j++) { int nStrategyId = strategys[j].RandomExamStrategyId; int nItemCount = strategys[j].ItemCount; IList <RandomExamItem> itemList = randomItemBLL.GetItemsByStrategyId(nStrategyId, year); // IList<RandomExamItem> itemList = randomItemBLL.GetItemsBySubjectId(nSubjectId); Random ObjRandom = new Random(); Hashtable hashTable = new Hashtable(); Hashtable hashTableCount = new Hashtable(); int index = 0; while (hashTable.Count < nItemCount) { int k = ObjRandom.Next(itemList.Count); hashTableCount[index] = k; index = index + 1; int itemID = itemList[k].ItemId; int examItemID = itemList[k].RandomExamItemId; if (!hashTableItemIds.ContainsKey(itemID)) { hashTable[examItemID] = examItemID; hashTableItemIds[itemID] = itemID; htSubjectItemIds[examItemID] = examItemID; } //if (hashTableCount.Count == itemList.Count && hashTable.Count < nItemCount) //{ // SessionSet.PageMessage = "随机考试在设定的取题范围内的试题量不够,请重新设置取题范围!"; // return; //} } } } randomExamResultAnswers = new List <RandomExamResultAnswerCurrent>(); foreach (int key in htSubjectItemIds.Keys) { string strItemId = htSubjectItemIds[key].ToString(); RandomExamItem item = randomItemBLL.GetRandomExamItem(Convert.ToInt32(strItemId), year); string nowSelectAnswer = string.Empty; string nowStandardAnswer = string.Empty; if (item.TypeId != PrjPub.ITEMTYPE_FILLBLANK) { Pub.GetNowAnswer(item, out nowSelectAnswer, out nowStandardAnswer); } RandomExamResultAnswerCurrent randomExamResultAnswer = new RandomExamResultAnswerCurrent(); randomExamResultAnswer.RandomExamResultId = nRandomExamResultPK; randomExamResultAnswer.RandomExamItemId = int.Parse(strItemId); randomExamResultAnswer.JudgeStatusId = 0; randomExamResultAnswer.JudgeRemark = string.Empty; randomExamResultAnswer.ExamTime = 0; randomExamResultAnswer.Answer = string.Empty; randomExamResultAnswer.SelectAnswer = nowSelectAnswer; randomExamResultAnswer.StandardAnswer = nowStandardAnswer; randomExamResultAnswerBLL.AddExamResultAnswerCurrent(randomExamResultAnswer); //完型填空子题 IList <RandomExamItem> randomExamItems = randomItemBLL.GetItemsByParentItemID(item.ItemId, obj.RandomExamId, year); foreach (RandomExamItem randomExamItem in randomExamItems) { Pub.GetNowAnswer(randomExamItem, out nowSelectAnswer, out nowStandardAnswer); randomExamResultAnswer = new RandomExamResultAnswerCurrent(); randomExamResultAnswer.RandomExamResultId = nRandomExamResultPK; randomExamResultAnswer.RandomExamItemId = randomExamItem.RandomExamItemId; randomExamResultAnswer.JudgeStatusId = 0; randomExamResultAnswer.JudgeRemark = string.Empty; randomExamResultAnswer.ExamTime = 0; randomExamResultAnswer.Answer = string.Empty; randomExamResultAnswer.SelectAnswer = nowSelectAnswer; randomExamResultAnswer.StandardAnswer = nowStandardAnswer; randomExamResultAnswerBLL.AddExamResultAnswerCurrent(randomExamResultAnswer); } System.Threading.Thread.Sleep(10); jsBlock = "<script>SetPorgressBar('正在生成试卷,请等待......','" + ((progressNum * 100) / ((double)ExamCount * str.Length * htSubjectItemIds.Count)).ToString("0.00") + "'); </script>"; Response.Write(jsBlock); Response.Flush(); progressNum++; } } else { SessionSet.PageMessage = "未找到记录!"; } } } //临时添加考生无需更改考试状态,因为考试状态肯定是正在进行和生成试卷 //objBll.UpdateHasPaper(Convert.ToInt32(strId), PrjPub.ServerNo, true); ////如果考试是随到随考,考试状态自动变为正在进行 //if (obj.StartMode == 1) //{ // objBll.UpdateIsStart(Convert.ToInt32(strId), PrjPub.ServerNo, 1); //} SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("“" + obj.ExamName + "”生成新增考生试卷"); Response.Write("<script>top.returnValue='true';top.close();</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (PrjPub.CurrentLoginUser == null) { Response.Redirect("../Common/Error.aspx?error=Session过期请重新登录本系统!"); return; } if (!IsPostBack) { hfLoginID.Value = PrjPub.CurrentLoginUser.EmployeeID.ToString(); if (PrjPub.HasEditRight("职员管理") && PrjPub.IsServerCenter) { HfUpdateRight.Value = "True"; } else { HfUpdateRight.Value = "False"; } if (PrjPub.HasDeleteRight("职员管理") && PrjPub.IsServerCenter) { HfDeleteRight.Value = "True"; } else { HfDeleteRight.Value = "False"; } string strQuery = Request.QueryString.Get("strQuery"); if (!string.IsNullOrEmpty(strQuery)) { string[] str = strQuery.Split('|'); txtName.Text = str[0]; ddlSex.SelectedValue = str[1]; ddlStatus.SelectedValue = str[2]; txtPinYin.Text = str[3]; txtTechnicalCode.Text = str[4]; hfPostID.Value = str[5]; } gridBind(); } string strRefresh = Request.Form.Get("Refresh"); if (!string.IsNullOrEmpty(strRefresh)) { gridBind(); } string strUpdate = Request.Form.Get("UpdatePsw"); if (!string.IsNullOrEmpty(strUpdate)) { SystemUserBLL objBll = new SystemUserBLL(); SystemUser obj = objBll.GetUserByEmployeeID(Convert.ToInt32(strUpdate)); if (obj != null) { obj.Password = "******"; if (PrjPub.IsServerCenter) { objBll.UpdateUser(obj); } else { objBll.UpdateUserPsw(obj.UserID, "111111"); } SessionSet.PageMessage = "初始化密码成功!"; } else { SessionSet.PageMessage = "该员工登录帐户不存在,初始化密码失败!"; } gridBind(); } string strDelete = Request.Form.Get("Delete"); if (!string.IsNullOrEmpty(strDelete)) { try { OracleAccess db = new OracleAccess(); if (PrjPub.CurrentLoginUser.EmployeeID != 0) { //判断该员工是否参加过考试 string strIsArrange = string.Format( "select count(1) from random_exam_arrange where ','||user_ids||',' like '%,{0},%'", strDelete); if (Convert.ToInt32(db.RunSqlDataSet(strIsArrange).Tables[0].Rows[0][0]) > 0) { ClientScript.RegisterStartupScript(GetType(), "NO", "alert('该员工已参加考试,不能删除!');", true); return; } string strSql = "delete from Employee where Employee_ID=" + strDelete; db.ExecuteNonQuery(strSql); } else { string strSql = "select * from Employee where Employee_ID=" + strDelete; DataRow dr = db.RunSqlDataSet(strSql).Tables[0].Rows[0]; EmployeeBLL employeebll = new EmployeeBLL(); employeebll.DeleteEmployee(Convert.ToInt32(strDelete)); SystemLogBLL systemLogBLL = new SystemLogBLL(); systemLogBLL.WriteLog("删除员工:" + dr["Employee_Name"] + "(" + dr["Work_No"] + ")基本信息"); } gridBind(); } catch { SessionSet.PageMessage = "该员工已被引用,不能删除!"; } } if (!string.IsNullOrEmpty(hfPostID.Value)) { PostBLL post = new PostBLL(); txtPost.Text = post.GetPost(Convert.ToInt32(hfPostID.Value)).PostName; } }
protected void btnOK_Click(object sender, EventArgs e) { string strId = Request.QueryString.Get("RandomExamID"); RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam obj = objBll.GetExam(Convert.ToInt32(strId)); #region 验证试卷完整性 /*OracleAccess db = new OracleAccess(); * * //查询本场考试现有生成试卷的总题数(完型填空子题除外) * int beginYear = obj.BeginTime.Year; * string strSql = * @"select * from Random_Exam_Result_Answer_Cur a * inner join Random_Exam_Item_"+beginYear+@" b on a.Random_Exam_Item_ID=b.Random_Exam_Item_ID * where b.Type_ID<>5 and Random_Exam_Result_ID in ( * select Random_Exam_Result_ID from Random_Exam_Result_Current * where Random_Exam_ID=" + strId + ")"; * DataSet dsAnswer = db.RunSqlDataSet(strSql); * * //查询本场考试题目个数 * strSql = "select Sum(Item_Count) from Random_Exam_Subject where Random_Exam_ID=" + strId; * DataSet dsSubject = db.RunSqlDataSet(strSql); * int itemCount = Convert.ToInt32(dsSubject.Tables[0].Rows[0][0]); * * //查询本服务器所有考生信息 * 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); + string strChooseID = string.Empty; + foreach (DataRow dr in ds.Tables[0].Rows) + { + if (string.IsNullOrEmpty(strChooseID)) + { + strChooseID += dr["User_Ids"].ToString(); + } + else + { + strChooseID += "," + dr["User_Ids"]; + } + } + int employeeCount = strChooseID.Split(',').Length; + + if (dsAnswer.Tables[0].Rows.Count != itemCount*employeeCount) + { + Response.Write("<script>alert('本场考试试卷生成有误,请联系监考老师删除考试试卷后重新下载后生成!'); top.close();</script>"); + return; + }*/ #endregion objBll.UpdateStartCode(Convert.ToInt32(strId), PrjPub.ServerNo, txtCode.Text); objBll.UpdateIsStart(Convert.ToInt32(strId), PrjPub.ServerNo, 1); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("“" + obj.ExamName + "”开始考试"); Response.Write("<script>top.returnValue='true';top.close();</script>"); }
protected void btnOk_Click(object sender, EventArgs e) { string[] strID = hfEmployeeID.Value.Split(','); EmployeeTransferBLL objBll = new EmployeeTransferBLL(); IList <EmployeeTransfer> objList = new List <EmployeeTransfer>(); OracleAccess db = new OracleAccess(); string strSql; if (PrjPub.CurrentLoginUser.SuitRange == 1) { strSql = @"select getstationorgid(org_id) stationorgid,count(*) AdminCount, GetOrgName(getstationorgid(org_id)) stationName from system_user s left join employee e on s.employee_id=e.employee_id where role_id=123 group by getstationorgid(org_id)"; } else { strSql = @"select getstationorgid(org_id) stationorgid,count(*) AdminCount, GetOrgName(getstationorgid(org_id)) stationName from system_user s left join employee e on s.employee_id=e.employee_id where role_id=123 and getstationorgid(org_id)=" + PrjPub.CurrentLoginUser.StationOrgID + @" group by getstationorgid(org_id)"; } DataTable dtCount = db.RunSqlDataSet(strSql).Tables[0]; strSql = @"select GetStationOrgID(org_id) stationorgid,s.* from Employee a inner join system_user s on s.employee_id=a.employee_id where a.Employee_ID in (" + hfEmployeeID.Value + ")"; DataTable dtEmployee = db.RunSqlDataSet(strSql).Tables[0]; strSql = @"select a.*,b.Employee_Name from EMPLOYEE_TRANSFER a inner join Employee b on a.Employee_ID=b.Employee_ID where getstationorgid(org_id)=" + PrjPub.CurrentLoginUser.StationOrgID; DataTable dtHasTrans = db.RunSqlDataSet(strSql).Tables[0]; Hashtable htCount = new Hashtable(); int count = 0; string error = string.Empty; for (int i = 0; i < strID.Length; i++) { EmployeeTransfer objTransfer = new EmployeeTransfer(); objTransfer.EmployeeID = Convert.ToInt32(strID[i]); objTransfer.TransferToOrgID = Convert.ToInt32(ddlOrg.SelectedValue); objList.Add(objTransfer); if (strID[i] == PrjPub.CurrentLoginUser.EmployeeID.ToString()) { count++; } DataRow[] drAdmin = dtEmployee.Select("Employee_ID=" + strID[i] + " and Role_ID=123"); if (drAdmin.Length > 0) { string stationid = drAdmin[0]["StationOrgID"].ToString(); if (htCount.ContainsKey(stationid)) { int num = Convert.ToInt32(htCount[stationid]); htCount[stationid] = num + 1; } else { htCount.Add(stationid, 1); } } DataRow[] drHasTrans = dtHasTrans.Select("Employee_ID=" + strID[i]); if (drHasTrans.Length > 0) { error = "学员【" + drHasTrans[0]["Employee_Name"] + "】已经处于调出状态,不能重复调出!"; break; } } if (error != "") { ClientScript.RegisterClientScriptBlock(GetType(), "", "alert('" + error + "')", true); return; } string strMessage = ""; foreach (DataRow dr in dtCount.Rows) { string stationid = dr["stationorgid"].ToString(); if (htCount.ContainsKey(stationid)) { int nownum = Convert.ToInt32(htCount[stationid]); if (nownum == Convert.ToInt32(dr["AdminCount"].ToString())) { strMessage = "必须为" + dr["stationName"] + "至少保留一位站段管理员!"; break; } } } if (count > 0) { ClientScript.RegisterClientScriptBlock(GetType(), "", "alert('" + PrjPub.CurrentLoginUser.EmployeeName + "是当前操作人员,不能被调出!')", true); return; } if (strMessage != "") { ClientScript.RegisterClientScriptBlock(GetType(), "", "alert('" + strMessage + "')", true); return; } objBll.AddEmployeeTransfer(objList); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("将部分员工调至" + ddlOrg.SelectedItem.Text); Response.Write("<script>window.returnValue='true';window.close();</script>"); }
/// <summary> /// 删除 /// </summary> /// <param name="strLogID"></param> protected void DeleteData(string strLogID) { EmployeeDetailBLL employeeDetailBLL = new EmployeeDetailBLL(); if (OrgList.SelectedIndex == 0) { if (employeeDetailBLL.GetEmployeeByWhere("Education_Level_ID=" + strLogID) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } EducationLevelBLL objBll = new EducationLevelBLL(); string educationName = objBll.GetEducationLevelByEducationLevelID(Convert.ToInt32(strLogID)).EducationLevelName; objBll.DeleteEducationLevel(Convert.ToInt32(strLogID), ""); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[0].Text + ":" + educationName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 1) { if (employeeDetailBLL.GetEmployeeByWhere("POLITICAL_STATUS_ID=" + strLogID) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } PoliticalStatusBLL objBll = new PoliticalStatusBLL(); string politicalName = objBll.GetPoliticalStatusByPoliticalStatusID(Convert.ToInt32(strLogID)).PoliticalStatusName; objBll.DeletePoliticalStatus(Convert.ToInt32(strLogID)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[1].Text + ":" + politicalName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 2) { if (employeeDetailBLL.GetEmployeeByWhere("workgroupleader_type_id=" + strLogID) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } WorkGroupLeaderLevelBLL objBll = new WorkGroupLeaderLevelBLL(); string wrokgroupName = objBll.GetWorkGroupLeaderLevelByWorkGroupLeaderLevelID(Convert.ToInt32(strLogID)).LevelName; objBll.DeleteWorkGroupLeaderLevel(Convert.ToInt32(strLogID)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[2].Text + ":" + wrokgroupName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 3) { if (employeeDetailBLL.GetEmployeeByWhere("TECHNICIAN_TYPE_ID=" + strLogID) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } TechnicianTypeBLL objBll = new TechnicianTypeBLL(); string technicianName = objBll.GetTechnicianTypeByTechnicianTypeID(Convert.ToInt32(strLogID)).TypeName; objBll.DeleteTechnicianType(Convert.ToInt32(strLogID), ""); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[3].Text + ":" + technicianName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 4) { if (employeeDetailBLL.GetEmployeeByWhere("TECHNICAL_TITLE_ID=" + strLogID) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } TechnicianTitleTypeBLL objBll = new TechnicianTitleTypeBLL(); string technicianTitleName = objBll.GetTechnicianTitleTypeByTechnicianTitleTypeID(Convert.ToInt32(strLogID)).TypeName; objBll.DeleteTechnicianTitleType(Convert.ToInt32(strLogID)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[4].Text + ":" + technicianTitleName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 5) { if (employeeDetailBLL.GetEmployeeByWhere("education_employee_type_id=" + strLogID) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } EducationEmployeeTypeBLL objBll = new EducationEmployeeTypeBLL(); string technicianTitleName = objBll.GetEducationEmployeeTypeByEducationEmployeeTypeID(Convert.ToInt32(strLogID)).TypeName; objBll.DeleteEducationEmployeeType(Convert.ToInt32(strLogID)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[5].Text + ":" + technicianTitleName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 6) { if (employeeDetailBLL.GetEmployeeByWhere("committee_head_ship_id=" + strLogID) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } CommitteeHeadShipBLL objBll = new CommitteeHeadShipBLL(); string ShipName = objBll.GetCommitteeHeadShipByCommitteeHeadShipID(Convert.ToInt32(strLogID)).CommitteeHeadShipName; objBll.DeleteCommitteeHeadShip(Convert.ToInt32(strLogID)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[6].Text + ":" + ShipName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 7) { RandomExamModularTypeBLL objBll = new RandomExamModularTypeBLL(); if (objBll.GetRandomExam(Convert.ToInt32(strLogID)) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } string TypeName = objBll.GetRandomExamModularTypeByTypeID(Convert.ToInt32(strLogID)).RandomExamModularTypeName; objBll.DeleteCommitteeHeadShip(Convert.ToInt32(strLogID)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[7].Text + ":" + TypeName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 8) { OracleAccess oracle = new OracleAccess(); DataTable dt = oracle.RunSqlDataSet( string.Format(" select * from zj_train_plan where train_plan_type_id={0}", Convert.ToInt32(strLogID))).Tables[0]; if (dt.Rows.Count > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } string TypeName = oracle.RunSqlDataSet( string.Format("select trainplan_type_name from zj_trainplan_type where trainplan_type_id={0}", Convert.ToInt32(strLogID))).Tables[0].Rows[0]["trainplan_type_name"].ToString(); oracle.ExecuteNonQuery(string.Format("delete from zj_trainplan_type where trainplan_type_id={0}", Convert.ToInt32(strLogID))); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[8].Text + ":" + TypeName); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 9) { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet("select count(1) from employee where safe_level_id=" + strLogID).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } string sql = "select safe_level_name from zj_safe_level where safe_level_id=" + strLogID; DataTable dt1 = access.RunSqlDataSet(sql).Tables[0]; try { access.ExecuteNonQuery(@" update zj_safe_level set order_index=order_index-1 where order_index> (select order_index from zj_safe_level where safe_level_id=" + strLogID + ")"); access.ExecuteNonQuery("delete from zj_safe_level where safe_level_id=" + strLogID); } catch { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[9].Text + ":" + dt1.Rows[0][0]); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 10) { OracleAccess access = new OracleAccess(); string sql = "select certificate_name from zj_certificate where certificate_id=" + strLogID; DataTable dt1 = access.RunSqlDataSet(sql).Tables[0]; try { access.ExecuteNonQuery( @" update zj_certificate set order_index=order_index-1 where order_index> (select order_index from zj_certificate where certificate_id=" + strLogID + ")"); access.ExecuteNonQuery("delete from zj_certificate where certificate_id=" + strLogID); } catch { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[10].Text + ":" + dt1.Rows[0][0]); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 11) { OracleAccess access = new OracleAccess(); string sql = "select certificate_level_name from zj_certificate_level where certificate_level_id=" + strLogID; DataTable dt1 = access.RunSqlDataSet(sql).Tables[0]; try { access.ExecuteNonQuery( @" update zj_certificate_level set order_index=order_index-1 where order_index> (select order_index from zj_certificate_level where certificate_level_id=" + strLogID + ")"); access.ExecuteNonQuery("delete from zj_certificate_level where certificate_level_id=" + strLogID); } catch { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[11].Text + ":" + dt1.Rows[0][0]); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 12) { OracleAccess access = new OracleAccess(); string sql = "select certificate_unit_name from zj_certificate_unit where certificate_unit_id=" + strLogID; DataTable dt1 = access.RunSqlDataSet(sql).Tables[0]; try { access.ExecuteNonQuery( @" update zj_certificate_unit set order_index=order_index-1 where order_index> (select order_index from zj_certificate_unit where certificate_unit_id=" + strLogID + ")"); access.ExecuteNonQuery("delete from zj_certificate_unit where certificate_unit_id=" + strLogID); } catch { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[12].Text + ":" + dt1.Rows[0][0]); BindGrid(OrgList.SelectedIndex); } if (OrgList.SelectedIndex == 13) { OracleAccess access = new OracleAccess(); string sql = "select train_unit_name from zj_train_unit where train_unit_id=" + strLogID; DataTable dt1 = access.RunSqlDataSet(sql).Tables[0]; try { access.ExecuteNonQuery( @" update zj_train_unit set order_index=order_index-1 where order_index> (select order_index from zj_train_unit where train_unit_id=" + strLogID + ")"); access.ExecuteNonQuery("delete from zj_train_unit where train_unit_id=" + strLogID); } catch { hfMessage.Value = "该数据字典已被引用,不能删除!"; BindGrid(OrgList.SelectedIndex); return; } SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("删除" + OrgList.Items[13].Text + ":" + dt1.Rows[0][0]); BindGrid(OrgList.SelectedIndex); } }
protected void Page_Load(object sender, EventArgs e) { hfChapterID.Value = Request.QueryString["id"]; hfIsWuhan.Value = PrjPub.IsWuhan().ToString(); if (fvBookChapter.CurrentMode == FormViewMode.Insert) { if (hfInsert.Value == "-1") { ((HiddenField)fvBookChapter.FindControl("hfParentID")).Value = Request.QueryString["ParentID"]; ((HiddenField)fvBookChapter.FindControl("hfBookID")).Value = Request.QueryString["BookID"]; } else { ((HiddenField)fvBookChapter.FindControl("hfParentId")).Value = hfInsert.Value; ((HiddenField)fvBookChapter.FindControl("hfBookID")).Value = Request.QueryString["BookID"]; } if (Request.QueryString["Mode"] == "Edit") { ((HiddenField)fvBookChapter.FindControl("hfIsEdit")).Value = "true"; } else { ((HiddenField)fvBookChapter.FindControl("hfIsEdit")).Value = "false"; } } else if (fvBookChapter.CurrentMode == FormViewMode.Edit) { if (Request.QueryString["Mode"] == "Edit") { ((HiddenField)fvBookChapter.FindControl("hfIsEdit")).Value = "true"; } else { ((HiddenField)fvBookChapter.FindControl("hfIsEdit")).Value = "false"; } } string strRefresh = Request.Form.Get("Refresh"); if (strRefresh != null & strRefresh != "") { string strPath = "../Online/Book/" + Request.QueryString["BookID"].ToString() + "/" + Request.QueryString["id"].ToString() + ".htm"; BookChapterBLL objBill = new BookChapterBLL(); objBill.UpdateBookChapterUrl(Convert.ToInt32(Request.QueryString["id"].ToString()), strPath); RailExam.Model.BookChapter objBookChapter = objBill.GetBookChapter(Convert.ToInt32(Request.QueryString["id"].ToString())); string strChapterName = objBookChapter.ChapterName; string str = File.ReadAllText(Server.MapPath(strPath), Encoding.UTF8); if (str.IndexOf("chaptertitle") < 0) { if (objBookChapter.LevelNum < 3) { str = "<link href='book.css' type='text/css' rel='stylesheet' />" + "<body oncontextmenu='return false' ondragstart='return false' onselectstart ='return false' oncopy='document.selection.empty()' onbeforecopy='return false'>" + "<div id='chaptertitle" + objBookChapter.LevelNum + "'>" + strChapterName + "</div>" + "<br>" + str + "</body>"; } else { str = "<link href='book.css' type='text/css' rel='stylesheet' />" + "<body oncontextmenu='return false' ondragstart='return false' onselectstart ='return false' oncopy='document.selection.empty()' onbeforecopy='return false'>" + "<div id='chaptertitle3'>" + strChapterName + "</div>" + "<br>" + str + "</body>"; } File.WriteAllText(Server.MapPath(strPath), str, Encoding.UTF8); } BookBLL objBookBill = new BookBLL(); if (Request.QueryString.Get("Mode") == "Edit") { objBookBill.UpdateBookVersion(Convert.ToInt32(Request.QueryString["BookID"].ToString())); } string strBookName = objBookBill.GetBook(Convert.ToInt32(Request.QueryString["BookID"].ToString())).bookName; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("编辑教材《" + strBookName + "》中“" + strChapterName + "”的章节内容"); fvBookChapter.DataBind(); Grid1.DataBind(); objBill.GetIndex(Request.QueryString["BookID"].ToString()); ItemBLL objBll = new ItemBLL(); IList <RailExam.Model.Item> objList = objBll.GetItemsByBookChapterId(Convert.ToInt32(Request.QueryString["BookID"]), Convert.ToInt32(Request.QueryString["id"]), 0, 0); if (objList.Count > 0) { ClientScript.RegisterStartupScript(GetType(), "jsSelectFirstNode", @"var ret = window.showModalDialog('/RailExamBao/Book/ItemEnabled.aspx?BookID=" + Request.QueryString["BookID"] + @"&ChapterID=" + Request.QueryString["id"] + @"','','help:no; status:no;dialogWidth:300px;dialogHeight:120px;');", true); } } string strRefreshGrid = Request.Form.Get("RefreshGrid"); if (strRefreshGrid != null & strRefreshGrid != "") { fvBookChapter.DataBind(); Grid1.DataBind(); } string strDeleteBookChapterUpdateID = Request.Form.Get("DeleteBookChapterUpdateID"); if (!string.IsNullOrEmpty(strDeleteBookChapterUpdateID)) { DeleteData(int.Parse(strDeleteBookChapterUpdateID)); Grid1.DataBind(); } }
/// <summary> /// 保存数据项 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void InsertButton_Click(object sender, EventArgs e) { string value = Request.QueryString["TypeValue"]; string id = Request.QueryString["ID"]; string mode = Request.QueryString["Mode"]; if (value == "education_level" && mode == "Update") { EducationLevelBLL objBLL = new EducationLevelBLL(); EducationLevel obj = objBLL.GetEducationLevelByEducationLevelID(Convert.ToInt32(id)); obj.EducationLevelID = Convert.ToInt32(id); string educationName = obj.EducationLevelName; if (objBLL.GetEducationLevelByWhereClause("Education_Level_ID !=" + id + " and Education_Level_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该文化程度,请重新输入!"; txtItemName.Focus(); return; } obj.EducationLevelName = txtItemName.Text; obj.Memo = txtMemo.Text; objBLL.UpdateEducationLevel(obj); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改文化程度:(" + educationName + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "political_status" && mode == "Update") { PoliticalStatusBLL objBLL = new PoliticalStatusBLL(); PoliticalStatus obj = objBLL.GetPoliticalStatusByPoliticalStatusID(Convert.ToInt32(id)); obj.PoliticalStatusID = Convert.ToInt32(id); string politicalStatusName = obj.PoliticalStatusName; if (objBLL.GetPoliticalStatusByWhereClause("Political_Status_ID !=" + id + " and Political_Status_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该政治面貌,请重新输入!"; txtItemName.Focus(); return; } obj.PoliticalStatusName = txtItemName.Text; obj.Memo = txtMemo.Text; objBLL.UpdatePoliticalStatus(obj); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改政治面貌:(" + politicalStatusName + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "workgroupleader_level" && mode == "Update") { WorkGroupLeaderLevelBLL objBLL = new WorkGroupLeaderLevelBLL(); WorkGroupLeaderLevel obj = objBLL.GetWorkGroupLeaderLevelByWorkGroupLeaderLevelID(Convert.ToInt32(id)); obj.WorkGroupLeaderLevelID = Convert.ToInt32(id); string levelName = obj.LevelName; if (objBLL.GetWorkGroupLeaderLevelByWhereClause("WorkGroupLeader_Level_ID !=" + id + " and Level_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该班组长类别,请重新输入!"; txtItemName.Focus(); return; } obj.LevelName = txtItemName.Text; obj.Memo = txtMemo.Text; objBLL.UpdateWorkGroupLeaderLevel(obj); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改班组长类别:(" + levelName + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "technician_type" && mode == "Update") { TechnicianTypeBLL objBLL = new TechnicianTypeBLL(); TechnicianType obj = objBLL.GetTechnicianTypeByTechnicianTypeID(Convert.ToInt32(id)); obj.TechnicianTypeID = Convert.ToInt32(id); string typeName = obj.TypeName; if (objBLL.GetTechnicianTypeByWhereClause("Technician_Type_ID !=" + id + " and Type_Name='" + txtItemName.Text + "'", "").Count > 0) { SessionSet.PageMessage = "系统中已存在该工人技能等级,请重新输入!"; txtItemName.Focus(); return; } obj.TypeName = txtItemName.Text; obj.Memo = txtMemo.Text; objBLL.UpdateTechnicianType(obj, ""); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改工人技能等级:(" + typeName + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "technician_title_type" && mode == "Update") { TechnicianTitleTypeBLL objBLL = new TechnicianTitleTypeBLL(); TechnicianTitleType obj = objBLL.GetTechnicianTitleTypeByTechnicianTitleTypeID(Convert.ToInt32(id)); obj.TechnicianTitleTypeID = Convert.ToInt32(id); string typeTitleName = obj.TypeName; if (objBLL.GetTechnicianTitleTypeByWhereClause("Technician_Title_Type_ID !=" + id + " and Type_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该干部技术职称,请重新输入!"; txtItemName.Focus(); return; } obj.TypeName = txtItemName.Text; obj.TypeLevel = Convert.ToInt32(ddlType.SelectedValue); objBLL.UpdateTechnicianTitleType(obj); txtMemo.ReadOnly = true; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改干部技术职称:(" + typeTitleName + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "education_employee_type" && mode == "Update") { EducationEmployeeTypeBLL objBLL = new EducationEmployeeTypeBLL(); EducationEmployeeType obj = objBLL.GetEducationEmployeeTypeByEducationEmployeeTypeID(Convert.ToInt32(id)); obj.EducationEmployeeTypeID = Convert.ToInt32(id); string typeTitleName = obj.TypeName; if (objBLL.GetAllEducationEmployeeTypeByWhereClause("Education_Employee_Type_ID !=" + id + " and Education_Employee_Type_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该职教人员类型,请重新输入!"; txtItemName.Focus(); return; } obj.TypeName = txtItemName.Text; objBLL.UpdateEducationEmployeeType(obj); txtMemo.ReadOnly = true; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改该职教人员类型:(" + typeTitleName + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "committee_head_ship" && mode == "Update") { CommitteeHeadShipBLL objBLL = new CommitteeHeadShipBLL(); CommitteeHeadShip obj = objBLL.GetCommitteeHeadShipByCommitteeHeadShipID(Convert.ToInt32(id)); obj.CommitteeHeadShipID = Convert.ToInt32(id); string ShipName = obj.CommitteeHeadShipName; if (objBLL.GetAllCommitteeHeadShipByWhereClause("committee_head_ship_id !=" + id + " and committee_head_ship_name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该职教委员会职务,请重新输入!"; txtItemName.Focus(); return; } obj.CommitteeHeadShipName = txtItemName.Text; objBLL.UpdateCommitteeHeadShip(obj); txtMemo.ReadOnly = true; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改职教委员会职务:(" + ShipName + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "random_exam_modular_type" && mode == "Update") { RandomExamModularTypeBLL objBLL = new RandomExamModularTypeBLL(); RandomExamModularType obj = objBLL.GetRandomExamModularTypeByTypeID(Convert.ToInt32(id)); obj.RandomExamModularTypeID = Convert.ToInt32(id); string TpyeName = obj.RandomExamModularTypeName; if (objBLL.GetAllRandomExamModularTypeByWhereClause("random_exam_modular_type_id !=" + id + " and random_exam_modular_type_name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该模块考试类别,请重新输入!"; txtItemName.Focus(); return; } obj.RandomExamModularTypeName = txtItemName.Text; objBLL.UpdateRandomExamModularType(obj); txtMemo.ReadOnly = true; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改模块考试类别:(" + TpyeName + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "trainplan_type" && mode == "Update") { OracleAccess oracle = new OracleAccess(); DataTable dt = oracle.RunSqlDataSet( string.Format( "select * from zj_trainplan_type where trainplan_type_id!={0} and trainplan_type_name='{1}'", Convert.ToInt32(id), txtItemName.Text)).Tables[0]; if (dt.Rows.Count > 0) { SessionSet.PageMessage = "系统中已存在该培训类别,请重新输入!"; txtItemName.Focus(); return; } DataTable dt1 = oracle.RunSqlDataSet( string.Format( "select * from zj_trainplan_type where trainplan_type_id={0}", Convert.ToInt32(id))).Tables[0]; oracle.ExecuteNonQuery( string.Format("update zj_trainplan_type set trainplan_type_name='{0}' where trainplan_type_id={1}", txtItemName.Text, (Convert.ToInt32(id)))); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改模块考试类别:(" + dt1.Rows[0]["trainplan_type_name"] + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "safe_level" && mode == "Update") { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet( string.Format("select count(1) from zj_safe_level where safe_level_id!={0} and safe_level_name='{1}'", Convert.ToInt32(id), txtItemName.Text.Trim())).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { SessionSet.PageMessage = "系统中已存在该安全等级,请重新输入!"; txtItemName.Focus(); return; } DataTable dt1 = access.RunSqlDataSet("select * from zj_safe_level where safe_level_id =" + id).Tables[0]; access.ExecuteNonQuery( string.Format("update zj_safe_level set safe_level_name='{0}' where safe_level_id={1}", txtItemName.Text.Trim(), Convert.ToInt32(id))); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改安全等级:(" + dt1.Rows[0]["safe_level_name"] + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "certificate" && mode == "Update") { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet( string.Format("select count(1) from zj_certificate where certificate_id!={0} and certificate_name='{1}'", Convert.ToInt32(id), txtItemName.Text.Trim())).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { SessionSet.PageMessage = "系统中已存在该证书,请重新输入!"; txtItemName.Focus(); return; } DataTable dt1 = access.RunSqlDataSet("select * from zj_certificate where certificate_id =" + id).Tables[0]; access.ExecuteNonQuery( string.Format("update zj_certificate set certificate_name='{0}' where certificate_id={1}", txtItemName.Text.Trim(), Convert.ToInt32(id))); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改证书:(" + dt1.Rows[0]["certificate_name"] + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "certificate_level" && mode == "Update") { OracleAccess access = new OracleAccess(); DataTable dt1 = access.RunSqlDataSet("select * from zj_certificate_level where certificate_level_id =" + id).Tables[0]; access.ExecuteNonQuery( string.Format("update zj_certificate_level set certificate_level_name='{0}',certificate_id={2} where certificate_level_id={1}", txtItemName.Text.Trim(), Convert.ToInt32(id), ddlType.SelectedValue)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改证书等级:(" + dt1.Rows[0]["certificate_level_name"] + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "certificate_unit" && mode == "Update") { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet( string.Format("select count(1) from zj_certificate_unit where certificate_unit_id!={0} and certificate_unit_name='{1}'", Convert.ToInt32(id), txtItemName.Text.Trim())).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { SessionSet.PageMessage = "系统中已存在该发证单位,请重新输入!"; txtItemName.Focus(); return; } DataTable dt1 = access.RunSqlDataSet("select * from zj_certificate_unit where certificate_unit_id =" + id).Tables[0]; access.ExecuteNonQuery( string.Format("update zj_certificate_unit set certificate_unit_name='{0}' where certificate_unit_id={1}", txtItemName.Text.Trim(), Convert.ToInt32(id))); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改发证单位:(" + dt1.Rows[0]["certificate_unit_name"] + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "train_unit" && mode == "Update") { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet( string.Format("select count(1) from zj_train_unit where train_unit_id!={0} and train_unit_name='{1}'", Convert.ToInt32(id), txtItemName.Text.Trim())).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { SessionSet.PageMessage = "系统中已存在该培训单位,请重新输入!"; txtItemName.Focus(); return; } DataTable dt1 = access.RunSqlDataSet("select * from zj_train_unit where train_unit_id =" + id).Tables[0]; access.ExecuteNonQuery( string.Format("update zj_train_unit set train_unit_name='{0}' where train_unit_id={1}", txtItemName.Text.Trim(), Convert.ToInt32(id))); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("修改培训单位:(" + dt1.Rows[0]["train_unit_name"] + ")为(" + txtItemName.Text + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "education_level" && mode == "Insert") { EducationLevelBLL objBLL = new EducationLevelBLL(); if (objBLL.GetEducationLevelByWhereClause("Education_Level_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该文化程度,请重新输入!"; txtItemName.Focus(); return; } objBLL.InsertEducationLevel(txtItemName.Text, txtMemo.Text); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增文化程度:" + txtItemName.Text); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "political_status" && mode == "Insert") { PoliticalStatusBLL objBLL = new PoliticalStatusBLL(); if (objBLL.GetPoliticalStatusByWhereClause("Political_Status_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该政治面貌,请重新输入!"; txtItemName.Focus(); return; } objBLL.InsertPoliticalStatus(txtItemName.Text, txtMemo.Text); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增政治面貌:" + txtItemName.Text); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "workgroupleader_level" && mode == "Insert") { WorkGroupLeaderLevelBLL objBLL = new WorkGroupLeaderLevelBLL(); if (objBLL.GetWorkGroupLeaderLevelByWhereClause("Level_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该班组长类别,请重新输入!"; txtItemName.Focus(); return; } objBLL.InsertWorkGroupLeaderLevel(txtItemName.Text, txtMemo.Text); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增班组长类别:" + txtItemName.Text); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "technician_type" && mode == "Insert") { TechnicianTypeBLL objBLL = new TechnicianTypeBLL(); if (objBLL.GetTechnicianTypeByWhereClause("Type_Name='" + txtItemName.Text + "'", "").Count > 0) { SessionSet.PageMessage = "系统中已存在该工人技能等级,请重新输入!"; txtItemName.Focus(); return; } objBLL.InsertTechnicianType(txtItemName.Text, txtMemo.Text, ""); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增工人技能等级:" + txtItemName.Text); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "technician_title_type" && mode == "Insert") { TechnicianTitleTypeBLL objBLL = new TechnicianTitleTypeBLL(); if (objBLL.GetTechnicianTitleTypeByWhereClause("Type_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该干部技术职称,请重新输入!"; txtItemName.Focus(); return; } TechnicianTitleType obj = new TechnicianTitleType(); obj.TypeName = txtItemName.Text; obj.TypeLevel = Convert.ToInt32(ddlType.SelectedValue); objBLL.InsertTechnicianTitleType(obj); txtMemo.ReadOnly = true; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增干部技术职称:" + txtItemName.Text); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "education_employee_type" && mode == "Insert") { EducationEmployeeTypeBLL objBLL = new EducationEmployeeTypeBLL(); if (objBLL.GetAllEducationEmployeeTypeByWhereClause("Education_Employee_Type_Name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该干部技术职称,请重新输入!"; txtItemName.Focus(); return; } EducationEmployeeType obj = new EducationEmployeeType(); obj.TypeName = txtItemName.Text; objBLL.InsertEducationEmployeeType(obj); txtMemo.Visible = false; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增职教人员类型:" + txtItemName.Text); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "committee_head_ship" && mode == "Insert") { CommitteeHeadShipBLL objBLL = new CommitteeHeadShipBLL(); if (objBLL.GetAllCommitteeHeadShipByWhereClause("committee_head_ship_name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该职教委员会职务,请重新输入!"; txtItemName.Focus(); return; } CommitteeHeadShip obj = new CommitteeHeadShip(); obj.CommitteeHeadShipName = txtItemName.Text; objBLL.InsertCommitteeHeadShip(obj); txtMemo.Visible = false; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增职教委员会职务:" + txtItemName.Text); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "random_exam_modular_type" && mode == "Insert") { RandomExamModularTypeBLL objBLL = new RandomExamModularTypeBLL(); if (objBLL.GetAllRandomExamModularTypeByWhereClause("random_exam_modular_type_name='" + txtItemName.Text + "'").Count > 0) { SessionSet.PageMessage = "系统中已存在该模块考试类别,请重新输入!"; txtItemName.Focus(); return; } RandomExamModularType obj = new RandomExamModularType(); obj.RandomExamModularTypeName = txtItemName.Text; objBLL.InsertRandomExamModularType(obj); txtMemo.Visible = false; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增模块考试类别:" + txtItemName.Text); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "trainplan_type" && mode == "Insert") { OracleAccess oracle = new OracleAccess(); DataTable dt = oracle.RunSqlDataSet( string.Format( "select * from zj_trainplan_type where trainplan_type_name='{0}'", txtItemName.Text)).Tables[0]; if (dt.Rows.Count > 0) { SessionSet.PageMessage = "系统中已存在该培训类别,请重新输入!"; txtItemName.Focus(); return; } oracle.ExecuteNonQuery( string.Format( "insert into zj_trainplan_type values(TRAIN_PLAN_TYPE_SEQ.Nextval,'{0}')", txtItemName.Text.Trim())); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增模块考试类别:(" + txtItemName.Text.Trim() + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } if (value == "safe_level" && mode == "Insert") { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet( string.Format("select count(1) from zj_safe_level where safe_level_name='{0}'", txtItemName.Text.Trim())).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { SessionSet.PageMessage = "系统中已存在该安全等级,请重新输入!"; txtItemName.Focus(); return; } try { DataTable dtcount = access.RunSqlDataSet("select count(1) from zj_safe_level").Tables[0]; string strIndex = "(select max(order_index)+1 from zj_safe_level)"; if (Convert.ToInt32(dtcount.Rows[0][0]) == 0) { strIndex = "1"; } string sql = string.Format( "insert into zj_safe_level values(safe_level_seq.nextval,'{0}',{1})", txtItemName.Text.Trim(), strIndex); access.ExecuteNonQuery(sql); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增安全等级:(" + txtItemName.Text.Trim() + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } catch { SessionSet.PageMessage = "数据新增失败!"; } } if (value == "certificate" && mode == "Insert") { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet( string.Format("select count(1) from zj_certificate where certificate_name='{0}'", txtItemName.Text.Trim())).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { SessionSet.PageMessage = "系统中已存在该证书,请重新输入!"; txtItemName.Focus(); return; } try { DataTable dtcount = access.RunSqlDataSet("select count(1) from zj_certificate").Tables[0]; string strIndex = "(select max(order_index)+1 from zj_certificate)"; if (Convert.ToInt32(dtcount.Rows[0][0]) == 0) { strIndex = "1"; } string sql = string.Format( "insert into zj_certificate values(zj_certificate_seq.nextval,'{0}',{1})", txtItemName.Text.Trim(), strIndex); access.ExecuteNonQuery(sql); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增证书:(" + txtItemName.Text.Trim() + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } catch { SessionSet.PageMessage = "数据新增失败!"; } } if (value == "certificate_level" && mode == "Insert") { OracleAccess access = new OracleAccess(); try { DataTable dtcount = access.RunSqlDataSet("select count(1) from zj_certificate_level").Tables[0]; string strIndex = "(select max(order_index)+1 from zj_certificate_level)"; if (Convert.ToInt32(dtcount.Rows[0][0]) == 0) { strIndex = "1"; } string sql = string.Format( "insert into zj_certificate_level values(zj_certificate_level_seq.nextval,'{0}','{1}',{2})", Convert.ToInt32(ddlType.SelectedValue), txtItemName.Text.Trim(), strIndex); access.ExecuteNonQuery(sql); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增证书级别:(" + txtItemName.Text.Trim() + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } catch { SessionSet.PageMessage = "数据新增失败!"; } } if (value == "certificate_unit" && mode == "Insert") { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet( string.Format("select count(1) from zj_certificate_unit where certificate_unit_name='{0}'", txtItemName.Text.Trim())).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { SessionSet.PageMessage = "系统中已存在该发证单位,请重新输入!"; txtItemName.Focus(); return; } try { DataTable dtcount = access.RunSqlDataSet("select count(1) from zj_certificate_unit").Tables[0]; string strIndex = "(select max(order_index)+1 from zj_certificate_unit)"; if (Convert.ToInt32(dtcount.Rows[0][0]) == 0) { strIndex = "1"; } string sql = string.Format( "insert into zj_certificate_unit values(zj_certificate_unit_seq.nextval,'{0}',{1})", txtItemName.Text.Trim(), strIndex); access.ExecuteNonQuery(sql); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增发证单位:(" + txtItemName.Text.Trim() + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } catch { SessionSet.PageMessage = "数据新增失败!"; } } if (value == "train_unit" && mode == "Insert") { OracleAccess access = new OracleAccess(); DataTable dt = access.RunSqlDataSet( string.Format("select count(1) from zj_train_unit where train_unit_name='{0}'", txtItemName.Text.Trim())).Tables[0]; if (Convert.ToInt32(dt.Rows[0][0]) > 0) { SessionSet.PageMessage = "系统中已存在该培训单位,请重新输入!"; txtItemName.Focus(); return; } try { DataTable dtcount = access.RunSqlDataSet("select count(1) from zj_train_unit").Tables[0]; string strIndex = "(select max(order_index)+1 from zj_train_unit)"; if (Convert.ToInt32(dtcount.Rows[0][0]) == 0) { strIndex = "1"; } string sql = string.Format( "insert into zj_train_unit values(zj_train_unit_seq.nextval,'{0}',{1})", txtItemName.Text.Trim(), strIndex); access.ExecuteNonQuery(sql); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("新增培训单位:(" + txtItemName.Text.Trim() + ")"); Response.Write("<script>window.opener.gridCallBack.callback('');window.close();</script>"); } catch { SessionSet.PageMessage = "数据新增失败!"; } } }
protected void Page_Load(object sender, EventArgs e) { hfChapterID.Value = Request.QueryString["id"]; if (fvBookChapter.CurrentMode == FormViewMode.Insert) { if (hfInsert.Value == "-1") { ((HiddenField)fvBookChapter.FindControl("hfParentID")).Value = Request.QueryString["ParentID"]; ((HiddenField)fvBookChapter.FindControl("hfBookID")).Value = Request.QueryString["BookID"]; } else { ((HiddenField)fvBookChapter.FindControl("hfParentId")).Value = hfInsert.Value; ((HiddenField)fvBookChapter.FindControl("hfBookID")).Value = Request.QueryString["BookID"]; } } string strRefresh = Request.Form.Get("Refresh"); if (strRefresh != null & strRefresh != "") { string strPath = "../Online/AssistBook/" + Request.QueryString["BookID"].ToString() + "/" + Request.QueryString["id"].ToString() + ".htm"; AssistBookChapterBLL objBill = new AssistBookChapterBLL(); objBill.UpdateAssistBookChapterUrl(Convert.ToInt32(Request.QueryString["id"].ToString()), strPath); RailExam.Model.AssistBookChapter objBookChapter = objBill.GetAssistBookChapter(Convert.ToInt32(Request.QueryString["id"].ToString())); string strChapterName = objBookChapter.ChapterName; string str = File.ReadAllText(Server.MapPath(strPath), Encoding.UTF8); if (str.IndexOf("chaptertitle") < 0) { if (objBookChapter.LevelNum < 3) { str = "<link href='book.css' type='text/css' rel='stylesheet' />" + "<body oncontextmenu='return false' ondragstart='return false' onselectstart ='return false' oncopy='document.selection.empty()' onbeforecopy='return false'>" + "<div id='chaptertitle" + objBookChapter.LevelNum + "'>" + strChapterName + "</div>" + "<br>" + str + "</body>"; } else { str = "<link href='book.css' type='text/css' rel='stylesheet' />" + "<body oncontextmenu='return false' ondragstart='return false' onselectstart ='return false' oncopy='document.selection.empty()' onbeforecopy='return false'>" + "<div id='chaptertitle3'>" + strChapterName + "</div>" + "<br>" + str + "</body>"; } File.WriteAllText(Server.MapPath(strPath), str, Encoding.UTF8); } AssistBookBLL objBookBill = new AssistBookBLL(); string strBookName = objBookBill.GetAssistBook(Convert.ToInt32(Request.QueryString["BookID"].ToString())).BookName; SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("编辑教材《" + strBookName + "》中“" + strChapterName + "”的章节内容"); fvBookChapter.DataBind(); Grid1.DataBind(); objBill.GetIndex(Request.QueryString["BookID"].ToString()); } string strRefreshGrid = Request.Form.Get("RefreshGrid"); if (strRefreshGrid != null & strRefreshGrid != "") { fvBookChapter.DataBind(); Grid1.DataBind(); } string strDeleteBookChapterUpdateID = Request.Form.Get("DeleteBookChapterUpdateID"); if (!string.IsNullOrEmpty(strDeleteBookChapterUpdateID)) { DeleteData(int.Parse(strDeleteBookChapterUpdateID)); Grid1.DataBind(); } }
protected void btnStop_Click(object sender, EventArgs e) { ViewState["EndTime"] = DateTime.Now.ToString(); //记录当前考试所在地的OrgID ViewState["OrgID"] = ConfigurationManager.AppSettings["StationID"]; string strId = Request.QueryString.Get("RandomExamID"); if (string.IsNullOrEmpty(strId)) { SessionSet.PageMessage = "缺少参数!"; return; } //获取当前考试的生成试卷的状态和次数 RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam objExam = objBll.GetExam(Convert.ToInt32(strId)); RandomExamComputerServerBLL serverBll = new RandomExamComputerServerBLL(); RandomExamComputerServer server = serverBll.GetRandomExamComputerServer(objExam.RandomExamId, PrjPub.ServerNo); if (server.IsStart == 0) { if (objExam.EndTime >= DateTime.Today) { SessionSet.PageMessage = "当前考试还未开始考试!"; return; } } else if (server.IsStart == 2) { SessionSet.PageMessage = "当前考试已经结束!"; return; } RandomExamResultCurrentBLL objResultCurrentBll = new RandomExamResultCurrentBLL(); IList <RandomExamResultCurrent> objResultCurrent = objResultCurrentBll.GetStartRandomExamResultInfo(Convert.ToInt32(strId)); IList <RandomExamResultCurrent> objResultCurrentNew = new List <RandomExamResultCurrent>(); try { RandomExamResultBLL objResultBll = new RandomExamResultBLL(); foreach (RandomExamResultCurrent current in objResultCurrent) { current.CurrentDateTime = DateTime.Parse(ViewState["EndTime"].ToString()); current.ExamTime = GetSecondBetweenTwoDate(DateTime.Parse(ViewState["EndTime"].ToString()), current.BeginDateTime); current.EndDateTime = DateTime.Parse(ViewState["EndTime"].ToString()); current.Score = 0; current.OrganizationId = int.Parse(ViewState["OrgID"].ToString()); current.Memo = ""; //参加考试将当前考试的标志置为2-已经结束 current.StatusId = 2; current.AutoScore = 0; current.CorrectRate = 0; //objResultCurrentNew.Add(current); objResultCurrentBll.UpdateRandomExamResultCurrent(current); int randomExamResultID = objResultBll.RemoveResultAnswer(Convert.ToInt32(current.RandomExamResultId)); //int randomExamResultID = objResultBll.RemoveResultAnswerCurrent(Convert.ToInt32(current.RandomExamResultId)); try { OracleAccess dbPhoto = new OracleAccess(); string strSql = "select * from Random_Exam_Result_Detail where Random_Exam_Result_ID=" + randomExamResultID + " and Random_Exam_ID=" + current.RandomExamId; DataSet dsPhoto = dbPhoto.RunSqlDataSet(strSql); if (dsPhoto.Tables[0].Rows.Count > 0) { DataRow drPhoto = dsPhoto.Tables[0].Rows[0]; int employeeId = Convert.ToInt32(drPhoto["Employee_ID"]); if (drPhoto["FingerPrint"] != DBNull.Value) { Pub.SavePhotoToLocal(current.RandomExamId, employeeId, (byte[])drPhoto["FingerPrint"], 0, randomExamResultID); } if (drPhoto["Photo1"] != DBNull.Value) { Pub.SavePhotoToLocal(current.RandomExamId, employeeId, (byte[])drPhoto["Photo1"], 1, randomExamResultID); } if (drPhoto["Photo2"] != DBNull.Value) { Pub.SavePhotoToLocal(current.RandomExamId, employeeId, (byte[])drPhoto["Photo2"], 2, randomExamResultID); } if (drPhoto["Photo3"] != DBNull.Value) { Pub.SavePhotoToLocal(current.RandomExamId, employeeId, (byte[])drPhoto["Photo3"], 3, randomExamResultID); } } } catch { hfSql.Value = GetSql(); } } hfSql.Value = GetSql(); examsGrid.DataBind(); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("“" + objExam.ExamName + "”终止正在进行的所有考试"); SessionSet.PageMessage = "终止当前考试成功!"; } catch { SessionSet.PageMessage = "终止当前考试失败!"; } }
private void StopExam(string strResultID) { ViewState["EndTime"] = DateTime.Now.ToString(); //记录当前考试所在地的OrgID ViewState["OrgID"] = ConfigurationManager.AppSettings["StationID"]; RandomExamResultCurrentBLL objResultCurrentBll = new RandomExamResultCurrentBLL(); RandomExamResultCurrent objResultCurrent = objResultCurrentBll.GetRandomExamResult(Convert.ToInt32(strResultID)); objResultCurrent.CurrentDateTime = DateTime.Parse(ViewState["EndTime"].ToString()); objResultCurrent.ExamTime = GetSecondBetweenTwoDate(DateTime.Parse(ViewState["EndTime"].ToString()), objResultCurrent.BeginDateTime); objResultCurrent.EndDateTime = DateTime.Parse(ViewState["EndTime"].ToString()); objResultCurrent.Score = 0; objResultCurrent.OrganizationId = int.Parse(ViewState["OrgID"].ToString()); objResultCurrent.Memo = ""; //参加考试将当前考试的标志置为2-已经结束 objResultCurrent.StatusId = 2; objResultCurrent.AutoScore = 0; objResultCurrent.CorrectRate = 0; RandomExamResultBLL objResultBll = new RandomExamResultBLL(); try { objResultCurrentBll.UpdateRandomExamResultCurrent(objResultCurrent); int randomExamResultID = objResultBll.RemoveResultAnswer(Convert.ToInt32(strResultID)); //将实时考试记录(临时表)转存到中间考试成绩表和答卷表 //int randomExamResultID = objResultBll.RemoveResultAnswerCurrent(Convert.ToInt32(strResultID)); try { OracleAccess dbPhoto = new OracleAccess(); string strSql = "select * from Random_Exam_Result_Detail where Random_Exam_Result_ID=" + randomExamResultID + " and Random_Exam_ID=" + objResultCurrent.RandomExamId; DataSet dsPhoto = dbPhoto.RunSqlDataSet(strSql); if (dsPhoto.Tables[0].Rows.Count > 0) { DataRow drPhoto = dsPhoto.Tables[0].Rows[0]; int employeeId = Convert.ToInt32(drPhoto["Employee_ID"]); if (drPhoto["FingerPrint"] != DBNull.Value) { Pub.SavePhotoToLocal(objResultCurrent.RandomExamId, employeeId, (byte[])drPhoto["FingerPrint"], 0, randomExamResultID); } if (drPhoto["Photo1"] != DBNull.Value) { Pub.SavePhotoToLocal(objResultCurrent.RandomExamId, employeeId, (byte[])drPhoto["Photo1"], 1, randomExamResultID); } if (drPhoto["Photo2"] != DBNull.Value) { Pub.SavePhotoToLocal(objResultCurrent.RandomExamId, employeeId, (byte[])drPhoto["Photo2"], 2, randomExamResultID); } if (drPhoto["Photo3"] != DBNull.Value) { Pub.SavePhotoToLocal(objResultCurrent.RandomExamId, employeeId, (byte[])drPhoto["Photo3"], 3, randomExamResultID); } } } catch { hfSql.Value = GetSql(); } #region 路局 //try //{ // if (!PrjPub.IsServerCenter) // { // RandomExamResult randomExamResult = // objResultBll.GetRandomExamResult(randomExamResultID); // objResultBll.AddRandomExamResultToServer(randomExamResult); // } //} //catch //{ // Pub.ShowErrorPage("无法连接路局服务器,请检查站段服务器网络连接是否正常!"); //} #endregion hfSql.Value = GetSql(); examsGrid.DataBind(); RandomExamBLL objBll = new RandomExamBLL(); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("“" + objBll.GetExam(objResultCurrent.RandomExamId).ExamName + "”中的“" + objResultCurrent.ExamineeName + "”终止考试"); SessionSet.PageMessage = "终止考试成功!"; } catch { SessionSet.PageMessage = "终止考试失败!"; } }
protected void btnDelPaper_Click(object sender, EventArgs e) { string strId = Request.QueryString.Get("RandomExamID"); if (string.IsNullOrEmpty(strId)) { SessionSet.PageMessage = "缺少参数!"; return; } //获取当前考试的生成试卷的状态和次数 RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam objExam = objBll.GetExam(Convert.ToInt32(strId)); RandomExamResultCurrentBLL objResultCurrentBll = new RandomExamResultCurrentBLL(); IList <RandomExamResultCurrent> objList = objResultCurrentBll.GetRandomExamResultInfo(Convert.ToInt32(strId)); int n = 0; foreach (RandomExamResultCurrent current in objList) { if (current.StatusId > 0) { n = 1; break; } } if (n > 0) { SessionSet.PageMessage = "当前考试有考生参加考试,不能再删除试卷!"; return; } RandomExamComputerServerBLL serverBll = new RandomExamComputerServerBLL(); RandomExamComputerServer server = serverBll.GetRandomExamComputerServer(objExam.RandomExamId, PrjPub.ServerNo); //if (!server.HasPaper) //{ // SessionSet.PageMessage = "当前考试还未生成试卷,不能删除试卷!"; // return; //} if (server.IsStart == 2) { SessionSet.PageMessage = "当前考试已经结束,不能再删除试卷!"; return; } try { objResultCurrentBll.DelRandomExamResultCurrent(Convert.ToInt32(strId)); objBll.UpdateHasPaper(Convert.ToInt32(strId), PrjPub.ServerNo, false); objBll.UpdateIsStart(Convert.ToInt32(strId), PrjPub.ServerNo, 0); if (objExam.StartMode == 2) { objBll.UpdateStartCode(Convert.ToInt32(strId), PrjPub.ServerNo, string.Empty); lblTitle.Visible = false; lblCode.Visible = false; btnApply.Visible = false; } SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("“" + objExam.ExamName + "”删除所有考试试卷"); SessionSet.PageMessage = "删除试卷成功!"; ClientScript.RegisterStartupScript(GetType(), "jsSelectFirstNode", @"refreshGrid();", true); } catch (Exception ex) { SessionSet.PageMessage = "删除试卷失败!"; Pub.ShowErrorPage(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack && !searchExamCallBack.IsCallback) { //如果是系统管理员访问站段服务器则没有权限监控站段考试 if (!PrjPub.IsServerCenter && PrjPub.CurrentLoginUser.IsAdmin && PrjPub.CurrentLoginUser.RoleID == 1) { btnGetPaper.Enabled = false; btnDelPaper.Enabled = false; btnStart.Enabled = false; btnStop.Enabled = false; btnEnd.Enabled = false; btnUpload.Enabled = false; btnUploadScore.Enabled = false; HfUpdateRight.Value = "False"; } //if (PrjPub.IsWuhan()) //{ // examsGrid.Levels[0].Columns[3].HeadingText = "员工编码"; //} //else //{ // examsGrid.Levels[0].Columns[3].HeadingText = "工资编号"; //} if (PrjPub.IsServerCenter) { btnUpload.Enabled = false; btnUploadScore.Enabled = false; } //当前站段有两台服务器并且当前服务器为次服务器时屏蔽“删除所有考生试卷”和“上传考试成绩”按钮 //if(!PrjPub.IsServerCenter && PrjPub.HasTwoServer() && !PrjPub.IsMainServer()) //{ // btnGetPaper.Visible = false; // btnDelPaper.Visible = false; // btnUpload.Visible = false; //} hfOrgID.Value = ConfigurationManager.AppSettings["StationID"].ToString(); string strId = Request.QueryString.Get("RandomExamID"); RandomExamArrangeBLL objArrangeBll = new RandomExamArrangeBLL(); IList <RandomExamArrange> objArrangeList = objArrangeBll.GetRandomExamArranges(Convert.ToInt32(strId)); string[] str = { "0" }; hfNowCount.Value = "0"; if (objArrangeList.Count == 1) { string strSql = "select * 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 b.Computer_Server_ID=c.Computer_Server_ID" + " where b.Org_ID='" + ConfigurationManager.AppSettings["StationID"] + "'" + " and c.Computer_Server_No='" + PrjPub.ServerNo + "'" + " and Random_Exam_ID=" + strId; OracleAccess db = new OracleAccess(); DataSet ds = db.RunSqlDataSet(strSql); string strUserId = ""; foreach (DataRow dr in ds.Tables[0].Rows) { if (string.IsNullOrEmpty(strUserId)) { strUserId += dr["User_Ids"].ToString(); } else { strUserId += "," + dr["User_Ids"]; } } strUserId = ("," + strUserId + ",").Replace(",0,", ","); str = ((strUserId.TrimStart(',')).TrimEnd(',')).Split(','); ExamBLL objexambll = new ExamBLL(); IList <RailExam.Model.Exam> objExamList = objexambll.GetExamsInfoByOrgID(null, -1, Convert.ToDateTime("0001-01-01"), Convert.ToDateTime("0001-01-01"), Convert.ToInt32(hfOrgID.Value), PrjPub.IsServerCenter.ToString()); foreach (RailExam.Model.Exam objExam in objExamList) { if (objExam.ExamId == Convert.ToInt32(strId)) { hfNowCount.Value = (str.Length - objExam.ExamineeCount).ToString(); break; } } } //获取当前考试的生成试卷的状态和次数 RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam objRandomExam = objBll.GetExam(Convert.ToInt32(strId)); RandomExamComputerServerBLL serverBll = new RandomExamComputerServerBLL(); RandomExamComputerServer server = serverBll.GetRandomExamComputerServer(objRandomExam.RandomExamId, PrjPub.ServerNo); if (server.HasPaper && objRandomExam.StartMode == 2 && server.IsStart != 0) { lblTitle.Text = "考试验证码:"; lblCode.Text = server.RandomExamCode; btnApply.Visible = true; } if (server.HasPaper && server.IsStart != 2)// && !objRandomExam.HasTrainClass { btnAddEmployee.Visible = true; } if (PrjPub.CurrentLoginUser.EmployeeID != 0) { examsGrid.Levels[0].Columns[12].Visible = false; } } if (!searchExamCallBack.IsCallback) { hfSql.Value = GetSql(); examsGrid.DataBind(); } if (Request.Form.Get("OutPutRandom") != null && Request.Form.Get("OutPutRandom") != "") { OutputWord(Request.Form.Get("OutPutRandom")); } if (Request.Form.Get("StopExam") != null && Request.Form.Get("StopExam") != "") { StopExam(Request.Form.Get("StopExam")); } if (Request.Form.Get("DeleteExam") != null && Request.Form.Get("DeleteExam") != "") { DeleteExam(Request.Form.Get("DeleteExam")); } if (Request.Form.Get("ClearExam") != null && Request.Form.Get("ClearExam") != "") { ClearExam(Request.Form.Get("ClearExam")); } if (Request.Form.Get("ReplyExam") != null && Request.Form.Get("ReplyExam") != "") { ReplyExam(Request.Form.Get("ReplyExam")); } if (Request.Form.Get("IsGet") != null && Request.Form.Get("IsGet") != "") { hfSql.Value = GetSql(); examsGrid.DataBind(); string strId = Request.QueryString.Get("RandomExamID"); RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam obj = objBll.GetExam(Convert.ToInt32(strId)); //if(!obj.HasTrainClass) //{ btnAddEmployee.Visible = true; //} SessionSet.PageMessage = "生成成功!"; } if (Request.Form.Get("IsEnd") != null && Request.Form.Get("IsEnd") != "") { hfSql.Value = GetSql(); examsGrid.DataBind(); SessionSet.PageMessage = "结束考试成功!"; } if (Request.Form.Get("IsUpload") != null && Request.Form.Get("IsUpload") != "") { hfSql.Value = GetSql(); examsGrid.DataBind(); string strId = Request.QueryString.Get("RandomExamID"); RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam obj = objBll.GetExam(Convert.ToInt32(strId)); SystemLogBLL objLogBll = new SystemLogBLL(); objLogBll.WriteLog("“" + obj.ExamName + "”上传考试成绩和答卷"); SessionSet.PageMessage = "上传成功!"; } if (Request.Form.Get("IsStart") != null && Request.Form.Get("IsStart") != "") { hfSql.Value = GetSql(); examsGrid.DataBind(); SessionSet.PageMessage = "开始考试成功!"; string strId = Request.QueryString.Get("RandomExamID"); //获取当前考试的生成试卷的状态和次数 RandomExamBLL objBll = new RandomExamBLL(); RailExam.Model.RandomExam objExam = objBll.GetExam(Convert.ToInt32(strId)); RandomExamComputerServerBLL serverBll = new RandomExamComputerServerBLL(); RandomExamComputerServer server = serverBll.GetRandomExamComputerServer(objExam.RandomExamId, PrjPub.ServerNo); if (server.HasPaper && objExam.StartMode == 2) { lblCode.Text = "考试验证码:" + server.RandomExamCode; btnApply.Visible = true; } ClientScript.RegisterStartupScript(GetType(), "jsSelectFirstNode", @"ApplyExam();", true); } if (Request.Form.Get("StudentInfo") != null && Request.Form.Get("StudentInfo") != "" && !searchExamCallBack.IsCallback) { DownloadStudentInfoExcel(); } refreshGridCallback.RefreshInterval = Convert.ToInt32(ConfigurationManager.AppSettings["RefreshInterval"]); btnUpload.Visible = btnUploadScore.Visible = false; // 包神这里用不著上传 2014-03-18 }