| | |
|---|
| | | { |
|---|
| | | 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", ""), |
|---|
| | | }); |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | |
|---|
| | | 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) |
|---|
