using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using LabelManager2;
namespace test01
{
public partial class Form1 : Form
{
public string PO_PO;
public string APPLEID;
public string SERIAL;
public string MODEL;
public string SHIPADTE;
public string PROJECT_CODE;
public string PROJECT_NAME;
public Form1()
{
InitializeComponent();
}
LabelManager2.ApplicationClass lbl = new LabelManager2.ApplicationClass();
private void button1_Click(object sender, EventArgs e)
{
LabelManager2.Document doc = lbl.ActiveDocument;
try
{
doc.Printer.SwitchTo("Zebra 100Xi4 (600 dpi)", "USB001", true);//选择打印机
DataTable d = CsvTest();
PO_PO = d.Rows[0][1].ToString();
APPLEID = d.Rows[1][2].ToString();
SERIAL = d.Rows[2][3].ToString();
MODEL = dataGridView1.Rows[0].Cells[3].Value.ToString();
SHIPADTE = dataGridView1.Rows[0].Cells[4].Value.ToString();
PROJECT_CODE = dataGridView1.Rows[0].Cells[5].Value.ToString();
PROJECT_NAME = dataGridView1.Rows[0].Cells[6].Value.ToString();
doc.Variables.FormVariables.Item("PO_PO").Value = PO_PO;
doc.Variables.FormVariables.Item("APPLEID").Value = APPLEID;
doc.Variables.FormVariables.Item("SERIAL").Value = SERIAL;
doc.Variables.FormVariables.Item("MODEL").Value = MODEL;
doc.Variables.FormVariables.Item("SHIPDATE").Value = SHIPADTE;
doc.Variables.FormVariables.Item("项目编号:").Value = PROJECT_CODE;
doc.Variables.FormVariables.Item("项目名称:").Value = PROJECT_NAME;
doc.Variables.FormVariables.Item("PN_2D").Value = PROJECT_CODE + PO_PO + APPLEID;
doc.PrintLabel(1, 1, 1, 1, 1, "");//打印
doc.FormFeed();
}
catch (Exception ex){
MessageBox.Show(ex.Message);
}
}
void openFile()
{
string strFile = @"D:\RMO\From_ftp_192_168_30_14_RMO\From_ftp_192_168_30_14_RMO\test.Lab";//lab文件路径
lbl.Documents.Open(strFile, false);//比较费时间
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
lbl.Documents.CloseAll(false);
lbl.Quit();
}
catch
{ }
}
private void Form1_Load_1(object sender, EventArgs e)
{
openFile();
}
private DataTable CsvTest()
{
//string sql = "insert into student(name, age, perfer, city) values (@name, @age, @perfer, @city)";
//DataTable dt = Class1.OpenCSV(@"E:\test.csv");
//string s = "";
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// {
// int age = 0;
// try { age = int.Parse(dt.Rows[i][1].ToString()); }
// catch { age = 0; }
// List<SqlParameter> pars = new List<SqlParameter>();
// pars.Add(new SqlParameter("@name", dt.Rows[i][0].ToString()));
// pars.Add(new SqlParameter("@age", age));
// pars.Add(new SqlParameter("@perfer", dt.Rows[i][2].ToString()));
// pars.Add(new SqlParameter("@city", dt.Rows[i][3].ToString()));
// int rst = SqlHelper.ExecuteQuery(sql, pars.ToArray());
// }
//}
string sql = "select name, age, perfer, city from student";
//DataSet ds = SqlHelper.ExecuteDataSet(sql);
DataTable dt = SqlHelper.ExecuteDataTable(sql);
CsvHelper.SaveCSV(dt, @"E:\test1.csv");
return dt;
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using LabelManager2;
namespace test01
{
public partial class Form1 : Form
{
public string PO_PO;
public string APPLEID;
public string SERIAL;
public string MODEL;
public string SHIPADTE;
public string PROJECT_CODE;
public string PROJECT_NAME;
public Form1()
{
InitializeComponent();
}
LabelManager2.ApplicationClass lbl = new LabelManager2.ApplicationClass();
private void button1_Click(object sender, EventArgs e)
{
LabelManager2.Document doc = lbl.ActiveDocument;
try
{
doc.Printer.SwitchTo("Zebra 100Xi4 (600 dpi)", "USB001", true);//选择打印机
DataTable d = CsvTest();
PO_PO = d.Rows[0][1].ToString();
APPLEID = d.Rows[1][2].ToString();
SERIAL = d.Rows[2][3].ToString();
MODEL = dataGridView1.Rows[0].Cells[3].Value.ToString();
SHIPADTE = dataGridView1.Rows[0].Cells[4].Value.ToString();
PROJECT_CODE = dataGridView1.Rows[0].Cells[5].Value.ToString();
PROJECT_NAME = dataGridView1.Rows[0].Cells[6].Value.ToString();
doc.Variables.FormVariables.Item("PO_PO").Value = PO_PO;
doc.Variables.FormVariables.Item("APPLEID").Value = APPLEID;
doc.Variables.FormVariables.Item("SERIAL").Value = SERIAL;
doc.Variables.FormVariables.Item("MODEL").Value = MODEL;
doc.Variables.FormVariables.Item("SHIPDATE").Value = SHIPADTE;
doc.Variables.FormVariables.Item("项目编号:").Value = PROJECT_CODE;
doc.Variables.FormVariables.Item("项目名称:").Value = PROJECT_NAME;
doc.Variables.FormVariables.Item("PN_2D").Value = PROJECT_CODE + PO_PO + APPLEID;
doc.PrintLabel(1, 1, 1, 1, 1, "");//打印
doc.FormFeed();
}
catch (Exception ex){
MessageBox.Show(ex.Message);
}
}
void openFile()
{
string strFile = @"D:\RMO\From_ftp_192_168_30_14_RMO\From_ftp_192_168_30_14_RMO\test.Lab";//lab文件路径
lbl.Documents.Open(strFile, false);//比较费时间
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
lbl.Documents.CloseAll(false);
lbl.Quit();
}
catch
{ }
}
private void Form1_Load_1(object sender, EventArgs e)
{
openFile();
}
private DataTable CsvTest()
{
//string sql = "insert into student(name, age, perfer, city) values (@name, @age, @perfer, @city)";
//DataTable dt = Class1.OpenCSV(@"E:\test.csv");
//string s = "";
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// {
// int age = 0;
// try { age = int.Parse(dt.Rows[i][1].ToString()); }
// catch { age = 0; }
// List<SqlParameter> pars = new List<SqlParameter>();
// pars.Add(new SqlParameter("@name", dt.Rows[i][0].ToString()));
// pars.Add(new SqlParameter("@age", age));
// pars.Add(new SqlParameter("@perfer", dt.Rows[i][2].ToString()));
// pars.Add(new SqlParameter("@city", dt.Rows[i][3].ToString()));
// int rst = SqlHelper.ExecuteQuery(sql, pars.ToArray());
// }
//}
string sql = "select name, age, perfer, city from student";
//DataSet ds = SqlHelper.ExecuteDataSet(sql);
DataTable dt = SqlHelper.ExecuteDataTable(sql);
CsvHelper.SaveCSV(dt, @"E:\test1.csv");
return dt;
}
}
}
无法嵌入互操作类型“Microsoft.Office.Interop.Word.ApplicationClass”。请改用适用的接口。
错误 4317 无法嵌入互操作类型“Microsoft.Office.Interop.Word.ApplicationClass”。请改用适用的接口。
类型“Microsoft.Office.Interop.Word.ApplicationClass”未定义构造函数
解决办法:
在Visual Studio 中点击菜单项“视图->解决方案资源管理器”,在其中点开“引用”文件夹,在"Microsoft.Office.Interop.Word" 上点击鼠标右键,选择“属性”,将属性中的“嵌入互操作类型”的值改为“false”即可。