public static ScalarBuiler CreateBuilder()
{
var builder = new ScalarBuiler();
builder.SqlParameters = new List <SqlParameter>();
return(builder);
}
public static ScalarBuiler CreateScalarWhere(string where, object[] paras)
{
string[] parts = where.Split('?');
StringBuilder sb = new StringBuilder();
ScalarBuiler builder = ScalarBuiler.CreateBuilder();
for (int i = 0; i < parts.Length; i++)
{
sb.Append(parts[i]);
if (i < parts.Length - 1)
{
object p = null;
if (i > paras.Length - 1)
{
p = paras[paras.Length - 1];
}
else
{
p = paras[i];
}
sb.Append(builder.AddParameter(p));
}
}
builder.Where = sb.ToString();
return(builder);
}