public MainWindow()
        {
            InitializeComponent();
            DataHandlerFactory dataHandlerFactory = new DataHandlerFactory();

            DataHandler = dataHandlerFactory.CreateDataHandler(ConfigurationManager.AppSettings["DataSourceType"]);
        }
示例#2
0
        public void Create_ReturnAnOracleHandler()
        {
            DataHandlerFactory factory = new DataHandlerFactory();
            IDataHandler myHandler = factory.Create( "OracleHandler" );

            Assert.AreEqual( "OracleHandler", myHandler.HandlerClassID() );
        }
示例#3
0
 public void Initialize()
 {
     dataHandlerFactory = new DataHandlerFactory();
     xMLDataHandler     = new XMLDataHandler();
     cSVDataHandler     = new CSVDataHandler();
     dBDataHandler      = new DBDataHandler(new CarDBContext());
 }
示例#4
0
        /// <summary>
        /// 获取数据列表
        /// </summary>
        /// <param name="connStr"></param>
        /// <param name="dataHandlerTypeName"></param>
        /// <param name="sql"></param>
        /// <param name="op"></param>
        /// <param name="ed"></param>
        /// <returns></returns>
        public static DataTable GetDataList(string connStr, string dataHandlerTypeName, string sql, DateTime op, DateTime ed)
        {
            IDataHandler dataHandler = DataHandlerFactory.GetHandler(dataHandlerTypeName);

            dataHandler.DBConnectStr = connStr;
            return(dataHandler.GetDataList(sql, op, ed));
        }
示例#5
0
        /// <summary>
        /// 连接数据库测试
        /// </summary>
        /// <param name="connStr"></param>
        /// <param name="dataHandlerTypeName"></param>
        /// <returns></returns>
        public static bool DBConnectOpen(string connStr, string dataHandlerTypeName)
        {
            IDataHandler dataHandler = DataHandlerFactory.GetHandler(dataHandlerTypeName);

            dataHandler.DBConnectStr = connStr;
            return(dataHandler.DBConnectOpen());
        }
        public void Test()
        {
            IDataHandler handler = DataHandlerFactory.GetHandler("Transfer8Pro.DAO.DataHandlers.SqlServer_DataHandler");  //new SqlServer_DataHandler();

            handler.DBConnectStr = "server=192.168.0.14;database=OX;uid=sa;pwd=sa.";
            string sql = "SELECT top 100 AuthorID,AuthorName FROM [OX].[dbo].[AT_AuthorInfo] WHERE CreateTime>@StartTime AND CreateTime<@EndTIme ";

            handler.OutputData(sql, new DateTime(2018, 3, 1), new DateTime(2018, 4, 1), @"R:\tmp.jl");
        }
        public void Test_Oracle()
        {
            var s = DataHandlerFactory.DBTypes;

            IDataHandler handler = DataHandlerFactory.GetHandler("Transfer8Pro.DAO.DataHandlers.Oracle_DataHandler");  //new SqlServer_DataHandler();

            handler.DBConnectStr = "Data Source=(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.60) (PORT=18991)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL12)));User Id=ox;Password=ox_pwd";
            string sql = "select * from OX_KINDINFO where CreatedTime>:StartTime AND CreatedTime<:EndTIme  ";

            handler.OutputData(sql, new DateTime(2018, 11, 1), new DateTime(2018, 12, 1), @"R:\tmp.jl");
        }
示例#8
0
        public override void BuildDbFile()
        {
            Action <TaskEntity> action = t8Task =>
            {
                try
                {
                    BuildInstanceObject buildInstanceService = new BuildInstanceObject();
                    //1得到数据库文件路径
                    AFileName     fileNameStragety     = buildInstanceService.GetGenerateFileNameStragety(3);
                    ISqlQueryTime SqlQueryTimeStragety = buildInstanceService.GetSqlQueryTimeStragety(t8Task.CycleType);

                    FileInfoEntity fileInfoEntity = new FileInfoEntity();
                    fileInfoEntity.NormalFileName = fileNameStragety.FileName(t8Task);
                    fileInfoEntity.NormalFilePath = fileNameStragety.FileFullName(t8Task);
                    fileInfoEntity.SqlStartTime   = SqlQueryTimeStragety.StartTime(DateTime.Now);
                    fileInfoEntity.SqlEndTime     = SqlQueryTimeStragety.EndTime(DateTime.Now);

                    t8Task.FileInfo = fileInfoEntity;

                    //2创建数据库文件并添加数据
                    IDataHandler handler = DataHandlerFactory.GetHandler(t8Task.DataHandler);
                    handler.DBConnectStr = Common.DecryptData(t8Task.DBConnectString_Hashed);
                    string sql       = t8Task.SQL;
                    bool   isSuccess = handler.OutputDataToSQLite(sql, fileInfoEntity.SqlStartTime, fileInfoEntity.SqlEndTime, fileInfoEntity.NormalFilePath);
                    Thread.Sleep(300);
                    if (!isSuccess)
                    {
                        LogUtil.WriteLog($"从数据库向数据文件[{fileInfoEntity.NormalFilePath}]导入数据出现错误");
                        throw new Exception($"从数据库向数据文件[{fileInfoEntity.NormalFilePath}]导入数据出现错误");
                    }

                    LogUtil.WriteLog($"数据文件[{fileInfoEntity.NormalFilePath}]创建并添加数据完成");
                }
                catch (Exception ex)
                {
                    LogUtil.WriteLog(ex);
                    throw new Exception(ex.Message);
                }
            };

            product.AddPart(action);
        }
示例#9
0
        public void InstantiateAFactory()
        {
            DataHandlerFactory factory = new DataHandlerFactory();

            Assert.AreNotEqual( null, factory );
        }