From 93dbdc305bd736f5745d217e33e2ba79cc7782fe Mon Sep 17 00:00:00 2001
From: wzp <2880584989@qq.com>
Date: 星期二, 12 七月 2022 10:35:23 +0800
Subject: [PATCH] RPT最新版本的保存更新
---
web/Dao/GwRptCodeDao.cs | 9 +++++++--
1 files changed, 7 insertions(+), 2 deletions(-)
diff --git a/web/Dao/GwRptCodeDao.cs b/web/Dao/GwRptCodeDao.cs
index d89323c..37a7460 100644
--- a/web/Dao/GwRptCodeDao.cs
+++ b/web/Dao/GwRptCodeDao.cs
@@ -46,7 +46,10 @@
{
Spid = oracleReaderWrapper.GetString("SPID", ""),
Proportion = oracleReaderWrapper.GetString("Proportion", ""),
- CreateTime = oracleReaderWrapper.GetDateTime("CREATETIME")
+ CreateTime = oracleReaderWrapper.GetDateTime("CREATETIME"),
+ TimeSpan = oracleReaderWrapper.GetString("TimeSpan","10"),
+ Threshold = oracleReaderWrapper.GetString("Threshold", "10000"),
+ WhitePhone = oracleReaderWrapper.GetString("WhitePhone", ""),
});
}
}
@@ -55,7 +58,9 @@
public bool AddAccountCode(RptAccount code)
{
- return OracleHelper.ExecuteSql("INSERT INTO GW_RPT_ACCOUNT(SPID,PROPORTION,CREATETIME) VALUES(:SPID,:PROPORTION,SYSDATE)", OracleHelper.Connection, new OracleParameter(":SPID", (object)code.Spid), new OracleParameter(":PROPORTION", (object)code.Proportion)) > 0;
+ return OracleHelper.ExecuteSql("INSERT INTO GW_RPT_ACCOUNT(SPID,PROPORTION,CREATETIME,TimeSpan,Threshold,WhitePhone) VALUES(:SPID,:PROPORTION,SYSDATE,:TimeSpan,:Threshold,:WhitePhone)",
+ OracleHelper.Connection, new OracleParameter(":SPID", (object)code.Spid), new OracleParameter(":PROPORTION", (object)code.Proportion),
+ new OracleParameter(":TimeSpan", (object)code.TimeSpan), new OracleParameter(":Threshold", (object)code.Threshold),new OracleParameter(":WhitePhone", (object)code.WhitePhone)) > 0;
}
public bool DeleteAccount(string spid)
--
Gitblit v1.9.1