static public bool IsDateTimeFormat(TDS7130_FORMAT format)
{
bool fmt = false;
switch (format)
{
case TdsDataObject.TDS7130_FORMAT.kFmtDate_YMD_HMS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_MDY_HMS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_HMS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_YMD:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_MD:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_MD_H:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_HM:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_YYMD_HMS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_YYMDHM_:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_MDYY_HMS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_MDY:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_YMD_HMS_MS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_MDY_HMS_MS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_YYMD_HMS_MS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_MDYY_HMS_MS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_MS:
case TdsDataObject.TDS7130_FORMAT.kFmtDate_S_MS:
fmt = true;
break;
default:
fmt = false;
break;
}
return(fmt);
}
static public string GetFormatTds2Google(TDS7130_FORMAT format)
{
string fmt = "";
switch (format)
{
case TDS7130_FORMAT.kDefDblFmtFlg:
case TDS7130_FORMAT.kUseFmtFlg:
case TDS7130_FORMAT.kDefFmtFlg:
case TDS7130_FORMAT.kFloat_01_00_FmtFlg:
break;
case TDS7130_FORMAT.kFmtp0:
case TDS7130_FORMAT.kFmtp1:
case TDS7130_FORMAT.kFmtp2:
case TDS7130_FORMAT.kFmtp3:
case TDS7130_FORMAT.kFmtp4:
case TDS7130_FORMAT.kFmtp5:
case TDS7130_FORMAT.kFmtp6:
case TDS7130_FORMAT.kFmtp7:
case TDS7130_FORMAT.kFmtp8:
case TDS7130_FORMAT.kFmtp9:
case TDS7130_FORMAT.kFmtp10:
case TDS7130_FORMAT.kFmtp11:
case TDS7130_FORMAT.kFmtp12:
case TDS7130_FORMAT.kFmtp13:
case TDS7130_FORMAT.kFmtp14:
case TDS7130_FORMAT.kFmtp15:
fmt = "0." + new String('0', (int)format);
break;
case TDS7130_FORMAT.kFmtE0:
case TDS7130_FORMAT.kFmtE1:
case TDS7130_FORMAT.kFmtE2:
case TDS7130_FORMAT.kFmtE3:
case TDS7130_FORMAT.kFmtE4:
case TDS7130_FORMAT.kFmtE5:
case TDS7130_FORMAT.kFmtE6:
case TDS7130_FORMAT.kFmtE7:
break;
// long format
case TDS7130_FORMAT.kFmtDate_YMD_HMS:
fmt = "yy/MM/dd HH:mm:ss";
break;
case TDS7130_FORMAT.kFmtDate_MDY_HMS:
fmt = "MM/dd/yy HH:mm:ss";
break;
case TDS7130_FORMAT.kFmtDate_HMS:
fmt = "HH:mm:ss";
break;
case TDS7130_FORMAT.kFmtDate_YMD:
fmt = "yy/MM/dd";
break;
case TDS7130_FORMAT.kFmtDate_MD:
fmt = "MM/dd";
break;
case TDS7130_FORMAT.kFmtDate_MD_H:
fmt = "MM/dd HH";
break;
case TDS7130_FORMAT.kFmtDate_HM:
fmt = "HH:MM";
break;
case TDS7130_FORMAT.kFmtDate_YYMD_HMS:
fmt = "yyyy/MM/dd HH:mm:ss";
break;
case TDS7130_FORMAT.kFmtDate_YYMDHM_:
fmt = "yyyyMMddHH";
break;
case TDS7130_FORMAT.kFmtDate_MDYY_HMS:
fmt = "MM/dd/yyyy HH:mm:ss";
break;
case TDS7130_FORMAT.kFmtDate_MDY:
fmt = "MM/dd/yy";
break;
case TDS7130_FORMAT.kFmtDate_YMD_HMS_MS:
fmt = "yy/MM/dd HH:mm:ss.ff";
break;
case TDS7130_FORMAT.kFmtDate_MDY_HMS_MS:
fmt = "MM/dd/yy HH:mm:ss.ff";
break;
case TDS7130_FORMAT.kFmtDate_YYMD_HMS_MS:
fmt = "yyyy/MM/dd HH:mm:ss.ff";
break;
case TDS7130_FORMAT.kFmtDate_MDYY_HMS_MS:
fmt = "MM/dd/yyyy HH:mm:ss.ff";
break;
case TDS7130_FORMAT.kFmtDate_MS:
fmt = "FF";
break;
case TDS7130_FORMAT.kFmtDate_S_MS:
fmt = "ss.ff";
break;
case TDS7130_FORMAT.kFmtDate_UTC:
fmt = "yyyy-MM-ddTHH:mm:ss.ffzzz";
break;
}
return(fmt);
}
