public DbConnectionHandler(uint id, string name, CommunicationInterfaceHandler communicationInterfaceHandler, DbConnectionHandlerFile dbConnectionHandlerFile, DbConnectionHandlerInterfaceAssignmentFile dbConnectionHandlerInterfaceAssignmentFile) : base(id, name, communicationInterfaceHandler) { DbConnectionHandlerFile = dbConnectionHandlerFile; DbConnectionHandlerInterfaceAssignmentFile = dbConnectionHandlerInterfaceAssignmentFile; StoredProcedures = new DbStoredProcedureList(this); if (dbConnectionHandlerInterfaceAssignmentFile.Assignment == null) dbConnectionHandlerInterfaceAssignmentFile.Assignment = new string[9][]; Assignment = dbConnectionHandlerInterfaceAssignmentFile.Assignment[Header.Id]; CreateInterfaceAssignment(); }
public void CreateOutput(string fileName, DbStoredProcedureList storedProcedures) { var settings = new XmlWriterSettings { Indent = true, IndentChars = "\t" }; using (var writer = XmlWriter.Create(fileName, settings)) { writer.WriteStartDocument(); writer.WriteStartElement("StoredProcedures"); foreach (var sp in storedProcedures.Items) { writer.WriteStartElement("Procedure"); writer.WriteAttributeString("Name", sp.SpName); writer.WriteAttributeString("Command", sp.SpCommand.ToString(CultureInfo.InvariantCulture)); foreach (var parameter in sp.SpParameters) { writer.WriteStartElement("Parameter"); writer.WriteAttributeString("Name", parameter.Name); writer.WriteAttributeString("Component", parameter.Component.Name); var id = 0; var parent = parameter.Component.GetOwner() as CommunicationInterfaceHandler; if (parent != null) id = (int)parent.Header.Id; writer.WriteAttributeString("InterfaceId", id.ToString(CultureInfo.InvariantCulture)); writer.WriteAttributeString("InterfaceType", parameter.Component.TypeOfInterface.ToString()); writer.WriteEndElement(); } writer.WriteEndElement(); } writer.WriteEndElement(); writer.WriteEndDocument(); } Logger.Log(fileName + " output file created"); }