数据过滤

lu

2025-08-25 42b161dc715b3bcc91311be408c8a408f4e450b1

 DevApp/Gs.DevApp/DevFrm/QC/Jyxm.cs

@@ -9,6 +9,7 @@
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;

@@ -437,9 +438,14 @@
        /// <param name="pageSize">每页几条</param>
        private void getPageList(int curPage)
        {
            gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
            _sbSqlWhere += " and b.guid is not null";
            _sbSqlWhere += " and a.FTYPE='" + this.strType + "'";
            gcMain1.DataSource = null;

            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            _sbSqlWhere.Append(" and b.guid is not null");
            _sbSqlWhere.Append(" and a.FTYPE='" + this.strType + "'");
            _sbSqlWhere.Append(" and org.fid in");
            _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
            _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
            var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount,
                "org.FNumber asc ,b.item_no asc,a.FVERSION desc", "", "", _sbSqlWhere.ToString());
            var json = JsonConvert.SerializeObject(pgq);