public override string ToString()
{
var queryText = QueryText;
if (DataSegment != null)
{
queryText = Syntax.Segment(queryText, DataSegment);
}
var sb = new StringBuilder(queryText);
if (Parameters.Count > 0)
{
sb.AppendLine();
foreach (var par in Parameters)
{
//字符或日期型，加'
if (par.Value is string || par.Value is DateTime || par.Value is char)
{
sb.Append($"\n{par.ParameterName}='{par.Value}'");
}
//字节数组，转换为字符串
else if (par.Value is byte[])
{
sb.AppendFormat($"\n{par.ParameterName}='{Encoding.ASCII.GetString(par.Value as byte[])}'");
}
else
{
sb.AppendFormat($"\n{par.ParameterName}={par.Value}");
}
}
}
return(sb.ToString());
}
