ConnectionForm.cs 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195
  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 = Config.Root.FindItem("Forms").FindItem(Name).GetProp("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. Config.Root.FindItem("Forms").FindItem(Name).SetProp("ConnectionType",
  93. (cbxConnections.SelectedItem as DataConnectionInfo).Object.Name);
  94. }
  95. }
  96. private void ConnectionForm_FormClosing(object sender, FormClosingEventArgs e)
  97. {
  98. if (DialogResult == DialogResult.OK && connection != null && connectionEditor != null)
  99. {
  100. connection.LoginPrompt = cbLoginPrompt.Checked;
  101. if (connection.LoginPrompt || TestConnection(false))
  102. connection.ConnectionString = connectionEditor.ConnectionString;
  103. else
  104. e.Cancel = true;
  105. }
  106. }
  107. private void cbxConnections_SelectedIndexChanged(object sender, EventArgs e)
  108. {
  109. cbAlwaysUse.Checked = false;
  110. SuspendLayout();
  111. if (connectionEditor != null)
  112. connectionEditor.Dispose();
  113. if (!editMode)
  114. {
  115. if (connection != null)
  116. connection.Dispose();
  117. connection = null;
  118. Type connectionType = (cbxConnections.SelectedItem as DataConnectionInfo).Object;
  119. connection = Activator.CreateInstance(connectionType) as DataConnectionBase;
  120. }
  121. connectionEditor = connection.GetEditor();
  122. connectionEditor.TabIndex = 3;
  123. if (connectionEditor != null)
  124. {
  125. connectionEditor.Parent = this;
  126. connectionEditor.Scale(new SizeF(this.DpiMultiplier(), this.DpiMultiplier()));
  127. UIUtils.CheckRTL(connectionEditor);
  128. connectionEditor.UpdateDpiDependencies();
  129. connectionEditor.Location = new Point(0, gbSelect.Bottom);
  130. ClientSize = new Size(ClientSize.Width,
  131. connectionEditor.Bottom + cbLoginPrompt.Height + btnOk.Height + gbSelect.Top * 5);
  132. }
  133. else
  134. ClientSize = new Size(ClientSize.Width,
  135. gbSelect.Bottom + cbLoginPrompt.Height + btnOk.Height + gbSelect.Top * 5);
  136. ResumeLayout();
  137. Refresh();
  138. if (connection != null && connectionEditor != null)
  139. {
  140. connectionEditor.ConnectionString = connection.ConnectionString;
  141. cbLoginPrompt.Checked = connection.LoginPrompt;
  142. }
  143. btnTest.Enabled = connection != null;
  144. }
  145. private void btnTest_Click(object sender, EventArgs e)
  146. {
  147. TestConnection(true);
  148. }
  149. public override void Localize()
  150. {
  151. base.Localize();
  152. MyRes res = new MyRes("Forms,Connection");
  153. Text = res.Get("");
  154. gbSelect.Text = res.Get("Select");
  155. cbAlwaysUse.Text = res.Get("AlwaysUse");
  156. cbLoginPrompt.Text = res.Get("LoginPrompt");
  157. btnTest.Text = res.Get("Test");
  158. }
  159. public override void UpdateDpiDependencies()
  160. {
  161. base.UpdateDpiDependencies();
  162. if (connectionEditor != null)
  163. connectionEditor.UpdateDpiDependencies();
  164. }
  165. public ConnectionForm()
  166. {
  167. InitializeComponent();
  168. Localize();
  169. UIUtils.CheckRTL(this);
  170. UpdateDpiDependencies();
  171. EnumConnections();
  172. }
  173. }
  174. }