1

yhj

2024-07-24 5e5d945e91568b973faa27d8ab0bcef99fc4a6c5

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
using System.Collections.Generic;
using System.Linq;
 
namespace CSFramework.DB
{
    /// <summary>
    /// 用户账套数据
    /// </summary>
    public class UserDataSet
    {
        public string ID { get; set; }
 
        public string Name { get; set; }
 
        public string ConnectionString_Local { get; set; }
 
        public string ConnectionString_Remote { get; set; }
    }
 
    /// <summary>
    /// 用户账套连接类型
    /// </summary>
    public enum UserDataSetConnect
    {
        LAN,
        WAN
    }
 
    /// <summary>
    /// 用户账套列表
    /// </summary>
    public static class UserDataSetList
    {
        private static List<UserDataSet> _List = new List<UserDataSet>();
 
        public static void InitList(List<UserDataSet> list)
        {
            _List.Clear();
            _List.AddRange(list);
        }
 
        public static void Add(UserDataSet dataset)
        {
            _List.Add(dataset);
        }
 
        public static string GetConnectionString(string dataSetID,
            UserDataSetConnect IPType)
        {
            var connectionStr = "";
 
            if (UserDataSetConnect.LAN == IPType)
            {
                var Q = (from item in _List.AsQueryable()
                    where item.ID == dataSetID
                    select item.ConnectionString_Local).ToList();
                connectionStr = Q[0];
            }
 
            if (UserDataSetConnect.WAN == IPType)
            {
                var Q = (from item in _List.AsQueryable()
                    where item.ID == dataSetID
                    select item.ConnectionString_Remote).ToList();
                connectionStr = Q[0];
            }
 
            return connectionStr;
        }
    }
}