From 2f74eb23c0d2d4a246bc612c5c34bdfa8dea5603 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期五, 11 十一月 2022 09:25:02 +0800
Subject: [PATCH] 修改账号产品关联的bug 修改产品不显示的bug
---
web/Dao/GwClientProductDao.cs | 35 ++++++++++++++++++++++++++++++++++-
1 files changed, 34 insertions(+), 1 deletions(-)
diff --git a/web/Dao/GwClientProductDao.cs b/web/Dao/GwClientProductDao.cs
index 7df596f..443b4b8 100644
--- a/web/Dao/GwClientProductDao.cs
+++ b/web/Dao/GwClientProductDao.cs
@@ -1,5 +1,6 @@
锘縰sing System;
using System.Collections.Generic;
+using System.Data.Common;
using System.Linq;
using System.Text;
using Common;
@@ -32,9 +33,41 @@
/// <returns></returns>
public bool Add(GwClientProduct gcp)
{
- return OracleHelper.ExecuteSql("insert into GW_Client_Product(id,client_id,product_id) values(:id,:client_id,:product_id)", OracleHelper.Connection, new OracleParameter(":id", (object)gcp.Id), new OracleParameter(":client_id", (object)gcp.ClientId), new OracleParameter(":product_id", (object)gcp.ProductId)) > 0;
+ return OracleHelper.ExecuteSql("insert into GW_Client_Product(id,client_id,product_id,sp_id,ACTIVATE_STATUS) values(:id,:client_id,:product_id,:sp_id,:ACTIVATE_STATUS)",
+ OracleHelper.Connection, new OracleParameter(":id", (object)gcp.Id), new OracleParameter(":client_id", (object)gcp.ClientId),
+ new OracleParameter(":product_id", gcp.ProductId),new OracleParameter(":sp_id",gcp.SpId),
+ new OracleParameter(":ACTIVATE_STATUS", gcp.ActivateStatus)) > 0;
}
+ /// <summary>
+ /// 鏇存柊
+ /// </summary>
+ /// <param name="gcp"></param>
+ /// <returns></returns>
+ public bool Update(GwClientProduct gcp)
+ {
+ return OracleHelper.ExecuteSql("update GW_Client_Product set product_id=:product_id,client_id=:client_id where sp_id=:sp_id ",
+ OracleHelper.Connection, new OracleParameter(":product_id", gcp.ProductId), new OracleParameter(":sp_id", gcp.SpId),
+ new OracleParameter(":client_id",gcp.ClientId)
+ ) > 0;
+ }
+
+ /// <summary>
+ /// 鏌ユ壘璐﹀彿鏄惁瀛樺湪
+ /// </summary>
+ /// <param name="spid"></param>
+ /// <returns></returns>
+ public bool FindBySp(string spid)
+ {
+ using (OracleDataReader oracleDataReader = OracleHelper.ExecuteReader(string.Format("select * from GW_Client_Product where SP_ID=:SP_ID"), OracleHelper.Connection, new OracleParameter(":SP_ID", spid)))
+ {
+ if (oracleDataReader.Read())
+ return true;
+ }
+ return false;
+ }
+
+
}
}
--
Gitblit v1.9.1