private void btnIncluirCausa_Click(object sender, EventArgs e)
{
FrmProcurar frmProcurar = new FrmProcurar();
ResultadoProcura rp = frmProcurar.PesquisarCausaPCP(dir, "Causa raíz", "Tipo;Causa;Controlavél;", "80;200;80;");
if (rp.fResultadoProcura)
{
Perguntar inputBox = new Perguntar();
inputBox.Inputar("Digite o detalhe da causa", "Causas");
string detalheCausa = inputBox.resultadoProcura.vCampo.ToString();
if (grdElementos.SelectedRows.Count > 0)
{
foreach (DataGridViewRow row in grdElementos.SelectedRows)
{
IncluirCausa(rp, detalheCausa, row.Cells["PLAN_SERVICO_AMO_ID"].Value.ToString());
}
}
else
{
IncluirCausa(rp, detalheCausa, grdElementos.CurrentRow.Cells["PLAN_SERVICO_AMO_ID"].Value.ToString());
}
}
dtCausa.Rows.Clear();
dtCriterio.Rows.Clear();
dtElemento.Rows.Clear();
dtElemento.ida.Fill(dtElemento);
dtCriterio.ida.Fill(dtCriterio);
dtCausa.ida.Fill(dtCausa);
}
private void btnAtribuirItem_Click(object sender, EventArgs e)
{
FrmProcurar procurar = new FrmProcurar();
StringBuilder sb = new StringBuilder();
sb.Append(" select ");
sb.Append(" etapa_id, ");
sb.Append(" item, ");
sb.Append(" etapa, etapa_id ");
sb.Append(" from etapa order by item ");
ResultadoProcura rp = new ResultadoProcura();
rp = procurar.Pesquisar(dir, "Escolher o item",
sb.ToString(), "Código;Item;Descrição;Id;",
"80;100;350;50;");
if (!rp.fResultadoProcura)
{
return;
}
int etapaid = Convert.ToInt32((rp.linha as DataGridViewRow).Cells["ETAPA_ID"].Value);
string item = (rp.linha as DataGridViewRow).Cells["ITEM"].Value.ToString();
string etapa = (rp.linha as DataGridViewRow).Cells["ETAPA"].Value.ToString();
if (grdServico.SelectedRows.Count < 2)
{
grdServico.CurrentRow.Cells["ETAPA_ID"].Value = etapaid;
grdServico.CurrentRow.Cells["ITEM"].Value = item;
grdServico.CurrentRow.Cells["ETAPA"].Value = etapa;
manipulacao.PRC_EXECUTAR_DIRETO("UPDATE SERVICO S SET S.ETAPA_ID = " + etapaid.ToString() +
" WHERE S.SERVICO_ID = " +
grdServico.CurrentRow.Cells["SERVICO_ID"].Value.ToString());
}
else
{
foreach (DataGridViewRow item1 in grdServico.SelectedRows)
{
item1.Cells["ETAPA_ID"].Value = etapaid;
item1.Cells["ITEM"].Value = item;
item1.Cells["ETAPA"].Value = etapa;
manipulacao.PRC_EXECUTAR_DIRETO("UPDATE SERVICO S SET S.ETAPA_ID = " + etapaid.ToString() +
" WHERE S.SERVICO_ID = " +
grdServico.CurrentRow.Cells["SERVICO_ID"].Value.ToString());
}
}
}
public FrmAnaliselookaHead(string idir, ExternalCommandData irevit, DataTable dtDownload)
{
revit = irevit;
InitializeComponent();
ConstruirQtdePSA();
dtpInicio.Value = DateTime.Today.AddDays(-30);
dtpTermino.Value = DateTime.Today;
manipulacao = new Plan_servico_amoNegocio(idir);
dtGrid.Columns.Add("INSUMO_ID", typeof(int));
dtGrid.Columns.Add("INSUMO", typeof(string));
dtGrid.Columns.Add("UNID", typeof(string));
dtGrid.Columns.Add("QTDE_TOTAL_ENTRADA", typeof(double));
dtGrid.Columns.Add("QTDE_CONSUMIDA", typeof(double));
dtGrid.Columns.Add("QTDE_SOLICITADA_LOOK_A_HEAD", typeof(double));
dtGrid.Columns.Add("SALDO", typeof(double));
dtGrid.Columns["SALDO"].Expression = "QTDE_TOTAL_ENTRADA - QTDE_CONSUMIDA - QTDE_SOLICITADA_LOOK_A_HEAD";
dtGrid.Columns.Add("SERVICO_ID", typeof(string));
dtGrid.Columns.Add("CONSUMO_INSUMO", typeof(double));
dtGrid.Columns.Add("ORIGEM", typeof(int));
DataGridViewCellStyle formatoNumerico = new DataGridViewCellStyle();
formatoNumerico.Format = "N2";
ds.Tables.Add(dtGrid);
bs.DataSource = ds;
bs.DataMember = dtGrid.TableName;
dataGridView1.DataSource = bs;
dataGridView1.Columns["INSUMO_ID"].Width = 90;
dataGridView1.Columns["INSUMO_ID"].HeaderText = "Insumo";
dataGridView1.Columns["INSUMO"].Width = 200;
dataGridView1.Columns["INSUMO"].HeaderText = "Desc. Inusmo";
dataGridView1.Columns["QTDE_TOTAL_ENTRADA"].Width = 120;
dataGridView1.Columns["QTDE_TOTAL_ENTRADA"].HeaderText = "Entrada";
dataGridView1.Columns["QTDE_TOTAL_ENTRADA"].DefaultCellStyle = formatoNumerico;
dataGridView1.Columns["QTDE_CONSUMIDA"].Width = 120;
dataGridView1.Columns["QTDE_CONSUMIDA"].HeaderText = "Saída";
dataGridView1.Columns["QTDE_CONSUMIDA"].DefaultCellStyle = formatoNumerico;
dataGridView1.Columns["QTDE_SOLICITADA_LOOK_A_HEAD"].Width = 120;
dataGridView1.Columns["QTDE_SOLICITADA_LOOK_A_HEAD"].HeaderText = "Lookahead";
dataGridView1.Columns["QTDE_SOLICITADA_LOOK_A_HEAD"].DefaultCellStyle = formatoNumerico;
dataGridView1.Columns["SALDO"].Width = 120;
dataGridView1.Columns["SALDO"].HeaderText = "Saldo";
dataGridView1.Columns["SALDO"].DefaultCellStyle = formatoNumerico;
FrmProcurar procurar = new FrmProcurar();
StringBuilder sb = new StringBuilder();
sb.Append(" select ");
sb.Append(" obra_id, ");
sb.Append(" obra ");
sb.Append(" ");
sb.Append(" from obra ");
ResultadoProcura rp = new ResultadoProcura();
rp = procurar.Pesquisar(idir, "Escolher Obra",
sb.ToString(), "Obra;Desc. Obra;",
"80;250;");
EscolherData escolherData1 = new EscolherData();
DialogResult resultado1 = escolherData1.inputar(ref mesAnalise, "Escolha o mes de análise", ref continuar);
EscolherData escolherData = new EscolherData();
DialogResult resultado = escolherData.inputar(ref diaAnalise, "Escolha o dia", ref continuar);
if (continuar)
{
if (procurar.resultadoProcura.fResultadoProcura)
{
atualizando = true;
cmbServico.SelectedItem = 0;
foreach (DataRow dr2 in dtDownload.Rows)
{
cmbServico.Items.Add(dr2["UAU_COMP"].ToString());
}
atualizando = false;
BuscarInsumoLookAHead(dtDownload, diaAnalise, Convert.ToInt32( rp.vCampo));
BuscarQtdePSA(dtDownload);
}
}
escolherData.Dispose();
uiApp = revit.Application;
uiDoc = uiApp.ActiveUIDocument.Document;
Selection sel = uiApp.ActiveUIDocument.Selection;
Util.uiDoc = uiDoc;
selecao = new revitDB.FilteredElementCollector(uiDoc).OfClass(typeof(Autodesk.Revit.DB.View));
foreach (revitDB.View view in selecao)
{
try
{
if (view.AreGraphicsOverridesAllowed())
if (view.LookupParameter("tocVistaAvanco").AsValueString() == "Sim")
vistasDeAvanco.Add(view);
}
catch
{
}
}
preenchimentoId = (Util.FindElementByName(typeof(revitDB.Material), "Previsto") as revitDB.Material).SurfacePatternId;
/* orgRestricao= Util.GetOverrideGraphicSettings(Util.GetColorRevit(CorLinhaResticao),
Util.GetColorRevit(CorSuperficieRestricao),
preenchimentoId, 0);*/
}
