系统账户管理列表用户角色显示优化

yzh

2022-06-23 203edd6bbdf883e897a0075037a4ef68cd519ac9

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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
 
using Common;
using Model;
using Oracle.DataAccess.Client;
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Text;
 
namespace Dao
{
  public class GwClientPayMentDao : IDisposable
  {
    public bool Update(GwClientPayMent item)
    {
      return OracleHelper.ExecuteSql("update GW_CLIENT_PAYMENT SET PAYMENT_NAME=:PAYMENT_NAME,RECEIVER_NAME=:RECEIVER_NAME,ACCOUNT=:ACCOUNT,PARTERNER_ID=:PARTERNER_ID,KEY=:KEY,IS_ENABLED=:IS_ENABLED WHERE PAYMENT_ID=:PAYMENT_ID", OracleHelper.Connection, new OracleParameter(":PAYMENT_ID", (object) item.PayMentID), new OracleParameter(":PAYMENT_NAME", (object) item.PayMentName), new OracleParameter(":RECEIVER_NAME", (object) item.ReceiverName), new OracleParameter(":ACCOUNT", (object) item.Account), new OracleParameter(":PARTERNER_ID", (object) item.PartnerID), new OracleParameter(":KEY", (object) item.Key), new OracleParameter(":IS_ENABLED", (object) item.IsEnabled)) > 0;
    }
 
    public bool Delete(int payMentID)
    {
      return OracleHelper.ExecuteSql("delete from GW_CLIENT_PAYMENT WHERE PAYMENT_ID=:PAYMENT_ID", OracleHelper.Connection, new OracleParameter(":PAYMENT_ID", (object) payMentID)) > 0;
    }
 
    public GwClientPayMent GetPayMentInfo(int payMentID)
    {
      GwClientPayMent o = new GwClientPayMent();
      using (OracleDataReader reader = OracleHelper.ExecuteReader("SELECT * FROM GW_CLIENT_PAYMENT WHERE PAYMENT_ID=:PAYMENT_ID", OracleHelper.Connection, new OracleParameter(":PAYMENT_ID", (object) payMentID)))
      {
        if (reader != null && ((DbDataReader) reader).Read())
          this.ReadInfo(reader, o);
      }
      return o;
    }
 
    public List<GwClientPayMent> LoadPayEnabledList()
    {
      List<GwClientPayMent> list = new List<GwClientPayMent>();
      try
      {
        StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.Append("SELECT * FROM GW_CLIENT_PAYMENT WHERE IS_ENABLED=0 ");
        using (OracleDataReader reader = OracleHelper.ExecuteReader(stringBuilder.ToString(), OracleHelper.Connection))
        {
          while (((DbDataReader) reader).Read())
          {
            GwClientPayMent o = new GwClientPayMent();
            if (this.ReadInfo(reader, o))
              list.Add(o);
          }
        }
      }
      catch (Exception ex)
      {
        LogHelper.Error(ex);
        return list;
      }
      return list;
    }
 
    public List<GwClientPayMent> LoadPayList()
    {
      List<GwClientPayMent> list = new List<GwClientPayMent>();
      try
      {
        StringBuilder stringBuilder = new StringBuilder();
        stringBuilder.Append("SELECT * FROM GW_CLIENT_PAYMENT");
        using (OracleDataReader reader = OracleHelper.ExecuteReader(stringBuilder.ToString(), OracleHelper.Connection))
        {
          while (((DbDataReader) reader).Read())
          {
            GwClientPayMent o = new GwClientPayMent();
            if (this.ReadInfo(reader, o))
              list.Add(o);
          }
        }
      }
      catch (Exception ex)
      {
        LogHelper.Error(ex);
        return list;
      }
      return list;
    }
 
    public bool Add(GwClientPayMent item)
    {
      return OracleHelper.ExecuteSql("INSERT INTO GW_CLIENT_PAYMENT(PAYMENT_ID,PAYMENT_NAME,RECEIVER_NAME,ACCOUNT,PARTERNER_ID,KEY,IS_ENABLED) VALUES(GW_CLIENT_PAYMENT_SEQ.nextval,:PAYMENT_NAME,:RECEIVER_NAME,:ACCOUNT,:PARTERNER_ID,:KEY,:IS_ENABLED)", OracleHelper.Connection, new OracleParameter(":PAYMENT_NAME", (object) item.PayMentName), new OracleParameter(":RECEIVER_NAME", (object) item.ReceiverName), new OracleParameter(":ACCOUNT", (object) item.Account), new OracleParameter(":PARTERNER_ID", (object) item.PartnerID), new OracleParameter(":KEY", (object) item.Key), new OracleParameter(":IS_ENABLED", (object) item.IsEnabled)) > 0;
    }
 
    private bool ReadInfo(OracleDataReader reader, GwClientPayMent o)
    {
      OracleReaderWrapper oracleReaderWrapper = new OracleReaderWrapper(reader);
      o.PayMentID = oracleReaderWrapper.GetInt("PAYMENT_ID", 0);
      o.PayMentName = oracleReaderWrapper.GetString("PAYMENT_NAME", "");
      o.ReceiverName = oracleReaderWrapper.GetString("RECEIVER_NAME", "");
      o.Account = oracleReaderWrapper.GetString("ACCOUNT", "");
      o.PartnerID = oracleReaderWrapper.GetString("PARTERNER_ID", "");
      o.Key = oracleReaderWrapper.GetString("KEY", "");
      o.IsEnabled = oracleReaderWrapper.GetInt("IS_ENABLED", 0);
      return true;
    }
 
    public void Dispose()
    {
    }
  }
}