巧拼SQL语句

        static Hashtable FMap = null;
        static DACStorageProductsQuery()
        {
            FMap = new Hashtable();
            FMap.Add("products_name", "''|=|products_name|'{0}'");
            FMap.Add("storage_name", "''|=|storage_name|'{0}'");
            FMap.Add("manufacturers_company", "''|=|manufacturers_company|'{0}'");
            FMap.Add("ProductsWarning", "''|=|ProductsWarning|'{0}'");
            FMap.Add("productiondatebegin", "''|<=|productiondate|'{0}'");
            FMap.Add("productiondateend", "''|=>|productiondate|'{0}'");
            FMap.Add("products_price_summin", "0|<=|products_price_sum|{0}");
            FMap.Add("products_price_summax", "0|=>|products_price_sum|{0}");
            FMap.Add("mafuproductiondatebegin", "''|<=|mafuproductiondate|'{0}'");
            FMap.Add("mafuproductiondateend", "''|=>|mafuproductiondate|'{0}'");
            FMap.Add("products_amount_summin", "0|<=|products_amount_sum|{0}");
            FMap.Add("products_amount_summax", "0|=>|products_amount_sum|{0}");
        }
        const string CondinOuterText = @" AND ( #Null$ = #FiledName# OR #Value$ #Option#  #FiledName# ) ";