From b401548e93334943320e2a4a6b11341cf8a5fecf Mon Sep 17 00:00:00 2001 From: lu <123456> Date: 星期日, 24 八月 2025 12:57:01 +0800 Subject: [PATCH] 数据过滤 --- DevApp/Gs.DevApp/DevFrm/WW/Frm_WwGd.cs | 11 ++++++++++- 1 files changed, 10 insertions(+), 1 deletions(-) diff --git a/DevApp/Gs.DevApp/DevFrm/WW/Frm_WwGd.cs b/DevApp/Gs.DevApp/DevFrm/WW/Frm_WwGd.cs index 51c9ee5..99b677b 100644 --- a/DevApp/Gs.DevApp/DevFrm/WW/Frm_WwGd.cs +++ b/DevApp/Gs.DevApp/DevFrm/WW/Frm_WwGd.cs @@ -1,3 +1,4 @@ +using DevExpress.Utils; using Gs.DevApp.DevFrm.WW; using Gs.DevApp.Entity; using Gs.DevApp.ToolBox; @@ -7,6 +8,7 @@ using System; using System.Collections.Generic; using System.Data; +using System.Drawing; using System.Threading.Tasks; using System.Windows.Forms; @@ -28,6 +30,9 @@ this.toolBarMenu1.btnWgClick += ToolBarMenu1_btnWgClick; toolBarMenu1.btnLogClick += ToolBarMenu1_btnLogClick; this.toolBarMenu1.getXmlConfig(); + gvMx1.Columns["barbl"].DisplayFormat.FormatType = FormatType.Numeric; + gvMx1.Columns["barbl"].DisplayFormat.FormatString = "p0"; + Gs.DevApp.ToolBox.UtilityHelper.CustomProgressBarColumn(gvMx1, "barbl", 90, Brushes.OrangeRed, Brushes.DodgerBlue); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, null, this, "pcShChk", "", (value) => { @@ -168,7 +173,11 @@ /// <param name="pageSize">姣忛〉鍑犳潯</param> private void getPageList(int curPage) { - gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); + gcMain1.DataSource = null; + System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder(); + _sbSqlWhere.Append(" and hzOrg.FID in"); + _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere()); + _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList)); PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "create_date", "desc", "", _sbSqlWhere.ToString()); string json = JsonConvert.SerializeObject(pgq); try -- Gitblit v1.9.3