/// <summary>
/// SQL3LogNumberFld()
/// </summary>
/// <param name="sqlvar"></param>
public static void SQL3LogNumberFld(Sql3SqlVar sqlvar)
{
short shortVal = 0;
long longVal = 0;
int printFieldLen;
float floatVal = 0.0F;
switch (sqlvar.SqlType)
{
case Sql3Type.SQL3TYPE_I2:
case Sql3Type.SQL3TYPE_I4:
case Sql3Type.SQL3TYPE_R4:
case Sql3Type.SQL3TYPE_R8:
if (sqlvar.SqlLen == 2)
{
shortVal = short.Parse(sqlvar.SqlData.ToString());
Logger.Instance.WriteToLog(string.Format("SQL3LogNumberFld(): sqlvar.SqlData = {0}", shortVal), true);
}
else if (sqlvar.SqlLen == 4)
{
if (sqlvar.typeAffinity == TypeAffinity.TYPE_AFFINITY_REAL)
{
floatVal = float.Parse(sqlvar.SqlData.ToString());
Logger.Instance.WriteToLog(string.Format("SQL3LogNumberFld():sqlvar.SqlData = {0}", floatVal), true);
}
else
{
longVal = long.Parse(sqlvar.SqlData.ToString());
Logger.Instance.WriteToLog(string.Format("SQL3LogNumberFld():sqlvar.SqlData = {0}", longVal), true);
}
}
else
{
Logger.Instance.WriteToLog(string.Format("SQL3LogNumberFld(): sqlvar.SqlData = {0}", sqlvar.SqlData), true);
}
break;
default:
if (sqlvar.SqlLen <= 40)
{
printFieldLen = (int)sqlvar.SqlLen;
Logger.Instance.WriteToLog(string.Format("SQL3LogNumberFld(): sqlvar.SqlData = {0}", sqlvar.SqlData), true);
}
else
{
Logger.Instance.WriteToLog("SQL3LogNumberFld(): sqlvar->sqllen bigger than 40, db_crsr->buf is not printed", true);
}
break;
}
}
/// <summary>
/// SQL3LogSqldataOutput()
/// </summary>
/// <param name="sqlvar"></param>
public static void SQL3LogSqldataOutput(Sql3SqlVar sqlVar)
{
int fldLen;
if (sqlVar.NullIndicator == 1)
{
Logger.Instance.WriteToLog("\n\tRESULT: NULL", true);
}
else
{
switch (sqlVar.SqlType)
{
case Sql3Type.SQL3TYPE_STR:
case Sql3Type.SQL3TYPE_DATE:
if (sqlVar.SqlLen < 40)
{
fldLen = sqlVar.SqlLen;
Logger.Instance.WriteToLog(string.Format("\n\tRESULT: {0}", sqlVar.SqlData), true);
}
else
{
Logger.Instance.WriteToLog(string.Format("\n\tRESULT TRUNCATED TO 40: {0}", sqlVar.SqlData), true);
}
break;
case Sql3Type.SQL3TYPE_WSTR:
case Sql3Type.SQL3TYPE_BSTR:
if (sqlVar.SqlLen < 40)
{
fldLen = (sqlVar.SqlLen / 2) - 1;
Logger.Instance.WriteToLog(string.Format("\n\tRESULT: {0}", sqlVar.SqlData), true);
}
else
{
Logger.Instance.WriteToLog(string.Format("\n\tRESULT TRUNCATED TO 40: {0}", sqlVar.SqlData), true);
}
break;
case Sql3Type.SQL3TYPE_UI1:
case Sql3Type.SQL3TYPE_I2:
case Sql3Type.SQL3TYPE_I4:
switch (sqlVar.SqlLen)
{
case 1:
Logger.Instance.WriteToLog(string.Format(" \n\tRESULT: {0}", sqlVar.SqlData), true);
break;
case 2:
Logger.Instance.WriteToLog(string.Format(" \n\tRESULT: {0}", short.Parse(sqlVar.SqlData.ToString())), true);
break;
case 4:
Logger.Instance.WriteToLog(string.Format(" \n\tRESULT: {0}", long.Parse(sqlVar.SqlData.ToString())), true);
break;
}
break;
case Sql3Type.SQL3TYPE_R4:
case Sql3Type.SQL3TYPE_R8:
switch (sqlVar.SqlLen)
{
case 4:
Logger.Instance.WriteToLog(string.Format(" \n\tRESULT: {0}", float.Parse(sqlVar.SqlData.ToString())), true);
break;
case 8:
Logger.Instance.WriteToLog(string.Format(" \n\tRESULT: {0}", double.Parse(sqlVar.SqlData.ToString())), true);
break;
}
break;
case Sql3Type.SQL3TYPE_BYTES:
Logger.Instance.WriteToLog(string.Format(" \n\tRESULT: {0}", sqlVar.SqlData), true);
break;
case Sql3Type.SQL3TYPE_BOOL:
Logger.Instance.WriteToLog(string.Format(" \n\tRESULT: {0}", sqlVar.SqlData.ToString()), true);
break;
}
}
}