From 374ce4ffd0c459bb4067e8d5765f972668aff9b1 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期四, 02 三月 2023 14:56:23 +0800
Subject: [PATCH] 变更oracle访问组件
---
web/Dao/GwClientProductDao.cs | 37 +++++++++++++++++++++++++++++++++++--
1 files changed, 35 insertions(+), 2 deletions(-)
diff --git a/web/Dao/GwClientProductDao.cs b/web/Dao/GwClientProductDao.cs
index 7df596f..4bb2434 100644
--- a/web/Dao/GwClientProductDao.cs
+++ b/web/Dao/GwClientProductDao.cs
@@ -1,10 +1,11 @@
锘縰sing System;
using System.Collections.Generic;
+using System.Data.Common;
using System.Linq;
using System.Text;
using Common;
using Model;
-using Oracle.DataAccess.Client;
+using Oracle.ManagedDataAccess.Client;
namespace Dao
{
@@ -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