112 lines
3.9 KiB
C#
112 lines
3.9 KiB
C#
using System;
|
||
//using System.Collections.Generic;
|
||
using System.Text;
|
||
using System.Data;
|
||
using System.Data.SqlClient;
|
||
using System.Net;
|
||
using System.Web;
|
||
using System.IO;
|
||
using System.Text.RegularExpressions;
|
||
using System.Net.Sockets;
|
||
using System.Configuration;
|
||
|
||
using System.Collections;
|
||
using System.Collections.Specialized;
|
||
|
||
using System.Data.OleDb;
|
||
//using SystemFramework;
|
||
|
||
|
||
namespace DataLinkMesWork
|
||
{
|
||
public partial class DataAccess
|
||
{
|
||
/// <summary>
|
||
/// 获得Excel连接
|
||
/// </summary>
|
||
/// <param name="filename"></param>
|
||
/// <returns></returns>
|
||
public static string ConnectString_OleDb(string filename)
|
||
{
|
||
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=\"" + filename + "\""; ;
|
||
strConn += ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\"";
|
||
return strConn;
|
||
}
|
||
|
||
|
||
/// <summary>
|
||
///
|
||
/// </summary>
|
||
/// <param name="filename"></param>
|
||
/// <returns></returns>
|
||
public static OleDbConnection getConn_OleDb(string filename)
|
||
{
|
||
string strConnectionstring = ConnectString_OleDb(filename);
|
||
OleDbConnection conn = new OleDbConnection(strConnectionstring);
|
||
conn.Open();
|
||
return conn;
|
||
}
|
||
/// <summary>
|
||
/// 增加Excel数据
|
||
/// </summary>
|
||
/// <param name="sql"></param>
|
||
/// <param name="filename"></param>
|
||
/// <param name="dt"></param>
|
||
/// <param name="oleDbParameter"></param>
|
||
/// <returns></returns>
|
||
public static bool ExecuteDataTable_OleDb_Insert_Excel(string sql, string filename, DataTable dt, ref OleDbParameter[] oleDbParameter)
|
||
{
|
||
string errorMessage;
|
||
string connectionString = ConnectString_OleDb(filename);
|
||
return SQLCommon.ExecuteDataTable_OleDb_Insert(sql, connectionString, dt, ref oleDbParameter, out errorMessage);
|
||
}
|
||
|
||
/// <summary>
|
||
/// 用于 Excel Access
|
||
/// 执行标准SQL语句，不要求返回结果，适合（增、删、改）
|
||
/// </summary>
|
||
/// <param name="sql"></param>
|
||
/// <param name="filename">Excel Access文件</param>
|
||
/// <param name="ErrorMessage"></param>
|
||
/// <returns></returns>
|
||
public static bool ExecuteSQL_OleDb(string sql, string filename, out string ErrorMessage)
|
||
{
|
||
string strConnectionstring;
|
||
strConnectionstring = ConnectString_OleDb(filename);
|
||
ErrorMessage = "";
|
||
return SQLCommon.ExecuteNonQuery_OleDb(sql, strConnectionstring, out ErrorMessage);
|
||
}
|
||
/// <summary>
|
||
///
|
||
/// </summary>
|
||
/// <param name="sql"></param>
|
||
/// <param name="filename"></param>
|
||
/// <param name="ErrorMessage"></param>
|
||
/// <returns></returns>
|
||
public static bool ExecuteSQL_OleDb(StringCollection sql, string filename, out string ErrorMessage)
|
||
{
|
||
string strConnectionstring;
|
||
strConnectionstring = ConnectString_OleDb(filename);
|
||
ErrorMessage = "";
|
||
return SQLCommon.ExecuteNonQuery_OleDb(sql, strConnectionstring, out ErrorMessage);
|
||
}
|
||
|
||
/// <summary>
|
||
/// 用于 Excel Access
|
||
/// 执行标准SQL查询语句，返回记录集
|
||
/// </summary>
|
||
/// <param name="sql"></param>
|
||
/// <param name="filename"></param>
|
||
/// <param name="dt"></param>
|
||
/// <param name="ErrorMessage"></param>
|
||
/// <returns></returns>
|
||
public static bool ExecuteDataTable_OleDb(string sql, string filename, out DataTable dt, out string ErrorMessage)
|
||
{
|
||
string strConnectionstring;
|
||
strConnectionstring = ConnectString_OleDb(filename);
|
||
ErrorMessage = "";
|
||
return SQLCommon.ExecuteDataTable_OleDb(sql, strConnectionstring, out dt, out ErrorMessage);
|
||
}
|
||
}
|
||
}
|