public static string ToString(SqlCommand cmd)
{
StringBuilder s = new StringBuilder();
s.AppendLine(cmd.CommandText);
foreach (SqlParameter p in cmd.Parameters)
{
s.AppendLine(UStr.Bracket(p.ParameterName) + " = " + UStr.Bracket(p.Value));
}
return(s.ToString());
}
public static string ToString(DataRow row)
{
if (row == null)
{
return("");
}
StringBuilder s = new StringBuilder();
s.AppendLine("Table Name = " + UStr.Bracket(row.Table.TableName));
foreach (DataColumn col in row.Table.Columns)
{
s.AppendLine(UStr.Bracket(col.ColumnName) + " = " + UStr.Bracket(row[col.ColumnName]));
}
return(s.ToString());
}
public static string FilterExact(string columnName, object value)
{
return(UStr.Bracket(columnName) + "='" + value + "'");
}
public static string FilterInt32(string columnName, object value)
{
return(UStr.Bracket(columnName) + "=" + value);
}
public static string FilterParam(string columnName, object value)
{
return("LOWER(" + UStr.Bracket(columnName) + ") LIKE LOWER(" + value + ")");
}
