public int compareColumn(ColumnInformation x, ColumnInformation y)
{
if (x.getId() < y.getId())
{
return(-1);
}
else
{
return(0);
}
}
public String convertValue(byte[] data, ColumnInformation colInfo)
{
int colType = (int)colInfo.getColType();
int maxLength = colInfo.getMaxLength();
if (colInfo.getName().Contains("Time"))
{
long timeValue = (long)BitConverter.ToUInt64(data, 0);
if (timeValue == 0)
{
return("0");
}
DateTime datetime = DateTime.FromBinary(timeValue);
datetime = datetime.AddYears(1600);
datetime = datetime.AddHours(Int32.Parse(UTCAddHour));
datetime = datetime.AddMinutes(Int32.Parse(UTCAddMinute));
return(datetime.ToString("yyyy-MM-dd HH:mm:ss"));
}
if (colType == 1) //bool
{
return("NULL");
}
else if (colType == 1) //bool
{
return(data[0] == 1 ? "TRUE" : "FALSE");
}
else if (colType == 2) //byte
{
return(data[0].ToString());
}
else if (colType == 3) //short
{
return(BitConverter.ToInt16(data, 0).ToString());
}
else if (colType == 4) //integer
{
return(BitConverter.ToInt32(data, 0).ToString());
}
else if (colType == 5) //binary
{
double temp = (double)BitConverter.ToInt64(data, 0) / 1E4;
return(temp.ToString());
}
else if (colType == 6) //float
{
return(BitConverter.ToSingle(data, 0).ToString());
}
else if (colType == 7) //double
{
return(BitConverter.ToDouble(data, 0).ToString());
}
else if (colType == 8) //dateTime
{
long longVar = BitConverter.ToInt64(data, 0);
DateTime dateTimeVar = new DateTime(1980, 1, 1).AddMilliseconds(longVar);
dateTimeVar.AddHours((Double)Int32.Parse(UTCAddHour));
dateTimeVar.AddMinutes((Double)Int32.Parse(UTCAddMinute));
return(dateTimeVar.ToString());
}
else if (colType == 9) //binary
{
string hex = BitConverter.ToString(data);
return(hex.Replace("-", ""));
}
else if (colType == 10) //text
{
if (maxLength == 255)
{
return(Encoding.UTF8.GetString(data));
}
else
{
return(Encoding.Unicode.GetString(data));
}
}
else if (colType == 11) //binary
{
string hex = BitConverter.ToString(data);
return(hex.Replace("-", ""));
}
else if (colType == 12) //text
{
return(Encoding.Unicode.GetString(data));
}
else if (colType == 13) //integer
{
return(BitConverter.ToInt32(data, 0).ToString());
}
else if (colType == 14) //unsigned integer
{
return(BitConverter.ToUInt32(data, 0).ToString());
}
else if (colType == 15) //unsigned long long
{
return(BitConverter.ToUInt64(data, 0).ToString());
}
else if (colType == 16) //text
{
return(Encoding.UTF8.GetString(data));
}
else if (colType == 17) //unsigned short
{
return(BitConverter.ToInt16(data, 0).ToString());
}
else
{
return("UNKNOWN");
}
}
