ConnectionForm.cs 6.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Drawing;
  4. using System.Windows.Forms;
  5. using FastReport.Utils;
  6. using FastReport.Data;
  7. using FastReport.Data.ConnectionEditors;
  8. namespace FastReport.Forms
  9. {
  10. internal partial class ConnectionForm : BaseDialogForm
  11. {
  12. private DataConnectionBase connection;
  13. private ConnectionEditorBase connectionEditor;
  14. private bool editMode;
  15. public DataConnectionBase Connection
  16. {
  17. get { return connection; }
  18. set { connection = value; }
  19. }
  20. public bool EditMode
  21. {
  22. get { return editMode; }
  23. set
  24. {
  25. editMode = value;
  26. if (value)
  27. {
  28. cbxConnections.Items.Clear();
  29. cbxConnections.Items.Add(RegisteredObjects.FindConnection(Connection.GetType()));
  30. cbxConnections.SelectedIndex = 0;
  31. cbxConnections.Enabled = false;
  32. cbAlwaysUse.Enabled = false;
  33. }
  34. }
  35. }
  36. private void EnumConnections()
  37. {
  38. var registeredObjects = new List<DataConnectionInfo>();
  39. RegisteredObjects.DataConnections.EnumItems(registeredObjects);
  40. string lastUsed = Storage.GetStr("ConnectionType");
  41. foreach (var info in registeredObjects)
  42. {
  43. if (info.Object != null)
  44. {
  45. cbxConnections.Items.Add(info);
  46. if (info.Object.Name == lastUsed)
  47. {
  48. cbxConnections.SelectedIndex = cbxConnections.Items.Count - 1;
  49. cbAlwaysUse.Checked = true;
  50. }
  51. }
  52. }
  53. if (cbxConnections.SelectedIndex == -1)
  54. cbxConnections.SelectedIndex = 0;
  55. }
  56. private bool TestConnection(bool showOkMessage)
  57. {
  58. string saveConnectionString = connection.ConnectionString;
  59. connection.ConnectionString = connectionEditor.ConnectionString;
  60. bool successful = true;
  61. string errorMsg = "";
  62. try
  63. {
  64. connection.TestConnection();
  65. }
  66. catch (Exception e)
  67. {
  68. successful = false;
  69. errorMsg = e.Message;
  70. }
  71. connection.ConnectionString = saveConnectionString;
  72. if (successful && showOkMessage)
  73. FRMessageBox.Information(Res.Get("Forms,Connection,TestSuccesful"));
  74. else if (!successful)
  75. FRMessageBox.Error(errorMsg);
  76. return successful;
  77. }
  78. private void cbxConnections_DrawItem(object sender, DrawItemEventArgs e)
  79. {
  80. e.DrawBackground();
  81. if (e.Index >= 0)
  82. {
  83. var info = cbxConnections.Items[e.Index] as DataConnectionInfo;
  84. TextFormatFlags flags = RightToLeft == RightToLeft.Yes ? TextFormatFlags.RightToLeft | TextFormatFlags.Right : TextFormatFlags.Default;
  85. TextRenderer.DrawText(e.Graphics, Res.TryGet(info.Text), e.Font, e.Bounds, e.ForeColor, flags);
  86. }
  87. }
  88. private void ConnectionForm_FormClosed(object sender, FormClosedEventArgs e)
  89. {
  90. if (cbAlwaysUse.Checked)
  91. {
  92. Storage.SetStr("ConnectionType", (cbxConnections.SelectedItem as DataConnectionInfo).Object.Name);
  93. }
  94. }
  95. private void ConnectionForm_FormClosing(object sender, FormClosingEventArgs e)
  96. {
  97. if (DialogResult == DialogResult.OK && connection != null && connectionEditor != null)
  98. {
  99. connection.LoginPrompt = cbLoginPrompt.Checked;
  100. if (connection.LoginPrompt || TestConnection(false))
  101. connection.ConnectionString = connectionEditor.ConnectionString;
  102. else
  103. e.Cancel = true;
  104. }
  105. }
  106. private void cbxConnections_SelectedIndexChanged(object sender, EventArgs e)
  107. {
  108. cbAlwaysUse.Checked = false;
  109. SuspendLayout();
  110. if (connectionEditor != null)
  111. connectionEditor.Dispose();
  112. if (!editMode)
  113. {
  114. if (connection != null)
  115. connection.Dispose();
  116. connection = null;
  117. Type connectionType = (cbxConnections.SelectedItem as DataConnectionInfo).Object;
  118. connection = Activator.CreateInstance(connectionType) as DataConnectionBase;
  119. }
  120. connectionEditor = connection.GetEditor();
  121. if (connectionEditor != null)
  122. {
  123. connectionEditor.TabIndex = 3;
  124. connectionEditor.Parent = this;
  125. connectionEditor.Scale(new SizeF(this.DpiMultiplier(), this.DpiMultiplier()));
  126. UIUtils.CheckRTL(connectionEditor);
  127. connectionEditor.UpdateDpiDependencies();
  128. connectionEditor.Location = new Point(0, gbSelect.Bottom);
  129. ClientSize = new Size(ClientSize.Width,
  130. gbSelect.Bottom + connectionEditor.Height + cbLoginPrompt.Height + btnOk.Height + gbSelect.Top * 5);
  131. }
  132. else
  133. ClientSize = new Size(ClientSize.Width,
  134. gbSelect.Bottom + cbLoginPrompt.Height + btnOk.Height + gbSelect.Top * 5);
  135. ResumeLayout();
  136. Refresh();
  137. if (connection != null && connectionEditor != null)
  138. {
  139. connectionEditor.ConnectionString = connection.ConnectionString;
  140. cbLoginPrompt.Checked = connection.LoginPrompt;
  141. }
  142. btnTest.Enabled = connection != null;
  143. #if AVALONIA
  144. // cbLoginPrompt disappears w/o this
  145. global::Avalonia.Threading.Dispatcher.UIThread.InvokeAsync(() =>
  146. {
  147. cbLoginPrompt.Visible = false;
  148. cbLoginPrompt.Visible = true;
  149. });
  150. #endif
  151. }
  152. private void btnTest_Click(object sender, EventArgs e)
  153. {
  154. TestConnection(true);
  155. }
  156. public override void Localize()
  157. {
  158. base.Localize();
  159. MyRes res = new MyRes("Forms,Connection");
  160. Text = res.Get("");
  161. gbSelect.Text = res.Get("Select");
  162. cbAlwaysUse.Text = res.Get("AlwaysUse");
  163. cbLoginPrompt.Text = res.Get("LoginPrompt");
  164. btnTest.Text = res.Get("Test");
  165. }
  166. public override void UpdateDpiDependencies()
  167. {
  168. base.UpdateDpiDependencies();
  169. if (connectionEditor != null)
  170. connectionEditor.UpdateDpiDependencies();
  171. }
  172. public ConnectionForm()
  173. {
  174. InitializeComponent();
  175. Localize();
  176. UIUtils.CheckRTL(this);
  177. UpdateDpiDependencies();
  178. EnumConnections();
  179. }
  180. }
  181. }