private void mostra_registros() { try { //retorna dados do evento cMaskara cm = new cMaskara(); int retidevento = cm.retorna_id_tipo_evento(tvwDemanda.SelectedNode.Text); if (retidevento > 0) { cEvento ce = new cEvento(); using (DataSet ds = ce.retorna_descricao_evento(NDemanda, int.Parse(retidevento.ToString()))) { foreach (DataRow item in ds.Tables["RetDescEvento"].Rows) { txtinfProduto.Text = item["PRODUTO"].ToString(); txtinfCliente.Text = item["CLIENTE"].ToString(); txtinfFundo.Text = item["RAZAO_SOCIAL"].ToString(); txtinfSiglaSAC.Text = item["SIGLA_SAC"].ToString(); txtinfSiglaFY.Text = item["SIGLA_FY"].ToString(); if (item["CNPJ_CPF"].ToString().Length == 14) { txtinfCNPJCPF.Text = string.Concat(item["CNPJ_CPF"].ToString().Substring(0, 2), ".", item["CNPJ_CPF"].ToString().Substring(2, 3), ".", item["CNPJ_CPF"].ToString().Substring(5, 3), "/", item["CNPJ_CPF"].ToString().Substring(8, 4), "-", item["CNPJ_CPF"].ToString().Substring(12, 2)).Replace(",", "."); } else { txtinfCNPJCPF.Text = string.Concat(item["CNPJ_CPF"].ToString().Substring(0, 3), ".", item["CNPJ_CPF"].ToString().Substring(3, 3), ".", item["CNPJ_CPF"].ToString().Substring(6, 3), "-", item["CNPJ_CPF"].ToString().Substring(9, 2)).Replace(",", "."); } txtDtDemanda.Text = item["DTDEMANDA"].ToString().Substring(0, 10); txtDtCota.Text = item["DTCOTA"].ToString().Substring(0, 10); txtStatus.Text = item["STATUS"].ToString(); //txtApCad.Text = item["USER_CAD"].ToString(); //txtApCadData.Text = item["DT_USER_CAD"].ToString(); //txtApGov.Text = item["GOV_CAD"].ToString(); //txtApGovData.Text = item["DT_GOV_CAD"].ToString(); //txtApCap.Text = item["CAPACITY_CAD"].ToString(); //txtApCapData.Text = item["DT_CAPACITY_CAD"].ToString(); //txtApRTO.Text = item["RTO_CAD"].ToString(); //txtApRTOData.Text = item["DT_RTO_CAD"].ToString(); } if (ds.Tables["RetDescEvento"].Rows.Count > 0) { previa_Cronograma pc = new previa_Cronograma(); using (DataTable dt = pc.retorna_cronograma(NDemanda, int.Parse(retidevento.ToString()))) { #region CAMPOS DataGridViewTextBoxColumn campo0 = new DataGridViewTextBoxColumn(); campo0.Name = "Atividade"; campo0.HeaderText = "Atividade"; campo0.DataPropertyName = "ATIVIDADE"; campo0.Width = 200; DataGridViewTextBoxColumn campo1 = new DataGridViewTextBoxColumn(); campo1.Name = "Esforço"; campo1.HeaderText = "Esforço"; campo1.DataPropertyName = "ESFORCO_PLAN"; campo1.Width = 100; DataGridViewTextBoxColumn campo2 = new DataGridViewTextBoxColumn(); campo2.Name = "Data Execução"; campo2.HeaderText = "Data Execução"; campo2.DataPropertyName = "DT_EXEC_PLAN"; campo2.Width = 100; DataGridViewTextBoxColumn campo3 = new DataGridViewTextBoxColumn(); campo3.Name = "Responsavel"; campo3.HeaderText = "Responsável"; campo3.DataPropertyName = "RESPONSAVEL"; campo3.Width = 100; dgvCronograma.Columns.Clear(); dgvCronograma.AutoGenerateColumns = false; dgvCronograma.Columns.AddRange(new DataGridViewColumn[] { campo0, campo1, campo2, campo3 }); dgvCronograma.DataSource = dt; dt.Dispose(); cDGV modelo = new cDGV(); dgvCronograma = modelo.Grade(dgvCronograma); #region RETORNA TOTAL DE MINUTOS CONFORME O RESPONSAVEL decimal min_passivo = 0; decimal min_processamento = 0; decimal min_suporte = 0; foreach (DataGridViewRow item in dgvCronograma.Rows) { if ((string)item.Cells[3].Value == "Passivo") { min_passivo = min_passivo + Convert.ToDecimal(item.Cells[1].Value); } if ((string)item.Cells[3].Value == "Processamento") { min_processamento = min_processamento + Convert.ToDecimal(item.Cells[1].Value); } if ((string)item.Cells[3].Value == "Suporte") { min_suporte = min_suporte + Convert.ToDecimal(item.Cells[1].Value); } } txtPassivo.Text = Convert.ToString(min_passivo); txtProcessamento.Text = Convert.ToString(min_processamento); txtSuporte.Text = Convert.ToString(min_suporte); #endregion #endregion } } } } } catch (Exception ex) { throw ex; } }
private void mostra_registros() { try { this.Width = 912; //retorna dados do evento cMaskara cm = new cMaskara(); int retidevento = cm.retorna_id_tipo_evento(tvwDemanda.SelectedNode.Text); cGlobal.id_tp_evento = int.Parse(retidevento.ToString()); cTarefa ativ = new cTarefa(); Status(); Avaliacao(); ds.Clear(); ds = ativ.retorna_cronograma(NDemanda, int.Parse(retidevento.ToString())); #region DATASET #region CLEAR txtID.DataBindings.Clear(); cboStatus.DataBindings.Clear(); txtAtividade.DataBindings.Clear(); txtEsfPlan.DataBindings.Clear(); txtEsfReal.DataBindings.Clear(); dtpEsforcoPlan.DataBindings.Clear(); dtpDataReal.DataBindings.Clear(); txtResp.DataBindings.Clear(); txtHistorico.DataBindings.Clear(); cboAvaliacao.DataBindings.Clear(); chkAtrCadastro.DataBindings.Clear(); chkFalCadastro.DataBindings.Clear(); chkAtrPassivo.DataBindings.Clear(); chkFalPassivo.DataBindings.Clear(); chkAtrRelacionamento.DataBindings.Clear(); chkFalRelacionamento.DataBindings.Clear(); chkAtrProduto.DataBindings.Clear(); chkFalProduto.DataBindings.Clear(); chkAtrLiquid.DataBindings.Clear(); chkFalLiquid.DataBindings.Clear(); chkAtrPrecif.DataBindings.Clear(); chkFalPrecif.DataBindings.Clear(); chkAtrCadAtivos.DataBindings.Clear(); chkFalCadAtivos.DataBindings.Clear(); chkAtrSupAtend.DataBindings.Clear(); chkFalSupAtend.DataBindings.Clear(); chkAtrSupProc.DataBindings.Clear(); chkFalSupProc.DataBindings.Clear(); chkAtrConc.DataBindings.Clear(); chkFalConc.DataBindings.Clear(); chkAtrCliente.DataBindings.Clear(); chkFalCliente.DataBindings.Clear(); chkAtrDespesa.DataBindings.Clear(); chkFalDespesa.DataBindings.Clear(); chkAtrTaxas.DataBindings.Clear(); chkFalTaxas.DataBindings.Clear(); #endregion #region VINCULA DATASET txtID.DataBindings.Add("Text", ds, "Cronograma.ID_CRONOGRAMA"); cboStatus.DataBindings.Add("Text", ds, "Cronograma.STATUS"); txtAtividade.DataBindings.Add("Text", ds, "Cronograma.ATIVIDADE"); txtEsfPlan.DataBindings.Add("Text", ds, "Cronograma.ESFORCO_PLAN"); txtEsfReal.DataBindings.Add("Text", ds, "Cronograma.ESFORCO_REAL"); dtpEsforcoPlan.DataBindings.Add("Text", ds, "Cronograma.DT_EXEC_PLAN"); dtpDataReal.DataBindings.Add("Text", ds, "Cronograma.DT_EXEC_REAL"); txtResp.DataBindings.Add("Text", ds, "Cronograma.RESPONSAVEL"); txtHistorico.DataBindings.Add("Text", ds, "Cronograma.HISTORICO"); cboAvaliacao.DataBindings.Add("Text", ds, "Cronograma.AVALIACAO"); chkAtrCadastro.DataBindings.Add("Checked", ds, "Cronograma.CADASTRO_ATRASO"); chkFalCadastro.DataBindings.Add("Checked", ds, "Cronograma.CADASTRO_FALHA"); chkAtrPassivo.DataBindings.Add("Checked", ds, "Cronograma.PASSIVO_ATRASO"); chkFalPassivo.DataBindings.Add("Checked", ds, "Cronograma.PASSIVO_FALHA"); chkAtrRelacionamento.DataBindings.Add("Checked", ds, "Cronograma.RELAC_ATRASO"); chkFalRelacionamento.DataBindings.Add("Checked", ds, "Cronograma.RELAC_FALHA"); chkAtrProduto.DataBindings.Add("Checked", ds, "Cronograma.PRODUTO_ATRASO"); chkFalProduto.DataBindings.Add("Checked", ds, "Cronograma.PRODUTO_FALHA"); chkAtrLiquid.DataBindings.Add("Checked", ds, "Cronograma.LIQUID_ATRASO"); chkFalLiquid.DataBindings.Add("Checked", ds, "Cronograma.LIQUID_FALHA"); chkAtrPrecif.DataBindings.Add("Checked", ds, "Cronograma.PRECIF_ATRASO"); chkFalPrecif.DataBindings.Add("Checked", ds, "Cronograma.PRECIF_FALHA"); chkAtrCadAtivos.DataBindings.Add("Checked", ds, "Cronograma.CAD_ATIVO_ATRASO"); chkFalCadAtivos.DataBindings.Add("Checked", ds, "Cronograma.CAD_ATIVO_FALHA"); chkAtrSupAtend.DataBindings.Add("Checked", ds, "Cronograma.SUPORTE_ATEND_ATRASO"); chkFalSupAtend.DataBindings.Add("Checked", ds, "Cronograma.SUPORTE_ATEND_FALHA"); chkAtrSupProc.DataBindings.Add("Checked", ds, "Cronograma.SUPORTE_PROC_ATRASO"); chkFalSupProc.DataBindings.Add("Checked", ds, "Cronograma.SUPORTE_PROC_FALHA"); chkAtrConc.DataBindings.Add("Checked", ds, "Cronograma.CONCILIACAO_ATRASO"); chkFalConc.DataBindings.Add("Checked", ds, "Cronograma.CONCILIACAO_FALHA"); chkAtrCliente.DataBindings.Add("Checked", ds, "Cronograma.CLIENTE_ATRASO"); chkFalCliente.DataBindings.Add("Checked", ds, "Cronograma.CLIENTE_FALHA"); chkAtrDespesa.DataBindings.Add("Checked", ds, "Cronograma.DESPESA_ATRASO"); chkFalDespesa.DataBindings.Add("Checked", ds, "Cronograma.DESPESA_FALHA"); chkAtrTaxas.DataBindings.Add("Checked", ds, "Cronograma.TAXAS_ATRASO"); chkFalTaxas.DataBindings.Add("Checked", ds, "Cronograma.TAXAS_FALHA"); #endregion tslStatus.Text = string.Concat(BindingContext[ds, "Cronograma"].Position + 1, "/", BindingContext[ds, "Cronograma"].Count); if (BindingContext[ds, "Cronograma"].Count > 0) { tspSuperior.Enabled = true; groupBox1.Enabled = true; groupBox2.Enabled = true; } else { tspSuperior.Enabled = false; groupBox1.Enabled = false; groupBox2.Enabled = false; Limpa_campos(); } #endregion } catch (Exception ex) { throw ex; } }