public List <ReporteInvoiceBE> ListadoMontlySales(int IdCompany, int IdClient, int Periodo, int Mes) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_rptInvoiceMontlySales"); db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany); db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, IdClient); db.AddInParameter(dbCommand, "pPeriodo", DbType.Int32, Periodo); db.AddInParameter(dbCommand, "pMes", DbType.Int32, Mes); IDataReader reader = db.ExecuteReader(dbCommand); List <ReporteInvoiceBE> ReporteInvoicelist = new List <ReporteInvoiceBE>(); ReporteInvoiceBE ReporteInvoice; while (reader.Read()) { ReporteInvoice = new ReporteInvoiceBE(); ReporteInvoice.NameCompany = reader["NameCompany"].ToString(); ReporteInvoice.NumberInvoice = reader["NumberInvoice"].ToString(); DateTime deIssueDate = DateTime.Parse(reader["IssueDate"].ToString()); ReporteInvoice.IssueDate = deIssueDate.ToString("MM/dd/yyyy"); ReporteInvoice.NameClient = reader["NameClient"].ToString(); ReporteInvoice.NameDestination = reader["NameDestination"].ToString(); ReporteInvoice.Contac = reader["Contac"].ToString(); ReporteInvoice.TotalAmount = Decimal.Parse(reader["TotalAmount"].ToString()); ReporteInvoice.TotalComision = Decimal.Parse(reader["TotalComision"].ToString()); ReporteInvoice.TotalPieces = Decimal.Parse(reader["TotalPieces"].ToString()); ReporteInvoicelist.Add(ReporteInvoice); } reader.Close(); reader.Dispose(); return(ReporteInvoicelist); }
public List <ReporteInvoiceBE> Listado(int IdInvoice) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_rptInvoice"); db.AddInParameter(dbCommand, "pIdInvoice", DbType.Int32, IdInvoice); IDataReader reader = db.ExecuteReader(dbCommand); List <ReporteInvoiceBE> ReporteInvoicelist = new List <ReporteInvoiceBE>(); ReporteInvoiceBE ReporteInvoice; while (reader.Read()) { ReporteInvoice = new ReporteInvoiceBE(); ReporteInvoice.NameCompany = reader["NameCompany"].ToString(); ReporteInvoice.Logo = (byte[])reader["Logo"]; ReporteInvoice.IdClient = Int32.Parse(reader["IdClient"].ToString()); ReporteInvoice.NumberInvoice = reader["NumberInvoice"].ToString(); ReporteInvoice.NameClient = reader["NameClient"].ToString(); ReporteInvoice.ConceptoImprime = reader["ConceptoImprime"].ToString(); DateTime deIssueDate = DateTime.Parse(reader["IssueDate"].ToString()); ReporteInvoice.IssueDate = deIssueDate.ToString("MM/dd/yyyy"); ReporteInvoice.NameDestination = reader["NameDestination"].ToString(); ReporteInvoice.BrandCertificate = reader["BrandCertificate"].ToString(); ReporteInvoice.PercentComision = Decimal.Parse(reader["PercentComision"].ToString()); ReporteInvoice.ComisionImprime = reader["ComisionImprime"].ToString(); ReporteInvoice.AddressClient = reader["AddressClient"].ToString(); ReporteInvoice.Contac = reader["Contac"].ToString(); ReporteInvoice.Occupation = reader["Occupation"].ToString(); ReporteInvoice.NoteGeneral = reader["NoteGeneral"].ToString(); ReporteInvoice.NameBank = reader["NameBank"].ToString(); ReporteInvoice.NumberCtaCte = reader["NumberCtaCte"].ToString(); ReporteInvoice.Swift = reader["Swift"].ToString(); ReporteInvoice.CodeAba = reader["CodeAba"].ToString(); ReporteInvoice.AddressBank = reader["AddressBank"].ToString(); ReporteInvoice.Phone = reader["Phone"].ToString(); ReporteInvoice.Representative = reader["Representative"].ToString(); ReporteInvoice.NameCurrency = reader["NameCurrency"].ToString(); ReporteInvoice.TotalAmount = Decimal.Parse(reader["TotalAmount"].ToString()); ReporteInvoice.TotalComision = Decimal.Parse(reader["TotalComision"].ToString()); ReporteInvoice.TotalPieces = Decimal.Parse(reader["TotalPieces"].ToString()); ReporteInvoice.ComisionLetter = reader["ComisionLetter"].ToString(); ReporteInvoice.NameStatus = reader["NameStatus"].ToString(); ReporteInvoice.IdInspectionCertificate = Int32.Parse(reader["IdInspectionCertificate"].ToString()); ReporteInvoice.NumberCertificate = reader["NumberCertificate"].ToString(); ReporteInvoice.NumberInvoiceCertificate = reader["NumberInvoiceCertificate"].ToString(); DateTime deIssueDateInvoice = DateTime.Parse(reader["IssueDateInvoice"].ToString()); ReporteInvoice.IssueDateInvoice = deIssueDateInvoice.ToString("MM/dd/yyyy"); ReporteInvoice.NameDivision = reader["NameDivision"].ToString(); ReporteInvoice.Amount = Decimal.Parse(reader["Amount"].ToString()); ReporteInvoice.Comision = Decimal.Parse(reader["Comision"].ToString()); ReporteInvoice.Pieces = Decimal.Parse(reader["Pieces"].ToString()); ReporteInvoicelist.Add(ReporteInvoice); } reader.Close(); reader.Dispose(); return(ReporteInvoicelist); }
public List <ReporteInvoiceBE> ListadoCommisionCover(int IdInvoice) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_rptInvoiceCommisionCover"); db.AddInParameter(dbCommand, "pIdInvoice", DbType.Int32, IdInvoice); IDataReader reader = db.ExecuteReader(dbCommand); List <ReporteInvoiceBE> ReporteInvoicelist = new List <ReporteInvoiceBE>(); ReporteInvoiceBE ReporteInvoice; while (reader.Read()) { ReporteInvoice = new ReporteInvoiceBE(); ReporteInvoice.NameCompany = reader["NameCompany"].ToString(); ReporteInvoice.Logo = (byte[])reader["Logo"]; ReporteInvoice.NumberInvoice = reader["NumberInvoice"].ToString(); ReporteInvoice.NameClient = reader["NameClient"].ToString(); ReporteInvoice.BrandCertificate = reader["BrandCertificate"].ToString(); ReporteInvoice.NameDestination = reader["NameDestination"].ToString(); ReporteInvoice.NameVendor = reader["NameVendor"].ToString(); ReporteInvoice.NumberCertificate = reader["NumberCertificate"].ToString(); DateTime deIssueCertificate = DateTime.Parse(reader["IssueCertificate"].ToString()); ReporteInvoice.IssueCertificate = deIssueCertificate.ToString("MM/dd/yyyy"); ReporteInvoice.NumberInvoiceCertificate = reader["NumberInvoiceCertificate"].ToString(); DateTime deIssueDateInvoice = DateTime.Parse(reader["IssueDateInvoice"].ToString()); ReporteInvoice.IssueDateInvoice = deIssueDateInvoice.ToString("MM/dd/yyyy"); ReporteInvoice.Amount = Decimal.Parse(reader["Amount"].ToString()); ReporteInvoice.Comision = Decimal.Parse(reader["Comision"].ToString()); ReporteInvoice.NameDivision = reader["NameDivision"].ToString(); ReporteInvoice.NumberPO = reader["NumberPO"].ToString(); ReporteInvoice.NumberOI = reader["NumberOI"].ToString(); ReporteInvoice.NameStyle = reader["NameStyle"].ToString(); ReporteInvoice.Pieces = Decimal.Parse(reader["Pieces"].ToString()); ReporteInvoice.AmountDetail = Decimal.Parse(reader["AmountDetail"].ToString()); ReporteInvoice.ComisionDetail = Decimal.Parse(reader["ComisionDetail"].ToString()); ReporteInvoicelist.Add(ReporteInvoice); } reader.Close(); reader.Dispose(); return(ReporteInvoicelist); }
public List <ReporteInvoiceBE> Listado(int IdInvoice) { try { ReporteInvoiceDL Invoice = new ReporteInvoiceDL(); List <ReporteInvoiceBE> lstReporteInvoice = new List <ReporteInvoiceBE>(); foreach (var item in Invoice.Listado(IdInvoice)) { ReporteInvoiceBE objE_ReporteInvoice = new ReporteInvoiceBE(); objE_ReporteInvoice.NameCompany = item.NameCompany; objE_ReporteInvoice.Logo = item.Logo; objE_ReporteInvoice.IdClient = item.IdClient; objE_ReporteInvoice.NumberInvoice = item.NumberInvoice; objE_ReporteInvoice.NameClient = item.NameClient; objE_ReporteInvoice.ConceptoImprime = item.ConceptoImprime; objE_ReporteInvoice.IssueDate = item.IssueDate; objE_ReporteInvoice.NameDestination = item.NameDestination; objE_ReporteInvoice.BrandCertificate = item.BrandCertificate; objE_ReporteInvoice.PercentComision = item.PercentComision; objE_ReporteInvoice.ComisionImprime = item.ComisionImprime; objE_ReporteInvoice.AddressClient = item.AddressClient; objE_ReporteInvoice.Contac = item.Contac; objE_ReporteInvoice.Occupation = item.Occupation; objE_ReporteInvoice.NoteGeneral = item.NoteGeneral; objE_ReporteInvoice.NameBank = item.NameBank; objE_ReporteInvoice.NumberCtaCte = item.NumberCtaCte; objE_ReporteInvoice.Swift = item.Swift; objE_ReporteInvoice.CodeAba = item.CodeAba; objE_ReporteInvoice.AddressBank = item.AddressBank; objE_ReporteInvoice.Phone = item.Phone; objE_ReporteInvoice.Representative = item.Representative; objE_ReporteInvoice.NameCurrency = item.NameCurrency; objE_ReporteInvoice.TotalAmount = item.TotalAmount; objE_ReporteInvoice.TotalComision = item.TotalComision; objE_ReporteInvoice.TotalPieces = item.TotalPieces; objE_ReporteInvoice.ComisionLetter = item.ComisionLetter; objE_ReporteInvoice.NameStatus = item.NameStatus; objE_ReporteInvoice.IdInspectionCertificate = item.IdInspectionCertificate; objE_ReporteInvoice.NumberInvoiceCertificate = item.NumberInvoiceCertificate; objE_ReporteInvoice.IssueDateInvoice = item.IssueDateInvoice; objE_ReporteInvoice.NameDivision = item.NameDivision; objE_ReporteInvoice.Amount = item.Amount; objE_ReporteInvoice.Comision = item.Amount; objE_ReporteInvoice.Pieces = item.Pieces; if (item.IdClient == 7) //SOLAMENTE PARA VINCE { string strCertificateVince = "CERTIFICATE# " + item.NumberCertificate + " - PO# "; string strStyleVince = "STYLE# "; List <InspectionCertificateDetailBE> lstInspectionCertificateDetail = null; lstInspectionCertificateDetail = new InspectionCertificateDetailDL().ListaResumen(item.IdInspectionCertificate); string strPOFinal = ""; string strCertificateFinal = ""; foreach (var itemIDC in lstInspectionCertificateDetail) { string strPO = ""; strPO = itemIDC.NumberPO.ToString().Substring(3, itemIDC.NumberPO.Length - 3); strPOFinal = strPOFinal + Convert.ToInt32(strPO).ToString() + "/"; strCertificateFinal = strCertificateFinal + itemIDC.NameStyle + "/"; } objE_ReporteInvoice.CertificateVince = strCertificateVince + strPOFinal.Remove(strPOFinal.Length - 1); objE_ReporteInvoice.StyleVince = strStyleVince + strCertificateFinal.Remove(strCertificateFinal.Length - 1); } lstReporteInvoice.Add(objE_ReporteInvoice); } return(lstReporteInvoice); } catch (Exception ex) { throw ex; } }
private void tlbMenu_PrintClick() { try { Cursor = Cursors.WaitCursor; List <ReporteInvoiceBE> lstReporteTemp = null; List <ReporteInvoiceBE> lstReporte = new List <ReporteInvoiceBE>(); int[] rows = gvInvoice.GetSelectedRows(); for (int i = 0; i < rows.Length; i++) { lstReporteTemp = new ReporteInvoiceBL().Listado(int.Parse(gvInvoice.GetRowCellValue(rows[i], gvInvoice.Columns.ColumnByFieldName("IdInvoice")).ToString())); foreach (var item in lstReporteTemp) { ReporteInvoiceBE objE_Reporte = new ReporteInvoiceBE(); objE_Reporte.NameCompany = item.NameCompany; objE_Reporte.Logo = item.Logo; objE_Reporte.NumberInvoice = item.NumberInvoice; objE_Reporte.NameClient = item.NameClient; objE_Reporte.ConceptoImprime = item.ConceptoImprime; objE_Reporte.IssueDate = item.IssueDate; objE_Reporte.NameDestination = item.NameDestination; objE_Reporte.BrandCertificate = item.BrandCertificate; objE_Reporte.PercentComision = item.PercentComision; objE_Reporte.ComisionImprime = item.ComisionImprime; objE_Reporte.AddressClient = item.AddressClient; objE_Reporte.Contac = item.Contac; objE_Reporte.Occupation = item.Occupation; objE_Reporte.NoteGeneral = item.NoteGeneral; objE_Reporte.NameBank = item.NameBank; objE_Reporte.NumberCtaCte = item.NumberCtaCte; objE_Reporte.Swift = item.Swift; objE_Reporte.CodeAba = item.CodeAba; objE_Reporte.AddressBank = item.AddressBank; objE_Reporte.Phone = item.Phone; objE_Reporte.Representative = item.Representative; objE_Reporte.NameCurrency = item.NameCurrency; objE_Reporte.TotalAmount = item.TotalAmount; objE_Reporte.TotalComision = item.TotalComision; objE_Reporte.TotalPieces = item.TotalPieces; objE_Reporte.ComisionLetter = item.ComisionLetter; objE_Reporte.NameStatus = item.NameStatus; objE_Reporte.NumberCertificate = item.NumberCertificate; objE_Reporte.IssueCertificate = item.IssueCertificate; objE_Reporte.NameVendor = item.NameVendor; objE_Reporte.NumberInvoiceCertificate = item.NumberInvoiceCertificate; objE_Reporte.IssueDateInvoice = item.IssueDateInvoice; objE_Reporte.NameDivision = item.NameDivision; objE_Reporte.Amount = item.Amount; objE_Reporte.Comision = item.Comision; objE_Reporte.Pieces = item.Pieces; objE_Reporte.CertificateVince = item.CertificateVince; objE_Reporte.StyleVince = item.StyleVince; lstReporte.Add(objE_Reporte); } } if (lstReporte != null) { if (lstReporte.Count > 0) { RptVistaReportes objRptInvoice = new RptVistaReportes(); objRptInvoice.VerRptInvoice(lstReporte); objRptInvoice.ShowDialog(); } else { XtraMessageBox.Show("No hay informaciĆ³n para el periodo seleccionado", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } Cursor = Cursors.Default; } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }