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