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