public DataTable InutilizacaoIntegracaoFilial(int cdentifilial, string datasource, string schema)
{
List <OracleParameter> lstParam = new List <OracleParameter>();
lstParam.Add(new OracleParameter("P_CDENTIFILIAL", cdentifilial));
DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_INUTILIZACAOINTEGRARFILIAL", lstParam, "P_CURSOR", OracleHelper.BancoOracle.optimus, datasource, schema);
return(ds.Tables[0]);
}
//public DataTable NotaFiscalBuscarRetornoFilial(int cdentifilial)
//{
// List<OracleParameter> lstParam = new List<OracleParameter>();
// lstParam.Add(new OracleParameter("P_CDENTIFILIAL", cdentifilial));
// DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_NOTASFISCAISBUSCARETFILIAL", lstParam, "P_CURSOR", OracleHelper.BancoOracle.optimus);
// return ds.Tables[0];
//}
public DataTable NotaFiscalBuscarRetornoFilial(int cdentifilial, string datasource, string schema)
{
List <OracleParameter> lstParam = new List <OracleParameter>();
lstParam.Add(new OracleParameter("P_CDENTIFILIAL", cdentifilial));
DataSet ds = OracleHelper.ExecProcedure("PK_NFE.SP_NOTASFISCAISBUSCARETFILIAL", lstParam, "P_CURSOR", OracleHelper.BancoOracle.optimus, datasource, schema);
return(ds.Tables[0]);
}
/*
* 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 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]);
}
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]);
}