/// <summary>
/// 获取当前连接的参数。
/// </summary>
/// <returns></returns>
public override ConnectionParameter GetConnectionParameter(ConnectionString connectionString)
{
var provider = connectionString.Properties["provider"];
var parameter = new ConnectionParameter
{
Database = connectionString.Properties["data source"],
UserId = connectionString.Properties["user id"],
Password = connectionString.Properties["password"]
};
switch (provider.ToUpper())
{
case "SQLOLEDB":
parameter.Schema = "dbo";
break;
case "MSDAORA":
case "MSDAORA.1":
parameter.Schema = connectionString.Properties["user id"].ToUpper();
break;
}
return(parameter);
}
static void OnSocket(NktHook hook, NktProcess process, NktHookCallInfo callInfo)
{
APIUnit report = Base(APIType.Simple, APICategory.Simple, APIID.SocketConnect, hook, process, callInfo);
if (report == null)
{
return;
}
var param = new ConnectionParameter();
int len = callInfo.Params().GetAt(2).LongVal;
byte[] buf = new byte[len];
GCHandle h = GCHandle.Alloc(buf, GCHandleType.Pinned);
IntPtr p = h.AddrOfPinnedObject();
var add = callInfo.Params().GetAt(1);
INktProcessMemory mem = add.Memory();
mem.ReadMem(p, add.PointerVal, (IntPtr)len);
h.Free();
report.ID = hook.FunctionName.Contains("bind") ? APIID.SocketBind : APIID.SocketConnect;
param.Port = (ushort)(buf[2] * 256 + buf[3]);
param.IP = String.Format("{0}.{1}.{2}.{3}", buf[4].ToString("D3"), buf[5].ToString("D3"), buf[6].ToString("D3"), buf[7].ToString("D3"));
param.Server = hook.FunctionName.Contains("bind") ? true : false;
report.ID = param.Server ? APIID.SocketBind : APIID.SocketConnect;
report.Parameter = param;
Reports.Enqueue(report);
}
public ConnectionViewModel()
{
_connectionParameter = new ConnectionParameter
{
Login = "******",
Password = string.Empty,
Port = 1235,
ServerIp = "91.230.153.2"
};
}
public PrintCommanderMainForm()
{
InitializeComponent();
printGroups = new PrintGroupItemList();
conParm = new ConnectionParameter();
manageToolStripMenuItem1.Enabled = false;
disablePrinterPoolToolStripMenuItem.Enabled = false;
removePrinterPoolToolStripMenuItem1.Enabled = false;
manageToolStripMenuItem.Enabled = false;
removePrinterPoolToolStripMenuItem.Enabled = false;
setAsDefaToolStripMenuItem.Enabled = false;
}
// Validate the connection when connector endpoints are dragged
protected override void ValidateConnection(ConnectionParameter args)
{
if (args.TargetPort is PortVM)
{
var port = args.TargetPort as PortVM;
if (!port.CanCreateConnection(args.Connector as IConnector))
{
args.TargetPort = null;
}
}
base.ValidateConnection(args);
}
public static void ConnectionParams(string connectionString)
{
SqlConnectionStringBuilder decoder = new SqlConnectionStringBuilder(connectionString);
string UserID = decoder.UserID;
string Password = decoder.Password;
ConnectionParameter oConnectionParameter = new ConnectionParameter();
oConnectionParameter.username = decoder.UserID;
oConnectionParameter.password = decoder.Password;
oConnectionParameter.catalog = decoder.InitialCatalog;
oConnectionParameter.integratedSecurity = decoder.IntegratedSecurity;
}
/// <summary>
/// Override the validate connection
/// </summary>
/// <param name="args">Gets args value</param>
protected override void ValidateConnection(ConnectionParameter args)
{
// set the target node and target port
if (args.TargetPort == null && args.TargetNode != null)
{
if (args.TargetNode is NodeViewModel)
{
NodeViewModel node = args.TargetNode as NodeViewModel;
if (node.Ports != null && (node.Ports as ObservableCollection <IPort>).Count() > 0)
{
args.TargetPort = (node.Ports as ObservableCollection <IPort>)[0];
}
}
}
}
protected override void ValidateConnection(ConnectionParameter args)
{
var isSourceAction = args.ConnectorEnd == ConnectorEnd.Source;
if ((isSourceAction && args.SourcePort != null) || (!isSourceAction && args.TargetPort != null))
{
//To change the connection indicator style of the port connection.
this.ConnectionIndicatorStyle = Application.Current.Resources["PortConnectorIndicatorstyle"] as Style;
}
else if ((isSourceAction && args.SourceNode != null) || (!isSourceAction && args.TargetNode != null))
{
this.ConnectionIndicatorStyle = Application.Current.Resources["NodeConnectorIndicatorstyle"] as Style;
}
base.ValidateConnection(args);
}
/// <summary>
/// 使用参数更新指定的连接。
/// </summary>
/// <param name="connectionString">连接字符串对象。</param>
/// <param name="parameter"></param>
public override void UpdateConnectionString(ConnectionString connectionString, ConnectionParameter parameter)
{
connectionString.Properties.TrySetValue(parameter.Server, "data source")
.TrySetValue(parameter.Database, "database")
.TrySetValue(parameter.UserId, "user id")
.TrySetValue(parameter.Password, "password")
.Update();
}
public static void Run()
{
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
// Create a workbook object from source file
Workbook workbook = new Workbook(sourceDir + "sampleRetrievingSQLConnectionData.xlsx");
// Access the external collections
ExternalConnectionCollection connections = workbook.DataConnections;
int connectionCount = connections.Count;
ExternalConnection connection = null;
for (int i = 0; i < connectionCount; i++)
{
connection = connections[i];
// Check if the Connection is DBConnection, then retrieve its various properties
if (connection is DBConnection)
{
DBConnection dbConn = (DBConnection)connection;
// Retrieve DB Connection Command
Console.WriteLine("Command: " + dbConn.Command);
// Retrieve DB Connection Command Type
Console.WriteLine("Command Type: " + dbConn.CommandType);
// Retrieve DB Connection Description
Console.WriteLine("Description: " + dbConn.ConnectionDescription);
// Retrieve DB Connection ID
Console.WriteLine("Id: " + dbConn.ConnectionId);
// Retrieve DB Connection Info
Console.WriteLine("Info: " + dbConn.ConnectionInfo);
// Retrieve DB Connection Credentials
Console.WriteLine("Credentials: " + dbConn.CredentialsMethodType);
// Retrieve DB Connection Name
Console.WriteLine("Name: " + dbConn.Name);
// Retrieve DB Connection ODC File
Console.WriteLine("OdcFile: " + dbConn.OdcFile);
// Retrieve DB Connection Source File
Console.WriteLine("Source file: " + dbConn.SourceFile);
// Retrieve DB Connection Type
Console.WriteLine("Type: " + dbConn.Type);
// Retrieve DB Connection Parameters Collection
ConnectionParameterCollection paramCollection = dbConn.Parameters;
int paramCount = paramCollection.Count;
// Iterate the Parameter Collection
for (int j = 0; j < paramCount; j++)
{
ConnectionParameter param = paramCollection[j];
// Retrieve Parameter Cell Reference
Console.WriteLine("Cell reference: " + param.CellReference);
// Retrieve Parameter Name
Console.WriteLine("Parameter name: " + param.Name);
// Retrieve Parameter Prompt
Console.WriteLine("Prompt: " + param.Prompt);
// Retrieve Parameter SQL Type
Console.WriteLine("SQL Type: " + param.SqlType);
// Retrieve Parameter Type
Console.WriteLine("Param Type: " + param.Type);
// Retrieve Parameter Value
Console.WriteLine("Param Value: " + param.Value);
} // End for
} // End if
} // End for
Console.WriteLine("RetrievingSQLConnectionData executed successfully.");
}
/// <summary> /// 使用参数更新指定的连接。 /// </summary> /// <param name="connectionString">连接字符串对象。</param> /// <param name="parameter"></param> /// <returns></returns> public abstract string UpdateConnectionString(ConnectionString connectionString, ConnectionParameter parameter);
public override string UpdateConnectionString(ConnectionString connectionString, ConnectionParameter parameter)
{
throw new NotImplementedException();
}
/// <summary>
/// 使用参数更新指定的连接。
/// </summary>
/// <param name="connectionString">连接字符串对象。</param>
/// <param name="parameter"></param>
/// <returns></returns>
public override string UpdateConnectionString(ConnectionString connectionString, ConnectionParameter parameter)
{
connectionString.Properties
.TrySetValue(parameter.Database, "data source");
return(connectionString.Update());
}
public static void Run()
{
// ExStart:1
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create a workbook object from source file
Workbook workbook = new Workbook(dataDir + "connection.xlsx");
// Access the external collections
ExternalConnectionCollection connections = workbook.DataConnections;
int connectionCount = connections.Count;
ExternalConnection connection = null;
for (int i = 0; i < connectionCount; i++)
{
connection = connections[i];
// Check if the Connection is DBConnection, then retrieve its various properties
if (connection is DBConnection)
{
DBConnection dbConn = (DBConnection)connection;
// Retrieve DB Connection Command
Console.WriteLine("Command: " + dbConn.Command);
// Retrieve DB Connection Command Type
Console.WriteLine("Command Type: " + dbConn.CommandType);
// Retrieve DB Connection Description
Console.WriteLine("Description: " + dbConn.ConnectionDescription);
// Retrieve DB Connection ID
Console.WriteLine("Id: " + dbConn.ConnectionId);
// Retrieve DB Connection Info
Console.WriteLine("Info: " + dbConn.ConnectionInfo);
// Retrieve DB Connection Credentials
Console.WriteLine("Credentials: " + dbConn.Credentials);
// Retrieve DB Connection Name
Console.WriteLine("Name: " + dbConn.Name);
// Retrieve DB Connection ODC File
Console.WriteLine("OdcFile: " + dbConn.OdcFile);
// Retrieve DB Connection Source File
Console.WriteLine("Source file: " + dbConn.SourceFile);
// Retrieve DB Connection Type
Console.WriteLine("Type: " + dbConn.Type);
// Retrieve DB Connection Parameters Collection
ConnectionParameterCollection paramCollection = dbConn.Parameters;
int paramCount = paramCollection.Count;
// Iterate the Parameter Collection
for (int j = 0; j < paramCount; j++)
{
ConnectionParameter param = paramCollection[j];
// Retrieve Parameter Cell Reference
Console.WriteLine("Cell reference: " + param.CellReference);
// Retrieve Parameter Name
Console.WriteLine("Parameter name: " + param.Name);
// Retrieve Parameter Prompt
Console.WriteLine("Prompt: " + param.Prompt);
// Retrieve Parameter SQL Type
Console.WriteLine("SQL Type: " + param.SqlType);
// Retrieve Parameter Type
Console.WriteLine("Param Type: " + param.Type);
// Retrieve Parameter Value
Console.WriteLine("Param Value: " + param.Value);
} // End for
} // End if
} // End for
// ExEnd:1
}
/// <summary>
/// 使用参数更新指定的连接。
/// </summary>
/// <param name="connectionString">连接字符串对象。</param>
/// <param name="parameter"></param>
public override void UpdateConnectionString(ConnectionString connectionString, ConnectionParameter parameter)
{
connectionString.Properties.TrySetValue(parameter.Server, "server")
.TrySetValue(parameter.Database, "database")
.Update();
}
/// <summary>
/// 使用参数更新指定的连接。
/// </summary>
/// <param name="connectionString">连接字符串对象。</param>
/// <param name="parameter"></param>
/// <returns></returns>
public override string UpdateConnectionString(ConnectionString connectionString, ConnectionParameter parameter)
{
connectionString.Properties.TrySetValue(parameter.Server, "data source", "server")
.TrySetValue(parameter.Database, "initial catalog", "database")
.TrySetValue(parameter.UserId, "user id", "uid")
.TrySetValue(parameter.Password, "password", "pwd");
return(connectionString.Update());
}
public frmServer()
{
InitializeComponent();
Param = new ConnectionParameter(Connection.Instance.ConnectionParameter);
FillControls();
}