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

            ApprovalRouteList = 112,            // 112:承認経路一覧

                                                                                { (int)MaintenanceExecuteNo.ApprovalRouteList,          "承認経路一覧"},               // 112

                                                                                { (int)MaintenanceExecuteNo.SubContrItem,               "協力会社工種登録"},           // 114

                                                                                { (int)MaintenanceExecuteNo.SubContrJobCat,             "協力会社職種登録"},           // 123

                                                                                { (int)MaintenanceExecuteNo.ConstrExpenses,             "施工経費区分登録"},           // 126

        /// <summary>

        /// 編集フラグ

        /// </summary>

        static int m_EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;

                    if (!ClsSecurityPermission.GetExecutePermission(m_ProcControlPara[NowPoint].ProcNo, ref m_EditFlg))

                        case (int)MaintenanceExecuteNo.ApprovalRouteList:                       // 118:承認経路マスタ

            FrmApprovalDisp frm = new FrmApprovalDisp();

            /// 工事コード

            /// </summary>

            ConstructionCode,

            /// <summary>

            strcmd.Append(" ,ConstructionCode");                                // 工事コード

                strcmd.AppendFormat(", {0}", work.ConstructionCode);                    // 工事番号

                    strcmd.AppendFormat(", {0}", work.ConstructionCode);                                // 工事番号

                strcmd.AppendFormat(",ConstructionCode = {0}", data.ConstructionCode);      // 工事番号

                    case (int)TableColumn.ConstructionCode:

                        strcmd.AppendFormat(" ConstructionCode = {0}", (int)value);

                        break;

                wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString());      // 工事番号

        /// 工事コード

        /// </summary>

        private int         m_ConstructionCode = 0;

        /// <summary>

        /// 工事コード

        public int ConstructionCode

        {

            get { return m_ConstructionCode; }

            set { m_ConstructionCode = value; }

        }

        /// <summary>

        /// 行動実績

        /// </summary>

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Collections;

using System.Diagnostics;

using System.Threading;

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.DB.Core;

using ProcessManagement.Forms.SubForms;

using ProcessManagement.Forms.CustomControls;

using ProcessManagement.Forms.ControlsAction;

//*--------------------- 承認経路マスタ一覧画面 -------------------------------*

//  2017/09/27  Ver1.0.0.0      Create Source           

//

//

//

//*----------------------------------------------------------------------------*

namespace ProcessManagement.Forms.Master

{

    public partial class FrmApprovalDisp : Form

    {

        #region 使用定義

        //log4netログを使用する

        private static readonly log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        #endregion

        #region 定数

        #region グリッド固定カラム

        /// <summary>

        /// グリッド固定カラム

        /// </summary>

        private enum GridColumn

        {

            No = 0,

            DepartmentCode,

            ApprovalCode,

            ApprovalName,

        }

        #endregion

        #region デフォルト色

        /// <summary>

        /// デフォルト色

        /// </summary>

        private static Color s_LastApproval = Color.LightSalmon;

        #endregion

        #endregion

        #region 参照フラグ

        /// <summary>

        /// 参照フラグ

        /// </summary>

        private bool m_EditLock = false;

        #endregion

        #region プロパティ

        /// <summary>

        /// 参照フラグ

        /// </summary>

        public bool EditLock

        {

            get { return m_EditLock; }

            set { m_EditLock = value; }

        }

        #endregion

        #region コンストラクタ

        public FrmApprovalDisp()

        {

            InitializeComponent();

        }

        #endregion

        #region デストラクタ

        ~FrmApprovalDisp()

        {

            try

            {

                GC.Collect();

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region フォームロード

        /// <summary>

        /// 初期フォームロード

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void FrmApprovalDisp_Load(object sender, EventArgs e)

        {

            // 初期表示

            InitDispGrid();

        }

        #endregion

        #region ×ボタン押下

        /// <summary>

        /// ×ボタン押下処理

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void FrmApprovalDisp_FormClosing(object sender, FormClosingEventArgs e)

        {

            // 前プロセスに戻る

            ClsExcute.BackProcess();

        }

        #endregion

        #region 終了ボタン

        /// <summary>

        /// 終了ボタンクリック

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void btnEnd_Click(object sender, EventArgs e)

        {

            this.Close();

        }

        #endregion

        #region グリッドダブルクリック

        /// <summary>

        /// グリッドダブルクリック

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void dgvProcess_CellDoubleClick(object sender, DataGridViewCellEventArgs e)

        {

            EntryDisp();

        }

        #endregion

    }

}

using ProcessManagement.Forms.CustomControls;

namespace ProcessManagement.Forms.Master

{

    partial class FrmApprovalDisp

    {

        /// <summary>

        /// 必要なデザイナ変数です。

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// 使用中のリソースをすべてクリーンアップします。

        /// </summary>

        /// <param name="disposing">マネージ リソースが破棄される場合 true、破棄されない場合は false です。</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows フォーム デザイナで生成されたコード

        /// <summary>

        /// デザイナ サポートに必要なメソッドです。このメソッドの内容を

        /// コード エディタで変更しないでください。

        /// </summary>

        private void InitializeComponent()

        {

            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();

            this.btnEnd = new System.Windows.Forms.Button();

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

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

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

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

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

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

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

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

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

            this.SuspendLayout();

            // 

            // btnEnd

            // 

            this.btnEnd.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

            this.btnEnd.BackColor = System.Drawing.Color.Blue;

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

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

            this.btnEnd.Location = new System.Drawing.Point(1128, 655);

            this.btnEnd.Name = "btnEnd";

            this.btnEnd.Size = new System.Drawing.Size(120, 30);

            this.btnEnd.TabIndex = 6;

            this.btnEnd.Text = "終　了";

            this.btnEnd.UseVisualStyleBackColor = false;

            this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);

            // 

            // label1

            // 

            this.label1.Anchor = System.Windows.Forms.AnchorStyles.Top;

            this.label1.BackColor = System.Drawing.Color.Gold;

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

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

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

            this.label1.Location = new System.Drawing.Point(380, 10);

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(500, 20);

            this.label1.TabIndex = 5;

            this.label1.Text = "承　認　経　路　一　覧";

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

            // 

            // dgvProcess

            // 

            this.dgvProcess.AllowUserToAddRows = false;

            this.dgvProcess.AllowUserToDeleteRows = false;

            this.dgvProcess.AllowUserToResizeColumns = false;

            this.dgvProcess.AllowUserToResizeRows = false;

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

            this.dgvProcess.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;

            this.dgvProcess.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.dgvProcess.AutoSizeRowsMode = System.Windows.Forms.DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders;

            this.dgvProcess.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));

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

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

            dataGridViewCellStyle2.BackColor = System.Drawing.Color.White;

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

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

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

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

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

            this.dgvProcess.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2;

            this.dgvProcess.ColumnHeadersHeight = 24;

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

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

            this.Column1,

            this.Column4,

            this.Column2,

            this.Column3});

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

            this.dgvProcess.Location = new System.Drawing.Point(10, 40);

            this.dgvProcess.Name = "dgvProcess";

            this.dgvProcess.RowHeadersVisible = false;

            this.dgvProcess.RowHeadersWidth = 20;

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

            this.dgvProcess.RowTemplate.Height = 20;

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

            this.dgvProcess.Size = new System.Drawing.Size(1240, 606);

            this.dgvProcess.TabIndex = 28;

            this.dgvProcess.TabStop = false;

            this.dgvProcess.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvProcess_CellDoubleClick);

            // 

            // Column1

            // 

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

            dataGridViewCellStyle3.Font = new System.Drawing.Font("Century", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

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

            this.Column1.DefaultCellStyle = dataGridViewCellStyle3;

            this.Column1.Frozen = true;

            this.Column1.HeaderText = "№";

            this.Column1.Name = "Column1";

            this.Column1.ReadOnly = true;

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

            this.Column1.Width = 60;

            // 

            // Column4

            // 

            this.Column4.Frozen = true;

            this.Column4.HeaderText = "部署コード";

            this.Column4.Name = "Column4";

            this.Column4.ReadOnly = true;

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

            this.Column4.Visible = false;

            // 

            // Column2

            // 

            this.Column2.Frozen = true;

            this.Column2.HeaderText = "承認コード";

            this.Column2.Name = "Column2";

            this.Column2.ReadOnly = true;

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

            this.Column2.Visible = false;

            this.Column2.Width = 60;

            // 

            // Column3

            // 

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

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

            this.Column3.DefaultCellStyle = dataGridViewCellStyle4;

            this.Column3.Frozen = true;

            this.Column3.HeaderText = "承　認　名　称";

            this.Column3.MaxInputLength = 50;

            this.Column3.Name = "Column3";

            this.Column3.ReadOnly = true;

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

            this.Column3.Width = 560;

            // 

            // lblLastAppColor

            // 

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

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

            this.lblLastAppColor.Location = new System.Drawing.Point(10, 658);

            this.lblLastAppColor.Name = "lblLastAppColor";

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

            this.lblLastAppColor.TabIndex = 32;

            // 

            // label3

            // 

            this.label3.Location = new System.Drawing.Point(110, 660);

            this.label3.Name = "label3";

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

            this.label3.TabIndex = 33;

            this.label3.Text = "最終承認者";

            // 

            // FrmApprovalDisp

            // 

            this.AutoScaleDimensions = new System.Drawing.SizeF(96F, 96F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Dpi;

            this.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;

            this.BackColor = System.Drawing.Color.Black;

            this.ClientSize = new System.Drawing.Size(1260, 692);

            this.Controls.Add(this.lblLastAppColor);

            this.Controls.Add(this.label3);

            this.Controls.Add(this.dgvProcess);

            this.Controls.Add(this.label1);

            this.Controls.Add(this.btnEnd);

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

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

            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;

            this.KeyPreview = true;

            this.MaximizeBox = false;

            this.MinimizeBox = false;

            this.Name = "FrmApprovalDisp";

            this.ShowIcon = false;

            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;

            this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.FrmApprovalDisp_FormClosing);

            this.Load += new System.EventHandler(this.FrmApprovalDisp_Load);

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

            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.Button btnEnd;

        private System.Windows.Forms.Label label1;

        private DataGridViewEX dgvProcess;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column1;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column4;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column2;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column3;

        private System.Windows.Forms.Label lblLastAppColor;

        private System.Windows.Forms.Label label3;

    }

}

<?xml version="1.0" encoding="utf-8"?>

<root>

  <!-- 

    Microsoft ResX Schema 

    Version 2.0

    The primary goals of this format is to allow a simple XML format 

    that is mostly human readable. The generation and parsing of the 

    various data types are done through the TypeConverter classes 

    associated with the data types.

    Example:

    ... ado.net/XML headers & schema ...

    <resheader name="resmimetype">text/microsoft-resx</resheader>

    <resheader name="version">2.0</resheader>

    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>

    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>

    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>

    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>

    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">

        <value>[base64 mime encoded serialized .NET Framework object]</value>

    </data>

    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>

        <comment>This is a comment</comment>

    </data>

    There are any number of "resheader" rows that contain simple 

    name/value pairs.

    Each data row contains a name, and value. The row also contains a 

    type or mimetype. Type corresponds to a .NET class that support 

    text/value conversion through the TypeConverter architecture. 

    Classes that don't support this are serialized and stored with the 

    mimetype set.

    The mimetype is used for serialized objects, and tells the 

    ResXResourceReader how to depersist the object. This is currently not 

    extensible. For a given mimetype the value must be set accordingly:

    Note - application/x-microsoft.net.object.binary.base64 is the format 

    that the ResXResourceWriter will generate, however the reader can 

    read any of the formats listed below.

    mimetype: application/x-microsoft.net.object.binary.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.soap.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64

    value   : The object must be serialized into a byte array 

            : using a System.ComponentModel.TypeConverter

            : and then encoded with base64 encoding.

    -->

  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />

    <xsd:element name="root" msdata:IsDataSet="true">

      <xsd:complexType>

        <xsd:choice maxOccurs="unbounded">

          <xsd:element name="metadata">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" />

              </xsd:sequence>

              <xsd:attribute name="name" use="required" type="xsd:string" />

              <xsd:attribute name="type" type="xsd:string" />

              <xsd:attribute name="mimetype" type="xsd:string" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="assembly">

            <xsd:complexType>

              <xsd:attribute name="alias" type="xsd:string" />

              <xsd:attribute name="name" type="xsd:string" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="data">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />

              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />

              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="resheader">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" />

            </xsd:complexType>

          </xsd:element>

        </xsd:choice>

      </xsd:complexType>

    </xsd:element>

  </xsd:schema>

  <resheader name="resmimetype">

    <value>text/microsoft-resx</value>

  </resheader>

  <resheader name="version">

    <value>2.0</value>

  </resheader>

  <resheader name="reader">

    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <resheader name="writer">

    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

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

    <value>True</value>

  </metadata>

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

    <value>True</value>

  </metadata>

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

    <value>True</value>

  </metadata>

</root>

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Collections;

using System.Diagnostics;

using System.Threading;

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.DB.Core;

using ProcessManagement.Forms.SubForms;

using ProcessManagement.Forms.CustomControls;

using ProcessManagement.Forms.ControlsAction;

namespace ProcessManagement.Forms.Master

{

    public partial class FrmApprovalDisp

    {

        #region 取得テーブルデータ並び

        /// <summary>

        /// 取得テーブルデータ並び

        /// </summary>

        private enum DispRecCol

        {

            DepartmentCode,

            DepartmentString,

            DepDispOrder,

            ApprovalCode,

            ApprovalName,

            ApprovalPerson,

            ApprovalAuthority,

            AppDispOrder,

            PersonCode,

            PersonName,

        }

        #endregion

        #region 初期時データ取得

        /// <summary>

        /// 初期時データ取得

        /// </summary>

        private bool InitDispGrid()

        {

            DataGridView dgv = dgvProcess;

            IOMApproval AppDB = new IOMApproval();

            try

            {

                lblLastAppColor.BackColor = s_LastApproval;

                // グリッドの行を0に戻す

                dgv.Rows.Clear();

                // データ取得

                StringBuilder strcmd = new StringBuilder();

                strcmd.Append("Select");

                strcmd.Append(" A.DepartmentCode,");

                strcmd.Append(" A.DepartmentString,");

                strcmd.Append(" A.DisplayOrder,");

                strcmd.Append(" B.ApprovalCode,");

                strcmd.Append(" '',");

                strcmd.Append(" B.ApprovalPerson,");

                strcmd.Append(" B.ApprovalAuthority,");

                strcmd.Append(" B.DisplayOrder,");

                strcmd.Append(" C.PersonCode,");

                strcmd.Append(" C.PersonName");

                strcmd.Append(" From");

                strcmd.Append(" departmentmaster AS A");

                strcmd.Append(" Left Join approvalmaster AS B");

                strcmd.Append(" ON B.DepartmentCode = A.DepartmentCode");

                strcmd.Append(" Left Join personinchargemaster AS C");

                strcmd.Append(" ON C.PersonCode= B.ApprovalPerson");

                strcmd.Append(" Order by");

                strcmd.Append(" A.DisplayOrder,");

                strcmd.Append(" B.ApprovalCode,");

                strcmd.Append(" B.DisplayOrder desc");

                ArrayList ReadList = new ArrayList();

                if (!AppDB.ExecuteReader(strcmd.ToString(), ref ReadList)) return false;

                // 取得データを表示配列へセット

                ArrayList DispList = new ArrayList();

                CreateDispArray(ReadList, ref DispList);

                // 最初に承認者を6人分追加する

                CreateColumn(6);

                // データ表示

                int nDepCode = 0;

                int nAppCode = 0;

                ArrayList AppRowList = new ArrayList();

                foreach (object[] objwrk in DispList)

                {

                    // 部署が違えば部署名表示

                    if (nDepCode != CommonMotions.cnvInt(objwrk[(int)DispRecCol.DepartmentCode]))

                    {

                        if (nAppCode != 0) SetGridRowData(ref AppRowList);

                        SetGridDepTitile(objwrk);

                        nDepCode = CommonMotions.cnvInt(objwrk[0]);

                        m_nDataNo = 0;

                        nAppCode = 0;

                    }

                    if (nAppCode != CommonMotions.cnvInt(objwrk[(int)DispRecCol.ApprovalCode]))

                    {

                        if (nAppCode != 0) SetGridRowData(ref AppRowList);

                        nAppCode = CommonMotions.cnvInt(objwrk[(int)DispRecCol.ApprovalCode]);

                    }

                    AppRowList.Add(objwrk);

                }

                // タイトル行の色セット

                GridDepTitileColor();

                // 行を選択しない

                dgv.ClearSelection();

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

            finally

            {

                AppDB.close(); AppDB = null;

                int AddRowCnt1 = CommonDefine.s_MaxInitLineCountMastamente - dgv.Rows.Count;

                if (AddRowCnt1 > 0) dgv.Rows.Add(AddRowCnt1);

            }

        }

        #endregion

        #region 表示データ配列作成

        /// <summary>

        /// 表示データ配列作成

        /// </summary>

        /// <param name="ReadList"></param>

        /// <param name="DispList"></param>

        private void CreateDispArray(ArrayList ReadList, ref ArrayList DispList)

        {

            IOMDepartment DepDB = new IOMDepartment();

            try

            {

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(" Where DeleteFlg = 0");

                strSQL.Append(" Order by DisplayOrder");

                List<DepartmentMaster> DepList = new List<DepartmentMaster>();

                if (!DepDB.SelectAction(strSQL.ToString(), ref DepList)) return;

                int depCode = 0;

                int appCode = 0;

                int AddCnt = 0;

                foreach (DepartmentMaster DepRec in DepList)

                {

                    foreach (KeyValuePair<int, string> AppList in ClsExcute.AppovalList)

                    {

                        AddCnt = 0;

                        foreach (object[] objRec in ReadList)

                        {

                            depCode = CommonMotions.cnvInt(objRec[(int)DispRecCol.DepartmentCode]);

                            appCode = CommonMotions.cnvInt(objRec[(int)DispRecCol.ApprovalCode]);

                            // 部署が違う場合は処理しない

                            if (DepRec.DepartmentCode != depCode) continue;

                            // 承認コードが違う場合は処理しない

                            if (AppList.Key != appCode) continue;

                            DispList.Add(new object[] { CommonMotions.cnvInt(objRec[(int)DispRecCol.DepartmentCode]),

                                                        CommonMotions.cnvString(objRec[(int)DispRecCol.DepartmentString]),

                                                        CommonMotions.cnvInt(objRec[(int)DispRecCol.DepDispOrder]),

                                                        CommonMotions.cnvInt(objRec[(int)DispRecCol.ApprovalCode]),

                                                        AppList.Value,

                                                        CommonMotions.cnvInt(objRec[(int)DispRecCol.ApprovalPerson]),

                                                        CommonMotions.cnvInt(objRec[(int)DispRecCol.ApprovalAuthority]),

                                                        CommonMotions.cnvInt(objRec[(int)DispRecCol.AppDispOrder]),

                                                        CommonMotions.cnvInt(objRec[(int)DispRecCol.PersonCode]),

                                                        CommonMotions.cnvString(objRec[(int)DispRecCol.PersonName]) });

                            AddCnt++;

                        }

                        // データがない場合は承認のみ追加

                        if (AddCnt == 0)

                        {

                            DispList.Add(new object[] { DepRec.DepartmentCode,

                                                        DepRec.DepartmentString,

                                                        0,

                                                        AppList.Key,

                                                        AppList.Value,

                                                        0,

                                                        0,

                                                        0,

                                                        0,

                                                        string.Empty });

                        }

                    }

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                DepDB.close(); DepDB = null;

            }

        }

        #endregion

        #region グリッド部署タイトルセット

        /// <summary>

        /// グリッド部署タイトルセット

        /// </summary>

        /// <param name="objrec"></param>

        private void SetGridDepTitile(object[] objrec)

        {

            try

            {

                DataGridView dgv = dgvProcess;

                int RowCnt = dgv.Rows.Add(string.Empty

                                    , CommonMotions.cnvInt(objrec[(int)DispRecCol.DepartmentCode])

                                    , string.Empty

                                    , string.Format("　{0}", CommonMotions.cnvString(objrec[(int)DispRecCol.DepartmentString]))

                                    );

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 部署タイトル行の色を変える

        /// <summary>

        /// 部署タイトル行の色を変える

        /// </summary>

        private void GridDepTitileColor()

        {

            try

            {

                DataGridView dgv = dgvProcess;

                foreach (DataGridViewRow CurRow in dgv.Rows)

                {

                    if (CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.ApprovalCode].Value) != 0) continue;

                    // タイトル行を対象にする

                    // 行の色を変える

                    for (int i = 0; i < dgv.ColumnCount; i++)

                    {

                        CurRow.Cells[i].Style.BackColor = Color.Black;

                        CurRow.Cells[i].Style.ForeColor = Color.White;

                    }

                    // 表示した行を書込み禁止にする

                    CurRow.ReadOnly = true;

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        private int m_nDataNo = 0;

        #region グリッドデータセット

        /// <summary>

        /// グリッドデータセット

        /// </summary>

        /// <param name="objrec"></param>

        private void SetGridRowData(ref ArrayList AppRowList)

        {

            try

            {

                DataGridView dgv = dgvProcess;

                int nRowCnt = 0;

                int nDataCnt = AppRowList.Count;

                int nColCnt = dgv.ColumnCount;

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

                // 承認者数が現在カラムを越えていれば先に増やしておく

                if (nColCnt < (nColFixCnt + nDataCnt))

                {

                    CreateColumn(nDataCnt);

                }

                // 行カウントアップ

                m_nDataNo++;

                // 承認者先頭列取得

                int ApprovalCnt=nColFixCnt;

                int nDepCode = 0;

                string DepartmentName = string.Empty;

                int nAppCode = 0;

                string ApprovalName = string.Empty;

                int AppPersonCode = 0;

                int ApprAuthority = -1;

                string PersonName = string.Empty;

                foreach (object[] objRec in AppRowList)

                {

                    nDepCode = CommonMotions.cnvInt(objRec[(int)DispRecCol.DepartmentCode]);

                    DepartmentName = string.Format("　{0}",CommonMotions.cnvString(objRec[(int)DispRecCol.DepartmentString]));

                    nAppCode = CommonMotions.cnvInt(objRec[(int)DispRecCol.ApprovalCode]);

                    ApprovalName = string.Format("　　{0}",CommonMotions.cnvString(objRec[(int)DispRecCol.ApprovalName]));

                    AppPersonCode = CommonMotions.cnvInt(objRec[(int)DispRecCol.ApprovalPerson]);

                    ApprAuthority = CommonMotions.cnvInt(objRec[(int)DispRecCol.ApprovalAuthority]);

                    PersonName = CommonMotions.cnvString(objRec[(int)DispRecCol.PersonName]);

                    // 1回目は行追加

                    if (nRowCnt < 1)

                    {

                        nRowCnt = dgv.Rows.Add(m_nDataNo

                                            , nDepCode

                                            , nAppCode

                                            , ApprovalName

                                            );

                    }

                    // 承認者セット

                    dgv.Rows[nRowCnt].Cells[ApprovalCnt].Value = PersonName;

                    // 最終承認者セット

                    if (ApprAuthority != 0) dgv.Rows[nRowCnt].Cells[ApprovalCnt].Style.BackColor = s_LastApproval;

                    ApprovalCnt++;

                }

                AppRowList.Clear();

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 列カラム作成

        /// <summary>

        /// 列カラム作成

        /// </summary>

        private void CreateColumn(int NewCnt)

        {

            try

            {

                DataGridView dgv = dgvProcess;

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

                int startcnt = 1;

                if (GridFixCnt < dgv.ColumnCount)

                {

                    startcnt = CommonMotions.cnvInt((dgv.Columns[(dgv.ColumnCount - 1)].HeaderText.Replace("承認者", ""))) + 1;

                }

                int LoopEnd = NewCnt - (dgv.ColumnCount - GridFixCnt);

                for (int i = 0; i < LoopEnd; i++)

                {

                    // 列を作成する

                    DataGridViewTextBoxColumn NewColumn = new DataGridViewTextBoxColumn();

                    DataGridViewCellStyle NewCellStyle = new DataGridViewCellStyle();

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

                    NewCellStyle.ForeColor = Color.Black;

                    NewColumn.DefaultCellStyle = NewCellStyle;

                    NewColumn.Name = string.Format("ApprovalPerson{0}", startcnt);

                    NewColumn.HeaderText = string.Format("承認者{0}", startcnt++);

                    NewColumn.HeaderCell.Style.Font = new System.Drawing.Font("ＭＳ 明朝", 9.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

                    NewColumn.Resizable = System.Windows.Forms.DataGridViewTriState.False;

                    NewColumn.ReadOnly = true;

                    NewColumn.SortMode = DataGridViewColumnSortMode.NotSortable;

                    NewColumn.Width = 100;

                    // 列を追加する

                    dgv.Columns.Add(NewColumn);

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 登録画面表示

        /// <summary>

        /// 登録画面表示

        /// </summary>

        private void EntryDisp()

        {

            FrmApprovalRoute frm = new FrmApprovalRoute();

            try

            {

                this.Hide();

                DataGridView dgv = dgvProcess;

                DataGridViewRow CurRow = dgv.CurrentRow;

                int nAppCode = CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.ApprovalCode].Value);

                int nDepCode = CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.DepartmentCode].Value);

                frm.ApprovalNo = nAppCode;

                frm.DepartmentCode = nDepCode;

                frm.ShowDialog();

                if (frm.ResultRet == DialogResult.Cancel) return;

                InitDispGrid();

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                this.Show();

                frm.Dispose(); frm = null;

            }

        }

        #endregion

    }

}

        /// <summary>

        /// 部署番号

        /// </summary>

        private int m_DepartmentCode = 0;

        /// <summary>

        /// 承認番号

        /// </summary>

        private int m_ApprovalNo = 0;

        /// <summary>

        /// 終了状態

        /// </summary>

        private DialogResult m_ResultRet = DialogResult.OK;

        /// <summary>

        /// 部署番号

        /// </summary>

        public int DepartmentCode

        {

            get { return m_DepartmentCode; }

            set { m_DepartmentCode = value; }

        }

        /// <summary>

        /// 承認番号

        /// </summary>

        public int ApprovalNo

        {

            get { return m_ApprovalNo; }

            set { m_ApprovalNo = value; }

        }

        /// <summary>

        /// 終了状態

        /// </summary>

        public DialogResult ResultRet

        {

            get { return m_ResultRet; }

            set { m_ResultRet = value; }

        }

            m_ResultRet = DialogResult.Cancel;

            // ヘッダーセット

            SetHeaderData();

            // データ表示

            DispMentenanceData();

            // 担当者一覧表示

                this.Close();

                string strDel = AppDB.CreatePrimarykeyString(m_ApprovalNo, m_DepartmentCode);

                this.Close();

        #region データグリッド値変更

        /// <summary>

        /// データグリッド値変更

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void dgvGridData_CellValueChanged(object sender, DataGridViewCellEventArgs e)

        {

            m_bChengeAns = true;

        }

        #endregion

                string strDelete = AppMDB.CreatePrimarykeyString(m_ApprovalNo, m_DepartmentCode);

                    AppRec.ApprovalCode = m_ApprovalNo;

                    AppRec.DepartmentCode = m_DepartmentCode;

        #region ヘッダーデータセット

        /// ヘッダーデータセット

        private void SetHeaderData()

        {

            IOMDepartment dmDB = new IOMDepartment();

            try

            {

                // 承認名称セット

                lblApprovalName.Text = ClsExcute.AppovalList[m_ApprovalNo];

                // 部署名セット

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(dmDB.CreatePrimarykeyString(m_DepartmentCode));

                DepartmentMaster dmRec = new DepartmentMaster();

                if (!dmDB.SelectAction(strSQL.ToString(), ref dmRec)) return;

                lblDepartmentName.Text = dmRec.DepartmentString;

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                dmDB.close(); dmDB = null;

            }

        }

        #endregion

        #region 担当者データ取得

        /// <summary>

        /// 担当者データ取得

        /// </summary>

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("Select");

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

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

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

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

                strSQL.Append(" A.ApprovalAuthority");

                strSQL.Append(" From");

                strSQL.Append(" approvalmaster AS A");

                strSQL.Append(" Left Join departmentmaster AS B");

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

                strSQL.Append(" Left Join personinchargemaster AS C");

                strSQL.Append(" ON C.PersonCode = A.ApprovalPerson");

                strSQL.AppendFormat(" Where A.ApprovalCode = {0}", m_ApprovalNo);

                strSQL.AppendFormat(" And A.DepartmentCode = {0}", m_DepartmentCode);

                strSQL.Append(" Order By A.DisplayOrder Asc");

                ArrayList DataList = new ArrayList();

                if (!AppMDB.ExecuteReader(strSQL.ToString(), ref DataList)) return;

                int PersonCode = 0;

                string PersonName = string.Empty;

                string PossionName = string.Empty;

                string DepName = string.Empty;

                int Authority = 0;

                bool bCheck = false;

                foreach (object[] wrkRec in DataList)