SQL拼接(自动生成SQL的where条件)

【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace SQL拼接
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            SQLStitching.ConditionHelper helper = new SQLStitching.ConditionHelper(false);
            helper.AddCondition("UserName", SQLStitching.Comparison.In, "张三", "李四", "王五");
            helper.AddAndCondition("Age", SQLStitching.Comparison.Between, 1, 17);
            helper.AddAndOpenParenthese("Gender", SQLStitching.Comparison.Equal, "Male");
            helper.AddOrCondition("Gender", SQLStitching.Comparison.Equal, "Female");
            helper.AddOrCondition("Time", SQLStitching.Comparison.Between, DateTime.Now.AddDays(-1), DateTime.Now.AddDays(1));
            helper.AddCloseParenthese();
            string condition = helper.ToString();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SQLStitching1.ConditionHelper condition = new SQLStitching1.ConditionHelper(false,"",false);
            condition.AppendCondition("UserName", SQLStitching1.Comparison.Equal, "Male");
            condition.AppendCondition("UserName", SQLStitching1.Comparison.In, "张三", "李四", "王五");
            condition.AppendCondition("Age", SQLStitching1.Comparison.Between, 1, 17);
            condition.AppendCondition("Gender", SQLStitching1.Comparison.Equal, "Male");
            condition.AppendCondition("Gender", SQLStitching1.Comparison.Equal, "Female");
            condition.AppendCondition("Time", SQLStitching1.Comparison.Between, DateTime.Now.AddDays(-1), DateTime.Now.AddDays(1));
           //condition.AppendParenthese(SQLStitching1.RelationType.AND, condition);
            condition.ToString();
            MessageBox.Show(condition.ToString());
        }

      
    }
}