public List <ReporteInspectionCertificateBE> ListadoShippingReportVinceStyle(int IdCompany, int IdClient, string NameStyle)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_rptInspectionCertificteShippingReportVinceStyle");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
db.AddInParameter(dbCommand, "pIdClient", DbType.Int32, IdClient);
db.AddInParameter(dbCommand, "pNameStyle", DbType.String, NameStyle);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ReporteInspectionCertificateBE> ReporteInspectionCertificatelist = new List <ReporteInspectionCertificateBE>();
ReporteInspectionCertificateBE ReporteInspectionCertificate;
while (reader.Read())
{
ReporteInspectionCertificate = new ReporteInspectionCertificateBE();
ReporteInspectionCertificate.NumberPO = reader["NumberPO"].ToString();
ReporteInspectionCertificate.Dyelot = reader["Dyelot"].ToString();
ReporteInspectionCertificate.NameStyle = reader["NameStyle"].ToString();
ReporteInspectionCertificate.Color = reader["Color"].ToString();
ReporteInspectionCertificate.XXS = Decimal.Parse(reader["XXS"].ToString());
ReporteInspectionCertificate.XS = Decimal.Parse(reader["XS"].ToString());
ReporteInspectionCertificate.S = Decimal.Parse(reader["S"].ToString());
ReporteInspectionCertificate.M = Decimal.Parse(reader["M"].ToString());
ReporteInspectionCertificate.L = Decimal.Parse(reader["L"].ToString());
ReporteInspectionCertificate.XL = Decimal.Parse(reader["XL"].ToString());
ReporteInspectionCertificate.XXL = Decimal.Parse(reader["XXL"].ToString());
ReporteInspectionCertificatelist.Add(ReporteInspectionCertificate);
}
reader.Close();
reader.Dispose();
return(ReporteInspectionCertificatelist);
}
public List <ReporteInspectionCertificateBE> Listado(int IdInspectionCertificate)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_rptInspectionCertificate");
db.AddInParameter(dbCommand, "pIdInspectionCertificate", DbType.Int32, IdInspectionCertificate);
IDataReader reader = db.ExecuteReader(dbCommand);
List <ReporteInspectionCertificateBE> ReporteInspectionCertificatelist = new List <ReporteInspectionCertificateBE>();
ReporteInspectionCertificateBE ReporteInspectionCertificate;
while (reader.Read())
{
string strComment = "";
string strCommentBrand = "";
string strCommentCarton = "";
string strCommentFinal = "";
strComment = reader["Comment"].ToString();
strCommentBrand = strComment.Replace("{BRAND}", reader["BrandCertificate"].ToString());
strCommentCarton = strCommentBrand.Replace("{CARTONS}", reader["Cartons"].ToString());
strCommentFinal = strCommentCarton.Replace("{POSS}", reader["NumberPO"].ToString());
ReporteInspectionCertificate = new ReporteInspectionCertificateBE();
ReporteInspectionCertificate.NameCompany = reader["NameCompany"].ToString();
ReporteInspectionCertificate.Logo = (byte[])reader["Logo"];
ReporteInspectionCertificate.NumberCertificate = reader["NumberCertificate"].ToString();
ReporteInspectionCertificate.NumberPO = reader["NumberPO"].ToString();
ReporteInspectionCertificate.NumberOI = reader["NumberOI"].ToString();
ReporteInspectionCertificate.NameClient = reader["NameClient"].ToString();
ReporteInspectionCertificate.Comment = strCommentFinal;
ReporteInspectionCertificate.NameDivision = reader["NameDivision"].ToString();
ReporteInspectionCertificate.BrandCertificate = reader["BrandCertificate"].ToString();
ReporteInspectionCertificate.NameVendor = reader["NameVendor"].ToString();
ReporteInspectionCertificate.PaymentTerm = reader["PaymentTerm"].ToString();
ReporteInspectionCertificate.Cartons = Int32.Parse(reader["Cartons"].ToString());
ReporteInspectionCertificate.IssueDate = reader["IssueDate"].ToString();
ReporteInspectionCertificate.NameRepresentative = reader["NameRepresentative"].ToString();
ReporteInspectionCertificate.DescriptionStyle = "" + reader["Cartons"].ToString() + " CARTONS SALID TO CONTAIN " + reader["Pieces"].ToString() + " PCS, " + reader["DescriptionStyle"].ToString();
ReporteInspectionCertificate.NumberInvoice = reader["NumberInvoice"].ToString();
ReporteInspectionCertificate.IssueDateInvoice = reader["IssueDateInvoice"].ToString();
ReporteInspectionCertificate.NameCurrency = reader["NameCurrency"].ToString();
ReporteInspectionCertificate.Amount = Decimal.Parse(reader["Amount"].ToString());
ReporteInspectionCertificate.EtdDate = reader["EtdDate"].ToString();
ReporteInspectionCertificate.NameTypeShipping = reader["NameTypeShipping"].ToString();
ReporteInspectionCertificate.BoardingWay = reader["BoardingWay"].ToString();
ReporteInspectionCertificate.NameStatus = reader["NameStatus"].ToString();
ReporteInspectionCertificate.Style = reader["Style"].ToString();
ReporteInspectionCertificate.Pieces = Int32.Parse(reader["Pieces"].ToString());
ReporteInspectionCertificatelist.Add(ReporteInspectionCertificate);
}
reader.Close();
reader.Dispose();
return(ReporteInspectionCertificatelist);
}
private void tlbMenu_PrintClick()
{
try
{
Cursor = Cursors.WaitCursor;
List <ReporteInspectionCertificateBE> lstReporteTemp = null;
List <ReporteInspectionCertificateBE> lstReporte = new List <ReporteInspectionCertificateBE>();
int[] rows = gvInspectionCertificate.GetSelectedRows();
for (int i = 0; i < rows.Length; i++)
{
lstReporteTemp = new ReporteInspectionCertificateBL().Listado(int.Parse(gvInspectionCertificate.GetRowCellValue(rows[i], gvInspectionCertificate.Columns.ColumnByFieldName("IdInspectionCertificate")).ToString()));
foreach (var item in lstReporteTemp)
{
ReporteInspectionCertificateBE objE_Reporte = new ReporteInspectionCertificateBE();
objE_Reporte.NameCompany = item.NameCompany;
objE_Reporte.Logo = item.Logo;
objE_Reporte.NumberCertificate = item.NumberCertificate;
objE_Reporte.NumberPO = item.NumberPO;
objE_Reporte.NumberOI = item.NumberOI;
objE_Reporte.NameClient = item.NameClient;
objE_Reporte.Comment = item.Comment;
objE_Reporte.NameDivision = item.NameDivision;
objE_Reporte.BrandCertificate = item.BrandCertificate;
objE_Reporte.NameVendor = item.NameVendor;
objE_Reporte.PaymentTerm = item.PaymentTerm;
objE_Reporte.Cartons = item.Cartons;
objE_Reporte.IssueDate = item.IssueDate;
objE_Reporte.NameRepresentative = item.NameRepresentative;
objE_Reporte.DescriptionStyle = item.DescriptionStyle;
objE_Reporte.NumberInvoice = item.NumberInvoice;
objE_Reporte.IssueDateInvoice = item.IssueDateInvoice;
objE_Reporte.NameCurrency = item.NameCurrency;
objE_Reporte.Amount = item.Amount;
objE_Reporte.EtdDate = item.EtdDate;
objE_Reporte.NameTypeShipping = item.NameTypeShipping;
objE_Reporte.BoardingWay = item.BoardingWay;
objE_Reporte.NameStatus = item.NameStatus;
objE_Reporte.Style = item.Style;
lstReporte.Add(objE_Reporte);
}
}
if (lstReporte != null)
{
if (lstReporte.Count > 0)
{
RptVistaReportes objRptInspectionCertificate = new RptVistaReportes();
objRptInspectionCertificate.VerRptInspectionCertificate(lstReporte);
objRptInspectionCertificate.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);
}
}
