プロジェクト

全般

プロフィール

リビジョン 78

山内 が8年以上前に追加

自動配信（運用VPS対応）バージョンは1

差分を表示:

branches/src/ProcessManagement/ProcessManagement/Common/CommonDefine.cs
44 44 
        // FTPパスワード
45 45 
        public const string s_FTP_PASSWORD = "hyou5210";
46 46 
        // FTPつなぎ先パス
47 
        public const string s_FTP_SERVER_PATH = "ftp://203.137.92.122:990/HYOU/";
47 
        public const string s_FTP_SERVER_PATH = "ftp://203.137.94.208:990/HYOU/";
48 48 
        // 更新モジュールフォルダ,ファイル名
49 49 
        public const string s_UPDATE_MODULE = "UpDateCopy";
50 50 
        // UVERSIONキー名
......
70 70 
        /// 住所ファイル
71 71 
        /// </summary>
72 72 
        public static string s_AddressFilePath = System.Environment.CurrentDirectory + @".\KEN_ALL.CSV";
73 
        public static string s_AddressWorkInput = @"D:\Temp\_KEN_ALL.CSV";
74 
        public static string s_AddressWorkOutput = @"D:\Temp\KEN_ALL.CSV";
75 
        //public static string s_AddressFilePath = "C:\\temp\\KEN_ALL.CSV";
73 
        public static string s_AddressWorkInput = System.Environment.CurrentDirectory + @".\KEN_ALL.CSV";
74 
        public static string s_AddressWorkOutput = System.Environment.CurrentDirectory + @".\KEN_ALL.CSV";
76 75 
        #endregion
77 76 

  		




  78
  77
  
    
        #region システムセキュリティ定義


  		












  

    
      branches/src/ProcessManagement/ProcessManagement/Common/CommonMotions.cs
    
  





  2331
  2331
  
    
                string strSQL = "SELECT A.MONTHLYSALARY, A.YEARSALARY, A.PERSONCODE, A.STARTDATE FROM PERSONSALARYMASTER A,";


  		




  2332
  2332
  
    
                strSQL += " (SELECT PERSONCODE, MAX(STARTDATE) sDate FROM PERSONSALARYMASTER";


  		




  2333
  2333
  
    
                strSQL += string.Format(" WHERE PERSONCODE = {0}", PersonCode);


  		




  2334
  
  
    
                strSQL += string.Format(" AND DATE(NOW()) <= STR_TO_DATE('{0}', '%Y/%m/%d)", GetData.ToShortDateString());


  		




  
  2334
  
    
                strSQL += string.Format(" AND DATE(NOW()) <= STR_TO_DATE('{0}', '%Y/%m/%d')", GetData.ToShortDateString());


  		




  2335
  2335
  
    
                strSQL += " GROUP BY PERSONCODE) B";


  		




  2336
  2336
  
    
                strSQL += " WHERE A.PERSONCODE = B.PERSONCODE AND A.STARTDATE = B.sDate";


  		




  2337
  2337
  
    

  		












  

    
      branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs
    
  





  14
  14
  
    
        /// <summary>


  		




  15
  15
  
    
        /// 本体バージョン


  		




  16
  16
  
    
        /// </summary>


  		




  17
  
  
    
        public static int s_SystemVersion = 3;


  		




  
  17
  
    
        public static int s_SystemVersion = 1;


  		




  18
  18
  
    

  		




  19
  19
  
    
        /// <summary>


  		




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


  		












  

    
      branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOSystemExecute.cs
    
  





  36
  36
  
    
        {


  		




  37
  37
  
    
            PrimaryCode = 0,


  		




  38
  38
  
    
            TargetDate,


  		




  
  39
  
    
            SystemVersion,


  		




  
  40
  
    
            UpDateCopyVersion,


  		




  39
  41
  
    
            EntryDate,


  		




  40
  42
  
    
            UpdateDate,


  		




  41
  43
  
    
        }


  		




  ......




  66
  68
  
    
            string strcmd = "SELECT";


  		




  67
  69
  
    
            strcmd += "  PrimaryCode";


  		




  68
  70
  
    
            strcmd += " ,DATE_FORMAT(TargetDate, '%Y/%m/%d %H:%i:%s')";


  		




  
  71
  
    
            strcmd += " ,SystemVersion";


  		




  
  72
  
    
            strcmd += " ,UpDateCopyVersion";


  		




  69
  73
  
    
            strcmd += " ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";


  		




  70
  74
  
    
            strcmd += " ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";


  		




  71
  75
  
    
            strcmd += " FROM SystemExecute";


  		




  ......




  354
  358
  
    
                // データ取得


  		




  355
  359
  
    
                wrk.PrimaryCode = int.Parse(objwrk[(int)TableColumn.PrimaryCode].ToString());


  		




  356
  360
  
    
                wrk.TargetDate = DateTime.Parse(objwrk[(int)TableColumn.TargetDate].ToString());


  		




  
  361
  
    
                wrk.SystemVersion = int.Parse(objwrk[(int)TableColumn.SystemVersion].ToString());


  		




  
  362
  
    
                wrk.UpDateCopyVersion = int.Parse(objwrk[(int)TableColumn.UpDateCopyVersion].ToString());


  		




  357
  363
  
    

  		




  358
  364
  
    
                wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());


  		




  359
  365
  
    
                wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());


  		




  360
  366
  
    
            }


  		




  361
  367
  
    
            catch (MySqlException myex)


  		




  362
  368
  
    
            {


  		




  363
  
  
    
                logger.ErrorFormat("オラクルエラー：{0}：{1}", CommonMotions.GetMethodName(), myex.Message);


  		




  
  369
  
    
                logger.ErrorFormat("ＭｙＳＱＬエラー：{0}：{1}", CommonMotions.GetMethodName(), myex.Message);


  		




  364
  370
  
    
            }


  		




  365
  371
  
    
            catch (Exception ex)


  		




  366
  372
  
    
            {


  		












  

    
      branches/src/ProcessManagement/ProcessManagement/Properties/AssemblyInfo.cs
    
  





  10
  10
  
    
[assembly: AssemblyConfiguration("")]


  		




  11
  11
  
    
[assembly: AssemblyCompany("H-YOUシステム開発")]


  		




  12
  12
  
    
[assembly: AssemblyProduct("現場監督秘書")]


  		




  13
  
  
    
[assembly: AssemblyCopyright("H-YOU Systems Copyright ©  2015")]


  		




  
  13
  
    
[assembly: AssemblyCopyright("H-YOU Systems Copyright ©  2015-2017")]


  		




  14
  14
  
    
[assembly: AssemblyTrademark("")]


  		




  15
  15
  
    
[assembly: AssemblyCulture("")]


  		




  16
  16
  
    

  		




  ......




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


  		




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


  		




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


  		




  35
  
  
    
[assembly: AssemblyVersion("0.0.0.0")]


  		




  36
  
  
    
[assembly: AssemblyFileVersion("0.9.9.9")]


  		




  
  35
  
    
[assembly: AssemblyVersion("1.0.0.0")]


  		




  
  36
  
    
[assembly: AssemblyFileVersion("1.0.0.0")]


  		




  37
  37
  
    
// Log4netを使用する


  		




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


  		












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