private void Delete(object sender, EventArgs e) { layer = new ConnectedLayer(); string comm = $"Delete From dbo.Самолёт where [Тип самолёта] = '{dataGridView1.CurrentCell.Value.ToString()}';"; layer.InsertUpdateDelete(comm); }
private void Update(object sender, EventArgs e) { layer = new ConnectedLayer(); string comm = $"Update dbo.Самолёт SET [Тип самолёта] = '{textBox1.Text}' WHERE [Тип самолёта] = '{dataGridView1.CurrentCell.Value.ToString()}';"; layer.InsertUpdateDelete(comm); }
private void Insert(object sender, EventArgs e) { layer = new ConnectedLayer(); string comm = $"Insert into dbo.Самолёт Values ('{textBox1.Text}','{textBox2.Text}')"; layer.InsertUpdateDelete(comm); }
public void Update(int readed) { var oSqlCon = new SqlConnection(connectionString); try { connectedLayer = new ConnectedLayer(); dc = new DataContext(connectionString); var query = from u in dc.GetTable <Airplane>() where u.Id == readed select u; // dc.GetTable<T>().InsertOnSubmit(readed); foreach (Airplane airplane in query) { airplane.Type_Airplane = DataCenter.Str1; airplane.Class_Airplane = DataCenter.Str2; } dc.SubmitChanges(); } catch { logger.Trace( "Connection to" + Environment.NewLine + "Data Source: " + oSqlCon.DataSource + Environment.NewLine + "Database: " + oSqlCon.Database + Environment.NewLine + "State: " + oSqlCon.State + "User: "******"Password:"******"Catalog: " + builder.InitialCatalog + "Server: " + builder.DataSource); } }
private void Init(ConnectedLayer connectedLayer) { ConnectedLayerIndex = connectedLayer.Index; InitInputValueAccessItems(connectedLayer); OutputBuffer = connectedLayer.OutputBuffer; BiasValueIndex = connectedLayer.BiasValueIndex; InnerItarationOutputValueStack = connectedLayer.InnerItarationOutputValueStack; IsOutput = connectedLayer.IsOutput; if ((connectedLayer.StructuralElementFlags & NNStructuralElement.RTLRInformation) != 0) { Method = ForwardComputationMethod.RTLR; UpperNonInputLayerInfos = connectedLayer.UpperNonInputLayerInfos; PBiasBuffers = connectedLayer.PBiasBuffers; PWeightBuffers = connectedLayer.PWeightBuffers; PrevPBiasBuffers = connectedLayer.PrevPBiasBuffers; PrevPWeightBuffers = connectedLayer.PrevPWeightBuffers; NetDerivBuffer = connectedLayer.NetDerivBuffer; GradientBuffers = connectedLayer.GradientBuffers; GradientSumBuffers = connectedLayer.GradientSumBuffers; BiasGradientValueIndex = connectedLayer.BiasGradientValueIndex; BiasGradientSumValueIndex = connectedLayer.BiasGradientSumValueIndex; } else if (connectedLayer.InnerItarationOutputValueStack != null) { Debug.Assert(connectedLayer.InnerItarationInputValueStacks != null); Method = ForwardComputationMethod.BPTT; } else { Method = ForwardComputationMethod.FeedForward; } }
public ActivationLayerForwardCompute(ConnectedLayer connectedLayer) : base(connectedLayer) { Contract.Requires(connectedLayer != null); Contract.Requires(connectedLayer.Layer is ActivationLayer); Function = ((ActivationLayer)connectedLayer.Layer).Function; }
private void Reading(object sender, EventArgs e) { // Чтение таблицы layer = new ConnectedLayer(); string commandsel = "Select [Тип самолёта],[Класс самолёта] from dbo.Самолёт"; dataGridView1.DataSource = layer.Read(commandsel).Tables[0]; }
protected LayerBackwardCompute(LayerForwardCompute forwardCompute, ConnectedLayer connectedLayer) { Contract.Requires(forwardCompute != null); Contract.Requires(connectedLayer != null); Contract.Requires((connectedLayer.StructuralElementFlags & NNStructuralElement.BackwardImplementation) != 0 && (connectedLayer.StructuralElementFlags & NNStructuralElement.GradientInformation) != 0); Init(forwardCompute, connectedLayer); }
public ActivationLayerBackwardCompute(ActivationLayerForwardCompute forwardCompute, ConnectedLayer connectedLayer) : base(forwardCompute, connectedLayer) { Contract.Requires(forwardCompute != null); Contract.Requires(connectedLayer != null); Contract.Requires((connectedLayer.StructuralElementFlags & NNStructuralElement.BackwardImplementation) != 0 && (connectedLayer.StructuralElementFlags & NNStructuralElement.GradientInformation) != 0); Function = forwardCompute.Function; }
private void insertToolStripMenuItem_Click(object sender, EventArgs e) { connlayer = new ConnectedLayer(); dc = new DbDataContext <Airplane>(connlayer.connectionString); Airplane airplane = new Airplane { Type_Airplane = $"{textBox1.Text}", Class_Airplane = $"{textBox2.Text}" }; dc.Insert(ref airplane); }
private void deleteToolStripMenuItem_Click(object sender, EventArgs e) { connlayer = new ConnectedLayer(); dc = new DbDataContext <Airplane>(connlayer.connectionString); Airplane airplane = new Airplane { Id = (int)dataGridView1.CurrentCell.Value }; dc.Delete(airplane.Id); }
internal void InitializeAlgo(BufferAllocator allocator, LearningRule rule, ConnectedLayer[] connectedLayers, CPUNNInitParameters initPars) { Contract.Requires(rule != null); Contract.Requires(connectedLayers != null); Contract.Requires(connectedLayers.Length > 0); Contract.Requires(initPars != null); Rule = rule; ConnectedLayers = connectedLayers; RunParallel = initPars.RunParallel; Ininitalize(allocator); }
private void readToolStripMenuItem_Click(object sender, EventArgs e) { connlayer = new ConnectedLayer(); dc = new DbDataContext <Airplane>(connlayer.connectionString); Airplane airplane = new Airplane(); var query = from u in dc.GetTable <Airplane>() where u.Id > 5 select u; dataGridView1.DataSource = query.ToList(); dc.SubmitChanges(); }
private void Init(LayerForwardCompute forwardCompute, ConnectedLayer connectedLayer) { RunParallel = forwardCompute.RunParallel; ForwardCompute = forwardCompute; InitLowerErrorValueAccessItems(connectedLayer); ErrorBuffer = connectedLayer.ErrorBuffer; GradientBuffers = connectedLayer.GradientBuffers; GradientSumBuffers = connectedLayer.GradientSumBuffers; BiasGradientValueIndex = connectedLayer.BiasGradientValueIndex; BiasGradientSumValueIndex = connectedLayer.BiasGradientSumValueIndex; OutputErrorBuffer = connectedLayer.OutputErrorBuffer; }
private void Button1_Click(object sender, EventArgs e) { string table1 = "Рейс"; string table2 = "Страны"; connlayer = new ConnectedLayer(); string flightscmd = "SELECT id_Рейса,id_Страны,[Дата и время вылета],[Дата и время прибытия],[Город вылета],[Город прибытия] From Рейс"; string countriescmd = "SELECT id_Страны,[Страна вылета],[Страна назначения],[Разные страны],[Входит ли в ООН] From Страны"; connlayer.Read(flightscmd, countriescmd, table1, table2); dataGridView1.DataSource = connlayer.datatable1; dataGridView2.DataSource = connlayer.datatable2; }
private void InitLowerErrorValueAccessItems(ConnectedLayer connectedLayer) { if (connectedLayer.WeightedOutputErrorBuffers == null) return; var items = new LinkedList<ErrorValueAccess>(); for (int outputErrorBufferIndex = 0; outputErrorBufferIndex < connectedLayer.WeightedOutputErrorBuffers.Length; outputErrorBufferIndex++) { var weightedOutputErrorBuffer = connectedLayer.WeightedOutputErrorBuffers[outputErrorBufferIndex]; int wibValueBufferSize = weightedOutputErrorBuffer.ValueBuffer.Size; items.AddLast( new ErrorValueAccess( weightedOutputErrorBuffer.ValueBuffer.Size, weightedOutputErrorBuffer.ValueBuffer.MinValue, weightedOutputErrorBuffer.WeightBuffer.MinValue)); } LowerErrorValueAccessItems = items.ToArray(); }
public WeightRelatedValues(BufferAllocator allocator, ConnectedLayer[] layers) { Contract.Requires(allocator != null); Contract.Requires(layers != null); Contract.Requires(layers.Length > 0); buffers = new IntRange[layers.Length][]; for (int layerIndex = 0; layerIndex < layers.Length; layerIndex++) { var wib = layers[layerIndex].WeightedInputBuffers; buffers[layerIndex] = new IntRange[wib.Length]; for (int buffIndex = 0; buffIndex < wib.Length; buffIndex++) { buffers[layerIndex][buffIndex] = allocator.Alloc(wib[buffIndex].WeightBuffer.Size); } } this.layers = layers; }
protected LayerForwardCompute(ConnectedLayer connectedLayer) : base(connectedLayer) { Contract.Requires(connectedLayer != null); }
protected internal override LayerBackwardCompute CreateBackwardCompute(ConnectedLayer connectedLayer) { return new ActivationLayerBackwardCompute(this, connectedLayer); }
private LayerForwardCompute CreateLayerForwardCompute(ConnectedLayer clayer, CPUNNInitParameters initPars) { LayerForwardCompute result = null; if (clayer.Layer is ActivationLayer) { result = new ActivationLayerForwardCompute(clayer); } if (result == null) throw new InvalidOperationException("Cannot build CPU Neural Network, because '" + clayer.Layer.GetType().FullName + "' layer type is unknown."); result.RunParallel = initPars.RunParallel; return result; }
protected internal virtual LayerBackwardCompute CreateBackwardCompute(ConnectedLayer connectedLayer) { Contract.Requires(connectedLayer != null); throw new InvalidOperationException("Backward computation is not supported."); }
private void InitInputValueAccessItems(ConnectedLayer connectedLayer) { int count = connectedLayer.WeightedInputBuffers.Length; var items = new InputValueAccess[count]; for (int inputBufferIndex = 0; inputBufferIndex < count; inputBufferIndex++) { var weightedInputBuffer = connectedLayer.WeightedInputBuffers[inputBufferIndex]; int wibValueBufferSize = weightedInputBuffer.ValueBuffer.Size; items[inputBufferIndex] = new InputValueAccess( weightedInputBuffer.ValueBuffer.Size, weightedInputBuffer.ValueBuffer.MinValue, weightedInputBuffer.WeightBuffer.MinValue, connectedLayer.InnerItarationInputValueStacks != null ? connectedLayer.InnerItarationInputValueStacks[inputBufferIndex] : null); } InputValueAccessItems = items; }