#region

using System;
using System.Collections.Generic;
using System.Data;
using CSFrameworkV5.Common;
using CSFrameworkV5.Core;
using CSFrameworkV5.Interfaces.InterfaceModels;
using CSFrameworkV5.Models;

#endregion

namespace CSFrameworkV5.Business
{
    /// *************************************************************************/
    /// *
    /// * 文件名    ：CommonData.cs      
    /// 
    /// * 程序说明  : 系统公共数据
    ///                
    /// * 原创作者  ：www.csframework.com 
    /// * Copyright 2006-2021 C/S框架网 www.csframework.com
    /// *
    /// **************************************************************************/
    /// <summary>
    ///     系统公共数据
    /// </summary>
    public static class CommonData
    {
        private static TCompanyInfo _CompanyInfo;

        /// <summary>
        ///     公司资料
        /// </summary>
        public static TCompanyInfo CompanyInfo => _CompanyInfo;

        /// <summary>
        ///     服务器日期
        /// </summary>
        public static DateTime ServerDay
        {
            get
            {
                var dt = ServerTime;
                return new DateTime(dt.Year, dt.Month, dt.Day);
            }
        }

        /// <summary>
        ///     服务器时间
        /// </summary>
        public static DateTime ServerTime
        {
            get
            {
                var bridge = BridgeFactory.CreateCommonDataBridge();
                return bridge.GetServerTime();
            }
        }

        /// <summary>
        ///     获取系统业务表
        /// </summary>
        /// <returns></returns>
        public static DataTable GetBusinessTables()
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetBusinessTables();
        }

        /// <summary>
        ///     获取系统所需公共信息
        /// </summary>
        public static void GetCommonInfos()
        {
            var bll = new bllCompanyInfo();
            bll.GetSummaryData(false);

            //获取公司资料
            var dt = bll.SummaryTable;
            if (dt.Rows.Count > 0)
                _CompanyInfo =
                    (TCompanyInfo)DataConverter.DataRowToObject(dt.Rows[0],
                        typeof(TCompanyInfo));
            else
                _CompanyInfo = new TCompanyInfo();
        }

        /// <summary>
        ///     获取当前帐套的数据字典。若要获取其它库的资料需要指定数据库名，请使用重载的GetDataDict方法
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        public static DataTable GetDataDict(string tableName)
        {
            var bridge =
                BridgeFactory.CreateDataDictBridge(tableName,
                    Loginer.CurrentUser.DBID);
            return bridge.GetSummaryData();
        }

        /// <summary>
        ///     取指定数据库的资料表
        /// </summary>
        /// <param name="DBName">数据库名</param>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        public static DataTable GetDataDict(string DBID, string tableName)
        {
            var bridge = BridgeFactory.CreateDataDictBridge(tableName, DBID);
            return bridge.GetSummaryData();
        }

        /// <summary>
        ///     获取数据字典数据的流水号
        /// </summary>
        /// <param name="dataCode">字头</param>
        /// <param name="asHeader">若数据库没有字头定义，自动添加</param>
        /// <returns></returns>
        public static string GetDataSN(string dataCode, bool asHeader)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetDataSN(dataCode, asHeader);
        }

        public static List<DbTableModel> GetDbTableFields(string DBName,
            string TableName)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetDbTableFields(DBName, TableName);
        }

        public static List<DbTableModel> GetDbTables()
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetDbTables();
        }

        public static string GetDocNo(string DocNoName)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetDocNo(DocNoName);
        }

        /// <summary>
        ///     取表结构
        /// </summary>
        /// <param name="DBName"></param>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public static DataTable GetEmptyTable(string DBID, string tableName)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetEmptyTable(DBID, tableName);
        }

        /// <summary>
        ///     取字典表的Lookup数据，通常只返回编号+名称
        /// </summary>
        /// <param name="tableName"></param>
        /// <returns></returns>
        public static DataTable GetLookupData(string tableName)
        {
            var bridge =
                BridgeFactory.CreateDataDictBridge(tableName,
                    Loginer.CurrentUser.DBID);
            return bridge.GetLookupData();
        }

        /// <summary>
        ///     获取系统模块
        /// </summary>
        /// <returns></returns>
        public static DataTable GetModules()
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetModules();
        }

        /// <summary>
        ///     获取帐套
        /// </summary>
        /// <returns></returns>
        public static DataTable GetSystemDataSet()
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetSystemDataSet();
        }

        /// <summary>
        ///     获取指定用户的帐套
        /// </summary>
        /// <param name="user"></param>
        /// <param name="password"></param>
        /// <returns></returns>
        public static DataTable GetSystemDataSet(string user, string password)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetSystemDataSet(user, password);
        }

        /// <summary>
        ///     获取我的系统参数及系统预设参数，(用于加载SystemSettings类）
        /// </summary>
        /// <param name="UserID"></param>
        /// <returns></returns>
        public static DataTable GetSystemSettings4Program(string DataSetID,
            string UserID)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetSystemSettings4Program(DataSetID, UserID);
        }

        /// <summary>
        ///     获取我的自定义参数,查询方法
        /// </summary>
        /// <param name="UserID"></param>
        /// <returns></returns>
        public static DataTable GetSystemSettingsByUser(string DataSetID,
            string UserID)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetSystemSettingsByUser(DataSetID, UserID);
        }

        /// <summary>
        ///     系统参数，搜索功能
        /// </summary>
        /// <param name="ParamName"></param>
        /// <returns></returns>
        public static DataTable GetSystemSettingsEx(string ParamName,
            string ParamType)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetSystemSettingsEx(ParamName, ParamType);
        }

        /// <summary>
        ///     获取表的所有字段
        /// </summary>
        /// <param name="tableName">表名</param>
        public static DataTable GetTableFieldsDef(string tableName,
            bool onlyDisplayField)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.GetTableFieldsDef(tableName, onlyDisplayField);
        }

        public static void PostSystemSettings(SystemSettings settings)
        {
            var dtOld = GetDataDict(Globals.DEF_SYSTEM_DBID,
                sys_SystemSettings.__TableName);
            SystemSettings.GetRow(dtOld, "AllowDBLog")[
                    sys_SystemSettings.ParamValue] =
                settings.AllowDBLog ? "Y" : "N";
            SystemSettings.GetRow(dtOld, "AllowLocalLog")[
                    sys_SystemSettings.ParamValue] =
                settings.AllowLocalLog ? "Y" : "N";
            SystemSettings.GetRow(dtOld, "LoginAuthType")[
                sys_SystemSettings.ParamValue] = (int)settings.LoginAuthType;
            SystemSettings.GetRow(dtOld, "ModuleLoadType")[
                    sys_SystemSettings.ParamValue] =
                (int)settings.ModuleLoadType;

            var ds = new DataSet();
            ds.Tables.Add(dtOld.Copy());
            var B = BridgeFactory.CreateDataDictBridge(
                typeof(sys_SystemSettings), Globals.DEF_SYSTEM_DBID);
            B.Update(ds);
        }

        public static void PostUserSettings(Loginer currentUser,
            string paramKey, string paramValue)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            bridge.PostUserSettings(currentUser, paramKey, paramValue);
        }

        public static DataTable SearchOutstanding(string invoiceNo,
            string customer, DateTime dateFrom, DateTime dateTo,
            DateTime dateEnd, string outstandingType)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.SearchOutstanding(invoiceNo, customer, dateFrom,
                dateTo, dateEnd, outstandingType);
        }

        public static DataSet SearchOutstanding_ByPage(string invoiceNo,
            string customer, DateTime dateFrom,
            DateTime dateTo, DateTime dateEnd, string outstandingType,
            int pageNo, int pageSize)
        {
            var bridge = BridgeFactory.CreateCommonDataBridge();
            return bridge.SearchOutstandingByPage(invoiceNo, customer, dateFrom,
                dateTo, dateEnd, outstandingType,
                pageNo, pageSize);
        }

        /// <summary>
        ///     测试登出操作
        /// </summary>
        /// <param name="count"></param>
        /// <returns></returns>
        public static int TestLogout(int count)
        {
            var user = BridgeFactory.CreateUserBridge();

            //循环测试
            for (var i = 1; i <= count; i++)
                user.Logout(new LoginUser(Loginer.CurrentUser));

            return count;
        }
    }
}