public PartImport(string mTbl, string sTbl, MDB_DAO md, string execPath)
{
string err = "";
mdbTbl = mTbl;
sqlTbl = sTbl;
mdbDao = md;
sqlDao = new SQL_DAO();
mCOLS.Clear();
doneCount = 0;
err = fileDao.PathInit(execPath);
Logger.WriteLog("Path Configuration: " + err);
}
public void DoInit(string srcTbl, string dstTbl, MDB_DAO mdb)
{
this.mdbDao = mdb;
this.sqlTbl = dstTbl;
this.mdbTbl = srcTbl;
this.mdbTmp = mdbTbl + "_TMP";
sqlDao = new SQL_DAO();
}
public void SetDaoAndTable(MDB_DAO mdb, SQLdb_DAO sql, string src, string dst)
{
mdbDao = mdb;
sqlDao = sql;
srcTable = src;
dstTable = dst;
}
public GDFG_MDB(String accessFile)
{
mdbDao = new MDB_DAO(accessFile);
}
public void InitDao(MDB_DAO mdb, string mdbTbl, string sqlTbl, string execPath)
{
this.mdbDao = mdb;
this.mdbTbl = mdbTbl;
this.sqlTbl = sqlTbl;
sqlDao = new SQL_DAO();
string err = fileDao.PathInit(execPath);
Logger.WriteLog("Path Configuration: " + err);
}
/// <summary>
/// 列出所有ACCESS数据库表
/// </summary>
/// <param name="mdbFile"></param>
private void listMdbTables(String mdbFile)
{
mdbDao = new MDB_DAO(mdbFile);
List<String> tblNameList = mdbDao.GetMdbTableName();
DataTable dt = new DataTable();
dt.Columns.Add("目标");
dt.Columns.Add("源");
mdbTblNum = 0;
foreach (String tblName in tblNameList)
{
DataRow dr;
dr = dt.NewRow();
dr[0] = tblName;
dr[1] = "";
dt.Rows.Add(dr);
mdbTblNum++;
}
this.dgvMdb.DataSource = dt;
}