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