/// <summary>
/// Установить параметры канала связи в соответствии с настройками
/// </summary>
public void SetCommCnlParams(SortedList <string, string> commCnlParams)
{
commCnlParams["TcpPort"] = TcpPort.ToString();
commCnlParams["InactiveTime"] = InactiveTime.ToString();
commCnlParams["Behavior"] = Behavior.ToString();
commCnlParams["ConnMode"] = ConnMode.ToString();
commCnlParams["DevSelMode"] = DevSelMode.ToString();
}
internal ConnOpts(int port, string passwd, ViewOpts viewOpts)
{
// TODO: Check the minimum and maximum values.
if (port < 0)
{
throw new ArgumentException("port", "Not a valid value");
}
if (viewOpts == null)
{
throw new ArgumentException("viewOpts", "Cannot be null");
}
ConnMode = ConnMode.Passive;
Host = "localhost";
Port = port;
Passwd = passwd;
ViewOpts = viewOpts;
}
public OleDbCtrl(ConnMode enConnMode, bool bIsHasHeaders, string strFileName)
{
this.enConnMode = enConnMode;
this.bIsHasHeaders = bIsHasHeaders;
string strConn = ExcelConnection(strFileName);
if (String.IsNullOrEmpty(strConn) == true)
{
throw new Exception("NeoFX : Excel 형식이 아닙니다.");
}
else
{
conn = new OleDbConnection(strConn);
comm = new OleDbCommand("", conn);
ad = new OleDbDataAdapter(comm);
}
}
/// <summary>
/// Open connection to database
/// </summary>
/// <param name="connMode">Mode of connection</param>
private void openConnection(ConnMode connMode = ConnMode.Dev)
{
try
{
switch (connMode)
{
case ConnMode.Dev:
this._dataSource = @"DESKTOP-NP990SR\SQLEXPRESS";
break;
case ConnMode.Deploy:
this._dataSource = @"";
break;
case ConnMode.Production:
this._dataSource = @"";
break;
}
string connectionString = $@"data source={this._dataSource};initial catalog={this._catalog};
integrated security={this._integratedSecurity};MultipleActiveResultSets={this._multipleActiveResultSets};";
if (this._connection == null || this._connection.State != ConnectionState.Open)
{
this._connection = new SqlConnection(connectionString);
_connection.Open();
}
else
{
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
}
}
catch (Exception)
{
throw;
}
}
protected void GetConnMode()
{
connMode = listenBox.Checked? ConnMode.Passive : ConnMode.Active;
}
internal void Load(string fileName)
{
XmlDocument doc = new XmlDocument();
doc.Load(fileName);
XmlNodeList list = doc.GetElementsByTagName(ConnModeName);
if (list.Count > 0)
{
switch (list[0].InnerText)
{
case PassiveName:
ConnMode = ConnMode.Passive;
break;
default:
ConnMode = ConnMode.Active;
break;
}
}
else
{
ConnMode = ConnMode.Active;
}
if (ConnMode == ConnMode.Active)
{
list = doc.GetElementsByTagName(HostName);
if (list.Count > 0)
{
Host = list[0].InnerText;
}
else
{
throw new FormatException("Host name is not found.");
}
}
else
{
Host = "localhost";
}
list = doc.GetElementsByTagName(PortName);
if (list.Count > 0)
{
Port = Int32.Parse(list[0].InnerText);
}
else
{
throw new FormatException("Port number is not found.");
}
list = doc.GetElementsByTagName(PasswdName);
if (list.Count > 0)
{
Passwd = list[0].InnerText;
}
else
{
Passwd = ""; // This means we did not save the password.
}
ViewOpts = new ViewOpts();
ViewOpts.ReadFromXml(doc, doc.DocumentElement);
}
