//private static string basePath = ConfigurationSettings.AppSettings["Dbf"].ToString(); /// <summary> /// 打开Dbf文件 /// </summary> /// <param name="dbfFile">Dbf文件</param> /// <returns></returns> public static DataTable OpenDbfFile(string date) { string tabel = "";// AkConfig.DbfBasePath + date + @"\GNDITEM.Dbf"; if (!File.Exists(tabel)) { return(null); } DataTable dt = null; DBFFile dbfFile = new DBFFile(tabel); try { dbfFile.Open(); dt = dbfFile.GetDataSet().Tables[0]; } catch (Exception er) { LogHelper.Error(typeof(DbfHelper) + ".OpenDbfFile Exception error=", er.ToString()); } finally { dbfFile.Close(); } return(dt); }
/// <summary> /// 读取历史数据 /// </summary> /// <param name="dbfFile">Dbf文件</param> /// <returns></returns> public static DataTable OpenDbfFile(string date) { if (string.IsNullOrEmpty(AkConfig.AkDir)) { return(null); } string table = string.Empty; if (string.IsNullOrEmpty(date)) { table = Path.Combine(AkConfig.AkDir, @"DATA\GNDSALE.Dbf"); } else { table = Path.Combine(AkConfig.AkDir, date + @"\GNDSALE.Dbf"); } if (!File.Exists(table)) { return(null); } DataTable dt = null; DBFFile dbfFile = new DBFFile(table); try { dbfFile.Open(); dt = dbfFile.GetDataSet().Tables[0]; } catch (Exception er) { LogHelper.Error(typeof(DbfHelper) + ".OpenDbfFile Exception error=", er.ToString()); } finally { dbfFile.Close(); } return(dt); }