public void DeleteTopologyAndWeightsMatrix(string NeuroNetName, LoadingWindow loadingWindow)
{
connector.ConnectToDB();
SQLiteCommand cmd = new SQLiteCommand(connector.connection);
cmd.CommandText = "SELECT ID FROM NeuroNet WHERE NAME = '" + NeuroNetName + "'";
int NNID = Convert.ToInt32(cmd.ExecuteScalar());
cmd.CommandText = "SELECT ID FROM NetTopology WHERE NeuroNetID = '" + Convert.ToString(NNID) + "'";
List<int> ls = new List<int>();
double progress = 0.0;
try
{
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ls.Add(Convert.ToInt32(reader[0]));
}
reader.Close();
foreach(int item in ls)
{
cmd.CommandText = "DELETE FROM WeightsMatrix WHERE NetTopologyID = '" + Convert.ToString(item) + "'";
cmd.ExecuteNonQuery();
cmd.CommandText = "DELETE FROM NetTopology WHERE ID = '" + Convert.ToString(item) + "'";
cmd.ExecuteNonQuery();
progress += 100.0 / Convert.ToDouble(ls.Count);
Action f = new Action(() => loadingWindow.LoadingBar.Value = Convert.ToInt32(progress));
if (loadingWindow.LoadingBar.InvokeRequired)
{
loadingWindow.LoadingBar.Invoke(f);
}
else
{
f();
}
}
}
catch (SQLiteException ex)
{
MessageBox.Show(ex.Message);
}
connector.DisconnectFromDB();
loadingWindow.Invoke(new Action(() => loadingWindow.Close()));
}
private void LoadNeuroNetIntoDB()
{
if (mode == form_destination.Creating)
{
try
{
string NameNN = tbNameNeuroNet.Text;
if (NameNN == "")
throw new Exception("Имя НС не может быть пустым");
if (dbHandler.IsNeuroNetExist(NameNN))
throw new Exception("Такое имя НС уже используется");
if (cbTopology.SelectedItem == null)
throw new Exception("Необходимо выбрать топологию");
string TopologyTypeName = LibraryOfTopologies.GetTopologyTypeName(cbTopology.SelectedItem.ToString());
if (cbTask.SelectedItem == null)
throw new Exception("Необходимо выбрать задачу");
string TaskName = cbTask.SelectedItem.ToString();
int CountNeurons = Convert.ToInt32(numNeuronsNumber.Value);
int CountLayers = Convert.ToInt32(numLayersNumber.Value);
string typeAF = LibraryOfActivateFunctions.GetActivateFunctionTypeName(cbActivateFunction.SelectedItem.ToString());
if (cbActivateFunction.SelectedIndex < 0)
throw new Exception("Необходимо выбрать активационную функцию");
string NeuronsInLayers = "";
int[] NeuInL = new int[CountLayers];
string ParametersAF = "";
int sumNeurons = 0;
for (int i = 0; i < CountLayers; i++)
{
int neurs = Convert.ToInt32(dgwEditNeuronsInLayers.Rows[i].Cells[1].Value);
if (neurs <= 0)
throw new Exception("В каждом слое должен быть по крайней мере 1 нейрон");
sumNeurons += neurs;
NeuInL[i] = neurs;
NeuronsInLayers += Convert.ToString(dgwEditNeuronsInLayers.Rows[i].Cells[1].Value);
if (i != CountLayers - 1)
NeuronsInLayers += " ";
}
if (sumNeurons != CountNeurons)
throw new Exception("Сумма нейронов по слоям должна равняться общему числу нейронов");
for (int i = 0; i < LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName); i++)
{
double par = Convert.ToDouble(dgwEditParametersAF.Rows[i].Cells[1].Value);
ParametersAF += Convert.ToString(par);
if (i != LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName) - 1)
ParametersAF += " ";
}
dbHandler.InsertNeuroNet(NameNN, TopologyTypeName, TaskName, CountNeurons, CountLayers, NeuronsInLayers, typeAF, ParametersAF);
LoadingWindow loadingWindow = new LoadingWindow();
loadingWindow.MakeLoading(
() => dbHandler.InsertTopologyOfNeuroNet(NameNN, TopologyTypeName, CountNeurons, CountLayers, NeuInL, loadingWindow),
"Запись нейронной сети в БД");
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (mode == form_destination.Editing)
{
try
{
string NameNN = tbNameNeuroNet.Text;
if (NameNN == "")
throw new Exception("Имя НС не может быть пустым");
if (cbTopology.SelectedItem == null)
throw new Exception("Необходимо выбрать топологию");
string TopologyTypeName = LibraryOfTopologies.GetTopologyTypeName(cbTopology.SelectedItem.ToString());
string TaskName = cbTask.SelectedItem.ToString();
int CountNeurons = Convert.ToInt32(numNeuronsNumber.Value);
int CountLayers = Convert.ToInt32(numLayersNumber.Value);
string typeAF = LibraryOfActivateFunctions.GetActivateFunctionTypeName(cbActivateFunction.SelectedItem.ToString());
string NeuronsInLayers = "";
int[] NeuInL = new int[CountLayers];
double[] ParAF = new double[LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName)];
string ParametersAF = "";
int sumNeurons = 0;
for (int i = 0; i < CountLayers; i++)
{
int neurs = Convert.ToInt32(dgwEditNeuronsInLayers.Rows[i].Cells[1].Value);
if (neurs <= 0)
throw new Exception("В каждом слое должен быть по крайней мере 1 нейрон");
sumNeurons += neurs;
NeuInL[i] = neurs;
NeuronsInLayers += Convert.ToString(dgwEditNeuronsInLayers.Rows[i].Cells[1].Value);
if (i != CountLayers - 1)
NeuronsInLayers += " ";
}
if (sumNeurons != CountNeurons)
throw new Exception("Сумма нейронов по слоям должна равняться общему числу нейронов");
for (int i = 0; i < LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName); i++)
{
ParAF[i] = Convert.ToDouble(dgwEditParametersAF.Rows[i].Cells[1].Value);
ParametersAF += Convert.ToString(dgwEditParametersAF.Rows[i].Cells[1].Value);
if (i != LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName) - 1)
ParametersAF += " ";
}
bool isContining = true;
bool isNeuronsInLayersSame = false;
bool isParametersAFSame = false;
bool isNeedToDelete = false;
if (CountLayers == definition_of_editing_net.LayerCount)
{
int k = 0;
for (int i = 0; i < CountLayers; i++)
{
if (NeuInL[i] == definition_of_editing_net.NeuronsInLayer[i])
{
k++;
}
}
if (k == CountLayers)
isNeuronsInLayersSame = true;
}
if (String.Compare(cbActivateFunction.SelectedItem.ToString(), definition_of_editing_net.ActivateFunction) == 0)
{
int k = 0;
for (int i = 0; i < definition_of_editing_net.AFParameters.Length; i++)
{
if (ParAF[i] == definition_of_editing_net.AFParameters[i])
{
k++;
}
}
if (k == definition_of_editing_net.AFParameters.Length)
isParametersAFSame = true;
}
if (String.Compare(TaskName, definition_of_editing_net.TaskName) != 0 ||
String.Compare(TopologyTypeName, definition_of_editing_net.TopologyName) != 0 ||
CountNeurons != definition_of_editing_net.NeuronsCount ||
isNeuronsInLayersSame == false || isParametersAFSame == false)
{
DialogResult res = MessageBox.Show("Данные изменения влекут удаление обученных весов сети. " +
"Нейронную сеть необходимо будет обучать заново.", "Предупреждение потери данных", MessageBoxButtons.OKCancel);
isNeedToDelete = true;
if (res == DialogResult.Cancel)
isContining = false;
}
if (isContining == true)
{
if (isNeedToDelete == true)
{
LoadingWindow loadingWindow = new LoadingWindow();
if (isNeuronsInLayersSame && (String.Compare(cbTopology.SelectedItem.ToString(), definition_of_editing_net.TopologyName) == 0))
{
loadingWindow.MakeLoading(
()=>dbHandler.DeleteWeightsMatrix(definition_of_editing_net.Name, loadingWindow),
"Удаление устаревших весовых коэффициентов");
}
else
{
loadingWindow.MakeLoading(
() => dbHandler.DeleteTopologyAndWeightsMatrix(definition_of_editing_net.Name, loadingWindow),
"Удаление старой топологии нейронной сети");
loadingWindow.MakeLoading(
() => dbHandler.InsertTopologyOfNeuroNet(definition_of_editing_net.Name, TopologyTypeName, CountNeurons, CountLayers, NeuInL, loadingWindow),
"Запись измененной нейронной сети в БД");
}
}
dbHandler.UpdateNeuroNet(NameNN, definition_of_editing_net.Name, TopologyTypeName, TaskName, CountNeurons, CountLayers,
NeuronsInLayers, typeAF, ParametersAF);
Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnDeleteNeuroNet_Click(object sender, EventArgs e)
{
DialogResult res = MessageBox.Show("После удаления все данные об нейронной сети, включая обученные веса, будут потеряны. Хотите продолжить?", "Предупреждение потери данных", MessageBoxButtons.OKCancel);
if (res == DialogResult.OK)
{
LoadingWindow loadingWindow = new LoadingWindow();
loadingWindow.MakeLoading(
() => dbHandler.DeleteTopologyAndWeightsMatrix(dgwNeuroNets.SelectedRows[0].Cells[0].Value.ToString(), loadingWindow),
"Удаление нейронной сети из БД");
dbHandler.DeleteNeuroNet(dgwNeuroNets.SelectedRows[0].Cells[0].Value.ToString());
LoadInformationForUsingNeuroNets();
FillNeuroNetChangingTable();
btnChangeNeuroNet.Enabled = false;
btnDeleteNeuroNet.Enabled = false;
dgwNeuronsInLayers.Rows.Clear();
dgwParamsAF.Rows.Clear();
}
}
public void InsertTopologyOfNeuroNet(string NameNN, string TopologyTypeName,
int CountNeurons, int CountLayers, int[] NeuronsInLayers, LoadingWindow loadingWindow)
{
connector.ConnectToDB();
SQLiteCommand cmd = new SQLiteCommand(connector.connection);
cmd.CommandText = "SELECT ID FROM NeuroNet WHERE Name = '" + NameNN + "'";
int NetID = Convert.ToInt32(cmd.ExecuteScalar());
Topology topology = LibraryOfTopologies.GetTopology(TopologyTypeName,
LibraryOfTopologies.GetterParameter.TypeOfTopologyName);
bool[,] connections = topology.CreateNet(CountNeurons, CountLayers, NeuronsInLayers);
double progressValue = 0.0;
for (int i = 0; i < CountNeurons; i++)
{
for (int j = 0; j < CountNeurons; j++)
{
if (connections[i, j] == true)
{
cmd.CommandText = "INSERT INTO NetTopology (IndexInputNeuron, " +
"IndexOutputNeuron, NeuroNetID) values('" + Convert.ToString(j) +
"','" + Convert.ToString(i) + "','" + Convert.ToString(NetID) + "')";
cmd.ExecuteNonQuery();
}
progressValue += 100.0 / Convert.ToDouble(CountNeurons * CountNeurons);
Action f = new Action(() => loadingWindow.LoadingBar.Value = Convert.ToInt32(progressValue));
if (loadingWindow.LoadingBar.InvokeRequired)
{
loadingWindow.LoadingBar.Invoke(f);
}
else
{
f();
}
}
}
connector.DisconnectFromDB();
loadingWindow.Invoke(new Action(() => loadingWindow.Close()));
}
private void LoadNeuroNetIntoDB()
{
if (mode == form_destination.Creating)
{
try
{
string NameNN = tbNameNeuroNet.Text;
if (NameNN == "")
{
throw new Exception("Имя НС не может быть пустым");
}
if (dbHandler.IsNeuroNetExist(NameNN))
{
throw new Exception("Такое имя НС уже используется");
}
if (cbTopology.SelectedItem == null)
{
throw new Exception("Необходимо выбрать топологию");
}
string TopologyTypeName = LibraryOfTopologies.GetTopologyTypeName(cbTopology.SelectedItem.ToString());
if (cbTask.SelectedItem == null)
{
throw new Exception("Необходимо выбрать задачу");
}
string TaskName = cbTask.SelectedItem.ToString();
int CountNeurons = Convert.ToInt32(numNeuronsNumber.Value);
int CountLayers = Convert.ToInt32(numLayersNumber.Value);
string typeAF = LibraryOfActivateFunctions.GetActivateFunctionTypeName(cbActivateFunction.SelectedItem.ToString());
if (cbActivateFunction.SelectedIndex < 0)
{
throw new Exception("Необходимо выбрать активационную функцию");
}
string NeuronsInLayers = "";
int[] NeuInL = new int[CountLayers];
string ParametersAF = "";
int sumNeurons = 0;
for (int i = 0; i < CountLayers; i++)
{
int neurs = Convert.ToInt32(dgwEditNeuronsInLayers.Rows[i].Cells[1].Value);
if (neurs <= 0)
{
throw new Exception("В каждом слое должен быть по крайней мере 1 нейрон");
}
sumNeurons += neurs;
NeuInL[i] = neurs;
NeuronsInLayers += Convert.ToString(dgwEditNeuronsInLayers.Rows[i].Cells[1].Value);
if (i != CountLayers - 1)
{
NeuronsInLayers += " ";
}
}
if (sumNeurons != CountNeurons)
{
throw new Exception("Сумма нейронов по слоям должна равняться общему числу нейронов");
}
for (int i = 0; i < LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName); i++)
{
double par = Convert.ToDouble(dgwEditParametersAF.Rows[i].Cells[1].Value);
ParametersAF += Convert.ToString(par);
if (i != LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName) - 1)
{
ParametersAF += " ";
}
}
dbHandler.InsertNeuroNet(NameNN, TopologyTypeName, TaskName, CountNeurons, CountLayers, NeuronsInLayers, typeAF, ParametersAF);
LoadingWindow loadingWindow = new LoadingWindow();
loadingWindow.MakeLoading(
() => dbHandler.InsertTopologyOfNeuroNet(NameNN, TopologyTypeName, CountNeurons, CountLayers, NeuInL, loadingWindow),
"Запись нейронной сети в БД");
Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (mode == form_destination.Editing)
{
try
{
string NameNN = tbNameNeuroNet.Text;
if (NameNN == "")
{
throw new Exception("Имя НС не может быть пустым");
}
if (cbTopology.SelectedItem == null)
{
throw new Exception("Необходимо выбрать топологию");
}
string TopologyTypeName = LibraryOfTopologies.GetTopologyTypeName(cbTopology.SelectedItem.ToString());
string TaskName = cbTask.SelectedItem.ToString();
int CountNeurons = Convert.ToInt32(numNeuronsNumber.Value);
int CountLayers = Convert.ToInt32(numLayersNumber.Value);
string typeAF = LibraryOfActivateFunctions.GetActivateFunctionTypeName(cbActivateFunction.SelectedItem.ToString());
string NeuronsInLayers = "";
int[] NeuInL = new int[CountLayers];
double[] ParAF = new double[LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName)];
string ParametersAF = "";
int sumNeurons = 0;
for (int i = 0; i < CountLayers; i++)
{
int neurs = Convert.ToInt32(dgwEditNeuronsInLayers.Rows[i].Cells[1].Value);
if (neurs <= 0)
{
throw new Exception("В каждом слое должен быть по крайней мере 1 нейрон");
}
sumNeurons += neurs;
NeuInL[i] = neurs;
NeuronsInLayers += Convert.ToString(dgwEditNeuronsInLayers.Rows[i].Cells[1].Value);
if (i != CountLayers - 1)
{
NeuronsInLayers += " ";
}
}
if (sumNeurons != CountNeurons)
{
throw new Exception("Сумма нейронов по слоям должна равняться общему числу нейронов");
}
for (int i = 0; i < LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName); i++)
{
ParAF[i] = Convert.ToDouble(dgwEditParametersAF.Rows[i].Cells[1].Value);
ParametersAF += Convert.ToString(dgwEditParametersAF.Rows[i].Cells[1].Value);
if (i != LibraryOfActivateFunctions.GetCountParametersOfAF(typeAF,
LibraryOfActivateFunctions.GetterParameter.TypeOfActivateFunctionName) - 1)
{
ParametersAF += " ";
}
}
bool isContining = true;
bool isNeuronsInLayersSame = false;
bool isParametersAFSame = false;
bool isNeedToDelete = false;
if (CountLayers == definition_of_editing_net.LayerCount)
{
int k = 0;
for (int i = 0; i < CountLayers; i++)
{
if (NeuInL[i] == definition_of_editing_net.NeuronsInLayer[i])
{
k++;
}
}
if (k == CountLayers)
{
isNeuronsInLayersSame = true;
}
}
if (String.Compare(cbActivateFunction.SelectedItem.ToString(), definition_of_editing_net.ActivateFunction) == 0)
{
int k = 0;
for (int i = 0; i < definition_of_editing_net.AFParameters.Length; i++)
{
if (ParAF[i] == definition_of_editing_net.AFParameters[i])
{
k++;
}
}
if (k == definition_of_editing_net.AFParameters.Length)
{
isParametersAFSame = true;
}
}
if (String.Compare(TaskName, definition_of_editing_net.TaskName) != 0 ||
String.Compare(TopologyTypeName, definition_of_editing_net.TopologyName) != 0 ||
CountNeurons != definition_of_editing_net.NeuronsCount ||
isNeuronsInLayersSame == false || isParametersAFSame == false)
{
DialogResult res = MessageBox.Show("Данные изменения влекут удаление обученных весов сети. " +
"Нейронную сеть необходимо будет обучать заново.", "Предупреждение потери данных", MessageBoxButtons.OKCancel);
isNeedToDelete = true;
if (res == DialogResult.Cancel)
{
isContining = false;
}
}
if (isContining == true)
{
if (isNeedToDelete == true)
{
LoadingWindow loadingWindow = new LoadingWindow();
if (isNeuronsInLayersSame && (String.Compare(cbTopology.SelectedItem.ToString(), definition_of_editing_net.TopologyName) == 0))
{
loadingWindow.MakeLoading(
() => dbHandler.DeleteWeightsMatrix(definition_of_editing_net.Name, loadingWindow),
"Удаление устаревших весовых коэффициентов");
}
else
{
loadingWindow.MakeLoading(
() => dbHandler.DeleteTopologyAndWeightsMatrix(definition_of_editing_net.Name, loadingWindow),
"Удаление старой топологии нейронной сети");
loadingWindow.MakeLoading(
() => dbHandler.InsertTopologyOfNeuroNet(definition_of_editing_net.Name, TopologyTypeName, CountNeurons, CountLayers, NeuInL, loadingWindow),
"Запись измененной нейронной сети в БД");
}
}
dbHandler.UpdateNeuroNet(NameNN, definition_of_editing_net.Name, TopologyTypeName, TaskName, CountNeurons, CountLayers,
NeuronsInLayers, typeAF, ParametersAF);
Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
