private List <KindaRepository> DBSelectByMainFeatures(int percents, SearchModel whatToSearch) { List <KindaRepository> firstSelect = new List <KindaRepository>(); SizeM _3DimensionSize = SomeHelpful.OrderSize(whatToSearch.Size1, whatToSearch.Size2, whatToSearch.Size3); decimal allowance = Allowance(_3DimensionSize.P2, _3DimensionSize.P1); decimal percentsCalculated = Percents(percents); PointM allowance1 = new PointM { LowerBound = allowance - percentsCalculated, UpperBound = allowance + percentsCalculated }; //10% допустимое отклонение allowance = Allowance(_3DimensionSize.P3, _3DimensionSize.P2); PointM allowance2 = new PointM { LowerBound = allowance - percentsCalculated, UpperBound = allowance + percentsCalculated }; //10% допустимое отклонение using (dataSearch = new SQLRepositoryDataContext(ConfigurationSettings.SQLConnection1)) { if (dataSearch != null) { var table = dataSearch.KindaRepositories.ToList(); try { firstSelect = table.Where( x => (Allowance(x.Size2, x.Size1) >= allowance1.LowerBound && Allowance(x.Size2, x.Size1) <= allowance1.UpperBound &&//поиск деталей соответствующим допустимому отклонению Allowance(x.Size3, x.Size2) >= allowance2.LowerBound && Allowance(x.Size3, x.Size2) <= allowance2.UpperBound )).ToList(); } catch (Exception fail) { MessageBox.Show(fail.Message); throw fail; } } else { System.Windows.Forms.MessageBox.Show("Не удалось установить подключение к базе даных. Проверте строку подключения и настройки сети!"); } } return(firstSelect); }
private void button1_Click(object sender, EventArgs e) { filePathes = null; oneFile = string.Empty; try { if (!checkBox1.Checked) { if (folderBrowserDialog1.ShowDialog() == DialogResult.OK) { filePathes = Directory.GetFiles(folderBrowserDialog1.SelectedPath); foreach (var item in filePathes) { MessageBox.Show(item); } } } else { OpenFileDialog choofdlog = new OpenFileDialog(); choofdlog.Filter = "All Files (*.SLDPRT*)|*.*"; choofdlog.FilterIndex = 1; if (choofdlog.ShowDialog() == DialogResult.OK) { SomeHelpful.OpenLocal(choofdlog.FileName); } } //if (filePathes?.Length > 0 || oneFile != string.Empty) //{ // groupBox1.Enabled = true; //} //else //{ // groupBox1.Enabled = false; //} } catch (Exception ep) { MessageBox.Show(ep.Message); } }
public void GetPartFromDB(SearchModel wasSelected) { string localPath; if (wasSelected.Local) { localPath = GetPathFromDB(wasSelected.ID); if (!SomeHelpful.OpenLocal(localPath)) { GoToGetBytes(wasSelected.ID); } } else { GoToGetBytes(wasSelected.ID); } }
private KindaRepository InitializeModel() { SizeM point3dSize = SomeHelpful.OrderSize(height, width, lenght); model = new KindaRepository(); model.Size1 = point3dSize.P1; model.Size2 = point3dSize.P2; model.Size3 = point3dSize.P3; SizeM diamOfVals = SomeHelpful.OrderSize(dimVal1, dimVal2, dimVal3); model.DimVal1 = diamOfVals.P1; model.DimVal2 = diamOfVals.P2; model.DimVal3 = diamOfVals.P3; model.Path = addModel.GetPath(); model.Model = addModel.ModelBytes(model.Path); return(model); }
/// <summary> /// Поиск по дополнительным параметрам, проводиться не на таблице из БД, а на списке обьектов выбранных по основным габаритам /// </summary> /// <param name="percents"></param> /// <param name="whatToSearch"></param> /// <param name="tableAlreadySelectedOnce"></param> /// <returns></returns> private List <KindaRepository> DBSelectBySubFeatures(int percents, SearchModel whatToSearch, List <KindaRepository> tableAlreadySelectedOnce) { List <KindaRepository> secondSelect = new List <KindaRepository>(); SizeM _3DimensionSize = SomeHelpful.OrderSize(whatToSearch.Size1, whatToSearch.Size2, whatToSearch.Size3); decimal allowance; decimal percentsCalculated = Percents(percents); SizeM _3DiamVals = SomeHelpful.OrderSize(whatToSearch.DimVal1, whatToSearch.DimVal2, whatToSearch.DimVal3); if (_3DiamVals.P3 == 0 && _3DiamVals.P2 == 0 && _3DiamVals.P1 != 0)// задан один диаметр вала { allowance = Allowance(_3DiamVals.P1, _3DimensionSize.P1); PointM allowance1 = new PointM { LowerBound = allowance - percentsCalculated, UpperBound = allowance + percentsCalculated }; secondSelect = tableAlreadySelectedOnce.Where( x => x.DimVal1 > 0 && (Allowance(x.DimVal1, x.Size1) >= allowance1.LowerBound && Allowance(x.DimVal1, x.Size1) <= allowance1.UpperBound)).ToList(); } else if (_3DiamVals.P3 == 0 && _3DiamVals.P2 != 0 && _3DiamVals.P1 != 0)// задано два диаметра вала { allowance = Allowance(_3DiamVals.P1, _3DimensionSize.P1); PointM allowance1 = new PointM { LowerBound = allowance - percentsCalculated, UpperBound = allowance + percentsCalculated }; allowance = Allowance(_3DiamVals.P2, _3DimensionSize.P2); PointM allowance2 = new PointM { LowerBound = allowance - percentsCalculated, UpperBound = allowance + percentsCalculated }; secondSelect = tableAlreadySelectedOnce.Where( x => (x.DimVal1 > 0 && x.DimVal2 > 0 && Allowance(x.DimVal1, x.Size1) >= allowance1.LowerBound && Allowance(x.DimVal1, x.Size1) <= allowance1.UpperBound && Allowance(x.DimVal2, x.Size2) >= allowance2.LowerBound && Allowance(x.DimVal2, x.Size2) <= allowance2.UpperBound )).ToList(); } else if (_3DiamVals.P3 != 0 && _3DiamVals.P2 != 0 && _3DiamVals.P1 != 0) //заданы три параметра по поиску для диаметра вала { allowance = Allowance(_3DiamVals.P1, _3DimensionSize.P1); PointM allowance1 = new PointM { LowerBound = allowance - percentsCalculated, UpperBound = allowance + percentsCalculated }; allowance = Allowance(_3DiamVals.P2, _3DimensionSize.P2); PointM allowance2 = new PointM { LowerBound = allowance - percentsCalculated, UpperBound = allowance + percentsCalculated }; allowance = Allowance(_3DiamVals.P3, _3DimensionSize.P3); PointM allowance3 = new PointM { LowerBound = allowance - percentsCalculated, UpperBound = allowance + percentsCalculated }; secondSelect = tableAlreadySelectedOnce.Where( x => (x.DimVal1 > 0 && x.DimVal2 > 0 && x.DimVal3 > 0 && Allowance(x.DimVal1, x.Size1) >= allowance1.LowerBound && Allowance(x.DimVal1, x.Size1) <= allowance1.UpperBound && Allowance(x.DimVal2, x.Size2) >= allowance2.LowerBound && Allowance(x.DimVal2, x.Size2) <= allowance2.UpperBound && Allowance(x.DimVal3, x.Size3) >= allowance3.LowerBound && Allowance(x.DimVal3, x.Size3) <= allowance3.UpperBound )).ToList(); } return(secondSelect); }