变更oracle访问组件

wzp

2023-03-02 374ce4ffd0c459bb4067e8d5765f972668aff9b1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
 
using Common;
using Oracle.ManagedDataAccess.Client;
using System;
using System.Data.Common;
 
namespace Dao
{
    public class GwSettingDao : IDisposable
    {
        public bool Update(string wxProfile, string smtpProfile, string smsProfile, string cmSegments, string cuSegments, string ctSegments, string gwName, string blackMoContent)
        {
            return OracleHelper.ExecuteSql("UPDATE  GW_SETTING SET SMTP_PROFILE=:SMTP_PROFILE,WX_PROFILE = :WX_PROFILE,SMS_PROFILE=:SMS_PROFILE,\r\nCM_SEGMENTS = :CM_SEGMENTS,CU_SEGMENTS=:CU_SEGMENTS,CT_SEGMENTS =:CT_SEGMENTS ,GW_NAME=:GW_NAME,BLACK_MO_CONTENT=:BLACK_MO_CONTENT\r\n                WHERE SETTING_ID=1", OracleHelper.Connection, new OracleParameter("WX_PROFILE", (object)wxProfile), new OracleParameter("SMTP_PROFILE", (object)smtpProfile), new OracleParameter("SMS_PROFILE", (object)smsProfile), new OracleParameter("CM_SEGMENTS", (object)cmSegments), new OracleParameter("CU_SEGMENTS", (object)cuSegments), new OracleParameter("CT_SEGMENTS", (object)ctSegments), new OracleParameter("BLACK_MO_CONTENT", (object)blackMoContent), new OracleParameter("GW_NAME", (object)gwName)) > 0;
        }
 
        public GwSetting GetCurrentSetting()
        {
            GwSetting gwSetting = new GwSetting();
            using (OracleDataReader reader = OracleHelper.ExecuteReader("SELECT * FROM GW_SETTING WHERE SETTING_ID=1", OracleHelper.Connection))
            {
                if (reader != null && ((DbDataReader)reader).Read())
                {
                    OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader);
                    gwSetting.SmtpProfile = this.FormatJson(oracleReaderWrapper.GetString("SMTP_PROFILE", ""));
                    gwSetting.WxProfile = this.FormatJson(oracleReaderWrapper.GetString("WX_PROFILE", ""));
                    gwSetting.SmsProfile = this.FormatJson(oracleReaderWrapper.GetString("SMS_PROFILE", ""));
                    gwSetting.CmSegments = oracleReaderWrapper.GetString("CM_SEGMENTS", "");
                    gwSetting.CuSegments = oracleReaderWrapper.GetString("CU_SEGMENTS", "");
                    gwSetting.CtSegments = oracleReaderWrapper.GetString("CT_SEGMENTS", "");
                    gwSetting.GwName = oracleReaderWrapper.GetString("GW_NAME", "");
                    gwSetting.Version = oracleReaderWrapper.GetString("VERSION", "");
                    gwSetting.BlackMoContent = oracleReaderWrapper.GetString("BLACK_MO_CONTENT", "");
                }
            }
            return gwSetting;
        }
 
        private string FormatJson(string v)
        {
            return string.IsNullOrEmpty(v) ? "{}" : v;
        }
 
        public void Dispose()
        {
        }
    }
}