Exemple #1
0
        private COASqlJoinData <T> MainJoinGeneator <T1>(Expression SetTables, object obj, COASqlJoinTypes type = COASqlJoinTypes.INNER, COADataBaseTypes databasetype = COADataBaseTypes.Sql)
        {
            var returnData = new COASqlJoinData <T>();

            returnData.DataBaseType = databasetype;
            returnData.TableName    = TableName;
            returnData.SetJoinType(type);
            var Column1Selected = Types.GetAllTypes(SetTables);
            var Selectedlist    = new List <string>();

            if (Column1Selected.Name.Count == 0)
            {
                var Types = GetGenericTypeList(obj);

                for (int i = 1; i < Types.Length; i++)
                {
                    var Props = Types[i].GetProperties();
                    foreach (var prop in Props)
                    {
                        Selectedlist.Add($"{prop.ReflectedType.Name}.{prop.Name}");
                    }
                }
            }
            else
            {
                Selectedlist = Types.JoinBaseGenerator(Column1Selected);
            }

            returnData.SelectedColumns = Selectedlist;
            returnData.SqlQuery        = Types.JoinSqlGenerator <T1>(returnData.SelectedColumns);
            return(returnData);
        }
Exemple #2
0
        public string PredicateToString(Expression predicate, COADataBaseTypes databasetype,bool join = false)
        {

            var Query = GetAllTypes(predicate);
            string str = " WHERE";
            for (int i = 0; i < Query.Name.Count; i++)
            {

                if (Query.Type[i] == typeof(DateTime))
                {
                    var date = Convert.ToDateTime(Query.Value[i]);
                    if (databasetype == COADataBaseTypes.Oracle)
                    {
                        if (date.Hour >= 1)
                            Query.Value[i] = "TO_DATE('" + date.ToString("yyyy-MM-dd HH:mm:ss") + "', 'YYYY/MM/DD HH:MI:SS')";
                        else
                            Query.Value[i] += "TO_DATE('" + date.ToString("yyyy-MM-dd") + "', 'YYYY/MM/DD')";
                    }
                    else
                    {
                        if (date.Second >= 1)
                            Query.Value[i] = "'" + date.ToString("yyyy-MM-dd HH:mm:ss") + "'";
                        else
                            Query.Value[i] += "'" + date.ToString("yyyy-MM-dd") + "'";
                    }
                }
                switch (Query.EqualType[i])
                {
                    case "Equal":
                        str += " " + Query.Name[i] + " = " + Query.Value[i];
                        break;
                    case "NotEqual":
                        str += " " + Query.Name[i] + " != " + Query.Value[i];
                        break;
                    case "GreaterThan":
                        str += " " + Query.Name[i] + " > " + Query.Value[i];
                        break;
                    case "GreaterThanOrEqual":
                        str += " " + Query.Name[i] + " >= " + Query.Value[i];
                        break;
                    case "LessThan":
                        str += " " + Query.Name[i] + " < " + Query.Value[i];
                        break;
                    case "LessThanOrEqual":
                        str += " " + Query.Name[i] + " <= " + Query.Value[i];
                        break;
                    case "Contains":
                        str += " " + Query.Name[i] + " LIKE '%" + TurnChar(Query.Value[i]) + "%'";
                        break;
                    case "StartsWith":
                        str += " " + Query.Name[i] + " LIKE '" + TurnChar(Query.Value[i]) + "%'";
                        break;
                    case "EndsWith":
                        str += " " + Query.Name[i] + " LIKE '% " + TurnChar(Query.Value[i]) + "'";
                        break;
                }
                if (i <= Query.Name.Count - 2)
                {
                    switch (Query.AndOr[i])
                    {
                        case "And":
                            str += " AND";
                            break;
                        case "AndAlso":
                            str += " AND";
                            break;
                        case "Or":
                            str += " OR";
                            break;
                        case "OrElse":
                            str += " OR";
                            break;
                    }
                }
            }

            return str;
        }