protected virtual string GetDeleteSql(SqlQuery query) { StringBuilder buf = new StringBuilder("delete from "); if (schema != null && schema.Length > 0) { buf.Append("[").Append(schema).Append("]."); } buf.Append("[").Append(name).Append("]"); if (query != null) { buf.Append(" ").Append(query.GetSql(this)); } buf.Append(";"); return(buf.ToString()); }
public virtual string GetSql(SqlTable table, ref int offset) { if (HasQuery) { string sql = query.GetSql(table, ref offset); return(string.Format("({0})", sql)); } else { index = offset; offset = offset + 1; string name = table.Translate(column); if (name == null || name.Length == 0) { //name = column; throw new LightException(string.Format("column {0} not found in table {1}", column, table.Name)); } return(string.Format("[{0}]{1}@{2}", name, oper, index)); } }
protected virtual string GetSelectSql(SqlQuery query) { if (selectSQL == null) { StringBuilder buf = new StringBuilder("select "); bool comma = false; foreach (SqlColumn column in columns) { if (comma) { buf.Append(","); } else { comma = true; } buf.Append("[").Append(column.Name).Append("]"); } buf.Append(" from "); if (schema != null && schema.Length > 0) { buf.Append("[").Append(schema).Append("]."); } buf.Append("[").Append(name).Append("]"); selectSQL = buf.ToString(); } if (query != null) { StringBuilder buf = new StringBuilder(selectSQL); buf.Append(" ").Append(query.GetSql(this)); buf.Append(";"); return(buf.ToString()); } else { return(string.Format("{0};", selectSQL)); } }
protected virtual string GetSelectSql(SqlQuery query) { if (selectSQL == null) { StringBuilder buf = new StringBuilder("select "); bool comma = false; foreach (SqlColumn column in columns) { if (comma) buf.Append(","); else comma = true; buf.Append("[").Append(column.Name).Append("]"); } buf.Append(" from "); if (schema != null && schema.Length > 0) buf.Append("[").Append(schema).Append("]."); buf.Append("[").Append(name).Append("]"); selectSQL = buf.ToString(); } if (query != null) { StringBuilder buf = new StringBuilder(selectSQL); buf.Append(" ").Append(query.GetSql(this)); buf.Append(";"); return buf.ToString(); } else return string.Format("{0};", selectSQL); }
protected virtual string GetDeleteSql(SqlQuery query) { StringBuilder buf = new StringBuilder("delete from "); if (schema != null && schema.Length > 0) buf.Append("[").Append(schema).Append("]."); buf.Append("[").Append(name).Append("]"); if (query != null) buf.Append(" ").Append(query.GetSql(this)); buf.Append(";"); return buf.ToString(); }