public ColumnMap(string columnName, string fieldName, IMetadataMap dataMap)
{
_columnName = columnName;
_fieldName = fieldName;
_dataMap = dataMap;
InitField();
}
public ColumnMap(string columnName, string fieldName, IMetadataMap dataMap)
{
_columnName = columnName;
_fieldName = fieldName;
_dataMap = dataMap;
InitField();
}
public override string GenerateSql(IMetadataMap metadataMap)
{
return string.Format("UPPER({0}) LIKE UPPER('{1}')", metadataMap.GetColumnForField(field), value);
}
public override string GenerateSql(IMetadataMap metadataMap)
{
return string.Format("{0} {1} {2}", metadataMap.GetColumnForField(field), sqlOperator, value);
}
public abstract string GenerateSql(IMetadataMap metadataMap);
public override string GenerateSql(IMetadataMap metadataMap)
{
return(string.Format("{0} {1} {2}", metadataMap.GetColumnForField(field), sqlOperator, value));
}
public override string GenerateSql(IMetadataMap metadataMap)
{
return(string.Format("UPPER({0}) LIKE UPPER('{1}')", metadataMap.GetColumnForField(field), value));
}
public abstract string GenerateSql(IMetadataMap metadataMap);
public FindByNameStatement(string firstName, string lastName, IMetadataMap metadataMap)
{
_firstName = firstName;
_lastName = lastName;
_metadataMap = metadataMap;
}
public SQLMapper()
{
_metadataMap = LoadMetadataMap();
}
public FindByCustomerStatement(Guid customerId, IMetadataMap metadataMap)
{
_customerId = customerId;
_metadataMap = metadataMap;
}
public FindByDateStatement(DateTime orderDate, IMetadataMap metadataMap)
{
_orderDate = orderDate;
_metadataMap = metadataMap;
}