public static string getType(string dbtype)
{
switch (dbtype)
{
case "string":
case "String":
return "string";
break;
case "Int32": return "number";
break;
case "Int16": return "number";
break;
case "Int64": return "number";
break;
case "DateTime": return "datetime";
break;
}
return "string";
}