|
- using CnasSynchronusIDAL;
- using CnasSynchrousModel;
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
-
- namespace CnasSynchronusDAL
- {
- public class ExcelDBService : IExcelService
- {
- public DataTable GetDataByTableName(ExcelOpenParams t, ConditionParams u)
- {
- return ExcelDAL.ReadExcelByNameToTable(
- t.StrPath,
- t.ExcelFileVersion,
- t.autoSql.ExcelViewName,
- t.autoSql.ExcelViewSql,
- u.TableName);
- }
-
- public Dictionary<string, DataTable> GetInstrumentData(ExcelOpenParams t)
- {
- return ExcelDAL.ReadExcelTableNameToTable(t.StrPath, t.ExcelFileVersion);
- }
-
- public DataTable GetInstrumentDataByDate(ExcelOpenParams t, ConditionParams u)
- {
- return ExcelDAL.ReadExcelTableNameToTableByDate(
- t.StrPath,
- t.ExcelFileVersion,
- t.autoSql.ExcelViewName,
- t.autoSql.ExcelViewSql,
- u.TableName,
- u.DateColumn,
- u.DateValue
- );
- }
-
- public DataTable GetInstrumentDataStruct(ExcelOpenParams t, ConditionParams u)
- {
- return ExcelDAL.ReadExcelTableStruct(
- t.StrPath,
- t.ExcelFileVersion,
- t.autoSql.ExcelViewName,
- t.autoSql.ExcelViewSql,
- u.TableName);
- }
- }
- }
|