修改显示包装单列表及修改包装单列表SQL

zgq

2021-01-23 452106da30aefb614239aa21a2ec58c98c3a1b09

修改显示包装单列表及修改包装单列表SQL

 NETSCM/ClsShowMod.cs

@@ -2126,7 +2126,7 @@
                        Sc_PackUnionBill oSc_PackUnionBill = new Sc_PackUnionBill();
                        oSc_PackUnionBill.ShowDialog(); 
                        break;
                    case "sc_packunionbillmainlist":
                    case "sc_packunionbilllist":
                        Sc_PackUnionBillList oSc_PackUnionBillList = new Sc_PackUnionBillList();
                        oSc_PackUnionBillList.MdiParent = oMain;
                        oSc_PackUnionBillList.ModCaption = gnmc;

 SCM/生产管理/Sc_PackUnionBillList.cs

@@ -105,7 +105,7 @@
                sql += " and 鏉＄爜 like '%" + txtHBarCode.Text.Trim() + "%'";
            }
            //寰楀埌淇℃伅
            string sql2 = "select * from " + ViewName + sql +" order by 鍞竴鏉＄爜 desc";
            string sql2 = "select * from " + ViewName + sql;/*+" order by 鍞竴鏉＄爜 desc";*/
            DataSet DS = oWeb.getDataSetBySQL(sql2, ViewName, ref DBUtility.ClsPub.sExeReturnInfo);
            if (DS==null ||  DS.Tables[0].Rows.Count == 0)
            {