public static string Delete(Type Type, List <int> ids, string Schema) { StringBuilder Query = new StringBuilder(); Query.Append(" Delete from "); Query.Append(" " + Schema + "." + Type.Name); Query.Append(" Where "); string idSQLIn = ""; foreach (var i in idSQLIn) { if (idSQLIn == "") { idSQLIn = i.ToString(); } else { idSQLIn = idSQLIn + ", " + i; } } PropertyInfo[] properties = Type.GetProperties(); foreach (PropertyInfo property in properties) { if (FactoryScript.ContainAttribute(property, typeof(KeyAttribute))) { Query.Append(" ( " + property.Name + " in (" + idSQLIn + "))"); break; } } return(Query.ToString()); }
private static string InsertParameters(Type Type) { StringBuilder Query = new StringBuilder(); PropertyInfo[] properties = Type.GetProperties(); int count = 0; Query.Append(" Values("); foreach (PropertyInfo property in properties) { if ((FactoryScript.ContainAttribute(property, typeof(ColumnAttribute))) && //(!FactoryScript.ContainAttribute(property, typeof(KeyAttribute))) && (!FactoryScript.ContainAttribute(property, typeof(DatabaseGeneratedAttribute))) ) { if (count == 0) { Query.Append("@" + property.Name); } else { Query.Append(", @" + property.Name); } count++; } } Query.Append(") "); return(Query.ToString()); }
public static string ReturnId(Type Type) { PropertyInfo[] properties = Type.GetProperties(); foreach (PropertyInfo property in properties) { if (FactoryScript.ContainAttribute(property, typeof(KeyAttribute))) { return(" RETURNING " + property.Name); } } return(string.Empty); }
public static string Update(Type Type, string Schema) { StringBuilder Query = new StringBuilder(); Query.Append("Update "); Query.Append(" " + Schema + "." + Type.Name); Query.Append(" set "); PropertyInfo[] properties = Type.GetProperties(); String NameKey = ""; #region int Count = 0; foreach (PropertyInfo property in properties) { if (FactoryScript.ContainAttribute(property, typeof(KeyAttribute))) { NameKey = property.Name; } else if (FactoryScript.ContainAttribute(property, typeof(ColumnAttribute))) { if (Count == 0) { Query.Append(property.Name + " = @" + property.Name); } else { Query.Append(", " + property.Name + " = @" + property.Name); } Count++; } } #endregion #region condition Query.Append(" Where"); Query.Append(" (@" + NameKey + " = " + NameKey + ")"); #endregion return(Query.ToString()); }
public static string Delete(Type Type, string Schema) { StringBuilder Query = new StringBuilder(); Query.Append(" Delete from "); Query.Append(" " + Schema + "." + Type.Name); Query.Append(" Where "); PropertyInfo[] properties = Type.GetProperties(); foreach (PropertyInfo property in properties) { if (FactoryScript.ContainAttribute(property, typeof(KeyAttribute))) { Query.Append(" ( " + property.Name + " = @" + property.Name + ")"); break; } } return(Query.ToString()); }
public static string Select(Type Type, int Key, string Schema) { StringBuilder Query = new StringBuilder(); Query.Append("Select "); Query.Append(" * "); Query.Append("From "); Query.Append(" " + Schema + "." + Type.Name); PropertyInfo[] properties = Type.GetProperties(); foreach (var property in properties) { if (FactoryScript.ContainAttribute(property, typeof(KeyAttribute))) { Query.Append(" Where (" + property.Name + " = " + Key + ")"); break; } } return(Query.ToString()); }
private static bool IndetifierAutoIncrement(PropertyInfo property) { return((FactoryScript.ContainAttribute(property, typeof(ColumnAttribute))) && (FactoryScript.ContainAttribute(property, typeof(KeyAttribute))) && (FactoryScript.ContainAttribute(property, typeof(DatabaseGeneratedAttribute)))); }