/// <summary>
/// This is used for Markup
/// </summary>
/// <param name="businessName"></param>
/// <param name="dataType"></param>
/// <param name="type"></param>
public USCItem(string businessName, string sqlExpression, SQLDBType dataType, DSIconType type)
{
BusinessName = businessName;
SQLExpression = sqlExpression;
DataType = dataType;
Type = type;
IsValid = true;
}
private SQLDBType GetSqlTypeFromString(string dataType)
{
SQLDBType dbType = new SQLDBType();
if (string.IsNullOrEmpty(dataType))
{
dbType.Name = SQLTypeName.UNKNOW_TYPE;
return(dbType);
}
dataType = dataType.ToUpper();
if (dataType.Equals(SQLTypeName.BIGINT.ToString()))
{
dbType.Name = SQLTypeName.BIGINT;
}
else if (dataType.Equals(SQLTypeName.BINARY.ToString()))
{
dbType.Name = SQLTypeName.BINARY;
}
else if (dataType.Equals(SQLTypeName.BIT.ToString()))
{
dbType.Name = SQLTypeName.BIT;
}
else if (dataType.Equals(SQLTypeName.CHAR.ToString()))
{
dbType.Name = SQLTypeName.CHAR;
}
else if (dataType.Equals(SQLTypeName.DATETIME.ToString()))
{
dbType.Name = SQLTypeName.DATETIME;
}
else if (dataType.Equals(SQLTypeName.DECIMAL.ToString()))
{
dbType.Name = SQLTypeName.DECIMAL;
}
else if (dataType.Equals(SQLTypeName.FLOAT.ToString()))
{
dbType.Name = SQLTypeName.FLOAT;
}
else if (dataType.Equals(SQLTypeName.IMAGE.ToString()))
{
dbType.Name = SQLTypeName.IMAGE;
}
else if (dataType.Equals(SQLTypeName.INT.ToString()))
{
dbType.Name = SQLTypeName.INT;
}
else if (dataType.Equals(SQLTypeName.MONEY.ToString()))
{
dbType.Name = SQLTypeName.MONEY;
}
else if (dataType.Equals(SQLTypeName.NCHAR.ToString()))
{
dbType.Name = SQLTypeName.NCHAR;
}
else if (dataType.Equals(SQLTypeName.NTEXT.ToString()))
{
dbType.Name = SQLTypeName.NTEXT;
}
else if (dataType.Equals(SQLTypeName.NUMERIC.ToString()))
{
dbType.Name = SQLTypeName.NUMERIC;
}
else if (dataType.Equals(SQLTypeName.NVARCHAR.ToString()))
{
dbType.Name = SQLTypeName.NVARCHAR;
}
else if (dataType.Equals(SQLTypeName.REAL.ToString()))
{
dbType.Name = SQLTypeName.REAL;
}
else if (dataType.Equals(SQLTypeName.SMALLMONEY.ToString()))
{
dbType.Name = SQLTypeName.SMALLMONEY;
}
else if (dataType.Equals(SQLTypeName.SMALLDATETIME.ToString()))
{
dbType.Name = SQLTypeName.SMALLDATETIME;
}
else if (dataType.Equals(SQLTypeName.SMALLINT.ToString()))
{
dbType.Name = SQLTypeName.SMALLINT;
}
else if (dataType.Equals(SQLTypeName.SQL_VARIANT.ToString()))
{
dbType.Name = SQLTypeName.SQL_VARIANT;
}
else if (dataType.Equals(SQLTypeName.TEXT.ToString()))
{
dbType.Name = SQLTypeName.TEXT;
}
else if (dataType.Equals(SQLTypeName.TIMESTAMP.ToString()))
{
dbType.Name = SQLTypeName.TIMESTAMP;
}
else if (dataType.Equals(SQLTypeName.TINYINT.ToString()))
{
dbType.Name = SQLTypeName.TINYINT;
}
else if (dataType.Equals(SQLTypeName.UNIQUEIDENTIFIER.ToString()))
{
dbType.Name = SQLTypeName.UNIQUEIDENTIFIER;
}
else if (dataType.Equals(SQLTypeName.VARBINARY.ToString()))
{
dbType.Name = SQLTypeName.VARBINARY;
}
else if (dataType.Equals(SQLTypeName.VARCHAR.ToString()))
{
dbType.Name = SQLTypeName.VARCHAR;
}
else if (dataType.Equals(SQLTypeName.XML.ToString()))
{
dbType.Name = SQLTypeName.XML;
}
else
{
dbType.Name = SQLTypeName.UNKNOW_TYPE;
}
return(dbType);
}
