You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

773 lines
38 KiB

2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
2 years ago
  1. 
  2. namespace ExportDataToFile
  3. {
  4. partial class Form1
  5. {
  6. /// <summary>
  7. /// 設計工具所需的變數。
  8. /// </summary>
  9. private System.ComponentModel.IContainer components = null;
  10. /// <summary>
  11. /// 清除任何使用中的資源。
  12. /// </summary>
  13. /// <param name="disposing">如果應該處置受控資源則為 true,否則為 false。</param>
  14. protected override void Dispose(bool disposing)
  15. {
  16. if (disposing && (components != null))
  17. {
  18. components.Dispose();
  19. }
  20. base.Dispose(disposing);
  21. }
  22. #region Windows Form 設計工具產生的程式碼
  23. /// <summary>
  24. /// 此為設計工具支援所需的方法 - 請勿使用程式碼編輯器修改
  25. /// 這個方法的內容。
  26. /// </summary>
  27. private void InitializeComponent()
  28. {
  29. System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
  30. this.txtTargetID = new System.Windows.Forms.TextBox();
  31. this.label7 = new System.Windows.Forms.Label();
  32. this.txtTargetDBName = new System.Windows.Forms.TextBox();
  33. this.label8 = new System.Windows.Forms.Label();
  34. this.txtTargetIP = new System.Windows.Forms.TextBox();
  35. this.label9 = new System.Windows.Forms.Label();
  36. this.cbTargetClass = new System.Windows.Forms.ComboBox();
  37. this.label10 = new System.Windows.Forms.Label();
  38. this.txtSourceID = new System.Windows.Forms.TextBox();
  39. this.label4 = new System.Windows.Forms.Label();
  40. this.txtSourceDBName = new System.Windows.Forms.TextBox();
  41. this.label3 = new System.Windows.Forms.Label();
  42. this.txtSourceIP = new System.Windows.Forms.TextBox();
  43. this.label2 = new System.Windows.Forms.Label();
  44. this.cbSourceClass = new System.Windows.Forms.ComboBox();
  45. this.label1 = new System.Windows.Forms.Label();
  46. this.btnExport = new System.Windows.Forms.Button();
  47. this.label12 = new System.Windows.Forms.Label();
  48. this.btnTargetConnTest = new System.Windows.Forms.Button();
  49. this.txtTargetPWD = new System.Windows.Forms.TextBox();
  50. this.label6 = new System.Windows.Forms.Label();
  51. this.btnSourceConnTest = new System.Windows.Forms.Button();
  52. this.txtSourcePWD = new System.Windows.Forms.TextBox();
  53. this.label5 = new System.Windows.Forms.Label();
  54. this.dgvExportList = new System.Windows.Forms.DataGridView();
  55. this.label11 = new System.Windows.Forms.Label();
  56. this.dgvColumnMapping = new System.Windows.Forms.DataGridView();
  57. this.txtWhere = new System.Windows.Forms.TextBox();
  58. this.label13 = new System.Windows.Forms.Label();
  59. this.label14 = new System.Windows.Forms.Label();
  60. this.cbTargetTable = new System.Windows.Forms.ComboBox();
  61. this.btnMapping = new System.Windows.Forms.Button();
  62. this.sfPath = new System.Windows.Forms.SaveFileDialog();
  63. this.label15 = new System.Windows.Forms.Label();
  64. this.txtMaxCount = new System.Windows.Forms.TextBox();
  65. this.label16 = new System.Windows.Forms.Label();
  66. this.label17 = new System.Windows.Forms.Label();
  67. this.txtTargetPort = new System.Windows.Forms.TextBox();
  68. this.txtSourcePort = new System.Windows.Forms.TextBox();
  69. this.btnExportXML = new System.Windows.Forms.Button();
  70. this.btnImportXML = new System.Windows.Forms.Button();
  71. this.ofPath = new System.Windows.Forms.OpenFileDialog();
  72. this.btnClean = new System.Windows.Forms.Button();
  73. this.clExport = new System.Windows.Forms.DataGridViewCheckBoxColumn();
  74. this.clCancel = new System.Windows.Forms.DataGridViewButtonColumn();
  75. this.clShow = new System.Windows.Forms.DataGridViewButtonColumn();
  76. this.clSourceTable = new System.Windows.Forms.DataGridViewTextBoxColumn();
  77. this.clTargetTable = new System.Windows.Forms.DataGridViewTextBoxColumn();
  78. this.clTableDel = new System.Windows.Forms.DataGridViewCheckBoxColumn();
  79. this.clWhere = new System.Windows.Forms.DataGridViewTextBoxColumn();
  80. this.clMappingData = new System.Windows.Forms.DataGridViewTextBoxColumn();
  81. this.clExpColumn = new System.Windows.Forms.DataGridViewCheckBoxColumn();
  82. this.clClean = new System.Windows.Forms.DataGridViewButtonColumn();
  83. this.clSourceColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
  84. this.clType = new System.Windows.Forms.DataGridViewTextBoxColumn();
  85. this.clTargetColumn = new System.Windows.Forms.DataGridViewComboBoxColumn();
  86. ((System.ComponentModel.ISupportInitialize)(this.dgvExportList)).BeginInit();
  87. ((System.ComponentModel.ISupportInitialize)(this.dgvColumnMapping)).BeginInit();
  88. this.SuspendLayout();
  89. //
  90. // txtTargetID
  91. //
  92. this.txtTargetID.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  93. this.txtTargetID.Location = new System.Drawing.Point(1218, 48);
  94. this.txtTargetID.Name = "txtTargetID";
  95. this.txtTargetID.Size = new System.Drawing.Size(135, 29);
  96. this.txtTargetID.TabIndex = 11;
  97. this.txtTargetID.Text = "sa";
  98. //
  99. // label7
  100. //
  101. this.label7.AutoSize = true;
  102. this.label7.ForeColor = System.Drawing.SystemColors.ControlLight;
  103. this.label7.Location = new System.Drawing.Point(1091, 51);
  104. this.label7.Name = "label7";
  105. this.label7.Size = new System.Drawing.Size(121, 20);
  106. this.label7.TabIndex = 33;
  107. this.label7.Text = "來源資料庫帳號";
  108. //
  109. // txtTargetDBName
  110. //
  111. this.txtTargetDBName.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  112. this.txtTargetDBName.Location = new System.Drawing.Point(928, 49);
  113. this.txtTargetDBName.Name = "txtTargetDBName";
  114. this.txtTargetDBName.Size = new System.Drawing.Size(135, 29);
  115. this.txtTargetDBName.TabIndex = 10;
  116. this.txtTargetDBName.Text = "EURO";
  117. //
  118. // label8
  119. //
  120. this.label8.AutoSize = true;
  121. this.label8.ForeColor = System.Drawing.SystemColors.ControlLight;
  122. this.label8.Location = new System.Drawing.Point(801, 53);
  123. this.label8.Name = "label8";
  124. this.label8.Size = new System.Drawing.Size(121, 20);
  125. this.label8.TabIndex = 31;
  126. this.label8.Text = "目標資料庫名稱";
  127. //
  128. // txtTargetIP
  129. //
  130. this.txtTargetIP.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  131. this.txtTargetIP.Location = new System.Drawing.Point(444, 48);
  132. this.txtTargetIP.Name = "txtTargetIP";
  133. this.txtTargetIP.Size = new System.Drawing.Size(135, 29);
  134. this.txtTargetIP.TabIndex = 8;
  135. this.txtTargetIP.Text = "localhost";
  136. //
  137. // label9
  138. //
  139. this.label9.AutoSize = true;
  140. this.label9.ForeColor = System.Drawing.SystemColors.ControlLight;
  141. this.label9.Location = new System.Drawing.Point(334, 52);
  142. this.label9.Name = "label9";
  143. this.label9.Size = new System.Drawing.Size(104, 20);
  144. this.label9.TabIndex = 29;
  145. this.label9.Text = "目標資料庫IP";
  146. //
  147. // cbTargetClass
  148. //
  149. this.cbTargetClass.FormattingEnabled = true;
  150. this.cbTargetClass.Items.AddRange(new object[] {
  151. "",
  152. "MS-SQL",
  153. "MySQL",
  154. "Oracle",
  155. "PostgreSQL"});
  156. this.cbTargetClass.Location = new System.Drawing.Point(142, 47);
  157. this.cbTargetClass.Name = "cbTargetClass";
  158. this.cbTargetClass.Size = new System.Drawing.Size(163, 28);
  159. this.cbTargetClass.TabIndex = 7;
  160. this.cbTargetClass.SelectedValueChanged += new System.EventHandler(this.cbTargetClass_SelectedValueChanged);
  161. //
  162. // label10
  163. //
  164. this.label10.AutoSize = true;
  165. this.label10.ForeColor = System.Drawing.SystemColors.ControlLight;
  166. this.label10.Location = new System.Drawing.Point(14, 50);
  167. this.label10.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
  168. this.label10.Name = "label10";
  169. this.label10.Size = new System.Drawing.Size(121, 20);
  170. this.label10.TabIndex = 27;
  171. this.label10.Text = "目標資料庫類型";
  172. //
  173. // txtSourceID
  174. //
  175. this.txtSourceID.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  176. this.txtSourceID.Location = new System.Drawing.Point(1218, 13);
  177. this.txtSourceID.Name = "txtSourceID";
  178. this.txtSourceID.Size = new System.Drawing.Size(135, 29);
  179. this.txtSourceID.TabIndex = 5;
  180. this.txtSourceID.Text = "sa";
  181. //
  182. // label4
  183. //
  184. this.label4.AutoSize = true;
  185. this.label4.ForeColor = System.Drawing.SystemColors.ControlLight;
  186. this.label4.Location = new System.Drawing.Point(1091, 16);
  187. this.label4.Name = "label4";
  188. this.label4.Size = new System.Drawing.Size(121, 20);
  189. this.label4.TabIndex = 25;
  190. this.label4.Text = "來源資料庫帳號";
  191. //
  192. // txtSourceDBName
  193. //
  194. this.txtSourceDBName.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  195. this.txtSourceDBName.Location = new System.Drawing.Point(928, 14);
  196. this.txtSourceDBName.Name = "txtSourceDBName";
  197. this.txtSourceDBName.Size = new System.Drawing.Size(135, 29);
  198. this.txtSourceDBName.TabIndex = 4;
  199. this.txtSourceDBName.Text = "EURO_Data";
  200. //
  201. // label3
  202. //
  203. this.label3.AutoSize = true;
  204. this.label3.ForeColor = System.Drawing.SystemColors.ControlLight;
  205. this.label3.Location = new System.Drawing.Point(801, 18);
  206. this.label3.Name = "label3";
  207. this.label3.Size = new System.Drawing.Size(121, 20);
  208. this.label3.TabIndex = 23;
  209. this.label3.Text = "來源資料庫名稱";
  210. //
  211. // txtSourceIP
  212. //
  213. this.txtSourceIP.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  214. this.txtSourceIP.Location = new System.Drawing.Point(444, 13);
  215. this.txtSourceIP.Name = "txtSourceIP";
  216. this.txtSourceIP.Size = new System.Drawing.Size(135, 29);
  217. this.txtSourceIP.TabIndex = 2;
  218. this.txtSourceIP.Text = "localhost";
  219. //
  220. // label2
  221. //
  222. this.label2.AutoSize = true;
  223. this.label2.ForeColor = System.Drawing.SystemColors.ControlLight;
  224. this.label2.Location = new System.Drawing.Point(334, 17);
  225. this.label2.Name = "label2";
  226. this.label2.Size = new System.Drawing.Size(104, 20);
  227. this.label2.TabIndex = 21;
  228. this.label2.Text = "來源資料庫IP";
  229. //
  230. // cbSourceClass
  231. //
  232. this.cbSourceClass.FormattingEnabled = true;
  233. this.cbSourceClass.Items.AddRange(new object[] {
  234. "",
  235. "MS-SQL",
  236. "MySQL",
  237. "Oracle",
  238. "PostgreSQL"});
  239. this.cbSourceClass.Location = new System.Drawing.Point(142, 12);
  240. this.cbSourceClass.Name = "cbSourceClass";
  241. this.cbSourceClass.Size = new System.Drawing.Size(163, 28);
  242. this.cbSourceClass.TabIndex = 1;
  243. this.cbSourceClass.SelectedValueChanged += new System.EventHandler(this.cbSourceClass_SelectedValueChanged);
  244. //
  245. // label1
  246. //
  247. this.label1.AutoSize = true;
  248. this.label1.ForeColor = System.Drawing.SystemColors.ButtonFace;
  249. this.label1.Location = new System.Drawing.Point(14, 15);
  250. this.label1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
  251. this.label1.Name = "label1";
  252. this.label1.Size = new System.Drawing.Size(121, 20);
  253. this.label1.TabIndex = 19;
  254. this.label1.Text = "來源資料庫類型";
  255. //
  256. // btnExport
  257. //
  258. this.btnExport.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));
  259. this.btnExport.Enabled = false;
  260. this.btnExport.Location = new System.Drawing.Point(1649, 1014);
  261. this.btnExport.Name = "btnExport";
  262. this.btnExport.Size = new System.Drawing.Size(135, 30);
  263. this.btnExport.TabIndex = 16;
  264. this.btnExport.Text = "資料匯出";
  265. this.btnExport.UseVisualStyleBackColor = true;
  266. this.btnExport.Click += new System.EventHandler(this.btnExport_Click);
  267. //
  268. // label12
  269. //
  270. this.label12.AutoSize = true;
  271. this.label12.ForeColor = System.Drawing.SystemColors.ControlLight;
  272. this.label12.Location = new System.Drawing.Point(1224, 160);
  273. this.label12.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
  274. this.label12.Name = "label12";
  275. this.label12.Size = new System.Drawing.Size(73, 20);
  276. this.label12.TabIndex = 41;
  277. this.label12.Text = "欄位對應";
  278. //
  279. // btnTargetConnTest
  280. //
  281. this.btnTargetConnTest.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
  282. this.btnTargetConnTest.Location = new System.Drawing.Point(1649, 45);
  283. this.btnTargetConnTest.Name = "btnTargetConnTest";
  284. this.btnTargetConnTest.Size = new System.Drawing.Size(135, 30);
  285. this.btnTargetConnTest.TabIndex = 14;
  286. this.btnTargetConnTest.Text = "建立目標連線";
  287. this.btnTargetConnTest.UseVisualStyleBackColor = true;
  288. this.btnTargetConnTest.Click += new System.EventHandler(this.btnTargetConnTest_Click);
  289. //
  290. // txtTargetPWD
  291. //
  292. this.txtTargetPWD.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  293. this.txtTargetPWD.Location = new System.Drawing.Point(1508, 46);
  294. this.txtTargetPWD.Name = "txtTargetPWD";
  295. this.txtTargetPWD.PasswordChar = '*';
  296. this.txtTargetPWD.Size = new System.Drawing.Size(135, 29);
  297. this.txtTargetPWD.TabIndex = 12;
  298. this.txtTargetPWD.Text = "i\'mnelson";
  299. //
  300. // label6
  301. //
  302. this.label6.AutoSize = true;
  303. this.label6.ForeColor = System.Drawing.SystemColors.ControlLight;
  304. this.label6.Location = new System.Drawing.Point(1381, 50);
  305. this.label6.Name = "label6";
  306. this.label6.Size = new System.Drawing.Size(121, 20);
  307. this.label6.TabIndex = 38;
  308. this.label6.Text = "來源資料庫密碼";
  309. //
  310. // btnSourceConnTest
  311. //
  312. this.btnSourceConnTest.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
  313. this.btnSourceConnTest.Location = new System.Drawing.Point(1649, 12);
  314. this.btnSourceConnTest.Name = "btnSourceConnTest";
  315. this.btnSourceConnTest.Size = new System.Drawing.Size(135, 30);
  316. this.btnSourceConnTest.TabIndex = 13;
  317. this.btnSourceConnTest.Text = "建立來源連線";
  318. this.btnSourceConnTest.UseVisualStyleBackColor = true;
  319. this.btnSourceConnTest.Click += new System.EventHandler(this.btnSourceConnTest_Click);
  320. //
  321. // txtSourcePWD
  322. //
  323. this.txtSourcePWD.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  324. this.txtSourcePWD.Location = new System.Drawing.Point(1508, 13);
  325. this.txtSourcePWD.Name = "txtSourcePWD";
  326. this.txtSourcePWD.PasswordChar = '*';
  327. this.txtSourcePWD.Size = new System.Drawing.Size(135, 29);
  328. this.txtSourcePWD.TabIndex = 6;
  329. this.txtSourcePWD.Text = "i\'mnelson";
  330. //
  331. // label5
  332. //
  333. this.label5.AutoSize = true;
  334. this.label5.ForeColor = System.Drawing.SystemColors.ControlLight;
  335. this.label5.Location = new System.Drawing.Point(1381, 15);
  336. this.label5.Name = "label5";
  337. this.label5.Size = new System.Drawing.Size(121, 20);
  338. this.label5.TabIndex = 35;
  339. this.label5.Text = "來源資料庫密碼";
  340. //
  341. // dgvExportList
  342. //
  343. this.dgvExportList.AllowUserToAddRows = false;
  344. this.dgvExportList.AllowUserToDeleteRows = false;
  345. this.dgvExportList.AllowUserToOrderColumns = true;
  346. this.dgvExportList.AllowUserToResizeRows = false;
  347. this.dgvExportList.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
  348. | System.Windows.Forms.AnchorStyles.Left)));
  349. this.dgvExportList.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
  350. this.dgvExportList.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
  351. this.clExport,
  352. this.clCancel,
  353. this.clShow,
  354. this.clSourceTable,
  355. this.clTargetTable,
  356. this.clTableDel,
  357. this.clWhere,
  358. this.clMappingData});
  359. this.dgvExportList.Location = new System.Drawing.Point(18, 125);
  360. this.dgvExportList.Name = "dgvExportList";
  361. this.dgvExportList.RowTemplate.Height = 25;
  362. this.dgvExportList.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect;
  363. this.dgvExportList.Size = new System.Drawing.Size(1204, 920);
  364. this.dgvExportList.TabIndex = 17;
  365. this.dgvExportList.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvExportList_CellClick);
  366. this.dgvExportList.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvExportList_CellContentClick);
  367. //
  368. // label11
  369. //
  370. this.label11.AutoSize = true;
  371. this.label11.ForeColor = System.Drawing.SystemColors.ControlLight;
  372. this.label11.Location = new System.Drawing.Point(18, 102);
  373. this.label11.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
  374. this.label11.Name = "label11";
  375. this.label11.Size = new System.Drawing.Size(121, 20);
  376. this.label11.TabIndex = 43;
  377. this.label11.Text = "匯出資料表列表";
  378. //
  379. // dgvColumnMapping
  380. //
  381. this.dgvColumnMapping.AllowUserToAddRows = false;
  382. this.dgvColumnMapping.AllowUserToDeleteRows = false;
  383. this.dgvColumnMapping.AllowUserToOrderColumns = true;
  384. this.dgvColumnMapping.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
  385. | System.Windows.Forms.AnchorStyles.Right)));
  386. this.dgvColumnMapping.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
  387. this.dgvColumnMapping.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
  388. this.clExpColumn,
  389. this.clClean,
  390. this.clSourceColumn,
  391. this.clType,
  392. this.clTargetColumn});
  393. this.dgvColumnMapping.Location = new System.Drawing.Point(1228, 183);
  394. this.dgvColumnMapping.Name = "dgvColumnMapping";
  395. this.dgvColumnMapping.RowTemplate.Height = 25;
  396. this.dgvColumnMapping.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect;
  397. this.dgvColumnMapping.Size = new System.Drawing.Size(556, 342);
  398. this.dgvColumnMapping.TabIndex = 19;
  399. this.dgvColumnMapping.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvColumnMapping_CellContentClick);
  400. //
  401. // txtWhere
  402. //
  403. this.txtWhere.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
  404. | System.Windows.Forms.AnchorStyles.Left)
  405. | System.Windows.Forms.AnchorStyles.Right)));
  406. this.txtWhere.Location = new System.Drawing.Point(1228, 554);
  407. this.txtWhere.Multiline = true;
  408. this.txtWhere.Name = "txtWhere";
  409. this.txtWhere.Size = new System.Drawing.Size(556, 453);
  410. this.txtWhere.TabIndex = 20;
  411. //
  412. // label13
  413. //
  414. this.label13.AutoSize = true;
  415. this.label13.ForeColor = System.Drawing.SystemColors.ControlLight;
  416. this.label13.Location = new System.Drawing.Point(1228, 531);
  417. this.label13.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
  418. this.label13.Name = "label13";
  419. this.label13.Size = new System.Drawing.Size(73, 20);
  420. this.label13.TabIndex = 46;
  421. this.label13.Text = "過濾條件";
  422. //
  423. // label14
  424. //
  425. this.label14.AutoSize = true;
  426. this.label14.ForeColor = System.Drawing.SystemColors.ControlLight;
  427. this.label14.Location = new System.Drawing.Point(1224, 128);
  428. this.label14.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
  429. this.label14.Name = "label14";
  430. this.label14.Size = new System.Drawing.Size(89, 20);
  431. this.label14.TabIndex = 48;
  432. this.label14.Text = "目標資料表";
  433. //
  434. // cbTargetTable
  435. //
  436. this.cbTargetTable.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
  437. | System.Windows.Forms.AnchorStyles.Right)));
  438. this.cbTargetTable.DisplayMember = "TableName";
  439. this.cbTargetTable.Enabled = false;
  440. this.cbTargetTable.FormattingEnabled = true;
  441. this.cbTargetTable.Location = new System.Drawing.Point(1320, 125);
  442. this.cbTargetTable.Name = "cbTargetTable";
  443. this.cbTargetTable.Size = new System.Drawing.Size(464, 28);
  444. this.cbTargetTable.TabIndex = 18;
  445. this.cbTargetTable.ValueMember = "TableName";
  446. this.cbTargetTable.SelectedIndexChanged += new System.EventHandler(this.cbTargetTable_SelectedIndexChanged);
  447. //
  448. // btnMapping
  449. //
  450. this.btnMapping.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
  451. this.btnMapping.Enabled = false;
  452. this.btnMapping.Location = new System.Drawing.Point(1508, 1013);
  453. this.btnMapping.Name = "btnMapping";
  454. this.btnMapping.Size = new System.Drawing.Size(135, 32);
  455. this.btnMapping.TabIndex = 23;
  456. this.btnMapping.Text = "設定匯出條件";
  457. this.btnMapping.UseVisualStyleBackColor = true;
  458. this.btnMapping.Click += new System.EventHandler(this.btnMapping_Click);
  459. //
  460. // label15
  461. //
  462. this.label15.AutoSize = true;
  463. this.label15.ForeColor = System.Drawing.SystemColors.ControlLight;
  464. this.label15.Location = new System.Drawing.Point(1365, 84);
  465. this.label15.Name = "label15";
  466. this.label15.Size = new System.Drawing.Size(137, 20);
  467. this.label15.TabIndex = 51;
  468. this.label15.Text = "檔案匯出上限筆數";
  469. //
  470. // txtMaxCount
  471. //
  472. this.txtMaxCount.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  473. this.txtMaxCount.Location = new System.Drawing.Point(1508, 80);
  474. this.txtMaxCount.Name = "txtMaxCount";
  475. this.txtMaxCount.Size = new System.Drawing.Size(135, 29);
  476. this.txtMaxCount.TabIndex = 15;
  477. this.txtMaxCount.Text = "0";
  478. //
  479. // label16
  480. //
  481. this.label16.AutoSize = true;
  482. this.label16.ForeColor = System.Drawing.SystemColors.ControlLight;
  483. this.label16.Location = new System.Drawing.Point(600, 51);
  484. this.label16.Name = "label16";
  485. this.label16.Size = new System.Drawing.Size(73, 20);
  486. this.label16.TabIndex = 54;
  487. this.label16.Text = "目標Port";
  488. //
  489. // label17
  490. //
  491. this.label17.AutoSize = true;
  492. this.label17.ForeColor = System.Drawing.SystemColors.ControlLight;
  493. this.label17.Location = new System.Drawing.Point(600, 16);
  494. this.label17.Name = "label17";
  495. this.label17.Size = new System.Drawing.Size(73, 20);
  496. this.label17.TabIndex = 53;
  497. this.label17.Text = "來源Port";
  498. //
  499. // txtTargetPort
  500. //
  501. this.txtTargetPort.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  502. this.txtTargetPort.Location = new System.Drawing.Point(674, 48);
  503. this.txtTargetPort.Name = "txtTargetPort";
  504. this.txtTargetPort.Size = new System.Drawing.Size(100, 29);
  505. this.txtTargetPort.TabIndex = 9;
  506. //
  507. // txtSourcePort
  508. //
  509. this.txtSourcePort.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
  510. this.txtSourcePort.Location = new System.Drawing.Point(674, 13);
  511. this.txtSourcePort.Name = "txtSourcePort";
  512. this.txtSourcePort.Size = new System.Drawing.Size(100, 29);
  513. this.txtSourcePort.TabIndex = 3;
  514. //
  515. // btnExportXML
  516. //
  517. this.btnExportXML.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
  518. this.btnExportXML.Enabled = false;
  519. this.btnExportXML.Location = new System.Drawing.Point(1228, 1013);
  520. this.btnExportXML.Name = "btnExportXML";
  521. this.btnExportXML.Size = new System.Drawing.Size(135, 32);
  522. this.btnExportXML.TabIndex = 21;
  523. this.btnExportXML.Text = "匯出XML";
  524. this.btnExportXML.UseVisualStyleBackColor = true;
  525. this.btnExportXML.Click += new System.EventHandler(this.btnExportXML_Click);
  526. //
  527. // btnImportXML
  528. //
  529. this.btnImportXML.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
  530. this.btnImportXML.Location = new System.Drawing.Point(1367, 1013);
  531. this.btnImportXML.Name = "btnImportXML";
  532. this.btnImportXML.Size = new System.Drawing.Size(135, 32);
  533. this.btnImportXML.TabIndex = 22;
  534. this.btnImportXML.Text = "匯入XML";
  535. this.btnImportXML.UseVisualStyleBackColor = true;
  536. this.btnImportXML.Click += new System.EventHandler(this.btnImportXML_Click);
  537. //
  538. // ofPath
  539. //
  540. this.ofPath.FileName = "file.xml";
  541. //
  542. // btnClean
  543. //
  544. this.btnClean.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
  545. this.btnClean.Location = new System.Drawing.Point(1649, 81);
  546. this.btnClean.Name = "btnClean";
  547. this.btnClean.Size = new System.Drawing.Size(135, 28);
  548. this.btnClean.TabIndex = 55;
  549. this.btnClean.Text = "清除";
  550. this.btnClean.UseVisualStyleBackColor = true;
  551. this.btnClean.Click += new System.EventHandler(this.btnClean_Click);
  552. //
  553. // clExport
  554. //
  555. this.clExport.HeaderText = "匯出";
  556. this.clExport.Name = "clExport";
  557. this.clExport.Width = 70;
  558. //
  559. // clCancel
  560. //
  561. this.clCancel.HeaderText = "清除";
  562. this.clCancel.Name = "clCancel";
  563. this.clCancel.Text = "...";
  564. this.clCancel.UseColumnTextForButtonValue = true;
  565. this.clCancel.Width = 70;
  566. //
  567. // clShow
  568. //
  569. this.clShow.HeaderText = "顯示來源";
  570. this.clShow.Name = "clShow";
  571. this.clShow.Text = "...";
  572. this.clShow.UseColumnTextForButtonValue = true;
  573. //
  574. // clSourceTable
  575. //
  576. this.clSourceTable.DataPropertyName = "TableName";
  577. this.clSourceTable.HeaderText = "來源資料表名稱";
  578. this.clSourceTable.Name = "clSourceTable";
  579. this.clSourceTable.ReadOnly = true;
  580. this.clSourceTable.Width = 200;
  581. //
  582. // clTargetTable
  583. //
  584. this.clTargetTable.HeaderText = "目標資料表名稱";
  585. this.clTargetTable.Name = "clTargetTable";
  586. this.clTargetTable.ReadOnly = true;
  587. this.clTargetTable.Width = 200;
  588. //
  589. // clTableDel
  590. //
  591. this.clTableDel.HeaderText = "清除目標資料表內容";
  592. this.clTableDel.Name = "clTableDel";
  593. this.clTableDel.Width = 200;
  594. //
  595. // clWhere
  596. //
  597. this.clWhere.HeaderText = "過濾條件";
  598. this.clWhere.Name = "clWhere";
  599. this.clWhere.Visible = false;
  600. //
  601. // clMappingData
  602. //
  603. this.clMappingData.HeaderText = "欄位對應";
  604. this.clMappingData.Name = "clMappingData";
  605. this.clMappingData.Visible = false;
  606. //
  607. // clExpColumn
  608. //
  609. this.clExpColumn.HeaderText = "匯出";
  610. this.clExpColumn.Name = "clExpColumn";
  611. this.clExpColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True;
  612. this.clExpColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
  613. this.clExpColumn.Width = 65;
  614. //
  615. // clClean
  616. //
  617. this.clClean.HeaderText = "清除";
  618. this.clClean.Name = "clClean";
  619. this.clClean.Text = "...";
  620. this.clClean.UseColumnTextForButtonValue = true;
  621. this.clClean.Width = 50;
  622. //
  623. // clSourceColumn
  624. //
  625. this.clSourceColumn.DataPropertyName = "COLUMN_NAME";
  626. this.clSourceColumn.HeaderText = "來源欄位";
  627. this.clSourceColumn.Name = "clSourceColumn";
  628. this.clSourceColumn.ReadOnly = true;
  629. this.clSourceColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True;
  630. this.clSourceColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
  631. this.clSourceColumn.Width = 200;
  632. //
  633. // clType
  634. //
  635. this.clType.DataPropertyName = "DATA_TYPE";
  636. this.clType.HeaderText = "型態";
  637. this.clType.Name = "clType";
  638. this.clType.Width = 80;
  639. //
  640. // clTargetColumn
  641. //
  642. this.clTargetColumn.HeaderText = "目標欄位";
  643. this.clTargetColumn.Name = "clTargetColumn";
  644. this.clTargetColumn.Resizable = System.Windows.Forms.DataGridViewTriState.True;
  645. this.clTargetColumn.Width = 200;
  646. //
  647. // Form1
  648. //
  649. this.AutoScaleDimensions = new System.Drawing.SizeF(10F, 20F);
  650. this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
  651. this.BackColor = System.Drawing.SystemColors.ControlDarkDark;
  652. this.ClientSize = new System.Drawing.Size(1796, 1057);
  653. this.Controls.Add(this.btnClean);
  654. this.Controls.Add(this.btnImportXML);
  655. this.Controls.Add(this.btnExportXML);
  656. this.Controls.Add(this.txtTargetPort);
  657. this.Controls.Add(this.txtSourcePort);
  658. this.Controls.Add(this.label16);
  659. this.Controls.Add(this.label17);
  660. this.Controls.Add(this.txtMaxCount);
  661. this.Controls.Add(this.label15);
  662. this.Controls.Add(this.btnMapping);
  663. this.Controls.Add(this.cbTargetTable);
  664. this.Controls.Add(this.label14);
  665. this.Controls.Add(this.txtWhere);
  666. this.Controls.Add(this.label13);
  667. this.Controls.Add(this.dgvColumnMapping);
  668. this.Controls.Add(this.dgvExportList);
  669. this.Controls.Add(this.label11);
  670. this.Controls.Add(this.btnExport);
  671. this.Controls.Add(this.label12);
  672. this.Controls.Add(this.btnTargetConnTest);
  673. this.Controls.Add(this.txtTargetPWD);
  674. this.Controls.Add(this.label6);
  675. this.Controls.Add(this.btnSourceConnTest);
  676. this.Controls.Add(this.txtSourcePWD);
  677. this.Controls.Add(this.label5);
  678. this.Controls.Add(this.txtTargetID);
  679. this.Controls.Add(this.label7);
  680. this.Controls.Add(this.txtTargetDBName);
  681. this.Controls.Add(this.label8);
  682. this.Controls.Add(this.txtTargetIP);
  683. this.Controls.Add(this.label9);
  684. this.Controls.Add(this.cbTargetClass);
  685. this.Controls.Add(this.label10);
  686. this.Controls.Add(this.txtSourceID);
  687. this.Controls.Add(this.label4);
  688. this.Controls.Add(this.txtSourceDBName);
  689. this.Controls.Add(this.label3);
  690. this.Controls.Add(this.txtSourceIP);
  691. this.Controls.Add(this.label2);
  692. this.Controls.Add(this.cbSourceClass);
  693. this.Controls.Add(this.label1);
  694. this.Font = new System.Drawing.Font("微軟正黑體", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(136)));
  695. this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
  696. this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
  697. this.Margin = new System.Windows.Forms.Padding(5);
  698. this.Name = "Form1";
  699. this.Text = "資料匯出程式";
  700. this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
  701. this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.Form1_FormClosing);
  702. this.Load += new System.EventHandler(this.Form1_Load);
  703. ((System.ComponentModel.ISupportInitialize)(this.dgvExportList)).EndInit();
  704. ((System.ComponentModel.ISupportInitialize)(this.dgvColumnMapping)).EndInit();
  705. this.ResumeLayout(false);
  706. this.PerformLayout();
  707. }
  708. #endregion
  709. private System.Windows.Forms.TextBox txtTargetID;
  710. private System.Windows.Forms.Label label7;
  711. private System.Windows.Forms.TextBox txtTargetDBName;
  712. private System.Windows.Forms.Label label8;
  713. private System.Windows.Forms.TextBox txtTargetIP;
  714. private System.Windows.Forms.Label label9;
  715. private System.Windows.Forms.ComboBox cbTargetClass;
  716. private System.Windows.Forms.Label label10;
  717. private System.Windows.Forms.TextBox txtSourceID;
  718. private System.Windows.Forms.Label label4;
  719. private System.Windows.Forms.TextBox txtSourceDBName;
  720. private System.Windows.Forms.Label label3;
  721. private System.Windows.Forms.TextBox txtSourceIP;
  722. private System.Windows.Forms.Label label2;
  723. private System.Windows.Forms.ComboBox cbSourceClass;
  724. private System.Windows.Forms.Label label1;
  725. private System.Windows.Forms.Button btnExport;
  726. private System.Windows.Forms.Label label12;
  727. private System.Windows.Forms.Button btnTargetConnTest;
  728. private System.Windows.Forms.TextBox txtTargetPWD;
  729. private System.Windows.Forms.Label label6;
  730. private System.Windows.Forms.Button btnSourceConnTest;
  731. private System.Windows.Forms.TextBox txtSourcePWD;
  732. private System.Windows.Forms.Label label5;
  733. private System.Windows.Forms.DataGridView dgvExportList;
  734. private System.Windows.Forms.Label label11;
  735. private System.Windows.Forms.DataGridView dgvColumnMapping;
  736. private System.Windows.Forms.TextBox txtWhere;
  737. private System.Windows.Forms.Label label13;
  738. private System.Windows.Forms.Label label14;
  739. private System.Windows.Forms.ComboBox cbTargetTable;
  740. private System.Windows.Forms.Button btnMapping;
  741. private System.Windows.Forms.SaveFileDialog sfPath;
  742. private System.Windows.Forms.Label label15;
  743. private System.Windows.Forms.TextBox txtMaxCount;
  744. private System.Windows.Forms.Label label16;
  745. private System.Windows.Forms.Label label17;
  746. private System.Windows.Forms.TextBox txtTargetPort;
  747. private System.Windows.Forms.TextBox txtSourcePort;
  748. private System.Windows.Forms.Button btnExportXML;
  749. private System.Windows.Forms.Button btnImportXML;
  750. private System.Windows.Forms.OpenFileDialog ofPath;
  751. private System.Windows.Forms.Button btnClean;
  752. private System.Windows.Forms.DataGridViewCheckBoxColumn clExport;
  753. private System.Windows.Forms.DataGridViewButtonColumn clCancel;
  754. private System.Windows.Forms.DataGridViewButtonColumn clShow;
  755. private System.Windows.Forms.DataGridViewTextBoxColumn clSourceTable;
  756. private System.Windows.Forms.DataGridViewTextBoxColumn clTargetTable;
  757. private System.Windows.Forms.DataGridViewCheckBoxColumn clTableDel;
  758. private System.Windows.Forms.DataGridViewTextBoxColumn clWhere;
  759. private System.Windows.Forms.DataGridViewTextBoxColumn clMappingData;
  760. private System.Windows.Forms.DataGridViewCheckBoxColumn clExpColumn;
  761. private System.Windows.Forms.DataGridViewButtonColumn clClean;
  762. private System.Windows.Forms.DataGridViewTextBoxColumn clSourceColumn;
  763. private System.Windows.Forms.DataGridViewTextBoxColumn clType;
  764. private System.Windows.Forms.DataGridViewComboBoxColumn clTargetColumn;
  765. }
  766. }