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

        #region 工事詳細台帳：請求金額更新処理

        /// <summary>

        /// 工事詳細台帳：請求金額更新処理

        /// </summary>

        /// <param name="LedgerDB">工事詳細台帳テーブル</param>

        /// <param name="ExecDB">工事詳細台帳実行テーブル</param>

        /// <param name="nConstrCode">工事番号</param>

        /// <param name="TargetMonth">対象年月</param>

        /// <param name="lValue">請求金額</param>

        /// <param name="DspMsg">メッセージ表示フラグ</param>

        /// <returns></returns>

        public static bool ModifyReceiveMoney(IOConstructionLedger LedgerDB

                                                , IOConstructionLedgerExcute ExecDB

                                                , int nConstrCode

                                                , string TargetMonth

                                                , long lValue

                                                , bool DspMsg = true)

        {

            try

            {

                // 詳細台帳データを取得する

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(LedgerDB.CreatePrimarykeyString(nConstrCode));

                ConstructionLedger LedgerRec = new ConstructionLedger();

                if (!LedgerDB.SelectAction(strSQL.ToString(), ref LedgerRec, false))

                {

                    if (DspMsg)

                    {

                        MessageBox.Show("工事詳細台帳データ：台帳データ取得に失敗しました。"

                                        , "データ取得エラー"

                                        , MessageBoxButtons.OK

                                        , MessageBoxIcon.Error);

                    }

                    return false;

                }

                // 現在の処理年月をDateTime型に変換する

                DateTime NowDates = CommonMotions.cnvDate(string.Format("{0}/01", TargetMonth));

                // 経過月数より列番号取得する

                int ColCnt = CalcTargetMonthToColumn(LedgerRec.ConstructionStart, NowDates);

                // 工事詳細台帳実行データ読込み

                int nGroupNo = (int)FrmConstructionLedger.DataGroup.BillingAmount;

                strSQL.Clear();

                strSQL.Append("Select");

                strSQL.Append(" A.ConstructionCode");           // 0

                strSQL.Append(", A.GroupCount");                // 1

                strSQL.Append(", A.LineCount");                 // 2

                strSQL.Append(", ifnull(B.ColumnCount, -1)");   // 3

                strSQL.Append(", B.PaymentAmount");             // 4

                strSQL.Append(", B.TargetMonth");               // 5

                strSQL.Append(", A.FirstString");               // 6

                strSQL.Append(", A.SecondString");              // 7

                strSQL.Append(" From constructionledgerdetail As A");

                strSQL.Append("      Left Join constructionledgerexcute As B");

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

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

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

                strSQL.AppendFormat("      And B.ColumnCount = {0}", ColCnt);

                strSQL.AppendFormat(" Where A.ConstructionCode = {0}", nConstrCode);

                strSQL.AppendFormat(" And A.GroupCount = {0}", nGroupNo);

                ArrayList ExecList = new ArrayList();

                if (!ExecDB.ExecuteReader(strSQL.ToString(), ref ExecList, false))

                {

                    if (DspMsg)

                    {

                        MessageBox.Show("工事詳細台帳明細データ：請求金額データ取得に失敗しました。"

                                        , "データ取得エラー"

                                        , MessageBoxButtons.OK

                                        , MessageBoxIcon.Error);

                    }

                    return false;

                }

                if (ExecList.Count < 1) return false;

                object[] ObjRec = (object[])ExecList[0];

                int nLineCnt = CommonMotions.cnvInt(ObjRec[2]);

                // カラム番号がマイナス（実行データが無い時）か否かで作成・更新を判定する

                if (CommonMotions.cnvInt(ObjRec[3]) >= 0)

                {

                    strSQL.Clear();

                    strSQL.Append(ExecDB.CreatePrimarykeyString(nConstrCode

                                                                , nGroupNo

                                                                , nLineCnt

                                                                , ColCnt));

                    // 金額更新

                    if (!ExecDB.UpdateFeild(strSQL.ToString()

                                            , (int)IOConstructionLedgerExcute.TableColumn.PaymentAmount

                                            , lValue

                                            , false))

                    {

                        if (DspMsg)

                        {

                            MessageBox.Show("工事詳細台帳実行データ：請求金額更新に失敗しました。"

                                            , "更新エラー"

                                            , MessageBoxButtons.OK

                                            , MessageBoxIcon.Error);

                        }

                        return false;

                    }

                }

                else

                {   // 請求データがあるのでここには来ないはず

                    ConstructionLedgerExcute ExecRec = new ConstructionLedgerExcute();

                    ExecRec.ConstructionCode = nConstrCode;	        // 工事コード

                    ExecRec.GroupCount = nGroupNo;                  // グループ番号

                    ExecRec.LineCount = nLineCnt;                   // 行番号

                    ExecRec.ColumnCount = ColCnt;                   // 列番号

                    ExecRec.PaymentAmount = (double)lValue;         // 支払金額

                    ExecRec.TargetMonth = NowDates;                 // 対象年月

                    if (!ExecDB.InsertAction(ExecRec, false))

                    {

                        if (DspMsg)

                        {

                            MessageBox.Show("工事詳細台帳実行データ：請求金額登録に失敗しました。"

                                            , "登録エラー"

                                            , MessageBoxButtons.OK

                                            , MessageBoxIcon.Error);

                        }

                        return false;

                    }

                }

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

        }

        #endregion

                        case (int)ProcessExecuteNo.ReqApprovalStatus:                   // 47:請求承認状況閲覧 add suzuki 2018/08/08

                if (CommonMotions.LoginUserProcExe.Count < 1)

                {

                    // 読込リストが存在しない場合はテーブル読込

                    return GetExecutePermission(CommonMotions.LoginUserData.PersonCode, ExecCode, ref Editflg);

                }

                // 読込リストが存在した場合はリストより検索

                foreach (ProcessExcute CurRec in CommonMotions.LoginUserProcExe)

                    if (ExecCode != CurRec.ExecCode) continue;

                    bRet = true;

                    Editflg = CurRec.EditFlg;

                    break;

            FrmInputDate frm = new FrmInputDate();

                if (frm.ShowDialog(this) == DialogResult.Cancel) return;

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

                if(!RePetitionExec(pAppDB, m_ApprovalCode, frm.ExcuteDate))

                // ??Z????E??Z?\?Z??????\??????

                if(!RePetitionRequestEstimate(pAppDB, m_ApprovalCode, frm.ExcuteDate))

                frm.Dispose(); frm = null;

                    case (int)CommonDefine.ApprovalStatus.Petition:         // 申請

                    case (int)CommonDefine.ApprovalStatus.Pending:          // 保留

                    case (int)CommonDefine.ApprovalStatus.Approval:         // 承認

                    case (int)CommonDefine.ApprovalStatus.NotApproval:      // 不承認

                        btnPetition.Visible = false;                        // 申請ボタン

                        txtHoppesDate.Enabled = false;                      // 承認希望日

                        btnApproval.Visible = true;                         // 承認ボタン

                        btnNotApproval.Visible = true;                      // 不承認ボタン

                        btnOnHold.Visible = true;                           // 保留ボタン

                    case (int)CommonDefine.ApprovalStatus.Undecided:        // 未定

                    case (int)CommonDefine.ApprovalStatus.Unclaimed:        // 未申請

                        btnPetition.Visible = true;                         // 申請ボタン

                        btnRePetition.Visible = false;                      // 再申請ボタン

                        btnNotPetition.Visible = false;                     // 申請取消ボタン

                        txtHoppesDate.Enabled = true;                       // 承認希望日

                        btnApproval.Visible = false;                        // 承認ボタン

                        btnNotApproval.Visible = false;                     // 不承認ボタン

                        btnOnHold.Visible = false;                          // 保留ボタン

        #region 再申請処理

        /// <summary>

        /// 再申請処理

        /// </summary>

        /// <returns></returns>

        private bool RePetitionExec(IOProcessApproval pAppDB, int CurApprovalCode, DateTime dtPetitionDate)

        {

            try

            {

                // 承認データを一気に削除する

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("DELETE FROM ProcessApproval");

                strSQL.Append(pAppDB.CreatePrimarykeyString(m_ConstructionCode, CurApprovalCode, m_OrderNo));

                strSQL.AppendFormat(" AND (SeqNo > 1 And PersonCode != {0})", CommonMotions.LoginUserData.PersonCode);

                pAppDB.ExecuteNonQuery(strSQL.ToString(), false);

                // 申請データを申請中に戻す

                if (!pAppDB.UpdateFeild(m_ConstructionCode,

                                    (int)IOProcessApproval.ColumnName.ApprovalStatus,

                                    (int)CommonDefine.ApprovalStatus.Petition,

                                    false,

                                    CurApprovalCode,

                                    m_OrderNo,

                                    1))

                {

                    MessageBox.Show("再申請データリセットに失敗しました。", "再申請エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                // 承認希望日をセットする

                if (!pAppDB.UpdateFeild(m_ConstructionCode,

                                    (int)IOProcessApproval.ColumnName.ApprovalLimitDates,

                                    dtPetitionDate,

                                    false,

                                    CurApprovalCode,

                                    m_OrderNo,

                                    1))

                {

                    MessageBox.Show("再申請データリセットに失敗しました。", "再申請エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 積算見積・積算予算を同時に再申請する

        /// <summary>

        /// 積算見積・積算予算を同時に再申請する

        /// </summary>

        private bool RePetitionRequestEstimate(IOProcessApproval pAppDB, int CurApprovalCode, DateTime dtPetitionDate)

        {

            try

            {

                // ----- 積算見積・積算予算は同時に申請を行う

                int Code1 = ClsExcute.AppovalList.First(x => x.Value.Equals("積算見積書承認")).Key;

                int Code2 = ClsExcute.AppovalList.First(x => x.Value.Equals("積算予算書承認")).Key;

                int NextApprovalCode = -1;

                if (CurApprovalCode == Code1)

                {

                    // ----- 積算見積書の申請時は積算予算書も申請する

                    // 積算予算データが存在しなかった場合は申請しない

                    if (!ExistEstimateBudget()) return true;

                    // コードのセット

                    NextApprovalCode = Code2;

                }

                else if (CurApprovalCode == Code2)

                {

                    // ----- 積算予算書の申請時は積算見積書は必ずあるので申請する

                    // コードのセット

                    NextApprovalCode = Code1;

                }

                else

                {

                    return true;

                }

                // 再申請のためデータを作成する

                if (!RePetitionExec(pAppDB, NextApprovalCode, dtPetitionDate)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

namespace ProcessManagement.Forms.DataEntry

{

    partial class FrmInputDate

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

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

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

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

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

            this.panel1 = new System.Windows.Forms.Panel();

            this.panel2 = new System.Windows.Forms.Panel();

            this.dtInput = new System.Windows.Forms.DateTimePicker();

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

            this.panel1.SuspendLayout();

            this.panel2.SuspendLayout();

            this.SuspendLayout();

            // 

            // btnExecProc

            // 

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

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

            this.btnExecProc.Location = new System.Drawing.Point(98, 1);

            this.btnExecProc.Name = "btnExecProc";

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

            this.btnExecProc.TabIndex = 0;

            this.btnExecProc.Text = "変　更";

            this.btnExecProc.UseVisualStyleBackColor = false;

            this.btnExecProc.Click += new System.EventHandler(this.btnExecProc_Click);

            // 

            // btnCancel

            // 

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

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

            this.btnCancel.Location = new System.Drawing.Point(238, 1);

            this.btnCancel.Name = "btnCancel";

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

            this.btnCancel.TabIndex = 3;

            this.btnCancel.Text = "キャンセル";

            this.btnCancel.UseVisualStyleBackColor = false;

            this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);

            // 

            // panel1

            // 

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

            this.panel1.Controls.Add(this.btnCancel);

            this.panel1.Controls.Add(this.btnExecProc);

            this.panel1.Location = new System.Drawing.Point(0, 116);

            this.panel1.Name = "panel1";

            this.panel1.Size = new System.Drawing.Size(382, 42);

            this.panel1.TabIndex = 3;

            // 

            // panel2

            // 

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

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

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

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

            this.panel2.Location = new System.Drawing.Point(2, 4);

            this.panel2.Name = "panel2";

            this.panel2.Size = new System.Drawing.Size(376, 107);

            this.panel2.TabIndex = 16;

            // 

            // dtInput

            // 

            this.dtInput.DropDownAlign = System.Windows.Forms.LeftRightAlignment.Right;

            this.dtInput.Font = new System.Drawing.Font("Century", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.dtInput.Format = System.Windows.Forms.DateTimePickerFormat.Short;

            this.dtInput.ImeMode = System.Windows.Forms.ImeMode.Off;

            this.dtInput.Location = new System.Drawing.Point(101, 50);

            this.dtInput.Name = "dtInput";

            this.dtInput.Size = new System.Drawing.Size(170, 33);

            this.dtInput.TabIndex = 17;

            // 

            // label1

            // 

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

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

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

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(240, 28);

            this.label1.TabIndex = 18;

            this.label1.Text = "再 承 認 希 望 日";

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

            // 

            // FrmInputDate

            // 

            this.AcceptButton = this.btnExecProc;

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

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

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

            this.ClientSize = new System.Drawing.Size(380, 157);

            this.Controls.Add(this.panel2);

            this.Controls.Add(this.panel1);

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

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

            this.KeyPreview = true;

            this.MaximizeBox = false;

            this.MinimizeBox = false;

            this.Name = "FrmInputDate";

            this.ShowIcon = false;

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

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

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

            this.panel1.ResumeLayout(false);

            this.panel2.ResumeLayout(false);

            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.Button btnExecProc;

        private System.Windows.Forms.Button btnCancel;

        private System.Windows.Forms.Panel panel1;

        private System.Windows.Forms.Panel panel2;

        private System.Windows.Forms.DateTimePicker dtInput;

        private System.Windows.Forms.Label label1;

    }

}

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 ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.Forms.CustomControls;

using ProcessManagement.Forms.ControlsAction;

namespace ProcessManagement.Forms.DataEntry

{

    public partial class FrmInputDate : Form

    {

        #region ログ使用定義

        //log4netログを使用する

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

        #endregion

        #region 定数

        private enum Dispcount

        {

            ExeCuteDate = 0,

            ProgressStatusA,

            ProgressStatusB,

            radioButtonA1,

            radioButtonA2,

            radioButtonA3,

        }

        #endregion

        #region 変数

        /// <summary>

        /// 実行時日付

        /// </summary>

        private DateTime m_ExcuteDate = DateTime.Now;

        #endregion

        #region プロパティ

        /// <summary>

        /// 実行時時間

        /// </summary>

        public DateTime ExcuteDate

        {

            get { return m_ExcuteDate; }

            set { m_ExcuteDate = value; }

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// フォーム初期化

        /// </summary>

        public FrmInputDate()

        {

            InitializeComponent();

        }

        #endregion

        #region フォームロード

        /// <summary>

        /// フォームロード

        /// </summary>

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

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

        private void FrmInputDate_Load(object sender, EventArgs e)

        {

            // フォームサイズ固定

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

            dtInput.Value = m_ExcuteDate;

        }

        #endregion

        #region フォームクロージング

        /// <summary>

        /// フォームクロージング

        /// </summary>

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

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

        private void FrmInputDate_FormClosing(object sender, FormClosingEventArgs e)

        {

            try

            {

                if (this.DialogResult != DialogResult.OK) this.DialogResult = DialogResult.Cancel;

            }

            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 btnCancel_Click(object sender, EventArgs e)

        {

            this.DialogResult = DialogResult.Cancel;

            this.Close();

        }

        #endregion

        #region 変更ボタン

        /// <summary>

        /// 変更ボタン押下

        /// </summary>

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

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

        private void btnExecProc_Click(object sender, EventArgs e)

        {

            try

            {

                if(dtInput.Value.Date < DateTime.Today.Date)

                {

                    MessageBox.Show("承認希望日が過去日付になっています。","日付選択エラー",MessageBoxButtons.OK,MessageBoxIcon.Error);

                    return;

                }

                m_ExcuteDate = dtInput.Value;

                this.DialogResult = DialogResult.OK;

                this.Close();

            }

            catch (Exception ex)

            {

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

            }

        }

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

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

</root>

            TestDataTest();

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

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

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

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

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

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

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

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

            // lblCellTotal

            // 

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

            this.lblCellTotal.AutoSize = true;

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

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

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

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

            this.lblCellTotal.Name = "lblCellTotal";

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

            this.lblCellTotal.TabIndex = 36;

            // 

            // btnDispDown

            // 

            this.btnDispDown.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            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(1300, 418);

            this.btnDispDown.Name = "btnDispDown";

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

            this.btnDispDown.TabIndex = 42;

            this.btnDispDown.TabStop = false;

            this.btnDispDown.Text = "▼";

            this.btnDispDown.UseVisualStyleBackColor = true;

            this.btnDispDown.Visible = false;

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

            // 

            // btnDispUp

            // 

            this.btnDispUp.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            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(1300, 354);

            this.btnDispUp.Name = "btnDispUp";

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

            this.btnDispUp.TabIndex = 41;

            this.btnDispUp.TabStop = false;

            this.btnDispUp.Text = "▲";

            this.btnDispUp.UseVisualStyleBackColor = true;

            this.btnDispUp.Visible = false;

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

            // 

            // btnOtherProc

            // 

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

            this.btnOtherProc.BackColor = System.Drawing.Color.SpringGreen;

            this.btnOtherProc.Location = new System.Drawing.Point(7, 656);

            this.btnOtherProc.Name = "btnOtherProc";

            this.btnOtherProc.Size = new System.Drawing.Size(160, 30);

            this.btnOtherProc.TabIndex = 95;

            this.btnOtherProc.TabStop = false;

            this.btnOtherProc.Text = "他の画面へ";

            this.btnOtherProc.UseVisualStyleBackColor = false;

            this.btnOtherProc.Click += new System.EventHandler(this.btnOtherProc_Click);

            // 

            // button1

            // 

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

            this.button1.Location = new System.Drawing.Point(1300, 540);

            this.button1.Name = "button1";

            this.button1.Size = new System.Drawing.Size(37, 35);

            this.button1.TabIndex = 100;

            this.button1.Text = "○";

            this.button1.UseVisualStyleBackColor = true;

            this.button1.Visible = false;

            this.button1.Click += new System.EventHandler(this.button1_Click);

            // 

            // button2

            // 

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

            this.button2.Location = new System.Drawing.Point(1300, 581);

            this.button2.Name = "button2";

            this.button2.Size = new System.Drawing.Size(37, 35);

            this.button2.TabIndex = 101;

            this.button2.Text = "１";

            this.button2.UseVisualStyleBackColor = true;

            this.button2.Visible = false;

            this.button2.Click += new System.EventHandler(this.button2_Click);

            // 

            // btnSelect

            // 

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

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

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

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

            this.btnSelect.Location = new System.Drawing.Point(546, 657);

            this.btnSelect.Name = "btnSelect";

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

            this.btnSelect.TabIndex = 102;

            this.btnSelect.Text = "選　択";

            this.btnSelect.UseVisualStyleBackColor = false;

            this.btnSelect.Visible = false;

            this.btnSelect.Click += new System.EventHandler(this.btnSelect_Click);

            // 

            // btnCreate

            // 

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

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

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

            this.btnCreate.ForeColor = System.Drawing.Color.Green;

            this.btnCreate.Location = new System.Drawing.Point(420, 657);

            this.btnCreate.Name = "btnCreate";

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

            this.btnCreate.TabIndex = 103;

            this.btnCreate.Text = "新　規";

            this.btnCreate.UseVisualStyleBackColor = false;

            this.btnCreate.Visible = false;

            this.btnCreate.Click += new System.EventHandler(this.btnCreate_Click);

            // 

        #region ※．テストロジック↓↓

        // ---------- ※．テストロジック↓↓

        private void TestDataTest()

        {

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            IOConstructionLedgerExcute ExecDB = new IOConstructionLedgerExcute();

            try

            {

                LedgerDB.connect(); LedgerDB.beginTran();

                ExecDB.connect(); ExecDB.beginTran();

                bool bret = ClsChangeLedgerData.ModifyReceiveMoney(LedgerDB

                                                , ExecDB

                                                , m_ConstructionCode

                                                , "2018/10"

                                                , 100000);

                if (!bret)

                {

                    LedgerDB.rollback();

                    ExecDB.rollback();

                }

                LedgerDB.commit();

                ExecDB.commit();

            }

            catch (System.Exception ex)

            {

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

            }

            finally

            {

                LedgerDB.close(); LedgerDB = null;

                ExecDB.close(); ExecDB = null;

            }

        }

        // ---------- ※．テストロジック↑↑

        #endregion

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

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

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

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

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

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

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

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

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

                // 製品版は以下を処理しない

                if (ProductDefine.ProductType != (int)ProductDefine.ProductTypeDef.Originals) return;

                if (dCnt != 0 && strUnitName.Length > 0)

                int nConstrCode = CommonMotions.cnvIntFromStringCode(m_dispLabelControl[(int)DispLabel.ConstructionCode].Text, "-");

                string DelSQL = edDB.CreatePrimarykeyString(nConstrCode);

                List<EstimateData> workList = new List<EstimateData>();

                    work.ConstructionCode = nConstrCode;

                    workList.Add(work);

                // データ登録

                if (!edDB.InsertAction(workList, false))

                {

                    LogicalErrorMessage("積算見積データ：登録に失敗しました。", "登録エラー", CommonMotions.GetMethodName());

                    return false;

                }

                int nConstrCode = CommonMotions.cnvIntFromStringCode(m_dispLabelControl[(int)DispLabel.ConstructionCode].Text, "-");

                string DelSQL = edbDB.CreatePrimarykeyString(nConstrCode);

                List<EstimateDataBody> workList = new List<EstimateDataBody>();

                    work.ConstructionCode = nConstrCode;

                    workList.Add(work);

                } // iTabs

                // データ登録

                if (!edbDB.InsertAction(workList, false))

                {

                    LogicalErrorMessage("登録に失敗しました。", "登録エラー", CommonMotions.GetMethodName());

                    return false;

                }

                int nConstrCode = CommonMotions.cnvIntFromStringCode(m_dispLabelControl[(int)DispLabel.ConstructionCode].Text, "-");

                string DelSQL = eddDB.CreatePrimarykeyString(nConstrCode);

                List<EstimateDataDetail> workList = new List<EstimateDataDetail>();

                    //for (int iRows = 0; iRows < wrkGrid.RowCount; iRows++)

                    bool bDataOn = false;

                    for (int iRows = (wrkGrid.RowCount - 1); iRows >= 0; iRows--)

                        if (!bDataOn && !ChkGridLineEffectiveness(wrkRows)) continue;

                        bDataOn = true;

                        work.ConstructionCode = nConstrCode;

                        workList.Add(work);

                // データ登録

                if (!eddDB.InsertAction(workList, false))

                {

                    LogicalErrorMessage("登録に失敗しました。", "登録エラー", CommonMotions.GetMethodName());

                    return false;

                }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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