public void cs_pxEliminarDocumento(string Id) { try { //actualizar relacion y estado en tabla document. List <List <string> > registros = new clsEntityDocument(localDB).cs_pxObtenerPorResumenDiario(Id); clsEntityDocument doc; foreach (var item in registros) { doc = new clsEntityDocument(localDB).cs_fxObtenerUnoPorId(item[0].ToString().Trim()); //doc.Cs_pr_EstadoSCC = "2"; //doc.Cs_pr_EstadoSUNAT = "2"; doc.Cs_pr_Resumendiario = ""; doc.cs_pxActualizar(false, false); } //eliminar de summary documents y los relacionados: clsEntitySummaryDocuments Summary = new clsEntitySummaryDocuments(localDB).cs_fxObtenerUnoPorId(Id); clsEntitySummaryDocuments_Notes Summary_Notes = new clsEntitySummaryDocuments_Notes(localDB);//eliminado clsEntitySummaryDocuments_SummaryDocumentsLine Summary_Line = new clsEntitySummaryDocuments_SummaryDocumentsLine(localDB); clsEntitySummaryDocuments_SummaryDocumentsLine_AllowanceCharge Summary_Line_Allowance_Charge = new clsEntitySummaryDocuments_SummaryDocumentsLine_AllowanceCharge(localDB); clsEntitySummaryDocuments_SummaryDocumentsLine_BillingPayment Summary_Line_Billing_Payment = new clsEntitySummaryDocuments_SummaryDocumentsLine_BillingPayment(localDB); clsEntitySummaryDocuments_SummaryDocumentsLine_TaxTotal Summay_Line_Tax_Total = new clsEntitySummaryDocuments_SummaryDocumentsLine_TaxTotal(localDB); foreach (var item in Summary_Notes.cs_fxObtenerTodoPorSummaryId(Id)) { item.cs_pxElimnar(false); } foreach (var item in Summary_Line.cs_fxObtenerTodoPorCabeceraId(Id)) { foreach (var item1 in Summary_Line_Billing_Payment.cs_fxObtenerTodoPorCabeceraId(item.Cs_pr_SummaryDocuments_SummaryDocumentsLine_Id)) { item1.cs_pxElimnar(false); } foreach (var item2 in Summary_Line_Allowance_Charge.cs_fxObtenerTodoPorCabeceraId(item.Cs_pr_SummaryDocuments_SummaryDocumentsLine_Id)) { item2.cs_pxElimnar(false); } foreach (var item3 in Summay_Line_Tax_Total.cs_fxObtenerTodoPorCabeceraId(item.Cs_pr_SummaryDocuments_SummaryDocumentsLine_Id)) { item3.cs_pxElimnar(false); } item.cs_pxElimnar(false); } Summary.cs_pxElimnar(false); } catch (Exception ex) { clsBaseLog.cs_pxRegistarAdd("clsEntitySummaryDocuments cs_pxEliminarDocumento " + ex.ToString()); } }
// public List <clsEntitySummaryDocuments> cs_pxObtenerFiltroSecundario(string estadocomprobantesunat, string fechainicio, string fechafin) { List <clsEntitySummaryDocuments> lista_documentos; clsEntitySummaryDocuments item; try { lista_documentos = new List <clsEntitySummaryDocuments>(); OdbcDataReader datos = null; string sql = "SELECT * FROM " + cs_cmTabla + " WHERE 1=1"; //sql += " AND cp9 IN ('2','4','5') "; if (estadocomprobantesunat != "") { sql += " AND cp9 ='" + estadocomprobantesunat + "' "; } if (fechainicio != "" && fechafin != "") { sql += " AND cp3 >= '" + fechainicio + "' AND cp3 <= '" + fechafin + "'"; } //clsBaseConexion cn = new clsBaseConexion(); OdbcConnection cs_pxConexion_basedatos = new OdbcConnection(localDB.cs_prConexioncadenabasedatos()); cs_pxConexion_basedatos.Open(); datos = new OdbcCommand(sql, cs_pxConexion_basedatos).ExecuteReader(); while (datos.Read()) { item = new clsEntitySummaryDocuments(localDB); item.Cs_pr_SummaryDocuments_Id = datos[0].ToString(); item.Cs_tag_ID = datos[1].ToString(); item.Cs_tag_ReferenceDate = datos[2].ToString(); item.Cs_tag_IssueDate = datos[3].ToString(); item.Cs_tag_AccountingSupplierParty_CustomerAssignedAccountID = datos[4].ToString(); item.Cs_tag_AccountingSupplierParty_AdditionalAccountID = datos[5].ToString(); item.Cs_tag_AccountingSupplierParty_Party_PartyLegalEntity_RegistrationName = datos[6].ToString(); item.Cs_pr_Ticket = datos[7].ToString(); item.Cs_pr_EstadoSCC = datos[8].ToString(); item.Cs_pr_EstadoSUNAT = datos[9].ToString(); item.Cs_pr_ComentarioSUNAT = datos[10].ToString(); item.Cs_pr_XML = datos[11].ToString(); item.Cs_pr_CDR = datos[12].ToString(); item.Cs_pr_ExceptionSUNAT = datos[13].ToString(); item.Cs_tag_DocumentCurrencyCode = datos[14].ToString(); item.Cs_tag_AccountingSupplierParty_Party_PartyName_Name = datos[15].ToString(); lista_documentos.Add(item); } cs_pxConexion_basedatos.Close(); return(lista_documentos); } catch (Exception ex) { clsBaseLog.cs_pxRegistarAdd("cs_pxObtenerFiltroSecundario " + ex.ToString()); return(null); } }
public clsEntitySummaryDocuments cs_fxObtenerUnoPorTicket(string ticket) { clsEntitySummaryDocuments documento = new clsEntitySummaryDocuments(localDB); Int32 correlativo = 0; correlativo++; try { OdbcDataReader datos = null; string sql = "SELECT * FROM " + cs_cmTabla + " WHERE cp7='" + ticket + "';";//Estado // clsBaseConexion cn = new clsBaseConexion(); OdbcConnection cs_pxConexion_basedatos = new OdbcConnection(localDB.cs_prConexioncadenabasedatos()); cs_pxConexion_basedatos.Open(); datos = new OdbcCommand(sql, cs_pxConexion_basedatos).ExecuteReader(); while (datos.Read()) { documento.Cs_pr_SummaryDocuments_Id = datos[0].ToString(); documento.Cs_tag_ID = datos[1].ToString(); documento.Cs_tag_ReferenceDate = datos[2].ToString(); documento.Cs_tag_IssueDate = datos[3].ToString(); documento.Cs_tag_AccountingSupplierParty_CustomerAssignedAccountID = datos[4].ToString(); documento.Cs_tag_AccountingSupplierParty_AdditionalAccountID = datos[5].ToString(); documento.Cs_tag_AccountingSupplierParty_Party_PartyLegalEntity_RegistrationName = datos[6].ToString(); documento.Cs_pr_Ticket = datos[7].ToString(); documento.Cs_pr_EstadoSCC = datos[8].ToString(); documento.Cs_pr_EstadoSUNAT = datos[9].ToString(); documento.Cs_pr_ComentarioSUNAT = datos[10].ToString(); documento.Cs_pr_XML = datos[11].ToString(); documento.Cs_pr_CDR = datos[12].ToString(); documento.Cs_pr_ExceptionSUNAT = datos[13].ToString(); documento.Cs_tag_DocumentCurrencyCode = datos[14].ToString(); documento.Cs_tag_AccountingSupplierParty_Party_PartyName_Name = datos[15].ToString(); } cs_pxConexion_basedatos.Close(); } catch (Exception ex) { clsBaseMensaje.cs_pxMsgEr("ERR6", ex.ToString()); clsBaseLog.cs_pxRegistarAdd("clsEntitySummaryDocuments cs_fxObtenerUnoPorTicket" + ex.ToString()); } return(documento); }