扫码系统新增生产领料、直接调拨校验数量控制参数

yxj

2022-04-21 74df9dfff2c73f969626a4cdcbbc27fdcb421107

 BaseSet/公用资料/其他基础资料/Gy_StdWorkTimesList.cs

@@ -266,28 +266,21 @@
                HParentID = sr[0].ToString();
            }
            //杩囨护鏉′欢
            if (frmCondition.SqlStr.Trim().Length == 0)
            if (HParentID == "" || HParentID == "鐗╂枡璧勬枡" || HParentID == "宸ュ簭璧勬枡")
            {
                if (HParentID == "" || HParentID == "鐗╂枡璧勬枡" || HParentID == "宸ュ簭璧勬枡")
                {
                    sSql = "Select top 10000 * from " + ViewName + " order by  HItemID Desc";
                }
                else
                {
                    if (wl.Checked == false)
                    {
                        sSql = "Select top 10000 * from " + ViewName + " where 宸ュ簭浠ｇ爜 like '%" + HParentID.ToString() + "%' order by HItemID Desc" ;
                    }
                    else
                    {
                        sSql = "Select top 10000 * from " + ViewName + " where 鐗╂枡浠ｇ爜 like '%" + HParentID.ToString() + "%' order by HItemID Desc ";
                    }

                }
                sSql = "Select top 10000 * from " + ViewName + " order by  HItemID Desc";
            }
            else
            {
                sSql = frmCondition.SqlStr + sWhere + " order by  HItemID Desc";
                if (wl.Checked == false)
                {
                    sSql = "Select top 10000 * from " + ViewName + " where 宸ュ簭浠ｇ爜 like '%" + HParentID.ToString() + "%' order by HItemID Desc";
                }
                else
                {
                    sSql = "Select top 10000 * from " + ViewName + " where 鐗╂枡浠ｇ爜 like '%" + HParentID.ToString() + "%' order by HItemID Desc ";
                }

            }
            //鎵цSQL
            DSet = SubCn.RunProcReturn(sSql, ViewName);
@@ -310,12 +303,12 @@
            oSumGrid.BuildTotalCols(sT);
            //  
            //鍐荤粨
            int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
            string s = frmCondition.cmbHComplete.Text;
            DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
            //int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
            //string s = frmCondition.cmbHComplete.Text;
            //DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
            //鐢荤嚎
            //
            Total();
            //Total();
        }

        //鍚堣 new