public List<Ub3Sintetico> getListUb3Sintetico(bool isAtivo, string prdDe, string prdAte, string grupo)
{
List<Ub3Sintetico> lstUb3StcPrd = new List<Ub3Sintetico>();
_Context = new Connection(this.ConnectionString);
_Context.AbrirConexao();
qryConsulta = SQLCommand.getQryUb3Sintetico(isAtivo, prdDe, prdAte, grupo);
try
{
IDataReader reader = _Context.RetornaDados(qryConsulta);
while (reader.Read())
{
Ub3Sintetico ub3S = new Ub3Sintetico();
ub3S.DESCRIC = reader.GetString(reader.GetOrdinal("DESCRI"));
ub3S.UB3_ADVMES = reader.GetDouble(reader.GetOrdinal("UB3_ADVMES"));
ub3S.UB3_SUSMES = reader.GetDouble(reader.GetOrdinal("UB3_SUSMES"));
ub3S.UB3_ATMES = reader.GetDouble(reader.GetOrdinal("UB3_ATMES"));
ub3S.UB3_FALMES = reader.GetDouble(reader.GetOrdinal("UB3_FALMES"));
ub3S.UB3_REEMES = reader.GetDouble(reader.GetOrdinal("UB3_REEMES"));
ub3S.UB3_MULTAS = reader.GetDouble(reader.GetOrdinal("UB3_MULTAS"));
ub3S.UB3_ACID = reader.GetDouble(reader.GetOrdinal("UB3_ACID"));
ub3S.UB3_TOTAL = reader.GetDouble(reader.GetOrdinal("UB3_TOTAL"));
lstUb3StcPrd.Add(ub3S);
}
}
catch (Exception) { throw; }
_Context.FechaConexao();
return lstUb3StcPrd;
}
/// <summary>
/// Method responsável por set itens da tabela sintecico.
/// </summary>
/// <param name="ub3a"></param>
/// <returns></returns>
public static string setDadosTableStc(Ub3Sintetico ub3s, string numNo)
{
html = new StringBuilder();
html.Append(" <tr class='treegrid-" + numNo + "'>\n");
html.Append(" <td>" + ub3s.DESCRIC + "</td>\n");
html.Append(" <td class='text-right'>" + ub3s.UB3_ADVMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3s.UB3_SUSMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3s.UB3_ATMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3s.UB3_FALMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3s.UB3_REEMES + "</td>\n");
html.Append(" <td class='text-right'>" + ub3s.UB3_TOTAL + "</td>\n");
html.Append(" </tr>\n");
return html.ToString();
}
