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

        #endregion

        #region SELECT　SQL作成

        private string CreateSelectSQL()

        {

            try

            {

                // 工事予算書データを読み込む

                ConstructionBudget BudgetRec = new ConstructionBudget();

                // 工事予算書明細データを読み込む

                List<ConstructionBudgetDetail> DetailList = new List<ConstructionBudgetDetail>();

                if (DetailList.Count == 0) return false;

                DataGridViewEX dgv = dgvAllDisplay;

                // 承認機能番号セット

                frm.ApprovalCode = ClsExcute.AppovalList.First(x => x.Value.Equals("請求承認")).Key;

                // 受付番号

                // 見えない画面を出す

                frm.WindowState = FormWindowState.Minimized;

                if (!frm.OneApprovalProcess) return false;

                // 完了メッセージ

                return true;

            }

            // 

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

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

            this.btnCancel.Name = "btnCancel";

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

            this.btnCancel.TabIndex = 22;

            // 

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

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

            this.btnExecProc1.Name = "btnExecProc1";

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

            this.btnExecProc1.TabIndex = 21;

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

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

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

            this.Controls.Add(this.btnCancel);

            this.Controls.Add(this.btnExecProc1);

            this.Controls.Add(this.groupBoxEx2);

            this.btnGenerate.Enabled = false;

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

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

            this.btnGenerate.Name = "btnGenerate";

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

            this.btnGenerate.TabIndex = 33;

            this.btnDel.Enabled = false;

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

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

            this.btnDel.Name = "btnDel";

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

            this.btnDel.TabIndex = 40;

            this.btnDel.Text = "請求取消";

            this.btnDel.UseVisualStyleBackColor = false;

            this.btnDel.Click += new System.EventHandler(this.btnDel_Click);

            // 

            // panel2

        {

            try

            {

                // ??????L???w???x

                {

                }

                else

                {

                }

                // ???v?Z?o

                // ???v?l?Z?o

            }

            catch (Exception ex)

            {

            this.comboBox1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

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

            this.comboBox1.FormattingEnabled = true;

            this.comboBox1.Location = new System.Drawing.Point(422, 5);

            this.comboBox1.Name = "comboBox1";

            this.comboBox1.Size = new System.Drawing.Size(130, 24);

            this.comboBox1.TabIndex = 2;

        private static Color s_RowSelectColor = Color.LightBlue;

        /// <summary>

        /// 月選択

        /// </summary>

        private long s_SelectedMonth = 1 << 3;

                sql.Append(" C1.ConstructionCode = A1.REQCONSTRUCTIONCODE");

                sql.AppendFormat(" AND C1.ConstructionPeriod = {0}", numericUpDown2.Value);

                sql.Append(" Group By A1.REQUESTMONTH");

                var data = new ArrayList();

                ReqHDB.ExecuteReader(sql.ToString(), ref data);

                foreach (object[] objRec in data)

                {

                }

            }

            catch (Exception ex)

                long SelComb = 0;

                int CntNo = 1;

                long lTotal = 0;

                foreach (object[] objRec in data)

                {

                    SelComb = SelectedCondition();

                    {

                    }

                    }

                    dgv.Rows.Add(CntNo++,

                                objRec[(int)GetOrder.A2OrderersCode],

                                objRec[(int)GetOrder.DiviNameString],

                                CommonMotions.cnvInt(objRec[(int)GetOrder.Value]).ToString("#,0"),

                                objRec[(int)GetOrder.E1DepartmentCode],

                                objRec[(int)GetOrder.D1PersonCode],

                                );

                    lTotal += CommonMotions.cnvInt(objRec[(int)GetOrder.Value]);

                }

            {

                long selValue = 0;

                if (CommonMotions.cnvInt(comboBox1.SelectedValue) != 0) selValue += s_SelectedMonth;

                if (CommonMotions.cnvInt(comboBox2.SelectedValue) != 0) selValue += s_SelectedDepartment;

                if (CommonMotions.cnvInt(comboBox3.SelectedValue) != 0) selValue += s_SelectedPerson;

        /// <param name="sql"></param>

        private void CreateSelectSQL(StringBuilder sql)

        {

            try

            {

                int SelMonth = CommonMotions.cnvInt(comboBox1.SelectedValue);

                sql.Append(", SUM(A1.REQUESTAMOUNT) AS Value");

                sql.Append(" LEFT JOIN orderersmaster AS A2");

                sql.Append("    ON A2.OrderCotegory = A1.ORDERERSDIVISION");

                sql.Append("    And A2.OrderersCode = A1.ORDERERSCODE");

                long SelComb = SelectedCondition();

                strOrder.Append("Value DESC");

                // ??????????????W?v?P???????

                {   // ?S?????

                }

                }

                else if ((SelComb & s_SelectedDepartment) == 0)

                }

                }

                else if ((SelComb & s_SelectedPerson) == 0)

                }

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

            }

        }

        #endregion

        {

            try

            {

                // 製品版Type1は消費税以外の設定を消す

                switch (ProductDefine.ProductType)

                {

                    case (int)ProductDefine.ProductTypeDef.MassProductionType1:

                        foreach (Control CurCtrl in groupBoxEx2.Controls)

                        {

                            if (CurCtrl.Name.Equals("label15")

                            CurCtrl.Visible = false;

                        }

                        break;

                }

            }

            catch (System.Exception ex)

                                                                { 0,

                                                                    0,

                                                                    0,

                                                                },

        };

        #endregion