From adee7a71ba7ab1b63cab63381dfe1846437853d6 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期四, 02 三月 2023 17:37:05 +0800
Subject: [PATCH] 增加分销商配置
---
web/Dao/GwClientDao.cs | 29 ++++++++++++++++++++++++-----
1 files changed, 24 insertions(+), 5 deletions(-)
diff --git a/web/Dao/GwClientDao.cs b/web/Dao/GwClientDao.cs
index 4b02d9d..196a96f 100644
--- a/web/Dao/GwClientDao.cs
+++ b/web/Dao/GwClientDao.cs
@@ -1,7 +1,7 @@
锘�
using Common;
using Model;
-using Oracle.DataAccess.Client;
+using Oracle.ManagedDataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data;
@@ -28,8 +28,7 @@
/// <param name="supportStaff">褰掑睘瀹㈡湇浜哄憳</param>
/// <param name="productId">浜у搧ID</param>
/// <returns></returns>
- //public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telphone, string agent)
- public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telephone, string agent, string company, string salesman, string supportStaff, string productId, int isEnable, string permissionsSQL )
+ public List<GwClient> LoadInfoList(out int recordCount, int pageIndex, int pageSizestring, string clientID, string clientName, string telephone, string agent, string company, string salesman, string supportStaff, string productId, int isEnable,int isSub, string permissionsSQL )
{
List<GwClient> list = new List<GwClient>();
@@ -46,7 +45,7 @@
stringBuilder.Append(" ) t on t.client_id = gwc.client_id ");
//stringBuilder.Append("from GW_CLIENT where 1=1");
stringBuilder.Append(" WHERE 1=1");
- OracleParameter[] oracleParameterArray = new OracleParameter[8];
+ OracleParameter[] oracleParameterArray = new OracleParameter[9];
if (clientID != null && clientID != "")
{
oracleParameterArray[0] = new OracleParameter(":ClientID", (OracleDbType)126);
@@ -97,10 +96,26 @@
stringBuilder.Append(" and gwc.IS_ENABLE = :IS_ENABLE");
}
+ //鏄惁涓�绾ц处鎴枫��0涓轰竴绾�
+ if (isSub == 0)
+ {
+ oracleParameterArray[8] = new OracleParameter(":CLIENT_PARENTID", OracleDbType.Int32);
+ ((DbParameter)oracleParameterArray[8]).Value = (object)(isSub);
+ stringBuilder.Append(" and gwc.CLIENT_PARENTID = :CLIENT_PARENTID");
+ }
+ else
+ {
+ oracleParameterArray[8] = new OracleParameter(":CLIENT_PARENTID", OracleDbType.Int32);
+ ((DbParameter)oracleParameterArray[8]).Value = (object)(isSub);
+ stringBuilder.Append(" and gwc.CLIENT_PARENTID != 0");
+ }
+
+
if (productId != null && productId != "")
{
stringBuilder.Append(" and gwc.CLIENT_ID IN ( SELECT distinct CLIENT_ID FROM GW_SP WHERE PRODUCT_ID = '" + productId + "' )");
}
+
//瀹㈡埛鏉冮檺SQL鑴氭湰
stringBuilder.Append(permissionsSQL);
@@ -305,7 +320,10 @@
*/
public bool UpdateClientAmount(Int64 AddBalance, Int64 payAmount, string clientId )
{
- return OracleHelper.ExecuteSql("UPDATE GW_CLIENT SET BALANCE=(BALANCE + :BALANCE), TOP_UP_AMOUNT_TOTAL=(TOP_UP_AMOUNT_TOTAL + :TOP_UP_AMOUNT_TOTAL) WHERE CLIENT_ID=:CLIENT_ID", OracleHelper.Connection, new OracleParameter(":BALANCE", (object)AddBalance), new OracleParameter(":TOP_UP_AMOUNT_TOTAL", (object)payAmount), new OracleParameter(":CLIENT_ID", (object)clientId)) > 0;
+ return OracleHelper.ExecuteSql("UPDATE GW_CLIENT SET BALANCE=(BALANCE + :BALANCE)," +
+ " TOP_UP_AMOUNT_TOTAL=(TOP_UP_AMOUNT_TOTAL + :TOP_UP_AMOUNT_TOTAL) WHERE CLIENT_ID=:CLIENT_ID",
+ OracleHelper.Connection, new OracleParameter(":BALANCE", (object)AddBalance),
+ new OracleParameter(":TOP_UP_AMOUNT_TOTAL", (object)payAmount), new OracleParameter(":CLIENT_ID", (object)clientId)) > 0;
}
public bool UpdateClientProduct(string clientId, string productId)
@@ -511,6 +529,7 @@
o.SupportStaff = oracleReaderWrapper.GetString("SUPPORT_STAFF", "");
o.FinancialStaff = oracleReaderWrapper.GetString("FINANCIAL_STAFF", "");
o.ChargeType = oracleReaderWrapper.GetInt("CHARGE_TYPE", 0);
+ o.SmsBillType = oracleReaderWrapper.GetInt("SMS_BILLTYPE",0);
o.SmsStatusReport = oracleReaderWrapper.GetInt("SMS_STATUS_REPORT", 0);
o.MmsStatusReport = oracleReaderWrapper.GetInt("MMS_STATUS_REPORT", 0);
--
Gitblit v1.9.1