#region

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

#endregion

namespace CSFrameworkV5.Interfaces
{
    /// <summary>
    ///     公共数据层的桥接接口
    /// </summary>
    public interface IBridge_CommonData
    {
        /// <summary>
        ///     审核/反审通用方法
        /// </summary>
        /// <param name="P">参数</param>
        /// <returns></returns>
        bool ApprovalBusiness(QueryApproval P);

        /// <summary>
        ///     获取业务单据名称定义清单
        /// </summary>
        /// <returns></returns>
        DataTable GetBusinessTables();

        /// <summary>
        ///     获取系统生成的流水号码
        /// </summary>
        /// <param name="dataCode">字头，如:PX,返回PX000001</param>
        /// <param name="asHeader">True:当号码表没有PX字头时，自动添加一条记录</param>
        /// <returns></returns>
        string GetDataSN(string dataCode, bool asHeader);

        /// <summary>
        ///     获取表结构描述
        /// </summary>
        /// <param name="DBName"></param>
        /// <param name="TableName"></param>
        /// <returns></returns>
        List<DbTableModel> GetDbTableFields(string DBName, string TableName);

        /// <summary>
        ///     获取字段名称定义表的表清单
        /// </summary>
        /// <returns></returns>
        List<DbTableModel> GetDbTables();

        string GetDocNo(string DocNoName);

        /// <summary>
        ///     取表结构
        /// </summary>
        /// <param name="DBID">账套编号</param>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        DataTable GetEmptyTable(string DBID, string tableName);

        /// <summary>
        ///     获取系统模块数据字典表
        /// </summary>
        /// <returns></returns>
        DataTable GetModules();

        /// <summary>
        ///     取服务器时间
        /// </summary>
        /// <returns></returns>
        DateTime GetServerTime();

        /// <summary>
        ///     获取系统帐套数据表
        /// </summary>
        /// <returns></returns>
        DataTable GetSystemDataSet();

        /// <summary>
        ///     根据用户取系统数据库里的资料表
        /// </summary>
        /// <param name="user">用户</param>
        /// <param name="password">密码</param>
        /// <returns></returns>
        DataTable GetSystemDataSet(string user, string password);

        DataTable GetSystemSettings4Program(string DataSetID, string UserID);

        DataTable GetSystemSettingsByUser(string DataSetID, string UserID);

        DataTable GetSystemSettingsEx(string paramName, string ParamType);

        /// <summary>
        ///     取表结构
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        DataTable GetTableFields(string tableName);

        /// <summary>
        ///     取表结构
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <param name="onlyDisplayField">仅返回字段名</param>
        /// <returns></returns>
        DataTable GetTableFieldsDef(string tableName, bool onlyDisplayField);

        /// <summary>
        ///     下载升级程序
        /// </summary>
        /// <param name="upgraderName">程序名称</param>
        /// <param name="serverVer">程序版本</param>
        /// <returns></returns>
        byte[] GetUpgrader(string upgraderName, string serverVer);

        /// <summary>
        ///     下载版本更新表数据
        /// </summary>       
        /// <returns></returns>
        DataTable GetUpgraderVersionData();

        /// <summary>
        ///     取升级程序版本
        /// </summary>
        /// <param name="upgraderName">程序名称</param>
        /// <returns></returns>
        string GetUpgraderVersion(string upgraderName);

        /// <summary>
        ///     提交用户个人设置的数据
        /// </summary>
        /// <param name="currentUser"></param>
        /// <param name="paramKey"></param>
        /// <param name="paramValue"></param>
        void PostUserSettings(Loginer currentUser, string paramKey,
            string paramValue);

        /// <summary>
        ///     查询客户应收应付帐款
        /// </summary>
        /// <param name="invoiceNo"></param>
        /// <param name="customer"></param>
        /// <param name="dateFrom"></param>
        /// <param name="dateTo"></param>
        /// <param name="dateEnd"></param>
        /// <param name="outstandingType"></param>
        /// <returns></returns>
        DataTable SearchOutstanding(string invoiceNo, string customer,
            DateTime dateFrom, DateTime dateTo,
            DateTime dateEnd, string outstandingType);

        /// <summary>
        ///     分页查询客户应收应付帐款
        /// </summary>
        /// <param name="invoiceNo">发票号码</param>
        /// <param name="customer">客户</param>
        /// <param name="dateFrom">起始日期</param>
        /// <param name="dateTo">结束日期</param>
        /// <param name="dateEnd">截止日期</param>
        /// <param name="outstandingType">类型:AR应收/AP应付</param>
        /// <param name="pageNo">当前页码</param>
        /// <param name="pageSize">每页返回的记录数</param>
        /// <returns></returns>
        DataSet SearchOutstandingByPage(string invoiceNo, string customer,
            DateTime dateFrom, DateTime dateTo,
            DateTime dateEnd,
            string outstandingType, int pageNo, int pageSize);

        /// <summary>
        ///     上传自动升级的程序
        /// </summary>
        /// <param name="upgraderName">程序名称</param>
        /// <param name="body">文件</param>
        /// <param name="version">版本号</param>
        /// <param name="uploadTime">上传日期</param>
        /// <param name="user">上传的用户</param>
        /// <returns></returns>
        bool UploadUpgrader(string upgraderName, byte[] body, string version,
            DateTime uploadTime, string user);

        DataTable GetReports(string reportsName);
    }
}