進階查詢,讓查詢條件精確到底...

    /// <summary>
        /// 進階查詢
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnAdvancedQuery_Click(object sender, EventArgs e)
        {

           //FindEmployee 為進階窗口.
            FindEmployee findOrder = new FindEmployee();
            DialogResult result = findOrder.ShowDialog(this);
            if (result == DialogResult.OK)
            {
                IDataQueryService appQuery = this.GetService<IDataQueryService>();
                if (appQuery != null)
                {
                    BaseDataBlock datablock = this.baseDataBlock1;
                    this.DataBlockSet.EndEdit();
                    datablock.QueryAllRecords = true;

 

                    appQuery.Reset(datablock);
                    RecordParameterCollection parameters = new RecordParameterCollection();
                    string where = findOrder.BuildWhereClause(parameters);
                    //datablock.Parameters.Clear();
                    foreach (RecordParameter parameter in parameters)
                    {
                        datablock.Parameters.Add(parameter);
                    }
                    appQuery.AppendClause(datablock, where);
                    this.DataBlockSet.RefreshData(datablock);
                }
            }
        }