多条件查询

 private void Bind(string[] where, string order, params string[] args)
    {
        //StringBuilder sb = new StringBuilder();
        //sb.Append("select * from u_user where 1=1 ");

        //for (int i = 0; i < where.Length; i++)
        //{
        //    sb.AppendFormat("and {0} = '{1}'", where[i], args[i]);
        //}
        //sb.AppendFormat(" order by {0}", order);
    }

 

 

多条件查询，where 列名集合，order 排序列 args 是参数值