public void AddAddress()
{
PdfPTable pt = new PdfPTable(2);
pt.WidthPercentage = 100;
pt.addCell(CellValue(@"Purchase Order Address:", false, boldfont, 0));
pt.addCell(CellValue(@" ", false, boldfont, 0));
pt.addCell(CellValue(@"MULTEK TECHNOLOGIES LIMITED" + System.Environment.NewLine +
@"1st Floor, The Exchange," + System.Environment.NewLine +
@"18 Cybercity, " + System.Environment.NewLine +
@"Ebene, REPUBLIC OF MAURITIUS" + System.Environment.NewLine +
@"Fax the PO copy to Multek Hong Kong", false, defaultfont, 0));
pt.addCell(CellValue(@" " + System.Environment.NewLine +
@"Telephone # (230) 454 3200" + System.Environment.NewLine +
@"Fax # (230) 454 3202" + System.Environment.NewLine +
@"Fax # (852) 2276 1122" + System.Environment.NewLine, false, defaultfont, 0));
doc.Add(pt);
}
//导出PDF文件方法
/// <summary>
/// DataTable导出到PDF
/// </summary>
/// <param name="datatable">DataTable</param>
/// <param name="PDFFilePath">导出的PDF存储路径</param>
/// <param name="PdfSaveTitle">导出的文件名</param>
/// <param name="FontPath">字体路径</param>
/// <param name="FontSize">字体大小</param>
/// <param name="widthmz">每一列宽度</param>
/// <returns>布尔值</returns>
public static bool ConvertDataTableToPDF(DataTable datatable, string PDFFilePath, string PdfSaveTitle, Brush brush, float FontSize, float[] widthmz)
{
if (widthmz == null || widthmz.Length == 0)//如果每一列宽度未指定
{
widthmz = new float[datatable.Columns.Count];
for (int i = 0; i < datatable.Columns.Count; i++)
{
widthmz[i] = 30f;
}
}
//初始化一个目标文档类
Document document = new Document(PageSize.A4, 10, 10, 25, 25);
//调用PDF的写入方法流
//注意FileMode-Create表示如果目标文件不存在，则创建，如果已存在，则覆盖。
PdfWriter writer = PdfWriter.getInstance(document, new FileStream(PDFFilePath, FileMode.Create));
try
{
System.Windows.Media.Color color = (System.Windows.Media.Color)ColorConverter.ConvertFromString(brush.ToString());
//打开目标文档对象
document.Open();
// 添加页眉
HeaderFooter header = new HeaderFooter(new Phrase(PdfSaveTitle), false);
document.Header = header;
// 添加页脚
HeaderFooter footer = new HeaderFooter(new Phrase(PdfSaveTitle), true);
footer.Border = Rectangle.NO_BORDER;
document.Footer = footer;
//创建PDF文档中的字体
BaseFont baseFont = BaseFont.createFont(@"C:\WINDOWS\Fonts\SIMFANG.TTF", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
//根据字体路径和字体大小属性创建字体
Font font = new Font(baseFont, FontSize);
font.setColor(color.R, color.G, color.B);
Paragraph pTitle = new Paragraph(new Chunk(PdfSaveTitle, FontFactory.getFont(FontFactory.HELVETICA, 12)));
document.Add(pTitle);
//根据数据表内容创建一个PDF格式的表
PdfPTable table = null;
table = new PdfPTable(widthmz);
//打印列名
for (int j = 0; j < datatable.Columns.Count; j++)
{
string ColumnName =datatable.Columns[j].ColumnName.ToString();
table.addCell(new Phrase(ColumnName, font));
}
//遍历原table的内容
for (int i = 0; i < datatable.Rows.Count; i++)
{
for (int j = 0; j < datatable.Columns.Count; j++)
{
table.addCell(new Phrase(datatable.Rows[i][j].ToString(), font));
}
}
//在目标文档中添加转化后的表数据
document.Add(table);
}
catch (Exception ec)
{
ec.GetBaseException();
return false;
}
finally
{
//关闭目标文件
document.Close();
//关闭写入流
writer.Close();
}
return true;
}
private void part5()
{
Paragraph t = new Paragraph(10f, "" + "\n", smallBoldFont());
doc.Add(t);
PdfPTable table = new PdfPTable(1);
Paragraph p = new Paragraph(11f, "Term and Conditions", terms);
PdfPCell c1 = new PdfPCell(p);
c1.Border = 0;
table.addCell(c1);
Paragraph p2 = new Paragraph(10f, "Lead-time is quoted in business days (excludes weekends & holidays) and is subject to " +
"the availability of material and may change within 24 hours notice." + Environment.NewLine +
"Lead-time for non-standard materials, approximately three weeks and is subject to confirmation. Prices are valid for 30 days from date of quote." + Environment.NewLine +
"Purchase order & data files, as stated below, must be received no later than 10:00AM for that day to be applied." + Environment.NewLine +
"All quote information is subject to change after receipt of Gerber data files, fabrication drawings & specifications." +
"Prices are only applicable for new purchase orders unless specified. Acceptance of a purchase order is contingent upon " +
"satisfactory credit approval. Deliveries maybe subject to applicable local sales taxes, VAT.", terms2);
//p2.SpacingAfter = 4f;
PdfPCell c2 = new PdfPCell(p2);
c2.Border = 0;
table.addCell(c2);
Paragraph p3 = new Paragraph(10f, "This quote is provided in accordance with the Multek Warranty Policy Terms and Conditions.", terms2);
//p3.SpacingAfter = 6f;
PdfPCell c3 = new PdfPCell(p3);
c3.Border = 0;
table.addCell(c3);
Paragraph x1 = new Paragraph(11f, "Policy for Cancellations", terms);
PdfPCell c4 = new PdfPCell(x1);
c4.Border = 0;
table.addCell(c4);
Paragraph x2 = new Paragraph(11f, "- 45 calendar days for the order" + Environment.NewLine +
"- 60 days for standard material" + Environment.NewLine +
"- 90 days for \"special\" material ( i.e. 13 Teflon, Cyanate Ester, GTEK, etc..)", terms2);
PdfPCell c5 = new PdfPCell(x2);
c5.Border = 0;
table.addCell(c5);
//x2.SpacingAfter = 8f;
//Paragraph ad = new Paragraph(11f, "ADDITIONAL NOTES:", termsB);
//ad.SpacingBefore = 2f;
//doc.Add(ad);
//Paragraph ad2 = new Paragraph(11f);
//ad2.Add(new Chunk("-Minimum Order per Delivery: ", termsB));
//ad2.Add(new Chunk("= " + row["Currency"].ToString() + row["MOV"].ToString(), timesBlue));
//ad2.Add(new Chunk(Environment.NewLine + "-" + row["Notes"].ToString() +
// Environment.NewLine + "-" + row["Notes2"].ToString(), termsB));
/*
Paragraph ad2 = new Paragraph(11f, "-Minimum Order per Delivery: = " + row["currency"].ToString()+ row["moq2"].ToString() +
Environment.NewLine+"-"+row["note1"].ToString()+
Environment.NewLine + "-" + row["note2"].ToString(), termsB);
*/
//ad2.SpacingAfter = 5f;
//doc.Add(ad2);
Paragraph inf = new Paragraph(11f, "Thanks & Best regards,", termsB);
//inf.SpacingAfter = 3f;
PdfPCell c6 = new PdfPCell(inf);
c6.Border = 0;
table.addCell(c6);
Paragraph inf0 = new Paragraph(12f, row["PrimaryContact"].ToString(), termsB);
//inf0.SpacingAfter = 3f;
PdfPCell c7 = new PdfPCell(inf0);
c7.Border = 0;
table.addCell(c7);
Paragraph inf1 = new Paragraph(12f, "Direct Line : " + row["Phone"].ToString(), pageFont());
PdfPCell c8 = new PdfPCell(inf1);
c8.Border = 0;
table.addCell(c8);
Paragraph inf2 = new Paragraph(11f, "Direct Fax : " + row["Fax"].ToString(), pageFont());
PdfPCell c9 = new PdfPCell(inf2);
c9.Border = 0;
table.addCell(c9);
Paragraph inf3 = new Paragraph(11f, "Cell Phone : " + row["CellPhone"].ToString(), pageFont());
PdfPCell c10 = new PdfPCell(inf3);
c10.Border = 0;
table.addCell(c10);
Paragraph inf4 = new Paragraph(11f, "Email Address : " + row["Email"].ToString(), pageFont());
PdfPCell c11 = new PdfPCell(inf4);
c11.Border = 0;
table.addCell(c11);
doc.Add(table);
//Paragraph inf6 = new Paragraph(11f, "1", pageFont());
//doc.Add(inf6);
//Paragraph inf7 = new Paragraph(11f, "Rev. B 11/10/2011", pageFont());
//doc.Add(inf7);
/*
Policy for Cancellations
*/
}
private void part4()
{
Paragraph p = new Paragraph(10f, "" + "\n", smallBoldFont());
doc.Add(p);
PdfPTable table = new PdfPTable(4);
table.TotalWidth = TBWidth;
//table.LockedWidth = true;
//table.SpacingAfter = 10f;
float[] widths = new float[] { 20f, 30f, 20f, 30f };
table.setWidths(widths);
PdfPCell c = titleCell("Conditions");
c.Colspan = 4;
table.addCell(c);
table.addCell(addCell("Card Size", true, false));
string cs = "";
if (row["UnitSizeLength"].ToString().Trim() + row["UnitSizeWidth"].ToString().Trim() != "")
cs = row["UnitSizeLength"].ToString() + " x " + row["UnitSizeWidth"].ToString() + " " + row["UnitType"].ToString();
table.addCell(getValue(cs));
table.addCell(addCell("Material", true, false));
//if (string.IsNullOrEmpty(row["LaminateType"].ToString()))
//{
// table.addCell(getValue(row["MaterialCategory"].ToString() + "" + row["LaminateType"].ToString()));
//}
//else
//{
// table.addCell(getValue(row["MaterialCategory"].ToString() + " (" + row["LaminateType"].ToString() + ")"));
//}
table.addCell(getValue(row["MaterialCategory"].ToString()));
table.addCell(addCell("Array Size", true, false));
string ars = " ";
if (row["ArraySizeWidth"].ToString().Trim() + row["ArraySizeLength"].ToString().Trim() != "")
ars = row["ArraySizeWidth"].ToString() + " x " + row["ArraySizeLength"].ToString() + " " + row["UnitType"].ToString() + " ";
if (row["UnitPerArray"].ToString().Trim() != "")
ars += "(" + row["UnitPerArray"].ToString() + " up)";
table.addCell(getValue(ars));
table.addCell(addCell("Thickness (mm/inch)", true, false));
table.addCell(getValue(row["BoardThickness"].ToString() + " (" + row["UnitType"].ToString() + ")"));
table.addCell(addCell("# of Layers", true, false));
string viaStructure = row["ViaStructure"].ToString();
if (!string.IsNullOrEmpty(viaStructure))
{
table.addCell(getValue(row["LayerCount"].ToString() + " [ " + viaStructure + " ] "));
}
else
{
table.addCell(getValue(row["LayerCount"].ToString()));
}
table.addCell(addCell("Copper (ext/int)", true, false));
table.addCell(getValue(row["Copper"].ToString()));
table.addCell(addCell("# of Holes", true, false));
table.addCell(getValue(row["Holes"].ToString() + " " + row["UnitOrArray"].ToString()));
table.addCell(addCell("Finish", true, false));
table.addCell(getValue(row["Finishing"].ToString()));
table.addCell(addCell("Smallest Hole", true, false));
table.addCell(getValue(row["SmallestHole"].ToString() + " " + row["UnitType"].ToString()));
table.addCell(addCell("Line & Space (ext)", true, false));
string lno = row["LnO"].ToString();
if (string.IsNullOrEmpty(lno.Trim()))
{
table.addCell(getValue(""));
}
else
{
table.addCell(getValue(row["LnO"].ToString() + " " + row["UnitType"].ToString()));
}
table.addCell(addCell("Impedance (Y/N)", true, false));
table.addCell(getValue(row["Imped"].ToString()));
table.addCell(addCell("Line & Space (int)", true, false));
string lni = row["LnI"].ToString();
if (string.IsNullOrEmpty(lni.Trim()))
{
table.addCell(getValue(" "));
}
else
{
table.addCell(getValue(row["LnI"].ToString() + " " + row["UnitType"].ToString()));
}
string s = " ";
if (Value("USize") != "")
s = Value("USize") + " ";
if (Value("UQty") != "")
s += "(" + Value("UQty") + ")";
table.addCell(addCell("Micro Via Size (Qty)", true, false));
table.addCell(getValue(s));
table.addCell(addCell("Outline Profiling", true, false));
table.addCell(getValue(Value("Outline")));
table.addCell(addCell("Blind/Buried Via", true, false));
s = " ";
if (Value("BlindSize") != "")
s = Value("BlindSize") + " ";
if (Value("BlindSize") != "")
s += "(" + Value("BlindSize") + ")";
s += "/";
if (Value("BuriedSize") != "")
s += Value("BuriedSize") + " ";
if (Value("BuriedQty") != "")
s += "(" + Value("BuriedQty") + ")";
table.addCell(getValue(s));
table.addCell(addCell("Internal Reference", true, false));
string reference = row["PanelSizeWidth"].ToString().Trim() + row["PanelSizeLength"].ToString().Trim() + row["UnitPerWorkingPanel"].ToString().Trim();
if (reference.Length > 2)
{
reference = reference.Substring(1, reference.Length - 1);
}
reference = reference+ '(' + plant2Number(row["Building"].ToString().Trim().ToUpper()).ToString() + ')';
table.addCell(getValue(reference + " " + row["ProjectNumber"].ToString()));
doc.Add(table);
PdfPTable table2 = new PdfPTable(1);
table2.TotalWidth = TBWidth;
//table2.LockedWidth = true;
//table2.SpacingAfter = 6f;
table2.addCell(titleCell("Technical Remarks & Remarks"));
PdfPCell cr = getValue(showProgramme(row["UnitPrice1"].ToString()) + Environment.NewLine + Value("TechnicalRemarks") + Environment.NewLine + Value("Remarks"));
//cr.FixedHeight = 40f;
cr.MinimumHeight = 40f;
cr.VerticalAlignment = Element.ALIGN_MIDDLE;
table2.addCell(cr);
doc.Add(table2);
}
private void part3()
{
Paragraph p = new Paragraph(10f, "" + "\n", smallBoldFont());
doc.Add(p);
PdfPTable table = new PdfPTable(4);
table.TotalWidth = TBWidth;
//table.LockedWidth = true;
//table.SpacingAfter = 10f;
float[] widths = new float[] { 25f, 25f, 25f, 25f };
table.setWidths(widths);
table.addCell(titleCellC("NRE Charge"));
table.addCell(titleCellC(" "));
table.addCell(titleCell("Min.Order Value"));
table.addCell(getValue(showCurrencyKey(row["MOV"].ToString())));
table.addCell(addCell("Set-up Charge", true, false));
table.addCell(getValue(showCurrencyKey(row["SetupCharge"].ToString())));
table.addCell(titleCell("Min.Order Qty"));
table.addCell(getValue(row["MOQ"].ToString()));
table.addCell(addCell("E-Testing Charge", true, false));
table.addCell(getValue(showCurrencyKey(row["EtestCharge"].ToString())));
table.addCell(titleCell("Shipment Term"));
string shipterms=row["ShipmentTerms"].ToString();
if(string.IsNullOrEmpty(shipterms.Trim()))
{
shipterms = "FCA HK - Free Carrier";
}
shipterms = shipterms+" "+row["Location"].ToString();
table.addCell(getValue(shipterms));
table.addCell(addCell("Tooling Charge", true, false));
table.addCell(getValue(showCurrencyKey(row["ToolingCharge"].ToString())));
table.addCell(titleCell("Payment Terms"));
table.addCell(getValue(row["PayTerms"].ToString()));
doc.Add(table);
}
private void part2()
{
Paragraph p = new Paragraph(10f, "Thank you for you inquiry, we are pleased to provide you quotation for our products as follow:", smallBoldFont());
//p.SpacingAfter = 2f;
//doc.Add(p);
PdfPTable table = new PdfPTable(6);
table.TotalWidth = TBWidth;
//table.LockedWidth = true;
float[] widths = new float[] { 28f, 15f, 11f, 9f, 10f, 27f };
table.setWidths(widths);
//table.SpacingAfter = 10f;
PdfPCell c1 = new PdfPCell(p);
//c1.FixedHeight = 33f;
c1.Colspan = 6;
c1.Border = 0;
table.addCell(c1);
table.addCell(titleCellC("Part Number"));
table.addCell(titleCellC("Lead-Time"));
table.addCell(titleCellC("Qty"));
table.addCell(titleCellC("Currency"));
table.addCell(titleCellC("Unit Price Each"));
table.addCell(titleCellC("Remarks"));
string programme = "";
string PartInfor = "";
if (row["ProgramName"].ToString().Trim() != "")
programme = row["ProgramName"].ToString();
if (row["CustomerPartNumber"].ToString().Trim() != "")
PartInfor += ((PartInfor == "") ? "" : ", ") + row["CustomerPartNumber"].ToString().Trim();
if (row["Revision"].ToString().Trim() != "")
PartInfor += ((PartInfor == "") ? "" : ", ") + row["Revision"].ToString().Trim();
table.addCell(getValue(PartInfor));
table.addCell(getValue(row["LeadTime"].ToString()));
table.addCell(getValue(row["Price1Qty"].ToString()));
table.addCell(getValue(row["Currency"].ToString()));
table.addCell(getValue(row["UnitPrice1"].ToString()));
string rm = Value("Remark1");
int len = rm.Length;
table.addCell(getValue(rm));
if (len > 100)
table.addCell(addCell(" ", true, false));
else
table.addCell(addCell(" ", true, false));
table.addCell(addCell(" ", true, false));
table.addCell(getValue(row["Price2Qty"].ToString()));
table.addCell(getValue(showCurrency(row["UnitPrice2"].ToString())));
table.addCell(getValue(row["UnitPrice2"].ToString()));
table.addCell(getValue(row["Remark2"].ToString()));
if (len > 150)
table.addCell(addCell(" ", true, false));
else
table.addCell(addCell(" ", true, false));
table.addCell(addCell(" ", true, false));
table.addCell(getValue(row["Price3Qty"].ToString()));
table.addCell(getValue(showCurrency(row["UnitPrice3"].ToString())));
table.addCell(getValue(row["UnitPrice3"].ToString()));
table.addCell(getValue(row["Remark3"].ToString()));
if (len > 200)
table.addCell(addCell(" ", true, false));
else
table.addCell(addCell(" ", true, false));
table.addCell(addCell(" ", true, false));
table.addCell(getValue(row["Price4Qty"].ToString()));
table.addCell(getValue(showCurrency(row["UnitPrice4"].ToString())));
table.addCell(getValue(row["UnitPrice4"].ToString()));
table.addCell(getValue(row["Remark4"].ToString()));
if (len > 250)
table.addCell(addCell(" ", true, false));
else
table.addCell(addCell(" ", true, false));
table.addCell(addCell(" ", true, false));
table.addCell(getValue(row["Price5Qty"].ToString()));
table.addCell(getValue(showCurrency(row["UnitPrice5"].ToString())));
table.addCell(getValue(row["UnitPrice5"].ToString()));
table.addCell(getValue(row["Remark5"].ToString()));
doc.Add(table);
}
private void part1()
{
try
{
PdfPTable table = new PdfPTable(4);
table.TotalWidth = TBWidth;
//table.LockedWidth = true;
float[] widths = new float[] { 15f, 45f, 15f, 25f };
table.setWidths(widths);
//table.SpacingAfter = 5f;
table.addCell(addCell("Company :", false, true));
string company = row["OEM"].ToString();
company += (row["CEM"].ToString().Trim() != "") ? " - " + row["CEM"].ToString() : "";
table.addCell(addCell(company, false, true));
table.addCell(addCell("Date :", false, true));
string customerquotedate=row["CustomerQuoteDate"].ToString();
if(string.IsNullOrEmpty(customerquotedate.Trim()))
{
customerquotedate = DateTime.Now.ToString("dd-MMM-yyyy");
}
DateTime customerdate=new DateTime();
DateTime.TryParse(customerquotedate,out customerdate);
table.addCell(addCell(customerdate.ToString("dd-MMM-yyyy"), false, true));
table.addCell(addCell("Attention :", false, true));
table.addCell(addCell(row["CustomerContact"].ToString(), false, true));
table.addCell(addCell("RFQ# :", false, true));
string extnumber = row["ExtNumber"].ToString();
if (row["ExtNumber"].ToString().IndexOf('-') > 0)
{
extnumber=row["ExtNumber"].ToString().Substring(0, row["ExtNumber"].ToString().IndexOf('-'));
}
table.addCell(addCell(extnumber, false, true));
doc.Add(table);
Paragraph p = new Paragraph(10f, ""+"\n", smallBoldFont());
doc.Add(p);
}
catch (Exception ex)
{
message = ex.ToString();
throw ex;
}
}
private void addHeader()
{
//string image_url = "http://mcnnt800.asia.ad.flextronics.com/Common/Content/Images/Multek_LOGO.PNG";
string image_url = HttpContext.Current.Server.MapPath("~/tmp/logo.png");
iTextSharp.text.Image png = iTextSharp.text.Image.getInstance(new Uri(image_url));
png.scaleToFit(140, 140);
png.Interpolation = true;
//png.setAbsolutePosition(RLMargin, doc.PageSize.Height - 50);
// doc.Add(png);
PdfPTable table2 = new PdfPTable(2);
table2.TotalWidth = TBWidth;
//table2.LockedWidth = true;
PdfPCell c1 = new PdfPCell(new Phrase(new Chunk(png,10,20)));
c1.Border = 0;
// c1.FixedHeight = 33f;
table2.addCell(c1);
PdfPCell ch = new PdfPCell(new Phrase(new Chunk("www.multek.com", bigBoldFont())));
ch.HorizontalAlignment = Element.ALIGN_RIGHT;
ch.VerticalAlignment = Element.ALIGN_MIDDLE;
ch.Border = 0;
ch.FixedHeight = 33f;
table2.addCell(ch);
// table2.SpacingAfter = 4f;
//ch.Rowspan
Phrase p = new Phrase(new Chunk("Quotation", bigBoldFont()));
//p.Font.Size = 14f;
PdfPCell cell = new PdfPCell(p);
cell.MinimumHeight = 18f;
cell.VerticalAlignment = Element.ALIGN_TOP;
cell.HorizontalAlignment = Element.ALIGN_CENTER;
cell.BackgroundColor = color;
cell.Colspan = 2;
table2.addCell(cell);
// table2.SpacingAfter = 4f;
doc.Add(table2);
}
/// <summary>
/// 打印主内容
/// </summary>
private void PrintContent()
{
PdfPTable pdfTable = new PdfPTable(Content.ColumnsCount);
pdfTable.WidthPercentage = 110;
Font font = new Font(BaseFont, 9);
for (int i = 0; i < Content.RowsCount; i++)
{
for (int j = 0; j < Content.ColumnsCount; j++)
{
Paragraph par = new Paragraph(string.Format("{0}", Content.GetValue(i, j)), font);
pdfTable.addCell(par);
}
}
PdfDoc.Add(pdfTable);
}
public void AddLeadTimePayShipTerms()
{
PdfPTable pt = new PdfPTable(2);
pt.WidthPercentage = 100;
pt.addCell(CellValue("3. Production Lead-time, Payment & Shipment Terms", false, boldfont, 0, 2));
pt.addCell(CellValue("Lead Time of FPC/RFPC", true, defaultfont, 0, true));
string leadTimeText = string.Format("Production first article parts will ship {0} after receipt of order.\r\n", maindt.Rows[rowid]["LeadTime"].ToString());
leadTimeText += "Lead time for follow on production orders is 4 weeks with forecast, or 6 weeks without forecast.\r\n";
leadTimeText += "Actual lead time depends on material and factory loading.";
pt.addCell(CellValue(leadTimeText, true, bluefont, 0, false));
pt.addCell(CellValue("Lead Time of BOM", true, defaultfont, 0, true));
pt.addCell(CellValue(maindt.Rows[rowid]["SMTBOMLeadtime"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Shipment Term", true, defaultfont, 0, true));
string strShipmentTerms = string.Empty;
foreach (string shipmentTerms in shipmentTermsList)
{
strShipmentTerms += shipmentTerms + "\n";
}
pt.addCell(CellValue(strShipmentTerms, true, bluefont, 0, false));
pt.addCell(CellValue("Payment Term", true, defaultfont, 0, true));
//pt.addCell(CellValue(maindt.Rows[rowid]["PayTerms"].ToString(), true, bluefont, 0, false));
string strPayTerms = string.Empty;
foreach (string payTerms in payTermsList)
{
strPayTerms += "Payment terms are " + payTerms + "\n";
}
strPayTerms += "Production tooling will be invoiced 100% upon order placement and 100% upon shipment of first article circuits.";
pt.addCell(CellValue(strPayTerms, true, bluefont, 0, false));
doc.Add(pt);
}
public void AddToolingSummary(int rfqId)
{
DataTable dt = GetToolingSummary(rfqId);
int rcount = dt.Rows.Count;
PdfPTable pt = new PdfPTable(1);
pt.WidthPercentage = 100;
pt.addCell(CellValue(@"2. Tooling Summary", false, boldfont, 0));
doc.Add(pt);
PdfPTable pt1 = new PdfPTable(rcount + 1);
pt1.WidthPercentage = 70;
pt1.HorizontalAlignment = Element.ALIGN_LEFT;
pt1.addCell(CellValue(@"Item", true, boldfont, 1, true));
for (int i = 0; i < rcount; i++)
{
pt1.addCell(CellValue(dt.Rows[i][1].ToString(), true, boldfont, 1, true));
}
List<float> widths = new List<float>();
for (int i = 0; i < rcount + 1; i++)
{
widths.Add(40f);
}
pt1.setWidths(widths.ToArray());
pt1.addCell(CellValue(@"Outline Tool-1", true, bluefont, 1, false));
for (int i = 0; i < rcount; i++)
{
pt1.addCell(CellValue(dt.Rows[i][2] is DBNull ? "N/A" : "$" + Convert.ToInt32(dt.Rows[i][2]).ToString("#,###"), true, bluefont, 1, false));
}
pt1.addCell(CellValue(@"Outline Tool-2", true, bluefont, 1, false));
for (int i = 0; i < rcount; i++)
{
pt1.addCell(CellValue(dt.Rows[i][3] is DBNull ? "N/A" : "$" + Convert.ToInt32(dt.Rows[i][3]).ToString("#,###"), true, bluefont, 1, false));
}
pt1.addCell(CellValue(@"Top Coverlay Tool", true, bluefont, 1, false));
for (int i = 0; i < rcount; i++)
{
pt1.addCell(CellValue(dt.Rows[i][4] is DBNull ? "N/A" : "$" + Convert.ToInt32(dt.Rows[i][4]).ToString("#,###"), true, bluefont, 1, false));
}
pt1.addCell(CellValue(@"Bottom Coverlay Tool", true, bluefont, 1, false));
for (int i = 0; i < rcount; i++)
{
pt1.addCell(CellValue(dt.Rows[i][5] is DBNull ? "N/A" : "$" + Convert.ToInt32(dt.Rows[i][5]).ToString("#,###"), true, bluefont, 1, false));
}
pt1.addCell(CellValue(@"E-test/CAD/Artwork/NRE", true, bluefont, 1, false));
for (int i = 0; i < rcount; i++)
{
pt1.addCell(CellValue(dt.Rows[i][6] is DBNull ? "N/A" : "$" + Convert.ToInt32(dt.Rows[i][6]).ToString("#,###"), true, bluefont, 1, false));
}
pt1.addCell(CellValue(@"SMT Tooling/Fixture", true, bluefont, 1, false));
for (int i = 0; i < rcount; i++)
{
pt1.addCell(CellValue(dt.Rows[i][7] is DBNull ? "N/A" : "$" + Convert.ToInt32(dt.Rows[i][7]).ToString("#,###"), true, bluefont, 1, false));
}
pt1.addCell(CellValue(@"Total", true, bluefont, 1, false));
for (int i = 0; i < rcount; i++)
{
pt1.addCell(CellValue(dt.Rows[i][8] is DBNull ? "N/A" : "$" + Convert.ToInt32(dt.Rows[i][8]).ToString("#,###"), true, bluefont, 1, false));
}
int eau = Convert.ToInt32(maindt.Rows[rowid]["VolumePerMonth"] is DBNull ? "0" : maindt.Rows[rowid]["VolumePerMonth"]);
pt1.addCell(CellValue(@"Remark:" + System.Environment.NewLine +
string.Format(@" MP Tooling charge based on run-rate of {0}K/Year.", eau / 1000), false, bluefont, 0, 7));
doc.Add(pt1);
}
public void AddTechniaclSummary(int rfqId)
{
DataTable dt = GetProductInformation(rfqId);
if (dt != null && dt.Rows.Count > 0)
{
DataRow row = dt.Rows[0];
PdfPTable pt = new PdfPTable(4);
pt.WidthPercentage = 100;
pt.addCell(CellValue("4. Technical Summary", false, boldfont, 0, 4));
pt.addCell(CellValue("Conditions", true, boldfont, 0, true, 4));
pt.addCell(CellValue("Card Size", true, defaultfont, 0, false));
string unitSizeW = row["UnitSizeWidth"] is DBNull ? "" : row["UnitSizeWidth"].ToString();
string unitSizeL = row["UnitSizeLength"] is DBNull ? "" : row["UnitSizeLength"].ToString();
if (!string.IsNullOrEmpty(unitSizeW) && !string.IsNullOrEmpty(unitSizeL))
{
pt.addCell(CellValue(unitSizeW + "*" + unitSizeL + "mm", true, bluefont, 0, false));
}
else
{
pt.addCell(CellValue("N/A", true, bluefont, 0, false));
}
pt.addCell(CellValue("Material", true, defaultfont, 0, false));
pt.addCell(CellValue(row["MaterialCategory"] is DBNull ? "N/A" : row["MaterialCategory"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Array Size", true, defaultfont, 0, false));
string arraySizeW = row["ArraySizeWidth"] is DBNull ? "" : row["ArraySizeWidth"].ToString();
string arraySizeL = row["ArraySizeLength"] is DBNull ? "" : row["ArraySizeLength"].ToString();
if (!string.IsNullOrEmpty(arraySizeW) && !string.IsNullOrEmpty(arraySizeL))
{
pt.addCell(CellValue(arraySizeW + "*" + arraySizeL + "mm", true, bluefont, 0, false));
}
else
{
pt.addCell(CellValue("N/A", true, bluefont, 0, false));
}
pt.addCell(CellValue("Thickness (mm/inch)", true, defaultfont, 0, false));
pt.addCell(CellValue(row["BoardThickness"] is DBNull ? "N/A" : row["BoardThickness"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("# of Layers", true, defaultfont, 0, false));
string viaStructure = row["ViaStructure"].ToString();
if (!string.IsNullOrEmpty(viaStructure))
{
pt.addCell(CellValue(row["LayerCount"] is DBNull ?
"N/A" : row["LayerCount"].ToString() + " [ " + viaStructure + " ] ", true, bluefont, 0, false));
}
else
{
pt.addCell(CellValue(row["LayerCount"] is DBNull ? "N/A" : row["LayerCount"].ToString(), true, bluefont, 0, false));
}
pt.addCell(CellValue("Copper (ext/int)", true, defaultfont, 0, false));
pt.addCell(CellValue(row["Copper"] is DBNull ? "N/A" : row["Copper"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Construction", true, defaultfont, 0, false));
pt.addCell(CellValue(row["BoardConstruction"] is DBNull ? "N/A" : row["BoardConstruction"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Surface Finishing", true, defaultfont, 0, false));
pt.addCell(CellValue(row["Finishing"] is DBNull ? "N/A" : row["Finishing"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("# of Holes", true, defaultfont, 0, false));
pt.addCell(CellValue(row["Holes"] is DBNull ? "N/A" : row["Holes"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Line & Space (ext)", true, defaultfont, 0, false));
pt.addCell(CellValue(row["LnO"] is DBNull ? "N/A" : row["LnO"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Smallest Hole", true, defaultfont, 0, false));
pt.addCell(CellValue(row["SmallestHole"] is DBNull ? "N/A" : row["SmallestHole"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Line & Space (int)", true, defaultfont, 0, false));
pt.addCell(CellValue(row["LnI"] is DBNull ? "N/A" : row["LnI"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Impedance (Y/N)", true, defaultfont, 0, false));
pt.addCell(CellValue(row["Imped"] is DBNull ? "N/A" : row["Imped"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Outline Profiling", true, defaultfont, 0, false));
pt.addCell(CellValue(row["Outline"] is DBNull ? "N/A" : row["Outline"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Micro Via Size (Qty)", true, defaultfont, 0, false));
pt.addCell(CellValue(row["MicroViaSize"] is DBNull ? "N/A" : row["MicroViaSize"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("LPI Solder Mask(Y/N)", true, defaultfont, 0, false));
pt.addCell(CellValue(row["LPISolderMask"] is DBNull ? "N/A" : row["LPISolderMask"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("Blind / Buried Via", true, defaultfont, 0, false));
string blindQty = row["BlindQty"].ToString();
string blindSize = row["BlindSize"].ToString();
string buriedQty = row["BuriedQty"].ToString();
string buriedSize = row["BuriedSize"].ToString();
if ((!string.IsNullOrEmpty(blindQty) && blindQty != "0") ||
(!string.IsNullOrEmpty(blindSize) && blindQty != "0") ||
(!string.IsNullOrEmpty(buriedQty) && blindQty != "0") ||
(!string.IsNullOrEmpty(buriedSize) && blindQty != "0"))
{
pt.addCell(CellValue("Y", true, bluefont, 0, false));
}
else
{
pt.addCell(CellValue("N", true, bluefont, 0, false));
}
pt.addCell(CellValue("Pre-bending (Y/N)", true, defaultfont, 0, false));
pt.addCell(CellValue(row["PreBending"] is DBNull ? "N/A" : row["PreBending"].ToString(), true, bluefont, 0, false));
pt.addCell(CellValue("X out criteria", true, defaultfont, 0, false));
pt.addCell(CellValue(row["XOutAllowance"] is DBNull ? "N/A" : row["XOutAllowance"].ToString(), true, bluefont, 0, 4));
doc.Add(pt);
}
}
public void AddRemarkPricingAssumption(int rfqId)
{
PdfPTable pt = new PdfPTable(1);
pt.WidthPercentage = 100;
pt.addCell(CellValue(" ", false, boldfont, 0, 4));
pt.addCell(CellValue("Remarks & Pricing Assumption", true, boldfont, 0, true));
//string remarks = maindt.Rows[rowid]["Remarks"].ToString();
//if (!string.IsNullOrEmpty(remarks))
//{
// PdfPCell c1 = new PdfPCell(CellValue(remarks, true, bluefont, 0, false));
// c1.Border = Rectangle.LEFT | Rectangle.RIGHT | Rectangle.TOP;
// pt.addCell(c1);
//}
//else
//{
// pt.addCell(CellValue(" ", true, bluefont, 0, 4));
//}
bool isAllCurrSame = true;
if (priceCurr.Count > 0)
{
foreach (string curr1 in priceCurr)
{
foreach (string curr2 in priceCurr)
{
if (curr1 != curr2)
{
isAllCurrSame = false;
break;
}
}
if (!isAllCurrSame)
{
break;
}
}
}
else
{
isAllCurrSame = false;
}
string remarks = "This quote is budgetary pending review of the finalized design and specifications.\n";
if (isAllCurrSame)
{
remarks += string.Format("All prices shown are in {0}.\n", priceCurr[0]);
}
remarks += "Actual delivery schedules must be negotiated with and confirmed by Multek Flexible Circuits upon receipt of order.\n";
remarks += "Assumed stackup as below;\n";
PdfPCell c1 = new PdfPCell(CellValue(remarks, true, bluefont, 0, 4));
//c1.Border = Rectangle.LEFT | Rectangle.RIGHT | Rectangle.TOP;
pt.addCell(c1);
string filePath = GetGraphPath(rfqId);
if (!string.IsNullOrEmpty(filePath))
{
iTextSharp.text.Image png = iTextSharp.text.Image.getInstance(new Uri(filePath));
png.scaleToFit(400, 1200);
png.Interpolation = true;
PdfPCell c2 = new PdfPCell(new Phrase(new Chunk(png, 10, 20)));
c2.Border = Rectangle.LEFT | Rectangle.RIGHT | Rectangle.BOTTOM;
pt.addCell(c2);
}
doc.Add(pt);
//string image_url = HttpContext.Current.Server.MapPath("~/tmp/pic1.png");
//iTextSharp.text.Image png = iTextSharp.text.Image.getInstance(new Uri(image_url));
//png.scaleToFit(400, 1200);
//png.Interpolation = true;
//PdfPCell c2 = new PdfPCell(new Phrase(new Chunk(png, 10, 20)));
//c2.Border = Rectangle.LEFT | Rectangle.RIGHT | Rectangle.BOTTOM;
//pt.addCell(c2);
//doc.Add(pt);
}
public void AddQuotationTitle()
{
PdfPTable pt = new PdfPTable(1);
pt.WidthPercentage = 100;
PdfPCell cell = CellValue(@"Quotation", true, boldfont, 1);
cell.BackgroundColor = new Color(192, 192, 192);
pt.addCell(cell);
doc.Add(pt);
}
public void AddQuotationSummary(int rfqId)
{
PdfPTable pt = new PdfPTable(1);
pt.WidthPercentage = 100;
pt.addCell(CellValue(@"1. Quotation Summary", false, boldfont, 0));
doc.Add(pt);
PdfPTable pt1 = new PdfPTable(7);
pt1.WidthPercentage = 100;
pt1.addCell(CellValue(@"Item", true, boldfont, 1, true));
pt1.addCell(CellValue(@"Bare FPC/RFPC Price(USD)", true, boldfont, 1, true));
pt1.addCell(CellValue(@"BOM Price(USD)", true, boldfont, 1, true));
pt1.addCell(CellValue(@"Assembly Price(USD)", true, boldfont, 1, true));
pt1.addCell(CellValue(@"Total Price(USD)", true, boldfont, 1, true));
pt1.addCell(CellValue(@"MOQ(pcs)", true, boldfont, 1, true));
pt1.addCell(CellValue(@"Remark", true, boldfont, 1, true));
float[] widths = new float[] { 40f, 30f, 30f, 30f, 30f, 30f, 60f };
pt1.setWidths(widths);
DataTable dt = GetPriceDetail(rfqId);
foreach (DataRow dr in dt.Rows)
{
priceCurr.Add(dr[7].ToString());
if (!(dr[8] is DBNull) && !shipmentTermsList.Contains(dr[8].ToString()))
{
shipmentTermsList.Add(dr[8].ToString());
}
if (!(dr[9] is DBNull) && !payTermsList.Contains(dr[9].ToString()))
{
payTermsList.Add(dr[9].ToString());
}
for (int i = 0; i < 7; i++)
{
if (i == 1 || i == 2 || i == 3 || i == 4)
{
if (dr[i] is DBNull || dr[i].ToString() == "0")
{
pt1.addCell(CellValue("N/A", true, bluefont, 1, false));
}
else
{
pt1.addCell(CellValue("$" + dr[i].ToString(), true, bluefont, 1, false));
}
}
else
{
pt1.addCell(CellValue(dr[i] is DBNull ? "" : dr[i].ToString(), true, bluefont, 1, false));
}
}
}
//pt1.addCell(CellValue(@"Remark:" + System.Environment.NewLine +
// @" 1. The tooling cost base on 10k/year and the panel is 48up/set." + "\n" +
// @" 2. Assume the FPCA assembly standard follows IPC-A-610 class2." + "\n" +
// @" 3. Assume DI water cleaning process with water solution solder paste." + "\n" +
// @" 4. Assume ICT test time is 24s per unit and the tester cost is around $1400. Any change the cost must be update.", false, bluefont, 0, 7));
string remarks = "Remark:\n" + maindt.Rows[0]["Remarks"].ToString();
pt1.addCell(CellValue(remarks, false, bluefont, 0, 7));
doc.Add(pt1);
}
public void AddQuotationInfo()
{
PdfPTable pt = new PdfPTable(4);
pt.WidthPercentage = 100;
pt.addCell(CellValue(@"Company:", false, boldfont, 0));
pt.addCell(CellValue(maindt.Rows[0]["OEM"].ToString(), false, bluefont, 0));
pt.addCell(CellValue(@"Date:", false, boldfont, 0));
pt.addCell(CellValue(Convert.ToDateTime(maindt.Rows[0]["CustomerQuoteDate"]).ToString("MM/dd/yyyy"), false, bluefont, 0));
pt.addCell(CellValue(@"Attention :", false, boldfont, 0));
pt.addCell(CellValue(maindt.Rows[0]["CustomerContact"].ToString(), false, bluefont, 0));
pt.addCell(CellValue(@"RFQ# :", false, boldfont, 0));
pt.addCell(CellValue(maindt.Rows[0]["ExtNumber"].ToString(), false, bluefont, 0));
pt.addCell(CellValue(@"Customer PN :", false, boldfont, 0));
pt.addCell(CellValue(maindt.Rows[0]["CustomerPartNumber"].ToString(), false, bluefont, 0));
pt.addCell(CellValue(@"", false, boldfont, 0));
pt.addCell(CellValue("", false, bluefont, 0));
doc.Add(pt);
doc.Add(new Phrase("" + System.Environment.NewLine));
PdfPTable pt1 = new PdfPTable(1);
pt1.WidthPercentage = 100;
pt1.addCell(CellValue(@"Thank you for your inquiry, we are pleased to provide quotation for the requested flexible circuits as follow:", false, defaultfont, 0));
doc.Add(pt1);
}
