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

        private static List<PersonDepartmentMaster> m_LoginUserRefDepartment = new List<PersonDepartmentMaster>();

        public static List<PersonDepartmentMaster> LoginUserRefDepartment

            get { return m_LoginUserRefDepartment; }

            set { m_LoginUserRefDepartment = value; }

        public static int s_SystemVersion = 134;

                // 読込み時のチェック

                MacthFlg = MessageReadPermission(RecoadNo, BuranchNo);

                if (bRead) return MacthFlg;

                MacthFlg = MessageNewEditPermission(RecoadNo, BuranchNo);

                    foreach (PersonDepartmentMaster wrkRec in CommonMotions.LoginUserRefDepartment)

            SecRank,

            FromCode

        public static bool MessageReadPermission(int RecoadNo, int BuranchNo)

                    ArrayList TargetList = new ArrayList();

                    /// 読込ターゲット取得

                    if (!GetReadTarget(mbtDB, RecoadNo, BuranchNo, ref TargetList)) return false;

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

                    bool bProtect = false;

                    for (int i = 0; i < TargetList.Count; i++)

                        object[] objRec = (object[])TargetList[i];

                        if (i == 0)

                        {

                            // ロック判定部署か？

                            bProtect = DecideLockData(CommonMotions.cnvInt(objRec[TergetCnt + (int)GetTarget.FromCode]));

                        }

                            // 所属部署が対象ならばOK

                            // ランク無は最大値をセット

                        if (!bProtect)

                            // ログイン者が所属長の場合は対象者の所属部署を参照部署と比較

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

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

                                // 参照部署にあるかのチェック

                                foreach (PersonDepartmentMaster RefDepRec in CommonMotions.LoginUserRefDepartment)

                                    if (DepCode == RefDepRec.DepartmentCode)

                                    {

                                        if (wrkRec.ToCode < 99999)

                                        {

                                            return true;

                                        }

                                        else

                                        {

                                            // 書込み者が自分より上位者では無い場合は読み込める

                                            if (CommonMotions.LoginUserSecurity.SecRank <= CurRecRank) return true;

                                        }

                                    }

        #region 読込ターゲット取得

        /// <summary>

        /// 読込ターゲット取得

        /// </summary>

        private static bool GetReadTarget(IOMessageBoardTerget mbtDB, int RecoadNo, int BuranchNo, ref ArrayList TargetList)

        {

            try

            {

                    // 掲示板閲覧テーブルのチェック

                    StringBuilder strSQL = new StringBuilder();

                    strSQL.Append("SELECT");

                    strSQL.Append(" A.RecordNumber");

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

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

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

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

                    strSQL.Append(", DATE_FORMAT(A.EntryDate, '%Y/%m/%d %H:%i:%s')");

                    strSQL.Append(", DATE_FORMAT(A.UpdateDate, '%Y/%m/%d %H:%i:%s')");

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

                    strSQL.Append(", C.DEPARTMENTCODE");

                    strSQL.Append(", D.SECRANK");

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

                    strSQL.Append(" FROM MESSAGEBOARDTERGET A");

                    strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER C");

                    strSQL.Append("   ON C.PERSONCODE = A.TOCODE");

                    strSQL.Append(" LEFT JOIN SECURITYMASTER D");

                    strSQL.Append("   ON D.SECCODE = C.SECCODE");

                    strSQL.Append(", MESSAGEBOARDDATA B");

                    strSQL.AppendFormat(" WHERE A.RECORDNUMBER = {0}", RecoadNo);

                    strSQL.AppendFormat(" AND A.BRANCHNUMBER = {0}", BuranchNo);

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

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

                    if (!mbtDB.ExecuteReader(strSQL.ToString(), ref TargetList)) return false;

                    return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 最上位部署ロック判定

        /// <summary>

        /// 最上位部署ロック判定

        /// </summary>

        private static bool DecideLockData(int nFromCode)

        {

            IOMSecurity SecDB = new IOMSecurity();

            try

            {

                int SRank = (int)CommonDefine.SecurityRankPos.SpecialAuthority;   // 経営者アクセス

                int nRankCode = CommonDefine.SecurityRankList[SRank].Key;

                StringBuilder strSQL = new StringBuilder();

                if (nFromCode < 99999)

                {   // ----- 対象者コードが5桁未満ならば部署コード

                    // 部署内の最大セキュリティ区分を取得する

                    strSQL.Append("SELECT");

                    strSQL.Append(" MIN(B.SECRANK)");

                    strSQL.Append(" FROM");

                    strSQL.Append(" PERSONINCHARGEMASTER A");

                    strSQL.Append(", SECURITYMASTER B");

                    strSQL.AppendFormat(" WHERE A.DEPARTMENTCODE = {0}", nFromCode);

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

                }

                else

                {   // ----- 対象者コードが5桁以上ならば担当者コード

                    // 担当者のセキュリティ区分を取得する

                    strSQL.Append("SELECT");

                    strSQL.Append(" B.SECRANK");

                    strSQL.Append(" FROM");

                    strSQL.Append(" PERSONINCHARGEMASTER A");

                    strSQL.Append(", SECURITYMASTER B");

                    strSQL.AppendFormat(" WHERE A.PERSONCODE = {0}", nFromCode);

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

                }

                ArrayList arData = new ArrayList();

                if (!SecDB.ExecuteReader(strSQL.ToString(), ref arData)) return false;

                if (arData.Count < 1) return false;

                object[] objRec = (object[])arData[0];

                bool bRet = false;

                if (nRankCode == CommonMotions.cnvInt(objRec[0])) bRet = true;

                return bRet;

            }

            catch (Exception ex)

            {

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

                return false;

            }

            finally

            {

                SecDB.close(); SecDB = null;

            }

        }

        #endregion

                    foreach (PersonDepartmentMaster wrkRec in CommonMotions.LoginUserRefDepartment)

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();

            this.lblCellTotal = new System.Windows.Forms.Label();

            this.lblReqSumType03 = new System.Windows.Forms.Label();

            this.panel2.Controls.Add(this.dgvAllDisplay);

            this.panel2.Size = new System.Drawing.Size(1290, 450);

            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.dgvAllDisplay.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;

            this.dgvAllDisplay.Size = new System.Drawing.Size(1278, 442);

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

            this.Column1.DefaultCellStyle = dataGridViewCellStyle2;

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

            this.Column5.DefaultCellStyle = dataGridViewCellStyle3;

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

            this.Column6.DefaultCellStyle = dataGridViewCellStyle4;

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

            dataGridViewCellStyle5.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(255)))));

            dataGridViewCellStyle5.Format = "N0";

            dataGridViewCellStyle5.NullValue = null;

            this.Column7.DefaultCellStyle = dataGridViewCellStyle5;

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

            dataGridViewCellStyle6.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(224)))), ((int)(((byte)(192)))));

            this.Column12.DefaultCellStyle = dataGridViewCellStyle6;

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

            this.Column9.DefaultCellStyle = dataGridViewCellStyle7;

            // lblCellTotal

            // 

            this.lblCellTotal.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));

            this.lblCellTotal.AutoSize = true;

            this.lblCellTotal.BackColor = System.Drawing.Color.WhiteSmoke;

            this.lblCellTotal.Font = new System.Drawing.Font("ＭＳ Ｐ明朝", 9.75F, System.Drawing.FontStyle.Bold);

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

            this.lblCellTotal.Location = new System.Drawing.Point(100, 430);

            this.lblCellTotal.Name = "lblCellTotal";

            this.lblCellTotal.Size = new System.Drawing.Size(0, 13);

            this.lblCellTotal.TabIndex = 36;

            // 

            // lblReqSumType03

            // 

            this.lblReqSumType03.BackColor = System.Drawing.Color.LightGray;

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

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

            this.lblReqSumType03.Location = new System.Drawing.Point(218, 4);

            this.lblReqSumType03.Name = "lblReqSumType03";

            this.lblReqSumType03.Size = new System.Drawing.Size(100, 20);

            this.lblReqSumType03.TabIndex = 1;

            this.lblReqSumType03.Text = "対 象 外";

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

            // 

            this.Controls.Add(this.button2);

            this.Controls.Add(this.button1);

            this.Controls.Add(this.btnDispDown);

            this.Controls.Add(this.btnDispUp);

  <metadata name="lblCellTotal.Locked" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

    <value>True</value>

  </metadata>

                if (!m_ReqSumFlag) return;

                // フォームスタイルセット

                this.BackColor = SystemColors.ControlLightLight;

                int nWDiff = panel2.Width - dgv.Width;

                panel2.Width = panel1.Width;

                dgv.Width = (panel2.Width - nWDiff);

                foreach( PersonDepartmentMaster Prsn in CommonMotions.LoginUserRefDepartment)

                int nConstrCode = CommonMotions.cnvInt(CurRow.Cells[m_Genba_Column].Value);

                    foreach (PersonDepartmentMaster RefDepRec in CommonMotions.LoginUserRefDepartment)

                        foreach (PersonDepartmentMaster RefDepRec in CommonMotions.LoginUserRefDepartment)

                CommonMotions.LoginUserRefDepartment.Clear();

                List<PersonDepartmentMaster> depList = CommonMotions.LoginUserRefDepartment;

                            foreach (PersonDepartmentMaster RefDepRec in CommonMotions.LoginUserRefDepartment)

                    // 所属長以上対象部署の全てのメッセージを見ることができる

                if (!ClsMessageBoradAccess.MessageReadPermission(RecoadNo, BuranchNo)) return false;

[assembly: AssemblyVersion("1.0.1.34")]

[assembly: AssemblyFileVersion("1.0.1.34")]