public string Deleta(TRegistro_Cad_DataSource val) { Hashtable hs = new Hashtable(1); hs.Add("@P_ID_DATASOURCE", val.ID_DataSource); return(executarProc("EXCLUI_BIN_DATASOURCE", hs)); }
public string Grava(TRegistro_Cad_DataSource val) { Hashtable hs = new Hashtable(4); hs.Add("@P_ID_DATASOURCE", new Guid(val.ID_DataSource)); hs.Add("@P_DS_DATASOURCE", val.DS_DataSource); hs.Add("@P_DS_SQL", val.DS_SQL); return(executarProc("IA_BIN_DATASOURCE", hs)); }
public TList_Cad_DataSource Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { TList_Cad_DataSource lista = new TList_Cad_DataSource(); SqlDataReader reader = null; bool podeFecharBco = false; if (Banco_Dados == null) { this.CriarBanco_Dados(false); podeFecharBco = true; } try { if (vNM_Campo == "") { reader = ExecutarBusca(SqlCodeBusca(vBusca, vTop, "")); } else { reader = ExecutarBusca(SqlCodeBusca(vBusca, vTop, vNM_Campo)); } while (reader.Read()) { TRegistro_Cad_DataSource reg = new TRegistro_Cad_DataSource(); if (!reader.IsDBNull(reader.GetOrdinal("ID_DTS"))) { reg.ID_DataSource = reader.GetGuid(reader.GetOrdinal("ID_DTS")).ToString(); } if (!reader.IsDBNull(reader.GetOrdinal("DS_DTS"))) { reg.DS_DataSource = reader.GetString(reader.GetOrdinal("DS_DTS")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_SQL"))) { reg.DS_SQL = reader.GetString(reader.GetOrdinal("DS_SQL")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_DTS"))) { reg.DT_DataSource = reader.GetDateTime(reader.GetOrdinal("DT_DTS")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } }; return(lista); }