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

                CommonMotions.SendMessage(txtInput06.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ????L??????

                CommonMotions.SendMessage(txtInput12.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ?H???J?n??

                CommonMotions.SendMessage(txtInput13.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ?H???I????

                CommonMotions.SendMessage(txtInput25.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ??????????z

                CommonMotions.SendMessage(txtInput28.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ??????????z

                CommonMotions.SendMessage(txtInput34.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ?????\???

                CommonMotions.SendMessage(txtInput35.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ?{?H?J?n??

                CommonMotions.SendMessage(txtInput38.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ?J?n?\???

                CommonMotions.SendMessage(textBoxEX3.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ?{?H?????J?n??

                CommonMotions.SendMessage(textBoxEX6.Handle, 5377, new IntPtr(showFocus ? 1 : 0), CommonDefine.s_UndecidedString);			// ?????m?F??

                txtInput06.Text = CommonDefine.s_UndecidedString;			// ????L??????

                txtInput12.Text = CommonDefine.s_UndecidedString;			// ?H???J?n??

                txtInput13.Text = CommonDefine.s_UndecidedString;			// ?H???I????

                txtInput25.Text = CommonDefine.s_UndecidedString;			// ??????????z

                txtInput28.Text = CommonDefine.s_UndecidedString;			// ??????????z

                txtInput34.Text = CommonDefine.s_UndecidedString;			// ?????\???

                txtInput35.Text = CommonDefine.s_UndecidedString;			// ?{?H?J?n??

                txtInput38.Text = CommonDefine.s_UndecidedString;			// ?J?n?\???

                textBoxEX3.Text = CommonDefine.s_UndecidedString;		    // ?{?H?????J?n??

                textBoxEX6.Text = CommonDefine.s_UndecidedString;			// ?????m?F??

                DateTime wrkDate = DateTime.Today;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.EstimatesSubmittedDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.ConstructionStartingDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.ProvisionalOrderDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.OrderDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.TransferConstructionDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.PreparationStartDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.ConstructionStartingDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.ConstructionCompletionDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.BillingStartDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.BillingComplateDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.NonOrderDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.ConstructionStartingDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                        wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.ConstructionStartingDate].Text).Date;

                        if (wrkDate != DateTime.MinValue.Date) break;

                DateTime wrkDate = DateTime.Today;

                wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.RevCompleteDate].Text).Date;

                if (wrkDate == DateTime.MinValue.Date)

                    m_DspCtrl[(int)DspCnt.RevCompleteDate].Enabled = true;

                wrkDate = CommonMotions.cnvUndecidedStringToDate(m_DspCtrl[(int)DspCnt.BillingComplateDate].Text).Date;

                if (wrkDate == DateTime.MinValue.Date)

                    m_DspCtrl[(int)DspCnt.BillingComplateDate].Enabled = true;

            SetBaseCompDate();

            //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 工事基本情報請求完了日セット

        /// <summary>

        /// 工事基本情報請求完了日セット

        /// </summary>

        private void SetBaseCompDate()

        {

            IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

            try

            {

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("Select A.ConstructionCode, DATE(A.ChangeDate) From constructionprogressdate As A");

                strSQL.Append(" Where A.ConstructionCode IN(");

                strSQL.Append("                            Select B.ConstructionCode From constructionbaseinfo As B");

                strSQL.Append("                            Where B.ConstructionStatusFlg = 10");

                strSQL.Append("                            And DATE (B.BillingDate) = DATE('0001/01/01'))");

                strSQL.Append(" And A.ConstructionStatusFlg = 10");

                strSQL.Append(" Order By A.ConstructionCode");

                ArrayList arList = new ArrayList();

                BaseDB.ExecuteReader(strSQL.ToString(), ref arList);

                BaseDB.connect(); BaseDB.beginTran();

                int cnt = 0;

                foreach (object[] objRec in arList)

                {

                    int nCode = CommonMotions.cnvInt(objRec[0]);

                    DateTime wrkDT = CommonMotions.cnvDate(objRec[1]);

                    if(!BaseDB.UpdateFeild(nCode,(int)IOConstructionBaseInfo.TableColumn.BillingDate,wrkDT,false))

                    {

                        BaseDB.rollback();

                        MessageBox.Show("更新エラー");

                        break;

                    }

                    cnt++;

                }

                MessageBox.Show(string.Format("終了件数：{0}", cnt));

                BaseDB.commit();

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                BaseDB.close(); BaseDB = null;

            }

        }

        #endregion

        #region 台帳日付セットテスト

        #endregion

                sql.Append("SELECT InvData.* FROM InvoiceData As InvData");

                sql.Append("                      Inner Join RequestHead As ReqHead");

                sql.Append("                             On ReqHead.InvoiceNo = InvData.InvoiceNo");

                sql.Append("                      Inner Join constructionbaseinfo As Base");

                sql.Append("                             On Base.ConstructionCode = ReqHead.REQCONSTRUCTIONCODE");

                sql.AppendFormat("                       And Base.BillingSplitFlg = {0}", m_ExecuteSubFlg);

                ArrayList arData = new ArrayList();

                if (!ioInvData.ExecuteReader(sql.ToString(), ref arData)) return;

                foreach (object[] objwrk in arData)

                {

                    InvoiceData work = new InvoiceData();

                    ioInvData.Reader2Struct(objwrk, ref work);

                    InvoiceList.Add(work);

                }

                // データセット

                sql.Append("           Inner Join constructionbaseinfo As Base");

                sql.Append("                  On Base.ConstructionCode = A.REQCONSTRUCTIONCODE");

                sql.AppendFormat("            And Base.BillingSplitFlg = {0}", m_ExecuteSubFlg);

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

            // lblProcessTitil

            // 

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

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

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

            this.lblProcessTitil.Name = "lblProcessTitil";

            this.lblProcessTitil.Size = new System.Drawing.Size(300, 20);

            this.lblProcessTitil.TabIndex = 32;

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

            // 

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

            this.cmbReqMonth.MaxDropDownItems = 12;

                strSQL.AppendFormat(" AND Base.BILLINGSPLITFLG = {0}", m_ExecuteSubFlg);

                    strSQL.AppendFormat(" And ReqHead.ORDERERSDIVISION = {0}", cmbOrderer.SelectedValue);