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

        public static int s_SystemVersion = 45;

                strcmd.Append(" MaterialItemCode,DATE_FORMAT(ProcessDate, '%Y/%m/%d %H:%i:%s'),SeqNo,RecKind,ConstructionCode,PersonCode,MaterialCount,DATE_FORMAT(RepayPlanDate, '%Y/%m/%d %H:%i:%s'),CommentText");

                    strcmd.Append(" VALUES (");

                strcmd.Append(" SET");

                // ???????B??o????^??\???????

                if (numUDConstPro.Value <= CommonMotions.SystemMasterData.BusinessPeriod)

                    // ???^???W?v????

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

                    {

                        // ?J?n?E?I??????????????f?t?H???g?????E???????g?p????

                        stDate = dtStartArray[i];

                        edDate = dtMaxCompArray[i];

                        CalcStartCompDate(dtDefaultStart, dtDefaultEnd, dtHireStDayArray[i], dtHireEdDayArray[i], ref stDate, ref edDate);

                        // ???^????

                        int workSalary = CommonMotions.CalcElapsedSalary(SalaryDB, stDate, edDate, PersonCDArray[i]);

                        // ??v???Z

                        TotalSalary += workSalary;

                        // ?\?????t??

                        if (DspSTDate > stDate) DspSTDate = stDate;

                        if (DspEdDate < edDate) DspEdDate = edDate;

                    }

                // ???????B??o????^??\???????

                if (numUDConstPro.Value <= CommonMotions.SystemMasterData.BusinessPeriod)

                    // ???^???W?v????

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

                    {

                        // ?J?n?E?I??????????????f?t?H???g?????E???????g?p????

                        stDate = dtStartArray[i];

                        edDate = dtMaxCompArray[i];

                        CalcStartCompDate(dtDefaultStart, dtDefaultEnd, dtHireStDayArray[i], dtHireEdDayArray[i], ref stDate, ref edDate);

                        // ???^????

                        int workSalary = CommonMotions.CalcElapsedSalary(SalaryDB, stDate, edDate, PersonCDArray[i]);

                        // ??v???Z

                        TotalSalary += workSalary;

                        // ?\?????t??

                        if (DspSTDate > stDate) DspSTDate = stDate;

                        if (DspEdDate < edDate) DspEdDate = edDate;

                    }

                StringBuilder strChkExists = new StringBuilder();

                ProcessExcute ExecRec = new ProcessExcute();

                        // 以下の処理は一覧を起動許可にする

                        switch (iSecCode)

                        {

                            case (int)ClsExcute.ProcessExecuteNo.MaterialReserveEntry:      // 26:資材貸出

                            case (int)ClsExcute.ProcessExecuteNo.MaterialReturnEntry:       // 27:資材返却

                                strChkExists.Clear();

                                strChkExists.Append(exeDB.CreatePrimarykeyString((int)ClsExcute.ProcessExecuteNo.MaterialEntrylList));

                                if (!exeDB.SelectAction(strChkExists.ToString(), ref ExecRec, false))

                                {

                                    // 起動処理番号

                                    wrk.ExecCode = (int)ClsExcute.ProcessExecuteNo.MaterialEntrylList;

                                    // データ作成

                                    exeDB.InsertAction(wrk, false);

                                }

                                break;

                        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            // ApprovalColumn02

            // 

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

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

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

            this.ApprovalColumn02.DefaultCellStyle = dataGridViewCellStyle15;

            this.ApprovalColumn02.Frozen = true;

            this.ApprovalColumn02.HeaderText = "工事コード";

            this.ApprovalColumn02.Name = "ApprovalColumn02";

            this.ApprovalColumn02.ReadOnly = true;

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

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

            this.ApprovalColumn02.Visible = false;

            this.ApprovalColumn02.Width = 5;

            // 

            // ApprovalColumn12

            // 

            this.ApprovalColumn12.Frozen = true;

            this.ApprovalColumn12.HeaderText = "承認機能番号";

            this.ApprovalColumn12.Name = "ApprovalColumn12";

            this.ApprovalColumn12.ReadOnly = true;

            this.ApprovalColumn12.Visible = false;

            this.ApprovalColumn12.Width = 5;

            // 

            // Column32

            // 

            this.Column32.Frozen = true;

            this.Column32.HeaderText = "受付番号";

            this.Column32.Name = "Column32";

            this.Column32.ReadOnly = true;

            this.Column32.Visible = false;

            this.Column32.Width = 5;

            // 

            // ApprovalColumn01

            // 

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

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

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

            this.ApprovalColumn01.DefaultCellStyle = dataGridViewCellStyle16;

            this.ApprovalColumn01.Frozen = true;

            this.ApprovalColumn01.HeaderText = "№";

            this.ApprovalColumn01.Name = "ApprovalColumn01";

            this.ApprovalColumn01.ReadOnly = true;

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

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

            this.ApprovalColumn01.Width = 40;

            // 

            // ApprovalColumn03

            // 

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

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

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

            this.ApprovalColumn03.DefaultCellStyle = dataGridViewCellStyle17;

            this.ApprovalColumn03.Frozen = true;

            this.ApprovalColumn03.HeaderText = "工　事　名　称";

            this.ApprovalColumn03.Name = "ApprovalColumn03";

            this.ApprovalColumn03.ReadOnly = true;

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

            this.ApprovalColumn03.Width = 320;

            // 

            // ApprovalColumn04

            // 

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

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

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

            this.ApprovalColumn04.DefaultCellStyle = dataGridViewCellStyle18;

            this.ApprovalColumn04.Frozen = true;

            this.ApprovalColumn04.HeaderText = "申請項目";

            this.ApprovalColumn04.Name = "ApprovalColumn04";

            this.ApprovalColumn04.ReadOnly = true;

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

            this.ApprovalColumn04.Width = 130;

            // 

            // ApprovalColumn05

            // 

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

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

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

            this.ApprovalColumn05.DefaultCellStyle = dataGridViewCellStyle19;

            this.ApprovalColumn05.Frozen = true;

            this.ApprovalColumn05.HeaderText = "申　請　者";

            this.ApprovalColumn05.Name = "ApprovalColumn05";

            this.ApprovalColumn05.ReadOnly = true;

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

            this.ApprovalColumn05.Width = 80;

            // 

            // ApprovalColumn06

            // 

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

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

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

            this.ApprovalColumn06.DefaultCellStyle = dataGridViewCellStyle20;

            this.ApprovalColumn06.Frozen = true;

            this.ApprovalColumn06.HeaderText = "申　請　日";

            this.ApprovalColumn06.Name = "ApprovalColumn06";

            this.ApprovalColumn06.ReadOnly = true;

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

            // 

            // ApprovalColumn07

            // 

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

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

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

            this.ApprovalColumn07.DefaultCellStyle = dataGridViewCellStyle21;

            this.ApprovalColumn07.Frozen = true;

            this.ApprovalColumn07.HeaderText = "承認希望日";

            this.ApprovalColumn07.Name = "ApprovalColumn07";

            this.ApprovalColumn07.ReadOnly = true;

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

            // 

            // ApprovalColumn08

            // 

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

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

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

            this.ApprovalColumn08.DefaultCellStyle = dataGridViewCellStyle22;

            this.ApprovalColumn08.Frozen = true;

            this.ApprovalColumn08.HeaderText = "承認者１";

            this.ApprovalColumn08.Name = "ApprovalColumn08";

            this.ApprovalColumn08.ReadOnly = true;

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

            this.ApprovalColumn08.Width = 80;

            // 

            // ApprovalColumn09

            // 

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

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

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

            this.ApprovalColumn09.DefaultCellStyle = dataGridViewCellStyle23;

            this.ApprovalColumn09.Frozen = true;

            this.ApprovalColumn09.HeaderText = "承認者２";

            this.ApprovalColumn09.Name = "ApprovalColumn09";

            this.ApprovalColumn09.ReadOnly = true;

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

            this.ApprovalColumn09.Width = 80;

            // 

            // ApprovalColumn10

            // 

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

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

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

            this.ApprovalColumn10.DefaultCellStyle = dataGridViewCellStyle24;

            this.ApprovalColumn10.Frozen = true;

            this.ApprovalColumn10.HeaderText = "承認者３";

            this.ApprovalColumn10.Name = "ApprovalColumn10";

            this.ApprovalColumn10.ReadOnly = true;

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

            this.ApprovalColumn10.Width = 80;

            // 

            // ApprovalColumn11

            // 

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

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

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

            this.ApprovalColumn11.DefaultCellStyle = dataGridViewCellStyle25;

            this.ApprovalColumn11.Frozen = true;

            this.ApprovalColumn11.HeaderText = "承認者４";

            this.ApprovalColumn11.Name = "ApprovalColumn11";

            this.ApprovalColumn11.ReadOnly = true;

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

            this.ApprovalColumn11.Width = 80;

            // 

            // Column47

            // 

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

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

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

            this.Column47.DefaultCellStyle = dataGridViewCellStyle26;

            this.Column47.Frozen = true;

            this.Column47.HeaderText = "承認者５";

            this.Column47.Name = "Column47";

            this.Column47.ReadOnly = true;

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

            this.Column47.Width = 80;

            // 

            this.label23.Text = "担当未定受注金額";

            this.tblLayoutOrder.Location = new System.Drawing.Point(54, 12);

            this.tableLayoutDocuments.Location = new System.Drawing.Point(54, 12);

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT C.DEPARTMENTCODE, C.DEPARTMENTSTRING, C.DISPLAYORDER, SUM(A.ORDERSDECISIONPRICE), SUM(D.ORDERSDECISIONPRICE)");

                strSQL.Append(" FROM CONSTRUCTIONBASEINFO AS A");

                strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER AS B ON B.PersonCode = A.CONSTRUCTIONPERSONCODE");

                strSQL.Append(" LEFT JOIN DEPARTMENTMASTER AS C ON C.DEPARTMENTCODE = B.DEPARTMENTCODE");

                strSQL.Append(" LEFT JOIN  CONSTRUCTIONLEDGER AS D ON D.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");

                strSQL.AppendFormat(" WHERE A.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

                strSQL.AppendFormat(" AND A.JOINFLG != {0}", (int)CommonDefine.BaseInfoJoinFlg.JoinChildren);

                strSQL.Append(" AND A.CONSTRUCTIONSTATUSFLG IN (");

                strSQL.AppendFormat("{0},", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("一般補修工事")).Key);       // 2

                strSQL.AppendFormat("{0},", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("仮 受 注")).Key);           // 3

                strSQL.AppendFormat("{0},", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("受　　注")).Key);           // 4

                strSQL.AppendFormat("{0},", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("部署引継")).Key);           // 5

                strSQL.AppendFormat("{0},", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("施工準備")).Key);           // 6

                strSQL.AppendFormat("{0},", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("施工開始")).Key);           // 7

                strSQL.AppendFormat("{0},", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("施工完了")).Key);           // 8

                strSQL.AppendFormat("{0},", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("空家補修工事")).Key);       // 16

                strSQL.AppendFormat("{0})", CommonDefine.ProjectsStatus.First(x => x.Value.Equals("Hit'sV工事")).Key);         // 17

                strSQL.Append(" GROUP BY C.DEPARTMENTCODE, C.DEPARTMENTSTRING, C.DISPLAYORDER");

                strSQL.Append(" ORDER BY C.DISPLAYORDER");

                if (!BaseDB.ExecuteReader(strSQL.ToString(), ref arList)) return;

                        //case 7:         // 7:会長室

                        //    RowCnt = 0;

                        //    ColCnt = 2;

                        //    break;

                    //if (DepCode == 7) continue;

[assembly: AssemblyVersion("1.0.0.45")]

[assembly: AssemblyFileVersion("1.0.0.45")]