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

        /// 住所ファイル名称

        public static string s_AddreddFileName= "KEN_ALL";

        public static string s_FrozenFileExtension = ".ZIP";

        public static string s_CSVFileExtension = ".CSV";

        /// <summary>

        /// 住所ファイルパス

        /// </summary>

        public static string s_AddressWorkInput = System.Environment.CurrentDirectory + @".\KEN_ALL_IN.CSV";

        public static int s_SystemVersion = 227;

            AddressConvert = 132,               // 132:郵便番号変換処理

                                                                                { (int)MaintenanceExecuteNo.AddressConvert,             "住所データ変換処理" },        // 132

                        case (int)ClsExcute.MaintenanceExecuteNo.AddressConvert:

                            MaintenanceExecuteNo_AddressConvert(m_ProcControlPara[NowPoint]);

                            break;

                int ProcessNo = (int)MaintenanceExecuteNo.BudgetCodeSum;

        #region 予算書集計コードマスタ

        /// <summary>

        /// 予算書集計コードマスタ

        /// </summary>

        public static void MaintenanceExecuteNo_AddressConvert(ProcessParameter CurrentPara)

        {

            // 

            FrmAddressConvert frm = new FrmAddressConvert();

            try

            {

                // 起動・編集フラグ

                int ProcessNo = (int)MaintenanceExecuteNo.AddressConvert;

                int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;

                if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg))

                {

                    BackProcess();

                    return;

                }

                frm.ShowDialog();

            }

            catch (Exception ex)

            {

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

                BackProcess();

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

        private DateTime    m_CompDate = DateTime.MaxValue;     // 終了年月日

        private DateTime    m_CompDate = DateTime.MaxValue;     // 担当終了年月日

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

                    // strSQL.Append(" And (B.SalesPersonCode IN (Select B1.PersonCode From PersonInChargeMaster B1");

                    strSQL.AppendFormat(" And (B.SalesPersonCode IN (Select B1.PersonCode From {0} As B1", strChgDep.ToString());

                    strSQL.Append("                                  Where B1.DepartmentCode IN (SELECT B2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER B2");

                    strSQL.AppendFormat("                                                        WHERE B2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" And (B.ConstructionPersonCode IN (Select B3.PersonCode From PersonInChargeMaster B3");

                    strSQL.AppendFormat(" And (B.ConstructionPersonCode IN (Select B3.PersonCode From {0} As B3", strChgDep.ToString());

                    strSQL.Append("                                         Where B3.DepartmentCode IN (SELECT B4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER B4");

                    strSQL.AppendFormat("                                                               WHERE B4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or B.CONSTRSUBPERSONCODE IN (Select B5.PersonCode From PersonInChargeMaster B5");

                    strSQL.AppendFormat(" OR B.CONSTRSUBPERSONCODE IN (Select B5.PersonCode From {0} As B5", strChgDep.ToString());

                    strSQL.Append("                                    Where B5.DepartmentCode IN (SELECT B6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER B6");

                    strSQL.AppendFormat("                                                          WHERE B6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or B.ConstructionInstructor IN (Select B7.PersonCode From PersonInChargeMaster B7");

                    strSQL.AppendFormat(" OR B.ConstructionInstructor IN (Select B7.PersonCode From {0} As B7", strChgDep.ToString());

                    strSQL.Append("                                       Where B7.DepartmentCode IN (SELECT B8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER B8");

                    strSQL.AppendFormat("                                                             WHERE B8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                strSQL.Append(" Inner Join (Select * From ChgChargeDep As H) As ChgMan");

                strSQL.Append(" Inner Join(Select * From ChgChargeDep As H) As ChgMan");

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

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

                    strSQL.AppendFormat(" And (A.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSQL.Append("                                  Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSQL.AppendFormat("                                                        WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSQL.AppendFormat(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSQL.Append("                                         Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSQL.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSQL.AppendFormat(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSQL.Append("                                    Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSQL.AppendFormat("                                                          WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSQL.AppendFormat(" Or A.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSQL.Append("                                       Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSQL.AppendFormat("                                                             WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                DateTime CompDate = DateTime.MaxValue;

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

                SetcmbDepartment();

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

                SetcmbPersons();

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

                    strSecurity.AppendFormat(" And (D.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSecurity.Append("                            Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSecurity.AppendFormat("                                                  WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    strSecurity.AppendFormat("       And (D.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSecurity.Append("                                         Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSecurity.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    strSecurity.AppendFormat("       Or D.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSecurity.Append("                                    Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSecurity.AppendFormat("                                                          WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    strSecurity.AppendFormat("       Or D.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSecurity.Append("                                       Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSecurity.AppendFormat("                                                             WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                strSQL.Append(" Inner Join chgchargedep As I");

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

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

                    strSQL.AppendFormat(" And (A.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSQL.Append("                                  Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSQL.AppendFormat("                                                        WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSQL.AppendFormat(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSQL.Append("                                         Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSQL.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSQL.AppendFormat(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSQL.Append("                                    Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSQL.AppendFormat("                                                          WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSQL.AppendFormat(" Or A.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSQL.Append("                                       Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSQL.AppendFormat("                                                             WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

                    // strSecurity.Append(" And (D.SalesPersonCode IN (Select A1.PersonCode From PersonInChargeMaster A1");

                    strSecurity.AppendFormat(" And (D.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSecurity.Append("                                  Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSecurity.AppendFormat("                                                        WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSecurity.Append(" And (D.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSecurity.AppendFormat(" And (D.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSecurity.Append("                                         Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSecurity.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSecurity.Append(" Or D.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSecurity.AppendFormat(" Or D.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSecurity.Append("                                       Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSecurity.AppendFormat("                                                             WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSecurity.Append(" Or D.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSecurity.AppendFormat(" Or D.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSecurity.Append("                                       Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSecurity.AppendFormat("                                                             WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

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

                    strSQL.AppendFormat(" And (A.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSQL.Append("                                  Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSQL.AppendFormat("                                                        WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSQL.AppendFormat(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSQL.Append("                                         Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSQL.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSQL.AppendFormat(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSQL.Append("                                      Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSQL.AppendFormat("                                                            WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSQL.AppendFormat(" Or A.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSQL.Append("                                         Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSQL.AppendFormat("                                                               WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

        private void CreateSecuritySQL(ref StringBuilder strSQL)

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

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

                    strSQL.AppendFormat(" And (A.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSQL.Append("                                  Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSQL.AppendFormat("                                                        WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

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

                    // strSQL.Append(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSQL.AppendFormat(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSQL.AppendFormat("                                   Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSQL.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSQL.AppendFormat(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSQL.Append("                                      Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSQL.AppendFormat("                                                            WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSQL.AppendFormat(" Or A.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSQL.Append("                                         Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSQL.AppendFormat("                                                               WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or (A.ConstructionStatusFlg >= {0} And A.ConstructionPersonCode = 0)", iStatus);          // ????????????o???H???S??????????????????\??

                    strSQL.AppendFormat(" Or (A.ConstructionStatusFlg = {0}", iStatus2);                                            // ???????p??????p???????????????

                    strSQL.AppendFormat(" And A.TransferConstruction = {0}))", CommonMotions.LoginUserData.DepartmentCode);

                    strSQL.AppendFormat(" And (A.SalesPersonCode = {0}", CommonMotions.LoginUserData.PersonCode);

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

                    strSQL.AppendFormat(" And (A.ConstructionPersonCode = {0}", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or A.CONSTRSUBPERSONCODE = {0}", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or A.ConstructionInstructor = {0})))", CommonMotions.LoginUserData.PersonCode);

        private void CreateInitSQL(ref StringBuilder strSQL)

                StringBuilder wrkBuff = new StringBuilder();

                strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                strSQL.Append(" And (A.ConstructionCode = A1.ConstructionCode");

                strSQL.AppendFormat(" And A1.ApprovalCode = {0}", ApprovalCode);

                strSQL.AppendFormat(" And A1.SeqNo = 1 And A1.APPROVALSTATUS = {0})", (int)CommonDefine.ApprovalStatus.Approval);

                strSQL.Append(" AND (A.CONSTRUCTIONCODE = A2.CONSTRUCTIONCODE AND A2.SEQNO = A11.LinkCode)");

                strSQL.Append(GetDepartmentString());

                strSQL.Append(GetPersonString());

                strSQL.Append(wrkBuff.ToString());

                strSQL.Append(" GROUP BY");

                strSQL.Append(" A.CONSTRUCTIONCODE");

                strSQL.Append(", A1.ORDERNO");

                strSQL.AppendFormat(" ORDER BY {0} ASC, {1} ASC, {2} ASC, {3} DESC, {4} DESC",

                StringBuilder strSQL = new StringBuilder();

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

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

                SetcmbDepartment();

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

                SetcmbPersons();

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

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

                    strSQL.AppendFormat(" And (B.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSQL.Append("                                  Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSQL.AppendFormat("                                                        WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" And (B.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSQL.AppendFormat(" And (B.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSQL.Append("                                         Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSQL.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or B.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSQL.AppendFormat(" Or B.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSQL.Append("                                    Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSQL.AppendFormat("                                                          WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or B.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSQL.AppendFormat(" Or B.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSQL.Append("                                       Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSQL.AppendFormat("                                                             WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

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

                    strSQL.AppendFormat(" And (A.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSQL.Append("                                  Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSQL.AppendFormat("                                                        WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSQL.AppendFormat(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSQL.Append("                                         Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSQL.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSQL.AppendFormat(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSQL.Append("                                    Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSQL.AppendFormat("                                                          WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSQL.AppendFormat(" Or A.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSQL.Append("                                       Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSQL.AppendFormat("                                                             WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                    // ?????J?n?I???N????

                    int nTargetYear = (int)numUDConstPro.Value;

                    string strdtStart = CommonMotions.GetOpeningEndDate(nTargetYear, true).ToShortDateString();

                    string strdtEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false).ToShortDateString();

                    StringBuilder strChgDep = new StringBuilder();

                    strChgDep.Append(" (Select * From chgchargedep As H");

                    strChgDep.AppendFormat(" Where (DATE(H.StartDate) <= DATE('{0}')", strdtEnd);

                    strChgDep.AppendFormat(" And DATE('{0}') <= DATE(H.CompDate)))", strdtStart);

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

                    strSQL.AppendFormat(" And (A.SalesPersonCode IN (Select A1.PersonCode From {0} As A1", strChgDep.ToString());

                    strSQL.Append("                                  Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2");

                    strSQL.AppendFormat("                                                        WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSQL.AppendFormat(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From {0} As A3", strChgDep.ToString());

                    strSQL.Append("                                         Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4");

                    strSQL.AppendFormat("                                                               WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSQL.AppendFormat(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From {0} As A5", strChgDep.ToString());

                    strSQL.Append("                                    Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6");

                    strSQL.AppendFormat("                                                          WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    // strSQL.Append(" Or A.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSQL.AppendFormat(" Or A.ConstructionInstructor IN (Select A7.PersonCode From {0} As A7", strChgDep.ToString());

                    strSQL.Append("                                       Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8");

                    strSQL.AppendFormat("                                                             WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                                                    new KeyValuePair<int, string>((int)ClsExcute.MaintenanceExecuteNo.AddressConvert, string.Empty),        // 郵便番号引込

                                                };

namespace ProcessManagement.Forms.SubForms

{

    partial class FrmAddressConvert

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

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

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.groupBoxEx1.SuspendLayout();

            this.SuspendLayout();

            // 

            // label1

            // 

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

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

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

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

            this.label1.Location = new System.Drawing.Point(169, 240);

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(360, 30);

            this.label1.TabIndex = 10;

            this.label1.Text = "工事管理システム住所データ";

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

            // 

            // label2

            // 

            this.label2.BackColor = System.Drawing.Color.MintCream;

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

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

            this.label2.Location = new System.Drawing.Point(12, 240);

            this.label2.Name = "label2";

            this.label2.Size = new System.Drawing.Size(149, 30);

            this.label2.TabIndex = 11;

            this.label2.Text = "出力ファイル";

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

            // 

            // btnCancel

            // 

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

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

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

            this.btnCancel.Location = new System.Drawing.Point(700, 286);

            this.btnCancel.Margin = new System.Windows.Forms.Padding(3, 4, 3, 4);

            this.btnCancel.Name = "btnCancel";

            this.btnCancel.Size = new System.Drawing.Size(128, 32);

            this.btnCancel.TabIndex = 13;

            this.btnCancel.Text = "キャンセル";

            this.btnCancel.UseVisualStyleBackColor = false;

            this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);

            // 

            // btnOK

            // 

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

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

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

            this.btnOK.Location = new System.Drawing.Point(563, 286);

            this.btnOK.Margin = new System.Windows.Forms.Padding(3, 4, 3, 4);

            this.btnOK.Name = "btnOK";

            this.btnOK.Size = new System.Drawing.Size(128, 32);

            this.btnOK.TabIndex = 12;

            this.btnOK.Text = "引込実行";

            this.btnOK.UseVisualStyleBackColor = false;

            this.btnOK.Click += new System.EventHandler(this.btnOK_Click);

            // 

            // label3

            // 

            this.label3.BackColor = System.Drawing.Color.Linen;

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

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

            this.label3.Location = new System.Drawing.Point(12, 70);

            this.label3.Name = "label3";

            this.label3.Size = new System.Drawing.Size(149, 30);

            this.label3.TabIndex = 11;

            this.label3.Text = "入力ファイル";

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

            // 

            // label4

            // 

            this.label4.BackColor = System.Drawing.Color.Linen;

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

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

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

            this.label4.Location = new System.Drawing.Point(169, 70);

            this.label4.Name = "label4";

            this.label4.Size = new System.Drawing.Size(360, 30);

            this.label4.TabIndex = 10;

            this.label4.Text = "ダウンロード郵便番号データ";

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

            // 

            // lblInputPath

            // 

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

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

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

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

            this.lblInputPath.Location = new System.Drawing.Point(169, 100);

            this.lblInputPath.Name = "lblInputPath";

            this.lblInputPath.Size = new System.Drawing.Size(660, 30);

            this.lblInputPath.TabIndex = 10;

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

            // 

            // label6

            // 

            this.label6.BackColor = System.Drawing.Color.Linen;

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

            this.label6.ForeColor = System.Drawing.Color.Navy;

            this.label6.Location = new System.Drawing.Point(12, 100);

            this.label6.Name = "label6";

            this.label6.Size = new System.Drawing.Size(149, 30);

            this.label6.TabIndex = 11;

            this.label6.Text = "ファイルパス";

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

            // 

            // BtnSearch

            // 

            this.BtnSearch.BackColor = System.Drawing.Color.DarkOrange;

            this.BtnSearch.Location = new System.Drawing.Point(700, 138);

            this.BtnSearch.Name = "BtnSearch";

            this.BtnSearch.Size = new System.Drawing.Size(128, 32);

            this.BtnSearch.TabIndex = 14;

            this.BtnSearch.Text = "ファイル検索";

            this.BtnSearch.UseVisualStyleBackColor = false;

            this.BtnSearch.Click += new System.EventHandler(this.BtnSearch_Click);

            // 

            // label5

            // 

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

            this.label5.BackColor = System.Drawing.Color.MintCream;

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

            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(222, 20);

            this.label5.Name = "label5";

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

            this.label5.TabIndex = 15;

            this.label5.Text = "住　所　デ　ー　タ　変　換　処　理";

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

            // 

            // ExecMessage

            // 

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

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

            this.ExecMessage.Font = new System.Drawing.Font("ＭＳ ゴシック", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.ExecMessage.ForeColor = System.Drawing.Color.Red;

            this.ExecMessage.Location = new System.Drawing.Point(2, 282);

            this.ExecMessage.Name = "ExecMessage";

            this.ExecMessage.Size = new System.Drawing.Size(840, 40);

            this.ExecMessage.TabIndex = 16;

            this.ExecMessage.Text = "変換処理中です、しばらくお待ちください。";

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

            this.ExecMessage.Visible = false;

            // 

            // groupBoxEx1

            // 

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

            this.groupBoxEx1.BorderColor = System.Drawing.Color.Black;

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

            this.groupBoxEx1.Location = new System.Drawing.Point(12, 138);

            this.groupBoxEx1.Name = "groupBoxEx1";

            this.groupBoxEx1.Size = new System.Drawing.Size(680, 80);

            this.groupBoxEx1.TabIndex = 18;

            this.groupBoxEx1.TabStop = false;

            // 

            // label7

            // 

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

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

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

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

            this.label7.Name = "label7";

            this.label7.Size = new System.Drawing.Size(660, 60);

            this.label7.TabIndex = 18;

            this.label7.Text = "※入力ファイルとなるダウンロード郵便番号データは\r\n　日本郵便の郵便番号データダウンロードより\r\n　該当する都道府県、または全国一括をダウンロードしてください。";

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

            // 

            // FrmAddressConvert

            // 

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

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

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

            this.ClientSize = new System.Drawing.Size(844, 331);

            this.Controls.Add(this.groupBoxEx1);

            this.Controls.Add(this.BtnSearch);

            this.Controls.Add(this.label5);

            this.Controls.Add(this.btnCancel);

            this.Controls.Add(this.btnOK);

            this.Controls.Add(this.label6);

            this.Controls.Add(this.label3);

            this.Controls.Add(this.label2);

            this.Controls.Add(this.lblInputPath);

            this.Controls.Add(this.label4);

            this.Controls.Add(this.label1);

            this.Controls.Add(this.ExecMessage);

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

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

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

            this.Margin = new System.Windows.Forms.Padding(4);

            this.MaximizeBox = false;

            this.MinimizeBox = false;

            this.Name = "FrmAddressConvert";

            this.ShowIcon = false;

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

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

            this.groupBoxEx1.ResumeLayout(false);

            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.Label label1;

        private System.Windows.Forms.Label label2;

        private System.Windows.Forms.Button btnCancel;

        private System.Windows.Forms.Button btnOK;

        private System.Windows.Forms.Label label3;

        private System.Windows.Forms.Label label4;

        private System.Windows.Forms.Label lblInputPath;

        private System.Windows.Forms.Label label6;

        private System.Windows.Forms.Button BtnSearch;

        private System.Windows.Forms.Label label5;

        private System.Windows.Forms.Label ExecMessage;

        private CustomControls.GroupBoxEx groupBoxEx1;

        private System.Windows.Forms.Label label7;

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.IO;

using System.IO.Compression;

using System.Diagnostics;

using System.Text.RegularExpressions;

using Microsoft.VisualBasic.FileIO;

using ProcessManagement.Common;

namespace ProcessManagement.Forms.SubForms

{

    public partial class FrmAddressConvert : Form

    {

        #region 定義

        // log4netログを使用する

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

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

        public FrmAddressConvert()

        {

            InitializeComponent();

        }

        #endregion

        #region 入力ファイル検索

        /// <summary>

        /// 入力ファイル検索

        /// </summary>

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

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

        private void BtnSearch_Click(object sender, EventArgs e)

        {

            // ファイル選択画面オープン

            GetInputPath();

        }

        #endregion

        #region ファイル選択画面オープン

        /// <summary>

        /// ファイル選択画面オープン

        /// </summary>

        private void GetInputPath()

        {

            try

            {

                // OpenFileDialogクラスのインスタンスを作成

                OpenFileDialog ofd = new OpenFileDialog();

                // 「ファイル名」で表示される文字列を指定する

                ofd.FileName = "KEN_ALL.ZIP";

                //はじめに表示されるフォルダを指定する

                ofd.InitialDirectory = @"C:\";

                //[ファイルの種類]に表示される選択肢を指定する

                ofd.Filter = "ZIPファイル(*.zip)|*.zip|すべてのファイル(*.*)|*.*";

                //[ファイルの種類]ではじめに選択されるものを指定する

                ofd.FilterIndex = 1;

                //タイトルを設定する

                ofd.Title = "開くファイルを選択してください";

                //ダイアログボックスを閉じる前に現在のディレクトリを復元するようにする

                ofd.RestoreDirectory = true;

                //ダイアログを表示する

                if (ofd.ShowDialog() != DialogResult.OK) ofd.FileName = string.Empty;

                //OKボタンがクリックされたとき、選択されたファイル名を表示する

                lblInputPath.Text = ofd.FileName;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 変換実行ボタン押下

        /// <summary>

        /// 変換実行ボタン押下

        /// </summary>

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

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

        private void btnOK_Click(object sender, EventArgs e)

        {

            // ファイル選択無しは処理しない

            if (lblInputPath.Text.Length < 1)

            {

                MessageBox.Show("解凍元ファイルを選択してください。",

                                "ファイル選択エラー",

                                MessageBoxButtons.OK, MessageBoxIcon.Error);

                return;

            }

            string InputPath = string.Empty;

            // 郵便番号ファイル解凍処理

            if (!ExpandZipFile(ref InputPath)) return;

            if (InputPath.Length < 1) return;

            // データ変換処理

            ExecDataConvert(InputPath);

        }

        #endregion

        #region 郵便番号ファイル解凍処理

        /// <summary>

        /// 郵便番号ファイル解凍処理

        /// </summary>

        /// <returns></returns>

        private bool ExpandZipFile(ref string InputPath)

        {

            try

            {

                // 解凍元ファイルパス取得

                string ZipFilePath = @lblInputPath.Text;

                // 添付パス取得

                string tempPath = Path.GetTempPath();

                // ----- 解凍先ファイルパス作成

                InputPath = string.Format("{0}{1}", ZipFilePath.Substring(0, (ZipFilePath.Length - 4))

                                                    , CommonDefine.s_CSVFileExtension);

                // 末尾から検索し見つかった位置を取得する

                int nFind = InputPath.LastIndexOf('\\');

                InputPath = string.Format("{0}{1}", tempPath,

                                                        InputPath.Substring((nFind + 1)));

                // 解凍ファイルが存在すれば削除

                if (File.Exists(InputPath)) File.Delete(InputPath);

                // ダウンロードした「現場監督秘書（本体）zip解凍

                ZipFile.ExtractToDirectory(ZipFilePath, tempPath);

                return true;

            }

            catch (Exception ex)

            {

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

                MessageBox.Show("解凍元ファイルの解凍に失敗しました。",

                                "解凍エラー",

                                MessageBoxButtons.OK,

                                MessageBoxIcon.Error);

                return false;

            }

        }

        #endregion

        #region データ変換処理

        /// <summary>

        /// データ変換処理

        /// </summary>

        private void ExecDataConvert(string InputPath)

        {

            // 処理時間を計測する

            Stopwatch stw = new Stopwatch();

            stw.Start();

            try

            {

                SetControlVisible(true);

                //ファイルの読み込み

                string[] InputString = File.ReadAllLines(InputPath, Encoding.Default);

                StringBuilder sb = new StringBuilder();

                string OutPutPath = string.Format("{0}{1}{2}", System.Environment.CurrentDirectory,

                                                                CommonDefine.s_AddreddFileName,

                                                                CommonDefine.s_CSVFileExtension);

                using (StreamWriter OutPutFile 

                                = new StreamWriter(CommonDefine.s_AddressWorkOutput,

                                                    false,

                                                    Encoding.GetEncoding("shift_jis")))

                {

                    foreach (string CurrentString in InputString)

                    {

                        //　カンマで区切られた文字列を取得

                        string[] sArray = CurrentString.Split(',');

                        sb.Clear();

                        sb.AppendFormat(",,{0},,,,{1},{2},", sArray[2], sArray[6], sArray[7]);

                        if (sArray[8].IndexOf("以下に掲載がない場合") < 0)

                        {

                            sb.Append(sArray[8]);

                        }

                        sb.Replace(@"""", "");

                        OutPutFile.WriteLine(sb.ToString());

                    }

                }

            }

            catch (Exception ex)

            {

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

                MessageBox.Show("郵便番号ファイルの読込に失敗しました。", "変換エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

            finally

            {

                SetControlVisible(false);

                stw.Stop();

                string DspMsg = "住所データ変換処理を終了しました。\r\n";

                DspMsg += "工事管理システムの住所データが変更されました。\r\n";

                //DspMsg += string.Format("処理時間：{0}.{1}秒", stw.Elapsed.Seconds, stw.Elapsed.Milliseconds);

                MessageBox.Show(DspMsg, "処理終了", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

        }

        #endregion

        #region 実行コントロール表示・非表示

        /// <summary>

        /// 実行コントロール表示・非表示

        /// </summary>

        private void SetControlVisible(bool bvisible)

        {

            try

            {

                ExecMessage.Visible = bvisible;

                btnOK.Visible = !bvisible;

                btnCancel.Visible = !bvisible;

                this.Update();

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region キャンセルボタン押下

        /// <summary>

        /// キャンセルボタン押下

        /// </summary>

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

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

        private void btnCancel_Click(object sender, EventArgs e)

        {

            this.Close();

        }

        #endregion

        #region ×ボタン

        /// <summary>

        /// ×ボタン

        /// </summary>

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

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

        private void FrmAddressConvert_FormClosing(object sender, FormClosingEventArgs e)

        {

            // 前プロセスに戻る

            ClsExcute.BackProcess();

        }

        #endregion

    }

}

<?xml version="1.0" encoding="utf-8"?>

<root>

  <!-- 

    Microsoft ResX Schema 

    Version 2.0

    The primary goals of this format is to allow a simple XML format 

    that is mostly human readable. The generation and parsing of the 

    various data types are done through the TypeConverter classes 

    associated with the data types.

    Example:

    ... ado.net/XML headers & schema ...

    <resheader name="resmimetype">text/microsoft-resx</resheader>

    <resheader name="version">2.0</resheader>

    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>

    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>

    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>

    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>

    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">

        <value>[base64 mime encoded serialized .NET Framework object]</value>

    </data>

    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>

        <comment>This is a comment</comment>

    </data>

    There are any number of "resheader" rows that contain simple 

    name/value pairs.

    Each data row contains a name, and value. The row also contains a 

    type or mimetype. Type corresponds to a .NET class that support 

    text/value conversion through the TypeConverter architecture. 

    Classes that don't support this are serialized and stored with the 

    mimetype set.

    The mimetype is used for serialized objects, and tells the 

    ResXResourceReader how to depersist the object. This is currently not 

    extensible. For a given mimetype the value must be set accordingly:

    Note - application/x-microsoft.net.object.binary.base64 is the format 

    that the ResXResourceWriter will generate, however the reader can 

    read any of the formats listed below.

    mimetype: application/x-microsoft.net.object.binary.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.soap.base64

    value   : The object must be serialized with