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;
}
}
