/// <summary>
        /// 填充页面
        /// </summary>
        protected void FillPage()
        {
            string value = Request.QueryString["TypeValue"];
            string id    = Request.QueryString["ID"];

            trType.Visible = false;
            trMemo.Visible = true;

            //修改 需要填充
            if (!string.IsNullOrEmpty(value) && !string.IsNullOrEmpty(id))
            {
                if (value == "education_level")
                {
                    EducationLevelBLL objBLL            = new EducationLevelBLL();
                    EducationLevel    objEducationLevel = objBLL.GetEducationLevelByEducationLevelID(Convert.ToInt32(id));
                    txtItemName.Text = objEducationLevel.EducationLevelName;
                    txtMemo.Text     = objEducationLevel.Memo;
                }
                if (value == "political_status")
                {
                    PoliticalStatusBLL objBLL             = new PoliticalStatusBLL();
                    PoliticalStatus    objPoliticalStatus = objBLL.GetPoliticalStatusByPoliticalStatusID(Convert.ToInt32(id));
                    txtItemName.Text = objPoliticalStatus.PoliticalStatusName;
                    txtMemo.Text     = objPoliticalStatus.Memo;
                }
                if (value == "workgroupleader_level")
                {
                    WorkGroupLeaderLevelBLL objBLL = new WorkGroupLeaderLevelBLL();
                    WorkGroupLeaderLevel    objWorkGroupLeaderLevel =
                        objBLL.GetWorkGroupLeaderLevelByWorkGroupLeaderLevelID(Convert.ToInt32(id));
                    txtItemName.Text = objWorkGroupLeaderLevel.LevelName;
                    txtMemo.Text     = objWorkGroupLeaderLevel.Memo;
                }
                if (value == "technician_type")
                {
                    TechnicianTypeBLL objBLL            = new TechnicianTypeBLL();
                    TechnicianType    objTechnicianType = objBLL.GetTechnicianTypeByTechnicianTypeID(Convert.ToInt32(id));
                    txtItemName.Text = objTechnicianType.TypeName;
                    txtMemo.Text     = objTechnicianType.Memo;
                }
                if (value == "technician_title_type")
                {
                    trType.Visible = true;
                    trMemo.Visible = false;
                    TechnicianTitleTypeBLL objBLL = new TechnicianTitleTypeBLL();
                    TechnicianTitleType    objTechnicianTitleType = objBLL.GetTechnicianTitleTypeByTechnicianTitleTypeID(Convert.ToInt32(id));
                    txtItemName.Text      = objTechnicianTitleType.TypeName;
                    ddlType.SelectedValue = objTechnicianTitleType.TypeLevel.ToString();
                    txtMemo.ReadOnly      = true;
                }
                if (value == "education_employee_type")
                {
                    trType.Visible = false;
                    trMemo.Visible = false;
                    EducationEmployeeTypeBLL objBLL = new EducationEmployeeTypeBLL();
                    EducationEmployeeType    obj    = objBLL.GetEducationEmployeeTypeByEducationEmployeeTypeID(Convert.ToInt32(id));
                    txtItemName.Text = obj.TypeName;
                    txtMemo.ReadOnly = true;
                }
                if (value == "committee_head_ship")
                {
                    trType.Visible = false;
                    trMemo.Visible = false;
                    CommitteeHeadShipBLL objBLL = new CommitteeHeadShipBLL();
                    CommitteeHeadShip    obj    = objBLL.GetCommitteeHeadShipByCommitteeHeadShipID(Convert.ToInt32(id));
                    txtItemName.Text = obj.CommitteeHeadShipName;
                    txtMemo.ReadOnly = true;
                }
                if (value == "random_exam_modular_type")
                {
                    trType.Visible = false;
                    trMemo.Visible = false;
                    RandomExamModularTypeBLL objBLL = new RandomExamModularTypeBLL();
                    RandomExamModularType    obj    = objBLL.GetRandomExamModularTypeByTypeID(Convert.ToInt32(id));
                    txtItemName.Text = obj.RandomExamModularTypeName;
                    txtMemo.ReadOnly = true;
                }
                if (value == "trainplan_type")
                {
                    trType.Visible = false;
                    trMemo.Visible = false;
                    OracleAccess oracle = new OracleAccess();
                    DataTable    dt     =
                        oracle.RunSqlDataSet(string.Format(
                                                 "select * from zj_trainplan_type where trainplan_type_id={0}", Convert.ToInt32(id))).Tables[
                            0];
                    txtItemName.Text = dt.Rows[0]["trainplan_type_name"].ToString();
                }

                if (value == "safe_level")
                {
                    trType.Visible = false;
                    trMemo.Visible = false;
                    OracleAccess access = new OracleAccess();
                    DataTable    dt     = access.RunSqlDataSet("select * from zj_safe_level where  safe_level_id =" + id).Tables[0];
                    txtItemName.Text = dt.Rows[0]["safe_level_name"].ToString();
                }
                if (value == "certificate")
                {
                    trType.Visible = false;
                    trMemo.Visible = false;
                    OracleAccess access = new OracleAccess();
                    DataTable    dt     = access.RunSqlDataSet("select * from zj_certificate where  certificate_id =" + id).Tables[0];
                    txtItemName.Text = dt.Rows[0]["certificate_name"].ToString();
                }
                if (value == "certificate_level")
                {
                    trType.Visible = true;
                    trMemo.Visible = false;
                    OracleAccess access = new OracleAccess();
                    DataTable    dt     = access.RunSqlDataSet("select * from zj_certificate_level where  certificate_level_id =" + id).Tables[0];
                    txtItemName.Text       = dt.Rows[0]["certificate_level_name"].ToString();
                    ddlType.DataSource     = access.RunSqlDataSet("select * from zj_certificate order by order_index").Tables[0];
                    ddlType.DataTextField  = "certificate_name";
                    ddlType.DataValueField = "certificate_id";
                    ddlType.DataBind();
                    ddlType.SelectedValue = dt.Rows[0]["certificate_id"].ToString();
                }
                if (value == "certificate_unit")
                {
                    trType.Visible = false;
                    trMemo.Visible = false;
                    OracleAccess access = new OracleAccess();
                    DataTable    dt     = access.RunSqlDataSet("select * from zj_certificate_unit where  certificate_unit_id =" + id).Tables[0];
                    txtItemName.Text = dt.Rows[0]["certificate_unit_name"].ToString();
                }
                if (value == "train_unit")
                {
                    trType.Visible = false;
                    trMemo.Visible = false;
                    OracleAccess access = new OracleAccess();
                    DataTable    dt     = access.RunSqlDataSet("select * from zj_train_unit where  train_unit_id =" + id).Tables[0];
                    txtItemName.Text = dt.Rows[0]["train_unit_name"].ToString();
                }
            }
            else
            {
                if (value == "technician_title_type")
                {
                    trType.Visible = true;
                    trMemo.Visible = false;
                }
                if (value == "education_employee_type")
                {
                    trMemo.Visible = false;
                }
                if (value == "committee_head_ship")
                {
                    trMemo.Visible = false;
                }
                if (value == "random_exam_modular_type")
                {
                    trMemo.Visible = false;
                }
                if (value == "trainplan_type")
                {
                    trMemo.Visible = false;
                }
                if (value == "safe_level")
                {
                    trMemo.Visible = false;
                }
                if (value == "certificate")
                {
                    trMemo.Visible = false;
                }
                if (value == "certificate_level")
                {
                    trMemo.Visible = false;
                    trType.Visible = true;
                    OracleAccess access = new OracleAccess();
                    ddlType.DataSource     = access.RunSqlDataSet("select * from zj_certificate order by order_index").Tables[0];
                    ddlType.DataTextField  = "certificate_name";
                    ddlType.DataValueField = "certificate_id";
                    ddlType.DataBind();
                }
                if (value == "certificate_unit")
                {
                    trMemo.Visible = false;
                }
                if (value == "train_unit")
                {
                    trMemo.Visible = false;
                }
            }
        }
Esempio n. 2
0
        /// <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);
            }
        }
        /// <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 = "数据新增失败!";
                }
            }
        }