public ListColumn(string member, string label, HorizontalAlign align, TypeColumn type)
{
this.Member = member;
this.Label = label;
this.Align = align;
this.Type = type;
}
public Value(String columnName, TypeColumn type, Object value)
{
this.column = new Column (columnName, type);
switch(type){
case(TypeColumn.VARCHAR):
this.s_value = (String) value;
break;
case(TypeColumn.TEXT):
this.s_value = (String) value;
break;
case(TypeColumn.BOOLEAN):
this.b_value = (bool) value;
break;
case(TypeColumn.LONGBLOB):
this.s_value = (String) value;
break;
case(TypeColumn.BLOB):
this.s_value = (String) value;
break;
case(TypeColumn.FLOAT):
this.f_value = (float) value;
break;
case(TypeColumn.DOUBLE):
this.d_value = (double) value;
break;
}
}
public TypeValue this[TypeRow row, TypeColumn column]
{
get
{
var key = Tuple.Create(row, column);
if (leftTable.Values.ContainsKey(key))
{
return(leftTable.Values[key]);
}
return(default);
public virtual EntityStatus GetEntityStatus(object item)
{
TypeTable schema = GetSchema(item.GetType());
if (schema.HasIdentity)
{
//Get the first Identity Column
TypeColumn column = schema.IdentityColumn;
var value = column.GetFieldValue(item);
if (Decimal.Zero.Equals(value))
{
return(EntityStatus.Insert);
}
return(EntityStatus.Update);
}
return(EntityStatus.Unchanged);
}
/// <summary>
/// A simple column
/// </summary>
/// <param name="left">X left coordinate</param>
/// <param name="right">X right coordinate</param>
/// <param name="traces">Traces, only when is partial</param>
/// <param name="typeColumn">Type of column</param>
/// <returns></returns>
protected ColumnDataDTO CreateColumn(int left, int right, List <GerberTraceDTO> traces, TypeColumn typeColumn)
{
return(new ColumnDataDTO()
{
Left = left,
Right = right,
TypeColumn = typeColumn,
Traces = traces
});
}
private object GetValue(object entity, string member, TypeColumn type)
{
object value = entity;
string[] memberParts = member.Split('.');
for (int index = 0; index < memberParts.Length; index++)
{
value = value.GetType().GetProperty(memberParts[index]).GetValue(value, null);
if (value == null) break;
}
if (type == TypeColumn.Bool)
{
if (Convert.ToBoolean(value))
{
if (string.IsNullOrEmpty(TrueImage))
{
return "<input type=\"checkbox\" checked=\"checked\" disabled=\"disabled\" />";
}
else
{
string path = Page.ResolveUrl(TrueImage);
return string.Format("<img src=\"{0}\" alt=\"{1}\" />", path, bool.TrueString);
}
}
else
{
if (string.IsNullOrEmpty(FalseImage))
{
return "<input type=\"checkbox\" disabled=\"disabled\" />";
}
else
{
string path = Page.ResolveUrl(FalseImage);
return string.Format("<img src=\"{0}\" alt=\"{1}\" />", path, bool.FalseString);
}
}
}
else if (type == TypeColumn.Image)
{
if(value!=null)
{
string path = Page.ResolveUrl(value.ToString());
return string.Format("<img src=\"{0}\" alt=\"{1}\" />", path, value);
}
}
return value;
}
public void setValue(TypeColumn type, Object value)
{
switch(type){
case(TypeColumn.VARCHAR):
this.s_value = (String) value;
break;
case(TypeColumn.TEXT):
this.s_value = (String) value;
break;
case(TypeColumn.BOOLEAN):
this.b_value = (bool) value;
break;
case(TypeColumn.LONGBLOB):
this.s_value = (String) value;
break;
case(TypeColumn.BLOB):
this.s_value = (String) value;
break;
case(TypeColumn.FLOAT):
this.f_value = (float) value;
break;
case(TypeColumn.DOUBLE):
this.d_value = (double) value;
break;
}
}
public void setColumn(String columnName, TypeColumn type)
{
this.column = new Column (columnName, type);
}
public override ICommand CreateInsertCommand(object data)
{
Type typeT = data.GetType();
string uniqueId = "26ABBE10-3D2A-40be-ABAC-F92EF9040608";
if (!CommandCache.ContainsKey(string.Format(CACHE_KEY, uniqueId, typeT.FullName)))
{
Anito.Data.Schema.TypeTable schemaTable = Provider.GetSchema(typeT);
Command sqlCommand = new Command();
StringBuilder commandTextBuilder = new StringBuilder();
StringBuilder paramBuilder = new StringBuilder();
StringBuilder columnBuilder = new StringBuilder();
TypeColumn identityColumn = null;
foreach (TypeColumn column in (from col in schemaTable where !col.ViewOnly select col))
{
if (column.IsIdentity)
{
identityColumn = column;
continue;
}
if (sqlCommand.Parameters.ContainsKey(string.Format("{0}{1}", PARAM_IDENTIFIER, column.Name)))
{
continue;
}
if (columnBuilder.Length > 0 && paramBuilder.Length > 0)
{
columnBuilder.Append(COMMA);
paramBuilder.Append(COMMA);
}
columnBuilder.Append(column.Name);
paramBuilder.Append(PARAM_IDENTIFIER + column.Name);
if (!sqlCommand.Parameters.ContainsKey(string.Format("{0}{1}", PARAM_IDENTIFIER, column.Name)))
{
sqlCommand.AddParam(string.Format("{0}{1}", PARAM_IDENTIFIER, column.Name));
}
}
commandTextBuilder.Append(string.Format("{0} {1} {2}",
INSERT, INTO, schemaTable.UpdateSource));
commandTextBuilder.Append(OPEN_PARENTHESES);
commandTextBuilder.Append(columnBuilder.ToString());
commandTextBuilder.Append(CLOSE_PARENTHESES);
commandTextBuilder.Append(SPACE);
commandTextBuilder.Append(VALUES + OPEN_PARENTHESES);
commandTextBuilder.Append(paramBuilder.ToString());
commandTextBuilder.Append(CLOSE_PARENTHESES + SEMI_COLON);
if (identityColumn != null)
{
commandTextBuilder.Append(string.Format("SELECT {0} FROM {1} WHERE {2} = (SELECT IDENT_CURRENT('{3}'));"
, schemaTable.ColumnList
, schemaTable.ViewSource
, identityColumn.Name
, schemaTable.ViewSource));
}
sqlCommand.SqlCommand.CommandText = commandTextBuilder.ToString();
CommandCache.Add(string.Format(CACHE_KEY, uniqueId, typeT.FullName), sqlCommand);
}
return(CommandCache[string.Format(CACHE_KEY, uniqueId, typeT.FullName)]);
}
public Column(String name, TypeColumn type)
{
this.name = name;
this.type = type;
}
public Column(String name, TypeColumn type, int size)
{
this.name = name;
this.type = type;
this.size = size;
}
public ListColumn(string member, string label, HorizontalAlign align, TypeColumn type, string Class)
: this(member, label, align, type)
{
this.Class = Class;
}
