private void LoadLeadTimeKpi(string orcId)
{
//vai entrar no metodo do botao
if (orcId != "Selecione")
{
//LoadLeadTimeKpi(Convert.ToInt32(orcamento_id));
BudgetBD budgetBD = new BudgetBD();
DataSet ds = budgetBD.SelectPreviousFinishedBudget(Convert.ToInt32(orcId));
int count = ds.Tables[0].Rows.Count;
if (count > 0)
{
gdvLeadTimeKpi.DataSource = ds.Tables[0].DefaultView;
gdvLeadTimeKpi.DataBind();
gdvLeadTimeKpi.HeaderRow.TableSection = TableRowSection.TableHeader;
//lblMessage.Visible = false;
}
FinishedBudget start = budgetBD.SelectStartDateById(Convert.ToInt32(orcId));
FinishedBudget end = budgetBD.SelectEndDateById(Convert.ToInt32(orcId));
double diasAcumulados = (end.FinishedDate - start.StartDate).TotalDays;
Label2.Visible = true;
lblDiasAcumulados.Visible = true;
lblDiasAcumulados.Text = " " + Convert.ToString(diasAcumulados);
}
else
{
gdvLeadTimeKpi.Visible = false;
}
}
public FinishedBudget SelectStartDateById(int id)
{
FinishedBudget obj = null;
System.Data.IDbConnection objConn;
System.Data.IDbCommand objCommand;
System.Data.IDataReader objDataReader;
objConn = Mapped.Connection();
objCommand = Mapped.Command("select * from orcamento orc join etapa eta on eta.orc_id = orc.orc_id join etapa_descricao des on des.etd_id = eta.etd_id where orc.orc_id = ?id order by eta.etd_id asc limit 1", objConn);
objCommand.Parameters.Add(Mapped.Parameter("?id", id));
objDataReader = objCommand.ExecuteReader();
while (objDataReader.Read())
{
obj = new FinishedBudget();
obj.StartDate = Convert.ToDateTime(objDataReader["eta_data_inicio"]);
}
objDataReader.Close();
objConn.Close();
objCommand.Dispose();
objConn.Dispose();
objDataReader.Dispose();
return(obj);
}
