RPT的处理

wzp

2021-11-30 f0a773e75016d08684a5c1fdd70d81f68141845d

 web/Dao/GwRptCodeDao.cs

@@ -29,6 +29,41 @@
      return list;
    }


        /// <summary>
        /// 获取账号比例
        /// </summary>
        /// <returns></returns>
        public List<RptAccount> LoadRptAccountList()
        {
            List<RptAccount> list = new List<RptAccount>();
            using (OracleDataReader reader = OracleHelper.ExecuteReader("SELECT * FROM GW_RPT_ACCOUNT ORDER BY CREATETIME ASC", OracleHelper.Connection))
            {
                while (reader != null && ((DbDataReader)reader).Read())
                {
                    OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader);
                    list.Add(new RptAccount()
                    {
                        Spid = oracleReaderWrapper.GetString("SPID", ""),
                        Proportion = oracleReaderWrapper.GetString("Proportion", ""),
                        CreateTime = oracleReaderWrapper.GetDateTime("CREATETIME")
                    });
                }
            }
            return list;
        }

        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;
        }

        public bool DeleteAccount(string spid)
        {
            return OracleHelper.ExecuteSql("DELETE FROM GW_RPT_ACCOUNT WHERE SPID = :SPID", OracleHelper.Connection, new OracleParameter(":SPID", (object)spid)) > 0;
        }


    public void Dispose()
    {
    }