public void TestSqlConnectionStringsCrud()
{
// Setup
var text = Helper.GetUnicodeString();
var entity = new StringsClass
{
SessionId = Guid.NewGuid(),
ColumnChar = text,
ColumnNChar = text,
ColumnNText = text,
ColumnNVarChar = text,
ColumnText = text,
ColumnVarChar = text
};
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = connection.Insert(entity);
// Act Query
var data = connection.Query <StringsClass>(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnChar, data.ColumnChar.Trim());
Assert.AreEqual(entity.ColumnNChar, data.ColumnNChar.Trim());
Assert.AreEqual(entity.ColumnNText, data.ColumnNText);
Assert.AreEqual(entity.ColumnNVarChar, data.ColumnNVarChar);
Assert.AreEqual(entity.ColumnText, data.ColumnText);
Assert.AreEqual(entity.ColumnVarChar, data.ColumnVarChar);
}
}
public void TestSqlConnectionStringsNullCrud()
{
// Setup
var entity = new StringsClass
{
SessionId = Guid.NewGuid(),
ColumnChar = null,
ColumnNChar = null,
ColumnNText = null,
ColumnNVarChar = null,
ColumnText = null,
ColumnVarChar = null
};
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = connection.Insert(entity);
// Act Query
var data = connection.Query <StringsClass>(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnChar);
Assert.IsNull(data.ColumnNChar);
Assert.IsNull(data.ColumnNText);
Assert.IsNull(data.ColumnNVarChar);
Assert.IsNull(data.ColumnText);
Assert.IsNull(data.ColumnVarChar);
}
}
public void TestDbRepositoryStringsNullCrudAsync()
{
// Setup
var entity = new StringsClass
{
SessionId = Guid.NewGuid(),
ColumnChar = null,
ColumnNChar = null,
ColumnNText = null,
ColumnNVarChar = null,
ColumnText = null,
ColumnVarChar = null
};
using (var repository = new DbRepository <SqlConnection>(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = repository.QueryAsync <StringsClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnChar);
Assert.IsNull(data.ColumnNChar);
Assert.IsNull(data.ColumnNText);
Assert.IsNull(data.ColumnNVarChar);
Assert.IsNull(data.ColumnText);
Assert.IsNull(data.ColumnVarChar);
}
}
public void TestBaseRepositoryStringsCrudAsync()
{
// Setup
var text = Helper.GetUnicodeString();
var entity = new StringsClass
{
SessionId = Guid.NewGuid(),
ColumnChar = text,
ColumnNChar = text,
ColumnNText = text,
ColumnNVarChar = text,
ColumnText = text,
ColumnVarChar = text
};
using (var repository = new StringsClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = repository.QueryAsync(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnChar, data.ColumnChar.Trim());
Assert.AreEqual(entity.ColumnNChar, data.ColumnNChar.Trim());
Assert.AreEqual(entity.ColumnNText, data.ColumnNText);
Assert.AreEqual(entity.ColumnNVarChar, data.ColumnNVarChar);
Assert.AreEqual(entity.ColumnText, data.ColumnText);
Assert.AreEqual(entity.ColumnVarChar, data.ColumnVarChar);
}
}
/// <summary>
/// 给图层设置唯一值渲染
/// </summary>
/// <param name="layer"></param>
/// <param name="renderFieldName"></param>
public MapObjects2.ValueMapRenderer GetUniqueValueRender(MapObjects2.MapLayer layer, string renderFieldName)
{
MapObjects2.ValueMapRenderer oValueMapRender = new MapObjects2.ValueMapRendererClass();
MapObjects2.Recordset oRecords = layer.Records;
MapObjects2.Strings oStrings = new StringsClass();
if (layer.shapeType == ShapeTypeConstants.moShapeTypePoint)
{
oValueMapRender.SymbolType = SymbolTypeConstants.moPointSymbol;
}
else if (layer.shapeType == ShapeTypeConstants.moShapeTypeLine)
{
oValueMapRender.SymbolType = SymbolTypeConstants.moLineSymbol;
}
else if (layer.shapeType == ShapeTypeConstants.moShapeTypePolygon)
{
oValueMapRender.SymbolType = SymbolTypeConstants.moFillSymbol;
}
oValueMapRender.Field = renderFieldName;
oStrings.Unique = true;
oRecords.MoveFirst();
while (!oRecords.EOF)
{
oStrings.Add(oRecords.Fields.Item(renderFieldName).ValueAsString);
oRecords.MoveNext();
}
oValueMapRender.ValueCount = oStrings.Count;
for (short i = 0; i < oStrings.Count; i++)
{
oValueMapRender.set_Value(i, oStrings.Item(i));
}
return(oValueMapRender);
}
/// <summary>
/// ��ͼ������Ψһֵ��Ⱦ
/// </summary>
/// <param name="layer"></param>
/// <param name="renderFieldName"></param>
public MapObjects2.ValueMapRenderer GetUniqueValueRender(MapObjects2.MapLayer layer, string renderFieldName)
{
MapObjects2.ValueMapRenderer oValueMapRender = new MapObjects2.ValueMapRendererClass();
MapObjects2.Recordset oRecords = layer.Records;
MapObjects2.Strings oStrings = new StringsClass();
if (layer.shapeType == ShapeTypeConstants.moShapeTypePoint)
oValueMapRender.SymbolType = SymbolTypeConstants.moPointSymbol;
else if (layer.shapeType == ShapeTypeConstants.moShapeTypeLine)
oValueMapRender.SymbolType = SymbolTypeConstants.moLineSymbol;
else if (layer.shapeType == ShapeTypeConstants.moShapeTypePolygon)
oValueMapRender.SymbolType = SymbolTypeConstants.moFillSymbol;
oValueMapRender.Field = renderFieldName;
oStrings.Unique = true;
oRecords.MoveFirst();
while (!oRecords.EOF)
{
oStrings.Add(oRecords.Fields.Item(renderFieldName).ValueAsString);
oRecords.MoveNext();
}
oValueMapRender.ValueCount = oStrings.Count;
for (short i = 0; i < oStrings.Count; i++) oValueMapRender.set_Value(i, oStrings.Item(i));
return oValueMapRender;
}
public void AnyMethod()
{
string Example = "HELLO EARTH";
string AnotherExample = StringsClass.getInstance().LowercaseCopy(Example);
} // void AnyMethod(...)
