public Field(string columnName, object value)
: this(columnName)
{
this.Value = value;
if (value is double || value is decimal)
{
this.DataType = DbTypes.Numeric;
}
else if (value is int || value is long)
{
this.DataType = DbTypes.Integer;
}
else if (value is DateTime)
{
this.DataType = DbTypes.DateTime;
}
else if (value is bool)
{
this.DataType = DbTypes.SmallInt;
}
else if (value is byte[])
{
this.DataType = DbTypes.Blob;
}
}
public Reemplazo(object buscar, object reemplazarCon)
{
this.Buscar = buscar;
this.ReemplazarCon = reemplazarCon;
if(buscar is int)
this.Tipo = Lfx.Data.DbTypes.Integer;
else if (buscar is double || buscar is decimal)
this.Tipo = Lfx.Data.DbTypes.Numeric;
else if (buscar is DateTime)
this.Tipo = Lfx.Data.DbTypes.DateTime;
}
public Tag(Connection dataBase, string tableName, Lfx.Data.Row fromRow)
{
this.DataBase = dataBase;
this.TableName = tableName;
this.Id = System.Convert.ToInt32(fromRow["id_tag"]);
this.FieldName = fromRow["fieldname"].ToString();
this.Label = fromRow["label"].ToString();
if (fromRow["extra"] != null)
this.Extra = fromRow["extra"].ToString();
string FldType = fromRow["fieldtype"].ToString();
switch(FldType) {
case "relation":
this.FieldType = DbTypes.Integer;
string[] RelationFields = this.Extra.Split(new char[] { ',' });
string ReferenceTable = RelationFields[0], ReferenceColumn, DetailColumn;
if(RelationFields.Length >= 2)
ReferenceColumn = RelationFields[1];
else
ReferenceColumn = dataBase.Tables[ReferenceTable].PrimaryKey;
if(RelationFields.Length >= 3)
DetailColumn = RelationFields[2];
else
DetailColumn = "nombre";
this.Relation = new Relation(this.FieldName, ReferenceTable, ReferenceColumn, DetailColumn);
if (RelationFields.Length >= 4)
LblType = RelationFields[3];
else
LblType = null;
break;
default:
this.FieldType = Lfx.Data.Types.FromSqlType(FldType);
break;
}
if (fromRow["inputtype"] != null && fromRow["inputtype"].ToString() != string.Empty)
this.InputFieldType = (Lfx.Data.InputFieldTypes)(Enum.Parse(typeof(Lfx.Data.InputFieldTypes), fromRow["inputtype"].ToString()));
this.Nullable = System.Convert.ToBoolean(fromRow["fieldnullable"]);
this.Internal = System.Convert.ToBoolean(fromRow["internal"]);
this.Access = System.Convert.ToInt32(fromRow["access"]);
this.DefaultValue = fromRow["fielddefault"];
if (this.DefaultValue is DBNull)
this.DefaultValue = null;
}
public Field(string columnName, object value)
: this(columnName)
{
this.Value = value;
if (value is double || value is decimal)
this.DataType = DbTypes.Numeric;
else if (value is int || value is long)
this.DataType = DbTypes.Integer;
else if (value is DateTime)
this.DataType = DbTypes.DateTime;
else if (value is bool)
this.DataType = DbTypes.SmallInt;
else if (value is byte[])
this.DataType = DbTypes.Blob;
}
public Reemplazo(object buscar, object reemplazarCon)
{
this.Buscar = buscar;
this.ReemplazarCon = reemplazarCon;
if (buscar is int)
{
this.Tipo = Lfx.Data.DbTypes.Integer;
}
else if (buscar is double || buscar is decimal)
{
this.Tipo = Lfx.Data.DbTypes.Numeric;
}
else if (buscar is DateTime)
{
this.Tipo = Lfx.Data.DbTypes.DateTime;
}
}
public Field(string columnName, DbTypes fieldType, object fieldValue)
: this(columnName, fieldValue)
{
this.DataType = fieldType;
}
public Field(string columnName, DbTypes fieldType, object fieldValue)
: this(columnName, fieldValue)
{
this.DataType = fieldType;
}
public Tag(Connection dataBase, string tableName, Lfx.Data.Row fromRow)
{
this.DataBase = dataBase;
this.TableName = tableName;
this.Id = System.Convert.ToInt32(fromRow["id_tag"]);
this.FieldName = fromRow["fieldname"].ToString();
this.Label = fromRow["label"].ToString();
if (fromRow["extra"] != null)
{
this.Extra = fromRow["extra"].ToString();
}
string FldType = fromRow["fieldtype"].ToString();
switch (FldType)
{
case "relation":
this.FieldType = DbTypes.Integer;
string[] RelationFields = this.Extra.Split(new char[] { ',' });
string ReferenceTable = RelationFields[0], ReferenceColumn, DetailColumn;
if (RelationFields.Length >= 2)
{
ReferenceColumn = RelationFields[1];
}
else
{
ReferenceColumn = dataBase.Tables[ReferenceTable].PrimaryKey;
}
if (RelationFields.Length >= 3)
{
DetailColumn = RelationFields[2];
}
else
{
DetailColumn = "nombre";
}
this.Relation = new Relation(this.FieldName, ReferenceTable, ReferenceColumn, DetailColumn);
if (RelationFields.Length >= 4)
{
LblType = RelationFields[3];
}
else
{
LblType = null;
}
break;
default:
this.FieldType = Lfx.Data.Types.FromSqlType(FldType);
break;
}
if (fromRow["inputtype"] != null && fromRow["inputtype"].ToString() != string.Empty)
{
this.InputFieldType = (Lfx.Data.InputFieldTypes)(Enum.Parse(typeof(Lfx.Data.InputFieldTypes), fromRow["inputtype"].ToString()));
}
this.Nullable = System.Convert.ToBoolean(fromRow["fieldnullable"]);
this.Internal = System.Convert.ToBoolean(fromRow["internal"]);
this.Access = System.Convert.ToInt32(fromRow["access"]);
this.DefaultValue = fromRow["fielddefault"];
if (this.DefaultValue is DBNull)
{
this.DefaultValue = null;
}
}
