BuildQuery A Simple SQL Query Tool

 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace BuildQuery
{
/// <summary>
/// ʹÓÃÌṩµÄÊý¾Ý½¨Á¢Ò»¸öSQL²éѯ
/// </summary>
public class BuildQuery
{
#region ÀàµÄ±äÁ¿
int numFieldsCount, dispos; //×Ö¶ÎÊýÁ¿£¬¼Ç¼¶ººÅµÄÊýÁ¿
//
//½«ËùÓеÄ×ֶκÍÖµ·ÅÈëµ½Dictionary¼¯ºÏÀÌá¸ß²Ù×÷ЧÂÊ
//
Dictionary<string, string> dicFields = new Dictionary<string, string>(); //×ֶμ¯ºÏ
Dictionary<string, string> dicData = new Dictionary<string, string>(); //ÖµµÄ¼¯ºÏ
Dictionary<string, bool> dicQuotes = new Dictionary<string, bool>(); //ÊÇ·ñÐèÒªÒýºÅµÄ¼¯ºÏ
//
//Ìõ¼þ×ֶμ°ÖµµÄ¼¯ºÏ
//
List<string> listIDFields = new List<string>(); //×ֶμ¯ºÏ
List<string> listIDValues = new List<string>(); //ÖµµÄ¼¯ºÏ
List<bool> listIDQuotes = new List<bool>(); //ÒýºÅ¼¯ºÏ
List<string> listIDOperators = new List<string>();//²Ù×÷·û¼¯ºÏ

string strTable; //±íÃû
Boolean IdentityCheck; //ÊÇ·ñÐèÒª·µ»ØÒ»¸öеÄʵÌåÀà
/// <summary>
/// ·â×°Ò»¸öÊÇ·ñÐèҪеÄʵÌåÀà
/// </summary>
public Boolean GetIdentity
{
get { return IdentityCheck; }
set { IdentityCheck = value; }
}

/// <summary>
/// ·â×°·µ»ØÒ»¸ö²éѯµÄ½á¹û
/// </summary>
public string Table
{
get { return strTable; }
set { strTable = value; }
}
#endregion
/// <summary>
/// ÀàµÄʵÀý»¯¹¹Ôì·½·¨
/// </summary>
public BuildQuery()
{
}
/// <summary>
/// ½¨Á¢Ò»¸ö²éѯǰÇå³ýDICTIONARY¼¯ºÏµÄËùÓÐÄÚÈÝ
/// </summary>
publ