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

        #endregion

        /// 部署引継色

        /// </summary>

        public static Color s_SuccessionBackColor = Color.LightSkyBlue;

        public static Color s_SuccessionForeColor = Color.LightYellow;

        /// <summary>

        /// 担当割当色

        /// </summary>

        public static Color s_AssignBackColor = Color.LightBlue;

        public static Color s_AssignForeColor = Color.LightYellow;

        /// <summary>

        //public static int s_PresidentsOffice = 7;

        #region 起動不許可時メッセージ

        /// <summary>

        /// 起動不許可時メッセージ

        /// </summary>

        private const string s_NotExecuteMessage = "選択された処理の起動権限が設定されていません。";

        private const string s_NotExecuteTitile = "起動権限確認";

        #endregion

                        MessageBox.Show(s_NotExecuteMessage, s_NotExecuteTitile, MessageBoxButtons.OK, MessageBoxIcon.Stop);

                            // 一覧の次処理の起動チェック

                            int NextProcNo = m_ProcControlPara[NowPoint].IntExecParameter[0];

                            if (!ClsSecurityPermission.GetExecutePermission(NextProcNo, ref m_EditFlg))

                            {

                                MessageBox.Show(s_NotExecuteMessage, s_NotExecuteTitile, MessageBoxButtons.OK, MessageBoxIcon.Stop);

                                BackProcess();

                                break;

                            }

        ///// <summary>

        ///// 総務部の対象プロセスへの起動許可判定

        ///// </summary>

        ///// <param name="ProcessNo"></param>

        ///// <returns></returns>

        //public static bool PermitGeneralAffairsDevision(int ProcessNo)

        //{

        //    try

        //    {

        //        bool bReturn = false;

        //        if (CommonMotions.LoginUserSecurity.GeneralAffairs != (int)SecurityMaster.GeneAffDef.GeneralDep) return false;

        //        switch (ProcessNo)

        //        {

        //            case (int)ClsExcute.ProcessExecuteNo.ConstructionBaseInfo:  //  2:工事情報入力

        //            case (int)ClsExcute.ProcessExecuteNo.ConstructionBudget:    //  6:工事予算書入力

        //            case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:    // 10:注文書印刷

        //            case (int)ClsExcute.ProcessExecuteNo.ConstructionLedger:    // 13:工事詳細台帳

        //                bReturn = true;

        //                break;

        //            default:

        //                bReturn = false;

        //                break;

        //        }

        //        return bReturn;

        //    }

        //    catch (Exception ex)

        //    {

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

        //        return false;

        //    }

        //}

        #region 定数

        #region 下位項目フラグ定義

        /// <summary>

        /// 下位項目フラグ定義

        /// </summary>

        public enum SubitemsFlgDef

        {

            /// <summary>

            /// 0:下位項目無

            /// </summary>

            NoneData = 0,

            /// <summary>

            /// 1:下位項目有

            /// </summary>

            ExistsData

        }

        #endregion

        #region 直接入力フラグ

        /// <summary>

        /// 直接入力フラグ

        /// </summary>

        public enum DirectInputFlgDef

        {

            /// <summary>

            /// 0:直接入力不許可

            /// </summary>

            NoneInput = 0,

            /// <summary>

            /// 1:直接入力許可

            /// </summary>

            DirectInput,

        }

        #endregion

        #region 自社経費フラグ

        /// <summary>

        /// 自社経費フラグ

        /// </summary>

        public enum MyExpensesFlgDef

        {

            /// <summary>

            /// 0:施工費

            /// </summary>

            ConstrCost = 0,

            /// <summary>

            /// 1:経費

            /// </summary>

            Expenses,

        }

        #endregion

        #endregion

            // ???????????C?A?E?g???

            InitDispLayout();

                // ----- 申請レコード更新

                // 承認以外は以下を処理しない

                if (statusCode != (int)CommonDefine.ApprovalStatus.Approval) return true;

                // ----- 承認

                // 案件に対して最終承認がされているかを確認する

                if (!ClsCommonApproval.CheckProcessApprovalFinal(m_ConstructionCode, m_ApprovalCode, m_OrderNo)) return true;

                // 最終承認がされていれば申請レコードを承認へ変更する

                if (!ClsCommonApproval.SetPrimaryRecStatus(m_ConstructionCode,

                                                                m_ApprovalCode,

                                                                m_OrderNo,

                                                                statusCode)) return false;

                // 承認完了後に処理があるものは処理する

                ApprovalNextProcess();

        #region 初期時画面レイアウト設定

        /// <summary>

        /// 初期時画面レイアウト設定

        /// </summary>

        private void InitDispLayout()

        {

            try

            {

                label14.Text = CommonMotions.GetYearTitle();

                label19.Text = CommonMotions.GetYearTitle(false).Replace("度", "");

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

                if (CommonMotions.BasePeriodYear())

                {

                    m_dispLabelControl[(int)DispHeader.ConstrPeriod].Text = string.Format("{0}", m_ConstrBaseRec.ConstructionPeriod);

                }

                else

                {

                    m_dispLabelControl[(int)DispHeader.ConstrPeriod].Text = string.Format("{0}", m_ConstrBaseRec.ConstructionYear);

                }

                if (CommonMotions.BasePeriodYear())

                {

                    for (int i = 0; i < s_SQLPart5.Length; i++) wrkFormat.Append(s_SQLPart5[i]);

                }

                else

                {

                    for (int i = 0; i < s_SQLPart5.Length; i++) wrkFormat.Append(s_SQLPart5_1[i]);

                }

            this.cmbConstructionYear.Size = new System.Drawing.Size(115, 24);

                data.MessageColor = String.Format("0x{0:X2}{1:X2}{2:X2}", CommonDefine.s_SuccessionForeColor.R

                                                                        , CommonDefine.s_SuccessionForeColor.G

                                                                        , CommonDefine.s_SuccessionForeColor.B);

                data.BackColor = String.Format("0x{0:X2}{1:X2}{2:X2}", CommonDefine.s_SuccessionBackColor.R

                                                                        , CommonDefine.s_SuccessionBackColor.G

                                                                        , CommonDefine.s_SuccessionBackColor.B);

                data.MessageColor = String.Format("0x{0:X2}{1:X2}{2:X2}", CommonDefine.s_AssignForeColor.R

                                                                        , CommonDefine.s_AssignForeColor.G

                                                                        , CommonDefine.s_AssignForeColor.B);

                data.BackColor = String.Format("0x{0:X2}{1:X2}{2:X2}", CommonDefine.s_AssignBackColor.R

                                                                        , CommonDefine.s_AssignBackColor.G

                                                                        , CommonDefine.s_AssignBackColor.B);

                TextBox txtRevComp = (TextBox)m_DspCtrl[(int)DspCnt.RevCompleteDate];

                if (txtRevComp.Text.Length < 1 || txtRevComp.Text.Equals(CommonDefine.s_UndecidedString))

                    txtRevComp.Enabled = true;

                TextBox txtBillComp = (TextBox)m_DspCtrl[(int)DspCnt.BillingComplateDate];

                if (txtBillComp.Text.Length < 1 || txtBillComp.Text.Equals(CommonDefine.s_UndecidedString))

                    txtBillComp.Enabled = true;

                // ----- ?V?X?e?????l????I??

                // ?????E?N?x????I??

                if (CommonMotions.BasePeriodYear())

                {

                    label28.Visible = true;

                    cmbConstructionPeriod.Visible = true;

                    label2.Visible = false;

                    cmbConstructionYear.Visible = false;

                }

                else

                {

                    label28.Visible = false;

                    cmbConstructionPeriod.Visible = false;

                    label2.Visible = true;

                    cmbConstructionYear.Visible = true;

                    label2.Location = label28.Location;

                    cmbConstructionYear.Location = cmbConstructionPeriod.Location;

                }

                if (CommonMotions.LoginUserSecurity.GeneralAffairs == (int)SecurityMaster.GeneAffDef.GeneralDep)

                        if (wrkRec.DirectInputFlg == (int)ComponentMaster.DirectInputFlgDef.DirectInput) InputFlg = true;

                        if (wrkRec.SubitemsFlg == (int)ComponentMaster.SubitemsFlgDef.NoneData)

                    if (CompList[iy].SubitemsFlg == (int)ComponentMaster.SubitemsFlgDef.NoneData) iInputFlg = 1;

                    if (CompList[iy].DirectInputFlg == (int)ComponentMaster.DirectInputFlgDef.DirectInput) iInputFlg = 1;

                strSQL.Append("SELECT");

                strSQL.Append(" A.*");

                strSQL.Append(", B.CNT");

                strSQL.Append(", B.COMPONENTCODE");

                strSQL.Append(" FROM");

                strSQL.Append(" ESTIMATEDATABODY A");

                strSQL.Append(" LEFT JOIN(SELECT");

                strSQL.Append("                BBB.CONSTRUCTIONCODE");

                strSQL.Append("              , BBB.COMPONENTCODE");

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

                strSQL.Append("           FROM ESTIMATEDATABODY BBB");

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

                strSQL.Append("           GROUP BY BBB.COMPONENTCODE) AS B");

                strSQL.Append(" On B.CONSTRUCTIONCODE = A.ConstructionCode");

                strSQL.Append(" And B.COMPONENTCODE = A.COMPONENTCODE");

                if (CommonMotions.LoginUserSecurity.GeneralAffairs == (int)SecurityMaster.GeneAffDef.GeneralDep)

                // 今は15回まででお茶を濁す

                if (m_nMaxOrderNo > 14)

                {

                    MessageBox.Show("請求回数は15回までです。"

                                        , "請求回数エラー"

                                        , MessageBoxButtons.OK

                                        , MessageBoxIcon.Error);

                    return;

                }

                    if (ShowMessageBox("データが保存されます。よろしいですか？"

                                        , "保存確認"

                                        , MessageBoxButtons.YesNo

                                        , MessageBoxIcon.Information) == DialogResult.No)

                    if (work.SubitemsFlg == (int)ComponentMaster.SubitemsFlgDef.NoneData) { sflg = "無"; }

                    else { sflg = "有"; }

                    if (work.DirectInputFlg == (int)ComponentMaster.DirectInputFlgDef.NoneInput) { dflg = "不許可"; }

                    else { dflg = "許可"; }

                    if (work.MyExpensesFlg == (int)ComponentMaster.MyExpensesFlgDef.ConstrCost) { lflg = "施工費"; }

                    else { lflg = "経費"; }

                strSql.Append("SELECT * From componentmaster As A");

                strSql.Append(" Left Join(Select");

                strSql.Append("            BB.ComponentCode");

                strSql.Append("          , Count(*) As LinkCount");

                strSql.Append("           From componentlinkmaster As BB");

                strSql.Append("           Group By BB.ComponentCode) As B");

                strSql.Append(" On B.ComponentCode = A.ComponentCode");

                strSql.AppendFormat(" Where A.DeleteFlg = {0}", (int)CommonDefine.DataRowDeleteDef.Exists);

                strSql.Append(" Order By A.DisplayOrder ASC");

                ArrayList wrk = new ArrayList();

                if (!sbDB.ExecuteReader(strSql.ToString(), ref wrk)) return false;

                int DataCnt = Enum.GetNames(typeof(IOMComponent.NameColumn)).Length;

                ComponentMaster work = new ComponentMaster();

                foreach (object[] objWrk in wrk)

                    sbDB.Reader2Struct(objWrk, ref work);

                    if (work.SubitemsFlg == (int)ComponentMaster.SubitemsFlgDef.NoneData) { sflg = "無"; }

                    else { sflg = "有"; }

                    if (work.DirectInputFlg == (int)ComponentMaster.DirectInputFlgDef.NoneInput) { dflg = "不許可"; }

                    else { dflg = "許可"; }

                    if (work.MyExpensesFlg == (int)ComponentMaster.MyExpensesFlgDef.ConstrCost) { lflg = "施工費"; }

                    else { lflg = "経費"; }

                    int Rowcnt = dgvComponentList.Rows.Add((ino++)

                    // ----- 設定エラーを色で返す

                    bool bErrsubItems = false;

                    int nCout = CommonMotions.cnvInt(objWrk[DataCnt + 1]);

                    if (work.SubitemsFlg == (int)ComponentMaster.SubitemsFlgDef.ExistsData)

                    {

                        // 下位項目有で中項目の設定が無い

                        if (nCout < 1) bErrsubItems = true;

                    }

                    else if (work.SubitemsFlg == (int)ComponentMaster.SubitemsFlgDef.NoneData)

                    {

                        // 下位項目無で中項目の設定が有る

                        if (nCout > 0) bErrsubItems = true;

                    }

                    if (bErrsubItems)

                    {

                        dgvComponentList.Rows[Rowcnt].Cells[(int)DispColumn.subItems].Style.BackColor = Color.Yellow;

                    }

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

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

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

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

            ((System.ComponentModel.ISupportInitialize)(this.dgvItemList)).BeginInit();

            // dgvItemList

            // 

            this.dgvItemList.AllowUserToAddRows = false;

            this.dgvItemList.AllowUserToDeleteRows = false;

            this.dgvItemList.AllowUserToResizeColumns = false;

            this.dgvItemList.AllowUserToResizeRows = false;

            this.dgvItemList.BackgroundColor = System.Drawing.Color.White;

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

            dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Control;

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

            dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText;

            dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;

            dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;

            dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True;

            this.dgvItemList.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;

            this.dgvItemList.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;

            this.dgvItemList.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.dataGridViewTextBoxColumn1,

            this.dataGridViewTextBoxColumn3,

            this.dataGridViewTextBoxColumn4});

            this.dgvItemList.EditMode = System.Windows.Forms.DataGridViewEditMode.EditProgrammatically;

            this.dgvItemList.EnableHeadersVisualStyles = false;

            this.dgvItemList.Location = new System.Drawing.Point(13, 3);

            this.dgvItemList.Name = "dgvItemList";

            this.dgvItemList.RowHeadersWidth = 20;

            this.dgvItemList.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;

            this.dgvItemList.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;

            this.dgvItemList.Size = new System.Drawing.Size(540, 510);

            this.dgvItemList.TabIndex = 52;

            // 

            // dataGridViewTextBoxColumn1

            // 

            this.dataGridViewTextBoxColumn1.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;

            dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;

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

            dataGridViewCellStyle2.ForeColor = System.Drawing.Color.Black;

            this.dataGridViewTextBoxColumn1.DefaultCellStyle = dataGridViewCellStyle2;

            this.dataGridViewTextBoxColumn1.Frozen = true;

            this.dataGridViewTextBoxColumn1.HeaderText = "№";

            this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1";

            this.dataGridViewTextBoxColumn1.ReadOnly = true;

            this.dataGridViewTextBoxColumn1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.dataGridViewTextBoxColumn1.Width = 60;

            // 

            // dataGridViewTextBoxColumn3

            // 

            this.dataGridViewTextBoxColumn3.Frozen = true;

            this.dataGridViewTextBoxColumn3.HeaderText = "工種キー";

            this.dataGridViewTextBoxColumn3.Name = "dataGridViewTextBoxColumn3";

            this.dataGridViewTextBoxColumn3.Resizable = System.Windows.Forms.DataGridViewTriState.False;

            this.dataGridViewTextBoxColumn3.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.dataGridViewTextBoxColumn3.Visible = false;

            // 

            // dataGridViewTextBoxColumn4

            // 

            dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;

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

            dataGridViewCellStyle3.ForeColor = System.Drawing.Color.Black;

            this.dataGridViewTextBoxColumn4.DefaultCellStyle = dataGridViewCellStyle3;

            this.dataGridViewTextBoxColumn4.Frozen = true;

            this.dataGridViewTextBoxColumn4.HeaderText = "中項目名称";

            this.dataGridViewTextBoxColumn4.MaxInputLength = 50;

            this.dataGridViewTextBoxColumn4.Name = "dataGridViewTextBoxColumn4";

            this.dataGridViewTextBoxColumn4.ReadOnly = true;

            this.dataGridViewTextBoxColumn4.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.dataGridViewTextBoxColumn4.Width = 440;

            // 

            this.Controls.Add(this.dgvComponentList);

            ((System.ComponentModel.ISupportInitialize)(this.dgvItemList)).EndInit();

            // Normalサイズ設定

            OrignalSizeSet();

                int DspCtrlCnt = Enum.GetNames(typeof(GridColumn)).Length;

                if (dgv.CurrentCell.ColumnIndex <= (DspCtrlCnt + 1)) return;

                int DspCtrlCnt = Enum.GetNames(typeof(GridColumn)).Length;

                if (dgv.CurrentCell.ColumnIndex < DspCtrlCnt) return;

                // 最後尾は処理しない

                if ((dgv.ColumnCount - 2) <= dgv.CurrentCell.ColumnIndex) return;

                // 画面初期データセット

                DisplayDataLoad();

                // サブフォームハンドルリスト初期化

                InitSubFormHandleList();

                // 初期化フラグOFF

                m_bInitFlg = false;

                if (CommonMotions.LoginUserSecurity.GeneralAffairs == (int)SecurityMaster.GeneAffDef.GeneralDep) bExecFlg = true;

                // 使用しないボタンを消す

                ButtonControlVisibleSet(tblLayoutOrder.Controls);

                int Normal = (int)CommonDefine.SecurityRankPos.NormalAuthority;             // 担当のみ

                int Limited = (int)CommonDefine.SecurityRankPos.LimitedAuthority;           // 所属長

                btnOrder0300.Visible = true;

                btnOrder0301.Visible = true;

                // 結合・分割は上位2クラスのみ使える

                if (CommonMotions.LoginUserSecurity.SecRank == CommonDefine.SecurityRankList[Normal].Key

                    || CommonMotions.LoginUserSecurity.SecRank == CommonDefine.SecurityRankList[Limited].Key)

                    btnOrder0300.Visible = false;

                    btnOrder0301.Visible = false;

                // ----- 使用ボタンはすべて表示する

                //int editflg = 0;

                //int RowFalseCnt = 0;

                //string strButtonName = string.Empty;

                //bool bDsp = true;

                //for (int iy = 0; iy < OrderMenuButton.GetLength(0); iy++)

                //{

                //    RowFalseCnt = 0;

                //    for (int ix = 0; ix < OrderMenuButton.GetLength(1); ix++)

                //    {

                //        // ボタンをさがす。

                //        strButtonName = string.Format("{0}{1}{2}", s_btnOrder, iy.ToString("00"), ix.ToString("00"));

                //        Control[] findCtrl = this.Controls.Find(strButtonName, true);

                //        // ボタンが無ければ処理しない

                //        if (findCtrl.Length < 1) continue;

                //        if (ClsSecurityPermission.GetExecutePermission(OrderMenuButton[iy, ix], ref editflg))

                //        {

                //            // ボタンが見つかれば、表示を変更する

                //            bDsp = true;

                //        }

                //        else

                //        {

                //            // ボタンが見つかれば、表示を変更する

                //            bDsp = false;

                //            RowFalseCnt++;

                //        }

                //        // ボタンが見つかれば、表示を変更する

                //        ((Button)findCtrl[0]).Visible = bDsp;

                //    }

                //}

                strSQL.Append(", B.TOCODE");

                strSQL.Append(" INNER JOIN MESSAGEBOARDTERGET B");

                strSQL.Append("        ON B.RECORDNUMBER = A.RECORDNUMBER");

                strSQL.Append("        AND B.BRANCHNUMBER = A.BRANCHNUMBER");

                switch (exeflg)

                {

                    case (int)TabNameEnum.MessageBoard:

                        // 掲示板データ

                        strSQL.Append(" DATE(A.WritingDate) > DATE(DATE_ADD(NOW(), INTERVAL - 1 MONTH))");

                        strSQL.AppendFormat(" And A.MessageFlag = {0}", (int)MessageBoardData.MessageFlgDef.Normal);

                        DispMessageSelect(exeflg, ref strSQL);

                        strSQL.Append(" Order By");

                        strSQL.Append(" A.RecordNumber Desc");

                        strSQL.Append(", A.BranchNumber Asc");

                        strSQL.Append(", B.SeqNum ASC");

                        break;

                    case (int)TabNameEnum.BusinessMessage:

                        // 秘書からの連絡

                        strSQL.Append(" DATE(A.WritingDate) > DATE(DATE_ADD(NOW(), INTERVAL - 10 DAY))");

                        strSQL.AppendFormat(" And A.MessageFlag = {0}", (int)MessageBoardData.MessageFlgDef.Secretary);

                        DispMessageSelect(exeflg, ref strSQL);

                        strSQL.Append(" Order By");

                        strSQL.Append(" A.WritingDate Desc");

                        strSQL.Append(", A.MessageTitile Asc");

                        strSQL.Append(", B.SeqNum ASC");

                        break;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 秘書からの連絡の表示範囲を設定するＳＱＬ作成

        /// <summary>

        /// 秘書からの連絡の表示範囲を設定するＳＱＬ作成

        /// </summary>

        private void DispMessageSelect(int exeflg, ref StringBuilder strSQL)

        {

            try

            {

                // キー値取得

                int AllPath = (int)CommonDefine.SecurityRangePos.AllPath;           // 全部署

                int Multiple = (int)CommonDefine.SecurityRangePos.Multiple;         // 複数部署

                int Only = (int)CommonDefine.SecurityRangePos.Only;                 // 自部署のみ

                int None = (int)CommonDefine.SecurityRangePos.None;                 // 自担当者のみ

                // データアクセスに権限により制限がある

                if (CommonMotions.LoginUserData.PersonCode == CommonDefine.AdminCode

                || CommonMotions.LoginUserSecurity.SecRange == CommonDefine.SecurityRangeList[AllPath].Key)

                    // すべて対象（制限SQL無）

                else if (CommonMotions.LoginUserSecurity.SecRange == CommonDefine.SecurityRangeList[Multiple].Key

                        || CommonMotions.LoginUserSecurity.SecRange == CommonDefine.SecurityRangeList[Only].Key)

                {

                    // 一部制限有

                    strSQL.Append(" And (");

                    // 機密管理者（自部署のみ）

                    switch (exeflg)

                    {

                        case (int)TabNameEnum.MessageBoard:

                            // 掲示板データ

                            strSQL.AppendFormat(" (A.FromCode = {0})", CommonMotions.LoginUserData.PersonCode);

                            strSQL.Append(" Or (A.RecordNumber IN(Select B1.RecordNumber From MESSAGEBOARDTERGET As B1");

                            strSQL.AppendFormat("                  Where B1.ToCode = {0}))", CommonDefine.s_AllMembersCode);

                            strSQL.Append(" Or (A.RecordNumber IN(Select B2.RecordNumber From MESSAGEBOARDTERGET As B2");

                            strSQL.AppendFormat("                  Where B2.ToCode = {0}))", CommonMotions.LoginUserData.PersonCode);

                            strSQL.Append(" Or (A.RecordNumber IN(Select B3.RecordNumber From MESSAGEBOARDTERGET As B3");

                            strSQL.Append("                        Where B3.ToCode In (Select A2.PersonCode From PERSONDEPARTMENTMASTER As A1");

                            strSQL.AppendFormat("                                     Inner Join  personinchargemaster As A2");

                            strSQL.Append("                                                On A2.DepartmentCode = A1.DepartmentCode");

                            strSQL.AppendFormat("                                     Where A1.PersonCode = {0})))", CommonMotions.LoginUserData.PersonCode);

                            strSQL.Append(" Or (A.RecordNumber IN(Select B4.RecordNumber From MESSAGEBOARDTERGET As B4");

                            strSQL.Append("                        Where B4.ToCode In (Select A3.DepartmentCode From PERSONDEPARTMENTMASTER As A3");

                            strSQL.AppendFormat("                                    Where A3.PersonCode = {0})))", CommonMotions.LoginUserData.PersonCode);

                            break;

                        case (int)TabNameEnum.BusinessMessage:

                            // 秘書からの連絡

                            strSQL.AppendFormat("(B.ToCode = {0})", CommonMotions.LoginUserData.PersonCode);

                            strSQL.Append(" Or (B.ToCode In (Select A1.PersonCode From personinchargemaster As A1");

                            strSQL.AppendFormat("                 Inner Join PERSONDEPARTMENTMASTER As A2");

                            strSQL.Append("                       On A2.DepartmentCode = A1.DepartmentCode");

                            strSQL.AppendFormat("            Where A2.PersonCode = {0}))", CommonMotions.LoginUserData.PersonCode);

                            break;

                    }

                    strSQL.Append(")");

                else if (CommonMotions.LoginUserSecurity.SecRange == CommonDefine.SecurityRangeList[None].Key)

                {

                    strSQL.Append(" And (");

                    switch (exeflg)

                    {

                        case (int)TabNameEnum.MessageBoard:

                            // 掲示板データ

                            strSQL.AppendFormat(" (A.FromCode = {0})", CommonMotions.LoginUserData.PersonCode);

                            strSQL.Append(" Or (A.RecordNumber IN(Select B1.RecordNumber From MESSAGEBOARDTERGET As B1");

                            strSQL.AppendFormat("                  Where B1.ToCode = {0}))", CommonDefine.s_AllMembersCode);

                            strSQL.Append(" Or (A.RecordNumber IN(Select B2.RecordNumber From MESSAGEBOARDTERGET As B2");

                            strSQL.AppendFormat("                  Where B2.ToCode = {0}))", CommonMotions.LoginUserData.PersonCode);

                            strSQL.Append(" Or (A.RecordNumber IN(Select B3.RecordNumber From MESSAGEBOARDTERGET As B3");

                            strSQL.AppendFormat("                  Where B3.ToCode = {0}))", CommonMotions.LoginUserData.DepartmentCode);

                            break;

                        case (int)TabNameEnum.BusinessMessage:

                            // 秘書からの連絡

                            strSQL.AppendFormat(" (B.ToCode = {0})", CommonMotions.LoginUserData.PersonCode);

                            break;

                    }

                    strSQL.Append(")");

                }

                int None = (int)CommonDefine.SecurityRangePos.None;                 // 自担当者のみ

                // 部署引継色を文字列で取得

                string cBackColor = String.Format("0x{0:X2}{1:X2}{2:X2}", CommonDefine.s_SuccessionBackColor.R

                                                        , CommonDefine.s_SuccessionBackColor.G

                                                        , CommonDefine.s_SuccessionBackColor.B);

                List<int> TergetCode = new List<int>();

                        TergetCode.Add(CommonMotions.cnvInt(DataRec[ToNameCnt + 1]));

                    // 掲示板の場合、部署引継データで自分に関係がないデータは担当者に表示しない

                    if (exeflg == (int)TabNameEnum.MessageBoard

                        && wrkRow.LinkType == (int)MessageBoardData.LinkTypeDef.ConstructionInfo

                        && CommonMotions.LoginUserSecurity.SecRange == CommonDefine.SecurityRangeList[None].Key)

                    {

                        // 部署引継を色で判定する

                        if (wrkRow.BackColor.Equals(cBackColor))

                        {

                            bool bMatch = false;

                            foreach (int CurCode in TergetCode)

                            {

                                if (CurCode == CommonMotions.LoginUserData.PersonCode)

                                {

                                    bMatch = true;

                                    break;

                                }

                            }

                            // 書込み者がログイン者

                            if (wrkRow.FromCode == CommonMotions.LoginUserData.PersonCode) bMatch = true;

                            // 表示しない

                            if (!bMatch) goto AfterSet;

                        }

                    }

                AfterSet:

                    TergetCode.Clear();

                    TergetCode.Add(CommonMotions.cnvInt(DataRec[ToNameCnt+1]));

[assembly: AssemblyVersion("1.0.0.0")]

[assembly: AssemblyFileVersion("1.0.1.0")]