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

        /// <summary>

        /// 本体バージョン

        /// </summary>

        /// <summary>

        /// コピー・環境バージョン

        /// <returns>Where文字列</returns>

        public string CreatePrimarykeyString(int TypeCode)

        {

            try

            {

                strWork.AppendFormat(" Where TypeCode = {0}", TypeCode);

        /// <returns>Where文字列</returns>

        public string CreatePrimarykeyString(DateTime Holiday)

        {

            try

            {

                strWork.AppendFormat(" Where Holiday = DATE_FORMAT('{0}','%Y/%m/%d')", Holiday.ToShortDateString());

        /// <returns>Where文字列</returns>

        public string CreatePrimarykeyString(int SecurityCode)

        {

            try

            {

                strWork.AppendFormat(" Where SecCode = {0}", SecurityCode);

        public bool SelectAction(string AddSQLString, ref List<RequestOrderDate> data, bool bConnect = true)

        {

            // インターフェース

            ArrayList arData = new ArrayList();

            try

            OrderNo,

        }

        #endregion

        #region ???

        /// <summary>

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

            InitCombBox();

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

            InitDisplayStyle();

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

            InitDepPersonCode();

            // ?????\??

            InitDataLoad();

        }

        #endregion

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

        /// <summary>

        /// ?c?????X

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

            int DepCode = CommonMotions.cnvInt(cmbDepartment.SelectedValue);

            int PerCode = CommonMotions.cnvInt(cmbConstructionPerson.SelectedValue);

            SetcmbDepartment();

            SetcmbPersons();

            cmbDepartment.SelectedValue = DepCode;

            cmbConstructionPerson.SelectedValue = PerCode;

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

            DataDisplay();

        {

            if (m_initDataLoad) return;

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

            SetcmbPersons();

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

            DataDisplay();

        {

            if (m_initDataLoad) return;

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

            SetPerosonToDepartment();

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

            DataDisplay();

        /// </summary>

        private void InitializeComponent()

        {

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

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

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

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

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

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

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

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

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

            this.btnDataCopy.UseVisualStyleBackColor = false;

            this.btnDataCopy.Click += new System.EventHandler(this.btnDataCopy_Click);

            // 

            // dgvMaster

            // 

            this.dgvMaster.AllowUserToAddRows = false;

            this.dgvMaster.AllowUserToDeleteRows = false;

            this.dgvMaster.AllowUserToResizeColumns = false;

            this.dgvMaster.AllowUserToResizeRows = false;

            this.dgvMaster.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.dgvMaster.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));

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

            this.dgvMaster.ColumnHeadersHeight = 24;

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

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

            this.Column3,

            this.Column2,

            this.Column11});

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

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

            this.dgvMaster.MultiSelect = false;

            // 

            // Column1

            // 

            this.Column1.Frozen = true;

            this.Column1.HeaderText = "№";

            this.Column1.Name = "Column1";

            // 

            // Column9

            // 

            this.Column9.Frozen = true;

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

            this.Column9.Name = "Column9";

            // 

            // Column5

            // 

            this.Column5.Frozen = true;

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

            this.Column5.Name = "Column5";

            // 

            // Column10

            // 

            this.Column10.Frozen = true;

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

            this.Column10.Name = "Column10";

            // 

            // Column6

            // 

            this.Column6.Frozen = true;

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

            this.Column6.Name = "Column6";

            // 

            // Column4

            // 

            this.Column4.Frozen = true;

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

            this.Column4.Name = "Column4";

            // 

            // Column7

            // 

            this.Column7.Frozen = true;

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

            this.Column7.Name = "Column7";

            // 

            // Column8

            // 

            this.Column8.Frozen = true;

            this.Column8.HeaderText = "印刷";

            this.Column8.Name = "Column8";

            // 

            // Column3

            // 

            this.Column3.Frozen = true;

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

            this.Column3.Name = "Column3";

            // 

            // Column2

            // 

            this.Column2.Frozen = true;

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

            this.Column2.Name = "Column2";

            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.btnDataCopy);

            this.Controls.Add(this.lblProcessTitil);

            this.Controls.Add(this.groupBox1);

        private System.Windows.Forms.DataGridViewTextBoxColumn Column3;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column2;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column11;

    }

}

            try

            {

                DataGridView dgv = dgvMaster;

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

                int ino = 1;

                                        , OrderNo

                                        );

                }

            }

            catch (Exception ex)

            {

        }

        #endregion

        #region ?f?[?^?\??????

        /// <summary>

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

            try

            {

                foreach (DataGridViewColumn wrkCol in dgvMaster.Columns) wrkCol.SortMode = DataGridViewColumnSortMode.NotSortable;

                dgvMaster.Rows.Clear();

                StringBuilder strSQL = new StringBuilder();

                // SQL??

                CreateInitSQL(ref strSQL);

                ArrayList arData = new ArrayList();

                // ?H????{????

                if (cbiDB.ExecuteReader(strSQL.ToString(), ref arData))

                cbiDB.close(); cbiDB = null;

                if (CommonDefine.s_MaxInitLineCount > dgvMaster.RowCount)

                    dgvMaster.RowCount += (CommonDefine.s_MaxInitLineCount - dgvMaster.RowCount);

            }

        }

        #endregion

            }

        }

        #endregion

    }

}

            IOMPersonInCharge picDB = new IOMPersonInCharge();

            try

            {

                // ?S????}?X?^??????????

                string strSQL = string.Format(" Where DepartmentCode = {0}", DepartmentCode);

                strSQL += " AND DeleteFlg = 0 Order By EmployeeClassFlg ASC, DisplayOrder ASC";

        private bool SetInitcmbPersonInCharge()

        {

            IOMPersonInCharge picDB = new IOMPersonInCharge();

            try

            {

                // ?S????}?X?^??????????

        {

            IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

            IOMPersonInCharge picDB = new IOMPersonInCharge();

            try

            {

                if (TransferCode == 0)

        private void SetcmbTransferConstructionCombBox()

        {

            IOMPersonInCharge picDB = new IOMPersonInCharge();

            IOMDepartment dmDB = new IOMDepartment();

            List<DepartmentMaster> dmList = new List<DepartmentMaster>();

            try

            RowData[(int)GridColumn.CompanyCode] = CompanyCode;

            RowData[(int)GridColumn.CompanyName] = CompanyName;

            RowData[(int)GridColumn.EstimatePrice] = SumaryValue.ToString("#,0");

            RowData[(int)GridColumn.HopePrice] = SumaryValue.ToString("#,0");

            RowData[(int)GridColumn.ExecPrice] = SumaryValue.ToString("#,0");

            RowData[(int)GridColumn.Percent] = CalculattionPercent((double)SumaryValue).ToString("0.00");

        private bool SetInitcmbPersonInCharge()

        {

            IOMPersonInCharge picDB = new IOMPersonInCharge();

            try

            {

                // 担当者マスタを検索する

        private static int s_CurrentProcessNo = (int)ClsExcute.ProcessExecuteNo.ConstructionLedgerList;

        #endregion

        #endregion

        #region ???

        /// <summary>

        /// ?t?B?[???h?l????t???O

            InitDepPersonCode();

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

            // ?????\??

            InitDataLoad();

        }

        #endregion

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

        /// <summary>

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

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

            int DepCode = CommonMotions.cnvInt(cmbDepartment.SelectedValue);

            int PerCode = CommonMotions.cnvInt(cmbConstructionPerson.SelectedValue);

            SetcmbDepartment();

            SetcmbPersons();

            cmbDepartment.SelectedValue = DepCode;

            cmbConstructionPerson.SelectedValue = PerCode;

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

            DataDisplay();

        {

            if (m_initDataLoad) return;

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

            SetcmbPersons();

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

            DataDisplay();

        {

            if (m_initDataLoad) return;

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

            SetPerosonToDepartment();

            // ????????????N????S?????X???p?????[?^??X

            if (!m_FirstStartFlg)

            {

                m_FirstStartPersonCode = CommonMotions.cnvInt(cmbConstructionPerson.SelectedValue);

            }

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

            DataDisplay();

        }

        #endregion

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

        /// <summary>

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

        }

        #endregion

        #region ???f?[?^?\??????

        /// <summary>

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

                dgv.SuspendLayout();

                dgv.Rows.Clear();

                prgber.Maximum = 10;

                StringBuilder strSQL = new StringBuilder();

                // SQL??

                dgv.ResumeLayout();

                // ProgressBar??l???X????

            }

        }

        #endregion

                // ステータスでの検索条件を追加する

                strSQL.Append(CreateStatusSQL(CreateStatusList()));

                strSQL.Append(CreateOhterSQL());

                strSQL.Append(" Group By DATE_FORMAT(Base.EstimatesSubmittedDate, '%Y%m')");

        }

        #endregion

        /// <summary>

        /// </summary>

        /// <returns></returns>

        private string CreateOhterSQL()

            StringBuilder strSQL = new StringBuilder();

            try

            {

                switch (m_ProcessNo)

                {

                    case (int)ClsExcute.ProcessExecuteNo.MainMenu:

                        break;

                    default:

                        break;

        }

        #endregion

        #region ステータス選択ＳＱＬ作成

        /// <summary>

        /// ステータス選択ＳＱＬ作成

                                strSQL.AppendFormat(" AND Base.ConstructionStatusFlg < {0})", StatusList[1]);

                                break;

                            default:

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

                                {

        private bool SetcmbPersons()

        {

            IOMPersonInCharge picDB = new IOMPersonInCharge();

            try

            {

                cmbSalesPerson.DataSource = null;

                // データセット

                ConstructionProgressDate Rec = new ConstructionProgressDate();

                Rec.ConstructionCode = ConstructionCode;

                Rec.PreviousStatusFlg = 0;

                Rec.ChangeDate = DateTime.Now;

                Rec.ChangePersonCode = CommonMotions.LoginUserData.PersonCode;

            try

            {

                // 工事番号・名称取得

                ConstructionBaseInfoDetail BaseDetailRec = new ConstructionBaseInfoDetail();

                if (!BaseDetailDB.SelectAction(strSQL, ref BaseDetailRec)) return false;

                string Quantity = CommonMotions.cnvString(wrkRow.Cells[(int)DispGridColumn3.Quantity].Value);

                // 資材名・数量が無い場合は登録しない

                if (FeildEmptyCheck(Materials, Quantity)) return true;

                bool bRet = true;

                bool bAns = true;

                dgvAllDisplay.Rows[iAddLine].Cells[(int)DispGridColumn.GroupCount].Value = GroupFlg;

                dgvAllDisplay.Rows[iAddLine].Cells[(int)DispGridColumn.EstimatePrice].Value = EstimatePrice.ToString("#,0");

                dgvAllDisplay.Rows[iAddLine].Cells[(int)DispGridColumn.FirstString].Value = TotalName;

                dgvAllDisplay.Rows[iAddLine].Cells[(int)DispGridColumn.TotalFlg].Value = TotalType;

        {

            try

            {

                int DepartmentCode = GetDepartmentCode();

                if (DepartmentCode == 0) return strRet.ToString();

                // ????????

                strSQL.AppendFormat(" WHERE LEDGERFLG = {0}", (int)PersonInChargeMaster.LedgerDivNoDef.CalcTarget);

                strSQL.Append(" AND (DEPARTMENTCODE");

                if (DepartmentCode == 0)

                {

                    // ?Q??????}?X?^????????

                NewPage.PageTextBox.Location = new System.Drawing.Point(1180, 8);

                NewPage.PageTextBox.Name = string.Format("NewPagePageTextBox{0}", PageCount);

                NewPage.PageTextBox.Size = new System.Drawing.Size(114, 23);

                NewPage.PageTextBox.TabIndex = 0;

                NewPage.PageTextBox.Enter += new System.EventHandler(this.txtBoxS001_Enter);

                NewPage.PageTextBox.TextChanged += new System.EventHandler(this.txtBox_TextChanged);

        private bool SetInitcmbPersonInCharge(PurchaseOrderInputPage inputpage)

        {

            IOMPersonInCharge picDB = new IOMPersonInCharge();

            try

            {

                // 担当者マスタを検索する

                    if (CommonMotions.cnvString(wrkRow.Cells[(int)DispColumn.CompanyName].Value).Length == 0) continue;

                    // ?X?????`?F?b?N

                    workCell = CommonMotions.cnvString(wrkRow.Cells[(int)DispColumn.MailingDate].Value);

                    if (workCell.Length != 0)

                    {

                    bRet &= bAns;

                    // ??????`?F?b?N

                    workCell = CommonMotions.cnvString(wrkRow.Cells[(int)DispColumn.ReturnDate].Value);

                    if (workCell.Length != 0)

                    {

                    bRet &= bAns;

                    // ????m?F???`?F?b?N

                    workCell = CommonMotions.cnvString(wrkRow.Cells[(int)DispColumn.ReturnCheckDate].Value);

                    if (workCell.Length != 0)

                    {

            {

                foreach (DataGridViewColumn wrkCol in dgvMaster.Columns) wrkCol.SortMode = DataGridViewColumnSortMode.NotSortable;

                dgvMaster.Rows.Clear();

                // SQL??

                CreateInitSQL(ref strSQL);

                ArrayList arData = new ArrayList();

                   (tcol == (int)DispColumn.depositAmountBill))                // 入金金額（手形）

                {

                    // カンマは一旦削除して文字列を取得

                    // 不要な空白は削除

                    str.Trim();

            if (nType == (int)EditType.Amount)

            {

                // カンマは一旦削除して文字列を取得

                // 不要な空白は削除

                str.Trim();

               (tcol == (int)DispColumn.DifferentAmount))                   // 次回繰越

            {

                // カンマは一旦削除して文字列を取得

                // 不要な空白は削除

                str.Trim();

                // 担当者マスタ取得SQL

                string strSql = string.Format(" Where EmployeeClassFlg = {0} And DeleteFlg = 0 Order By DisplayOrder ASC", (int)PersonInChargeMaster.EmployeeClassFlgDef.OutSource);

                // グリッドの行を0に戻す

                // 担当者マスタ取得

                if (!picDB.SelectAction(strSql, ref pic)) return false;

                strSql.AppendFormat(" And DeleteFlg = {0}", Delflg);

                strSql.Append(" Order By DisplayOrder ASC");

                // グリッドの行を0に戻す

                // 担当者マスタ取得

                if (!picDB.SelectAction(strSql.ToString(), ref pic)) return false;

                if (SecondSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, SecondSQL);

                // 支払区分検索条件取得

                if (ThirdSQL.Length != 0) strSQL += string.Format("{0} {1}", s_SQLAND, ThirdSQL);

                strSQL += string.Format("{0} DeleteFlg = 0 Order By DisplayOrder ASC", s_SQLAND);

                if (SecondSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, SecondSQL);

                // 支払区分検索条件取得

                if (ThirdSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, ThirdSQL);

                strSQL += string.Format("{0} DeleteFlg = 0 Order By DisplayOrder ASC", s_SQLAND);

                if (SecondSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND,SecondSQL);

                // 50音検索条件取得

                if (ThirdSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, ThirdSQL);

                strSQL += string.Format("{0} DeleteFlg = 0 Order By labourKind DESC, DisplayOrder ASC", s_SQLAND);

        {

            try

            {

                if (Value < 0) return string.Empty;

                return string.Format("labourKind = {0}", CommonMotions.cnvInt(cmbLabour.SelectedValue));

            IOMSubContractorItem itemDB = new IOMSubContractorItem();

            try

            {

                List<SubContractorItemMaster> itemList = new List<SubContractorItemMaster>();

                string strSQL = " Order By DisplayOrder";

            IOMSubContractor sbDB = new IOMSubContractor();

            try

            {

                string strSQL = "Select Distinct JapaneseSyllabary From SubContractorMaster WHERE DELETEFLG = 0 Order By JapaneseSyllabary";

                ArrayList arData = new ArrayList();

                if (!sbDB.ExecuteReader(strSQL, ref arData)) return;

        {

            try

            {

                // データセット

                List<KeyValuePair<int, string>> DataList = new List<KeyValuePair<int, string>>();

        private bool SetlstPersonInCharge()

        {

            IOMPersonInCharge picDB = new IOMPersonInCharge();

            IOMDepartment dmDB = new IOMDepartment();

            List<DepartmentMaster> dmList = new List<DepartmentMaster>();

            try

                if (SecondSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, SecondSQL);

                // 支払区分検索条件取得

                if (ThirdSQL.Length != 0) strSQL += string.Format("{0} {1}", s_SQLAND, ThirdSQL);

                strSQL += string.Format("{0} DeleteFlg = 0 Order By DisplayOrder ASC", s_SQLAND);

                //if (SecondSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, SecondSQL);

                //// 50音検索条件取得

                //if (ThirdSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, ThirdSQL);

                //strSQL += string.Format("{0} DeleteFlg = 0 Order By DisplayOrder ASC", s_SQLAND);

                if (SecondSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, SecondSQL);

                // 支払区分検索条件取得

                if (ThirdSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, ThirdSQL);

                strSQL += string.Format("{0} DeleteFlg = 0 Order By DisplayOrder ASC", s_SQLAND);

            if (SecondSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, SecondSQL);

            // 50音検索条件取得

            if (ThirdSQL.Length != 0) strSQL += string.Format(" {0} {1}", s_SQLAND, ThirdSQL);

            strSQL += string.Format("{0} DeleteFlg = 0 Order By labourKind DESC, DisplayOrder ASC", s_SQLAND);

                string arrayName = lblName.Name;

                string compere = FixLableName[0];

                int ArrayCnt = 0;

                // 午前の表示

                if (arrayName.Contains(FixLableName[0])) 

                {

                int BillComp = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("請求完了")).Key;

                // ----- SQL作成

                // 増減工事の増減分を取得する

                strSQL1.Append("(SELECT A.ConstructionCode, A.ConstructionPeriod, B.DETAILNO, B.DETAILSTRING, A.ConstructionStatusFlg,");

                strSQL1.Append(" A.EstimatesSubmitDeadline, C.PERSONNAME, D.PERSONNAME, E.PERSONNAME, F.PERSONNAME, D.DepartmentCode,");

                strSQL1.Append(" G.APPROVALCODE, IFNULL(G.APPROVALSTATUS, -1), TRUNCATE(A.ConstructionCode / 100, 0), MOD(A.ConstructionCode ,100), A.*");

// すべての値を指定するか、下のように '*' を使ってビルドおよびリビジョン番号を 

// 既定値にすることができます:

// [assembly: AssemblyVersion("1.0.*")]

// Log4netを使用する

[assembly: log4net.Config.XmlConfigurator(ConfigFile = @"log4net.config", Watch = true)]