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

        public static int s_SystemVersion = 153;

            BillingEntrylList = 39,             // 39:請求選択一覧

                                                                                { (int)ProcessExecuteNo.RequestInput,           "請求データ作成－入力"},

                                                                                { (int)ProcessExecuteNo.BillingEntrylList,      "請求データ一覧－表示"},

                        case (int)ProcessExecuteNo.BillingEntrylList:                   // 39:請求選択一覧

                            ProcessExecuteNo_BillingEntrylList(m_ProcControlPara[NowPoint]);

            //　入金確認

            FrmEntryReqSelOrderer frm = new FrmEntryReqSelOrderer();

                int ProcessNo = (int)ProcessExecuteNo.PaymentConfirmation;

        #region 請求選択一覧

        /// 請求選択一覧

        public static void ProcessExecuteNo_BillingEntrylList(ProcessParameter CurrentPara)

            //　請求選択一覧

            FrmConstrReqList frm = new FrmConstrReqList();

        #region 指定レコードの表示順を更新する

        /// <summary>

        /// 指定レコードの表示順を更新する

        /// </summary>

        /// <param name="AddSQLString"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        public bool SetDisplayOrder(string AddSQLString, bool bConnect = true)

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

                // SQL作成

                strcmd.Append("UPDATE ORDERERSMASTER SET DisplayOrder = ROWNUM");

                strcmd.Append(AddSQLString);

                // SQL実行

                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

                    Console.WriteLine("{0}, {1}", c.ColumnIndex, c.RowIndex);

                    if (wrkRow.Index == 40)

                    {

                        Console.WriteLine("Debug");

                    }

                SelectRow.Cells[m_TargetColumn].Value = m_AddingRequestPrice.ToString("0,0");

                    SelectRow.Cells[nSetColumn].Value = DataCurRec.BillPrice.ToString("0,0");

                    Console.WriteLine("{0}, {1}", c.ColumnIndex, c.RowIndex);

                    Console.WriteLine("{0}, {1}", c.ColumnIndex, c.RowIndex);

                    Console.WriteLine("{0}, {1}", c.ColumnIndex, c.RowIndex);

                    Console.WriteLine("{0}, {1}", c.ColumnIndex, c.RowIndex);

                lblCount01.Text = DetailList.Count.ToString("0,0");

                lblCount02.Text = nAllcnt.ToString("0,0");

                lblCount03.Text = OrederCnt.ToString("0,0");

                lblCount04.Text = nCnt.ToString("0,0");

                lblCount05.Text = nCnt.ToString("0,0");

                lblCount06.Text = nCnt.ToString("0,0");

                lblCount04.Text = nCnt.ToString("0,0");

                lblCount05.Text = nCnt.ToString("0,0");

                                    (TotalVal - TaxVal).ToString("0,0"),

                lblLabel06.Text = (HeaderRec.TotalAmount - HeaderRec.TaxAmount).ToString("0,0");

                    Console.WriteLine("{0}, {1}", c.ColumnIndex, c.RowIndex);

                                        , CommonMotions.cnvInt(objwrk[(int)GetData.REQUESTAMOUNT]).ToString("0,0")

                                    , CommonMotions.cnvInt(objwrk[(int)GetData.TOTALAMOUNT]).ToString("0,0")

namespace ProcessManagement.Forms.DataEntry

{

    partial class FrmConstrReqList

    {

        /// <summary>

        /// 必要なデザイナ変数です。

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// 使用中のリソースをすべてクリーンアップします。

        /// </summary>

        /// <param name="disposing">マネージ リソースが破棄される場合 true、破棄されない場合は false です。</param>

        protected override void Dispose(bool disposing)

        {

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

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows フォーム デザイナで生成されたコード

        /// <summary>

        /// デザイナ サポートに必要なメソッドです。このメソッドの内容を

        /// コード エディタで変更しないでください。

        /// </summary>

        private void InitializeComponent()

        {

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

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

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle26 = 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();

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

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

            this.groupBox1 = new ProcessManagement.Forms.CustomControls.GroupBoxEx();

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

            this.radioButton2 = new System.Windows.Forms.RadioButton();

            this.radioButton1 = new System.Windows.Forms.RadioButton();

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

            this.numUDConstPro = new System.Windows.Forms.NumericUpDown();

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

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

            this.cmbConstructionPerson = new System.Windows.Forms.ComboBox();

            this.cmbDepartment = new System.Windows.Forms.ComboBox();

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

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

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

            this.dgvEntry = new ProcessManagement.Forms.CustomControls.DataGridViewEX();

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

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

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

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

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

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

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

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

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

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

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

            this.groupBox1.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.numUDConstPro)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.dgvEntry)).BeginInit();

            this.SuspendLayout();

            // 

            // btnEnd

            // 

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

            this.btnEnd.BackColor = System.Drawing.Color.Blue;

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

            this.btnEnd.Location = new System.Drawing.Point(1150, 619);

            this.btnEnd.Name = "btnEnd";

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

            this.btnEnd.TabIndex = 8;

            this.btnEnd.Text = "終　了";

            this.btnEnd.UseVisualStyleBackColor = false;

            this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);

            // 

            // label1

            // 

            this.label1.Anchor = System.Windows.Forms.AnchorStyles.Top;

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

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

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

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

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

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(400, 20);

            this.label1.TabIndex = 6;

            this.label1.Text = "工　事　情　報　一　覧";

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

            // 

            // groupBox1

            // 

            this.groupBox1.Anchor = System.Windows.Forms.AnchorStyles.Top;

            this.groupBox1.BackColor = System.Drawing.Color.Aquamarine;

            this.groupBox1.BorderColor = System.Drawing.Color.White;

            this.groupBox1.Controls.Add(this.label3);

            this.groupBox1.Controls.Add(this.radioButton2);

            this.groupBox1.Controls.Add(this.radioButton1);

            this.groupBox1.Controls.Add(this.label4);

            this.groupBox1.Controls.Add(this.numUDConstPro);

            this.groupBox1.Controls.Add(this.label5);

            this.groupBox1.Controls.Add(this.label7);

            this.groupBox1.Controls.Add(this.cmbConstructionPerson);

            this.groupBox1.Controls.Add(this.cmbDepartment);

            this.groupBox1.Controls.Add(this.label2);

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

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

            this.groupBox1.Name = "groupBox1";

            this.groupBox1.Size = new System.Drawing.Size(1260, 55);

            this.groupBox1.TabIndex = 0;

            this.groupBox1.TabStop = false;

            // 

            // label3

            // 

            this.label3.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));

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

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

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

            this.label3.Location = new System.Drawing.Point(747, 19);

            this.label3.Name = "label3";

            this.label3.Size = new System.Drawing.Size(120, 25);

            this.label3.TabIndex = 4;

            this.label3.Text = "担　当　者";

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

            // 

            // radioButton2

            // 

            this.radioButton2.AutoSize = true;

            this.radioButton2.BackColor = System.Drawing.Color.Transparent;

            this.radioButton2.Checked = true;

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

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

            this.radioButton2.Location = new System.Drawing.Point(662, 32);

            this.radioButton2.Name = "radioButton2";

            this.radioButton2.Size = new System.Drawing.Size(77, 20);

            this.radioButton2.TabIndex = 44;

            this.radioButton2.TabStop = true;

            this.radioButton2.Text = "工　事";

            this.radioButton2.TextAlign = System.Drawing.ContentAlignment.BottomCenter;

            this.radioButton2.UseVisualStyleBackColor = false;

            this.radioButton2.CheckedChanged += new System.EventHandler(this.radioButton_CheckedChanged);

            // 

            // radioButton1

            // 

            this.radioButton1.AutoSize = true;

            this.radioButton1.BackColor = System.Drawing.Color.Transparent;

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

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

            this.radioButton1.Location = new System.Drawing.Point(662, 12);

            this.radioButton1.Name = "radioButton1";

            this.radioButton1.Size = new System.Drawing.Size(77, 20);

            this.radioButton1.TabIndex = 43;

            this.radioButton1.Text = "営　業";

            this.radioButton1.TextAlign = System.Drawing.ContentAlignment.TopCenter;

            this.radioButton1.UseVisualStyleBackColor = false;

            this.radioButton1.CheckedChanged += new System.EventHandler(this.radioButton_CheckedChanged);

            // 

            // label4

            // 

            this.label4.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));

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

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

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

            this.label4.Location = new System.Drawing.Point(20, 19);

            this.label4.Name = "label4";

            this.label4.Size = new System.Drawing.Size(120, 25);

            this.label4.TabIndex = 42;

            this.label4.Text = "営業期";

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

            // 

            // numUDConstPro

            // 

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

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

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

            this.numUDConstPro.Location = new System.Drawing.Point(173, 20);

            this.numUDConstPro.Name = "numUDConstPro";

            this.numUDConstPro.ReadOnly = true;

            this.numUDConstPro.Size = new System.Drawing.Size(80, 23);

            this.numUDConstPro.TabIndex = 0;

            this.numUDConstPro.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;

            this.numUDConstPro.ValueChanged += new System.EventHandler(this.numUDConstPro_ValueChanged);

            // 

            // label5

            // 

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

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

            this.label5.Location = new System.Drawing.Point(253, 23);

            this.label5.Name = "label5";

            this.label5.Size = new System.Drawing.Size(25, 16);

            this.label5.TabIndex = 39;

            this.label5.Text = "期";

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

            // 

            // label7

            // 

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

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

            this.label7.Location = new System.Drawing.Point(148, 23);

            this.label7.Name = "label7";

            this.label7.Size = new System.Drawing.Size(25, 16);

            this.label7.TabIndex = 40;

            this.label7.Text = "第";

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

            // 

            // cmbConstructionPerson

            // 

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

            this.cmbConstructionPerson.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

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

            this.cmbConstructionPerson.FormattingEnabled = true;

            this.cmbConstructionPerson.Location = new System.Drawing.Point(875, 20);

            this.cmbConstructionPerson.Name = "cmbConstructionPerson";

            this.cmbConstructionPerson.Size = new System.Drawing.Size(200, 23);

            this.cmbConstructionPerson.TabIndex = 2;

            this.cmbConstructionPerson.TextChanged += new System.EventHandler(this.cmbConstructionPerson_TextChanged);

            // 

            // cmbDepartment

            // 

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

            this.cmbDepartment.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

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

            this.cmbDepartment.FormattingEnabled = true;

            this.cmbDepartment.Location = new System.Drawing.Point(422, 20);

            this.cmbDepartment.Name = "cmbDepartment";

            this.cmbDepartment.Size = new System.Drawing.Size(200, 23);

            this.cmbDepartment.TabIndex = 1;

            this.cmbDepartment.TextChanged += new System.EventHandler(this.cmbDepartment_TextChanged);

            // 

            // label2

            // 

            this.label2.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));

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

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

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

            this.label2.Location = new System.Drawing.Point(294, 19);

            this.label2.Name = "label2";

            this.label2.Size = new System.Drawing.Size(120, 25);

            this.label2.TabIndex = 4;

            this.label2.Text = "部　　署";

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

            // 

            // 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 = 9;

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

            // 

            // btnDataUpDate

            // 

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

            this.btnDataUpDate.BackColor = System.Drawing.Color.Aquamarine;

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

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

            this.btnDataUpDate.Location = new System.Drawing.Point(1150, 4);

            this.btnDataUpDate.Name = "btnDataUpDate";

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

            this.btnDataUpDate.TabIndex = 7;

            this.btnDataUpDate.Text = "最新状態に更新";

            this.btnDataUpDate.UseVisualStyleBackColor = false;

            this.btnDataUpDate.Click += new System.EventHandler(this.btnDataUpDate_Click);

            // 

            // dgvEntry

            // 

            this.dgvEntry.AllowUserToAddRows = false;

            this.dgvEntry.AllowUserToDeleteRows = false;

            this.dgvEntry.AllowUserToResizeColumns = false;

            this.dgvEntry.AllowUserToResizeRows = false;

            dataGridViewCellStyle14.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));

            this.dgvEntry.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle14;

            this.dgvEntry.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 

            | System.Windows.Forms.AnchorStyles.Left) 

            | System.Windows.Forms.AnchorStyles.Right)));

            this.dgvEntry.BackgroundColor = System.Drawing.Color.White;

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

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

            dataGridViewCellStyle15.BackColor = System.Drawing.SystemColors.Control;

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

            dataGridViewCellStyle15.ForeColor = System.Drawing.SystemColors.WindowText;

            dataGridViewCellStyle15.SelectionBackColor = System.Drawing.SystemColors.Highlight;

            dataGridViewCellStyle15.SelectionForeColor = System.Drawing.SystemColors.HighlightText;

            dataGridViewCellStyle15.WrapMode = System.Windows.Forms.DataGridViewTriState.True;

            this.dgvEntry.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle15;

            this.dgvEntry.ColumnHeadersHeight = 24;

            this.dgvEntry.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;

            this.dgvEntry.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.Column1,

            this.Column9,

            this.Column5,

            this.Column10,

            this.Column6,

            this.Column4,

            this.Column7,

            this.Column3,

            this.Column2,

            this.Column11,

            this.Column8});

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

            dataGridViewCellStyle26.BackColor = System.Drawing.SystemColors.Window;

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

            dataGridViewCellStyle26.ForeColor = System.Drawing.SystemColors.ControlText;

            dataGridViewCellStyle26.SelectionBackColor = System.Drawing.Color.LightSeaGreen;

            dataGridViewCellStyle26.SelectionForeColor = System.Drawing.SystemColors.HighlightText;

            dataGridViewCellStyle26.WrapMode = System.Windows.Forms.DataGridViewTriState.False;

            this.dgvEntry.DefaultCellStyle = dataGridViewCellStyle26;

            this.dgvEntry.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;

            this.dgvEntry.EnableHeadersVisualStyles = false;

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

            this.dgvEntry.MultiSelect = false;

            this.dgvEntry.Name = "dgvEntry";

            this.dgvEntry.RowHeadersVisible = false;

            this.dgvEntry.RowHeadersWidth = 20;

            this.dgvEntry.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;

            this.dgvEntry.RowTemplate.Height = 24;

            this.dgvEntry.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;

            this.dgvEntry.Size = new System.Drawing.Size(1260, 508);

            this.dgvEntry.TabIndex = 5;

            this.dgvEntry.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvMaster_CellDoubleClick);

            // 

            // Column1

            // 

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

            this.Column1.DefaultCellStyle = dataGridViewCellStyle16;

            this.Column1.HeaderText = "№";

            this.Column1.Name = "Column1";

            this.Column1.ReadOnly = true;

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

            this.Column1.Width = 50;

            // 

            // Column9

            // 

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

            this.Column9.DefaultCellStyle = dataGridViewCellStyle17;

            this.Column9.HeaderText = "営業部署";

            this.Column9.Name = "Column9";

            this.Column9.ReadOnly = true;

            this.Column9.Width = 135;

            // 

            // Column5

            // 

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

            this.Column5.DefaultCellStyle = dataGridViewCellStyle18;

            this.Column5.HeaderText = "営業担当者";

            this.Column5.Name = "Column5";

            this.Column5.ReadOnly = true;

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

            this.Column5.Width = 135;

            // 

            // Column10

            // 

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

            this.Column10.DefaultCellStyle = dataGridViewCellStyle19;

            this.Column10.HeaderText = "工事部署";

            this.Column10.Name = "Column10";

            this.Column10.ReadOnly = true;

            this.Column10.Width = 135;

            // 

            // Column6

            // 

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

            this.Column6.DefaultCellStyle = dataGridViewCellStyle20;

            this.Column6.HeaderText = "工事担当者";

            this.Column6.Name = "Column6";

            this.Column6.ReadOnly = true;

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

            this.Column6.Width = 135;

            // 

            // Column4

            // 

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

            this.Column4.DefaultCellStyle = dataGridViewCellStyle21;

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

            this.Column4.Name = "Column4";

            this.Column4.ReadOnly = true;

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

            this.Column4.Width = 440;

            // 

            // Column7

            // 

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

            this.Column7.DefaultCellStyle = dataGridViewCellStyle22;

            this.Column7.HeaderText = "施工状態";

            this.Column7.Name = "Column7";

            this.Column7.ReadOnly = true;

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

            this.Column7.Width = 150;

            // 

            // Column3

            // 

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

            this.Column3.DefaultCellStyle = dataGridViewCellStyle23;

            this.Column3.HeaderText = "営業期";

            this.Column3.Name = "Column3";

            this.Column3.ReadOnly = true;

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

            this.Column3.Visible = false;

            // 

            // Column2

            // 

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

            this.Column2.DefaultCellStyle = dataGridViewCellStyle24;

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

            this.Column2.Name = "Column2";

            this.Column2.ReadOnly = true;

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

            this.Column2.Visible = false;

            // 

            // Column11

            // 

            this.Column11.HeaderText = "申請受付番号";

            this.Column11.Name = "Column11";

            this.Column11.ReadOnly = true;

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

            this.Column11.Visible = false;

            // 

            // Column8

            // 

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

            this.Column8.DefaultCellStyle = dataGridViewCellStyle25;

            this.Column8.HeaderText = "作成";

            this.Column8.Name = "Column8";

            this.Column8.ReadOnly = true;

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

            this.Column8.Width = 60;

            // 

            // FrmConstrReqList

            // 

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

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

            this.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink;

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

            this.ClientSize = new System.Drawing.Size(1280, 657);

            this.Controls.Add(this.lblProcessTitil);

            this.Controls.Add(this.groupBox1);

            this.Controls.Add(this.label1);

            this.Controls.Add(this.btnDataUpDate);

            this.Controls.Add(this.btnEnd);

            this.Controls.Add(this.dgvEntry);

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

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

            this.KeyPreview = true;

            this.MinimizeBox = false;

            this.Name = "FrmConstrReqList";

            this.ShowIcon = false;

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

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

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

            this.SizeChanged += new System.EventHandler(this.FrmConstructionList_SizeChanged);

            this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.FrmConstructionBaseInfoList_KeyDown);

            this.groupBox1.ResumeLayout(false);

            this.groupBox1.PerformLayout();

            ((System.ComponentModel.ISupportInitialize)(this.numUDConstPro)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.dgvEntry)).EndInit();

            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.Button btnEnd;

        private System.Windows.Forms.Label label1;

        private ProcessManagement.Forms.CustomControls.GroupBoxEx groupBox1;

        private System.Windows.Forms.Label label2;

        private System.Windows.Forms.ComboBox cmbDepartment;

        private ProcessManagement.Forms.CustomControls.DataGridViewEX dgvEntry;

        private System.Windows.Forms.Label lblProcessTitil;

        private System.Windows.Forms.ComboBox cmbConstructionPerson;

        private System.Windows.Forms.Label label3;

        private System.Windows.Forms.Button btnDataUpDate;

        private System.Windows.Forms.Label label4;

        private System.Windows.Forms.NumericUpDown numUDConstPro;

        private System.Windows.Forms.Label label5;

        private System.Windows.Forms.Label label7;

        private System.Windows.Forms.RadioButton radioButton2;

        private System.Windows.Forms.RadioButton radioButton1;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column1;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column9;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column5;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column10;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column6;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column4;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column7;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column3;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column2;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column11;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column8;

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Collections;

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.DB.Core;

using ProcessManagement.Forms.CustomControls;

using ProcessManagement.Forms.ControlsAction;

//*---------------------------- ?????H????????? --------------------------*

//  2017/05/25  Ver1.0.0.0      Create Source           

//

//

//

//*----------------------------------------------------------------------------*

namespace ProcessManagement.Forms.DataEntry

{

    public partial class FrmConstrReqList : Form

    {

        #region ?g?p??`

        //log4net???O???g?p????

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

        #endregion

        #region ??

        /// <summary>

        /// ?\???J????

        /// </summary>

        private enum DispColumn

        {

            No = 0,

            SalesDepartment,

            SalesPerson,

            ConstructionDepartment,

            ConstructionPerson,

            ConstructionName,

            Status,

            ConstructionPeriod,

            ConstructionCode,

            OrderNo,

            BillingMark,

        }

        #endregion

        #region ???

        /// <summary>

        /// ???????t???O

        /// </summary>

        private bool m_initDataLoad = true;

        /// <summary>

        /// ?N???t???O

        /// </summary>

        private int m_ExecuteFlg = 0;

        /// <summary>

        /// ?N???????t???O

        /// </summary>

        private int m_ExecuteSubFlg = 0;

        /// <summary>

        /// ?f?[?^????{?^???\???t???O

        /// </summary>

        private bool m_DataAddtionButton = false;

        /// <summary>

        /// ?I???{?^???????t???O

        /// </summary>

        private bool m_CloseingProcessOff = false;

        /// <summary>

        /// Cell???T?C?Y

        /// </summary>

        private int[] m_CellSize;

        #region ?t?H?[????

        /// <summary>

        /// ?t?H?[????

        /// </summary>

        private int m_FormWidthSize = 0;

        #endregion

        #region ?O???b?h???T?C?Y

        /// <summary>

        /// ?O???b?h???T?C?Y

        /// </summary>

        private int m_GridWidthSize = 0;

        #endregion

        /// <summary>

        /// ?????H?????

        /// </summary>

        private int m_ConstructionCode = 0;

        #endregion

        #region ?v???p?e?B

        /// <summary>

        /// ?N???t???O

        /// </summary>

        public int ExecuteFlg

        {

            get { return m_ExecuteFlg; }

            set { m_ExecuteFlg = value; }

        }

        /// <summary>

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

        /// </summary>

        public bool DataAddtionButton

        {

            get { return m_DataAddtionButton; }

            set { m_DataAddtionButton = value; }

        }

        /// <summary>

        /// ?????H?????

        /// </summary>

        public int ConstructionCode

        {

            get { return m_ConstructionCode; }

        }

        /// <summary>

        /// ?N???????t???O

        /// </summary>

        public int ExecuteSubFlg

        {

            get { return m_ExecuteSubFlg; }

            set { m_ExecuteSubFlg = value; }

        }

        #endregion

        #region ?R???X?g???N?^

        public FrmConstrReqList()

        {

            InitializeComponent();

        }

        #endregion

        #region ?f?X?g???N?^

        ~FrmConstrReqList()

        {

            try

            {

                GC.Collect();

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region ?~?{?^??

        /// <summary>

        /// ?~?{?^??????????

        /// </summary>

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

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

        private void FrmConstructionList_FormClosing(object sender, FormClosingEventArgs e)

        {

            if (m_CloseingProcessOff) return;

            // ?O?v???Z?X????

            ClsExcute.BackProcess();

        }

        #endregion

        #region ?I???{?^??

        /// <summary>

        /// ?I???{?^???N???b?N

        /// </summary>

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

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

        private void btnEnd_Click(object sender, EventArgs e)

        {

            // ?O?v???Z?X????

            ClsExcute.BackProcess();

            m_CloseingProcessOff = true;

            this.Close();

        }

        #endregion

        #region ?X?V?{?^??

        /// <summary>

        /// ?f?[?^?X?V?{?^??????

        /// </summary>

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

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

        private void btnDataUpDate_Click(object sender, EventArgs e)

        {

            if (m_initDataLoad) return;

            // ?\???f?[?^?X?V

            DataDisplay();

        }

        #endregion

        #region ?t?H?[?????[?h

        /// <summary>

        /// ?????t?H?[?????[?h

        /// </summary>

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

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

        private void FrmConstructionList_Load(object sender, EventArgs e)

        {

            SetInitnumUDConstPro();

            // ?R???{?{?b?N?X?Z?b?g

            SetcmbDepartment();

            SetcmbPersons();

            // ?R???{?{?b?N?X?????\??

            InitCombBox();

            // ?\???X?^?C?????X

            InitDisplayStyle();

            // ???O?C?????Z?b?g

            InitDepPersonCode();

            // ?????\??

            InitDataLoad();

            m_initDataLoad = false;

        }

        #endregion

        #region ?Z???_?u???N???b?N

        /// <summary>

        /// ?Z???_?u???N???b?N

        /// </summary>

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

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

        private void dgvMaster_CellDoubleClick(object sender, DataGridViewCellEventArgs e)

        {

            if (e.RowIndex < 0) return;

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

            if (dgvEntry.RowCount == 0) return;

            if (CommonMotions.chkCellBlank(dgvEntry.CurrentRow.Cells[(int)DispColumn.ConstructionName].Value)) return;

            // ?e?????N??

            int ConstrCode = CommonMotions.cnvIntFromStringCode(dgvEntry.CurrentRow.Cells[(int)DispColumn.ConstructionCode].Value.ToString(), "-");

            int OrderNo = CommonMotions.cnvInt(dgvEntry.CurrentRow.Cells[(int)DispColumn.OrderNo].Value);

            SubProcessExecute(ConstrCode, OrderNo);

        }

        #endregion

        #region ?t?H?[??KeyDown

        /// <summary>

        /// Entry?L?[?????????

        /// </summary>

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

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

        private void FrmConstructionBaseInfoList_KeyDown(object sender, KeyEventArgs e)

        {

            //Enter?L?[?????????????m?F

            //Alt??Ctrl?L?[?????????????????????

            if ((e.KeyCode == Keys.Enter) && !e.Alt && !e.Control)

            {

                //????????Tab?L?[??????????????????

                //Shift??????????????O??R???g???[????t?H?[?J?X?????

                this.ProcessTabKey(!e.Shift);

                e.Handled = true;

                //.NET Framework 2.0??~

                e.SuppressKeyPress = true;

            }

        }

        #endregion

        #region ?c????R???{?{?b?N?X??X

        /// <summary>

        /// ?c?????X

        /// </summary>

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

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

        private void numUDConstPro_ValueChanged(object sender, EventArgs e)

        {

            if (m_initDataLoad) return;

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

            DataDisplay();

        }

        #endregion

        #region ?????R???{?{?b?N?X??X

        /// <summary>

        /// ?????R???{?{?b?N?X??X

        /// </summary>

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

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

        private void cmbDepartment_TextChanged(object sender, EventArgs e)

        {

            if (m_initDataLoad) return;

            // ?S????R???{?{?b?N?X??X

            SetcmbPersons();

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

            DataDisplay();

        }

        #endregion

        #region ?S????R???{?{?b?N?X??X

        /// <summary>

        /// ?S?????X

        /// </summary>

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

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

        private void cmbConstructionPerson_TextChanged(object sender, EventArgs e)

        {

            if (m_initDataLoad) return;

            // ?S????I?????????I????????

            SetPerosonToDepartment();

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

            DataDisplay();

        }

        #endregion

        #region ?t?H?[???T?C?Y??X

        /// <summary>

        /// ?t?H?[???T?C?Y??X

        /// </summary>

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

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

        private void FrmConstructionList_SizeChanged(object sender, EventArgs e)

        {

            if (this.WindowState == FormWindowState.Minimized)

            {

                // ?????

            }

            else if (this.WindowState == FormWindowState.Maximized)

            {

                // ???

                CellSizeChangesWhenChangingScreenSize(false);

            }

            else if (this.WindowState == FormWindowState.Normal)

            {

                // ?W????

                CellSizeChangesWhenChangingScreenSize(true);

            }

        }

        #endregion

        #region ?c??E?H???S????????

        /// <summary>

        /// ?c??E?H???S????????

        /// </summary>

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

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

        private void radioButton_CheckedChanged(object sender, EventArgs e)

        {

            if (m_initDataLoad) return;

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

            DataDisplay();

        }

        #endregion

    }

}

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 System.Collections;

using System.Diagnostics;

using System.Threading;

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.DB.Core;

using ProcessManagement.Forms.CustomControls;

using ProcessManagement.Forms.ControlsAction;

using ProcessManagement.Forms.SubForms;

namespace ProcessManagement.Forms.DataEntry

{

    partial class FrmConstrReqList

    {

        #region ??

        #region ?????`

        /// <summary>

        /// ?????`

        /// </summary>

        private enum GetData

        {

            ConstructionCode,

            ConstructionPeriod,

            ConstructionName,

            ConstructionStatusFlg,

            SalesCode,

            SalesName,

            SalesDepCode,

            SalesDepName,

            SalesManDispOrder,

            SalesDepDispOrder,

            ConstCode,

            ConstName,

            ConstDepCode,

            ConstDepName,

            ConstManDispOrder,

            ConstDepDispOrder,

            MainConstructionCode,

        }

        #endregion

        #endregion

        #region ???

        #endregion

        #region ?v???p?e?B

        #endregion

        #region ???v???Z?X?N??

        /// <summary>

        /// ?H???????N??????v???Z?X?I??????

        /// </summary>

        /// <param name="para_ConstructionCode"></param>

        private void SubProcessExecute(int para_ConstructionCode = 0, int para_OrderNo = 0)

        {

            try

            {

                DataGridView dgv = dgvEntry;

                int NowPoint = ClsExcute.GetNowProcessPoint();

                // ??????l?N???A

                ClsExcute.ClearSaveParameter(NowPoint);

                // ----- ???????

                // ?????N

                ClsExcute.ProcControlPara[NowPoint].StringSaveParameter.Add(numUDConstPro.Value.ToString());

                // ?S????I???????

                if (radioButton2.Checked) ClsExcute.ProcControlPara[NowPoint].BoolSaveParameter.Add(true);

                // ????????

                ClsExcute.ProcControlPara[NowPoint].IntSaveParameter.Add(CommonMotions.cnvInt(cmbDepartment.SelectedValue));

                // ?????S????

                ClsExcute.ProcControlPara[NowPoint].IntSaveParameter.Add(CommonMotions.cnvInt(cmbConstructionPerson.SelectedValue));

                // ?\?????s

                ClsExcute.ProcControlPara[NowPoint].IntSaveParameter.Add(dgv.FirstDisplayedScrollingRowIndex);

                // ??????s

                ClsExcute.ProcControlPara[NowPoint].IntSaveParameter.Add(dgv.CurrentRow.Index);

                // ?\?[?g???

                if (dgv.SortedColumn != null)

                {

                    ClsExcute.ProcControlPara[NowPoint].IntSaveParameter.Add((int)dgv.SortedColumn.Index);

                    ClsExcute.ProcControlPara[NowPoint].IntSaveParameter.Add((int)dgv.SortOrder);

                }

                // ???N???v???Z?X?Z?b?g

                NowPoint = ClsExcute.NextProcess(m_ExecuteFlg);

                // ?I???H??????Z?b?g

                ClsExcute.ProcControlPara[NowPoint].IntExecParameter.Add(para_ConstructionCode);

                // ??t????Z?b?g

                ClsExcute.ProcControlPara[NowPoint].IntExecParameter.Add(para_OrderNo);

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                // ?N???[?Y??????OFF?????B

                m_CloseingProcessOff = true;

                // ???N???[?Y

                this.Close();

            }

        }

        #endregion

        #region ????SQL??Z?L?????e?B??????????????

        /// <summary>

        /// ????SQL??Z?L?????e?B??????????????

        /// </summary>

        /// <param name="strSQL"></param>

        private void CreateSecuritySQL(ref StringBuilder strSQL)

        {

            try

            {

                // ?L?[?l??

                int AllPath = (int)CommonDefine.SecurityRangePos.AllPath;           // ?S????

                int Multiple = (int)CommonDefine.SecurityRangePos.Multiple;         // ????????

                int Only = (int)CommonDefine.SecurityRangePos.Only;                 // ?????????

                int None = (int)CommonDefine.SecurityRangePos.None;                 // ???S??????

                int iStatus = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("??????")).Key;

                int iStatus2 = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("???????p")).Key;

                // ?f?[?^?A?N?Z?X?????????????????

                if (CommonMotions.LoginUserData.PersonCode == CommonDefine.AdminCode

                || CommonMotions.LoginUserSecurity.SecRange == CommonDefine.SecurityRangeList[AllPath].Key)

                {

                    // ???????i????SQL???j

                }

                else if (CommonMotions.LoginUserSecurity.SecRange == CommonDefine.SecurityRangeList[Multiple].Key

                        || CommonMotions.LoginUserSecurity.SecRange == CommonDefine.SecurityRangeList[Only].Key)

                {

                    // ???????L

                    // ?@???????i?????????j

                    strSQL.Append(" And (A.SalesPersonCode IN (Select A1.PersonCode From PersonInChargeMaster A1");

                    strSQL.AppendFormat(" Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2 WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or (A.ConstructionStatusFlg >= {0}", iStatus);