public bool DeleteRecord(Banco_Fields oBanco)
{
//**************
//* Declarações
//**************
DBManager oDBManager = new DBManager(ConnectionString);
string SQL = string.Empty;
//******************************
//* O código do banco é válido?
//******************************
if (oBanco.PK_CodBco != 0)
{
//******************
//* Exclui registro
//******************
SQL = "DELETE FROM banco WHERE CodBco = " + oBanco.PK_CodBco;
oDBManager.ExecuteCommand(SQL);
//*****************************
//* Retorna estado de execução
//*****************************
if (!oDBManager.Error)
{
//*************
//* Retorna OK
//*************
_ErrorText = string.Empty;
_Error = false;
return(true);
}
else
{
//***************
//* Retorna erro
//***************
_ErrorText = oDBManager.ErrorMessage;
_Error = oDBManager.Error;
return(false);
}
}
else
{
//***************
//* Retorna erro
//***************
_ErrorText = "Informe o código do banco.";
_Error = true;
return(false);
}
}
public Int32 ApplyRecord(Banco_Fields oBanco, bool Import = false)
{
//**************
//* Declarações
//**************
DBManager oDBManager = new DBManager(ConnectionString);
string SQL = string.Empty;
//******************************
//* Atualiza ou insere registro
//******************************
SQL = "REPLACE INTO banco (";
SQL += "CodBco,";
SQL += "DescBco,";
SQL += "NroDescBco,";
SQL += "NroAgencia,";
SQL += "NroCedenteAg,";
SQL += "NroConvenio,";
SQL += "NroCarteira,";
SQL += "Instrucao,";
SQL += "Instrucao2,";
SQL += "DvNroAgencia,";
SQL += "RegistroCobranca,";
SQL += "SequenciaRemessa,";
SQL += "CodigoEmpresaBanco";
SQL += ") VALUES (";
SQL += oBanco.PK_CodBco + ",";
SQL += "'" + oBanco.DescBco.SQLFilter() + "',";
SQL += "'" + oBanco.NroDescBco.SQLFilter() + "',";
SQL += "'" + oBanco.NroAgencia.SQLFilter() + "',";
SQL += "'" + oBanco.NroCedenteAg.SQLFilter() + "',";
SQL += "'" + oBanco.NroConvenio.SQLFilter() + "',";
SQL += "'" + oBanco.NroCarteira.SQLFilter() + "',";
SQL += "'" + oBanco.Instrucao.SQLFilter() + "',";
SQL += "'" + oBanco.Instrucao2.SQLFilter() + "',";
SQL += "'" + oBanco.DvNroAgencia.SQLFilter() + "',";
SQL += oBanco.RegistroCobranca + ",";
SQL += oBanco.SequenciaRemessa + ",";
SQL += "'" + oBanco.CodigoEmpresaBanco.SQLFilter() + "')";
//****************************
//* Controla erro de execução
//****************************
try
{
//**************************
//* Executa comando formado
//**************************
oBanco.PK_CodBco = oDBManager.ExecuteCommand(SQL, Import);
//************************************
//* Devolve status e mensagem de erro
//************************************
_ErrorText = oDBManager.ErrorMessage;
_Error = oDBManager.Error;
}
catch (Exception oException)
{
//************************************
//* Devolve status e mensagem de erro
//************************************
_ErrorText = oException.Message;
_Error = true;
}
//*************************
//* Retorna chave primária
//*************************
return(oBanco.PK_CodBco);
}
public Banco_Fields GetRecord(Int32 CodBanco)
{
//**************
//* Declarações
//**************
Banco_Fields oBanco = new Banco_Fields();
DBManager oDBManager = new DBManager(ConnectionString);
DataTable oTable = new DataTable();
string SQL = string.Empty;
//****************************
//* Controla erro de execução
//****************************
try
{
//*****************
//* Obtem registro
//*****************
SQL = "SELECT * FROM banco WHERE CodBco = " + CodBanco;
oTable = oDBManager.ExecuteQuery(SQL);
//************************************
//* Devolve status e mensagem de erro
//************************************
_ErrorText = oDBManager.ErrorMessage;
_Error = oDBManager.Error;
}
catch (Exception oException)
{
//************************************
//* Devolve status e mensagem de erro
//************************************
_ErrorText = oException.Message;
_Error = true;
}
//*********************************
//* A pesquisa retornou registros?
//*********************************
if (oTable != null)
{
//***********************************
//* A pesquisa localizou o registro?
//***********************************
if (oTable.Rows.Count == 1)
{
//*******************************
//* Copia dados para a estrutura
//*******************************
DataRow oRow = oTable.Rows[0];
oBanco.PK_CodBco = !DBNull.Value.Equals(oRow["CodBco"]) ? Convert.ToInt32("0" + oRow["CodBco"]) : 0;
oBanco.DescBco = !DBNull.Value.Equals(oRow["DescBco"]) ? oRow["DescBco"].ToString() : string.Empty;
oBanco.NroDescBco = !DBNull.Value.Equals(oRow["NroDescBco"]) ? oRow["NroDescBco"].ToString() : string.Empty;
oBanco.NroAgencia = !DBNull.Value.Equals(oRow["NroAgencia"]) ? oRow["NroAgencia"].ToString() : string.Empty;
oBanco.NroCedenteAg = !DBNull.Value.Equals(oRow["NroCedenteAg"]) ? oRow["NroCedenteAg"].ToString() : string.Empty;
oBanco.NroConvenio = !DBNull.Value.Equals(oRow["NroConvenio"]) ? oRow["NroConvenio"].ToString() : string.Empty;
oBanco.NroCarteira = !DBNull.Value.Equals(oRow["NroCarteira"]) ? oRow["NroCarteira"].ToString() : string.Empty;
oBanco.Instrucao = !DBNull.Value.Equals(oRow["Instrucao"]) ? oRow["Instrucao"].ToString() : string.Empty;
oBanco.Instrucao2 = !DBNull.Value.Equals(oRow["Instrucao2"]) ? oRow["Instrucao2"].ToString() : string.Empty;
oBanco.DvNroAgencia = !DBNull.Value.Equals(oRow["DvNroAgencia"]) ? oRow["DvNroAgencia"].ToString() : string.Empty;
oBanco.RegistroCobranca = !DBNull.Value.Equals(oRow["RegistroCobranca"]) ? Convert.ToInt16("0" + oRow["RegistroCobranca"]) : (Int16)0;
oBanco.SequenciaRemessa = !DBNull.Value.Equals(oRow["SequenciaRemessa"]) ? Convert.ToInt32("0" + oRow["SequenciaRemessa"]) : 0;
oBanco.CodigoEmpresaBanco = !DBNull.Value.Equals(oRow["CodigoEmpresaBanco"]) ? oRow["CodigoEmpresaBanco"].ToString() : string.Empty;
}
}
else
{
//************************************
//* Devolve status e mensagem de erro
//************************************
_ErrorText = "O resultado da pesquisa retornou nulo";
_Error = true;
}
//****************
//* Retorna dados
//****************
return(oBanco);
}
