汉字转拼音
1, HxfPinYin
这是我自己根据网上大神提供的源码, 再. net core 框架下编译出的类库
主要提供汉字转拼音的功能.
使用
public static class Pinyin
- {
- public static string ConvertEncoding(string text, Encoding srcEncoding, Encoding dstEncoding);
- public static string GetChineseText(string pinyin);
- public static string GetChineseText(string pinyin, Encoding encoding);
- public static string GetInitials(string text);
- public static string GetInitials(string text, Encoding encoding);
- public static string GetPinyin(string text);
- public static string GetPinyin(string text, Encoding encoding);
- public static string GetPinyin(char ch);
- public static string GetPinyin(char ch, Encoding encoding);
- }
excel 操作
1,EPPlus.Core
生成 excel 表格
- string sFileName = $"{Guid.NewGuid()}.xlsx";
- FileInfo file = new FileInfo(sFileName);
- string[] title = { "货品编号",
- "货品名称",
- "条码",
- "规格",
- "基本单位",
- "当前库存",
- "库存下限",
- "库存上限"
- };
- using (ExcelPackage package = new ExcelPackage(file))
- {
- ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("库存信息");
- int index = 1;
- foreach (string t in title)
- {
- worksheet.Cells[1, index++].Value = t;
- }
- index = 2;
- foreach (var d in list)
- {
- worksheet.Cells[index,1].Value = d.ProductCode;
- worksheet.Cells[index, 2].Value = d.ProductName;
- worksheet.Cells[index, 3].Value = d.BarCode;
- worksheet.Cells[index, 4].Value = d.SpecValues;
- worksheet.Cells[index, 5].Value = d.BaseUnit;
- worksheet.Cells[index, 6].Value = d.Quantity;
- worksheet.Cells[index, 7].Value = d.DownLimitQuantity;
- worksheet.Cells[index, 8].Value = d.UpLimitQuantity;
- index++;
- }
- package.Save();
- }
pdf 操作
1,iTextSharp.LGPLv2.Core
生成 pdf
- string tempFilePath = $"{Guid.NewGuid()}.pdf";
- string[] title = { "货品编号",
- "货品名称",
- "条码",
- "规格",
- "基本单位",
- "当前库存",
- "库存下限",
- "库存上限"
- };
- using (FileStream wfs = new FileStream(tempFilePath, FileMode.OpenOrCreate)) {
- //PageSize.A4.Rotate(); 当需要把 PDF 纸张设置为横向时
- Document docPDF = new Document(PageSize.A4,10, 10, 20,20);
- PdfWriter write = PdfWriter.GetInstance(docPDF, wfs);
- docPDF.Open();
- // 在这里需要注意的是, itextsharp 不支持中文字符, 想要显示中文字符的话需要自己设置字体
- BaseFont bsFont = BaseFont.CreateFont(@"C:\Windows\Fonts\simsun.ttc,0", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
- Font font = new Font(bsFont);
- float[] clos = new float[] { 40,40,40,20,20,30,30,30};// 宽度
- PdfPTable tablerow1 = new PdfPTable(clos);
- foreach (string t in title)
- {
- PdfPCell cell = new PdfPCell(new Paragraph(t, font));
- cell.MinimumHeight = 4f;
- tablerow1.AddCell(cell);
- }
- foreach (var d in list)
- {
- tablerow1.AddCell(new PdfPCell(new Paragraph(d.ProductCode, font)));
- tablerow1.AddCell(new PdfPCell(new Paragraph(d.ProductName, font)));
- tablerow1.AddCell(new PdfPCell(new Paragraph(d.BarCode, font)));
- tablerow1.AddCell(new PdfPCell(new Paragraph(d.SpecValues, font)));
- tablerow1.AddCell(new PdfPCell(new Paragraph(d.BaseUnit, font)));
- tablerow1.AddCell(new PdfPCell(new Paragraph(d.Quantity.ToString(), font)));
- tablerow1.AddCell(new PdfPCell(new Paragraph(d.DownLimitQuantity.ToString(), font)));
- tablerow1.AddCell(new PdfPCell(new Paragraph(d.UpLimitQuantity.ToString(), font)));
- }
- docPDF.Add(tablerow1);// 将表格添加到 pdf 文档中
- docPDF.Close();// 关闭
- write.Close();
- wfs.Close();
- }
来源: http://www.jianshu.com/p/fec63cade243