public static string ParseToString(object o, Dialect.DbDialect dd) { if (o == null) { return("NULL"); } var ot = o.GetType(); if (typeof(bool) == ot) { return(Convert.ToInt32(o).ToString()); } if (typeof(string) == ot) { string s = o.ToString(); s = s.Replace("'", "''"); return(string.Format("N'{0}'", s)); } if (typeof(DateTime) == ot || typeof(Date) == ot || typeof(Time) == ot) { return(dd.QuoteDateTimeValue(o.ToString())); } if (ot.IsEnum) { return(Convert.ToInt32(o).ToString()); } if (typeof(byte[]) == ot) { throw new ApplicationException("Sql without Parameter can not support blob, please using Parameter mode."); } return(o.ToString()); }
public string ToSqlText(DataParameterCollection dpc, Dialect.DbDialect dd) { return(string.Format("{0}.{1} {4} {2}.{3}", dd.QuoteForTableName(Table1), dd.QuoteForColumnName(Key1), dd.QuoteForTableName(Table2), dd.QuoteForColumnName(Key2), StringHelper.EnumToString(Comp))); }
//internal FromClause(params string[] linkColumnNames) //{ // if (linkColumnNames.Length < 2 || linkColumnNames.Length % 2 != 0) // { // throw new ArgumentException("LinkColumnNames.Length not even or less than 2."); // } // joinClauseList = new JoinClause[linkColumnNames.Length / 2]; // for (int i = 0; i < linkColumnNames.Length; i+=2) // { // joinClauseList[i / 2] = new JoinClause(linkColumnNames[i], linkColumnNames[i + 1], // CompareOpration.Equal, JoinMode.Inner); // } //} public string ToSqlText(DataParameterCollection dpc, Dialect.DbDialect dd, bool isView) { if (!MainViewName.IsNullOrEmpty() && isView) { return(dd.QuoteForTableName(MainViewName)); } if (MainTableName != null) { return(dd.QuoteForTableName(MainTableName)); } if (_fromStrings.Contains(dd)) { return((string)_fromStrings[dd]); } string ret; if (PartOf != null) { ret = dd.QuoteForLimitTableName(ModelContext.GetInstance(PartOf).Info.From.MainTableName); } else { var sd = new StringDictionary(); ret = dd.QuoteForTableName(JoinClauseList[0].Table1); sd.Add(ret, ""); for (int i = 0; i < JoinClauseList.Length; i++) { if (i != 0 && dd.NeedBracketForJoin) { ret = string.Format("({0})", ret); } string tn = dd.QuoteForTableName(JoinClauseList[i].Table2); if (sd.ContainsKey(tn)) { tn = dd.QuoteForTableName(JoinClauseList[i].Table1); } sd.Add(tn, ""); ret = string.Format("{0} {3} JOIN {1} ON {2}", ret, tn, JoinClauseList[i].ToSqlText(dpc, dd, isView), JoinClauseList[i].Mode); } } lock (_fromStrings.SyncRoot) { _fromStrings[dd] = ret; } return(ret); }
public string ToSqlText(DataParameterCollection dpc, Dialect.DbDialect dd) { if (OrderItems != null && OrderItems.Count > 0) { var sb = new StringBuilder(" ORDER BY "); foreach (ASC oi in OrderItems) { sb.Append(oi.ToString(dd)); sb.Append(","); } if (sb.Length > 10) { sb.Length--; } return(sb.ToString()); } return(""); }
public override string ToSqlText(SqlEntry.DataParameterCollection dpc, Dialect.DbDialect dd, List <string> queryRequiredFields) { return(null); }
public OleDbDriver(Dialect.DbDialect dialectClass, string name, string connectionString, string dbProviderFactoryName, AutoScheme autoScheme) : base(dialectClass, name, connectionString, dbProviderFactoryName, autoScheme) { }
public override string ToString(Dialect.DbDialect dd) { return(dd.QuoteForColumnName(Key) + " DESC"); }
public virtual string ToString(Dialect.DbDialect dd) { return(dd.QuoteForColumnName(Key) + " ASC"); }