根據UserInfo的Locale 來計算datetime format sequence
Settings> User Option:
public static int getSystemDateIntSequence()
{
/*
// The example displays the following output:
// 'd' standard format string:
// M/d/yyyy
// M/d/yy
// MM/dd/yy
// MM/dd/yyyy
// yy/MM/dd
// yyyy-MM-dd
// dd-MMM-yy */
int sequence;
// System.Globalization.DateTimeFormatInfo formatInfo = System.Globalization.DateTimeFormatInfo::get_CurrentInfo();
// str shortDatePatten = formatInfo.get_ShortDatePattern();
System.Globalization.CultureInfo cultureInfo = System.Globalization.CultureInfo::CurrentUICulture;
UserInfo userinfo;
select firstonly userinfo where userinfo.id == curUserId();
cultureInfo = System.Globalization.CultureInfo::GetCultureInfo(userinfo.PreferredLocale);
str shortDatePatten = cultureInfo.DateTimeFormat.ShortDatePattern;
info('CurrentCulture.Name : ' + cultureInfo.Name);
info('CurrentCulture.shortDatePatten : ' + cultureInfo.DateTimeFormat.ShortDatePattern);
shortDatePatten = strreplace(shortDatePatten, "MM" , "M");
shortDatePatten = strreplace(shortDatePatten, "dd" , "d");
shortDatePatten = strreplace(shortDatePatten, "yyyy" , "y");
shortDatePatten = strreplace(shortDatePatten, "yy" , "y");
shortDatePatten = strrem(shortDatePatten, "/" );
shortDatePatten = strrem(shortDatePatten, "-" );
shortDatePatten = strreplace(shortDatePatten, "M" , "2");
shortDatePatten = strreplace(shortDatePatten, "d" , "1");
shortDatePatten = strreplace(shortDatePatten, "y" , "3");
sequence = str2Int(shortDatePatten);
if(!sequence)
throw error("cannot get user date format");
// sequence = 213;
info(strFmt('sequence :%1' , sequence));
return sequence;
}
留言列表