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

        /// <summary>

        /// データ削除フラグ

        /// </summary>

        {

            /// <summary>

            /// 存在中

                    strSQL.Append(" WHERE");

                    // 削除されていないもの

                    DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(nTargetCount, false);

                    strSQL.AppendFormat(" And DATE(A.StartDate) <= DATE('{0}')", dtDefaultEnd.ToShortDateString());

        /// </summary>

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

        /// <param name="nTargetYear"></param>

        {

            try

            {

                if (nDepCode > 0) strSQL.AppendFormat(" AND (B.DEPARTMENTCODE = {0})", nDepCode);

                // 今期のデータかどうかを判定する

                string FieldName = string.Empty;

                if (CommonMotions.BasePeriodYear())

                    strSQL.Append(" On C.DepartmentCode = B.DEPARTMENTCODE");

                    strSQL.AppendFormat(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);

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

                }

            {

                // 本日の初回起動がされている場合は処理しない

                if (!ExecuteCheck(ref m_lastsessionDate)) return;

                // 更新済みにするために日付の更新

                if (!(ProcessFlg = UpDateTargetDate(DateTime.Now))) return;

                if (!(ProcessFlg = MaterialLimitCheck(m_lastsessionDate))) return;

                // 日付の期限チェックを行う

                // 見積有効期限切れを非受注へ移行する

                if (!(ProcessFlg = ChangeNonOrdersData())) return;

                // 開始期日がきた給与を適用する

                if (!(ProcessFlg = SetNewPayrollCheck())) return;

                // 工事詳細台帳の給与を加算する

                //if (!(ProcessFlg = CalculateDaysSalary(m_lastsessionDate))) return;

                // 日付比較

                if (DateTime.Today == recordRec.TargetDate.Date) return false;

                return true;

            }

            catch (Exception ex)

                if (Target.Date == CriteriaDate.Date)

                {

                    TermMasterData.CheckSchdule = (int)TermMaster.TermDateCheckTimingDef.CheckSchdule1;

                }

                // 後日以降継続のチェック 今日を基準に経過日（1日）が過ぎているか比較する

                else if (Target.AddDays(1).Date <= CriteriaDate.Date)

                {

                    TermMasterData.CheckSchdule = (int)TermMaster.TermDateCheckTimingDef.CheckSchdule3;

                }

                TermRec = TermMasterData;

                for (int ix = 0; ix < diffDays; ix++)

                {

                    DateTime CriteriaDate = StartDate.AddDays((ix + 1));

                    {

                        // 工事情報データセット

                        cbiDB.Reader2Struct(objRec, ref wrkBaseRec);

                strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER B ON B.PERSONCODE = P.SALESPERSONCODE");

                strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = P.CONSTRUCTIONPERSONCODE");

                strSQL.Append(", CONSTRUCTIONBASEINFODETAIL A");

                strSQL.AppendFormat(" AND A.CONSTRUCTIONCODE = P.CONSTRUCTIONCODE AND A.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                ArrayList arList = new ArrayList();

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

                string DetailString = string.Empty;

                int SalesPersonCode = 0;

                string SalesPersonName = string.Empty;

                // 更新処理

                PersonDB.connect(); PersonDB.beginTran();

                {

                    // 月給与更新

                    if (!PersonDB.UpdateFeild(CommonMotions.cnvInt(objRec[0]),

        }

        #endregion

        #region 管理マスタ：営業期・工事年度変更

        /// <summary>

        /// 管理マスタ：営業期・工事年度変更

                if (workList.Count == 0) return true;

                // 削除フラグ

                // データ更新

                if (!UpdateAction(strWhere.ToString(), workList[0], bConnect))

                {

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

                int nTargetCount = GetTargetYear();

                StringBuilder strSQL = new StringBuilder();

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

                ArrayList workList = new ArrayList();

                    strSQL.Append(" WHERE");

                    // ???????????????

                    DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(nTargetCount, false);

                    strSQL.AppendFormat(" And DATE(A.StartDate) <= DATE('{0}')", dtDefaultEnd.ToShortDateString());

            {

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

                StringBuilder strSQL = new StringBuilder();

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

                if (!dmDB.SelectAction(strSQL.ToString(), ref dmList)) return;

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

                DataList.Add(new KeyValuePair<int, string>(0, ""));

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

                strSQL.Clear();

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

                if (!picDB.SelectAction(strSQL.ToString(), ref workList)) return;

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

                // Value????Key??????

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(dvDB.CreatePrimarykeyString((int)DivisionMaster.DivisionMasterCodeDef.OrderDivision));

                if (!dvDB.SelectAction(strSQL.ToString(), ref bvList)) return;

                if (bvList.Count == 0) return;

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

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(orDB.CreatePrimarykeyString(idivision));

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

                if (!orDB.SelectAction(strSQL.ToString(), ref workList)) return false;

                List<ConstructionTypeMaster> typeList = new List<ConstructionTypeMaster>();

                StringBuilder strSQL = new StringBuilder();

                if (!TypeDB.SelectAction(strSQL.ToString(), ref typeList)) return;

                if (typeList.Count == 0) return;

                int DivisionCode = (int)DivisionMaster.DivisionMasterCodeDef.OrderDivision;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(dvDB.CreatePrimarykeyString(DivisionCode));

                if (!dvDB.SelectAction(strSQL.ToString(), ref bvList)) return;

                if (bvList.Count == 0) return;

                    strSQL.Append(" AND");

                }

                strSQL.AppendFormat(" A.EMPLOYEECLASSFLG = {0}", (int)PersonInChargeMaster.EmployeeClassFlgDef.Regular);

                strSQL.Append(" ORDER BY A.DISPLAYORDER ASC");

            }

            catch (System.Exception ex)

                strSQL.Append(" Else DATE(EndDate) End As EndDate");

                strSQL.Append(", EmployeeClassFlg");

                strSQL.Append(", LedgerFlg");

                strSQL.Append(" From PERSONINCHARGEMASTER) AS C");

                strSQL.Append(" ON C.PersonCode = ChgDep.PersonCode");

                strSQL.AppendFormat(" And C.LedgerFlg = {0}", (int)PersonInChargeMaster.EmployeeClassFlgDef.Regular);

                    // ????E??E??

                    if (bExistsFlg)

                    {   // ?????????S????

                    }

                    else

                    {   // ???????????S????

                    }

                    strSQL.Append(" GROUP BY D.DepartmentCode, C.PersonCode, F.NameCode");

                    strSQL.Append("         Group By A.DepartmentCode) As C");

                    strSQL.Append("     On C.DepartmentCode = B.DepartmentCode");

                    strSQL.Append(" Order By B.DisplayOrder");

                }

                else

                    strSQL.Append(" WHERE");

                    // ???????????????

                    DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(nTargetCount, false);

                    strSQL.AppendFormat(" And DATE(A.StartDate) <= DATE('{0}')", dtDefaultEnd.ToShortDateString());

                strSQL.Append(" LEFT JOIN ATTENDANCEDAILYDATA B ON B.PERSONCODE = A.PERSONCODE");

                strSQL.Append(" LEFT JOIN TRANCEPORTDAILYDATA C ON C.PERSONCODE = A.PERSONCODE");

                strSQL.AppendFormat(" WHERE A.EMPLOYEECLASSFLG = {0}", (int)PersonInChargeMaster.EmployeeClassFlgDef.Regular);

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

            }

            catch (Exception ex)

            {

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

                StringBuilder strSQL = new StringBuilder();

                // 担当者マスタ読込

                if (!picDB.SelectAction(strSQL.ToString(), ref workList)) return false;

                /////////////////////////////////////////////////////////////////////////////

                sql.Append("WHERE ");

                sql.Append("ORDER BY  ");

                sql.Append("DEPM.DisplayOrder ASC");                                            // ?????}?X?^?D?\?????i?????j

                sql.Append("FROM ");

                sql.Append("personinchargemaster PERIM ");                              // ?S????}?X?^

                sql.Append("WHERE ");

                /////////////////////////////////////////////////////////////////////////////

                // ????????(???I)START

                sql.Append("WHERE ");

                sql.AppendFormat("DIVI.DivisionCode = {0} "                             // ???}?X?^?D???R?[?h

                                , (int)DivisionMaster.DivisionMasterCodeDef.OrderDivision);

                /////////////////////////////////////////////////////////////////////////////

                // ????????(???I)START

                sql.Append("FROM ");

                sql.Append("orderersmaster As Orm ");                                   // ??????}?X?^

                sql.Append("WHERE ");

                /////////////////////////////////////////////////////////////////////////////

                // ????????(???I)START

            {

                DataGridViewEX dgv = dgvProcess;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(" Order by DisplayOrder");

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

                if (!DepDB.SelectAction(strSQL.ToString(), ref DepList)) return;

                strcmd.Append(", A.PersonName");

                strcmd.Append(", A.DisplayString");

                strcmd.Append(" FROM PersonInChargeMaster A, DepartmentMaster B");

                strcmd.Append(" Order By A.EmployeeClassFlg ASC, B.DisplayOrder ASC, A.DisplayOrder ASC");

                ArrayList arData = new ArrayList();

                if (!perDB.ExecuteReader(strcmd.ToString(), ref arData)) return false;

            {

                // 構成項目マスタを検索する

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(" Order By DisplayOrder Asc, ComponentCode Asc");

                // 構成項目マスタ読込

                strSQL.Append(" On B.ItemCode = A.ItemCode");

                strSQL.Append(" Where");

                strSQL.AppendFormat(" A.ComponentCode = {0}", nCompCode);

                strSQL.Append(" Order By B.DisplayOrder");

                // 工種マスタ読込

                // SQL作成

                StringBuilder strSQL = new StringBuilder();

                // 表示順マスタ取得

                if (!cmDB.SelectAction(strSQL.ToString(), ref cm)) return;

                StringBuilder strSQL = new StringBuilder();

                strSQL.AppendFormat(" Where NameCode = {0} And DeleteFlg = {1} Order By DisplayOrder ASC"

                                                , CommonMotions.cnvInt(cmbDisplayType.SelectedValue.ToString())

                // 表示順マスタ取得

                if (!cmDB.SelectAction(strSQL.ToString(), ref cm)) return false;

                List<ConstructionTypeMaster> wrk = new List<ConstructionTypeMaster>();

                // 作業名称取得SQL

                StringBuilder strSql = new StringBuilder();

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

                dgvTypeList.Rows.Clear();

                List<ComponentMaster> wrk = new List<ComponentMaster>();

                // 作業名称取得SQL

                StringBuilder strSql = new StringBuilder();

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

                dgvWorkList.Rows.Clear();

                strSql.Append("           From componentlinkmaster As BB");

                strSql.Append("           Group By BB.ComponentCode) As B");

                strSql.Append(" On B.ComponentCode = A.ComponentCode");

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

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

                List<ConstructionItemMaster> wrk = new List<ConstructionItemMaster>();

                // 作業名称取得SQL

                StringBuilder strSql = new StringBuilder();

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

                dgvWorkList.Rows.Clear();

                StringBuilder strSql = new StringBuilder();

                strSql.AppendFormat(" Where ItemCode = {0} And DeleteFlg = {1} Order By DisplayOrder ASC"

                                    , m_ItemCode

                // 作業名称取得

                if (!csDB.SelectAction(strSql.ToString(), ref wrk)) return;

                // 作業名称取得SQL

                StringBuilder strSql = new StringBuilder();

                strSql.AppendFormat(" Where SubItemsFlg = {0}", (int)ConstructionItemMaster.SubitemsFlgDef.Exists);

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

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

                List<ConstructionTypeMaster> wrk = new List<ConstructionTypeMaster>();

                // 作業名称取得SQL

                StringBuilder strSql = new StringBuilder();

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

                dgvWorkList.Rows.Clear();

                strSQL.Append("SELECT A.NAMECODE, A.NAMESTRING, B.TYPECODE, B.EXPENSESPERIOD, B.EXPENSESRAITO");

                strSQL.Append(" FROM DIVISIONMASTER A");

                strSQL.AppendFormat(" LEFT JOIN TYPEEXPENSESMASTER B ON B.TYPECODE = {0} AND B.NAMECODE = A.NAMECODE AND B.DELETEFLG = {1}"

                strSQL.AppendFormat(" WHERE A.DIVISIONCODE = {0}", DivCode);

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

                if (!TypeExDB.ExecuteReader(strSQL.ToString(), ref wrklist)) return;

                {

                    if (!dmDB.UpdateFeild(DepCodeKey

                                            , (int)IOMDepartment.NameColumn.DeleteFlg

                                            , false))

                    {

                        dmDB.rollback();

                    }

                    if (!expDB.UpdateFeild(DepCodeKey, 0, 0

                                            , (int)IOMDepartmentExpenses.NameColumn.DeleteFlg

                                            , false))

                    {

                        dmDB.rollback();

                // SQL作成

                StringBuilder strSQL = new StringBuilder();

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

                // 部署取得

                if (!dmDB.SelectAction(strSQL.ToString(), ref dmList)) return false;

                int nNameCode = CommonMotions.cnvInt(dgvMaster.CurrentRow.Cells[(int)DispColumn.NameCode].Value);

                if (!nmDB.UpdateFeild(m_DivisionCode, nNameCode

                                    , (int)IOMDivision.NameColumn.DeleteFlg

                                    , false))

                {

                    nmDB.rollback();

                {

                    StringBuilder strSQL = new StringBuilder();

                    strSQL.Append("Update departmentexpensesmaster");

                    strSQL.AppendFormat(" Where ExpensesPeriod >= {0}", CommonMotions.GetPeriodYear());

                    strSQL.AppendFormat(" And NameCode = {0}", nNameCode);

                    if (!deDB.ExecuteNonQuery(strSQL.ToString(), false))

                // SQL作成

                StringBuilder strSQL = new StringBuilder();

                strSQL.AppendFormat(" Where DivisionCode = {0}", m_DivisionCode);

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

                // 表示順マスタ取得

                if (!cmDB.SelectAction(strSQL.ToString(), ref cm)) return false;

                // SQL作成

                // ValueからKeyを検索

                StringBuilder strSQL = new StringBuilder();

                List<ConstructionTypeMaster> cm = new List<ConstructionTypeMaster>();

                // 区分マスタ取得

                if (!cmDB.SelectAction(strSQL.ToString(), ref cm)) return false;

                StringBuilder strKindWhere = new StringBuilder();

                strKindWhere.Append(m_IoMtype.CreatePrimarykeyString(CommonMotions.cnvInt(cmbTypes.SelectedValue)));

                List<MaterialKindMaster> mKindList = new List<MaterialKindMaster>();

                // 資材種類マスタ存在確認

                if (!m_IoMtype.SelectAction(strKindWhere.ToString(), ref mKindList, false))

            {

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

                StringBuilder strsql = new StringBuilder();

                if (!IoMt.SelectAction(strsql.ToString(), ref itemList)) return;

                if (itemList.Count == 0) return;

                // 資材品目抽出条件

                StringBuilder strSQL = new StringBuilder();

                strSQL.AppendFormat(" Where MaterialKindCode = {0}", strMaterialKindCode);

                if (!m_IoMt.SelectAction(strSQL.ToString(), ref mim,false)) return;

                // データ表示

        {            

            // クリアデータセット

            dgvMaster[(int)DispColumn.RowState, iIndex].Value = DataRowState.Unchanged;

            dgvMaster[(int)DispColumn.DisplayOrder, iIndex].Value = "";

            dgvMaster[(int)DispColumn.MaterialTypesKey, iIndex].Value = "";

            dgvMaster[(int)DispColumn.NameString, iIndex].Value = "";

                            && CommonMotions.cnvString(r.Cells[(int)DispColumn.NameString].Value).Length == 0) continue;

                    // 削除行は処理しない

                    //名称

                    bAns = true;

                // SQL作成

                StringBuilder strSQL = new StringBuilder();

                // 表示順マスタ取得

                if (!m_IoMt.SelectAction(strSQL.ToString(), ref cm, false)) return false;

                // 発注者取得SQL

                StringBuilder strSql = new StringBuilder();

                strSql.Append(orDB.CreatePrimarykeyString(CommonMotions.cnvInt(cmbDivision.SelectedValue.ToString())));

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

                dgvMaster.Rows.Clear();

                // 作業名称取得

                cmbChangeOrdersDivision.SelectedValue = odList.OrderCotegory;

                {

                    label18.Visible = true;

                }

                int DivisionCode = (int)DivisionMaster.DivisionMasterCodeDef.OrderDivision;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(dvDB.CreatePrimarykeyString(DivisionCode));

                if (!dvDB.SelectAction(strSQL.ToString(), ref bvList)) return;

                if (bvList.Count == 0) return;

            this.label8.Name = "label8";

            this.label8.Size = new System.Drawing.Size(139, 25);

            this.label8.TabIndex = 28;

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

            // 

            // txtInput2

            this.label9.Name = "label9";

            this.label9.Size = new System.Drawing.Size(139, 25);

            this.label9.TabIndex = 30;

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

            // 

            // txtInput3

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

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

            this.cmbDepartment.FormattingEnabled = true;

            this.cmbDepartment.Name = "cmbDepartment";

            this.cmbDepartment.Size = new System.Drawing.Size(429, 24);

            this.cmbDepartment.TabIndex = 8;

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

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

            this.cmbLedgerFlg.FormattingEnabled = true;

            this.cmbLedgerFlg.Name = "cmbLedgerFlg";

            this.cmbLedgerFlg.Size = new System.Drawing.Size(139, 24);

            this.cmbLedgerFlg.TabIndex = 13;

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

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

            this.cmbSecManage.FormattingEnabled = true;

            this.cmbSecManage.Name = "cmbSecManage";

            this.cmbSecManage.Size = new System.Drawing.Size(284, 24);

            this.cmbSecManage.TabIndex = 14;

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

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

            this.cmbRefDepartment.FormattingEnabled = true;

            this.cmbRefDepartment.Name = "cmbRefDepartment";

            this.cmbRefDepartment.Size = new System.Drawing.Size(429, 24);

            this.cmbRefDepartment.TabIndex = 19;

                        dgvAssignment.Rows[1].Selected = true;

                    }

                }

                if (iLength == 0)

                {

                    return false;

                }

                return true;

            }

            catch (System.Exception ex)

                // 担当者マスタ：終了年月日・削除フラグ更新

                if (!picDB.UpdateFeild(workRec.PersonCode

                                        , (int)IOMPersonInCharge.ColumnCnt.DeleteFlg

                                        , false))

                {

                    picDB.rollback();

                // 部署マスタを検索する

                StringBuilder strSQL = new StringBuilder();

                if (bDspExistsData)

                else

                    strSQL.Append(" Order By DeleteFlg ASC, DisplayOrder ASC");

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

                joblinkDB.connect(); joblinkDB.beginTran();

                // 削除フラグ

                // データ更新

                if (!sbDB.UpdateAction(strWhere, workList[0], false))

        private string CreateSQL()

        {

            StringBuilder strSQL = new StringBuilder();

            try

            {

                string[] strArray = new string[3];

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("Select Distinct JapaneseSyllabary From SubContractorMaster");

                ArrayList arData = new ArrayList();

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

                if (arData.Count == 0) return;

                }

                // データ削除（論理削除）

                //if (!supDB.DeleteAction(strWhere))

                if (!supDB.UpdateAction(strWhere, orData))

                {

                    MessageBox.Show("削除に失敗しました。", "削除エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                List<SuppliersMaster> wrk = new List<SuppliersMaster>();

                // 仕入先取得SQL

                StringBuilder strSql = new StringBuilder();

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

                dgvMaster.Rows.Clear();

                // データ取得

                cmbVehicleAdministrator.DataSource = null;

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

                // 部署マスタを検索する

                // 担当者マスタ読込

                if (!dmDB.SelectAction(strSQL, ref workList)) return;

                strSQL.Clear();

                if (m_ConstrTypeCode < 1)

                {

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

                    if (!cmpDB.SelectAction(strSQL.ToString(), ref m_ciList)) return;

                }

                    strSQL.Append("               On B.ComponentCode = A.ComponentCode");

                    strSQL.Append("        Inner Join constructiontypemaster AS C");

                    strSQL.Append("               On C.TypeCode = B.TypeCode");

                    strSQL.AppendFormat(" And C.TypeCode = {0}", m_ConstrTypeCode);

                    strSQL.Append(" Order By A.DisplayOrder");

                    ArrayList arrayList = new ArrayList();

            {

                List<ComponentMaster> ciList = new List<ComponentMaster>();

                // 工種マスタ取得

                if (!cmpDB.SelectAction(strSQL, ref ciList)) return false;

                StringBuilder strSQL = new StringBuilder(); ;

                if (m_AllDisplayFlg)

                {   // ----- 全表示

                }

                else

                {   // ----- 大項目キーが指定されてる場合

                    strSQL.Append(", DATE_FORMAT(B.EntryDate, '%Y/%m/%d %H:%i:%s')");

                    strSQL.Append(", DATE_FORMAT(B.UpdateDate, '%Y/%m/%d %H:%i:%s')");

                    strSQL.Append(" FROM ComponentLinkMaster A, ConstructionItemMaster B");

                    strSQL.AppendFormat(" And A.ComponentCode = {0}", m_ComponentCode);

                    strSQL.Append(" And A.ItemCode = B.ItemCode");

                    strSQL.Append(" Order By A.DisplayOrder ASC");

                strSQL.Append(", DATE_FORMAT(B.EntryDate, '%Y/%m/%d %H:%i:%s')");

                strSQL.Append(", DATE_FORMAT(B.UpdateDate, '%Y/%m/%d %H:%i:%s')");

                strSQL.Append(" FROM ComponentLinkMaster A, ConstructionItemMaster B");

                strSQL.AppendFormat(" And A.ComponentCode = {0}", m_ComponentCode);

                strSQL.Append(" And A.ItemCode = B.ItemCode");

                strSQL.Append(" Order By A.DisplayOrder ASC");

                m_SenderList.Add(new KeyValuePair<int, string>(CommonDefine.s_AllMembersCode, CommonDefine.s_AllMembersString));

                // 部署マスタを追加

                // 部署マスタ読込

                if (!dmDB.SelectAction(strSQL2, ref dmList)) return false;

                // データ表示

                m_SenderList.Add(new KeyValuePair<int, string>(0, ""));

                // 担当者マスタを追加

                // 担当者マスタ読込

                if (!picDB.SelectAction(strSQL, ref workList)) return false;

                // データ表示

        private string CreateSQL()

        {

            StringBuilder strSQL = new StringBuilder();

            try

            {

                string[] strArray = new string[3];

                    {

                        // 協力会社マスタ取得

                        strSQL = sbcDB.CreatePrimarykeyString(wrk.InputCode);

                        if (!sbcDB.SelectAction(strSQL, ref sbcRec)) continue;

                    }

                    int iRows = dgvHistory.Rows.Add(++i,

                // SQL作成

                string strSQL = sbcDB.CreatePrimarykeyString(SubContractorCode);

                // 協力会社マスタ取得

                if (!sbcDB.SelectAction(strSQL, ref DataRec)) return false;

            {

                StringBuilder strSQL = new StringBuilder(); ;

                strSQL.Append("Select Distinct JapaneseSyllabary From SubContractorMaster");

                ArrayList arData = new ArrayList();

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

                if (arData.Count == 0) return;

                // SQL作成

                StringBuilder strSQL = new StringBuilder();

                strSQL.AppendFormat(" Where EmployeeClassFlg = {0}", (int)PersonInChargeMaster.EmployeeClassFlgDef.OutSource);

                // 担当者マスタ取得

                if (!personDB.SelectAction(strSQL.ToString(), ref personList)) return;

                    strSQL = personDB.CreatePrimarykeyString(SubContractorCode);

                    strSQL += string.Format(" AND EmployeeClassFlg = {0} And DeleteFlg = {1}"

                                            , (int)PersonInChargeMaster.EmployeeClassFlgDef.OutSource

                    // 担当者マスタ取得

                    if (!personDB.SelectAction(strSQL, ref personRec)) return false;

                    DataRec.CompanyCode = personRec.PersonCode;

        private string CreateSQL()

        {

            StringBuilder strSQL = new StringBuilder();

            try

            {

                string[] strArray = new string[3];

            {

                dgvSearch.Rows.Clear();

                List<SuppliersMaster> sbcList = new List<SuppliersMaster>();

                // SQL作成

            try

            {

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

                if (!IoMt.SelectAction(strsql, ref itemList)) return;

                if (itemList.Count == 0) return;

                sql.AppendLine(" From MaterialItemMaster as Mim");

                sql.AppendLine("      left join MaterialInfo as Mi on Mim.MATERIALITEMCODE = Mi.MATERIALITEMCODE ");

                sql.AppendLine("      left join materialkindmaster as Mk on Mim.MATERIALKINDCODE = Mk.MATERIALKINDCODE ");

                // 条件追加

                //if (strMaterialKindCode.Length == 1 && strMaterialKindCode != "0") 

            try

            {

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

                if (!IoMt.SelectAction(strsql, ref itemList)) return;

                if (itemList.Count == 0) return;

                strSQL.AppendLine(" Where");

                strSQL.AppendFormat(" A.MaterialKindCode = {0}", strMaterialKindCode);

                strSQL.AppendLine(" And B.MATERIALITEMCODE = A.MATERIALITEMCODE");

                strSQL.AppendLine(" And B.RENTCOUNT > 0");

                strSQL.AppendLine(" And C.MATERIALKINDCODE = A.MATERIALKINDCODE");

                //コンボボックスのデータをセットする

                // SQL作成

                // 工種マスタ取得

                if (!picDB.SelectAction(strSQL, ref m_PersonList)) return;

                strSQL.AppendFormat(" Where A.ACTIONSCHEDULEFLG = {0}", (int)DepartmentMaster.ActionScheduleFlgDef.OnDisplay);

                strSQL.Append(" AND A.DEPARTMENTCODE = B.DEPARTMENTCODE");

                strSQL.AppendFormat(" And B.EmployeeClassFlg = {0}", EmployeeClass);

                strSQL.Append(" Order By A.DISPLAYORDER ASC, B.DISPLAYORDER ASC, DateC ASC, DateD ASC, D.SeqNo ASC");

            }

            catch (Exception ex)

                        // ---------------担当者の取得

                        string strPerson = string.Format(" Where PersonCode = {0} And DeleteFlg = {1}"

                                                        , BaseConstructionPersonCode

                        if (!picDB.SelectAction(strPerson, ref picList)) continue;

                        if (picList.Count == 0) continue;

                        ipicDisp = BaseConstructionPersonCode;

                            // ---------------部署の取得

                            string strDepartment = string.Format(" Where DepartmentCode = {0} And DeleteFlg = {1}"

                                                                    , picList[0].DepartmentCode

                            if (!dmDB.SelectAction(strDepartment, ref dmList)) continue;

                            if (dmList.Count == 0) continue;

                            idmDisp = picList[0].DepartmentCode;