//public int NotaFiscalAtualizarNota(
// int CdNotaFiscalSaida,
// string xmlNFe,
// string xmlAutorizacao,
// string autMotivo,
// string chaveNfe,
// string NrNota,
// string NrSerie,
// string dtEmissaoNf,
// string TipoPessoa,
// string EMI_CNPJ,
// string CLI_CPF_CNPJ,
// string dtRetornoSefaz,
// string NumeroProtocolo,
// string StatusNfe,
// string xmlCancelamento,
// string xmlAutCancelamento,
// TipoNFe tpnfe)
//{
// StringBuilder NotaFiscalSaida = new StringBuilder();
// List<string> partes = new List<string>();
// string TipoEmissao = "1"; //1 normal 4 depec
// string texto = Convert.ToString(xmlNFe);
// int quantidadeTotal = texto.Length;
// int quantidadePermitida = 30000;
// int quantidadePartes = quantidadeTotal / quantidadePermitida;
// int quantidadeRestante = quantidadeTotal % quantidadePermitida;
// if (quantidadeTotal > quantidadePermitida)
// {
// for (int i = 0; i < quantidadePartes; i++)
// partes.Add(texto.Substring(i == 0 ? i : (i * quantidadePermitida) + 1, quantidadePermitida));
// if (quantidadeRestante > 0)
// partes.Add(texto.Substring(quantidadeTotal - quantidadeRestante, quantidadeRestante));
// }
// else
// {
// partes.Add(xmlNFe);
// }
// NotaFiscalSaida.Append("DECLARE ");
// if (tpnfe == TipoNFe.Inclusao)
// {
// NotaFiscalSaida.Append(" Vtxfilenfe Clob; ");
// NotaFiscalSaida.Append(" Vtxfilenfeaut Clob; ");
// NotaFiscalSaida.Append(" Vtxnferetorno Clob; ");
// }
// else
// {
// NotaFiscalSaida.Append(" Vtxfilenfecanc Clob; ");
// }
// NotaFiscalSaida.Append(" Vtxfilenfeoutros Clob; ");
// NotaFiscalSaida.Append("BEGIN ");
// if (tpnfe == TipoNFe.Inclusao)
// {
// /*************************************************Juntando as partes para executar query***********************************************************************/
// for (int i = 0; i < partes.Count; i++)
// {
// if (i == 0)
// NotaFiscalSaida.Append(" Vtxfilenfe := to_Clob('" + partes[i] + "');");
// else
// NotaFiscalSaida.Append(" DBMS_LOB.writeappend (Vtxfilenfe,LENGTH ('" + partes[i] + "'), '" + partes[i] + "');");
// }
// /**************************************************************************************************************************************************************/
// NotaFiscalSaida.Append(" Vtxfilenfeaut := To_Clob('" + xmlAutorizacao + "');");
// NotaFiscalSaida.Append(" Vtxnferetorno := To_Clob('" + autMotivo + "'); ");
// }
// else
// {
// NotaFiscalSaida.Append(" Vtxfilenfecanc := To_Clob('" + xmlCancelamento + "');");
// }
// //NotaFiscalSaida.Append(" Vtxfilenfeoutros := To_Clob('" + Convert.ToString(Retorno["XML_DADOSADIC"]) + "');");
// NotaFiscalSaida.Append(" Update Notafiscalsaida SET ");
// if (tpnfe == TipoNFe.Inclusao)
// {
// NotaFiscalSaida.Append(" Txfilenfe = Vtxfilenfe, ");
// NotaFiscalSaida.Append(" Txfilenfeaut = Vtxfilenfeaut, ");
// NotaFiscalSaida.Append(" Nrnfechave = '" + chaveNfe + "', ");
// NotaFiscalSaida.Append(" CDNFETIPOEMISSAO = '" + TipoEmissao + "', ");
// NotaFiscalSaida.Append(" Tsnfeautorizacao = To_Date('" + dtRetornoSefaz + "', 'DD/MM/YYYY HH24:MI:SS'), ");
// NotaFiscalSaida.Append(" Nrnfeautorizacao = '" + NumeroProtocolo + "', ");
// NotaFiscalSaida.Append(" Txnferetorno = Vtxnferetorno ,");
// }
// else
// {
// NotaFiscalSaida.Append(" Txfilenfecanc = Vtxfilenfecanc, ");
// if (StatusNfe == "100")
// {
// NotaFiscalSaida.Append(" stnfsaida = 0, ");
// }
// }
// //NotaFiscalSaida.Append(" Txfilenfeoutros = Vtxfilenfeoutros, ");
// NotaFiscalSaida.Append(" Cdnfestatus = '" + StatusNfe + "'");
// //NotaFiscalSaida.Append(" Where Nrnota = '" + NrNota + "' ");
// NotaFiscalSaida.Append(" Where ");
// //NotaFiscalSaida.Append(" And Cdserie = '" + NrSerie + "' ");
// NotaFiscalSaida.Append(" Cdnotafiscalsaida = " + CdNotaFiscalSaida + "; ");
// //NotaFiscalSaida.Append(" And trunc(DTEMISSAO) = To_Date('" + dtEmissaoNf + "','DD/MM/YYYY') ");
// //if (TipoPessoa.Equals("J"))
// // NotaFiscalSaida.Append("And CDENTIDADE = (select max(Cdentipj) from pessjuridica pj, entidade e where pj.cdentipj = e.cdentidade and e.stexcluido = 0 and pj.cnpj = '" + CLI_CPF_CNPJ + "') ");
// //else
// // NotaFiscalSaida.Append("And CDENTIDADE = (select max(CDENTIPF) from pessfisica pf, entidade e where pf.cdentipf = e.cdentidade and e.stexcluido = 0 and pf.cpf = '" + CLI_CPF_CNPJ + "' ) ");
// //NotaFiscalSaida.Append("And Cdentifilial = (select max(Cdentipj) from pessjuridica pj, entidade e where pj.cdentipj = e.cdentidade and e.stexcluido = 0 and pj.cnpj = '" + EMI_CNPJ + "'); ");
// NotaFiscalSaida.Append(" END;");
// //RJS.Optimus.Biblioteca.RJSOptimusLog.GravaLogEventViewer("NFE OPTIMUS QUERY", NotaFiscalSaida.ToString(), System.Diagnostics.EventLogEntryType.Information);
// string aaaa = NotaFiscalSaida.ToString();
// return OracleHelper.ExecProcedureNonQuery(NotaFiscalSaida.ToString(), null, OracleHelper.BancoOracle.optimus);
//}
public int NotasFiscalSaidaAtualizarProc(
int _CDNOTAFISCALSAIDA,
string _XMLNFE,
string _XMLAUTORIZACAO,
string _AUTMOTIVO,
DateTime _DTRETORNOSEFAZ,
string _NUMEROPROTOCOLO,
string _STATUSNFE,
string _XMLCANCELAMENTO,
string _XMLAUTCANCELAMENTO,
string _datasource,
string _schema
)
{
List <OracleParameter> lstParam = new List <OracleParameter>();
lstParam.Add(new OracleParameter("P_CDNOTAFISCALSAIDA", _CDNOTAFISCALSAIDA));
lstParam.Add(new OracleParameter("P_TXFILENFE", OracleDbType.Clob, _XMLNFE, ParameterDirection.Input));
lstParam.Add(new OracleParameter("P_TXFILENFEAUT", OracleDbType.Clob, _XMLAUTORIZACAO, ParameterDirection.Input));
lstParam.Add(new OracleParameter("P_TXNFERETORNO", _AUTMOTIVO));
lstParam.Add(new OracleParameter("P_NRNFEAUTORIZACAO", _NUMEROPROTOCOLO));
lstParam.Add(new OracleParameter("P_TSNFEAUTORIZACAO", OracleDbType.Date, _DTRETORNOSEFAZ, ParameterDirection.Input));
lstParam.Add(new OracleParameter("P_TXFILENFECANC", OracleDbType.Clob, _XMLCANCELAMENTO, ParameterDirection.Input));
lstParam.Add(new OracleParameter("P_TXFILENFECANCAUT", OracleDbType.Clob, _XMLAUTCANCELAMENTO, ParameterDirection.Input));
lstParam.Add(new OracleParameter("P_CDNFESTATUS", _STATUSNFE));
return(Convert.ToInt32(OracleHelper.ExecProcedureScalarTrans("PK_NFE.SP_ATUALIZANOTASAIDA", lstParam, CommandType.StoredProcedure, OracleHelper.BancoOracle.optimus, _datasource, _schema)));
}
public int InutilizacaoUpdate(int CDNOTAFISCALINUTNUMERACAO, int CDNFESTATUS, int CDNFESTATUSSEFAZ, string XMLRETORNO, string datasource, string schema)
{
List <OracleParameter> lstParam = new List <OracleParameter>();
lstParam.Add(new OracleParameter("P_CDNOTAFISCALINUTNUMERACAO", CDNOTAFISCALINUTNUMERACAO));
lstParam.Add(new OracleParameter("P_CDNFESTATUS", CDNFESTATUS));
lstParam.Add(new OracleParameter("P_CDNFESTATUSSEFAZ", CDNFESTATUSSEFAZ));
lstParam.Add(new OracleParameter("P_XMLRETORNO", OracleDbType.Clob, XMLRETORNO, ParameterDirection.Input));
return(Convert.ToInt32(OracleHelper.ExecProcedureScalarTrans("PK_NFE.SP_INUTILIZACAOATUALIZAR", lstParam, CommandType.StoredProcedure, OracleHelper.BancoOracle.optimus, datasource, schema)));
}
//public int NotasFiscalEntradaInsert(NFE _NFE)
//{
// List<OracleParameter> lstParam = new List<OracleParameter>();
// lstParam.Add(new OracleParameter("XML_NFE", OracleDbType.Clob, _NFE.XML_NFE, ParameterDirection.Input));
// lstParam.Add(new OracleParameter("XML_AUT", OracleDbType.Clob, _NFE.XML_AUT, ParameterDirection.Input));
// lstParam.Add(new OracleParameter("XML_CANC", OracleDbType.Clob, _NFE.XML_CANC, ParameterDirection.Input));
// lstParam.Add(new OracleParameter("XML_DADOSADIC", OracleDbType.Clob, _NFE.XML_DADOSADIC, ParameterDirection.Input));
// lstParam.Add(new OracleParameter("IDE_SERIE", _NFE.IDE_SERIE));
// lstParam.Add(new OracleParameter("IDE_NNF", _NFE.IDE_NNF));
// lstParam.Add(new OracleParameter("IDE_DEMI", OracleDbType.Date, _NFE.IDE_DEMI, ParameterDirection.Input));
// lstParam.Add(new OracleParameter("EMIT_CNPJ", _NFE.EMIT_CNPJ));
// lstParam.Add(new OracleParameter("DEST_CNPJ", _NFE.DEST_CNPJ));
// lstParam.Add(new OracleParameter("DEST_CPF", _NFE.DEST_CPF));
// lstParam.Add(new OracleParameter("IDE_CUF", _NFE.IDE_CUF));
// lstParam.Add(new OracleParameter("IDE_MOD", _NFE.IDE_MOD));
// lstParam.Add(new OracleParameter("IDE_CNF", _NFE.IDE_CNF));
// lstParam.Add(new OracleParameter("EMIT_IE", _NFE.EMIT_IE));
// lstParam.Add(new OracleParameter("DEST_IE", _NFE.DEST_IE));
// lstParam.Add(new OracleParameter("DEST_ENDERDEST_UF", _NFE.DEST_ENDERDEST_UF));
// lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VBC", _NFE.TOTAL_ICMSTOT_VBC));
// lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VBCST", _NFE.TOTAL_ICMSTOT_VBCST));
// lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VPROD", _NFE.TOTAL_ICMSTOT_VPROD));
// lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VICMS", _NFE.TOTAL_ICMSTOT_VICMS));
// lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VST", _NFE.TOTAL_ICMSTOT_VST));
// lstParam.Add(new OracleParameter("TOTAL_ISSQNTOT_VBC", _NFE.TOTAL_ISSQNTOT_VBC));
// lstParam.Add(new OracleParameter("TRANSP_TRANSPORTA_CNPJ", _NFE.TRANSP_TRANSPORTA_CNPJ));
// lstParam.Add(new OracleParameter("TRANSP_IE", _NFE.TRANSP_IE));
// lstParam.Add(new OracleParameter("TRANSP_VEICTRANSP_PLACA", _NFE.TRANSP_VEICTRANSP_PLACA));
// lstParam.Add(new OracleParameter("IDE_ID", _NFE.IDE_ID));
// lstParam.Add(new OracleParameter("IDE_TPEMIS", _NFE.IDE_TPEMIS));
// lstParam.Add(new OracleParameter("STATUSNFE", _NFE.STATUSNFE));
// lstParam.Add(new OracleParameter("DOCSEQUENCE", _NFE.DOCSEQUENCE));
// lstParam.Add(new OracleParameter("IDEID1", _NFE.IDEID1));
// lstParam.Add(new OracleParameter("IDEID2", _NFE.IDEID2));
// lstParam.Add(new OracleParameter("IDEID3", _NFE.IDEID3));
// lstParam.Add(new OracleParameter("IDE_ID_RELATED", _NFE.IDE_ID_RELATED));
// return Convert.ToInt32(OracleHelper.ExecProcedureScalarTrans("PK_NFE.SP_INSERT_NFE", lstParam, CommandType.StoredProcedure, OracleHelper.BancoOracle.optimus));
//}
public int NotasFiscalEntradaInsert(NFE _NFE, string datasource, string schema)
{
List <OracleParameter> lstParam = new List <OracleParameter>();
lstParam.Add(new OracleParameter("XML_NFE", OracleDbType.Clob, _NFE.XML_NFE, ParameterDirection.Input));
lstParam.Add(new OracleParameter("XML_AUT", OracleDbType.Clob, _NFE.XML_AUT, ParameterDirection.Input));
lstParam.Add(new OracleParameter("XML_CANC", OracleDbType.Clob, _NFE.XML_CANC, ParameterDirection.Input));
lstParam.Add(new OracleParameter("XML_DADOSADIC", OracleDbType.Clob, _NFE.XML_DADOSADIC, ParameterDirection.Input));
lstParam.Add(new OracleParameter("IDE_SERIE", _NFE.IDE_SERIE));
lstParam.Add(new OracleParameter("IDE_NNF", _NFE.IDE_NNF));
lstParam.Add(new OracleParameter("IDE_DEMI", OracleDbType.Date, _NFE.IDE_DEMI, ParameterDirection.Input));
lstParam.Add(new OracleParameter("EMIT_CNPJ", _NFE.EMIT_CNPJ));
lstParam.Add(new OracleParameter("DEST_CNPJ", _NFE.DEST_CNPJ));
lstParam.Add(new OracleParameter("DEST_CPF", _NFE.DEST_CPF));
lstParam.Add(new OracleParameter("IDE_CUF", _NFE.IDE_CUF));
lstParam.Add(new OracleParameter("IDE_MOD", _NFE.IDE_MOD));
lstParam.Add(new OracleParameter("IDE_CNF", _NFE.IDE_CNF));
lstParam.Add(new OracleParameter("EMIT_IE", _NFE.EMIT_IE));
lstParam.Add(new OracleParameter("DEST_IE", _NFE.DEST_IE));
lstParam.Add(new OracleParameter("DEST_ENDERDEST_UF", _NFE.DEST_ENDERDEST_UF));
lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VBC", _NFE.TOTAL_ICMSTOT_VBC));
lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VBCST", _NFE.TOTAL_ICMSTOT_VBCST));
lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VPROD", _NFE.TOTAL_ICMSTOT_VPROD));
lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VICMS", _NFE.TOTAL_ICMSTOT_VICMS));
lstParam.Add(new OracleParameter("TOTAL_ICMSTOT_VST", _NFE.TOTAL_ICMSTOT_VST));
lstParam.Add(new OracleParameter("TOTAL_ISSQNTOT_VBC", _NFE.TOTAL_ISSQNTOT_VBC));
lstParam.Add(new OracleParameter("TRANSP_TRANSPORTA_CNPJ", _NFE.TRANSP_TRANSPORTA_CNPJ));
lstParam.Add(new OracleParameter("TRANSP_IE", _NFE.TRANSP_IE));
lstParam.Add(new OracleParameter("TRANSP_VEICTRANSP_PLACA", _NFE.TRANSP_VEICTRANSP_PLACA));
lstParam.Add(new OracleParameter("IDE_ID", _NFE.IDE_ID));
lstParam.Add(new OracleParameter("IDE_TPEMIS", _NFE.IDE_TPEMIS));
lstParam.Add(new OracleParameter("STATUSNFE", _NFE.STATUSNFE));
lstParam.Add(new OracleParameter("DOCSEQUENCE", _NFE.DOCSEQUENCE));
lstParam.Add(new OracleParameter("IDEID1", _NFE.IDEID1));
lstParam.Add(new OracleParameter("IDEID2", _NFE.IDEID2));
lstParam.Add(new OracleParameter("IDEID3", _NFE.IDEID3));
lstParam.Add(new OracleParameter("IDE_ID_RELATED", _NFE.IDE_ID_RELATED));
return(Convert.ToInt32(OracleHelper.ExecProcedureScalarTrans("PK_NFE.SP_INSERT_NFE", lstParam, CommandType.StoredProcedure, OracleHelper.BancoOracle.optimus, datasource, schema)));
}
