/// <summary>
/// Method responsável por cria lista referente ao ano/mes correspondente a consulta, por grupo, deforma analitica.
/// </summary>
/// <param name="grupo"></param>
/// <param name="prdDe"></param>
/// <returns></returns>
public List<Ub3Analitico> getListUb3Analitico(bool isAtivo, string grupo, string prdDe, string prdAte)
{
List<Ub3Analitico> lstUb3AntPrd = new List<Ub3Analitico>();
_Context = new Connection(this.ConnectionString);
_Context.AbrirConexao();
qryConsulta = string.Empty;
qryConsulta = SQLCommand.getQryUb3Analitico(isAtivo, prdDe, prdAte, grupo);
try
{
IDataReader reader = _Context.RetornaDados(qryConsulta);
while (reader.Read())
{
Ub3Analitico ub3a = new Ub3Analitico();
ub3a.UNIDADE = reader.GetString(reader.GetOrdinal("UNIDADE"));
ub3a.CC = reader.GetString(reader.GetOrdinal("CC"));
ub3a.DESC_CC = reader.GetString(reader.GetOrdinal("DESC_CC"));
ub3a.UB3_MAT = reader.GetString(reader.GetOrdinal("UB3_MAT"));
ub3a.UB3_DEMIS = reader.GetString(reader.GetOrdinal("UB3_DEMIS"));
ub3a.UB3_ADVMES = reader.GetDouble(reader.GetOrdinal("UB3_ADVMES"));
ub3a.UB3_SUSMES = reader.GetDouble(reader.GetOrdinal("UB3_SUSMES"));
ub3a.UB3_ATMES = reader.GetDouble(reader.GetOrdinal("UB3_ATMES"));
ub3a.UB3_FALMES = reader.GetDouble(reader.GetOrdinal("UB3_FALMES"));
ub3a.UB3_REEMES = reader.GetDouble(reader.GetOrdinal("UB3_REEMES"));
ub3a.UB3_MULTAS = reader.GetDouble(reader.GetOrdinal("UB3_MULTAS"));
ub3a.UB3_ACID = reader.GetDouble(reader.GetOrdinal("UB3_ACID"));
ub3a.UB3_TOTAL = reader.GetDouble(reader.GetOrdinal("UB3_TOTAL"));
lstUb3AntPrd.Add(ub3a);
}
}
catch (Exception) { }
_Context.FechaConexao();
return lstUb3AntPrd;
}
/// <summary>
/// Method responsável por set itens da tabela sintecico.
/// </summary>
/// <param name="ub3a"></param>
/// <returns></returns>
public static string setDadosTableAnlt(Ub3Analitico ub3a)
{
html = new StringBuilder();
html.Append(" <tr class='table_filha_item'>\n");
html.Append(" <td>" + ub3a.CC + "</td>\n");
html.Append(" <td style='width:950px;'>" + ub3a.DESC_CC + "</td>\n");
html.Append(" <td style='width:950px;'>" + ub3a.UB3_MAT + "</td>\n");
html.Append(" <td>" + ub3a.UB3_DEMIS + "</td>\n");
html.Append(" <td class='text-right'>" + ub3a.UB3_ADVMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3a.UB3_SUSMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3a.UB3_ATMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3a.UB3_FALMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3a.UB3_REEMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3a.UB3_MULTAS + "</td>\n");
html.Append(" <td class='text-right'>" + ub3a.UB3_ACID + "</td>\n");
html.Append(" <td class='text-right'>" + ub3a.UB3_TOTAL + "</td>\n");
html.Append(" <td class='text-right'><a href='DetalhesFunce.aspx?mat=" + ub3a.UB3_MAT.Substring(0, 6) + "' class='btn btn-link link-painel' target='_blank'><img src='img/print.png' style='width:15px; height:15px;'/></a></td>\n");
html.Append(" </tr>\n");
return html.ToString();
}