/// <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);
        }
Exemple #3
0
        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);
        }
Exemple #5
0
        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);
        }
Exemple #6
0
 /// <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));
 }
Exemple #8
0
 /// <summary>
 /// Visits the specified <see cref="SqlValues"/>.
 /// </summary>
 /// <param name="expression">
 /// The expression to visit.
 /// </param>
 public virtual void Visit(SqlValues expression)
 {
 }
Exemple #9
0
        public void Add_WithNullValues_ThrowsArgumentNull()
        {
            var values = new SqlValues();

            Assert.Throws <ArgumentNullException>(() => values.Add(null));
        }