プロジェクト

全般

プロフィール

リビジョン 460

堀内約6年前に追加

承認処理:承認後の非承認・保留対応
工事詳細台帳:一般管理費表示位置バグ修正・データ表示SQL注文書データ取得バグ修正・人件費振分バグ修正
工事検索サブウィンドウ:全年度対応
積算見積入力:中項目行入力フラグをマスタ無時に既存データより判定する様に変更
メニュー:掲示板データ絞り込みコンボボックス文字修正・非受注工事/完了工事検索、全年度対象追加

差分を表示:

trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsCommonApproval.cs
631 631
                    if (DataRec.SeqNo == s_PrimartyRecord) continue;
632 632

  
633 633
                    // 承認以外は対象にしない
634
                    if (DataRec.ApprovalStatus != (int)CommonDefine.ApprovalStatus.Approval) continue;
634
                    //if (DataRec.ApprovalStatus != (int)CommonDefine.ApprovalStatus.Approval) continue;
635 635

  
636 636
                    foreach (ApprovalMaster MasterRec in MasterList)
637 637
                    {
......
645 645
                        if (MasterRec.ApprovalAuthority == (int)ApprovalMaster.ApprovalAuthorityDef.LastApproval)
646 646
                        {
647 647
                            // 最終承認済みは処理しない
648
                            if (RequestData.ApprovalStatus == (int)CommonDefine.ApprovalStatus.Approval) break;
648
                            //if (RequestData.ApprovalStatus == (int)CommonDefine.ApprovalStatus.Approval) break;
649 649

  
650 650
                            bApproval = true;
651 651
                            break;
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalScreen/FrmApprovalScreenAuxiliary.cs
316 316
                // 工事情報取得
317 317
                if (!SetBaseInfoData()) return false;
318 318

  
319
                // 現在申請データ取得
320
                if (!SetFirstApprovalData(statusCode)) return false;
321

  
319 322
                ProcessApproval Rec = new ProcessApproval();
320 323

  
321 324
                // 承認レコードの作成
......
359 362
                }
360 363

  
361 364
                // ----- 申請レコード更新
362
                // 承認以外は以下を処理しない
363
                if (statusCode != (int)CommonDefine.ApprovalStatus.Approval) return true;
365
                // 申請中は承認以外は以下を処理しない
366
                if (m_PettionData.ApprovalStatus == (int)CommonDefine.ApprovalStatus.Petition)
367
                {
368
                    if (statusCode != (int)CommonDefine.ApprovalStatus.Approval) return true;
369
                }
364 370

  
365 371
                // ----- 承認
366 372
                // 案件に対して最終承認がされているかを確認する
......
712 718
        }
713 719
        #endregion
714 720

  
721
        #region 現在申請データ取得
722
        /// <summary>
723
        /// 現在申請データ取得
724
        /// </summary>
725
        /// <returns></returns>
726
        private bool SetFirstApprovalData(int statusCode)
727
        {
728
            IOProcessApproval AppDB = new IOProcessApproval();
729
            try
730
            {
731
                // 申請時は取得しない
732
                if (statusCode == (int)CommonDefine.ApprovalStatus.Petition)
733
                {
734
                    m_PettionData.ApprovalStatus = (int)(int)CommonDefine.ApprovalStatus.Petition;
735
                    return true;
736
                }
737

  
738
                StringBuilder strSQL = new StringBuilder();
739
                strSQL.Append(AppDB.CreatePrimarykeyString(m_ConstructionCode,
740
                                                            m_ApprovalCode,
741
                                                            m_OrderNo,
742
                                                            1));
743

  
744
                if (!AppDB.SelectAction(strSQL.ToString(), ref m_PettionData)) return false;
745

  
746

  
747
                return true;
748
            }
749
            catch (Exception ex)
750
            {
751
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
752
                return false;
753
            }
754
            finally
755
            {
756
                AppDB.close(); AppDB = null;
757
            }
758
        }
759
        #endregion
760

  
715 761
        #region ヘッダー情報表示
716 762
        /// <summary>
717 763
        /// ヘッダー情報表示
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedger/FrmConstructionLedgerAuxiliary.cs
1990 1990
                }
1991 1991

  
1992 1992
                int nSetRow = m_CostsRowCount[(int)CostsRowLine.ExpensesRowLine] - 1;
1993
                if (nSetRow < 0) nSetRow = 0; ;
1993
                if (nSetRow < 0) nSetRow = 0;
1994 1994
                dgvAllDisplay.Rows[nSetRow].Cells[(int)GridColumn.EstimatePrice].Value = nRetVal.ToString("#,#");
1995 1995
                dgvAllDisplay.Rows[nSetRow].Cells[(int)GridColumn.EstimatePrice].ToolTipText = "一 般 管 理 費";
1996 1996
            }
......
3553 3553
                strcmd.Append("         ON Odr.ConstructionCode = A.SourceCode");
3554 3554
                strcmd.Append("         And Odr.SourceCode = A.ConstructionCode");
3555 3555
                strcmd.Append("         And Odr.SourceDetailCnt = A.DetailCount");
3556
                strcmd.AppendFormat("   And Odr.GroupCount = {0}", (int)PurchaseOrderDetail.GroupCountDef.Detail);
3556 3557

  
3557 3558
                strcmd.Append("   LEFT JOIN PurchaseOrderDetail As Odr2");
3558 3559
                strcmd.Append("         ON Odr2.ConstructionCode = Odr.ConstructionCode");
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionSerarch/FrmConstrSerarch.Designer.cs
41 41
            this.cmbEstiDate = new System.Windows.Forms.ComboBox();
42 42
            this.textBox1 = new System.Windows.Forms.TextBox();
43 43
            this.textBox2 = new System.Windows.Forms.TextBox();
44
            this.checkBox1 = new System.Windows.Forms.CheckBox();
44 45
            ((System.ComponentModel.ISupportInitialize)(this.numUDConstPro)).BeginInit();
45 46
            this.SuspendLayout();
46 47
            // 
......
202 203
            this.textBox2.Size = new System.Drawing.Size(480, 23);
203 204
            this.textBox2.TabIndex = 3;
204 205
            // 
206
            // checkBox1
207
            // 
208
            this.checkBox1.BackColor = System.Drawing.Color.Transparent;
209
            this.checkBox1.Font = new System.Drawing.Font("MS 明朝", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
210
            this.checkBox1.ForeColor = System.Drawing.Color.White;
211
            this.checkBox1.Location = new System.Drawing.Point(412, 45);
212
            this.checkBox1.Name = "checkBox1";
213
            this.checkBox1.Size = new System.Drawing.Size(200, 32);
214
            this.checkBox1.TabIndex = 51;
215
            this.checkBox1.Text = "全データ対象検索";
216
            this.checkBox1.UseVisualStyleBackColor = false;
217
            this.checkBox1.CheckedChanged += new System.EventHandler(this.checkBox1_CheckedChanged);
218
            // 
205 219
            // FrmConstrSerarch
206 220
            // 
207 221
            this.AutoScaleDimensions = new System.Drawing.SizeF(9F, 16F);
......
209 223
            this.BackColor = System.Drawing.Color.Black;
210 224
            this.CancelButton = this.btnEnd;
211 225
            this.ClientSize = new System.Drawing.Size(618, 211);
226
            this.Controls.Add(this.checkBox1);
212 227
            this.Controls.Add(this.textBox2);
213 228
            this.Controls.Add(this.textBox1);
214 229
            this.Controls.Add(this.cmbEstiDate);
......
256 271
        private System.Windows.Forms.ComboBox cmbEstiDate;
257 272
        private System.Windows.Forms.TextBox textBox1;
258 273
        private System.Windows.Forms.TextBox textBox2;
274
        private System.Windows.Forms.CheckBox checkBox1;
259 275
    }
260 276
}
261 277

  
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionSerarch/FrmConstrSerarch.cs
47 47
        private Point m_InitPoint = new Point();
48 48
        #endregion
49 49

  
50
        #region 全データ対象
51
        /// <summary>
52
        /// 全データ対象
53
        /// </summary>
54
        private bool m_AllData = false;
55
        #endregion
56

  
50 57
        #region 営業期の表示制御
51 58
        /// <summary>
52 59
        /// 営業期の表示制御
......
129 136
        }
130 137
        #endregion
131 138

  
139
        #region 全データ対象
140
        /// <summary>
141
        /// 全データ対象
142
        /// </summary>
143
        public bool AllData
144
        {
145
            get { return m_AllData; }
146
            set { m_AllData = value; }
147
        }
148
        #endregion
149

  
132 150
        #region 営業期の表示制御
133 151
        /// <summary>
134 152
        /// 営業期の表示制御
......
347 365
        /// <param name="e"></param>
348 366
        private void btnExec_Click(object sender, EventArgs e)
349 367
        {
368
            // 全データ選択
369
            m_AllData = CommonMotions.cnvBool(checkBox1.Checked);
350 370
            // 営業期
351 371
            m_Period = (int)numUDConstPro.Value;
352 372
            // 見積年月
......
375 395
            numUDConstPro.ValueChanged += new System.EventHandler(numUDConstPro_ValueChanged);
376 396
        }
377 397
        #endregion
398

  
399
        #region 全年度対象検索チェック
400
        /// <summary>
401
        /// 全年度対象検索チェック
402
        /// </summary>
403
        /// <param name="sender"></param>
404
        /// <param name="e"></param>
405
        private void checkBox1_CheckedChanged(object sender, EventArgs e)
406
        {
407
            bool bVisDisp = true;
408
            if (checkBox1.Checked) bVisDisp = false;
409

  
410
            label4.Visible = bVisDisp;
411
            label8.Visible = bVisDisp;
412
            numUDConstPro.Visible = bVisDisp;
413
            label7.Visible = bVisDisp;
414

  
415
            label2.Visible = bVisDisp;
416
            cmbEstiDate.Visible = bVisDisp;
417

  
418
            if (bVisDisp) CommonMotions.SetSerchTitle(label4, label8, numUDConstPro, label7);
419
        }
420
        #endregion
378 421
    }
379 422
}
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionSerarch/FrmConstrSerarchAux.cs
59 59
                label8.Visible = false;
60 60
                numUDConstPro.Visible = false;
61 61

  
62
                checkBox1.Visible = false;
63

  
62 64
                return false;
63 65
            }
64 66
            catch (Exception ex)
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/EstimateInput/FrmEstimateInputAuxiliary.cs
4839 4839
                    SmallRec.UpdateDate = CommonMotions.cnvDate(objRec[(int)IOEstimateDataDetail.TableColumn.UpdateDate]);              // 更新日付
4840 4840
                    SmallList.Add(SmallRec);
4841 4841

  
4842
                    // 構成データセット
4842
                    // 中項目データセット
4843 4843
                    ConstructionItemMaster MciRec = new ConstructionItemMaster();
4844 4844
                    MciRec.ItemCode = CommonMotions.cnvInt(objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.ItemCode]);	            // 工種キー
4845 4845
                    MciRec.DisplayOrder = CommonMotions.cnvInt(objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.DisplayOrder]);	    // 表示順
4846
                    MciRec.ItemName = CommonMotions.cnvString(objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.ItemName]);	        // 名称
4847
                    MciRec.SubitemsFlg = CommonMotions.cnvInt(objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.SubitemsFlg]);	    // 下位項目フラグ
4846
                    MciRec.ItemName = CommonMotions.cnvString(objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.ItemName]);          // 名称
4847
                    // 下位項目フラグデータ存在のチェック
4848
                    if (SmallRec.PageCount == 3) { Debug.WriteLine(""); }
4849
                    object wrkObj = objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.SubitemsFlg];
4850
                    if (CommonMotions.cnvString(wrkObj).Length < 1)
4851
                    {
4852
                        MciRec.SubitemsFlg = SmallRec.InputFlg == (int)CommonDefine.DirectInput.Input
4853
                                                                ? (int)ConstructionItemMaster.SubitemsFlgDef.None : (int)ConstructionItemMaster.SubitemsFlgDef.Exists;
4854
                    }
4855
                    else
4856
                    {
4857
                        MciRec.SubitemsFlg = CommonMotions.cnvInt(wrkObj);
4858
                    }
4859

  
4848 4860
                    MciRec.MyExpensesFlg = CommonMotions.cnvInt(objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.MyExpensesFlg]);   // 自社経費フラグ
4849 4861
                    MciRec.DeleteFlg = CommonMotions.cnvInt(objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.DeleteFlg]);	        // 削除フラグ
4850 4862
                    MciRec.EntryDate = CommonMotions.cnvDate(objRec[EstimateCnt + (int)IOMConstructionItem.NameColumn.EntryDate]);          // 登録日付
trunk/src/ProcessManagement/ProcessManagement/Forms/ZMenu/FrmMenu.cs
322 322
                                                                                        {(int)MessageBoardData.LinkTypeDef.ConstructionInfo," 部署引継・担当者選任" },
323 323
                                                                                        {(int)MessageBoardData.LinkTypeDef.MaterialInfo," 資 材 管 理" },
324 324
                                                                                        {(int)MessageBoardData.LinkTypeDef.ProcessApproval," 工 事 承 認" },
325
                                                                                        {(int)MessageBoardData.LinkTypeDef.PaymentEntry," 入 金 確認" } };
325
                                                                                        {(int)MessageBoardData.LinkTypeDef.PaymentEntry," 入 金 確 認" } };
326 326
        #endregion
327 327

  
328 328
        #region 行動予定グリッドセル定義
trunk/src/ProcessManagement/ProcessManagement/Forms/ZMenu/FrmMenuAuxiliary.cs
5197 5197
                dgv.Columns[2].HeaderText = GridTitleString[CommonMotions.SystemMasterData.ConstructionNoBase];
5198 5198

  
5199 5199
                dgv.SuspendLayout();
5200
                // 工事委検索全データ対象無
5201
                if (!m_AllData)
5202
                {
5200 5203
                // 工事検索時は検索画面の値をセットする
5201
                if (m_bConstrSearchFlg)
5202
                {
5203
                    numUDNonOrder.ValueChanged -= new EventHandler(numUDNonOrder_ValueChanged);
5204
                    numUDNonOrder.Value = m_Period;
5205
                    numUDNonOrder.ValueChanged += new EventHandler(numUDNonOrder_ValueChanged);
5204
                    if (m_bConstrSearchFlg)
5205
                    {
5206
                        numUDNonOrder.ValueChanged -= new EventHandler(numUDNonOrder_ValueChanged);
5207
                        numUDNonOrder.Value = m_Period;
5208
                        numUDNonOrder.ValueChanged += new EventHandler(numUDNonOrder_ValueChanged);
5209
                    }
5206 5210
                }
5207 5211

  
5208 5212
                dgv.Rows.Clear();
......
5335 5339
            }
5336 5340
            finally
5337 5341
            {
5342
                m_AllData = false;
5338 5343
                // 読込時データカウント取得
5339 5344
                if (CommonDefine.s_MaxInitLineCount > dgv.RowCount)
5340 5345
                    dgv.RowCount += (CommonDefine.s_MaxInitLineCount - dgv.RowCount);
......
5370 5375
                //strSQL += CreateListSQLFluctuation();
5371 5376
                strSQL.Append(" WHERE (");
5372 5377
                strSQL.Append(CreateListSQL(stat));
5373
                if (CommonMotions.BasePeriodYear())
5378
                // 工事委検索全データ対象無
5379
                if (!m_AllData)
5374 5380
                {
5375
                    strSQL.AppendFormat(" And CONSTRUCTIONPERIOD = {0}", numUDNonOrder.Value);
5381
                    if (CommonMotions.BasePeriodYear())
5382
                    {
5383
                        strSQL.AppendFormat(" And CONSTRUCTIONPERIOD = {0}", numUDNonOrder.Value);
5384
                    }
5385
                    else
5386
                    {
5387
                        strSQL.AppendFormat(" And ConstructionYear = {0}", numUDNonOrder.Value);
5388
                    }
5376 5389
                }
5377
                else
5378
                {
5379
                    strSQL.AppendFormat(" And ConstructionYear = {0}", numUDNonOrder.Value);
5380
                }
5381

  
5382 5390
                return strSQL.ToString();
5383 5391
            }
5384 5392
            catch (Exception ex)
......
5419 5427
            DataGridViewEX dgv = dgvCompletionOfConstruction;
5420 5428
            try
5421 5429
            {
5422
                // 工事検索時は検索画面の値をセットする
5423
                if (m_bConstrSearchFlg)
5430
                // 工事委検索全データ対象無
5431
                if (!m_AllData)
5424 5432
                {
5425
                    numUDCompletion.ValueChanged -= new EventHandler(numUDCompletion_ValueChanged);
5426
                    numUDCompletion.Value = m_Period;
5427
                    numUDCompletion.ValueChanged += new EventHandler(numUDCompletion_ValueChanged);
5433
                    // 工事検索時は検索画面の値をセットする
5434
                    if (m_bConstrSearchFlg)
5435
                    {
5436
                        numUDCompletion.ValueChanged -= new EventHandler(numUDCompletion_ValueChanged);
5437
                        numUDCompletion.Value = m_Period;
5438
                        numUDCompletion.ValueChanged += new EventHandler(numUDCompletion_ValueChanged);
5439

  
5440
                    }
5428 5441
                }
5429 5442

  
5430 5443
                dgv.Rows.Clear();
......
5550 5563
            }
5551 5564
            finally
5552 5565
            {
5566
                m_AllData = false;
5567

  
5553 5568
                // 読込時データカウント取得
5554 5569
                if (CommonDefine.s_MaxInitLineCount > dgv.RowCount)
5555 5570
                    dgv.RowCount += (CommonDefine.s_MaxInitLineCount - dgv.RowCount);
......
5722 5737
                strSQL.Append(CreateListSQL(stat, false, strArias));
5723 5738

  
5724 5739
                //strSQL += string.Format(" And TO_DATE('{0}', 'yyyy/dd/mm') <= ConstructionCompletionDate", StartDate.ToShortDateString());
5725
                if (CommonMotions.BasePeriodYear())
5726
                    strSQL.AppendFormat(" And A.CONSTRUCTIONPERIOD = {0}", numUDCompletion.Value);
5727
                else
5728
                    strSQL.AppendFormat(" And A.ConstructionYear = {0}", numUDCompletion.Value);
5740
                // 工事委検索全データ対象無
5741
                if (!m_AllData)
5742
                {
5743
                    if (CommonMotions.BasePeriodYear())
5744
                        strSQL.AppendFormat(" And A.CONSTRUCTIONPERIOD = {0}", numUDCompletion.Value);
5745
                    else
5746
                        strSQL.AppendFormat(" And A.ConstructionYear = {0}", numUDCompletion.Value);
5747
                }
5729 5748

  
5730 5749
                return strSQL.ToString();
5731 5750
            }
......
8302 8321
        #endregion
8303 8322

  
8304 8323
        #region 工事検索
8324
        #region 全データ対象
8325
        /// <summary>
8326
        /// 全データ対象
8327
        /// </summary>
8328
        private bool m_AllData = false;
8329
        #endregion
8305 8330
        #region 営業期
8306 8331
        /// <summary>
8307 8332
        /// 工事検索営業期
......
8397 8422
                // 終了状態確認
8398 8423
                if (frm.EndStatus == DialogResult.Cancel) return;
8399 8424

  
8425
                // 全データ対象
8426
                m_AllData = frm.AllData;
8400 8427
                // 営業期
8401 8428
                m_Period = frm.Period;
8402 8429
                // 見積年月

他の形式にエクスポート: Unified diff