数据库操作数据类型转换类

CString CEx11_3App::VariantToCString(VARIANT var)//数据类型转换
{
       CString strValue;
    _variant_t var_t;
    _bstr_t bst_t;
    time_t cur_time;
    CTime time_value;
    COleCurrency var_currency;
    switch(var.vt)
    {
    case VT_EMPTY:strValue=_T("");break;
    case VT_UI1:strValue.Format ("%d",var.bVal);break;
    case VT_I2:strValue.Format ("%d",var.iVal );break;
    case VT_I4:strValue.Format ("%d",var.lVal);break;
    case VT_R4:strValue.Format ("%f",var.fltVal);break;
    case VT_R8:strValue.Format ("%f",var.dblVal);break;
    case VT_CY:
        var_currency=var;
        strValue=var_currency.Format(0);
        break;
    case VT_BSTR:
        var_t=var;
        bst_t=var_t;
        strValue.Format ("%s",(const char*)bst_t);
        break;
    case VT_NULL:strValue=_T("");break;
    case VT_DATE:
        cur_time=var.date;
        time_value=cur_time;
        strValue=time_value.Format("%Y-%m-%d");
        break;
    case VT_BOOL:strValue.Format ("%d",var.boolVal );break;
    default:strValue=_T("");break;
    }
    return strValue;

 

转载于:https://www.cnblogs.com/Daniell/p/7694904.html