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