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);
        }