DbfFileImport.cs 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using System.IO;
  5. namespace FastReport.Map.Import.Shp
  6. {
  7. /// <summary>
  8. /// Represents loading map data from dbf-file.
  9. /// </summary>
  10. public class DbfFileImport
  11. {
  12. #region Fields
  13. private string filter;
  14. private Stream stream;
  15. private MapLayer layer;
  16. private List<DBaseFieldDescription> fields;
  17. private Encoding encoding;
  18. #endregion // Fields
  19. #region Properties
  20. /// <summary>
  21. /// Gets or sets the filter string used in an open file dialog.
  22. /// </summary>
  23. public string Filter
  24. {
  25. get { return filter; }
  26. protected set { filter = value; }
  27. }
  28. #endregion // Properties
  29. #region Constructors
  30. /// <summary>
  31. /// Initializes a new instance of the <see cref="DbfFileImport"/> class.
  32. /// </summary>
  33. public DbfFileImport()
  34. {
  35. filter = GetFilter();
  36. fields = new List<DBaseFieldDescription>();
  37. encoding = Encoding.ASCII;
  38. }
  39. #endregion // Constructors
  40. #region Private Methods
  41. private void LoadFieldsDescription()
  42. {
  43. byte[] buffer = new byte[11];
  44. string name = "";
  45. string type = "";
  46. int length = 0;
  47. stream.Seek(32, SeekOrigin.Begin);
  48. for (int i = 0; i < 128; i++)
  49. {
  50. stream.Read(buffer, 0, 11);
  51. name = encoding.GetString(buffer);
  52. name = name.Remove(name.IndexOf('\0'));
  53. stream.Read(buffer, 0, 1);
  54. type = encoding.GetString(buffer, 0, 1);
  55. stream.Seek(4, SeekOrigin.Current);
  56. stream.Read(buffer, 0, 1);
  57. length = (int)buffer[0];
  58. fields.Add(new DBaseFieldDescription(name, type, length));
  59. stream.Seek(15, SeekOrigin.Current);
  60. stream.Read(buffer, 0, 1);
  61. if (buffer[0] == 0x0D)
  62. {
  63. break;
  64. }
  65. else
  66. {
  67. stream.Seek(-1, SeekOrigin.Current);
  68. }
  69. }
  70. }
  71. private string LoadField(int length)
  72. {
  73. string field = "";
  74. byte[] buffer = new byte[length];
  75. stream.Read(buffer, 0, length);
  76. field = encoding.GetString(buffer);
  77. return field;
  78. }
  79. private string LoadChar(int length)
  80. {
  81. string field = LoadField(length);
  82. field = field.TrimEnd(null);
  83. return field;
  84. }
  85. private string LoadDate(int length)
  86. {
  87. string field = LoadField(length);
  88. char[] f = field.ToCharArray();
  89. field = f[6].ToString() + f[7].ToString() + "." + f[4].ToString() + f[5].ToString() + "." + f[0].ToString() + f[1].ToString() + f[2].ToString() + f[3].ToString();
  90. return field;
  91. }
  92. private string LoadNumeric(int length)
  93. {
  94. string field = LoadField(length);
  95. field = field.Trim();
  96. return field;
  97. }
  98. private string LoadLogical(int length)
  99. {
  100. string field = LoadField(length).ToUpper();
  101. if (field == "T" || field == "Y")
  102. {
  103. field = "true";
  104. }
  105. else if (field == "F" || field == "N")
  106. {
  107. field = "false";
  108. }
  109. else
  110. {
  111. field = "";
  112. }
  113. return field;
  114. }
  115. private void LoadRecords(int numRecords, int recordLength)
  116. {
  117. for (int i = 0; i < numRecords; i++)
  118. {
  119. stream.Seek(1, SeekOrigin.Current);
  120. foreach (DBaseFieldDescription f in fields)
  121. {
  122. string value = "";
  123. switch (f.Type)
  124. {
  125. case DBaseFieldType.Char:
  126. value = LoadChar(f.Length);
  127. break;
  128. case DBaseFieldType.Date:
  129. value = LoadDate(f.Length);
  130. break;
  131. case DBaseFieldType.Numeric:
  132. value = LoadNumeric(f.Length);
  133. break;
  134. case DBaseFieldType.Logical:
  135. value = LoadLogical(f.Length);
  136. break;
  137. }
  138. if (i < layer.Shapes.Count)
  139. layer.Shapes[i].SpatialData.SetValue(f.Name, value);
  140. }
  141. }
  142. }
  143. private Encoding GetEncoding(int id)
  144. {
  145. int codepage = 0;
  146. #region switch
  147. switch (id)
  148. {
  149. case 1:
  150. codepage = 437;
  151. break;
  152. case 2:
  153. codepage = 850;
  154. break;
  155. case 3:
  156. codepage = 1252;
  157. break;
  158. case 4:
  159. codepage = 10000;
  160. break;
  161. case 8:
  162. codepage = 865;
  163. break;
  164. case 9:
  165. codepage = 437;
  166. break;
  167. case 10:
  168. codepage = 850;
  169. break;
  170. case 11:
  171. codepage = 437;
  172. break;
  173. case 13:
  174. codepage = 437;
  175. break;
  176. case 14:
  177. codepage = 850;
  178. break;
  179. case 15:
  180. codepage = 437;
  181. break;
  182. case 16:
  183. codepage = 850;
  184. break;
  185. case 17:
  186. codepage = 437;
  187. break;
  188. case 18:
  189. codepage = 850;
  190. break;
  191. case 19:
  192. codepage = 932;
  193. break;
  194. case 20:
  195. codepage = 850;
  196. break;
  197. case 21:
  198. codepage = 437;
  199. break;
  200. case 22:
  201. codepage = 850;
  202. break;
  203. case 23:
  204. codepage = 865;
  205. break;
  206. case 24:
  207. codepage = 437;
  208. break;
  209. case 25:
  210. codepage = 437;
  211. break;
  212. case 26:
  213. codepage = 850;
  214. break;
  215. case 27:
  216. codepage = 437;
  217. break;
  218. case 28:
  219. codepage = 863;
  220. break;
  221. case 29:
  222. codepage = 850;
  223. break;
  224. case 31:
  225. codepage = 852;
  226. break;
  227. case 34:
  228. codepage = 852;
  229. break;
  230. case 35:
  231. codepage = 852;
  232. break;
  233. case 36:
  234. codepage = 860;
  235. break;
  236. case 37:
  237. codepage = 850;
  238. break;
  239. case 38:
  240. codepage = 866;
  241. break;
  242. case 55:
  243. codepage = 850;
  244. break;
  245. case 64:
  246. codepage = 852;
  247. break;
  248. case 77:
  249. codepage = 936;
  250. break;
  251. case 78:
  252. codepage = 949;
  253. break;
  254. case 79:
  255. codepage = 950;
  256. break;
  257. case 80:
  258. codepage = 874;
  259. break;
  260. case 87:
  261. codepage = 0;
  262. break;
  263. case 88:
  264. codepage = 1252;
  265. break;
  266. case 89:
  267. codepage = 1252;
  268. break;
  269. case 100:
  270. codepage = 852;
  271. break;
  272. case 101:
  273. codepage = 866;
  274. break;
  275. case 102:
  276. codepage = 865;
  277. break;
  278. case 103:
  279. codepage = 861;
  280. break;
  281. case 104:
  282. codepage = 895;
  283. break;
  284. case 105:
  285. codepage = 620;
  286. break;
  287. case 106:
  288. codepage = 737;
  289. break;
  290. case 107:
  291. codepage = 857;
  292. break;
  293. case 108:
  294. codepage = 863;
  295. break;
  296. case 120:
  297. codepage = 950;
  298. break;
  299. case 121:
  300. codepage = 949;
  301. break;
  302. case 122:
  303. codepage = 936;
  304. break;
  305. case 123:
  306. codepage = 932;
  307. break;
  308. case 124:
  309. codepage = 874;
  310. break;
  311. case 134:
  312. codepage = 737;
  313. break;
  314. case 135:
  315. codepage = 852;
  316. break;
  317. case 136:
  318. codepage = 857;
  319. break;
  320. case 150:
  321. codepage = 10007;
  322. break;
  323. case 151:
  324. codepage = 10029;
  325. break;
  326. case 152:
  327. codepage = 10006;
  328. break;
  329. case 200:
  330. codepage = 1250;
  331. break;
  332. case 201:
  333. codepage = 1251;
  334. break;
  335. case 202:
  336. codepage = 1254;
  337. break;
  338. case 203:
  339. codepage = 1253;
  340. break;
  341. case 204:
  342. codepage = 1257;
  343. break;
  344. default:
  345. codepage = 0;
  346. break;
  347. }
  348. #endregion // switch
  349. if (codepage == 0)
  350. {
  351. return Encoding.ASCII;
  352. }
  353. else
  354. {
  355. return Encoding.GetEncoding(codepage);
  356. }
  357. }
  358. private void LoadFileHeader()
  359. {
  360. byte[] buffer = new byte[4];
  361. stream.Seek(0, SeekOrigin.Begin);
  362. stream.Read(buffer, 0, 1);
  363. stream.Seek(4, SeekOrigin.Begin);
  364. stream.Read(buffer, 0, 4);
  365. if (!BitConverter.IsLittleEndian)
  366. {
  367. Array.Reverse(buffer, 0, 4);
  368. }
  369. int numRecords = BitConverter.ToInt32(buffer, 0);
  370. stream.Read(buffer, 0, 2);
  371. if (!BitConverter.IsLittleEndian)
  372. {
  373. Array.Reverse(buffer, 0, 2);
  374. }
  375. int headerLength = (int)BitConverter.ToInt16(buffer, 0);
  376. stream.Read(buffer, 0, 2);
  377. if (!BitConverter.IsLittleEndian)
  378. {
  379. Array.Reverse(buffer, 0, 2);
  380. }
  381. int recordLength = (int)BitConverter.ToInt16(buffer, 0);
  382. stream.Seek(29, SeekOrigin.Begin);
  383. stream.Read(buffer, 0, 1);
  384. encoding = GetEncoding((int)buffer[0]);
  385. LoadFieldsDescription();
  386. LoadRecords(numRecords, recordLength);
  387. }
  388. private void LoadFile(MapLayer layer, Stream stream)
  389. {
  390. this.stream = stream;
  391. this.layer = layer;
  392. LoadFileHeader();
  393. }
  394. #endregion // Private Methods
  395. #region Protected Methods
  396. /// <summary>
  397. /// Returns a file filter for an open file dialog.
  398. /// </summary>
  399. /// <returns>String that contains a file filter.</returns>
  400. protected string GetFilter()
  401. {
  402. return new FastReport.Utils.MyRes("FileFilters").Get("DbfFile");
  403. }
  404. #endregion // Protected Methods
  405. #region Public Methods
  406. /// <summary>
  407. /// Imports the map data from a specified file into a specfied layer.
  408. /// </summary>
  409. /// <param name="layer">The MapObject for an importing map.</param>
  410. /// <param name="filename">The name of a file that contains map.</param>
  411. public void ImportFile(MapLayer layer, string filename)
  412. {
  413. using (FileStream stream = new FileStream(filename, FileMode.Open, FileAccess.Read))
  414. {
  415. LoadFile(layer, stream);
  416. }
  417. }
  418. #endregion // Public Methods
  419. }
  420. /// <summary>
  421. /// Represents the description of dBase field.
  422. /// </summary>
  423. public class DBaseFieldDescription
  424. {
  425. #region Fields
  426. private string name;
  427. private DBaseFieldType type;
  428. private int length;
  429. #endregion // Fields
  430. #region Properties
  431. /// <summary>
  432. /// Gets the field name.
  433. /// </summary>
  434. public string Name
  435. {
  436. get { return name; }
  437. }
  438. /// <summary>
  439. /// Gets the field type.
  440. /// </summary>
  441. public DBaseFieldType Type
  442. {
  443. get { return type; }
  444. }
  445. /// <summary>
  446. /// Gets the field length.
  447. /// </summary>
  448. public int Length
  449. {
  450. get { return length; }
  451. }
  452. #endregion // Properties
  453. #region Constructors
  454. /// <summary>
  455. /// Initializes a new instance of the <see cref="DBaseFieldDescription"/> class.
  456. /// </summary>
  457. public DBaseFieldDescription()
  458. {
  459. name = "";
  460. type = DBaseFieldType.Char;
  461. length = 0;
  462. }
  463. /// <summary>
  464. /// Initializes a new instance of the <see cref="DBaseFieldDescription"/> class with a specified parameters.
  465. /// </summary>
  466. /// <param name="name">The field name.</param>
  467. /// <param name="type">The field type.</param>
  468. /// <param name="length">The field length.</param>
  469. public DBaseFieldDescription(string name, DBaseFieldType type, int length)
  470. {
  471. this.name = name;
  472. this.type = type;
  473. this.length = length;
  474. }
  475. /// <summary>
  476. /// Initializes a new instance of the <see cref="DBaseFieldDescription"/> class with a specified parameters.
  477. /// </summary>
  478. /// <param name="name">The field name.</param>
  479. /// <param name="type">The field type.</param>
  480. /// <param name="length">The field length.</param>
  481. public DBaseFieldDescription(string name, string type, int length)
  482. {
  483. this.name = name;
  484. InitType(type);
  485. this.length = length;
  486. }
  487. #endregion // Constructors
  488. #region Private Methods
  489. private void InitType(string type)
  490. {
  491. if (type == "C")
  492. {
  493. this.type = DBaseFieldType.Char;
  494. }
  495. else if (type == "D")
  496. {
  497. this.type = DBaseFieldType.Date;
  498. }
  499. else if (type == "N")
  500. {
  501. this.type = DBaseFieldType.Numeric;
  502. }
  503. else if (type == "L")
  504. {
  505. this.type = DBaseFieldType.Logical;
  506. }
  507. else if (type == "M")
  508. {
  509. this.type = DBaseFieldType.Memo;
  510. }
  511. else
  512. {
  513. this.type = DBaseFieldType.Char;
  514. }
  515. }
  516. #endregion // Private Methods
  517. }
  518. /// <summary>
  519. /// The type of dBase field.
  520. /// </summary>
  521. public enum DBaseFieldType
  522. {
  523. /// <summary>
  524. /// Character field.
  525. /// </summary>
  526. Char,
  527. /// <summary>
  528. /// Date field.
  529. /// </summary>
  530. Date,
  531. /// <summary>
  532. /// Numeric field.
  533. /// </summary>
  534. Numeric,
  535. /// <summary>
  536. /// Logical field.
  537. /// </summary>
  538. Logical,
  539. /// <summary>
  540. /// Memo field.
  541. /// </summary>
  542. Memo
  543. }
  544. }