数据过滤

lu

2025-08-25 42b161dc715b3bcc91311be408c8a408f4e450b1

 DevApp/Gs.DevApp/DevFrm/Work/Frm_Repair.cs

@@ -49,9 +49,11 @@
            };
            btnBad.Click += (s, e) =>
            {

                getModel(lbGuid.Text.Trim(), txt_badDescription.TextTxt, txt_repairReson.TextTxt.Trim(), txt_repairMethd.TextTxt.Trim(), badTag);
            };

            this.ActiveControl = this.txt_barCode111;
            txt_barCode111.Focus();
        }
        /// <summary>
        /// 
@@ -130,7 +132,13 @@
        private void getPageList(int curPage)
        {
            txt_barCode111.Text = "";
            gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
            gcMain1.DataSource = null;

            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            _sbSqlWhere.Append(" and d.erp_sczz in");
            _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
            _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
            
            PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "a.createDate", "desc", "", _sbSqlWhere.ToString());
            string json = JsonConvert.SerializeObject(pgq);
            try