本文整理汇总了C#中IDbCommand.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# IDbCommand.Dispose方法的具体用法?C# IDbCommand.Dispose怎么用?C# IDbCommand.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IDbCommand
的用法示例。
在下文中一共展示了IDbCommand.Dispose方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Criar
internal void Criar(Uf v_oUf)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBPRO021(");
sbSQL.Append("CDUNDDFEDR,");
sbSQL.Append("NMUNDDFEDR");
sbSQL.Append(") VALUES (");
sbSQL.Append(":CDUNDDFEDR,");
sbSQL.Append(":NMUNDDFEDR");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("CDUNDDFEDR").ToString(), v_oUf.Sigla);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NMUNDDFEDR").ToString(), v_oUf.Nome);
oCmd.ExecuteNonQuery();
v_oUf.Codigo = ObterNovoCodigo(oCmd, "SEQTBPRO021");
oCmd.Dispose();
}
catch (Exception ex)
{
throw new Dor.Util.OperacaoInvalidaBD(ex);
}
}
示例2: Criar
internal void Criar(Operacao v_oOperacao)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBPRO020(");
sbSQL.Append("DSAPLDOPRC,");
sbSQL.Append("NMOPRC");
sbSQL.Append(") VALUES (");
sbSQL.Append(":DSAPLDOPRC,");
sbSQL.Append(":NMOPRC");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DSAPLDOPRC").ToString(), v_oOperacao.Apelido);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NMOPRC").ToString(), v_oOperacao.Nome);
oCmd.ExecuteNonQuery();
v_oOperacao.Codigo = ObterNovoCodigo(oCmd, "SEQTBPRO020");
oCmd.Dispose();
}
catch (Exception ex)
{
throw new Dor.Util.OperacaoInvalidaBD(ex);
}
}
示例3: Criar
internal void Criar(PerfilFuncao v_oPerfilFuncao)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBPRO033(");
sbSQL.Append("IDPRO016,");
sbSQL.Append("IDPRO031");
sbSQL.Append(") VALUES (");
sbSQL.Append(":IDPRO016,");
sbSQL.Append(":IDPRO031");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO016").ToString(), v_oPerfilFuncao.CodigoPerfil);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO031").ToString(), v_oPerfilFuncao.CodigoFuncao);
oCmd.ExecuteNonQuery();
v_oPerfilFuncao.Codigo = ObterNovoCodigo(oCmd, "SEQTBPRO033");
oCmd.Dispose();
}
catch (Exception ex)
{
throw new Dor.Util.OperacaoInvalidaBD(ex);
}
}
示例4: Start
// Use this for initialization
void Start()
{
OpenDB("MakingTime.db");
_dbcm = _dbc.CreateCommand();
//Insert data
sqlQuery = "INSERT INTO Event (name,current_day,current_time,min_day,max_day,min_time,max_time,scheduled,creator,type) VALUES ('Date',1,1,0,3,2,3,1,'Robert','Social')";
_dbcm.CommandText = sqlQuery;
_dbcm.ExecuteNonQuery();
sqlQuery = "INSERT INTO Event (name,current_day,current_time,min_day,max_day,min_time,max_time,scheduled,creator,type) VALUES ('Party',1,1,0,3,2,3,1,'Gina','Social')";
_dbcm.CommandText = sqlQuery;
_dbcm.ExecuteNonQuery();
sqlQuery = "INSERT INTO Event (name,current_day,current_time,min_day,max_day,min_time,max_time,scheduled,creator,type) VALUES ('Movie',1,1,0,3,2,3,1,'Robert','Social')";
_dbcm.CommandText = sqlQuery;
_dbcm.ExecuteNonQuery();
sqlQuery = "select * from Event";
_dbcm.CommandText = sqlQuery;
_dbr = _dbcm.ExecuteReader();
while (_dbr.Read())
{
Debug.Log("****** Data: " + _dbr["name"] + "\tday: " + _dbr["current_day"] + "\tTime: " + _dbr["current_time"] + "\tMin Day: " + _dbr["min_day"]
+ "\tMax Day: " + _dbr["max_day"] + "\tMin Time: " + _dbr["min_time"] + "\tMax Time: " + _dbr["max_time"] + "\tScheduled: " + _dbr["scheduled"]
+ "\tcreator: " + _dbr["creator"] + "\ttype: " + _dbr["type"]);
}
_dbr.Close();
_dbr = null;
_dbcm.Dispose();
_dbcm = null;
_dbc.Close();
_dbc = null;
}
示例5: Criar
internal void Criar(Sumario_Procedimento v_oSumario_Procedimento)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBINT063(");
sbSQL.Append("IDINT058,");
sbSQL.Append("DSPRC,");
sbSQL.Append("DTPRC");
sbSQL.Append(") VALUES (");
sbSQL.Append(":IDINT058,");
sbSQL.Append(":DSPRC,");
sbSQL.Append(":DTPRC");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDINT058").ToString(), Convert.ToInt32(UtSessao.Sessao["Id058"]));
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DSPRC").ToString(), v_oSumario_Procedimento.nome);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DTPRC").ToString(), v_oSumario_Procedimento.dtprc);
oCmd.ExecuteNonQuery();
v_oSumario_Procedimento.Codigo = ObterNovoCodigo(oCmd, "SEQTBINT063");
oCmd.Dispose();
}
catch (Exception en)
{
throw new Dor.Util.OperacaoInvalidaBD(en);
}
}
示例6: ReadRandomNewCommitment
public static void ReadRandomNewCommitment(string event_Type, ref string name, ref int time_Length,
ref int maxTime, ref int minTime)
{
OpenDB("MakingTime.db");
_dbcm = _dbc.CreateCommand();
sqlQuery = "select count(*) as NumberOfRegions from Event_Type where Category = '" + event_Type + "'";
_dbcm.CommandText = sqlQuery;
Int32 rows = Convert.ToInt32(_dbcm.ExecuteScalar());
sqlQuery = "select * from Event_Type where Category = '" + event_Type + "'";
_dbcm.CommandText = sqlQuery;
_dbr = _dbcm.ExecuteReader();
int commitmentRow = UnityEngine.Random.Range(0, rows);
//Question
for(int countRows = 0; countRows < commitmentRow + 1; countRows += 1)
{
_dbr.Read();
}
name = _dbr.GetString(0);
time_Length = _dbr.GetInt32(1);
maxTime = _dbr.GetInt32(8);
minTime = _dbr.GetInt32(7);
_dbr.Close();
_dbr = null;
_dbcm.Dispose();
_dbcm = null;
_dbc.Close();
_dbc = null;
}
示例7: CleanUp
public static void CleanUp(IDataReader pmReader, IDbCommand pmCommand, IDbConnection pmConnection)
{
if (pmReader != null)
pmReader.Close ();
if (pmCommand != null)
pmCommand.Dispose ();
if (pmConnection != null)
pmConnection.Close ();
}
示例8: DoDisposeCommand
private static void DoDisposeCommand(IDbCommand command)
{
try
{
command.Dispose();
}
catch (Exception e)
{
LOG.Warn("Could not dispose of command", e);
}
}
示例9: Criar
internal void Criar(Sumario_Receituario v_oSumario_Receituario)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBINT070(");
sbSQL.Append("IDINT058,");
sbSQL.Append("COD_PRD,");
sbSQL.Append("DESCRICAO_PRODUTO,");
sbSQL.Append("DESCRICAO_DOSE,");
sbSQL.Append("DESCRICAO_VIA,");
sbSQL.Append("DESCRICAO_FREQUENCIA,");
sbSQL.Append("DESCRICAO_DURACAO,");
sbSQL.Append("ULTIMA_DOSE");
sbSQL.Append(") VALUES (");
sbSQL.Append(":IDINT058,");
sbSQL.Append(":COD_PRD,");
sbSQL.Append(":DESCRICAO_PRODUTO,");
sbSQL.Append(":DESCRICAO_DOSE,");
sbSQL.Append(":DESCRICAO_VIA,");
sbSQL.Append(":DESCRICAO_FREQUENCIA,");
sbSQL.Append(":DESCRICAO_DURACAO,");
sbSQL.Append(":ULTIMA_DOSE");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDINT058").ToString(), Convert.ToInt32(UtSessao.Sessao["Id058"]));
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("COD_PRD").ToString(), v_oSumario_Receituario.cod_prd);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DESCRICAO_PRODUTO").ToString(), v_oSumario_Receituario.desc_produto);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DESCRICAO_DOSE").ToString(), v_oSumario_Receituario.desc_dose);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DESCRICAO_VIA").ToString(), v_oSumario_Receituario.desc_via);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DESCRICAO_FREQUENCIA").ToString(), v_oSumario_Receituario.desc_frequencia);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DESCRICAO_DURACAO").ToString(), v_oSumario_Receituario.desc_duracao);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("ULTIMA_DOSE").ToString(), v_oSumario_Receituario.ult_dose);
oCmd.ExecuteNonQuery();
v_oSumario_Receituario.Codigo = ObterNovoCodigo(oCmd, "SEQTBINT070");
oCmd.Dispose();
}
catch (Exception en)
{
throw new Dor.Util.OperacaoInvalidaBD(en);
}
}
示例10: DisposeCommand
public static void DisposeCommand(IDbCommand pCommand)
{
try
{
if (pCommand != null)
{
pCommand.Dispose();
}
}
catch
{
throw;
}
}
示例11: Criar
internal void Criar(Empresa v_oEmpresa)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBPRO012(");
sbSQL.Append("CDCNPJ,");
sbSQL.Append("DSURL,");
sbSQL.Append("IDPRO010,");
sbSQL.Append("IDPRO011,");
sbSQL.Append("NMFANT,");
sbSQL.Append("NMRAZASOCL,");
sbSQL.Append("IDSUBEMPR");
sbSQL.Append(") VALUES (");
sbSQL.Append(":CDCNPJ,");
sbSQL.Append(":DSURL,");
sbSQL.Append(":IDPRO010,");
sbSQL.Append(":IDPRO011,");
sbSQL.Append(":NMFANT,");
sbSQL.Append(":NMRAZASOCL,");
sbSQL.Append(":IDSUBEMPR");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("CDCNPJ").ToString(), v_oEmpresa.CNPJ);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DSURL").ToString(), v_oEmpresa.Url);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO010").ToString(), v_oEmpresa.Endereco.Codigo);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO011").ToString(), v_oEmpresa.Telefone.Codigo);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NMFANT").ToString(), v_oEmpresa.Nome);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NMRAZASOCL").ToString(), v_oEmpresa.RazaoSocial);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDSUBEMPR").ToString(), v_oEmpresa.SubEmpresa);
oCmd.ExecuteNonQuery();
v_oEmpresa.Codigo = ObterNovoCodigo(oCmd, "SEQTBPRO012");
oCmd.Dispose();
}
catch (Exception ex)
{
throw new Dor.Util.OperacaoInvalidaBD(ex);
}
}
示例12: Criar
internal void Criar(Endereco v_oEndereco)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBPRO010(");
sbSQL.Append("CDCEP,");
sbSQL.Append("DSCOMP,");
sbSQL.Append("IDPRO021,");
sbSQL.Append("NMBARR,");
sbSQL.Append("NMCIDD,");
sbSQL.Append("NMLOGR,");
sbSQL.Append("NRNUMR");
sbSQL.Append(") VALUES (");
sbSQL.Append(":CDCEP,");
sbSQL.Append(":DSCOMP,");
sbSQL.Append(":IDPRO021,");
sbSQL.Append(":NMBARR,");
sbSQL.Append(":NMCIDD,");
sbSQL.Append(":NMLOGR,");
sbSQL.Append(":NRNUMR");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("CDCEP").ToString(), v_oEndereco.Cep);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DSCOMP").ToString(), v_oEndereco.Complemento);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO021").ToString(), v_oEndereco.CodigoUF);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NMBARR").ToString(), v_oEndereco.Bairro);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NMCIDD").ToString(), v_oEndereco.Cidade);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NMLOGR").ToString(), v_oEndereco.Logradouro);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NRNUMR").ToString(), v_oEndereco.Numero);
oCmd.ExecuteNonQuery();
v_oEndereco.Codigo = ObterNovoCodigo(oCmd, "SEQTBPRO010");
oCmd.Dispose();
}
catch (Exception ex)
{
throw new Dor.Util.OperacaoInvalidaBD(ex);
}
}
示例13: Criar
internal void Criar(Log v_oLog)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBPRO019(");
sbSQL.Append("DSOBSR,");
sbSQL.Append("DTLOG,");
sbSQL.Append("HRLOG,");
sbSQL.Append("IDPRO015,");
sbSQL.Append("IDPRO020");
sbSQL.Append(") VALUES (");
sbSQL.Append(":DSOBSR,");
sbSQL.Append(":DTLOG,");
sbSQL.Append(":HRLOG,");
sbSQL.Append(":IDPRO015,");
sbSQL.Append(":IDPRO020");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DSOBSR").ToString(), v_oLog.Observacao);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DTLOG").ToString(), v_oLog.Data);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("HRLOG").ToString(), v_oLog.Hora);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO015").ToString(), v_oLog.CodigoUsuario);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO020").ToString(), v_oLog.CodigoOperacao);
oCmd.ExecuteNonQuery();
v_oLog.Codigo = ObterNovoCodigo(oCmd, "SEQTBPRO019");
oCmd.Dispose();
}
catch (Exception ex)
{
throw new Dor.Util.OperacaoInvalidaBD(ex);
}
}
示例14: _loadBusinessEvents
private TokensEvents[] _loadBusinessEvents(IDbCommand cmd, out int totRows)
{
totRows = -1;
IDataReader _dr = null;
List<TokensEvents> _tokensEvents = new List<TokensEvents>();
TokensEvents[] result;
try
{
base.Connection.Open();
_dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (_dr.Read())
{
_tokensEvents.Add(this._buildBusinessEventRequest(_dr, false));
}
this.GetTotRows(cmd, out totRows);
result = _tokensEvents.ToArray();
}
catch (Exception ex)
{
SAFLOGGER.Write(SAFLOGGER.LOGGEREventID.EXCEPTION, "SAFBUSINESS", new string[]
{
"http://sfexpand.SAFBusiness.TokenBusinessDAO.softfinanca.com/",
Assembly.GetExecutingAssembly().FullName.ToString(),
ex.ToString()
});
result = null;
}
finally
{
if (_dr != null)
{
_dr.Dispose();
}
if (cmd != null)
{
cmd.Dispose();
}
base.CloseConnection();
}
return result;
}
示例15: Criar
internal void Criar(Funcao v_oFuncao)
{
try
{
sbSQL.Length = 0;
sbSQL.Append("INSERT INTO TBPRO031(");
sbSQL.Append("DSAPLDFUNC,");
sbSQL.Append("IDPRO039,");
sbSQL.Append("IDPRO042,");
sbSQL.Append("NMFUNC,");
sbSQL.Append("IDPRO018");
sbSQL.Append(") VALUES (");
sbSQL.Append(":DSAPLDFUNC,");
sbSQL.Append(":IDPRO039,");
sbSQL.Append(":IDPRO042,");
sbSQL.Append(":NMFUNC,");
sbSQL.Append(":IDPRO018");
sbSQL.Append(")");
sbSQL = TratarSQLParametroBanco(sbSQL.ToString());
oCmd = ObterCommand(sbSQL.ToString());
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("DSAPLDFUNC").ToString(), v_oFuncao.Apelido);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO039").ToString(), v_oFuncao.CodigoMenu);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO042").ToString(), v_oFuncao.CodigoClasse);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("NMFUNC").ToString(), v_oFuncao.Nome);
UtDbNet.AdicionarParametro(oCmd, TratarSQLParametroBanco("IDPRO018").ToString(), v_oFuncao.CodigoProjeto);
oCmd.ExecuteNonQuery();
v_oFuncao.Codigo = ObterNovoCodigo(oCmd, "SEQTBPRO031");
oCmd.Dispose();
}
catch (Exception ex)
{
throw new Dor.Util.OperacaoInvalidaBD(ex);
}
}