public frmAvaliacao(String avaId) { InitializeComponent(); ava = new Avaliacao(); func = new Funcionario(); alu = new Aluno(); ana = new Anamnese(); per = new Perimetro(); comp = new Composicao(); neuro = new Neuromotor(); util = new Utils(); util.desabilitarCampos(tbAnamnese.Controls, false); ttbGeralSaude.Enabled = true; ttbAtividadeFisica.Enabled = true; ttbPartesModificar.Enabled = true; ttbObjetivoPraticaExe.Enabled = true; util.numericMaskFormata(tbPerimetros.Controls); util.numericMaskFormata(tbComposicao.Controls); util.numericMaskFormata(ttbNeuroWells); ava.Id = avaId; ava = ava.getById(); func.Id = ava.FuncId; func.getDadosFunc(); alu.Id = Convert.ToInt32(ava.AluId); alu = alu.getAlunoById(); if (alu.Sexo == 'm') { lblProtocolo.Text = "Pollock - 3 dobras"; ttbCompAxilarMedia.Enabled = false; ttbCompSubEscap.Enabled = false; ttbCompSupraIliaca.Enabled = false; ttbCompTricipital.Enabled = false; } else { lblProtocolo.Text = "Pollock - 7 dobras"; } lblAvaliado.Text = alu.Nome; lblAvaliador.Text = func.Nome; lblIdade.Text = ""+util.getIdade(alu.DtNasc); lblCodigo.Text = ava.Id; if (!ava.jaRealizada()) { ana.nova(ava.Id); per.nova(ava.Id); comp.nova(ava.Id, alu.Sexo); neuro.novo(ava.Id); ava = ava.getById(); } setarCamposAna(); setarCamposPer(); setarCamposComp(); setarCamposNeuro(); lblData.Text = ava.DtRealizada; atualizaTermo(); }
public Neuromotor getById(String id) { Neuromotor neuro = new Neuromotor(); sql = "SELECT * FROM neuromotor WHERE neuro_id=@1"; sql = sql.Replace("@1", id); bco.conecta(); result = bco.executeQuery(sql, out dt); bco.desconecta(); if (dt.Rows.Count > 0) { neuro.Id = dt.Rows[0]["neuro_id"].ToString(); neuro.Flexao = dt.Rows[0]["neuro_flexao"].ToString(); neuro.Abdominal = dt.Rows[0]["neuro_abdominal"].ToString(); neuro.Wells = dt.Rows[0]["neuro_banco_wells"].ToString(); neuro.FlexaoLegenda = dt.Rows[0]["neuro_flexao_legenda"].ToString(); neuro.AbdominalLegenda = dt.Rows[0]["neuro_abdominal_legenda"].ToString(); neuro.WellsLegenda = dt.Rows[0]["neuro_wells_legenda"].ToString(); } return neuro; }
public bool atualiza(Neuromotor neuro) { sql = "UPDATE neuromotor SET neuro_flexao=@1, neuro_abdominal=@2, neuro_banco_wells=@3 " + ", neuro_flexao_legenda='@4', neuro_abdominal_legenda='@5', neuro_wells_legenda='@6' "+ "WHERE neuro_id = @A"; sql = sql.Replace("@A", neuro.Id); sql = sql.Replace("@1", neuro.Flexao); sql = sql.Replace("@2", neuro.Abdominal); if (neuro.Wells == "") sql = sql.Replace("@3", "null"); else sql = sql.Replace("@3", neuro.Wells); sql = sql.Replace("@4", neuro.FlexaoLegenda); sql = sql.Replace("@5", neuro.AbdominalLegenda); sql = sql.Replace("@6", neuro.WellsLegenda); bco.conecta(); result = bco.executeNonQuery(sql); bco.desconecta(); return result; }
private void setarCamposNeuro() { neuro.Id = ava.NeuroId; neuro = neuro.getById(); ttbNeuroWells.Text = neuro.Wells; try { numNeuroAbdominal.Value = Convert.ToDecimal(neuro.Abdominal); } catch { } try { numNeuroFlexao.Value = Convert.ToDecimal(neuro.Flexao); } catch { } }