static CodeCentralExampleInMemoryDataStoreProvider() { string providerKey = Guid.NewGuid().ToString(); fConnectionString = String.Format("XpoProvider={0}", providerKey); fdataSet = new DataSet(); DataStoreBase.RegisterDataStoreProvider(providerKey, CreateProviderFromString); }
public override long GetAutoSolderDataTotalNum(string line) { IOperationBase IOb = new DataStoreBase(); long num = 0; IOb.ReadBaseProfile_totalNum(line, out num); return(num); }
public override long GetAutoSolderDataTimeToTimeNum(string line, DateTime dtStart, DateTime dtEnd) { IOperationBase IOb = new DataStoreBase(); long num = 0; IOb.ReadBaseProfile_TimeToTimeNum(line, dtStart.ToString(), dtEnd.ToString(), out num); return(num); }
public new static void Register() { try { DataStoreBase.RegisterDataStoreProvider(XpoProviderTypeString, new DataStoreCreationFromStringDelegate(CreateProviderFromString)); } catch (ArgumentException e) { Tracing.Tracer.LogError(e); //Tracing.Tracer.LogText("A connection provider with the same name ( {0} ) has already been registered", XpoProviderTypeString); } }
static CodeCentralExampleInMemoryDataStoreProvider() { try { dataSet = new DataSet(); DataStoreBase.RegisterDataStoreProvider(XpoProviderTypeString, new DataStoreCreationFromStringDelegate(CreateProviderFromString)); } catch { throw new Exception(string.Format("Cannot register the {0}", typeof(CodeCentralExampleInMemoryDataStoreProvider).Name)); } }
public override DataTable GetAutoSolderData(string line, DateTime dtStart, DateTime dtEnd) { IOperationBase IOb = new DataStoreBase(); DataTable dt = new DataTable(); string tableName = line; IOb.ReadBaseProfile_dataTable(tableName, dtStart.ToString(), dtEnd.ToString(), out dt); return(dt); }
public static void InitXpo(string connectionString, string login, string password) { RegisterEntities(); InitSecurity(); XpoDefault.RegisterBonusProviders(); DataStoreBase.RegisterDataStoreProvider(WebApiDataStoreClient.XpoProviderTypeString, CreateWebApiDataStoreFromString); ObjectSpaceProvider = new SecuredObjectSpaceProvider(Security, connectionString, null); UpdateDataBase(); LogIn(login, password); XpoDefault.Session = null; }
public override DataTable GetAutoSolderDataUsePage(string line, DateTime dtStart, DateTime dtEnd, string beginIndex, string num) { IOperationBase IOb = new DataStoreBase(); DataTable dt = new DataTable(); string tablename = line; IOb.ReadBaseProfile_dataTableUsePage(line, dtStart.ToString(), dtEnd.ToString(), out dt, beginIndex, num); return(dt); }
public override DateTime GetCurrentdateTime(string line) { DateTime dtime = DateTime.Now; DataTable dt = new DataTable(); IOperationBase IOb = new DataStoreBase(); IOb.ReadCurrentBaseprofileToDataTable(line, out dt); if (dt.Rows.Count > 0) { dtime = Convert.ToDateTime(dt.Rows[0]["TimePoint"]); } return(dtime); }
public static void Initialize() { // initialize if (StoreOnMemoryObjectPersistence.IsPersistentDataExisted("statuses")) { _store = new PersistentDataStore<long, TwitterStatus> (_ => _.Id, Path.Combine(App.DataStorePath, "statuses"), new IdReverseComparer(), manageData: StoreOnMemoryObjectPersistence.GetPersistentData("statuses")); } else { _store = new PersistentDataStore<long, TwitterStatus> (_ => _.Id, Path.Combine(App.DataStorePath, "statuses"), new IdReverseComparer()); } App.OnApplicationFinalize += Shutdown; }
public static void Initialize() { // initialize store if (StoreOnMemoryObjectPersistence.IsPersistentDataExisted("users")) { _store = new PersistentDataStore<long, TwitterUser> (_ => _.Id, Path.Combine(App.DataStorePath, "users"), chunkNum: 16, manageData: StoreOnMemoryObjectPersistence.GetPersistentData("users")); } else { _store = new PersistentDataStore<long, TwitterUser> (_ => _.Id, Path.Combine(App.DataStorePath, "users"), chunkNum: 16); } LoadScreenNameResolverCache(); App.OnApplicationFinalize += Shutdown; }
/// <inheritdoc /> // ReSharper disable once TooManyDependencies protected SteamBotWorker( SteamBotOptions options, DataStoreBase dataStore, Coordinator coordinator, WorkerConfiguration configuration, Logger logger) : base( options, new LoggerWrapper(configuration.Alias ?? configuration.WorkerType + " [" + options.Username + "]", logger) ) { DataStore = dataStore; Coordinator = coordinator; Configuration = configuration; options.Coordinator = coordinator; Options = options; }
public override List <DataTable> GetAutoSolderCurrentData(List <string> lineList) { IOperationBase IOb = new DataStoreBase(); List <DataTable> listTable = new List <DataTable>(); if (lineList == null) { return(null); } foreach (string tableName in lineList) { DataTable dt = new DataTable(); IOb.ReadCurrentBaseprofileToDataTable(tableName, out dt); listTable.Add(dt); } return(listTable); }
public static void Initialize() { // initialize store if (StoreOnMemoryObjectPersistence.IsPersistentDataExisted("users")) { _store = new PersistentDataStore<long, TwitterUser> (_ => _.Id, Path.Combine(App.DataStorePath, "users"), ChunkCount, manageData: StoreOnMemoryObjectPersistence.GetPersistentData("users")); } else { _store = new PersistentDataStore<long, TwitterUser> (_ => _.Id, Path.Combine(App.DataStorePath, "users"), ChunkCount); } _dispatcher = new SingleThreadDispatcher<TwitterUser>(_store.Store); LoadScreenNameResolverCache(); App.ApplicationFinalize += Shutdown; }
/// <summary> /// 现改为查询最近数据中一天内的数据 /// </summary> /// <param name="line"></param> /// <returns></returns> public override DataSet GetAllDeviceDataChart(string line) { //查询最近一条数据的时间,再往前推一天,获取起止时间 DateTime dtEnd = DateTime.Now; DateTime dtStart = dtEnd.AddDays(-1); string dtEndString = dtEnd.ToString(); string dtStartString = dtStart.ToString(); IOperationBase IOb = new DataStoreBase(); DataTable DtCurrent = new DataTable(); IOb.ReadCurrentBaseprofileToDataTable(line, out DtCurrent); if (DtCurrent != null) { dtEndString = DtCurrent.Rows[0]["timepoint"].ToString(); dtStartString = Convert.ToDateTime(dtEndString).AddDays(-1).ToString(); } DataTable DtSolder = new DataTable(); IOb.ReadBaseProfile_dataTableWithChart(line, dtStartString, dtEndString, out DtSolder); if (DtSolder == null) { DtSolder = new DataTable(); } string pisMaxTResult = ExecuteScalar("select starttime from pisreflowdata where id = (select max(id) from pisreflowdata where proline='" + line + "')").ToString(); if (pisMaxTResult != null) { dtEndString = pisMaxTResult; dtStartString = Convert.ToDateTime(pisMaxTResult).AddDays(-1).ToString(); } DataTable DtPis = ExecuteDataTable("select UNIX_TIMESTAMP(starttime + INTERVAL 8 HOUR) * 1000 AS x, Convert(cpk,decimal(9,3)) AS y from pisreflowdata where proline = @line and starttime >= @begintime and starttime <= @endtime", CommandType.Text, new MySqlParameter[] { new MySqlParameter(@"line", line), new MySqlParameter(@"begintime", dtStartString), new MySqlParameter(@"endtime", dtEndString) }); DataSet Ds = new DataSet(); DtSolder.TableName = "soldertable"; DtPis.TableName = "pistable"; Ds.Tables.AddRange(new DataTable[] { DtSolder, DtPis }); return(Ds); }
public override DataSet GetAllDeviceData(string line) { //因为两个数据库查询方法中的连接分开写的,分两次查出 DataTable DtSolder = new DataTable(); IOperationBase IOb = new DataStoreBase(); IOb.ReadCurrentBaseprofileToDataTable(line, out DtSolder); if (DtSolder == null) { DtSolder = new DataTable(); } //DbDataReader Dr = ExecuteReader("select * from pisreflowdata where id = (select max(id) where pisreflowdata)"); //if (Dr.Read()) //{ //} //Dr.Close(); //与pis页面类似 采用存储过程查询 // DataTable DtPis = ExecuteDataTable("select * from pisreflowdata where id = (select max(id) from pisreflowdata where proline = '" + line + "')"); DataTable DtPis = GetPISData(-1, new DateTime(), new DateTime()); //取出当前所需结果 DataRow[] rows = DtPis.Select("proline = '" + line + "'"); DataTable DtPisResult = new DataTable(); DtPisResult = DtPis.Clone(); foreach (DataRow row in rows) { DtPisResult.ImportRow(row); } DataSet Ds = new DataSet(); DtSolder.TableName = "soldertable"; DtPisResult.TableName = "pistable"; Ds.Tables.AddRange(new DataTable[] { DtSolder, DtPisResult }); return(Ds); }
private void ExcuteFun() { ILDO ini = new INI(); ini.LDOPath = "D:\\AutosolderNet\\AutoSolderNetCon.ini"; List <NetConfig> listNet = ini.ReadFun(); if (listNet == null) { // PISTrace.WriteStrLine("listNet is null"); LogClass.WriteLogFile("class-AutosolderServiceFun;Fun-ExcuteFun; :listNet isNull 28行处"); return; } Executelist = new List <ExecuteQueue>(); for (int i = 0; i < listNet.Count; i++) { AutoSolderService.ExecuteQueue queue = new AutoSolderService.ExecuteQueue(); int temp; try { temp = int.Parse(listNet[i].Port); } catch (Exception ex) { temp = 1234; LogClass.WriteLogFile("Class-AutosolderServic;Fun-ExcuteFun; : 44行" + ex.Message); } queue.setupConection(listNet[i].Ip, temp); queue.ExecuteAddBaseProfile(listNet[i].Line);//10s Executelist.Add(queue); //事件 IOperationBase Ids = new DataStoreBase(); Ids.SettingEventScheduler("60", listNet[i].Line); } }
public static void Register() { //var store = CreateProviderFromString; DataStoreBase.RegisterDataStoreProvider(XpoProviderTypeString, CreateProviderFromString); }
public static void Initialize() { // initialize if (StoreOnMemoryObjectPersistence.IsPersistentDataExisted("statuses")) { _store = new PersistentDataStore<long, TwitterStatus> (_ => _.Id, Path.Combine(App.DataStorePath, "statuses"), ChunkCount, new IdReverseComparer(), StoreOnMemoryObjectPersistence.GetPersistentData("statuses")); } else { _store = new PersistentDataStore<long, TwitterStatus> (_ => _.Id, Path.Combine(App.DataStorePath, "statuses"), ChunkCount, new IdReverseComparer()); } _dispatcher = new SingleThreadDispatcher<TwitterStatus>(_store.Store); App.ApplicationFinalize += Shutdown; }
public static void Register() { DataStoreBase.RegisterDataStoreProvider(PostgreSqlConnectionProvider.XpoProviderTypeString, new DevExpress.Xpo.DB.Helpers.DataStoreCreationFromStringDelegate(CreateProviderFromString)); }
/// <summary> /// 保存到数据库 /// </summary> /// <param name="baseprofile"></param> private void SaveData(BaseProfile baseprofile, string tableName) { DataStoreBase dataStoreBase = new DataStoreBase(); dataStoreBase.AddBaseProfile(baseprofile, tableName); }
public new static void Register() { //HACK review this link https://supportcenter.devexpress.com/ticket/details/BC4261/data-access-library-connection-provider-registration-has-been-changed DataStoreBase.RegisterDataStoreProvider(XpoProviderTypeString, CreateProviderFromString); DataStoreBase.RegisterDataStoreProvider(XpoProviderTypeString, CreateProviderFromConnection); }
static void ConfigureXpoForDevEnvironment() { XpoDefault.RegisterBonusProviders(); DataStoreBase.RegisterDataStoreProvider(WebApiDataStoreClient.XpoProviderTypeString, CreateWebApiDataStoreFromString); }
/// <summary> /// 保存到数据库 /// </summary> /// <param name="baseprofile"></param> private void SaveData(BaseProfile baseprofile) { DataStoreBase dataStoreBase = new DataStoreBase(); dataStoreBase.AddBaseProfile(baseprofile, "baseprofile"); }
public static void Initialize() { // initialize if (StoreOnMemoryObjectPersistence.IsPersistentDataExisted("statuses")) { try { store = new PersistentDataStore<long, TwitterStatus> (_ => _.Id, Path.Combine(App.DataStorePath, "statuses"), tocniops: StoreOnMemoryObjectPersistence.GetPersistentData("statuses")); } catch (Exception ex) { InformationHub.PublishInformation(new Information(InformationKind.Warning, "STATUSSTORE_INIT_FAILED", "ステータス データベースが破損しています。", "読み込み時にエラーが発生したため、データベースを初期化しました。" + Environment.NewLine + "送出された例外: " + ex.ToString())); } } if (store == null) { store = new PersistentDataStore<long, TwitterStatus> (_ => _.Id, Path.Combine(App.DataStorePath, "statuses")); } App.OnApplicationFinalize += Shutdown; }