public override object GetModel(string moduleId, NameValueCollection args)
{
if (moduleId == null)
{
return(null);
}
int si = moduleId.IndexOf(":");
string libId = moduleId.Substring(4, si - 4);
DataAccessType type = ModuleManager.GetDBType(libId);
string connStr = ModuleManager.GetDBConn(libId);
if (connStr == null)
{
return(null);
}
string sqlstr = HandleArgs(moduleId.Substring(si + 1), args);
StatisticControl ctrl = new StatisticControl();
ctrl.DataAccessType = type;
ctrl.ConnectionString = connStr;
ctrl.SQL = sqlstr;
ctrl.UploadFileVirtualPath = ModuleManager.UploadFileVirtualPath;
DynamicTable dt = ctrl.GetWebDynamicTable();
HandleArgs(dt, args);
dt = ctrl.GetWebDynamicTable();
HandleArgs(dt, args);
return(ctrl);
}
protected DBHelper GetDBHelper(DataAccessType accessType = DataAccessType.Default)
{
if (!SettingConfig.UseReadSeparation)//不使用主从时
{
FillParame(__DbHelper);
return(__DbHelper);
}
var _useTransactionScope = CallContext.GetData <bool>(Base.UseTransactionScopeName);
if (_useTransactionScope)//使用TransactionScope
{
FillParame(__DbHelper);
return(__DbHelper);
}
var _useCRLContext = CallContext.GetData <bool>(Base.UseCRLContextFlagName);
if (_useCRLContext)//对于数据库事务,只创建一个上下文
{
FillParame(__DbHelper);
return(__DbHelper);
}
var db = dbContext.GetDBHelper(accessType);
FillParame(db);
__DbHelper = db;
return(db);
}
/// <inheritdoc />
/// <summary>
/// Sql Server Data access
/// </summary>
/// <param name="connectionString">Connection string</param>
/// <param name="accessType">Data access type</param>
public SqlServerDataAccess(string connectionString, DataAccessType accessType = DataAccessType.StoredProcedure)
{
ConnectionString = connectionString;
AccessType = accessType;
ParametersBinder = new SqlServerParametersBinder(this);
EntityValueConverter = new SqlServerEntityValueConverter(this);
}
/// <inheritdoc />
/// <summary>
/// MySql Server Data access
/// </summary>
/// <param name="connectionString">Connection string</param>
/// <param name="accessType">Data access type</param>
public MySqlDataAccess(string connectionString, DataAccessType accessType = DataAccessType.Query)
{
ConnectionString = connectionString;
AccessType = accessType;
EntityValueConverter = new MySqlEntityValueConverter(this);
ReturnParameterName = null;
}
internal CoreHelper.DBHelper GetDBHelper(DataAccessType accessType = DataAccessType.Default)
{
DBLocation.DataAccessType = accessType;
var helper = SettingConfig.GetDbAccess(DBLocation);
return(helper);
}
internal DBHelper GetDBHelper(DataAccessType accessType = DataAccessType.Default)
{
DBLocation.DataAccessType = accessType;
var helper = DBConfigRegister.GetDBHelper(DBLocation);
return(helper);
}
internal DBHelper GetDBHelper(DataAccessType accessType = DataAccessType.Default)
{
DBLocation.DataAccessType = accessType;
var helper = SettingConfig.GetDBAccessBuild(DBLocation).GetDBHelper();
return(helper);
}
internal WebDynamicTable OnCreateWebDynamicTable(string sql, DataAccessType datype, string connstr)
{
if (CreateWebDynamicTable != null)
{
return(CreateWebDynamicTable(sql, datype, connstr));
}
return(null);
}
private void RestoreState()
{
if (!string.IsNullOrEmpty(Request.Form[htObjType.UniqueID]))
{
objectType = Convert.ToInt32((string)Request.Form[htObjType.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htSort.UniqueID]))
{
sort = (QuickSort)Convert.ToInt32((string)Request.Form[htSort.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htSortDirection.UniqueID]))
{
sortDirection = (QuickSortDirection)Convert.ToInt32((string)Request.Form[htSortDirection.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htAccesType.UniqueID]))
{
accessType = (DataAccessType)Convert.ToInt32((string)Request.Form[htAccesType.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htShowState.UniqueID]))
{
showState = (ObjectShowState)Convert.ToInt32((string)Request.Form[htShowState.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htNumberItems.UniqueID]))
{
numberItems = Convert.ToInt32((string)Request.Form[htNumberItems.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htDateFrom.UniqueID]))
{
dateFrom = Convert.ToDateTime((string)Request.Form[htDateFrom.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htDateTo.UniqueID]))
{
dateTo = Convert.ToDateTime((string)Request.Form[htDateTo.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htCurrentPage.UniqueID]))
{
currentPage = Convert.ToInt32((string)Request.Form[htCurrentPage.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htSearchWord.UniqueID]))
{
searchWord = Request.Form[htSearchWord.UniqueID];
}
if (!string.IsNullOrEmpty(Request.Form[htMyCntOnly.UniqueID]))
{
showMyContentOnly = bool.Parse(Request.Form[htMyCntOnly.UniqueID]);
}
if (!string.IsNullOrEmpty(Request.Form[htCommunityId.UniqueID]))
{
communityIds = Request.Form[htCommunityId.UniqueID];
}
if (!string.IsNullOrEmpty(Request.Form[htTagId.UniqueID]))
{
tagList = Request.Form[htTagId.UniqueID];
}
}
public static DataAccessProperties GetDataAccessProperties(DataAccessType dataAccessType)
{
switch (dataAccessType)
{
case DataAccessType.SQLite:
return(new DataAccessProperties(false, true));
default:
return(new DataAccessProperties(true, true));
}
}
public static bool IsGetAggregateAccess(this DataAccessType accessType)
{
switch (accessType)
{
case DataAccessType.GetClient:
case DataAccessType.GetAgency:
case DataAccessType.GetTransportOperator:
return(true);
default:
return(false);
}
}
public IAssetManagementDataAccess GetDataAccess(DataAccessType dataAccessType)
{
if (dataAccess == null)
{
if (dataAccessType == DataAccessType.MS_SQL)
{
dataAccess = new MsSqlAssetManagementDataAccess();
}
else
{
dataAccess = new InMemAssetManagementDataAccess();
}
}
return(dataAccess);
}
/// <summary>
/// 产生一个全局唯一标识符
/// </summary>
/// <returns>返回全局唯一标识符</returns>
public static Guid NewGuid(DataAccessType pdbtype)
{
switch (pdbtype)
{
case DataAccessType.SqlClient:
return(SqlQueryDAO.NewGuid());
case DataAccessType.OLEDB:
return(OleDbQueryDAO.NewGuid());
case DataAccessType.ODPNet:
return(OdpQueryDAO.NewGuid());
default:
throw(new Exception("此种访问方式没有定义!"));
}
}
/// <summary>
/// 指定数据源连接名称,数据访问资源文件名称
/// </summary>
/// <param name="itemname">指定数据源连接名称</param>
/// <param name="xmlfile">XML数据资源文件</param>
public DataAccRes(string itemname, string xmlfile)
{
DataConnSection conn = DefaultSection;
DataConnInfo conninfo = null;
if (!string.IsNullOrEmpty(itemname))
{
conninfo = conn.DataConnList[itemname];
}
if (null == conninfo)
{
conninfo = DefaultDataConnInfo;
}
this._DbType = conninfo.DAType;
this._sConn = conninfo.Value;
this._sXmlFile = xmlfile;
}
/// <summary>
/// 构造一个数据访问对象实例，参数指明了提供者类型与对应的连接串。
/// </summary>
/// <param name="_type"></param>
/// <param name="connstr"></param>
/// <returns></returns>
public static IDataAccess Produce(DataAccessType _type, string connstr)
{
switch (_type)
{
case DataAccessType.SQL:
return(new SQLDataAccess(connstr));
case DataAccessType.Oracle:
return(new OracleDataAccess(connstr));
case DataAccessType.OleDb:
return(new OleDbDataAccess(connstr));
case DataAccessType.Odbc:
return(new OdbcDataAccess(connstr));
default:
return(null);
}
}
public void SetContext(DataAccessType dataAccessType, string connectionString)
{
this.DataAccessType = dataAccessType;
gbConnectionProperties.Text = String.Format("{0} Connection Properties", dataAccessType);
m_ConnectionStringBuilder = DataAccessFactory.GetConnectionStringBuilder(dataAccessType);
try
{
m_ConnectionStringBuilder.ConnectionString = connectionString;
}
catch (Exception ex)
{
MessageBox.Show(String.Format("Unable to read connection string: {0}", ex.Message), "Connection String Builder", MessageBoxButtons.OK, MessageBoxIcon.Error);
m_ConnectionStringBuilder.ConnectionString = String.Empty;
}
olvConnectionProperties.SetObjects(m_ConnectionStringBuilder.Keys);
olvConnectionProperties.AutoResizeColumn(olvColumnPropertyName.Index, ColumnHeaderAutoResizeStyle.ColumnContent);
zUpdateConnectionString();
}
public static void SetDB(string libId, string provider, string server, string database, string user, string pass)
{
string connstr = "";
DataAccessType type = DataAccessType.OleDb;
string prov = provider.ToUpper();
if (prov.IndexOf("ORAOLEDB.ORACLE") >= 0)
{
connstr = "Provider=" + prov + ";Data Source=" + server + ";User Id=" + user + ";Password="******";";
type = DataAccessType.OleDb;
}
else if (prov.IndexOf("SQLOLEDB") >= 0)
{
connstr = "Provider=" + prov + ";Data Source=" + server + ";Initial Catalog=" + database + ";User Id=" + user + ";Password="******";";
type = DataAccessType.OleDb;
}
else if (prov.IndexOf("[ODBC.NET]") >= 0)
{
prov = prov.Substring(10);
connstr = "DSN=" + prov + ";SRVR=" + server + ";DB=" + database + ";UID=" + user + ";PWD=" + pass + ";";
type = DataAccessType.Odbc;
}
else if (prov.IndexOf("[ORACLE.NET]") >= 0)
{
connstr = "Data Source=" + server + ";User Id=" + user + ";Password="******";";
type = DataAccessType.Oracle;
}
else if (prov.IndexOf("[SQL.NET]") >= 0)
{
connstr = "Data Source=" + server + ";Initial Catalog=" + database + ";User Id=" + user + ";Password="******";";
type = DataAccessType.SQL;
}
else
{
connstr = "";
type = DataAccessType.OleDb;
}
SetDB(libId, connstr, type);
}
protected virtual void GetDataAccessType(INamedPropertyDictionary properties)
{
lock (_globalSettingsLock)
{
if (!properties.ContainsKey(GlymaModelConstants.DataAccessType) || string.IsNullOrEmpty((string)properties[GlymaModelConstants.DataAccessType]))
{
throw new ArgumentException("The property: " + GlymaModelConstants.DataAccessType + ", has not been specified in the model.");
}
string dataAccessTypeString = (string)properties[GlymaModelConstants.DataAccessType];
DataAccessType dataAccessType;
try
{
dataAccessType = ParseEnum <DataAccessType>(dataAccessTypeString);
}
catch (ArgumentException)
{
throw new ArgumentException("The property: " + GlymaModelConstants.DataAccessType + ", has an invalid value. The allowed values are: (" + string.Join(", ", Enum.GetNames(typeof(DataAccessType))) + ").");
}
_dataAccessType = dataAccessType;
}
}
public static DbConnectionStringBuilder GetConnectionStringBuilder(DataAccessType dataAccessType)
{
switch (dataAccessType)
{
case DataAccessType.SQLite:
return(new SQLiteConnectionStringBuilder());
case DataAccessType.SQL:
return(new SqlConnectionStringBuilder());
case DataAccessType.MySql:
return(new MySqlConnectionStringBuilder());
case DataAccessType.OleDb:
return(new OleDbConnectionStringBuilder());
case DataAccessType.ODBC:
return(new OdbcConnectionStringBuilder());
default:
throw new NotSupportedException();
}
}
public static IDataAccess CreateDataAccess(DataAccessType dataAccessType, string connectionString)
{
switch (dataAccessType)
{
case DataAccessType.SQLite:
return(new SQLiteDataAccess(connectionString));
case DataAccessType.SQL:
return(new SQLDataAccess(connectionString));
case DataAccessType.MySql:
return(new MySqlDataAccess(connectionString));
case DataAccessType.OleDb:
return(new OleDbDataAccess(connectionString));
case DataAccessType.ODBC:
return(new ODBCDataAccess(connectionString));
default:
throw new NotSupportedException();
}
}
/// <summary>
/// Create an abstract data request (allways attached to a data type and has a <see cref="DataAccessType" />)
/// </summary>
/// <param name="accessType">read-only or read-write access</param>
/// <param name="fullTypeName"></param>
protected DataRequest(DataAccessType accessType, string fullTypeName)
{
_accessType = accessType;
_fullTypeName = fullTypeName;
}
public GuideInfo(DataAccessType type, string connstr) : base(type, connstr)
{
ResetMetadata();
}
/// <summary>
/// 指定数据库的访问方式,数据访问项目的xml文件,数据库连接字符串
/// </summary>
/// <param name="pdbtype">数据访问类型</param>
/// <param name="xmlfile">XML数据资源文件</param>
/// <param name="strConn">数据库连接字符串</param>
public DataAccRes(DataAccessType pdbtype,string xmlfile,string strconn)
{
this._DbType=pdbtype;
this._sXmlFile=xmlfile;
this._sConn=strconn;
}
public SQLDataBlock(string sqlstr, DataAccessType datype, string connstr) : base(sqlstr, datype, connstr)
{
}
/// <summary>
/// 指定数据源连接名称,数据访问资源文件名称
/// </summary>
/// <param name="itemname">指定数据源连接名称</param>
/// <param name="xmlfile">XML数据资源文件</param>
public DataAccRes(string itemname,string xmlfile)
{
DataConnSection conn = DefaultSection;
DataConnInfo conninfo = null;
if (!string.IsNullOrEmpty(itemname))
conninfo = conn.DataConnList[itemname];
if (null == conninfo)
conninfo = DefaultDataConnInfo;
this._DbType = conninfo.DAType;
this._sConn = conninfo.Value;
this._sXmlFile=xmlfile;
}
public AuditLogEvent(string userName, Guid eventStreamId, DataAccessType dataAccessType, bool accessDenied = false) : this(accessDenied ? DomainEventType.AccessDeniedAuditEvent : DomainEventType.DataAccessedAuditLogEvent, userName, eventStreamId, 0)
{
this.DataAccessType = dataAccessType;
}
/// <summary>
/// 产生一个全局唯一标识符
/// </summary>
/// <returns>返回全局唯一标识符</returns>
public static Guid NewGuid(DataAccessType pdbtype)
{
switch(pdbtype)
{
case DataAccessType.SqlClient:
return SqlQueryDAO.NewGuid();
case DataAccessType.OLEDB:
return OleDbQueryDAO.NewGuid();
case DataAccessType.ODPNet:
return OdpQueryDAO.NewGuid();
default:
throw(new Exception("此种访问方式没有定义!"));
}
}
/// <summary>
/// Create an abstract data request (always attached to a data type and has a <see cref="DataAccessType" />)
/// </summary>
/// <param name="accessType">read-only or read-write access</param>
/// <param name="collectionName"></param>
/// <param name="sessionId">optional session id</param>
protected DataRequest(DataAccessType accessType, string collectionName, Guid sessionId = default)
{
AccessType = accessType;
CollectionName = collectionName;
SessionId = sessionId;
}
//配置数据
public static void SetMetaConn(DataAccessType datype, string metaconn)
{
daType = datype;
metaConn = metaconn;
SetDB("0", metaConn, daType);
}
public static void SetDB(string libId, string connstr, DataAccessType type)
{
libConns[libId] = connstr;
libConnTypes[libId] = type;
}
public ConnectionStringEditor(DataAccessType dataAccessType, string connectionString)
: this()
{
SetContext(dataAccessType, connectionString);
}
public static MySqlConnection GetConnection(DataAccessType accessType = DataAccessType.Data)
{
return(accessType == DataAccessType.Data
? new MySqlConnection(primaryConnectionString)
: new MySqlConnection(loggingConnectionString));
}
/// <inheritdoc />
/// <summary>
/// Sql Server Data access
/// </summary>
/// <param name="connectionString">Connection string</param>
/// <param name="accessType">Data access type</param>
public SQLiteDataAccess(string connectionString, DataAccessType accessType = DataAccessType.Query)
{
ConnectionString = connectionString;
AccessType = DataAccessType.Query;
}
public DAOFactory(DataAccessType type)
{
_type = type;
}
