产品分配账户

yzh

2021-10-11 6c4ea53f92500f49959013c36b5c67fed25cd791

 web/Dao/GwProductDao.cs

@@ -48,7 +48,7 @@
                stringBuilder.Append(" and op_group_id=:op_group_id");
            }

            stringBuilder.Append(" order by ID DESC");
            stringBuilder.Append(" order by PATH ");
            using (OracleDataReader reader = OracleHelper.ExecuteReader("select count(*) as count " + stringBuilder.ToString(), OracleHelper.Connection, list2.ToArray()))
            {
                while (((DbDataReader)reader).Read())
@@ -118,6 +118,24 @@
        }

        /**
         * 获取产品列表
         * */
        public List<GwProduct> getGwProductList()
        {
            List<GwProduct> list = new List<GwProduct>();
            using (OracleDataReader reader = OracleHelper.ExecuteReader(string.Format("select * from GW_PRODUCT where IS_ENABLE = 1 AND CLASSES=1 "), OracleHelper.Connection))
            {
                while (reader != null && ((DbDataReader)reader).Read())
                {
                    GwProduct o = new GwProduct();
                    if (this.ReadInfo(reader, o))
                        list.Add(o);
                }
            }
            return list;
        }

        /**
         * 根据产品ID获取产品信息
         * */
        public GwProduct find(string productId)