private static int saveToTableOfPart(FormSaveToDataBase form, string date)
{
string nameOfPart = form.textBox1.Text;
int cipherDetail = Convert.ToInt32(form.textBox2.Text);
bool isCipherExist = false;
try
{
dbConnection.GetDataUsingDataAdapter($@"SELECT * FROM {DETAIL} WHERE cipher_detail = {cipherDetail}", ref tempDataTable, ref tableDataAdapter);
isCipherExist = tempDataTable.Rows[0] != null;
}
catch { isCipherExist = false; }
if (!isCipherExist)
{
double lengthOfPart = Part.getLenghtOfPart();
dbConnection.SetQuery($@"INSERT INTO {DETAIL} VALUES ('{nameOfPart}', {cipherDetail}, '{date}', {doubleToStringForDb(lengthOfPart)})");
}
return(cipherDetail);
}
private static void saveWorkpieceToTableOfOperations(FormSaveToDataBase form, int index)
{
ParametersWorkpiece parametersWorkpiece = Part.getWorkpiece();
// ClassesToCalculate.ResultsOfCalculation resultOfCalculation = Part.getSurfaceOnIndex(0).getResultsOfCalculation();
// form.переходыTableAdapter.Insert(Convert.ToInt16(form.dataGridView1[0, index - 1].Value.ToString()) + 1, 0, parametersWorkpiece.getNameOfWorkpiece(), "", (float)parametersWorkpiece.getSurfaceRoughnessRz(), (float)parametersWorkpiece.getThicknessOfDefectiveCoating(), (float)resultOfCalculation.getSpatialDeviation()[0], (float)resultOfCalculation.getdeviationOfInstallation()[0], (float)resultOfCalculation.getAccuracies()[0], (float)resultOfCalculation.getNominalAllowance()[0], (float)resultOfCalculation.getSizeOfWorkprieceAfterOperation()[0], parametersWorkpiece.getIdWorkpiece(), null, (float)parametersWorkpiece.getValidOffsetSurface(), (int)parametersWorkpiece.getKvalitet());
}
private static void saveToDatabase(FormSaveToDataBase form)
{
DateTime date = DateTime.Now;
string dateToString = date.ToString("MM.dd.yyyy");
int cipherDetail = saveToTableOfPart(form, dateToString);
int idCalculation = saveToCalculation(form, cipherDetail, dateToString);
saveToTableTechnologicalProcessAndSurfaces(form, cipherDetail, idCalculation);
}
public static void buttonSaveToDatabase(FormSaveToDataBase form)
{
try
{
if (checkNameOfPartAndNameOfSurface(form))
{
saveToDatabase(form);
MessageBox.Show("Сохранение прошло успешно");
form.Close();
}
}
catch (Exception e) { MessageBox.Show("Ошибка Базы данных" + e.TargetSite, "Ошибка"); }
}
private static void saveToTableTechnologicalProcessAndSurfaces(FormSaveToDataBase form, int cipherDetail, int idCalculation)
{
ParametersWorkpiece workpiece = Part.getWorkpiece();
int idWorkpieceInDB = saveWorkpiece(cipherDetail, idCalculation, workpiece);
List <Operation> technologicalProcess = Part.getSurfaceOnIndex(0).getOperations();
int countOperation = Part.getSurfaceOnIndex(0).getCountShortListOperation();
for (int i = 0; i < countOperation; i++)
{
int idOperation = saveOperationInTechnologicalProcess(cipherDetail, idCalculation, technologicalProcess[i], i + 1);
}
saveSurfaces(cipherDetail, idCalculation);
}
private static bool checkNameOfPartAndNameOfSurface(FormSaveToDataBase form)
{
if (form.textBox1.Text.Equals(""))
{
MessageBox.Show("Введите наименование детали", "Ошибка");
return(false);
}
if (form.textBox2.Text.Equals(""))
{
MessageBox.Show("Введите обозначение поверхности", "Ошибка");
return(false);
}
return(true);
}
private static void saveToTableOfOperations(FormSaveToDataBase form, int index)
{
Surface surface = Part.getSurfaceOnIndex(0);
List <ParametersOperation> parametersOperations = surface.getParametersOperation();
int numberOfOperation = surface.getCountLongListOperation();
for (int i = 0; i < numberOfOperation; i++)
{
ParametersOperation parametersOperation = parametersOperations[i];
ClassesToCalculate.ResultsOfCalculation resultsOfCalculation = parametersOperation.getResultsOfCalculation();
string nameOperation = parametersOperation.getTypeOfMachining() + ',' + parametersOperation.getPrecisionOfMachining();
// form.переходыTableAdapter.Insert(Convert.ToInt16(form.dataGridView1[0, index - 1].Value.ToString()) + 1, i + 1, nameOperation, parametersOperation.getTypeOfInstrument(), (float)parametersOperation.getSurfaceRoughnessRz(), (float)parametersOperation.getThicknessOfDefectiveCoating(), (float)resultsOfCalculation.getSpatialDeviation(), (float)resultsOfCalculation.getdeviationOfInstallation(), (float)resultsOfCalculation.getAccuracies(), (float)resultsOfCalculation.getNominalAllowance(), (float)resultsOfCalculation.getSizeOfWorkprieceAfterOperation(), parametersOperation.getIdOperation(), null, (float)parametersOperation.getCoefficientOfRefinement(), (int)parametersOperation.getKvalitet());
}
}
private void buttonSaveToBase_Click(object sender, EventArgs e)
{
FormSaveToDataBase form = new FormSaveToDataBase();
form.ShowDialog();
}
private static int saveToCalculation(FormSaveToDataBase form, int cipherDetail, string date)
{
dbConnection.SetQuery($@"INSERT INTO {CALCULATION} VALUES ({cipherDetail}, '{date}')");
return(getIdentCurrent(CALCULATION));
}