数据过滤

lu

2025-08-25 42b161dc715b3bcc91311be408c8a408f4e450b1

 DevApp/Gs.DevApp/DevFrm/IPQC/Frm_ShouJianDetect01.cs

@@ -1,4 +1,5 @@
using Gs.DevApp.Entity;
using Gs.DevApp.DevFrm.User;
using Gs.DevApp.Entity;
using Gs.DevApp.ToolBox;
using Gs.DevApp.UserControl;
using Newtonsoft.Json;
@@ -7,6 +8,7 @@
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Net;
using System.Threading.Tasks;
using System.Windows.Forms;
@@ -32,13 +34,13 @@
            {
                Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 0);
            }, tips);
            Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) =>
            {
                getModel(value, "0");
            }, (value) =>
            {
                getPageList(this.pageBar1.CurrentPage);
            }, lbGuid);
            //Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) =>
            //{
            //    getModel(value, "0");
            //}, (value) =>
            //{
            //    getPageList(this.pageBar1.CurrentPage);
            //}, lbGuid);
            getPageList(1);
            pageBar1.PagerEvent += PageBar1_PagerEvent;
            xtraTabControl2.SelectedPageChanged += XtraTabControl2_SelectedPageChanged;
@@ -137,7 +139,7 @@
                lbGuid, txt_releaseNo, gridView1, "releaseNo");
            if (string.IsNullOrEmpty(rowGuid))
            {
                MsgHelper.Warning("请先选择你要操作的行！");
                MsgHelper.ShowError("请先选择你要操作的行！");
                return;
            }
            if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】，确定导出吗？"))
@@ -166,7 +168,8 @@
                            {
                                client.DownloadFile(_url, _folderName);
                            }
                            ToolBox.MsgHelper.ShowInformation("导出成功！");
                            var frm = new Gs.DevApp.DevFrm.QC.Xls(_folderName);
                            frm.ShowDialog();
                        }
                        else
                        {
@@ -209,8 +212,11 @@
        /// <param name="pageSize">每页几条</param>
        private void getPageList(int curPage)
        {
            gcMain1.DataSource = null;var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
            // _sbSqlWhere += " and isnull(fsubmit,0)=0";
            gcMain1.DataSource = null;
            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            _sbSqlWhere.Append(" and daa.erp_sczz in");
            _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
            _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
            PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "release_no", "asc", "", _sbSqlWhere.ToString());
            string json = JsonConvert.SerializeObject(pgq);
            try
@@ -374,5 +380,27 @@
            txtJianYan.ReadOnly = !bl;
            btnIpt.Text = (bl == true ? "录入样本" : "查看样本");
        }

        /// <summary>
        /// 去检验
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void rptButtonUrl_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            if (e.Button.Index == 0)
            {
                var userGuid =
               string.IsNullOrEmpty(LoginInfoModel.CurrentUser.LoginUserGuid)
                   ? Guid.NewGuid().ToString()
                   : LoginInfoModel.CurrentUser.LoginUserGuid;

                var rowhandle = gridView1.FocusedRowHandle;
                var dr = gridView1.GetDataRow(rowhandle);
                var qcGuid = dr["guid"].ToString()+"&mth="+DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")+"&userGuid="+ userGuid;
                Frm_ShouJianDetect01H5 frm = new Frm_ShouJianDetect01H5(qcGuid);
                frm.ShowDialog();
            }
        }
    }
}