数据过滤

lu

2025-08-25 42b161dc715b3bcc91311be408c8a408f4e450b1

 DevApp/Gs.DevApp/DevFrm/RkQC/RkDetect01.cs

@@ -64,7 +64,11 @@
            btnIpt.Click += BtnIpt_Click;
            string rptName = "";
            if (strType == QcSeason.受托入库.ToString())
            {
                rptName = "rpt_Strk";
                layoutControlItem25.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
                layoutControlItem27.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
            }
            else
                  if (strType == QcSeason.其它入库检.ToString())
            {
@@ -439,7 +443,8 @@
            toolBarMenu1.isSetBtn = false;
            string rkckid = txt_rkCkId.GetId();
            if (strType == QcSeason.超期检.ToString()
                || strType == QcSeason.其它入库检.ToString())
                || strType == QcSeason.其它入库检.ToString()
                || strType == QcSeason.受托入库.ToString())
            {

            }
@@ -497,11 +502,17 @@
        {
            gcMain1.DataSource = null;
            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            _sbSqlWhere.Append(" and a.ReceiveOrgId in");
            _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
            _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
            if (strType == QcSeason.其它入库检.ToString())
            {
                _sbSqlWhere.Append(" and isnull(qtrk.qt028,0)=1 and isnull(qtrk.qt032,0)=1 and isnull(qtrk.qt015,0)=1 ");
            }
            if (strType == QcSeason.受托入库.ToString())
            {
                _sbSqlWhere.Append(" and isnull(st.isCheck,0)=1 and isnull(st.qt032,0)=1");
            }
            PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "release_no", "asc", "", " and a.order_type='" + strType + "' " + _sbSqlWhere.ToString());
            string json = JsonConvert.SerializeObject(pgq);
            try