internal static void ExportCK(string rkid) { ExcelAccess ea = new ExcelAccess(); string filename = AppDomain.CurrentDomain.BaseDirectory + "\\00记录模板\\.xls"; if (!File.Exists(filename)) { //导出资源文件到本机 Stream obj = typeof(PrintHelper).Assembly.GetManifestResourceStream("Ebada.Kcgl._00记录模板..xls"); object[] files = typeof(PrintHelper).Assembly.GetManifestResourceNames(); if (obj != null) { byte[] buff = new byte[obj.Length]; obj.Read(buff, 0, (int)obj.Length); FileStream fs = new FileStream(filename, FileMode.OpenOrCreate); fs.Write(buff, 0, buff.Length); fs.Flush(); fs.Close(); fs.Dispose(); } } ea.Open(filename); //显示文件 ea.Print(); ea.DisPoseExcel(); }
public static void Print(PrintType printType, BarcodeSample sample, TestResult technic, TestResult reality) { ExcelAccess access = new ExcelAccess(); string path = ConfigurationManager.AppSettings["template"]; string fullPath = Path.GetFullPath(path); access.Open(fullPath); access.IsVisibledExcel = true; access.FormCaption = "商品条码符号检测数据"; switch (printType) { case PrintType.Print: access.Print(); break; case PrintType.PrintView: access.PrintPreview(); break; default: access.Close(); break; } access.Close(); }
/// <summary> /// 根据入库单id,导出入库单 /// </summary> /// <param name="rkid"></param> internal static void ExportRK(string rkid) { ExcelAccess ea = new ExcelAccess(); string filename=AppDomain.CurrentDomain.BaseDirectory+"\\00记录模板\\.xls"; if (!File.Exists(filename)) { //导出资源文件到本机 Stream obj = typeof(PrintHelper).Assembly.GetManifestResourceStream("Ebada.Kcgl._00记录模板..xls"); object[] files = typeof(PrintHelper).Assembly.GetManifestResourceNames(); if (obj != null) { byte[] buff = new byte[obj.Length]; obj.Read(buff, 0, (int)obj.Length); FileStream fs = new FileStream(filename, FileMode.OpenOrCreate); fs.Write(buff, 0, buff.Length); fs.Flush(); fs.Close(); fs.Dispose(); } } ea.Open(filename); JH_yearks rkobj=Client.ClientHelper.TransportSqlMap.GetOneByKey<JH_yearks>(rkid); if(rkobj==null)return; int brow = 5; int bcol = 2; //填充数据 //for (int i = 0; i < list.Count; i++) { // var obj = list[i]; // ea.SetCellValue((i+1).ToString(), i + brow, bcol-1); // ea.SetCellValue(kcname, i + brow, bcol); // ea.SetCellValue(obj.供货厂家, i + brow, bcol + 1); // ea.SetCellValue(obj.材料名称, i + brow, bcol + 2); // ea.SetCellValue(obj.规格及型号, i + brow, bcol + 3); // ea.SetCellValue(obj.计量单位, i + brow, bcol + 4); // ea.SetCellValue(obj.数量.ToString(), i + brow, bcol + 5); // ea.SetCellValue(obj.备注, i + brow, bcol + 6); //} //显示文件 ea.Print(); ea.DisPoseExcel(); }