From 42b161dc715b3bcc91311be408c8a408f4e450b1 Mon Sep 17 00:00:00 2001 From: lu <123456> Date: 星期一, 25 八月 2025 11:00:00 +0800 Subject: [PATCH] 数据过滤 --- DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaMj.cs | 10 ++++++++-- 1 files changed, 8 insertions(+), 2 deletions(-) diff --git a/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaMj.cs b/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaMj.cs index 92a4c65..c76d2ae 100644 --- a/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaMj.cs +++ b/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaMj.cs @@ -274,8 +274,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"; + gcMain1.DataSource = null; + + System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder(); + _sbSqlWhere.Append(" and b.guid is not null"); + _sbSqlWhere.Append(" and org.fid in"); + _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere()); + _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList)); + PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "org.FNumber asc ,b.ITEM_NO", "asc", "", _sbSqlWhere.ToString()); string json = JsonConvert.SerializeObject(pgq); try -- Gitblit v1.9.3