資源簡介
讓更多的人知道如何用C#操作斑馬條碼打印機(jī),多格式,多種通訊方式打印

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Configuration;
using?System.Data;
using?System.Data.OleDb;
using?System.Text;
using?System.IO;
namespace?掃碼打印工具
{
????public?class?AccessHelper
????{
????????protected?static?OleDbConnection?conn?=?new?OleDbConnection();
????????protected?static?OleDbCommand?comm?=?new?OleDbCommand();
????????private?string?dbpath?=?““;
????????public?AccessHelper(string?path)
????????{
????????????dbpath?=?path;
????????}
????????///?
????????///?打開數(shù)據(jù)庫
????????///?
????????private?void?Connection()
????????{
????????????string?dsource?=?dbpath;
????????????if?(!System.IO.File.Exists(dsource))
????????????{
????????????????throw?new?Exception(“未找到數(shù)據(jù)文件!“);
????????????}
????????????if?(conn.State?==?ConnectionState.Closed)
????????????{
????????????????//conn.ConnectionString?=?@“Provider=Microsoft.ACE.OLEDB.12.0;Data?Source=“?+?AppDomain.CurrentDomain.baseDirectory?+?ConfigurationManager.AppSettings[“myconn“].ToString()?+?“;Jet?OLEDB:Database?PassWord=sa“;
????????????????conn.ConnectionString?=?@“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?dsource?+?“;Persist?Security?Info=False“;
????????????????//conn.ConnectionString?=?@“Provider=Microsoft.Jet.OLEDB.12.0;Data?Source=Results.Mdb;Persist?Security?Info=False“;
????????????????comm.Connection?=?conn;
????????????????try
????????????????{
????????????????????conn.Open();
????????????????}
????????????????catch?(Exception?e)
????????????????{
????????????????????if?(e.Message.IndexOf(“4.0“)?>?-1)
????????????????????{
????????????????????????try
????????????????????????{
????????????????????????????conn.ConnectionString?=?@“Provider=Microsoft.ACE.OLEDB.12.0;Data?Source=“?+?dsource?+?“;Persist?Security?Info=False“;
????????????????????????????comm.Connection?=?conn;
????????????????????????????conn.Open();
????????????????????????}
????????????????????????catch?(Exception?ex)?{?throw?new?Exception(ex.Message);?}
????????????????????}
????????????????????else
????????????????????{
????????????????????????throw?new?Exception(e.Message);
????????????????????}
????????????????}
????????????}
????????}
????????///?
????????///?關(guān)閉數(shù)據(jù)庫
????????///?
????????private?void?DisConnection()
????????{
????????????if?(conn.State?==?ConnectionState.Open)
????????????{
????????????????conn.Close();
????????????????conn.Dispose();
????????????????comm.Dispose();
????????????}
????????}
????????///?
????????///?執(zhí)行sql語句
????????///?
????????///?
????????public?void?EexcuteSql(string?sqlstr)
????????{
????????????try
????????????{
????????????????Connection();
????????????????comm.CommandType?=?CommandType.Text;
????????????????comm.CommandText?=?sqlstr;
????????????????comm.ExecuteNonQuery();
????????????}
????????????catch?(Exception?e)
????????????{
????????????????throw?new?Exception(e.Mess
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
????..A..H.?????53248??2019-04-04?15:44??掃碼打印工具\(yùn).vs\掃碼打印工具\(yùn)v15\.suo
?????文件??????????0??2019-04-04?15:42??掃碼打印工具\(yùn).vs\掃碼打印工具\(yùn)v15\Server\sqlite3\db.lock
?????文件???????4096??2019-04-04?15:42??掃碼打印工具\(yùn).vs\掃碼打印工具\(yùn)v15\Server\sqlite3\storage.ide
?????文件??????32768??2019-04-04?15:42??掃碼打印工具\(yùn).vs\掃碼打印工具\(yùn)v15\Server\sqlite3\storage.ide-shm
?????文件?????712792??2019-04-04?15:44??掃碼打印工具\(yùn).vs\掃碼打印工具\(yùn)v15\Server\sqlite3\storage.ide-wal
?????文件???????9004??2018-02-08?11:49??掃碼打印工具\(yùn)掃碼打印工具\(yùn)AccessHelper.cs
?????文件????????144??2018-02-27?17:32??掃碼打印工具\(yùn)掃碼打印工具\(yùn)App.config
?????文件????4063232??2018-03-02?13:07??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\2017-09-14.Mdb
?????文件?????214016??2017-10-31?20:34??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\Trace.Common.UnicodeToZPL.dll
?????文件???????4659??2017-10-31?20:31??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\Trace.Common.UnicodeToZPL.xm
?????文件??????60928??2018-03-02?13:57??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\掃碼打印工具.exe
?????文件????????160??2018-03-02?11:58??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\掃碼打印工具.exe.config
?????文件??????67072??2018-03-02?13:57??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\掃碼打印工具.pdb
?????文件??????11600??2018-03-02?11:39??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\掃碼打印工具.vshost.exe
?????文件????????144??2018-02-27?17:32??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\掃碼打印工具.vshost.exe.config
?????文件????????490??2010-03-17?22:39??掃碼打印工具\(yùn)掃碼打印工具\(yùn)bin\Debug\掃碼打印工具.vshost.exe.manifest
?????文件???????8893??2018-03-02?13:57??掃碼打印工具\(yùn)掃碼打印工具\(yùn)Form1.cs
?????文件??????15038??2018-03-02?11:52??掃碼打印工具\(yùn)掃碼打印工具\(yùn)Form1.Designer.cs
?????文件??????20617??2018-03-02?11:52??掃碼打印工具\(yùn)掃碼打印工具\(yùn)Form1.resx
?????文件???????1970??2018-03-02?11:39??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件???????6474??2018-03-02?13:57??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????4608??2018-02-27?17:32??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\TempPE\Properties.Resources.Designer.cs.dll
?????文件?????????42??2019-04-04?15:42??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\掃碼打印工具.csproj.CoreCompileInputs.cache
?????文件????????976??2018-03-02?11:39??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\掃碼打印工具.csproj.FileListAbsolute.txt
?????文件????????975??2018-03-02?11:56??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\掃碼打印工具.csproj.GenerateResource.Cache
?????文件??????30125??2019-04-04?15:42??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\掃碼打印工具.csprojAssemblyReference.cache
?????文件???????6002??2018-03-02?11:46??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\掃碼打印工具.csprojResolveAssemblyReference.cache
?????文件??????60928??2018-03-02?13:57??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\掃碼打印工具.exe
?????文件??????10228??2018-03-02?11:56??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\掃碼打印工具.Form1.resources
?????文件??????67072??2018-03-02?13:57??掃碼打印工具\(yùn)掃碼打印工具\(yùn)obj\x86\Debug\掃碼打印工具.pdb
............此處省略29個(gè)文件信息
評論
共有 條評論