public override string GetSql(SqlTable table, ref int offset)
{
string name = table.Translate(Column);
if (name == null || name.Length == 0)
throw new LightException(string.Format("column {0} not found in table {1}",
Column, table.Name));
index = offset;
IList values = (IList) Value;
StringBuilder buf = new StringBuilder();
buf.Append("[").Append(name).Append("] ").Append(Operator).Append(" (");
if (values.Count > 0)
{
offset = offset + values.Count;
for (int i = index; i < offset; i++)
{
if (i > index)
buf.Append(",");
string pname = string.Format("@{0}", i);
buf.Append(pname);
}
}
else
{
buf.Append("null");
}
buf.Append(")");
return buf.ToString();
}
public override string GetSql(SqlTable table, ref int offset)
{
string name = table.Translate(Column);
if (name == null || name.Length == 0)
{
throw new LightException(string.Format("column {0} not found in table {1}",
Column, table.Name));
}
index = offset;
IList values = (IList)Value;
StringBuilder buf = new StringBuilder();
buf.Append("[").Append(name).Append("] ").Append(Operator).Append(" (");
if (values.Count > 0)
{
offset = offset + values.Count;
for (int i = index; i < offset; i++)
{
if (i > index)
{
buf.Append(",");
}
string pname = string.Format("@{0}", i);
buf.Append(pname);
}
}
else
{
buf.Append("null");
}
buf.Append(")");
return(buf.ToString());
}
public override string GetSql(SqlTable table, ref int offset)
{
string name = table.Translate(this.Column);
if (name == null || name.Length == 0)
throw new LightException(string.Format("column {0} not found in table {1}",
this.Column, table.Name));
return string.Format("[{0}] {1} null", name, this.Operator);
}
public override string GetSql(SqlTable table, ref int offset)
{
string name = table.Translate(this.Column);
if (name == null || name.Length == 0)
{
throw new LightException(string.Format("column {0} not found in table {1}",
this.Column, table.Name));
}
return(string.Format("[{0}] {1} null", name, this.Operator));
}
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);
}
}
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));
}
}
