C/S框架V2.0版集成高级查询功能

using System;
using System.Collections.Generic;
using System.Text;

namespace CSFramework_ADO2.Interfaces
{
   /// <summary>
   /// 支持高级搜索功能
   /// </summary>
   public interface ISupportAdvancedSearch
   {
      /// <summary>
      /// 高级搜索的方法
      /// </summary>
      /// <param name="whereSQL">高级搜索组合的查询条件</param>
      /// <returns>返回查询的对象</returns>
      object AdvancedSearch(string whereSQL);
   }
}


// 来源:www.CSFramework.com, C/S结构框架学习网

public class bllInventoryCheck : bllBase, ILogSupportable, ISupportAdvancedSearch
{

   ... Your Other code...
      
   #region ISupportAdvancedSearch 成员
   
   /// <summary>
   /// 实现高级查询接口
   /// </summary>
   /// <param name="whereSQL">查询条件组合</param>
   /// <returns></returns>
   public object AdvancedSearch(string whereSQL)
   {
      return dalProductCheck.Instance.AdvancedSearch(whereSQL);
   }
   
   #endregion
}


// 来源:www.CSFramework.com, C/S结构框架学习网

//高级查询
public object AdvancedSearch(string whereSQL)
{
   string query = "select * from tb_MyProductTake where 1=1 ";
   
   if (false == String.IsNullOrEmpty(whereSQL))
   query = query " AND " whereSQL;
   else
   query = query " AND 1=0 ";
   
   SqlCommandBase cmd = new SqlBuilder().BuildSqlCommandBase(query);
   DataTable dt = DataProvider.Instance.GetTable(cmd.SqlCommand, TProductTake.TableName);
   return dt;
}

// 来源:www.CSFramework.com, C/S结构框架学习网

private void btnAdvSearch_Click(object sender, EventArgs e)
{
   //打开高级搜索功能
   frmAdvancedSearch.Execute(gvSummary, _DataProxy);
}

// 来源:www.CSFramework.com, C/S结构框架学习网

_CurrentBusiness = _DataProxy.GetBusinessByKey("");// 获取一个空的业务表
DoBindingSummaryGrid(_CurrentBusiness.Tables[0]); //绑定主表的Grid