protected void Session_Start(object sender, EventArgs e)
{
// Code that runs on application startup
//string conn = DevExpress.Xpo.DB.MSSqlConnectionProvider.GetConnectionString(@".\SqlExpress", "sa", "123", "DBSymaiMall");
var configConStr = ConfigurationManager.ConnectionStrings["DreamMallConnectString"].ConnectionString;
var userId = Utils.GetItemValueFromConnectionString(configConStr, "User ID");
var password = Utils.GetItemValueFromConnectionString(configConStr, "Password");
var server = Utils.GetItemValueFromConnectionString(configConStr, "Data Source");
var catalog = Utils.GetItemValueFromConnectionString(configConStr, "Initial Catalog");
string conn = DevExpress.Xpo.DB.MSSqlConnectionProvider.GetConnectionString(
server,
userId,
password,
catalog
);
DevExpress.Xpo.Metadata.XPDictionary dict = new DevExpress.Xpo.Metadata.ReflectionDictionary();
// Initialize the XPO dictionary.
dict.GetDataStoreSchema(new Type[] { typeof(zhongcj.cc.Models.BusinessObjects.DreamWeb.Article) });
dict.GetDataStoreSchema(new Type[] { typeof(zhongcj.cc.Models.BusinessObjects.DreamMallMember.Member) });
dict.GetDataStoreSchema(typeof(zhongcj.cc.Models.BusinessObjects.DreamMall.Product).Assembly);
DevExpress.Xpo.XpoDefault.Session = null;
DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault.GetConnectionProvider(conn, DevExpress.Xpo.DB.AutoCreateOption.SchemaOnly);
DevExpress.Xpo.XpoDefault.DataLayer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store);
}
static DevExpress.Xpo.ThreadSafeDataLayer CreateThreadSafeDataLayer(SqlConnection conn)
{
DevExpress.Xpo.Metadata.XPDictionary dict = new DevExpress.Xpo.Metadata.ReflectionDictionary();
DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault.GetConnectionProvider(conn, DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists);
//注意：如果项目中的XPO对象不是集中在一个类库而是分散在多个类库的话，我们需要在这里从每一个
// 类库中都任意抓取一个对象作为参数传递给 GetDataStoreSchema 方法
dict.GetDataStoreSchema(
typeof(Hwagain.Components.BaseData).Assembly,
typeof(YiKang.RBACS.AccessService).Assembly
);
return(new DevExpress.Xpo.ThreadSafeDataLayer(dict, store));
}
public static void Init()
{
var connectionString = @"XpoProvider=MSAccess;Provider=Microsoft.Jet.OLEDB.4.0;Mode=Share Deny None;data source=C:\DataBase\audience.mdb;Jet OLEDB:Database Password=diesirae";
DevExpress.Xpo.Metadata.XPDictionary dict =
new DevExpress.Xpo.Metadata.ReflectionDictionary();
// Initialize the XPO dictionary.
dict.GetDataStoreSchema(typeof(AudienceJournal), typeof(AudienceRadio), typeof(AudienceTV), typeof(Individu), typeof(Signalitique), typeof(Vague), typeof(XpoSupportPresse), typeof(XpoSupportRadio), typeof(XpoSupportTV));
DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault.GetConnectionProvider(connectionString,
DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
DevExpress.Xpo.XpoDefault.DataLayer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store);
DevExpress.Xpo.XpoDefault.Session = null;
}
public static void Init()
{
AppSettingsReader config = new AppSettingsReader();
var connectionString = ((string)config.GetValue("connect", typeof(string)));
DevExpress.Xpo.Metadata.XPDictionary dict =
new DevExpress.Xpo.Metadata.ReflectionDictionary();
// Initialize the XPO dictionary.
dict.GetDataStoreSchema(typeof(XpoStock), typeof(XpoProductLine), typeof(XpoProduct), typeof(XpoSector), typeof(XpoClient), typeof(XpoOrder), typeof(XpoOrderLine), typeof(XpoWilaya), typeof(XpoCommune));
DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault.GetConnectionProvider(connectionString,
DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
DevExpress.Xpo.XpoDefault.DataLayer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store);
DevExpress.Xpo.XpoDefault.Session = null;
}
private void btnConvert_Click(object sender, RoutedEventArgs e)
{
try
{
tbOracleConnectionStringText = TbOracleConnectionString.Text;
TbCmsConnectionStringText = TbCmsConnectionString.Text;
string conn = TbCmsConnectionStringText;
//get thread safe klayer
if (conn != null)
{
// Code that runs on application startup
DevExpress.Xpo.Metadata.XPDictionary dict =
new DevExpress.Xpo.Metadata.ReflectionDictionary();
dict.GetDataStoreSchema(typeof(NewNetServicesModule).Assembly);
DevExpress.Xpo.DB.IDataStore store =
DevExpress.Xpo.XpoDefault
.GetConnectionProvider(conn,
DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists);
store = new DevExpress.Xpo.DB.DataCacheNode(new DevExpress.Xpo.DB.DataCacheRoot(store));
var layer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store);
Tsdl = layer;
}
if (Tsdl == null)
{
//DevExpress.XtraEditors.XtraMessageBox.Show($"Couldn't create dl");
return;
}
// MAINWorker.Connect(tsdl);
}
catch (Exception ex)
{
NewNetServices.Module.Core.StaticHelperMethods.WriteOut($"{ex}");
}
BtnConvert.IsEnabled = false;
Task.Factory
.StartNew(() =>
{
Task.WhenAll(BeginWork());
Dispatcher.Invoke(() => BtnConvert.IsEnabled = true);
});
}
/// <summary>
/// Registers the IdentityServer stores with the container
/// If the <paramref name="connectionString"> is passed , a <see name="IDocumentStore"> and <see name="IDocumentSession"> are registered
/// </summary>
/// <param name="builder"></param>
/// <param name="connectionString">A Xpo connectionstring</param>
/// <returns></returns>
public static IIdentityServerBuilder AddXpo(
this IIdentityServerBuilder builder, string connectionString = null, params Assembly[] xpoAssemblys)
{
builder.Services.AddTransient <IClientStore, ClientStore>();
builder.Services.AddTransient <IResourceStore, ResourceStore>();
builder.Services.AddTransient <ICorsPolicyService, CorsPolicyService>();
if (!string.IsNullOrEmpty(connectionString))
{
builder.Services
.AddXpoDefaultUnitOfWork(true, options => options
.UseConnectionString(connectionString)
.UseThreadSafeDataLayer(true)
//.UseConnectionPool(false) // Remove this line if you use a network database like SQL Server, Oracle, PostgreSql etc.
.UseAutoCreationOption(DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema) // Remove this line if the database already exists
//.UseEntityTypes(typeof(Customer), typeof(Order)) // Pass all of your persistent object types to this method.
.UseCustomDictionaryFactory(() =>
{
DevExpress.Xpo.Metadata.XPDictionary dictionary = new ReflectionDictionary();
//DevExpress.Xpo.Metadata.ReflectionClassInfo.SuppressSuspiciousMemberInheritanceCheck = true;
var assemblys = new List <Assembly>
{
typeof(ApiResource).Assembly
};
if (xpoAssemblys != null)
{
assemblys.AddRange(xpoAssemblys);
}
dictionary.GetDataStoreSchema(assemblys.ToArray());
//DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault.GetConnectionProvider(conn, DevExpress.Xpo.DB.AutoCreateOption.SchemaOnly);
DevExpress.Xpo.DB.IDataStore store = DevExpress.Xpo.XpoDefault.GetConnectionProvider(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
DevExpress.Xpo.XpoDefault.DataLayer = new DevExpress.Xpo.ThreadSafeDataLayer(dictionary, store);
DevExpress.Xpo.XpoDefault.Session = new DevExpress.Xpo.Session(DevExpress.Xpo.XpoDefault.DataLayer);
return(dictionary);
})
);
}
return(builder);
}
void CreateDataLayer()
{
TbCmsConnectionStringText = TbCmsConnectionString.Text;
string conn = TbCmsConnectionStringText;
//get thread safe klayer
if (conn != null)
{
// Code that runs on application startup
DevExpress.Xpo.Metadata.XPDictionary dict =
new DevExpress.Xpo.Metadata.ReflectionDictionary();
dict.GetDataStoreSchema(typeof(NewNetServicesModule).Assembly);
DevExpress.Xpo.DB.IDataStore store =
DevExpress.Xpo.XpoDefault
.GetConnectionProvider(conn,
DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists);
store = new DevExpress.Xpo.DB.DataCacheNode(new DevExpress.Xpo.DB.DataCacheRoot(store));
var layer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store);
Tsdl = layer;
}
}
private void btnConvert_Click(object sender, RoutedEventArgs e)
{
try
{
dbName = TbDb.Text;
if (!wcTable.Contains(dbName))
{
wcTable = dbName + "." + wcTable;
oltTable = dbName + "." + oltTable;
oltPortsTable = dbName + "." + oltPortsTable;
splitterTable = dbName + "." + splitterTable;
splitterPortsTable = dbName + "." + splitterPortsTable;
oltSplitterDpTable = dbName + "." + oltSplitterDpTable;
outdPairsTable = dbName + "." + outdPairsTable;
assignmentPrimlocTable = dbName + "." + assignmentPrimlocTable;
assignmentDPairsTable = dbName + "." + assignmentDPairsTable;
assignmentSplitPortTable = dbName + "." + assignmentSplitPortTable;
assignmentOltTable = dbName + "." + assignmentOltTable;
addressTable = dbName + "." + addressTable;
cablesWithOUTSpansTable = dbName + "." + cablesWithOUTSpansTable;
conTable = dbName + ".Conduits";
CABLEPAIR_Table = dbName + ".CablePairs";
dgroupTable = dbName + ".DesignationGroups";
cpdpTable = dbName + ".CABLEPAIRDESIGNATIONPAIR";
dpTable = dbName + ".DesignationPairs";
junkTable = dbName + ".JUNCTIONS";
subTable = dbName + ".Subscribers";
}
tbOracleConnectionStringText = TbOracleConnectionString.Text;
TbCmsConnectionStringText = TbCmsConnectionString.Text;
string conn = TbCmsConnectionStringText;
//get thread safe klayer
if (conn != null)
{
// Code that runs on application startup
DevExpress.Xpo.Metadata.XPDictionary dict =
new DevExpress.Xpo.Metadata.ReflectionDictionary();
dict.GetDataStoreSchema(typeof(NewNetServicesModule).Assembly);
DevExpress.Xpo.DB.IDataStore store =
DevExpress.Xpo.XpoDefault
.GetConnectionProvider(conn,
DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists);
store = new DevExpress.Xpo.DB.DataCacheNode(new DevExpress.Xpo.DB.DataCacheRoot(store));
var layer = new DevExpress.Xpo.ThreadSafeDataLayer(dict, store);
Tsdl = layer;
}
if (Tsdl == null)
{
//DevExpress.XtraEditors.XtraMessageBox.Show($"Couldn't create dl");
return;
}
// MAINWorker.Connect(tsdl);
}
catch (Exception ex)
{
NewNetServices.Module.Core.StaticHelperMethods.WriteOut($"{ex}");
}
using (UnitOfWork uow = new UnitOfWork(Tsdl))
{
//using (UnitOfWork uow = MAINWorker.OptimisticLockingReadBehavior = LockingOption)
// uow = MAINWorker. LockingOption STATE = (DefaultFields
this.state = DefaultFields.GetBusinessObjectDefault <State>(uow,
new List <Tuple <string, object> >()
{
new Tuple <string, object>("ShortName", State),
new Tuple <string, object>("LongName", (State == "IA" ? "Iowa" : State == "ND"? "North Dakota" :""))
})
.Oid;
}
BtnConvert.IsEnabled = false;
Task.Factory
.StartNew(() =>
{
Task.WhenAll(BeginWork());
Dispatcher.Invoke(() => BtnConvert.IsEnabled = true);
});
//if (ToggleStep.IsChecked.HasValue && ToggleStep.IsChecked.Value)
//{
// Dispatcher.Invoke(() => ProgressBar.Maximum = 0);
// WorkBeginning?.Invoke("GID GUID Matching..", null);
// HandleStep2<Location>();
// HandleStep2<Cable>();
//}
//else
//{
}
public CustomCreateDataLayerEventArgs(XPDictionary dictionary, DevExpress.Xpo.DB.IDataStore dataStore)
{
Dictionary = dictionary;
DataStore = dataStore;
}
