/*
* PROCEDURE SP_INUTILIZACAOINTEGRAR ( P_CURSOR out SYS_REFCURSOR);
* PROCEDURE SP_INUTILIZACAOINTEGRARFILIAL
* (
* P_CURSOR out SYS_REFCURSOR ,
* P_CDENTIFILIAL IN NOTAFISCALINUTNUMERACAO.CDENTIFILIAL%TYPE
* );
* PROCEDURE SP_INUTILIZACAOATUALIZAR
* (
* P_CDNOTAFISCALINUTNUMERACAO IN NOTAFISCALINUTNUMERACAO.CDNOTAFISCALINUTNUMERACAO%TYPE,
* P_CDNFESTATUS IN NOTAFISCALINUTNUMERACAO.CDSTATUS%TYPE,
* P_CDNFESTATUSSEFAZ IN NOTAFISCALINUTNUMERACAO.CDSTATUSSEFAZ%TYPE,
* P_XMLRETORNO IN NOTAFISCALINUTNUMERACAO.XMLRETORNO%TYPE
* ) ;
*/
public DataTable InutilizacaoIntegracao(string datasource, string schema)
{
DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_INUTILIZACAOINTEGRAR", null, "P_CURSOR", OracleHelper.BancoOracle.optimus, datasource, schema);
return(ds.Tables[0]);
}
public int UpdateStatusInutilizacao(int CDNOTAFISCALINUTNUMERACAO, int cdstatus, int cdstatussefaz, string datasource, string schema)
{
string query = string.Format("UPDATE NOTAFISCALINUTNUMERACAO SET CDSTATUS = {0} , CDSTATUSsefaz = {1} WHERE CDNOTAFISCALINUTNUMERACAO = {2}", cdstatus, cdstatussefaz, CDNOTAFISCALINUTNUMERACAO);
return(OracleHelper.ExecProcedureNonQuery(query, null, CommandType.Text, datasource, schema));
}
public int UpdateStatusCC(int cdnotafiscalsaidaCC, int cdstatus, int cdstatussefaz, string datasource, string schema)
{
string query = string.Format("UPDATE NOTAFISCALSAIDACC SET CDSTATUS = {0} , CDSTATUSsefaz = {1} WHERE CDNOTAFISCALSAIDACC = {2}", cdstatus, cdstatussefaz, cdnotafiscalsaidaCC);
return(OracleHelper.ExecProcedureNonQuery(query, null, CommandType.Text, datasource, schema));
}
//public DataTable NotaFiscalBuscarRetorno()
//{
// DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_NOTASFISCAISBUSCARETORNO", null, "P_CURSOR", OracleHelper.BancoOracle.optimus);
// return ds.Tables[0];
//}
public DataTable NotaFiscalBuscarRetorno(string datasource, string schema)
{
DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_NOTASFISCAISBUSCARETORNO", null, "P_CURSOR", OracleHelper.BancoOracle.optimus, datasource, schema);
return(ds.Tables[0]);
}
//public DataTable CartaCorrecaoIntegracao()
//{
// DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_CARTACORRECAOINTEGRAR", null, "P_CURSOR", OracleHelper.BancoOracle.optimus);
// return ds.Tables[0];
//}
public DataTable CartaCorrecaoIntegracao(string datasource, string schema)
{
DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_CARTACORRECAOINTEGRAR", null, "P_CURSOR", OracleHelper.BancoOracle.optimus, datasource, schema);
return(ds.Tables[0]);
}
/// <summary>
/// Atualiza o status da NFE
/// </summary>
/// <param name="cdnotafiscalsaida"></param>
/// <param name="CdStatusNfe"></param>
/// <returns></returns>
public int UpdateStatusNf(string cdnotafiscalsaida, string CdStatusNfe, string datasource, string schema)
{
string query = string.Format("UPDATE NOTAFISCALSAIDA SET CDNFESTATUS = {0} WHERE CDNOTAFISCALSAIDA = {1}", CdStatusNfe, cdnotafiscalsaida);
return(OracleHelper.ExecProcedureNonQuery(query, null, CommandType.Text, datasource, schema));
}
public int NotaFiscalUpdateEmailEnviado(int CdNotaFiscalSaida, int status, string datasource, string schema)
{
string query = string.Format("UPDATE NOTAFISCALSAIDA SET STEMAILENVIADO = {0} ,TSEMAILENVIADO = SYSDATE WHERE CDNOTAFISCALSAIDA ={1}", status, CdNotaFiscalSaida);
return(OracleHelper.ExecProcedureNonQuery(query, null, CommandType.Text, datasource, schema));
}
public DataTable NotaFiscalEnviarEmail(string datasource, string schema)
{
DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_NOTASFISCAISENVIAREMAIL", null, "P_CURSOR", OracleHelper.BancoOracle.optimus, datasource, schema);
return(ds.Tables[0]);
}
//public DataTable NotaFiscalIntegracao()
//{
// DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_NOTASFISCAISINTEGRAR", null, "P_CURSOR", OracleHelper.BancoOracle.optimus);
// return ds.Tables[0];
//}
public DataTable NotaFiscalIntegracao(string datasource, string schema)
{
DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_NOTASFISCAISINTEGRAR", null, "P_CURSOR", OracleHelper.BancoOracle.optimus, datasource, schema);
return(ds.Tables[0]);
}