private void ParseResult(string[] right)
{
for (int i = 0; i < right.Length; i++)
{
var str = right[i];
if (str.Length == One.Length && str.All(b => One.Contains(b)))
{
ResultArray[i] = 1;
}
if (str.Length == Four.Length && str.All(b => Four.Contains(b)))
{
ResultArray[i] = 4;
}
if (str.Length == Seven.Length && str.All(b => Seven.Contains(b)))
{
ResultArray[i] = 7;
}
if (str.Length == Eight.Length && str.All(b => Eight.Contains(b)))
{
ResultArray[i] = 8;
}
//Part 2
//6 parts - 0,6,9
if (str.Length == Zero.Length && str.All(b => Zero.Contains(b)))
{
ResultArray[i] = 0;
}
if (str.Length == Six.Length && str.All(b => Six.Contains(b)))
{
ResultArray[i] = 6;
}
if (str.Length == Nine.Length && str.All(b => Nine.Contains(b)))
{
ResultArray[i] = 9;
}
//5 parts - 2,3,5
if (str.Length == Two.Length && str.All(b => Two.Contains(b)))
{
ResultArray[i] = 2;
}
if (str.Length == Three.Length && str.All(b => Three.Contains(b)))
{
ResultArray[i] = 3;
}
if (str.Length == Five.Length && str.All(b => Five.Contains(b)))
{
ResultArray[i] = 5;
}
}
if (ResultArray.Any(a => a < 0))
{
throw new Exception();
}
//Part 2
ResultNumber = Convert.ToInt32(ResultArray[0].ToString() + ResultArray[1].ToString() + ResultArray[2].ToString() + ResultArray[3].ToString());
}
private void Parse(string[] left)
{
One = left.Where(a => a.Count() == 2).FirstOrDefault();
Four = left.Where(a => a.Count() == 4).FirstOrDefault();
Seven = left.Where(a => a.Count() == 3).FirstOrDefault();
Eight = "abcdefg";
//6 parts - 0,6,9
Six = left.Where(a => a.Count() == 6).Single(a => One.All(b => a.Contains(b)) == false);
char rightUp = Eight.First(a => Six.Contains(a) == false);
string leftUpAndMiddle = string.Concat(Four.Where(a => One.Contains(a) == false));
Nine = left.Where(a => a.Count() == 6).First(a => (a.All(b => Six.Contains(b)) == false) && leftUpAndMiddle.All(b => a.Contains(b)));
Zero = left.Where(a => a.Count() == 6).First(a => (a.All(b => Nine.Contains(b)) == false) && (a.All(b => Six.Contains(b)) == false));
//5 parts - 2,3,5
Three = left.Where(a => a.Count() == 5).Single(a => One.All(b => a.Contains(b)));
Two = left.Where(a => a.Count() == 5).Single(a => a.Contains(rightUp) && (a.All(b => Three.Contains(b)) == false));
Five = left.Where(a => a.Count() == 5).First(a => (a.All(b => Two.Contains(b)) == false) && (a.All(b => Three.Contains(b)) == false));
}
public void Sql2008_IN_ToSQL()
{
string[] palyers = new string[]
{
"A"
};
int[] ages = new int[]
{
1, 2, 3
};
Six[] sixs = new Six[]
{
Six.Man,
Six.Woman
};
IDbTranslator dbTranslator = new Sql2008Translator();
IExpressionParser expressionParser = new ExpressionParser(EntityMapperFactory.Instance.GetEntityMapper(typeof(User)));
DataParameterCollection dpc = new DataParameterCollection();
Expression <Func <User, bool> > predicate = entity => palyers.Contains(entity.Name) || ages.Contains(entity.Age) || sixs.Contains(entity.Six);
string sql = expressionParser.ToSQL(predicate.Body, dbTranslator, dpc);
Assert.Equal(1, 1);
}
