/// <summary>
/// 添加sql语句的Value部分
/// </summary>
/// <param name="url"></param>
private void AppendValuesString(string url, string name)
{
if (!String.IsNullOrEmpty(SqlValues.ToString()))
{
SqlValues.Append(" union ");
}
SqlValues.Append(" select NEWID(),'" + url + "', '" + name + "', '', ''," + MaxIndex + "," + DropDownListAuthentication.SelectedValue + ", " + DropDownListShow.SelectedValue);
MaxIndex++;
}
public void Count_ReturnsNumberOfItems()
{
var values = new SqlValues();
Assert.Equal(0, values.Count);
values.Add(Enumerable.Range(0, 5).Cast<SqlValue>());
Assert.Equal(1, values.Count);
values.Add(Enumerable.Range(5, 10).Cast<SqlValue>());
Assert.Equal(2, values.Count);
}
public void Count_ReturnsNumberOfItems()
{
var values = new SqlValues();
Assert.Equal(0, values.Count);
values.Add(Enumerable.Range(0, 5).Cast <SqlValue>());
Assert.Equal(1, values.Count);
values.Add(Enumerable.Range(5, 10).Cast <SqlValue>());
Assert.Equal(2, values.Count);
}
public void GetEnumerator_ReturnsEnumerator()
{
var values = new SqlValues
{
Enumerable.Range(0, 5).Cast<SqlValue>(),
Enumerable.Range(5, 10).Cast<SqlValue>()
};
var enumerator = ((IEnumerable) values).GetEnumerator();
Assert.NotNull(enumerator);
int count = 0;
while (enumerator.MoveNext())
{
count++;
}
Assert.Equal(2, count);
}
public void GetEnumerator_ReturnsEnumerator()
{
var values = new SqlValues
{
Enumerable.Range(0, 5).Cast <SqlValue>(),
Enumerable.Range(5, 10).Cast <SqlValue>()
};
var enumerator = ((IEnumerable)values).GetEnumerator();
Assert.NotNull(enumerator);
int count = 0;
while (enumerator.MoveNext())
{
count++;
}
Assert.Equal(2, count);
}
/// <summary>
/// Visits the specified <see cref="SqlValues"/>.
/// </summary>
/// <param name="expression">
/// The expression to visit.
/// </param>
public virtual void Visit(SqlValues expression)
{
}
public void Add_WithNullValues_ThrowsArgumentNull()
{
var values = new SqlValues();
Assert.Throws<ArgumentNullException>(() => values.Add(null));
}
/// <summary>
/// Visits the specified <see cref="SqlValues"/>.
/// </summary>
/// <param name="expression">
/// The expression to visit.
/// </param>
public virtual void Visit(SqlValues expression)
{
}
public void Add_WithNullValues_ThrowsArgumentNull()
{
var values = new SqlValues();
Assert.Throws <ArgumentNullException>(() => values.Add(null));
}
