工事管理システム製品化対応

        public static int s_SystemVersion = 202;

                // 承認データを取得する

                string strData = ApprDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode, OrderNo);

                //strData += string.Format(" And SeqNo != {0} And ApprovalStatus = {1}", s_PrimartyRecord, (int)CommonDefine.ApprovalStatus.Approval);

                strData += " Order By SeqNo ASC";

                List<ProcessApproval> DataList = new List<ProcessApproval>();

                if (!ApprDB.SelectAction(strData, ref DataList)) return false;

                if (DataList.Count == 0) return false;

                // 申請データを取得する

                ProcessApproval RequestData = DataList.Find(x => x.SeqNo == s_PrimartyRecord);

                if (RequestData == null) return false;

                    // 申請データは対象にしない

                    if (DataRec.SeqNo == s_PrimartyRecord) continue;

                        // 承認していればデータ件数からマイナス

                        --NoCnt;

                            // 最終承認済みは処理しない

                            if (RequestData.ApprovalStatus == (int)CommonDefine.ApprovalStatus.Approval) break;

                if (NoCnt == 0)

                {

                    // 最終承認済みは処理しない

                    if (RequestData.ApprovalStatus != (int)CommonDefine.ApprovalStatus.Approval)

                    {

                        bApproval = true;

                    }

                }

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 工事担当者変更履歴データ

    /// </summary>

    public class ChgConstrCharge

    {

        #region 定数

        /// <summary>

        /// 設定区分定義

        /// </summary>

        public enum DivisionDef

        {

            /// <summary>

            /// 1:指導員給料行

            /// </summary>

            Instructor = 1,

            /// <summary>

            /// 2:副担当者給料行

            /// </summary>

            Assistant,

            /// <summary>

            /// 3:担当者給料行

            /// </summary>

            Payroll,

        }

        #endregion

        #region メンバ変数

        private int         m_ConstructionCode = 0;             // 工事コード

        private int         m_Division = 0;                     // 設定区分

        private int         m_SeqNo = 0;                        // 連番

        private int         m_DepartmentCode = 0;               // 部署コード

        private int         m_PersonCode = 0;                   // 担当者コード

        private DateTime    m_StartDate = DateTime.MinValue;    // 担当開始年月日

        private DateTime    m_CompDate = DateTime.MinValue;     // 担当終了年月日

        private DateTime    m_EntryDate = DateTime.Now;         // 登録日付

        private DateTime    m_UpdateDate = DateTime.Now;        // 更新日付

        #endregion

        #region コンストラクタ

        #endregion

        #region プロパティ

        /// <summary>

        /// 工事コード

        /// </summary>

        public int ConstructionCode

        {

            get { return m_ConstructionCode; }

            set { m_ConstructionCode = value; }

        }

        /// <summary>

        /// 設定区分

        /// </summary>

        public int Division

        {

            get { return m_Division; }

            set { m_Division = value; }

        }

        /// <summary>

        /// 連番

        /// </summary>

        public int SeqNo

        {

            get { return m_SeqNo; }

            set { m_SeqNo = value; }

        }

        /// <summary>

        /// 部署コード

        /// </summary>

        public int DepartmentCode

        {

            get { return m_DepartmentCode; }

            set { m_DepartmentCode = value; }

        }

        /// <summary>

        /// 担当者コード

        /// </summary>

        public int PersonCode

        {

            get { return m_PersonCode; }

            set { m_PersonCode = value; }

        }

        /// <summary>

        /// 担当開始年月日

        /// </summary>

        public DateTime StartDate

        {

            get { return m_StartDate; }

            set { m_StartDate = value; }

        }

        /// <summary>

        /// 担当終了年月日

        /// </summary>

        public DateTime CompDate

        {

            get { return m_CompDate; }

            set { m_CompDate = value; }

        }

        /// <summary>

        /// 登録日付

        /// </summary>

        public DateTime EntryDate

        {

            set { m_EntryDate = value; }

            get { return m_EntryDate; }

        }

        /// <summary>

        /// 更新日付

        /// </summary>

        public DateTime UpdateDate

        {

            set { m_UpdateDate = value; }

            get { return m_UpdateDate; }

        }

        #endregion

    }

}

                string strwrk = CommonMotions.LoginUserData.DisplayString.Substring(0, 7);

                m_dispLabelControl[(int)DispHeader.ApprovalDisplayString].Text = strwrk;                                            // 役職名

                string strwrk = string.Empty;

                if (CommonMotions.LoginUserData.DisplayString.Length > 7)

                    strwrk = CommonMotions.LoginUserData.DisplayString.Substring(0, 7);

                else

                    strwrk = CommonMotions.LoginUserData.DisplayString;

                m_dispLabelControl[(int)DispHeader.ApprovalDisplayString].Text = strwrk;                                            // 役職名

                SetcmbPersonInCharge();                     // ?S????

                SetConstrManCombbox();                      // ?H???S????i???p????????????j

        #region ?????R???{?{?b?N?X?f?[?^???r?p?k??

        /// <summary>

        /// ?????R???{?{?b?N?X?f?[?^???r?p?k??

        /// </summary>

        /// <param name="strSQL"></param>

        public static void CreateDepCombBoxSQL(ref StringBuilder strSQL, int nTargetCount)

        {

            try

            {

                // ??????f?[?^????????????

                bool bNowSeason = CommonMotions.CheckNowSeason(nTargetCount);

                strSQL.Append("SELECT");

                strSQL.Append(" A.DEPARTMENTCODE");

                strSQL.Append(", A.DEPARTMENTSTRING");

                strSQL.Append(", A.DISPLAYORDER");

                strSQL.Append(", COUNT(*)");

                strSQL.Append(" FROM");

                if (bNowSeason)

                {

                    // ??????v???C?}???e?[?u????????}?X?^

                    strSQL.Append(" DEPARTMENTMASTER A");

                }

                else

                {   // ?????f?[?^??H????????????

                    strSQL.Append(" (");

                    strSQL.Append("Select");

                    strSQL.Append(" A1.SalesDepCode As DEPARTMENTCODE");

                    strSQL.Append(", B1.DetailString As DEPARTMENTSTRING");

                    strSQL.Append(", ifnull(C1.DisplayOrder, 10) As DISPLAYORDER");

                    strSQL.Append(" From Constructionbaseinfo As A1");

                    strSQL.Append("  Inner Join constructionbaseinfodetail As B1");

                    strSQL.Append("        On B1.ConstructionCode = A1.ConstructionCode");

                    strSQL.AppendFormat("  And B1.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.SalesDepartmentName);

                    strSQL.Append("  Left Join departmentmaster As C1");

                    strSQL.Append("       On C1.DepartmentCode = A1.SalesDepCode");

                    strSQL.AppendFormat(" Where A1.ConstructionPeriod = {0}", nTargetCount);

                    strSQL.Append("       And A1.SalesDepCode != 0");

                    strSQL.Append(" Union Select");

                    strSQL.Append(" A2.ConstrDepCode As DEPARTMENTCODE");

                    strSQL.Append(", B2.DetailString As DEPARTMENTSTRING");

                    strSQL.Append(", ifnull(C2.DisplayOrder, 10) As DISPLAYORDER");

                    strSQL.Append(" From Constructionbaseinfo As A2");

                    strSQL.Append(" Inner Join constructionbaseinfodetail As B2");

                    strSQL.Append("       On B2.ConstructionCode = A2.ConstructionCode");

                    strSQL.AppendFormat(" And B2.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstrDepartmentName);

                    strSQL.Append(" Left Join departmentmaster As C2");

                    strSQL.Append("      On C2.DepartmentCode = A2.ConstrDepCode");

                    strSQL.AppendFormat(" Where A2.ConstructionPeriod = {0}", nTargetCount);

                    strSQL.Append("       And A2.ConstrDepCode != 0");

                    strSQL.Append(" Union Select");

                    strSQL.Append(" A3.ConstrSubDepCode As DEPARTMENTCODE");

                    strSQL.Append(", B3.DetailString As DEPARTMENTSTRING");

                    strSQL.Append(", ifnull(C3.DisplayOrder, 10) As DISPLAYORDER");

                    strSQL.Append(" From Constructionbaseinfo As A3");

                    strSQL.Append(" Inner Join constructionbaseinfodetail As B3");

                    strSQL.Append("       On B3.ConstructionCode = A3.ConstructionCode");

                    strSQL.AppendFormat(" And B3.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstrSubDepartmentName);

                    strSQL.Append(" Left Join departmentmaster As C3");

                    strSQL.Append("      On C3.DepartmentCode = A3.ConstrSubDepCode");

                    strSQL.AppendFormat(" Where A3.ConstructionPeriod = {0}", nTargetCount);

                    strSQL.Append("       And A3.ConstrSubDepCode != 0");

                    strSQL.Append(" Union Select");

                    strSQL.Append(" A4.ConstrInstrDepCode As DEPARTMENTCODE");

                    strSQL.Append(", B4.DetailString As DEPARTMENTSTRING");

                    strSQL.Append(", ifnull(C4.DisplayOrder, 10) As DISPLAYORDER");

                    strSQL.Append(" From Constructionbaseinfo As A4");

                    strSQL.Append(" Inner Join constructionbaseinfodetail As B4");

                    strSQL.Append("       On B4.ConstructionCode = A4.ConstructionCode");

                    strSQL.AppendFormat(" And B4.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.InstrDepartmentName);

                    strSQL.Append(" Left Join departmentmaster As C4");

                    strSQL.Append("      On C4.DepartmentCode = A4.ConstrInstrDepCode");

                    strSQL.AppendFormat(" Where A4.ConstructionPeriod = {0}", nTargetCount);

                    strSQL.Append("       And A4.ConstrInstrDepCode != 0");

                    strSQL.Append(") As A");

                }

                if (bNowSeason)

                {   // ???????????

                    strSQL.Append(" WHERE");

                    // ???????????????

                    strSQL.AppendFormat(" A.DELETEFLG = {0}", (int)CommonDefine.DataRowDeleteDef.Exists);

                    DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(nTargetCount, false);

                    strSQL.AppendFormat(" And DATE(A.StartDate) <= DATE('{0}')", dtDefaultEnd.ToShortDateString());

                }

                else

                {   // ??????????

                    strSQL.Append(", CONSTRUCTIONBASEINFO C");

                    strSQL.Append(" WHERE");

                    strSQL.AppendFormat(" (C.ConstructionPeriod = {0}", nTargetCount);

                    strSQL.Append(" And A.DepartmentCode IN(C.SalesDepCode, C.ConstrDepCode, C.ConstrSubDepCode, C.ConstrInstrDepCode))");

                }

                strSQL.Append(" GROUP BY A.DEPARTMENTCODE, A.DEPARTMENTSTRING, A.DISPLAYORDER");

                strSQL.Append(" ORDER BY A.DISPLAYORDER ASC");

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

            }

        }

        #endregion

                CreateDepCombBoxSQL(ref strSQL, nPeriod);

                                                    .Where(x => CommonMotions.cnvInt(x.Cells[nGroupCount].Value) == (int)DataGroup.Expenses)

                    if (CurRec.NameCode < 1) continue;

        /// <summary>

        /// ?[??????

        /// </summary>

        Fraction,

                                                            , "????????????@"

                                                            , "?[?@???@???@???@"};

                // ----- 端数処理金額

                GetEstimateDataFraction();

                Datarec.FirstString = GroupTitle[(int)GroupName_EstimateBudget.PurchasePrice];          // 構成名称

        #region 見積データの端数を引き込む

        /// <summary>

        /// 見積データの端数を引き込む

        /// </summary>

        /// <returns></returns>

        private void GetEstimateDataFraction()

        {

            IOEstimateData esDB = new IOEstimateData();

            try

            {

                string TargetCode = FrmEstimateInput.TotalTitleName.First(x => x.Value.Equals("端　数　処　理")).Key;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT COMPONENTCODE, ITEMNAME, SPECNAME, PRICEVALUE, FIXEDITEMCODE");

                strSQL.Append(" FROM ESTIMATEDATA");

                strSQL.AppendFormat(" WHERE CONSTRUCTIONCODE = {0}", m_ConstructionCode);

                strSQL.AppendFormat(" AND FixedItemCode = '{0}'", TargetCode);

                ArrayList arList = new ArrayList();

                if (!esDB.ExecuteReader(strSQL.ToString(), ref arList)) return;

                // データ無は処理しない

                if (arList.Count == 0) return;

                // 空行セット

                InsertBlankLine(2);

                // タイトルセット

                DispTitle(GroupTitle[(int)GroupName_EstimateBudget.Fraction], (int)TitleDivision.Group);

                DataGridView dgv = dgvAllDisplay;

                int icnt = 1;

                double dSumaryWork = 0;

                double dTotal = 0;

                foreach (object[] wrkobj in arList)

                {

                    dSumaryWork = CommonMotions.cnvInt(wrkobj[3]);

                    string ComponentName = string.Empty;

                    string ItemName = string.Empty;

                    int CompomentCode = 0;

                    if (!CommonMotions.chkObjectIsNull(wrkobj[1])) ComponentName = wrkobj[1].ToString();

                    if (!CommonMotions.chkObjectIsNull(wrkobj[2])) ItemName = wrkobj[2].ToString();

                    if (!CommonMotions.chkObjectIsNull(wrkobj[0])) CompomentCode = CommonMotions.cnvInt(wrkobj[0]);

                    // データ表示

                    int iItemCode = CommonMotions.cnvInt(wrkobj[4]);

                    EstimateBudgetDetail Datarec = new EstimateBudgetDetail();

                    Datarec.GroupCount = (int)GroupName_EstimateBudget.Dispose;    // グループ番号

                    Datarec.ComponentCode = CompomentCode;          // 構成キー

                    Datarec.ItemCode = iItemCode;	                // 工種キー

                    Datarec.FirstString = ComponentName;            // 構成名称

                    Datarec.SecondString = ItemName;                // 工種名称・協力会社名

                    Datarec.EstimatePrice = dSumaryWork;            // 見積時金額

                    Datarec.NegotiationPrice = dSumaryWork;         // 交渉時金額

                    DisplayGridData(icnt++, Datarec);

                    dTotal += dSumaryWork;

                    // クリア

                    dSumaryWork = 0;

                    int nLineCnt = dgv.RowCount - 1;

                    // 端数処理は入力させない

                    dgv.Rows[nLineCnt].Cells[(int)DispGridColumn.EstimatePrice].ReadOnly = true;

                    dgv.Rows[nLineCnt].Cells[(int)DispGridColumn.NegotiationPrice].ReadOnly = true;

                }

                // 小計

                string strDspName = GroupTitle[(int)GroupName_EstimateBudget.Fraction] + s_TotaFixlName;

                CreateTotalLine(strDspName, dTotal, dTotal, (int)TitleDivision.Group, (int)GroupName_EstimateBudget.Fraction);

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

            }

            finally

            {

                esDB.close(); esDB = null;

            }

        }

        #endregion

                newpage.EntryDGV.SelectionChanged += new System.EventHandler(this.dgvEntryData_SelectionChanged);

                if (bRef) btnRequestPrint.Visible = false;           // 見積依頼印刷ボタン

                    if (m_ConstructionBaseInfo.TyingFlg != (int)ConstructionBaseInfo.TyingFlgDef.Tying)

        //try

        //{

        //    // 最初に削除

        //    string strSQL = CommentDB.CreatePrimarykeyString(m_ConstructionCode);

        //    CommentDB.DeleteAction(strSQL, false);

        //    int SeqCount = 1;

        //    int PageCnt = 1;

        //    // 表示ページよりコメントを抜き出して登録を行う

        //    foreach (EstimateInputPage CurEntryPage in m_EntryPage)

        //    {

        //        foreach (Control wrkCtrl in CurEntryPage.CommentShapeContainer.Controls)

        //        {

        //            // コメントのみを対象にする

        //            if (!wrkCtrl.GetType().Equals(typeof(MoveTextBox))) continue;

        //            PointingOutComment ComRec = new PointingOutComment();

        //            ComRec.ConstructionCode = m_ConstructionCode;

        //            ComRec.ProcessNo = (int)ClsExcute.ProcessExecuteNo.EstimateInput;

        //            ComRec.SeqNo = SeqCount++;

        //            ComRec.PageCount = PageCnt;

        //            ComRec.PersonCode = ((MoveTextBox)wrkCtrl).ContinerCode;

        //            ComRec.DrowColor = String.Format("0x{0:X2}{1:X2}{2:X2}"

        //                            , wrkCtrl.BackColor.R, wrkCtrl.BackColor.G, wrkCtrl.BackColor.B);

        //            ComRec.CommentMessage = wrkCtrl.Text;

        //            ComRec.StartPointX = ((MoveTextBox)wrkCtrl).ParentPoint.X;

        //            ComRec.StartPointY = ((MoveTextBox)wrkCtrl).ParentPoint.Y;

        //            ComRec.CurrentPointX = ((MoveTextBox)wrkCtrl).Location.X;

        //            ComRec.CurrentPointY = ((MoveTextBox)wrkCtrl).Location.Y;

        //            ComRec.CurrentWidth = ((MoveTextBox)wrkCtrl).Width;

        //            ComRec.CurrentHeight = ((MoveTextBox)wrkCtrl).Height;

        //            // 追加処理

        //            if (!CommentDB.InsertAction(ComRec, false))

        //            {

        //                return false;

        //            }

        //        }

        //        PageCnt++;

        //    }

        //    return true;

        //catch (System.Exception ex)

        //{

        //    logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

        //    return false;

        //}

        //}

        //IOPointingOutComment CommentDB = new IOPointingOutComment();

        //IOMPersonInCharge picDB = new IOMPersonInCharge();

        //try

        //{

        //    string strSQL = CommentDB.CreatePrimarykeyString(m_ConstructionCode);

        //    strSQL += " ORDER BY PageCount";

        //    List<PointingOutComment> CommentList = new List<PointingOutComment>();

        //    if (!CommentDB.SelectAction(strSQL, ref CommentList)) return false;

        //    if (CommentList.Count == 0) return true;

        //    // コメントを抜き出して表示を行う

        //    foreach (PointingOutComment ComRec in CommentList)

        //    {

        //        int TabCnt = ComRec.PageCount - 1;

        //        ShapeContainer wrkCtrl = m_EntryPage[TabCnt].CommentShapeContainer;

        //        // コメントボックス追加

        //        MoveTextBox NewComment = new MoveTextBox();

        //        NewComment.ParentPoint = new Point(ComRec.StartPointX, ComRec.StartPointY);

        //        NewComment.StartPoint = new Point(ComRec.CurrentPointX, ComRec.CurrentPointY);

        //        NewComment.Width = ComRec.CurrentWidth;

        //        NewComment.Height = ComRec.CurrentHeight;

        //        NewComment.DrowColor = CommonMotions.getBackForeColor(ComRec.DrowColor, CommonDefine.PalceOfColor.BackColor);

        //        NewComment.Text = ComRec.CommentMessage;

        //        NewComment.ContinerCode = ComRec.PersonCode;

        //        // 権限により変更可能かどうかを確認する

        //        if (!GetCommentEditPermission(ComRec.PersonCode)) NewComment.ReadOnly = true;

        //        string strPerson = picDB.CreatePrimarykeyString(ComRec.PersonCode);

        //        PersonInChargeMaster picRec = new PersonInChargeMaster();

        //        picDB.SelectAction(strPerson, ref picRec);

        //        NewComment.ToolTipString = string.Format("指摘者：{0}", picRec.PersonName);

        //        wrkCtrl.Controls.Add(NewComment);

        //    }

        //    return true;

        //catch (System.Exception ex)

        //{

        //    logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

        //    return false;

        //}

        //finally

        //{

        //    CommentDB.close(); CommentDB = null;

        //    picDB.close(); picDB = null;

        //}

        //}

            this.txtInput3 = new ProcessManagement.Forms.CustomControls.TextBoxEX();

            this.cmbDepartment = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.cmbLedgerFlg = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.cmbSecManage = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.dgvSalary = new ProcessManagement.Forms.CustomControls.DataGridViewEX();

            this.SalaryColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.SalaryColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.SalaryColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.dgvRefDepartment = new ProcessManagement.Forms.CustomControls.DataGridViewEX();

            this.Column8 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.TextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.cmbRefDepartment = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.dgvAssignment = new ProcessManagement.Forms.CustomControls.DataGridViewEX();

            this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.dataGridViewTextBoxColumn2 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.dataGridViewTextBoxColumn3 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.panel2.SuspendLayout();

            this.panel3.SuspendLayout();

            // txtInput3

            // 

            this.txtInput3.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.txtInput3.ImeMode = System.Windows.Forms.ImeMode.Disable;

            this.txtInput3.Location = new System.Drawing.Point(148, 111);

            this.txtInput3.MaxLength = 11;

            this.txtInput3.Name = "txtInput3";

            this.txtInput3.Size = new System.Drawing.Size(139, 23);

            this.txtInput3.TabIndex = 3;

            this.txtInput3.TextChanged += new System.EventHandler(this.txtInput_TextChanged);

            this.txtInput3.Validated += new System.EventHandler(this.txtInput_Validated);

            // 

            // cmbDepartment

            // 

            this.cmbDepartment.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.tableLayoutPanel1.SetColumnSpan(this.cmbDepartment, 3);

            this.cmbDepartment.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

            this.cmbDepartment.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

            this.cmbDepartment.FormattingEnabled = true;

            this.cmbDepartment.Location = new System.Drawing.Point(148, 362);

            this.cmbDepartment.Name = "cmbDepartment";

            this.cmbDepartment.Size = new System.Drawing.Size(429, 24);

            this.cmbDepartment.TabIndex = 8;

            this.cmbDepartment.TextChanged += new System.EventHandler(this.valueChange);

            // 

            // cmbLedgerFlg

            // 

            this.cmbLedgerFlg.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.cmbLedgerFlg.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

            this.cmbLedgerFlg.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

            this.cmbLedgerFlg.FormattingEnabled = true;

            this.cmbLedgerFlg.Location = new System.Drawing.Point(148, 647);

            this.cmbLedgerFlg.Name = "cmbLedgerFlg";

            this.cmbLedgerFlg.Size = new System.Drawing.Size(139, 24);

            this.cmbLedgerFlg.TabIndex = 13;

            this.cmbLedgerFlg.TextChanged += new System.EventHandler(this.valueChange);

            // 

            // cmbSecManage

            // 

            this.cmbSecManage.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.tableLayoutPanel1.SetColumnSpan(this.cmbSecManage, 2);

            this.cmbSecManage.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

            this.cmbSecManage.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

            this.cmbSecManage.FormattingEnabled = true;

            this.cmbSecManage.Location = new System.Drawing.Point(148, 682);

            this.cmbSecManage.Name = "cmbSecManage";

            this.cmbSecManage.Size = new System.Drawing.Size(284, 24);

            this.cmbSecManage.TabIndex = 14;

            this.cmbSecManage.SelectedValueChanged += new System.EventHandler(this.cmbSecManage_SelectedValueChanged);

            this.cmbSecManage.TextChanged += new System.EventHandler(this.valueChange);

            // 

            this.cmbRefDepartment.Location = new System.Drawing.Point(148, 967);

            // btnRefDepDel

            // 

            this.btnRefDepDel.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 

            | System.Windows.Forms.AnchorStyles.Left) 

            | System.Windows.Forms.AnchorStyles.Right)));

            this.btnRefDepDel.BackColor = System.Drawing.Color.Red;

            this.btnRefDepDel.Font = new System.Drawing.Font("ＭＳ 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.btnRefDepDel.ForeColor = System.Drawing.Color.White;

            this.btnRefDepDel.Location = new System.Drawing.Point(438, 998);

            this.btnRefDepDel.Name = "btnRefDepDel";

            this.btnRefDepDel.Size = new System.Drawing.Size(139, 29);

            this.btnRefDepDel.TabIndex = 33;

            this.btnRefDepDel.TabStop = false;

            this.btnRefDepDel.Text = "参照部署削除";

            this.btnRefDepDel.UseVisualStyleBackColor = false;

            this.btnRefDepDel.Click += new System.EventHandler(this.btnRefDepDel_Click);

            // 

            // btnRefDepAdd

            // 

            this.btnRefDepAdd.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 

            | System.Windows.Forms.AnchorStyles.Left) 

            | System.Windows.Forms.AnchorStyles.Right)));

            this.btnRefDepAdd.BackColor = System.Drawing.Color.Green;

            this.btnRefDepAdd.Font = new System.Drawing.Font("ＭＳ 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.btnRefDepAdd.ForeColor = System.Drawing.Color.White;

            this.btnRefDepAdd.Location = new System.Drawing.Point(293, 998);

            this.btnRefDepAdd.Name = "btnRefDepAdd";

            this.btnRefDepAdd.Size = new System.Drawing.Size(139, 29);

            this.btnRefDepAdd.TabIndex = 32;

            this.btnRefDepAdd.TabStop = false;

            this.btnRefDepAdd.Text = "参照部署追加";

            this.btnRefDepAdd.UseVisualStyleBackColor = false;

            this.btnRefDepAdd.Click += new System.EventHandler(this.btnRefDepAdd_Click);

            // 

            // BtnDepartMentAdd

            // 

            this.BtnDepartMentAdd.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 

            | System.Windows.Forms.AnchorStyles.Left) 

            | System.Windows.Forms.AnchorStyles.Right)));

            this.BtnDepartMentAdd.BackColor = System.Drawing.Color.Green;

            this.BtnDepartMentAdd.Font = new System.Drawing.Font("ＭＳ 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.BtnDepartMentAdd.ForeColor = System.Drawing.Color.White;

            this.BtnDepartMentAdd.Location = new System.Drawing.Point(293, 393);

            this.BtnDepartMentAdd.Name = "BtnDepartMentAdd";

            this.BtnDepartMentAdd.Size = new System.Drawing.Size(139, 29);

            this.BtnDepartMentAdd.TabIndex = 32;

            this.BtnDepartMentAdd.TabStop = false;

            this.BtnDepartMentAdd.Text = "配属追加";

            this.BtnDepartMentAdd.UseVisualStyleBackColor = false;

            this.BtnDepartMentAdd.Click += new System.EventHandler(this.BtnDepartMentAdd_Click);

            // 

            // BtnDepartMentDel

            // 

            this.BtnDepartMentDel.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 

            | System.Windows.Forms.AnchorStyles.Left) 

            | System.Windows.Forms.AnchorStyles.Right)));

            this.BtnDepartMentDel.BackColor = System.Drawing.Color.Red;

            this.BtnDepartMentDel.Font = new System.Drawing.Font("ＭＳ 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.BtnDepartMentDel.ForeColor = System.Drawing.Color.White;

            this.BtnDepartMentDel.Location = new System.Drawing.Point(438, 393);

            this.BtnDepartMentDel.Name = "BtnDepartMentDel";

            this.BtnDepartMentDel.Size = new System.Drawing.Size(139, 29);

            this.BtnDepartMentDel.TabIndex = 33;

            this.BtnDepartMentDel.TabStop = false;

            this.BtnDepartMentDel.Text = "配属履歴削除";

            this.BtnDepartMentDel.UseVisualStyleBackColor = false;

            this.BtnDepartMentDel.Click += new System.EventHandler(this.BtnDepartMentDel_Click);

            // 

            // txtInput13

            // 

            this.txtInput13.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.txtInput13.ImeMode = System.Windows.Forms.ImeMode.Disable;

            this.txtInput13.Location = new System.Drawing.Point(148, 396);

            this.txtInput13.MaxLength = 11;

            this.txtInput13.Name = "txtInput13";

            this.txtInput13.Size = new System.Drawing.Size(139, 23);

            this.txtInput13.TabIndex = 9;

            this.txtInput13.TextChanged += new System.EventHandler(this.txtInput_TextChanged);

            this.txtInput13.Validated += new System.EventHandler(this.txtInput_Validated);

            // 

            // label24

            // 

            this.label24.Anchor = System.Windows.Forms.AnchorStyles.Left;

            this.label24.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(128)))));

            this.label24.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label24.ForeColor = System.Drawing.Color.Black;

            this.label24.Location = new System.Drawing.Point(3, 395);

            this.label24.Name = "label24";

            this.label24.Size = new System.Drawing.Size(139, 25);

            this.label24.TabIndex = 30;

            this.label24.Text = "配属年月日";

            this.label24.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // lblSecurtyManegement

            // 

            this.lblSecurtyManegement.BackColor = System.Drawing.Color.White;

            this.lblSecurtyManegement.Location = new System.Drawing.Point(1127, 4);

            this.lblSecurtyManegement.Name = "lblSecurtyManegement";

            this.lblSecurtyManegement.Size = new System.Drawing.Size(83, 26);

            this.lblSecurtyManegement.TabIndex = 19;

            this.lblSecurtyManegement.Visible = false;

            // 

            // rdbMode2

            // 

            this.rdbMode2.AutoSize = true;

            this.rdbMode2.Location = new System.Drawing.Point(234, 5);

            this.rdbMode2.Name = "rdbMode2";

            this.rdbMode2.Size = new System.Drawing.Size(94, 20);

            this.rdbMode2.TabIndex = 21;

            this.rdbMode2.Text = "削除一覧";

            this.rdbMode2.UseVisualStyleBackColor = true;

            this.rdbMode2.CheckedChanged += new System.EventHandler(this.rdbMode_CheckedChanged);

            // 

            // rdbMode1

            // 

            this.rdbMode1.AutoSize = true;

            this.rdbMode1.Checked = true;

            this.rdbMode1.Location = new System.Drawing.Point(132, 5);