From 6c4ea53f92500f49959013c36b5c67fed25cd791 Mon Sep 17 00:00:00 2001
From: yzh <snbbt@21cn.com>
Date: 星期一, 11 十月 2021 19:00:15 +0800
Subject: [PATCH] 产品分配账户
---
web/Dao/GwProductDao.cs | 20 +++++++++++++++++++-
1 files changed, 19 insertions(+), 1 deletions(-)
diff --git a/web/Dao/GwProductDao.cs b/web/Dao/GwProductDao.cs
index 86abaea..f8d54af 100644
--- a/web/Dao/GwProductDao.cs
+++ b/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)
--
Gitblit v1.9.1