private int DetailSetId()
{
using (var db = new DBServerContext())
{
return(db.CREATEDETAILS.First(f => f.Detail_CreatedId == createdDetail.Detail_CreatedId).DetailsSet.DetailsSetId);
}
}
private void ChartControll()
{
var seriesMaxStress = new BarSeries();
var seriesMinStress = new BarSeries();
using (var db = new DBServerContext())
{
var pointsMax = new List <DataPoint>();
var pointsMin = new List <DataPoint>();
foreach (var stress in detailsList)
{
var detail = db.CREATEDETAILS.Where(f => f.DetailsList == stress.DetailName)
.First(w => w.DetailsSet.DetailsSetId == stress.ID);
var maxMin = db.MAXMINSTRESS.First(f => f.Analysis.AnalysisId == detail.Analysis.AnalysisId);
pointsMax.Add(new CategoricalDataPoint(Math.Round(maxMin.Max), String.Format("ID: {0}\n{1}",
detail.Detail_CreatedId, detail.DetailsList)));
pointsMin.Add(new CategoricalDataPoint(Math.Round(maxMin.Min), String.Format("ID: {0}\n{1}",
detail.Detail_CreatedId, detail.DetailsList)));
}
seriesMaxStress.DataPoints.AddRange(pointsMax);
seriesMaxStress.ShowLabels = true;
seriesMinStress.DataPoints.AddRange(pointsMin);
seriesMinStress.ShowLabels = true;
}
chartResults.View.Series.Add(seriesMaxStress);
chartResults.View.Series.Add(seriesMinStress);
}
private void FillInfoGroup()
{
using (var db = new DBServerContext())
{
nameTextBox.Text = createdDetail.DetailsList;
idTextBox.Text = createdDetail.Detail_CreatedId.ToString();
dataSetTextBox.Text = db.CREATEDETAILS.First(f => f.Detail_CreatedId == createdDetail.Detail_CreatedId).DetailsSet.Name;
}
}
private void ResultCommand_Click(object sender, EventArgs e)
{
using (var db = new DBServerContext())
{
grid.DataSource = null;
var analysisId = db.CREATEDETAILS.First(f => f.DetailsList == createdDetail.DetailsList).Analysis.AnalysisId;
grid.DataSource = db.RESULTS.Where(w => w.Analysis.AnalysisId == analysisId).ToList();
TextAlignment();
NowTextBox.Text = "РЕЗУЛЬТАТЫ";
}
}
private void PropertyCommand_Click(object sender, EventArgs e)
{
using (var db = new DBServerContext())
{
grid.DataSource = null;
var analysisId = db.CREATEDETAILS.First(f => f.DetailsList == createdDetail.DetailsList).Analysis.AnalysisId;
grid.DataSource = db.PROPERTYANDMESHES.Where(w => w.Analysis.AnalysisId == analysisId).ToList();
TextAlignment();
NowTextBox.Text = "СВОЙСТВА КЭ";
}
}
private void ConstraintCommand_Click(object sender, EventArgs e)
{
using (var db = new DBServerContext())
{
grid.DataSource = null;
var analysisId = db.CREATEDETAILS.First(f => f.DetailsList == createdDetail.DetailsList).Analysis.AnalysisId;
grid.DataSource = db.CONTRAINTS.Where(w => w.Analysis.AnalysisId == analysisId).ToList();
TextAlignment();
NowTextBox.Text = "ГРАНИЧНЫЕ УСЛОВИЯ";
}
}
public AssemblyForm(model FemapModel)
{
InitializeComponent();
this.FemapModel = FemapModel;
Status.CancellationTokenSourse = new CancellationTokenSource();
timer1.Start();
timer1.Interval = 200;
timer1.Tick += timer1_Tick;
DBServerContext context = new DBServerContext();
comboDetailSets.DataSource = context.DETAILS.Select(s => s.Name).ToList();
}
public СrankshaftForm(femap.model FemapModel)
{
InitializeComponent();
this.FemapModel = FemapModel;
Status.CancellationTokenSourse = new CancellationTokenSource();
timer1.Start();
timer1.Interval = 200;
timer1.Tick += timer1_Tick;
ui = new SyncGUI(FemapModel);
ui.SyncSizes(groupBox1);
db = new DBServerContext();
Task.Run(() => FindDetail());
}
private async Task FindDetail()
{
DBServerContext db = new DBServerContext();
int currentId = db.DETAILS.Select(s => s.DetailsSetId).ToListAsync().Result[db.DETAILS.Select(s => s.DetailsSetId).CountAsync().Result - 1];
foreach (var detail in db.CREATEDETAILS.Where(w => w.DetailsSet.DetailsSetId == currentId).Select(s => s.DetailsList))
{
if (detail == "Крышка шатуна")
{
CreateBtn.Enabled = false;
}
}
}
private DBDetailsSet.DBDetail_Created FindBestResult()
{
using (var db = new DBServerContext())
{
foreach (var detail in detailsList)
{
var findDetail = db.CREATEDETAILS.Where(f => f.DetailsList == detail.DetailName)
.First(w => w.DetailsSet.DetailsSetId == detail.ID);
var maxMin = db.MAXMINSTRESS.First(f => f.Analysis.AnalysisId == findDetail.Analysis.AnalysisId);
details.Add(findDetail);
MaxMin.Add(maxMin);
}
var minValue = MaxMin.Select(s => s.Max).Min();
var BestResult = MaxMin.First(f => f.Max == minValue);
return(db.CREATEDETAILS.First(f => f.Analysis.AnalysisId == BestResult.Analysis.AnalysisId));
}
}
private void SizesCommand_Click(object sender, EventArgs e)
{
using (var db = new DBServerContext())
{
grid.DataSource = null;
var ID = DetailSetId();
switch (createdDetail.DetailsList)
{
case "Поршень":
grid.DataSource = db.PISTON.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
break;
case "Шатун":
grid.DataSource = db.ROD.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
break;
case "Крышка шатуна":
grid.DataSource = db.COVERROD.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
break;
case "Поршневой палец":
grid.DataSource = db.FINGER.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
break;
case "Коленчатый вал":
grid.DataSource = db.CRANKSHAFT.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
break;
case "Гильза цилиндра":
grid.DataSource = db.SLEEVECYLINDER.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
break;
}
grid.Columns[0].HeaderText = "Идентификатор";
grid.Columns[1].HeaderText = "Размер";
grid.Columns[2].HeaderText = "Значение";
grid.Columns[3].IsVisible = false;
TextAlignment();
NowTextBox.Text = "РАЗМЕРЫ";
}
}
private void OutputInWORDButton_Click(object sender, EventArgs e)
{
using (var db = new DBServerContext())
{
var analysisId = db.CREATEDETAILS.First(f => f.DetailsList == createdDetail.DetailsList).Analysis.AnalysisId;
var properties = db.PROPERTYANDMESHES.Where(w => w.Analysis.AnalysisId == analysisId).ToList();
var results = db.RESULTS.Where(w => w.Analysis.AnalysisId == analysisId).ToList();
var constraints = db.CONTRAINTS.Where(w => w.Analysis.AnalysisId == analysisId).ToList();
var loads = db.LOADS.Where(w => w.Analysis.AnalysisId == analysisId).ToList();
var materials = db.MATERIALS.Where(w => w.Analysis.AnalysisId == analysisId).ToList();
var maxMinStresses = db.MAXMINSTRESS.Where(f => f.Analysis.AnalysisId == analysisId).ToList();
var maxMinTranslates = db.MAXMINTRANSLATE.Where(f => f.Analysis.AnalysisId == analysisId).ToList();
var ID = DetailSetId();
var pistons = new List <DBDetailsSet.DBPiston>(3);
var rods = new List <DBDetailsSet.DBRod>(3);
var coverRods = new List <DBDetailsSet.DBCoverRod>(3);
var fingers = new List <DBDetailsSet.DBFinger>(3);
var crankshafts = new List <DBDetailsSet.DBCrankshaft>(3);
var cylinders = new List <DBDetailsSet.DBSleeveCylinder>(3);
var output = new OutputDataToWord();
switch (createdDetail.DetailsList)
{
case "Поршень":
pistons = db.PISTON.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
Task.Run(() => output.CreateWordAsync(createdDetail.Detail_CreatedId, createdDetail.DetailsList,
DetailSetId(), pistons, materials, loads, constraints, maxMinStresses, maxMinTranslates, properties,
results));
break;
case "Шатун":
rods = db.ROD.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
Task.Run(() => output.CreateWordAsync(createdDetail.Detail_CreatedId, createdDetail.DetailsList,
DetailSetId(), rods, materials, loads, constraints, maxMinStresses, maxMinTranslates, properties,
results));
break;
case "Крышка шатуна":
coverRods = db.COVERROD.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
Task.Run(() => output.CreateWordAsync(createdDetail.Detail_CreatedId, createdDetail.DetailsList,
DetailSetId(), coverRods, materials, loads, constraints, maxMinStresses, maxMinTranslates, properties,
results));
break;
case "Поршневой палец":
fingers = db.FINGER.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
Task.Run(() => output.CreateWordAsync(createdDetail.Detail_CreatedId, createdDetail.DetailsList,
DetailSetId(), fingers, materials, loads, constraints, maxMinStresses, maxMinTranslates, properties,
results));
break;
case "Коленчатый вал":
crankshafts = db.CRANKSHAFT.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
Task.Run(() => output.CreateWordAsync(createdDetail.Detail_CreatedId, createdDetail.DetailsList,
DetailSetId(), crankshafts, materials, loads, constraints, maxMinStresses, maxMinTranslates, properties,
results));
break;
case "Гильза цилиндра":
cylinders = db.SLEEVECYLINDER.Where(w => w.DetailsSet.DetailsSetId == ID).ToList();
Task.Run(() => output.CreateWordAsync(createdDetail.Detail_CreatedId, createdDetail.DetailsList,
DetailSetId(), cylinders, materials, loads, constraints, maxMinStresses,
maxMinTranslates, properties,
results));
break;
}
}
}
