public IDataAccessObjectEx GetDataAccessObjectFactory() { if (_dbObject == null) { throw new NullReferenceException("no DBObject found"); } if (_daoCache == null) { switch (_dbObject.DataBaseType) { case DBObject.DataBase.Oracle: case DBObject.DataBase.ManagedOracle: _daoCache = new OracleDao(_dbObject); break; case DBObject.DataBase.MSSQL: case DBObject.DataBase.MySQL: case DBObject.DataBase.Access: case DBObject.DataBase.SQLlite: case DBObject.DataBase.Sybase: default: throw new NotImplementedException("database not implement: " + _dbObject.DataBaseType); } } return(_daoCache); }
/// <summary> /// Initialize <see cref="Server.DateTime"/> object /// </summary> public static bool InitializeServerTime(IDataAccessObjectEx dao, out string message) { var internalDao = dao as IInternalDataAccessObject; if (internalDao == null) { message = "no date time sql"; return(false); // unknown server time sql } var serverTimeSql = internalDao.GetServerTime(); var dummyTable = internalDao.GetDummyTable(); var res = dao.ExecuteScalar("Select " + serverTimeSql + " FROM " + dummyTable, null, null); if (!res.IsSuccess) { message = res.Message; return(false); // execute false } var time = res.GetValue <DateTime>(); if (!time.HasValue) { message = "sys time is empty"; return(false); } message = null; _TimeOffset = time.Value - DateTime.Now; _TimeOffsetFlag = true; return(true); }
public DataAccessObjectWrapper(IDataAccessObjectEx dao) { _dao = (DataAccessObjectBase)dao; _db = (DbActionBase)_dao.DbAction; }
/// <summary> /// Initialize <see cref="Server.DateTime"/> object /// </summary> public static bool InitializeServerTime(IDataAccessObjectEx dao) { string message; return(InitializeServerTime(dao, out message)); }