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

        public static int s_SystemVersion = 18;

    #endregion

        /// 行動予定フィールド並び

        #region 行動予定検索

        /// 行動予定検索

        /// <param name="data">行動予定データ</param>

        #region 行動予定複数追加

        /// 行動予定複数追加

        /// <param name="data">行動予定データ</param>

        #region 行動予定１件追加

        /// 行動予定１件追加

        #region 行動予定更新

        /// 行動予定更新

        /// <param name="data">行動予定データ</param>

        #region 行動予定削除

        /// 行動予定削除

        /// <param name="data">行動予定データ</param>

                string strSQL = "SELECT AX.DT, DATE_FORMAT(C.HOLIDAY,'%Y/%m/%d'), D.ACTIONRESULT, D.OVERTIMEHOURS, D.WORKINGCOMMENT FROM";

                strSQL += " (SELECT DATE_FORMAT((st+ROWNUM-1), '%Y/%m/%d') DT";

                strSQL += " FROM SYS.ALL_CATALOG A,";

                strSQL += string.Format(" (SELECT STR_TO_DATE('{0}','%Y%m%d') st,", (WorktDate.Year.ToString() + WorktDate.Month.ToString("00") + "01"));

                strSQL += string.Format(" STR_TO_DATE('{0}','%Y%m%d') ed FROM SYS.DUAL) B", (WorktDate.Year.ToString() + WorktDate.Month.ToString("00") + m_LastDays.ToString("00")));

                strSQL += " WHERE ROWNUM <= (ed - st + 1)) AX";

                strSQL += " LEFT JOIN HOLIDAYCALENDERMASTER C ON C.HOLIDAY = AX.DT";

                strSQL += string.Format(" LEFT JOIN ATTENDANCEDAILYDATA D ON  D.PERSONCODE = {0} AND D.ATTENDANCEDATE = AX.DT", PersonCode);

                strSQL += " ORDER BY AX.DT, D.SEQNO";

                string strSQL = "SELECT AX.DT,";                        // 0

                strSQL += " (SELECT DATE_FORMAT((st+ROWNUM-1), '%Y/%m/%d') DT FROM SYS.ALL_CATALOG A,";

                strSQL += string.Format(" (SELECT STR_TO_DATE('{0}','%Y%m%d') st,", (WorktDate.Year.ToString() + WorktDate.Month.ToString("00") + "01"));

                strSQL += string.Format(" STR_TO_DATE('{0}','%Y%m%d') ed FROM DUAL) B", (WorktDate.Year.ToString() + WorktDate.Month.ToString("00") + m_LastDays.ToString("00")));

                strSQL += " WHERE ROWNUM <= (ed - st + 1)) AX";

                strSQL += " LEFT JOIN HOLIDAYCALENDERMASTER C ON C.HOLIDAY = AX.DT";

                strSQL += string.Format(" LEFT JOIN TRANCEPORTDAILYDATA D ON  D.PERSONCODE = {0} AND D.ATTENDANCEDATE = AX.DT", PersonCode);

                strSQL += " ORDER BY AX.DT";

                strSQL += string.Format(" AND DATE_FORMAT(AttendanceMonth,'YYYY/MM') = '{0}'", TargetMonth);

                strSQL += string.Format(" AND DATE_FORMAT(ATTENDANCEMONTH,'YYYY/MM') = '{0}'", TargetMonth);

                    // SQL作成

                    SetRowToSQL1(wrkRow, LineCnt++, ref NewList);

        #region 出勤日報データ作成SQL

        /// 出勤日報データ作成SQL

        private void SetRowToSQL1(DataGridViewRow wrkRow, int LineCnt, ref List<AttendanceDailyData> NewList)

                strSQL += string.Format(" AND DATE_FORMAT(ATTENDANCEMONTH,'%Y/%m') = '{0}'", TargetMonth);

                    SetRowToSQL2(PersonCode, wrkRow, ref NewList);

                    SetRowToSQL2(PersonCode, wrkRow, ref NewList);

        #region 出勤交通費データ取り込み

        /// 出勤交通費データ取り込み

        private void SetRowToSQL2(int PersonCode, DataGridViewRow wrkRow, ref List<TranceportDailyData> NewList)

                strSQL += string.Format(" AND DATE_FORMAT(ATTENDANCEMONTH,'%Y/%m') = '{0}'", TargetMonth);

                    int DayCnt = m_CalendPage.MonthryData[i].lblDayData.Length;

                    for (int ix = 0; ix < DayCnt; ix++)

                        // 該当日を検索する

                        string wrkHi = m_CalendPage.MonthryData[i].lblDayData[ix].Text;

                        int tergetDay = CommonMotions.cnvInt(wrkHi);

                        string nen = m_CalendPage.lblMonthTitle[i].Text.Substring(0, m_CalendPage.lblMonthTitle[i].Text.IndexOf("年"));

                        DateTime dtter = DateTime.Parse(nen + "/" + wrkTuki + "/" + wrkHi);

                        string strSQL = hcDB.CreatePrimarykeyString(dtter);

                        //string strSQL = hcDB.CreateSubkeyString(ClsCommon.cnvInt(txtInput01.Text), tergetMonth, tergetDay);

                        List<HolidayCalenderMaster> dataList = new List<HolidayCalenderMaster>();

                        //Console.Write("Start Time={0}   {1}\n", DateTime.Now.ToString("HH:mm:ss.fff"), strSQL);

                        if (!hcDB.SelectAction(strSQL, ref dataList)) continue;

                        if (dataList.Count == 0) continue;

                        //Console.Write("End   Time={0}\n", DateTime.Now.ToString("HH:mm:ss.fff"));

using ProcessManagement.Forms.CustomControls;

namespace ProcessManagement.Forms.Master

{

    partial class FrmConstructionType

    {

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.SuspendLayout();

            // 

            // btnDataEntry

            // 

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

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

            this.btnDataEntry.Location = new System.Drawing.Point(144, 650);

            this.btnDataEntry.Name = "btnDataEntry";

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

            this.btnDataEntry.TabIndex = 1;

            this.btnDataEntry.Text = "登　録";

            this.btnDataEntry.UseVisualStyleBackColor = false;

            this.btnDataEntry.Click += new System.EventHandler(this.btnDataEntry_Click);

            // 

            // btnLineEntry

            // 

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

            this.btnLineEntry.Location = new System.Drawing.Point(272, 650);

            this.btnLineEntry.Name = "btnLineEntry";

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

            this.btnLineEntry.TabIndex = 2;

            this.btnLineEntry.Text = "追　加";

            this.btnLineEntry.UseVisualStyleBackColor = false;

            this.btnLineEntry.Click += new System.EventHandler(this.btnLineEntry_Click);

            // 

            // btnLineDelete

            // 

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

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

            this.btnLineDelete.Location = new System.Drawing.Point(400, 650);

            this.btnLineDelete.Name = "btnLineDelete";

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

            this.btnLineDelete.TabIndex = 3;

            this.btnLineDelete.Text = "削　除";

            this.btnLineDelete.UseVisualStyleBackColor = false;

            this.btnLineDelete.Click += new System.EventHandler(this.btnLineDelete_Click);

            // 

            // btnEnd

            // 

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

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

            this.btnEnd.Location = new System.Drawing.Point(528, 650);

            this.btnEnd.Name = "btnEnd";

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

            this.btnEnd.TabIndex = 4;

            this.btnEnd.Text = "終　了";

            this.btnEnd.UseVisualStyleBackColor = false;

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

            // 

            // lblTitile

            // 

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

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

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

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

            this.lblTitile.Location = new System.Drawing.Point(100, 10);

            this.lblTitile.Name = "lblTitile";

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

            this.lblTitile.TabIndex = 6;

            this.lblTitile.Text = "工事種別マスタメンテナンス";

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

            // 

            // dgvMaster

            // 

            this.dgvMaster.AllowUserToAddRows = false;

            this.dgvMaster.AllowUserToDeleteRows = false;

            this.dgvMaster.AllowUserToResizeColumns = false;

            this.dgvMaster.AllowUserToResizeRows = false;

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

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

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

            this.Column1,

            this.Column2,

            this.Column3,

            this.Column5});

            this.dgvMaster.Location = new System.Drawing.Point(8, 40);

            this.dgvMaster.Name = "dgvMaster";

            this.dgvMaster.RowHeadersWidth = 20;

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

            this.dgvMaster.RowTemplate.Height = 21;

            this.dgvMaster.Size = new System.Drawing.Size(640, 602);

            this.dgvMaster.TabIndex = 0;

            this.dgvMaster.CellEnter += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvMaster_CellEnter);

            this.dgvMaster.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvMaster_CellValueChanged);

            // 

            // Column1

            // 

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

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

            this.Column1.DefaultCellStyle = dataGridViewCellStyle2;

            this.Column1.Frozen = true;

            this.Column1.HeaderText = "№";

            this.Column1.Name = "Column1";

            this.Column1.ReadOnly = true;

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

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

            // 

            // Column2

            // 

            this.Column2.Frozen = true;

            this.Column2.HeaderText = "名称コード";

            this.Column2.Name = "Column2";

            this.Column2.ReadOnly = true;

            this.Column2.Visible = false;

            // 

            // Column3

            // 

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

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

            this.Column3.DefaultCellStyle = dataGridViewCellStyle3;

            this.Column3.Frozen = true;

            this.Column3.HeaderText = "名　  称";

            this.Column3.MaxInputLength = 50;

            this.Column3.Name = "Column3";

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

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

            this.Column3.Width = 500;

            // 

            // Column5

            // 

            this.Column5.HeaderText = "NewFlg";

            this.Column5.Name = "Column5";

            this.Column5.ReadOnly = true;

            this.Column5.Visible = false;

            // 

            // btnDispDown

            // 

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

            this.btnDispDown.Location = new System.Drawing.Point(653, 300);

            this.btnDispDown.Name = "btnDispDown";

            this.btnDispDown.Size = new System.Drawing.Size(40, 40);

            this.btnDispDown.TabIndex = 10;

            this.btnDispDown.Text = "▼";

            this.btnDispDown.UseVisualStyleBackColor = true;

            this.btnDispDown.Click += new System.EventHandler(this.btnDispDown_Click);

            // 

            // btnDispUp

            // 

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

            this.btnDispUp.Location = new System.Drawing.Point(653, 236);

            this.btnDispUp.Name = "btnDispUp";

            this.btnDispUp.Size = new System.Drawing.Size(40, 40);

            this.btnDispUp.TabIndex = 9;

            this.btnDispUp.Text = "▲";

            this.btnDispUp.UseVisualStyleBackColor = true;

            this.btnDispUp.Click += new System.EventHandler(this.btnDispUp_Click);

            // 

            // FrmConstructionType

            // 

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

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

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

            this.ClientSize = new System.Drawing.Size(700, 687);

            this.Controls.Add(this.btnDispDown);

            this.Controls.Add(this.btnDispUp);

            this.Controls.Add(this.lblTitile);

            this.Controls.Add(this.btnDataEntry);

            this.Controls.Add(this.btnLineEntry);

            this.Controls.Add(this.btnLineDelete);

            this.Controls.Add(this.btnEnd);

            this.Controls.Add(this.dgvMaster);

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

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

            this.KeyPreview = true;

            this.MaximizeBox = false;

            this.Name = "FrmConstructionType";

            this.ShowIcon = false;

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

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

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

            this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.FrmConstructionType_KeyDown);

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

            this.ResumeLayout(false);

        }

        #endregion

        private DataGridViewEX dgvMaster;

        private System.Windows.Forms.Button btnDataEntry;

        private System.Windows.Forms.Button btnLineEntry;

        private System.Windows.Forms.Button btnLineDelete;

        private System.Windows.Forms.Button btnEnd;

        private System.Windows.Forms.Label lblTitile;

        private System.Windows.Forms.Button btnDispDown;

        private System.Windows.Forms.Button btnDispUp;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column1;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column2;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column3;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column5;

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

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;

//*------------------------ 工事種別メンテ画面 ------------------------------*

//  2015/11/07  Ver1.0.0.0      Create Source           

//

//

//

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

namespace ProcessManagement.Forms.Master

{

    public partial class FrmConstructionType : Form

    {

        #region 使用定義

        //log4netログを使用する

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

        #endregion

        #region 定数

        /// <summary>

        /// 表示カラム

        /// </summary>

        private enum DispColumn

        {

            No = 0,

            TypeCode,

            NameString,

            NewFlg,

        }

        /// <summary>

        /// マスタリストMAXライン

        /// </summary>

        private const int s_ListMaxLineCount = 53;

        #endregion

        #region 変数

        /// <summary>

        /// フィールド値変化フラグ

        /// </summary>

        private bool m_bChengeAns = false;

        /// <summary>

        /// 初期時グリッドカウント

        /// </summary>

        private int m_initDataCount = 0;

        /// <summary>

        /// 名称キー

        /// </summary>

        private int m_NameCode = 0;

        /// <summary>

        /// ダイアログ使用時フラグ

        /// </summary>

        private bool m_DialogFlg = false;

        #endregion

        #region プロパティ

        /// <summary>

        /// ダイアログ使用時フラグ

        /// </summary>

        public bool DialogUsed

        {

            set { m_DialogFlg = value; }

        }

        /// <summary>

        /// 名称コード

        /// </summary>

        public int NameCode

        {

            get { return m_NameCode; }

            set { m_NameCode = value; }

        }

        #endregion

        #region コンストラクタ

        public FrmConstructionType()

        {

            InitializeComponent();

        }

        #endregion

        #region デストラクタ

        ~FrmConstructionType()

        {

            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 FrmConstructionType_FormClosing(object sender, FormClosingEventArgs e)

        {

            if (m_bChengeAns)

            {

                if (MessageBox.Show("データに変更があります、登録せずに終了してよろしいですか？。", "終了確認"

                                , MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)

                {

                    e.Cancel = true;

                    return;

                }

            }

            // 前プロセスに戻る

            ClsExcute.BackProcess();

        }

        /// <summary>

        /// 終了ボタン押下

        /// </summary>

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

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

        private void btnEnd_Click(object sender, EventArgs e)

        {

            this.Close();

        }

        /// <summary>

        /// フォームロード

        /// </summary>

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

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

        private void FrmConstructionType_Load(object sender, EventArgs e)

        {

            // 初期表示

            InitDataLoad();

            // ダイアログ使用時

            if (m_DialogFlg)

            {

                //フォームの幅だけを変更する

                this.SetBounds(this.Left, this.Top, (this.Width - 40), this.Height, BoundsSpecified.Width);

            }

            // フォームサイズ固定

            this.MaximizedBounds = new Rectangle(this.Left, this.Top, this.Width, this.Height);

        }

        /// <summary>

        /// 行データクリア

        /// </summary>

        /// <param name="iIndex">行カウント</param>

        private void SetRowClearData(int iIndex, bool bfront = true)

        {

            // クリアデータセット

            dgvMaster[(int)DispColumn.No, iIndex].Value = "0";

            dgvMaster[(int)DispColumn.TypeCode, iIndex].Value = "";

            dgvMaster[(int)DispColumn.NameString, iIndex].Value = "";

            dgvMaster[(int)DispColumn.NewFlg, iIndex].Value = "1";

        }

        /// <summary>

        /// グリッド採番処理

        /// </summary>

        private void LineReNumbering()

        {

            int icnt = 1;

            foreach (DataGridViewRow r in dgvMaster.Rows)

            {

                if (CommonMotions.chkObjectIsNull(r.Cells[(int)DispColumn.NameString].Value)) continue;

                if (r.Cells[(int)DispColumn.NameString].Value.ToString().Length == 0) continue;

                // 表示されているものだけ採番

                if (r.Visible)

                    r.Cells[(int)DispColumn.No].Value = (icnt++).ToString();

                else

                    r.Cells[(int)DispColumn.No].Value = "0";

            }

        }

        /// <summary>

        /// 行追加ボタン押下

        /// </summary>

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

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

        private void btnLineEntry_Click(object sender, EventArgs e)

        {

            // 行がない場合は作成して抜ける

            if (dgvMaster.Rows.Count == 0)

            {

                if (MessageBox.Show("行を追加します", "追加確認"

                                    , MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.Cancel) return;

                // 行追加

                dgvMaster.Rows.Add();

                // クリアデータセット

                SetRowClearData(0);

                // №再採番

                LineReNumbering();

                //　変更フラグOn

                valueChange(sender, e);

                // フォーカス移動

                dgvMaster.Focus();

                return;

            }

            // メッセージ表示

            BtnTextCustomMessageBox msg = new BtnTextCustomMessageBox();

            msg.ButtonText.No = "前へ追加";

            msg.ButtonText.Yes = "後へ追加";

            msg.ButtonText.Cancel = "キャンセル";

            DialogResult resRet = msg.Show("行の前・後を選択してください。", "追加確認"

                                            , MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information);

            // キャンセルは処理しない

            if (resRet == DialogResult.Cancel) return;

            // カレント行取得

            int iIndex = dgvMaster.CurrentRow.Index;

            // 最終行

            if (iIndex == dgvMaster.RowCount - 1)

            {

                if (resRet == DialogResult.No)

                {

                    // 前

                    dgvMaster.Rows.Insert(iIndex);

                }

                else if (resRet == DialogResult.Yes)

                {

                    // 後

                    dgvMaster.Rows.Add();

                    iIndex = (dgvMaster.RowCount - 1);

                }

            }

            else

            {

                if (resRet == DialogResult.Yes)

                {

                    // 後ろ

                    ++iIndex;

                }

                dgvMaster.Rows.Insert(iIndex);

            }

            // クリアデータセット

            if ((iIndex + 1) >= dgvMaster.Rows.Count)

                SetRowClearData(iIndex, true);

            else

                SetRowClearData(iIndex, false);

            // №再採番

            LineReNumbering();

            //　変更フラグOn

            valueChange(sender, e);

            // フォーカス移動

            dgvMaster.Focus();

            //dgvMaster.FirstDisplayedScrollingRowIndex = iIndex;

            //dgvMaster.CurrentCell = dgvMaster[0, iIndex];

        }

        /// <summary>

        /// フィールド値変更フラグ

        /// </summary>

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

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

        private void valueChange(object sender, EventArgs e)

        {

            m_bChengeAns = true;

        }

        /// <summary>

        /// セル値変化

        /// </summary>

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

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

        private void dgvMaster_CellValueChanged(object sender, DataGridViewCellEventArgs e)

        {

            // インデックス外は処理しない

            if (e.RowIndex < 0 || e.ColumnIndex < 0) return;

            // null値は処理しない

            if (CommonMotions.chkObjectIsNull(dgvMaster.Rows[e.RowIndex].Cells[e.ColumnIndex].Value)) return;

            dgvMaster.Rows[e.RowIndex].Cells[e.ColumnIndex].ToolTipText

                = ((DataGridView)sender).Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();

            // 変更フラグON

            m_bChengeAns = true;

        }

        /// <summary>

        /// 行削除ボタン押下

        /// </summary>

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

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

        private void btnLineDelete_Click(object sender, EventArgs e)

        {

            IOMConstructionType ctDB = new IOMConstructionType();

            IOMConstructionSpecUnitPrice csuDB = new IOMConstructionSpecUnitPrice();

            try

            {

                if (CommonMotions.chkCellBlank(dgvMaster.CurrentRow.Cells[(int)DispColumn.NameString].Value)) return;

                if (MessageBox.Show("選択した行データを削除します。", "削除確認"

                    , MessageBoxButtons.YesNo, MessageBoxIcon.Information) != DialogResult.Yes) return;

                // 表示行退避

                int iIndex = dgvMaster.FirstDisplayedScrollingRowIndex;

                ctDB.connect(); ctDB.beginTran();

                csuDB.connect(); csuDB.beginTran();

                int TypeCode = CommonMotions.cnvInt(dgvMaster.CurrentRow.Cells[(int)DispColumn.TypeCode].Value.ToString());

                string strSQL = ctDB.CreatePrimarykeyString(TypeCode);

                if (!ctDB.DeleteAction(strSQL, false))

                {

                    ctDB.rollback();

                    MessageBox.Show("工事種別マスタ削除に失敗しました。", "削除エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return;

                }

                strSQL = string.Format(" Where ConstructionTypeCode = {0}", TypeCode);

                if (!csuDB.DeleteAction(strSQL, false))

                {

                    ctDB.rollback();

                    csuDB.rollback();

                    MessageBox.Show("作業単価マスタ削除に失敗しました。", "削除エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return;

                }

                ctDB.commit();

                csuDB.commit();

                // データ表示

                if (!DispGridData()) return;

                // 表示行復元

                dgvMaster.FirstDisplayedScrollingRowIndex = iIndex;

                // 変更フラグOff

                m_bChengeAns = false;

            }

            catch (System.Exception ex)

            {

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

            }

            finally

            {

                ctDB.close(); ctDB = null;

                csuDB.close(); csuDB = null;

            }

        }

        /// <summary>

        /// 登録ボタン押下

        /// </summary>

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

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

        private void btnDataEntry_Click(object sender, EventArgs e)

        {

            //データ無は抜ける

            if (dgvMaster.Rows.Count == 0) return;

            try

            {

                //データチェック

                if (!DispFeildCheck()) return;

                if (MessageBox.Show("表示中のデータを登録します。", "登録確認"

                        , MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes) return;

                // 表示行退避

                int iIndex = dgvMaster.FirstDisplayedScrollingRowIndex;

                // データ登録

                ConstructionTypeMasterDataEntry();

                // データ表示

                if (!DispGridData()) return;

                // 表示行復元

                dgvMaster.FirstDisplayedScrollingRowIndex = iIndex;

                // 変更フラグクリア

                m_bChengeAns = false;

            }

            catch (System.Exception ex)

            {

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

            }

        }

        /// <summary>

        /// IMEのコントロール

        /// </summary>

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

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

        private void dgvMaster_CellEnter(object sender, DataGridViewCellEventArgs e)

        {

            try

            {

                DataGridView dgv = (DataGridView)sender;

                if (dgv.CurrentCell.ReadOnly) return;

                //列によってIMEのモードを変更する

                if (dgv.Columns[e.ColumnIndex].Name.Equals("Column3"))

                {

                    dgv.ImeMode = ImeMode.On;

                }

                else

                {

                    dgv.ImeMode = ImeMode.Disable;

                }

            }

            catch (System.Exception ex)

            {

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

            }

        }

        /// <summary>

        /// アップキー押下

        /// </summary>

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

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

        private void btnDispUp_Click(object sender, EventArgs e)

        {

            try

            {

                // 先頭は処理しない

                if (dgvMaster.CurrentRow.Index == 0) return;

                int irowcnt = dgvMaster.CurrentRow.Index;

                if (irowcnt == 0) return;

                if (CommonMotions.chkObjectIsNull(dgvMaster.Rows[irowcnt - 1].Cells[(int)DispColumn.NameString].Value)) return;

                // グリッドアップキー処理

                DataGridViewAction.GridRowUpAction((DataGridView)dgvMaster, (int)DispColumn.TypeCode, (int)DispColumn.NewFlg);

                m_bChengeAns = true;

            }

            catch (System.Exception ex)

            {

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

            }

        }

        /// <summary>

        /// ダウンキー押下処理

        /// </summary>

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

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

        private void btnDispDown_Click(object sender, EventArgs e)

        {

            try

            {

                // 最終行は処理しない

                if ((dgvMaster.CurrentRow.Index + 1) == dgvMaster.Rows.Count) return;

                int irowcnt = dgvMaster.CurrentRow.Index;

                if (CommonMotions.chkObjectIsNull(dgvMaster.Rows[irowcnt + 1].Cells[(int)DispColumn.NameString].Value)) return;

                if (dgvMaster.Rows[irowcnt + 1].Cells[(int)DispColumn.NameString].Value.ToString() == "") return;

                // グリッドダウンキー処理

                DataGridViewAction.GridRowDownAction((DataGridView)dgvMaster, (int)DispColumn.TypeCode, (int)DispColumn.NewFlg);

                m_bChengeAns = true;

            }

            catch (System.Exception ex)

            {

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

            }

        }

        /// セルクリック

        /// </summary>

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

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

        private void dgvMaster_CellClick(object sender, DataGridViewCellEventArgs e)

        {

            dgvMaster_CellDoubleClick(sender, e);

        }

        /// <summary>

        /// セルダブルクリック

        /// </summary>

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

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

        private void dgvMaster_CellDoubleClick(object sender, DataGridViewCellEventArgs e)

        {

            // ダイアログとして使用するとき以外は処理しない

            if (!m_DialogFlg) return;

            if (e.RowIndex < 0) return;

            m_NameCode = int.Parse(dgvMaster.CurrentRow.Cells[(int)DispColumn.TypeCode].Value.ToString());

            this.Close();

        }

        /// <summary>

        /// Formキーダウン処理

        /// </summary>

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

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

        private void FrmConstructionType_KeyDown(object sender, KeyEventArgs e)

        {

            // DataGridviewは処理しない

            if (ActiveControl.Name.Equals("dgvMaster"))

            {

                // 最終行時の処理

                GridLastLine();

                return;

            }

        }

        #endregion

        #region プライベートメソッド

        /// <summary>

        /// 初期表示処理

        /// </summary>

        private void InitDataLoad()

        {

            try

            {

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

                dgvMaster.Rows.Clear();

                // 初期表示

                DispGridData();

                // 初期時フラグ

                m_bChengeAns = false;

            }

            catch (Exception ex)

            {

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

            }

        }

        /// <summary>

        /// 画面項目のチェック

        /// </summary>

        /// <returns></returns>

        private bool DispFeildCheck()

        {

            bool bRet = true;

            bool bAns = true;

            try

            {

                foreach (DataGridViewRow r in dgvMaster.Rows)

                {

                    //名称

                    bAns = true;

                    if (CommonMotions.chkObjectIsNull(r.Cells[(int)DispColumn.NameString].Value)) continue;

                    if (r.Cells[(int)DispColumn.NameString].Value.ToString().Length == 0) continue;

                    // レングスチェック

                    bAns = CommonMotions.chkStringLength(r.Cells[(int)DispColumn.NameString].Value.ToString(), 100);

                    // 背景色変更

                    CommonMotions.chgBackColor(r.Cells[(int)DispColumn.NameString], bAns);

                    bRet &= bAns;

                }

                if (!bRet)

                {

                    MessageBox.Show("入力エラーがあります、確認してください。", "データ確認"

                                                , MessageBoxButtons.OK, MessageBoxIcon.Warning);

                }

                return bRet;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

      }

        /// <summary>

        /// 工事種別データ登録

        /// </summary>

        private void ConstructionTypeMasterDataEntry()

        {

            IOMConstructionType ctDB = new IOMConstructionType();

            try

            {

                // 番号降り直し

                int ino = 0;

                foreach (DataGridViewRow r in dgvMaster.Rows)

                {

                    // 入力無は処理しない

                    if (CommonMotions.chkObjectIsNull(r.Cells[(int)DispColumn.NameString].Value)) continue;

                    // 番号セット

                    r.Cells[(int)DispColumn.No].Value = (++ino).ToString();

                }

                //// 一括処理なので接続を行う

                ctDB.connect();

                ctDB.beginTran();

                // データを画面より取得

                foreach (DataGridViewRow r in dgvMaster.Rows)

                {

                    // 入力無は処理しない

                    if (CommonMotions.chkObjectIsNull(r.Cells[(int)DispColumn.NameString].Value)) continue;

                    if (r.Cells[(int)DispColumn.NameString].Value.ToString().Length == 0) continue;

                    ConstructionTypeMaster ctRec = new ConstructionTypeMaster();

                    // データセット

                    ctRec.NameString = r.Cells[(int)DispColumn.NameString].Value.ToString();

                    ctRec.DisplayOrder = int.Parse(r.Cells[(int)DispColumn.No].Value.ToString());

                    ctRec.DeleteFlg = 0;

                    // データセット

                    if (CommonMotions.chkCellBlank(r.Cells[(int)DispColumn.TypeCode].Value))

                    {

                        // 新規時キーセット

                        // 履歴がない場合は過去の最大値をとる

                        ctRec.TypeCode = ctDB.SelectMaxCategoryHistoryCount(string.Empty, false) + 1;

                    }

                    else

                    {

                        ctRec.TypeCode = int.Parse(r.Cells[(int)DispColumn.TypeCode].Value.ToString());

                    }

                    ctRec.DisplayOrder = int.Parse(r.Cells[(int)DispColumn.No].Value.ToString());

                    ctRec.NameString = r.Cells[(int)DispColumn.NameString].Value.ToString();

                    // SQL作成

                    string strSelect = ctDB.CreatePrimarykeyString(ctRec.TypeCode);

                    List<ConstructionTypeMaster> ctList = new List<ConstructionTypeMaster>();

                    // 業種マスタ取得

                    if (!ctDB.SelectAction(strSelect, ref ctList, false))

                    {

                        ctDB.rollback();

                        MessageBox.Show("登録確認に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        return;

                    }

                    if (ctList.Count == 0)

                    {

                        // データがない場合は追加

                        ctList.Clear();

                        ctList.Add(ctRec);

                        // データ登録

                        if (!ctDB.InsertAction(ctList, false))

                        {

                            ctDB.rollback();

                            MessageBox.Show("登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                            return;

                        }

                    }

                    else

                    {

                        // データ登録

                        if (!ctDB.UpdateAction(strSelect, ctRec, false))

                        {

                            ctDB.rollback();

                            MessageBox.Show("更新に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                            return;

                        }

                    }

                }

                // 成功したらcommit

                ctDB.commit();

            }

            catch (System.Exception ex)

            {

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

            }

            finally

            {

                ctDB.close();

                ctDB = null;

            }

        }

        /// <summary>

        /// 名称マスタ表示

        /// </summary>

        /// <returns></returns>

        private bool DispGridData()

        {

            IOMConstructionType cmDB = new IOMConstructionType();

            List<ConstructionTypeMaster> cm = new List<ConstructionTypeMaster>();

            try

            {

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

                dgvMaster.Rows.Clear();

                // SQL作成

                string strSQL = " Where DeleteFlg = 0 Order By DisplayOrder ASC";

                // 表示順マスタ取得

                if (!cmDB.SelectAction(strSQL, ref cm)) return false;

                // データ表示

                int icnt = 0;

                foreach (ConstructionTypeMaster work in cm)

                {

                    dgvMaster.Rows.Add((icnt + 1)

                                        , work.TypeCode

                                        , work.NameString.ToString()

                                        , 0);

                    dgvMaster.Rows[icnt++].Cells[(int)DispColumn.NameString].ToolTipText = work.NameString.ToString();

                }

                // №再採番

                LineReNumbering();

                // 表示行が足りない場合は追加する

                if (dgvMaster.Rows.Count <= CommonDefine.s_MaxInitLineCountMastamente)

                {

                    int iAddLine = CommonDefine.s_MaxInitLineCountMastamente - dgvMaster.Rows.Count;

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

                    {

                        dgvMaster.Rows.Add();

                    }

                }

                dgvMaster.Rows.Add();

                // クリアデータセット

                SetRowClearData(dgvMaster.Rows.Count - 1);

                // 読込時データカウント取得

                m_initDataCount = cm.Count;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

            finally

            {

                cmDB.close();

                cmDB = null;

            }

        }

        /// <summary>

        /// グリッド最終行での処理

        /// </summary>

        private void GridLastLine()

        {

            // 最終行判定

            if (dgvMaster.CurrentCell.RowIndex == dgvMaster.Rows.Count - 1)

            {

                // 最終列判定

                if (dgvMaster.CurrentCell.ColumnIndex == (int)DispColumn.NameString)

                {

                    // 1行追加

                    dgvMaster.Rows.Add();

                    // クリアデータセット

                    SetRowClearData(dgvMaster.Rows.Count - 1);

                    // №再採番

                    LineReNumbering();

                }

            }

        }

        #endregion

    }

}

<?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>