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);
}
