基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：78630559

本次赞助数额为： 5 元　

支付宝支付

微信支付

   源码介绍

---

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

      
    }
}