CNAS/CnasSynchronusClient/TargetCnasData/ICnasDataOperation.cs

using CnasSynchronousCommon;
using CnasSynchronusDAL;
using CnasSynchrousModel;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;

namespace CnasSynchronusClient
{
    /// <summary>
    /// CNAS数据操作接口
    /// </summary>
    public interface ICnasDataOperation
    {
        //测试连接
        bool TestConnect(DataBaseInfo dataBase);

        //获取所有表名称
        DataTable GetAllCNASTablesName(DataBaseInfo dataBase);

        //获取第一张表的表结构
        DataTable GetCNASTablesStruct(string strTableName, DataBaseInfo dataBase);

        //向第一张表的表中插入数据
        int InsertDataToCNASTable(DataTable dt, DataBaseInfo dataBase, List<SyncParamasInfo> syncParamasInfos, string strInstrumentColumn, List<CnasConditionMapValue> lstFixedValue = null);

        //获取所有表的数据类型和长度
        DataTable GetCNASTableTypeLenth(string strTableName, DataBaseInfo dataBase);

        /// <summary>
        /// 根据表名和时间列名获取该表内该列最大时间
        /// </summary>
        /// <param name="dataBase"></param>
        /// <param name="strTableName"></param>
        /// <param name="strDateColumn"></param>
        /// <returns></returns>
        string GetMaxTimeByTableName(DataBaseInfo dataBase, string strTableName, string strDateColumn, string strInstrumentColumn, string strInstrumentValue);

        /// <summary>
        /// 根据用户名密码获取登陆信息
        /// </summary>
        /// <param name="dataBase"></param>
        /// <param name="strUserName"></param>
        /// <param name="strPwd"></param>
        /// <returns></returns>
        DataTable GetLoginNameByPwd(DataBaseInfo dataBase, string strUserName, string strPwd);

        /// <summary>
        /// 根据Mac地址验证数据是否存在
        /// </summary>
        /// <param name=""></param>
        /// <param name="strMac"></param>
        /// <returns></returns>
        bool CheckMacMessage(DataBaseInfo dataBase, string strMac);

        /// <summary>
        /// 获取某个表的数据
        /// </summary>
        /// <param name="dataBase"></param>
        /// <param name="strSql"></param>
        /// <returns></returns>
        DataTable GetTableData(DataBaseInfo dataBase, string strSql);


        /// <summary>
        /// 插入某个表的数据
        /// </summary>
        /// <param name="dataBase"></param>
        /// <param name="strSql"></param>
        /// <returns></returns>
        bool InsertTableData(DataBaseInfo dataBase, string strSql);

    }


}