{"id":342,"date":"2011-05-25T16:21:13","date_gmt":"2011-05-25T07:21:13","guid":{"rendered":"http:\/\/www.climb.co.jp\/blog_dbmoto\/?p=342"},"modified":"2011-05-25T16:21:13","modified_gmt":"2011-05-25T07:21:13","slug":"%e3%82%b8%e3%83%a5%e3%83%aa%e3%82%a2%e3%83%b3%e3%83%87%e3%83%bc%e3%83%88%e3%81%ae%e3%83%ac%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3%e3%80%90%e3%83%aa%e3%82%a2%e3%83%ab%e3%82%bf","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/342","title":{"rendered":"\u30b8\u30e5\u30ea\u30a2\u30f3\u30c7\u30fc\u30c8\u306e\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3010\u30ea\u30a2\u30eb\u30bf\u30a4\u30e0\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30c4\u30fc\u30ebDBMoto\u3011"},"content":{"rendered":"

AS\/400\u3067\u30b8\u30e5\u30ea\u30a2\u30f3\u30c7\u30fc\u30c8\u3092\u6301\u3064\u30c7\u30fc\u30bf\u306f\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4ecb\u3057\u3066yyyy\/MM\/dd\u5f62\u5f0f\u306b\u5909\u63db\u3057\u3066\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

\u30bd\u30fc\u30b9\uff1aAS\/400\uff08SALDATE\u304c\u30b8\u30e5\u30ea\u30a2\u30f3\u30c7\u30fc\u30c8\u3067\u3059\uff09
\"\"<\/p>\n

\u30bf\u30fc\u30b2\u30c3\u30c8\uff1aOracle\uff08SALDATE\u304c\u30b8\u30e5\u30ea\u30a2\u30f3\u30c7\u30fc\u30c8\u304b\u3089\u5909\u63db\u3057\u3066yyyyMMdd\u5f62\u5f0f\u306b\u3059\u308b\u4e88\u5b9a\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u3067\u3059\uff09
\"\"<\/p>\n

\u25cf\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u306b\u4e0b\u8a18\u3092\u8a18\u8ff0\u3057\u307e\u3059<\/p>\n

Imports Microsoft.VisualBasic<\/span><\/strong><\/span><\/p>\n

Imports DBMotoPublic<\/span><\/strong><\/span><\/p>\n

Imports DBMotoScript<\/span><\/strong><\/span><\/p>\n

Imports DBRS.GlobalScript<\/span><\/strong><\/span><\/p>\n

Imports System.Data<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

Namespace DBRS<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

 <\/span><\/strong><\/p>\n

    <\/span>Public Class GlobalScript : Inherits IGlobalScript<\/span><\/strong><\/span><\/p>\n

      <\/span>Public Shared globalCounter As Integer<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

     <\/span>‘This function takes a numeric Julian date in the format YYYDDD where<\/span><\/strong><\/span><\/p>\n

     <\/span>‘YYY is the number of years since 1900 and DDD is the day of the year<\/span><\/strong><\/span><\/p>\n

     <\/span>‘and returns a VB.Net date value or Null if the original value was null<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

     <\/span>‘One adds this function to the global script and uses it in a mapping<\/span><\/strong><\/span><\/p>\n

     <\/span>‘expression.  <\/span>Be sure to set the source column to Use Unmapped<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

       <\/span>Public Shared Function JulianToDate(obj as Object) as Object<\/span><\/strong><\/span><\/p>\n

         <\/span>‘If the value is null return null<\/span><\/strong><\/span><\/p>\n

         <\/span>If obj Is Nothing Then Return Nothing<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

         <\/span>‘If the value is non numeric return null<\/span><\/strong><\/span><\/p>\n

         <\/span>If Not IsNumeric(obj) Then Return Nothing<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

         <\/span>‘Get the year value<\/span><\/strong><\/span><\/p>\n

         <\/span>Dim intYears as Integer<\/span><\/strong><\/span><\/p>\n

         <\/span>intYears = Int(obj\/1000)<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

         <\/span>‘Get the day of the year and subtract 1 because we’ll be adding<\/span><\/strong><\/span><\/p>\n

         <\/span>‘this value to January 1<\/span><\/strong><\/span><\/p>\n

         <\/span>Dim intDays as Integer<\/span><\/strong><\/span><\/p>\n

         <\/span>intDays = (obj – intYears * 1000) – 1<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

         <\/span>‘Calculate the date<\/span><\/strong><\/span><\/p>\n

         <\/span>Dim datDate as Date<\/span><\/strong><\/span><\/p>\n

         <\/span>datDate = CDate(“1\/1\/” & Str(1900 + intYears)).AddDays(intDays)<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

         <\/span>‘Return the date<\/span><\/strong><\/span><\/p>\n

        <\/span>Return datDate<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

      <\/span>End Function<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

    <\/span>End Class<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

    <\/span>Public Class MappingRule : Inherits IMappingRule<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

    <\/span>End Class<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

    <\/span>Public Class GlobalEvents : Inherits IGlobalEvents<\/span><\/strong><\/span><\/p>\n

 <\/span><\/strong><\/p>\n

    <\/span>End Class<\/span><\/strong><\/span><\/p>\n

End Namespace<\/span><\/strong><\/span><\/p>\n

\u30de\u30c3\u30d4\u30f3\u30b0\u753b\u9762\u306b\u3066\u3001\u5bfe\u8c61\u306e\u30d5\u30a3\u30fc\u30eb\u30c9\u3067Map to Expression\u3092\u958b\u304d\u307e\u3059\u3002
\"\"<\/p>\n

User functions\u304b\u3089\u5148\u307b\u3069\u8a2d\u5b9a\u3057\u305f\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u95a2\u6570\u3092\u9078\u629e\u3057\u3001\u5f15\u6570\u306b\u5bfe\u8c61\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002
\"\"<\/p>\n

\u25cf\u30ea\u30d5\u30ec\u30c3\u30b7\u30e5\u7d50\u679c
\"\"<\/p>\n

\u25cf\u30df\u30e9\u30fc\u30ea\u30f3\u30b0\u7d50\u679c
\"\"<\/p>\n

\u6b63\u3057\u304f\u5909\u63db\u3057\u3066\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

AS\/400\u3067\u30b8\u30e5\u30ea\u30a2\u30f3\u30c7\u30fc\u30c8\u3092\u6301\u3064\u30c7\u30fc\u30bf\u306f\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4ecb\u3057\u3066yyyy\/MM\/dd\u5f62\u5f0f\u306b\u5909\u63db\u3057\u3066\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3067\u3059\u3002 \u30bd\u30fc\u30b9\uff1aAS\/400\uff08SALDATE\u304c\u30b8\u30e5\u30ea\u30a2\u30f3\u30c7\u30fc\u30c8\u3067\u3059\uff09 \u30bf\u30fc\u30b2\u30c3\u30c8\uff1aOracl … \u7d9a\u304d\u3092\u8aad\u3080 →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-342","post","type-post","status-publish","format-standard","hentry","category-syniti"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=342"}],"version-history":[{"count":0,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/342\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}