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();
}
