private void button1_Click(object sender, EventArgs e) { //Mostrar na listBox2 os alunos do curso selecionado no listBox1: try { listBox2.Items.Clear(); //limpamos a segunda lista string cursoSelec = (string)((DataRowView)listBox1.SelectedItem)[0]; string sql = "SELECT * FROM Alunos WHERE abrevcurso = '" + cursoSelec + "'"; //suponhamos o BD em C:\tempo System.Data.OleDb.OleDbConnection conexao = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/temp/Universidade3.mdb"); conexao.Open(); System.Data.OleDb.OleDbCommand comando = new System.Data.OleDb.OleDbCommand(sql, conexao); System.Data.OleDb.OleDbDataReader dr = comando.ExecuteReader(); while (dr.Read()) { string dadosAluno = dr.GetString(0) + ", " + dr.GetString(1) + ", " + dr.GetString(2) + ", " + dr.GetInt32(3) + ", " + dr.GetString(4); listBox2.Items.Add(dadosAluno); } dr.Close(); comando.Dispose(); conexao.Close(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }
private void button3_Click(object sender, EventArgs e) { // Botão btnResultados try { string id1 = txtIdade1.Text; string id2 = txtIdade2.Text; string strSsexo = ""; if (rbMasculino.Checked) strSsexo = " sexo = 'M' AND "; else if (rbFeminino.Checked) strSsexo = " sexo = 'F' AND "; else strSsexo = ""; sql = "select * from alunos WHERE " + strSsexo + " idade>=" + id1 + " AND idade<=" + id2 + " ORDER BY nome"; stm = new System.Data.OleDb.OleDbCommand(sql, conexao); rs = stm.ExecuteReader(); string strSaida = ""; while (rs.Read()) { string dados = "RGM: " + rs.GetString(0) + ", " + rs.GetString(1) + ", idade: " + rs.GetInt32(3) + ", sexo: " + rs.GetString(4) + ", curso: " + rs.GetString(2); strSaida += dados + "\r\n"; } txtResultados.Text = strSaida; } catch (Exception exsql) { MessageBox.Show("Erro na consulta"); } if(stm!=null)stm.Dispose(); if(rs!=null)rs.Close(); }
internal Structs.ResultWeaponsClass[] GetResultWeaponClassesWithResults() { string select = "SELECT DISTINCT weapons.class " + "FROM (weapons RIGHT JOIN Competitors ON weapons.WeaponId = Competitors.WeaponId) " + "INNER JOIN CompetitorResults ON Competitors.CompetitorId = CompetitorResults.CompetitorId;"; System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand( select, myInterface.databaseClass.Conn); if (myInterface.databaseClass.Conn.State != ConnectionState.Open) { myInterface.databaseClass.Conn.Open(); } System.Data.OleDb.OleDbDataReader r = cmd.ExecuteReader(); List <Structs.WeaponClass> wclasses = new List <Structs.WeaponClass>(); while (r.Read()) { wclasses.Add((Structs.WeaponClass)r.GetInt32(0)); } r.Dispose(); cmd.Dispose(); List <Structs.ResultWeaponsClass> rwclasses = new List <Structs.ResultWeaponsClass>(); foreach (Structs.WeaponClass wclass in wclasses) { // Check for duplicates Structs.ResultWeaponsClass rwc = CConvert.ConvertWeaponsClassToResultClass( wclass, myInterface.CompetitionCurrent.Type); if (!rwclasses.Contains(rwc)) { rwclasses.Add(rwc); } } // Sort rwclasses.Sort(); return(rwclasses.ToArray()); }
private void button3_Click(object sender, EventArgs e) { // Botão btnResultados try { string id1 = txtIdade1.Text; string id2 = txtIdade2.Text; string strSsexo = ""; if (rbMasculino.Checked) { strSsexo = " sexo = 'M' AND "; } else if (rbFeminino.Checked) { strSsexo = " sexo = 'F' AND "; } else { strSsexo = ""; } sql = "select * from alunos WHERE " + strSsexo + " idade>=" + id1 + " AND idade<=" + id2 + " ORDER BY nome"; stm = new System.Data.OleDb.OleDbCommand(sql, conexao); rs = stm.ExecuteReader(); string strSaida = ""; while (rs.Read()) { string dados = "RGM: " + rs.GetString(0) + ", " + rs.GetString(1) + ", idade: " + rs.GetInt32(3) + ", sexo: " + rs.GetString(4) + ", curso: " + rs.GetString(2); strSaida += dados + "\r\n"; } txtResultados.Text = strSaida; } catch (Exception exsql) { MessageBox.Show("Erro na consulta"); } if (stm != null) { stm.Dispose(); } if (rs != null) { rs.Close(); } }
private void m_axCalendar_DoCreateRPattern(object sender, AxXtremeCalendarControl._DCalendarControlEvents_DoCreateRPatternEvent e) { e.bResult = false; if (!IsOpen()) { return; } try { String strSQL = "SELECT * FROM CalendarRecurrencePatterns WHERE RecurrencePatternID = 0 "; System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(strSQL, m_oleDbConnection); System.Data.OleDb.OleDbCommandBuilder custCB = new System.Data.OleDb.OleDbCommandBuilder(oleDbDataAdapter); custCB.QuotePrefix = "["; custCB.QuoteSuffix = "]"; System.Data.DataSet objPatternDSet = new System.Data.DataSet(); oleDbDataAdapter.Fill(objPatternDSet); //code to modify data in dataset here System.Data.DataRow objDRow = objPatternDSet.Tables[0].NewRow(); objPatternDSet.Tables[0].Rows.Add(objDRow); m_DataHelper.PutRPatternToData(e.pPattern, objDRow); oleDbDataAdapter.Update(objPatternDSet); //'-- update Auto EventID System.Data.OleDb.OleDbCommand objCommand = m_oleDbConnection.CreateCommand(); objCommand.CommandText = "SELECT MAX(RecurrencePatternID) AS NewNewPatternID FROM CalendarRecurrencePatterns"; System.Data.OleDb.OleDbDataReader objReader = objCommand.ExecuteReader(); objReader.Read(); e.newPatternID = objReader.GetInt32(0); objReader.Close(); e.bResult = true; } catch (System.Exception ex) { System.Diagnostics.Debug.WriteLine("EXCEPTION! providerSQLServer.m_axCalendar_DoCreateRPattern: " + ex.Message); } }
/// <summary> Returns the Java source code for a class that represents the specified segment.</summary> public static System.String makeSegment(System.String name, System.String version) { System.Text.StringBuilder source = new System.Text.StringBuilder(); try { System.Data.OleDb.OleDbConnection conn = NuGenNormativeDatabase.Instance.Connection; System.Text.StringBuilder sql = new System.Text.StringBuilder(); sql.Append("SELECT HL7SegmentDataElements.seg_code, HL7SegmentDataElements.seq_no, "); sql.Append("HL7SegmentDataElements.repetitional, HL7SegmentDataElements.repetitions, "); sql.Append("HL7DataElements.description, HL7DataElements.length, HL7DataElements.table_id, "); sql.Append("HL7SegmentDataElements.req_opt, HL7Segments.description, HL7DataElements.data_structure "); sql.Append("FROM HL7Versions RIGHT JOIN (HL7Segments INNER JOIN (HL7DataElements INNER JOIN HL7SegmentDataElements "); sql.Append("ON (HL7DataElements.version_id = HL7SegmentDataElements.version_id) "); sql.Append("AND (HL7DataElements.data_item = HL7SegmentDataElements.data_item)) "); sql.Append("ON (HL7Segments.version_id = HL7SegmentDataElements.version_id) "); sql.Append("AND (HL7Segments.seg_code = HL7SegmentDataElements.seg_code)) "); sql.Append("ON (HL7Versions.version_id = HL7Segments.version_id) "); sql.Append("WHERE HL7SegmentDataElements.seg_code = '"); sql.Append(name); sql.Append("' and HL7Versions.hl7_version = '"); sql.Append(version); sql.Append("' ORDER BY HL7SegmentDataElements.seg_code, HL7SegmentDataElements.seq_no;"); //System.out.println(sql.toString()); //for debugging System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = sql.ToString(); System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); System.Collections.ArrayList elements = new System.Collections.ArrayList(); System.String segDesc = null; NuGenSegmentElement se; while (rs.Read()) { if (segDesc == null) { segDesc = System.Convert.ToString(rs[9 - 1]); } se = new NuGenSegmentElement(); se.field = rs.GetInt32(2 - 1); se.rep = System.Convert.ToString(rs[3 - 1]); se.repetitions = rs.GetInt32(4 - 1); if (se.repetitions == 0) { if (se.rep == null || !se.rep.ToUpper().Equals("Y".ToUpper())) { se.repetitions = 1; } } se.desc = System.Convert.ToString(rs[5 - 1]); se.length = rs.GetInt32(6 - 1); se.table = rs.GetInt32(7 - 1); se.opt = System.Convert.ToString(rs[8 - 1]); se.type = System.Convert.ToString(rs[10 - 1]); //shorten CE_x to CE if (se.type.StartsWith("CE")) { se.type = "CE"; } elements.Add(se); /*System.out.println("Segment: " + name + " Field: " + se.field + " Rep: " + se.rep + * " Repetitions: " + se.repetitions + " Desc: " + se.desc + " Length: " + se.length + * " Table: " + se.table + " Segment Desc: " + segDesc);*/ } NuGenNormativeDatabase.Instance.returnConnection(conn); //write imports, class documentation, etc ... source.Append("package "); source.Append(NuGenSourceGenerator.getVersionPackageName(version)); source.Append("segment;\r\n\r\n"); source.Append("import Genetibase.NuGenHL7.model.*;\r\n"); source.Append("import "); source.Append(NuGenSourceGenerator.getVersionPackageName(version)); source.Append("datatype.*;\r\n\r\n"); source.Append("import Genetibase.NuGenHL7.parser.ModelClassFactory;\r\n"); source.Append("import Genetibase.NuGenHL7.HL7Exception;\r\n\r\n"); source.Append("/**\r\n"); source.Append(" * <p>Represents an HL7 "); source.Append(name); source.Append(" message segment. \r\n"); source.Append(" * This segment has the following fields:</p><p>\r\n"); for (int i = 0; i < elements.Count; i++) { se = (NuGenSegmentElement)elements[i]; source.Append(" * "); source.Append(name); source.Append("-"); source.Append(se.field); source.Append(": "); source.Append(se.desc); source.Append(" ("); source.Append(se.type); source.Append(")<br> \r\n"); } source.Append(" * </p><p>The get...() methods return data from individual fields. These methods \r\n"); source.Append(" * do not throw exceptions and may therefore have to handle exceptions internally. \r\n"); source.Append(" * If an exception is handled internally, it is logged and null is returned. \r\n"); source.Append(" * This is not expected to happen - if it does happen this indicates not so much \r\n"); source.Append(" * an exceptional circumstance as a bug in the code for this class.</p> \r\n"); source.Append(" */\r\n"); source.Append("public class "); source.Append(name); source.Append(" extends AbstractSegment "); //implement interface from model.control package if required /*Class correspondingControlInterface = Control.getInterfaceImplementedBy(name); * if (correspondingControlInterface != null) { * source.append("implements "); * source.append(correspondingControlInterface.getName()); * } */ source.Append(" {\r\n\r\n"); source.Append(" /**\r\n"); source.Append(" * Creates a "); source.Append(name); source.Append(" ("); source.Append(segDesc); source.Append(") segment object that belongs to the given \r\n"); source.Append(" * message. \r\n"); source.Append(" */\r\n"); //write constructor source.Append(" public "); source.Append(name); source.Append("(Group parent, ModelClassFactory factory) {\r\n"); source.Append(" super(parent, factory);\r\n"); source.Append(" Message message = getMessage();\r\n"); if (elements.Count > 0) { source.Append(" try {\r\n"); for (int i = 0; i < elements.Count; i++) { se = (NuGenSegmentElement)elements[i]; System.String type = NuGenSourceGenerator.getAlternateType(se.type, version); source.Append(" this.add("); source.Append(type); source.Append(".class"); // if (type.equalsIgnoreCase("Varies")) { // } else { // source.append("factory.getTypeClass(\""); // source.append(type); // source.append("\", \""); // source.append(version); // source.append("\")"); // } source.Append(", "); if (se.opt == null) { source.Append("false"); } else { if (se.opt.ToUpper().Equals("R".ToUpper())) { source.Append("true"); } else { source.Append("false"); } } source.Append(", "); source.Append(se.repetitions); source.Append(", "); source.Append(se.length); source.Append(", "); if (se.type.Equals("ID") || se.type.Equals("IS")) { source.Append("new Object[]{message, new Integer("); source.Append(se.table); source.Append(")}"); } else { source.Append("new Object[]{message}"); } source.Append(");\r\n"); } source.Append(" } catch (HL7Exception he) {\r\n"); source.Append(" }\r\n"); } source.Append(" }\r\n\r\n"); //write a datatype-specific accessor for each field for (int i = 0; i < elements.Count; i++) { se = (NuGenSegmentElement)elements[i]; if (!se.desc.ToUpper().Equals("UNUSED".ToUpper())) { //some entries in 2.1 DB say "unused" System.String type = NuGenSourceGenerator.getAlternateType(se.type, version); source.Append(" /**\r\n"); source.Append(" * Returns "); if (se.repetitions != 1) { source.Append("a single repetition of "); } source.Append(se.desc); source.Append(" ("); source.Append(name); source.Append("-"); source.Append(se.field); source.Append(").\r\n"); if (se.repetitions != 1) { source.Append(" * @param rep the repetition number (this is a repeating field)\r\n"); source.Append(" * @throws HL7Exception if the repetition number is invalid.\r\n"); } source.Append(" */\r\n"); source.Append(" public "); source.Append(type); source.Append(" "); source.Append(NuGenSourceGenerator.makeAccessorName(se.desc)); source.Append("("); if (se.repetitions != 1) { source.Append("int rep"); } source.Append(") "); if (se.repetitions != 1) { source.Append("throws HL7Exception"); } source.Append(" {\r\n"); source.Append(" "); source.Append(type); source.Append(" ret = null;\r\n"); source.Append(" try {\r\n"); source.Append(" Type t = this.getField("); source.Append(se.field); source.Append(", "); if (se.repetitions == 1) { source.Append("0"); } else { source.Append("rep"); } source.Append(");\r\n"); source.Append(" ret = ("); source.Append(type); source.Append(")t;\r\n"); source.Append(" } catch (ClassCastException ) {\r\n"); source.Append(" throw new Exception();\r\n"); if (se.repetitions == 1) { source.Append(" } catch (HL7Exception he) {\r\n"); source.Append(" throw new Exception();\r\n"); } source.Append(" }\r\n"); source.Append(" return ret;\r\n"); source.Append(" }\r\n\r\n"); //add an array accessor as well for repeating fields if (se.repetitions != 1) { source.Append(" /**\r\n"); source.Append(" * Returns all repetitions of "); source.Append(se.desc); source.Append(" ("); source.Append(name); source.Append("-"); source.Append(se.field); source.Append(").\r\n"); source.Append(" */\r\n"); source.Append(" public "); source.Append(type); source.Append("[] "); source.Append(NuGenSourceGenerator.makeAccessorName(se.desc)); source.Append("() {\r\n"); source.Append(" "); source.Append(type); source.Append("[] ret = null;\r\n"); source.Append(" try {\r\n"); source.Append(" Type[] t = this.getField("); source.Append(se.field); source.Append("); \r\n"); source.Append(" ret = new "); source.Append(type); source.Append("[t.length];\r\n"); source.Append(" for (int i = 0; i < ret.length; i++) {\r\n"); source.Append(" ret[i] = ("); source.Append(type); source.Append(")t[i];\r\n"); source.Append(" }\r\n"); source.Append(" } catch (ClassCastException ) {\r\n"); source.Append(" throw new Exception();\r\n"); source.Append(" } catch (HL7Exception he) {\r\n"); source.Append(" throw new Exception();\r\n"); source.Append(" }\r\n"); source.Append(" return ret;\r\n"); source.Append(" }\r\n\r\n"); } } } //add adapter method code for control package if it exists //source.append(Control.getImplementation(correspondingControlInterface, version)); source.Append("}"); } catch (System.Data.OleDb.OleDbException sqle) { SupportClass.WriteStackTrace(sqle, Console.Error); } return(source.ToString()); }
/// <summary> Creates source code for a single data type in the HL7 normative /// database. /// </summary> /// <param name="targetDirectory">the directory into which the file will be written /// </param> /// <param name="datatype">the name (e.g. ST, ID, etc.) of the data type to be created /// </param> /// <param name="version">the HL7 version of the intended data type /// </param> public static void make(System.IO.FileInfo targetDirectory, System.String dataType, System.String version) { Console.WriteLine(" Writing " + targetDirectory.FullName + dataType); //make sure that targetDirectory is a directory ... if (!System.IO.Directory.Exists(targetDirectory.FullName)) { throw new System.IO.IOException("Can't create file in " + targetDirectory.ToString() + " - it is not a directory."); } //get any components for this data type //UPGRADE_NOTE: There are other database providers or managers under System.Data namespace which can be used optionally to better fit the application requirements. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1208'" System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection; //UPGRADE_TODO: Method 'java.sql.Connection.createStatement' was converted to 'SupportClass.TransactionManager.manager.CreateStatement' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlConnectioncreateStatement'" System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); System.Text.StringBuilder sql = new System.Text.StringBuilder(); //this query is adapted from the XML SIG informative document sql.Append("SELECT HL7DataStructures.data_structure, HL7DataStructureComponents.seq_no, HL7DataStructures.description, HL7DataStructureComponents.table_id, "); sql.Append("HL7Components.description, HL7Components.table_id, HL7Components.data_type_code, HL7Components.data_structure "); sql.Append("FROM HL7Versions LEFT JOIN (HL7DataStructures LEFT JOIN (HL7DataStructureComponents LEFT JOIN HL7Components "); sql.Append("ON HL7DataStructureComponents.comp_no = HL7Components.comp_no AND "); sql.Append("HL7DataStructureComponents.version_id = HL7Components.version_id) "); sql.Append("ON HL7DataStructures.version_id = HL7DataStructureComponents.version_id "); sql.Append("AND HL7DataStructures.data_structure = HL7DataStructureComponents.data_structure) "); sql.Append("ON HL7DataStructures.version_id = HL7Versions.version_id "); sql.Append("WHERE HL7DataStructures.data_structure = '"); sql.Append(dataType); sql.Append("' AND HL7Versions.hl7_version = '"); sql.Append(version); sql.Append("' ORDER BY HL7DataStructureComponents.seq_no"); //System.out.println(sql.toString()); //for debugging //UPGRADE_TODO: Interface 'java.sql.ResultSet' was converted to 'System.Data.OleDb.OleDbDataReader' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javasqlResultSet'" System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = sql.ToString(); System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); System.Collections.ArrayList dataTypes = new System.Collections.ArrayList(20); System.Collections.ArrayList descriptions = new System.Collections.ArrayList(20); System.Collections.ArrayList tables = new System.Collections.ArrayList(20); System.String description = null; while (rs.Read()) { if (description == null) { description = System.Convert.ToString(rs[3 - 1]); } System.String de = System.Convert.ToString(rs[5 - 1]); System.String dt = System.Convert.ToString(rs[8 - 1]); int ta = -1; if (!rs.IsDBNull(4 - 1)) { ta = rs.GetInt32(4 - 1); } //trim all CE_x to CE if (dt != null) { if (dt.StartsWith("CE")) { dt = "CE"; } } //System.out.println("Component: " + de + " Data Type: " + dt); //for debugging dataTypes.Add(dt); descriptions.Add(de); tables.Add((System.Int32)ta); } if (dataType.ToUpper().Equals("TS") && version != "2.5") { dataTypes[0] = "TSComponentOne"; } rs.Close(); //UPGRADE_ISSUE: Method 'java.sql.Statement.close' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javasqlStatementclose'" stmt.Dispose(); NormativeDatabase.Instance.returnConnection(conn); //if there is only one component make a Primitive, otherwise make a Composite System.String source = null; if (dataTypes.Count == 1) { if (dataType.Equals("FT") || dataType.Equals("ST") || dataType.Equals("TX") || dataType.Equals("NM") || dataType.Equals("SI") || dataType.Equals("TN") || dataType.Equals("GTS")) { source = makePrimitive(dataType, description, version); } else { source = null; //note: IS, ID, DT, DTM, and TM are coded manually } } else if (dataTypes.Count > 1) { int numComponents = dataTypes.Count; //copy data into arrays ... System.String[] type = new System.String[numComponents]; System.String[] desc = new System.String[numComponents]; int[] table = new int[numComponents]; for (int i = 0; i < numComponents; i++) { type[i] = ((System.String)dataTypes[i]); desc[i] = ((System.String)descriptions[i]); table[i] = ((System.Int32)tables[i]); } source = makeComposite(dataType, description, type, desc, table, version); } else { //no components? //throw new DataTypeException("The data type " + dataType + " could not be found"); Console.WriteLine("No components for " + dataType); } //System.out.println(source); //write to file ... if (source != null) { System.String targetFile = targetDirectory.ToString() + "/" + dataType + ".cs"; //UPGRADE_WARNING: At least one expression was used more than once in the target code. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1181'" //UPGRADE_TODO: Constructor 'java.io.FileWriter.FileWriter' was converted to 'System.IO.StreamWriter' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javaioFileWriterFileWriter_javalangString_boolean'" //UPGRADE_TODO: Class 'java.io.FileWriter' was converted to 'System.IO.StreamWriter' which has a different behavior. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1073_javaioFileWriter'" using (System.IO.StreamWriter writer = new System.IO.StreamWriter(targetFile)) { writer.Write(source); writer.Write("}"); //End namespace } } else { Console.WriteLine("No Source for " + dataType); } }
/// <summary> Creates source code for a single data type in the HL7 normative database. </summary> /// /// <exception cref="IOException"> Thrown when an IO failure occurred. </exception> /// /// <param name="targetDirectory"> the directory into which the file will be written. </param> /// <param name="dataType"> Type of the data. </param> /// <param name="version"> the HL7 version of the intended data type. </param> /// /// ### <param name="datatype"> the name (e.g. ST, ID, etc.) of the data type to be created. </param> public static void make(System.IO.FileInfo targetDirectory, System.String dataType, System.String version) { Console.WriteLine(" Writing " + targetDirectory.FullName + dataType); //make sure that targetDirectory is a directory ... if (!System.IO.Directory.Exists(targetDirectory.FullName)) { throw new System.IO.IOException("Can't create file in " + targetDirectory + " - it is not a directory."); } //get any components for this data type System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection; System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn); System.Text.StringBuilder sql = new System.Text.StringBuilder(); //this query is adapted from the XML SIG informative document sql.Append( "SELECT HL7DataStructures.data_structure, HL7DataStructureComponents.seq_no, HL7DataStructures.description, HL7DataStructureComponents.table_id, "); sql.Append( "HL7Components.description, HL7Components.table_id, HL7Components.data_type_code, HL7Components.data_structure "); sql.Append( "FROM HL7Versions LEFT JOIN (HL7DataStructures LEFT JOIN (HL7DataStructureComponents LEFT JOIN HL7Components "); sql.Append("ON HL7DataStructureComponents.comp_no = HL7Components.comp_no AND "); sql.Append("HL7DataStructureComponents.version_id = HL7Components.version_id) "); sql.Append("ON HL7DataStructures.version_id = HL7DataStructureComponents.version_id "); sql.Append("AND HL7DataStructures.data_structure = HL7DataStructureComponents.data_structure) "); sql.Append("ON HL7DataStructures.version_id = HL7Versions.version_id "); sql.Append("WHERE HL7DataStructures.data_structure = '"); sql.Append(dataType); sql.Append("' AND HL7Versions.hl7_version = '"); sql.Append(version); sql.Append("' ORDER BY HL7DataStructureComponents.seq_no"); System.Data.OleDb.OleDbCommand temp_OleDbCommand; temp_OleDbCommand = stmt; temp_OleDbCommand.CommandText = sql.ToString(); System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader(); System.Collections.ArrayList dataTypes = new System.Collections.ArrayList(20); System.Collections.ArrayList descriptions = new System.Collections.ArrayList(20); System.Collections.ArrayList tables = new System.Collections.ArrayList(20); System.String description = null; while (rs.Read()) { if (description == null) { description = System.Convert.ToString(rs[3 - 1]); } System.String de = System.Convert.ToString(rs[5 - 1]); System.String dt = System.Convert.ToString(rs[8 - 1]); int ta = -1; if (!rs.IsDBNull(4 - 1)) { ta = rs.GetInt32(4 - 1); } //trim all CE_x to CE if (dt != null) { if (dt.StartsWith("CE")) { dt = "CE"; } } //System.out.println("Component: " + de + " Data Type: " + dt); //for debugging dataTypes.Add(dt); descriptions.Add(de); tables.Add(ta); } if (dataType.ToUpper().Equals("TS")) { dataTypes[0] = "TSComponentOne"; } rs.Close(); stmt.Dispose(); NormativeDatabase.Instance.returnConnection(conn); //if there is only one component make a Primitive, otherwise make a Composite System.String source = null; if (dataTypes.Count == 1) { if (dataType.Equals("FT") || dataType.Equals("ST") || dataType.Equals("TX") || dataType.Equals("NM") || dataType.Equals("SI") || dataType.Equals("TN") || dataType.Equals("GTS")) { source = makePrimitive(dataType, description, version); } else { source = null; //note: IS, ID, DT, DTM, and TM are coded manually } } else if (dataTypes.Count > 1) { int numComponents = dataTypes.Count; //copy data into arrays ... System.String[] type = new System.String[numComponents]; System.String[] desc = new System.String[numComponents]; int[] table = new int[numComponents]; for (int i = 0; i < numComponents; i++) { type[i] = ((System.String)dataTypes[i]); desc[i] = ((System.String)descriptions[i]); table[i] = ((System.Int32)tables[i]); } source = makeComposite(dataType, description, type, desc, table, version); } else { //no components? //throw new DataTypeException("The data type " + dataType + " could not be found"); Console.WriteLine("No components for " + dataType); } //System.out.println(source); //write to file ... if (source != null) { System.String targetFile = targetDirectory + "/" + dataType + ".cs"; using (System.IO.StreamWriter writer = new System.IO.StreamWriter(targetFile)) { writer.Write(source); writer.Write("}"); //End namespace } } else { Console.WriteLine("No Source for " + dataType); } }
protected CalendarEvent _CreateEventFromData(System.Data.OleDb.OleDbDataReader pEventData, Boolean bRException) { try { CalendarEvent pEvent = null; int nEventID; if (pEventData.IsClosed /*|| !pEventData.HasRows*/) { return(null); } nEventID = pEventData.GetInt32(pEventData.GetOrdinal("EventID")); pEvent = m_pCalendar.DataProvider.CreateEventEx(nEventID); if (pEvent == null) { return(null); } pEvent.Subject = pEventData.GetString(pEventData.GetOrdinal("Subject")); pEvent.Location = pEventData.GetString(pEventData.GetOrdinal("Location")); pEvent.Body = pEventData.GetString(pEventData.GetOrdinal("Body")); pEvent.MeetingFlag = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("IsMeeting"))); pEvent.PrivateFlag = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("IsPrivate"))); pEvent.Label = pEventData.GetInt32(pEventData.GetOrdinal("LabelID")); pEvent.BusyStatus = (CalendarEventBusyStatus)pEventData.GetInt32(pEventData.GetOrdinal("BusyStatus")); pEvent.Importance = (CalendarEventImportance)pEventData.GetInt32(pEventData.GetOrdinal("ImportanceLevel")); pEvent.StartTime = pEventData.GetDateTime(pEventData.GetOrdinal("StartDateTime")); pEvent.EndTime = pEventData.GetDateTime(pEventData.GetOrdinal("EndDateTime")); pEvent.AllDayEvent = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("IsAllDayEvent"))); pEvent.Reminder = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("IsReminder"))); pEvent.ReminderMinutesBeforeStart = pEventData.GetInt32(pEventData.GetOrdinal("ReminderMinutesBeforeStart")); pEvent.ReminderSoundFile = pEventData.GetString(pEventData.GetOrdinal("RemainderSoundFile")); pEvent.CustomProperties.LoadFromString(pEventData.GetString(pEventData.GetOrdinal("CustomPropertiesXMLData"))); pEvent.CustomIcons.LoadFromString(pEventData.GetString(pEventData.GetOrdinal("CustomIconsIDs"))); pEvent.ScheduleID = pEventData.GetInt32(pEventData.GetOrdinal("ScheduleID")); if (bRException) { pEvent.MakeAsRException(); pEvent.RExceptionStartTimeOrig = pEventData.GetDateTime(pEventData.GetOrdinal("RExceptionStartTimeOrig")); pEvent.RExceptionEndTimeOrig = pEventData.GetDateTime(pEventData.GetOrdinal("RExceptionEndTimeOrig")); pEvent.RExceptionDeleted = ToBool(pEventData.GetInt32(pEventData.GetOrdinal("ISRecurrenceExceptionDeleted"))); } if (!bRException) { // "process_RecurrenceState" and "process_RecurrencePatternID" properties // are used to process master events. // // If they are set and RecurrenceStaie is Master Data provider will // fier DoReadRPattern event and make event as Master. // And it will also generate occurrences for RetrieveDayEvents method. // // These properties are temporary and they will be removed by data provider. // // If these properties are not set data provider expect that master event // is already compleated - CreateRecurrence method is called and // Recurrence pattern is set. // // This mechanism is useful for DB data providers, when events and patterns // are stored separately (in tables). // But if events stored in some memory collection or array // it should not be used because master event store recurrence pattern inside. pEvent.CustomProperties["process_RecurrenceState"] = pEventData.GetValue(pEventData.GetOrdinal("RecurrenceState")); pEvent.CustomProperties["process_RecurrencePatternID"] = pEventData.GetValue(pEventData.GetOrdinal("RecurrencePatternID")); } return(pEvent); } catch (System.Exception e) { System.Diagnostics.Debug.WriteLine("EXCEPTION! SQLDataHelper.CreateEventFromRS: " + e.Message); } return(null); }
public CalendarRecurrencePattern CreateRPatternFromData(System.Data.OleDb.OleDbDataReader pRPatternData, System.Data.OleDb.OleDbConnection pOleDbConn) { try { CalendarRecurrencePattern pRPattern = null; int nPatternID; if (pRPatternData.IsClosed /*|| !pRPatternData.HasRows*/) { return(null); } nPatternID = pRPatternData.GetInt32(pRPatternData.GetOrdinal("RecurrencePatternID")); pRPattern = m_pCalendar.DataProvider.CreateRecurrencePattern(nPatternID); if (pRPattern == null) { return(null); } pRPattern.MasterEventId = pRPatternData.GetInt32(pRPatternData.GetOrdinal("MasterEventID")); pRPattern.StartTime = pRPatternData.GetDateTime(pRPatternData.GetOrdinal("EventStartTime")); pRPattern.DurationMinutes = pRPatternData.GetInt32(pRPatternData.GetOrdinal("EventDuration")); pRPattern.StartDate = pRPatternData.GetDateTime(pRPatternData.GetOrdinal("PatternStartDate")); pRPattern.EndMethod = (CalendarPatternEnd)pRPatternData.GetInt32(pRPatternData.GetOrdinal("PatternEndMethod")); if (pRPattern.EndMethod == CalendarPatternEnd.xtpCalendarPatternEndDate) { pRPattern.EndDate = pRPatternData.GetDateTime(pRPatternData.GetOrdinal("PatternEndDate")); } else if (pRPattern.EndMethod == CalendarPatternEnd.xtpCalendarPatternEndAfterOccurrences) { pRPattern.EndAfterOccurrences = pRPatternData.GetInt32(pRPatternData.GetOrdinal("PatternEndAfterOccurrences")); } else { System.Diagnostics.Debug.Assert(pRPattern.EndMethod == CalendarPatternEnd.xtpCalendarPatternEndNoDate); } pRPattern.Options.Data1 = pRPatternData.GetInt32(pRPatternData.GetOrdinal("OptionsData1")); pRPattern.Options.Data2 = pRPatternData.GetInt32(pRPatternData.GetOrdinal("OptionsData2")); pRPattern.Options.Data3 = pRPatternData.GetInt32(pRPatternData.GetOrdinal("OptionsData3")); pRPattern.Options.Data4 = pRPatternData.GetInt32(pRPatternData.GetOrdinal("OptionsData4")); pRPattern.CustomProperties.LoadFromString(pRPatternData.GetString(pRPatternData.GetOrdinal("CustomPropertiesXMLData"))); pRPatternData.Close(); ReadRPatternExceptions(pRPattern, pOleDbConn); return(pRPattern); } catch (System.Exception e) { System.Diagnostics.Debug.WriteLine("EXCEPTION! SQLDataHelper.CreateRPatternFromData: " + e.Message); } return(null); }