/// <summary>
/// Creates skeletal source code (without correct data structure but no business logic) for all
/// data types found in the normative database. For versions > 2.2, Primitive data types are not
/// generated, because they are coded manually (as of HAPI 0.3).
/// </summary>
///
/// <param name="baseDirectory"> Pathname of the base directory. </param>
/// <param name="version"> the HL7 version of the intended data type. </param>
public static void makeAll(System.String baseDirectory, System.String version)
{
//make base directory
if (!(baseDirectory.EndsWith("\\") || baseDirectory.EndsWith("/")))
{
baseDirectory = baseDirectory + "/";
}
System.IO.FileInfo targetDir =
SourceGenerator.makeDirectory(
baseDirectory + PackageManager.GetVersionPackagePath(version) + "Datatype");
SourceGenerator.makeDirectory(baseDirectory + PackageManager.GetVersionPackagePath(version) + "Datatype");
//get list of data types
System.Collections.ArrayList types = new System.Collections.ArrayList();
System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection;
System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn);
//get normal data types ...
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText =
"select data_type_code from HL7DataTypes, HL7Versions where HL7Versions.version_id = HL7DataTypes.version_id and HL7Versions.hl7_version = '"
+ version + "'";
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
while (rs.Read())
{
types.Add(System.Convert.ToString(rs[1 - 1]));
}
rs.Close();
//get CF, CK, CM, CN, CQ sub-types ...
System.Data.OleDb.OleDbCommand temp_OleDbCommand2;
temp_OleDbCommand2 = stmt;
temp_OleDbCommand2.CommandText = "select data_structure from HL7DataStructures, HL7Versions where ("
+ "data_type_code = 'CF' or " + "data_type_code = 'CK' or "
+ "data_type_code = 'CM' or " + "data_type_code = 'CN' or "
+ "data_type_code = 'CQ') and "
+ "HL7Versions.version_id = HL7DataStructures.version_id and HL7Versions.hl7_version = '"
+ version + "'";
rs = temp_OleDbCommand2.ExecuteReader();
while (rs.Read())
{
types.Add(System.Convert.ToString(rs[1 - 1]));
}
stmt.Dispose();
NormativeDatabase.Instance.returnConnection(conn);
System.Console.Out.WriteLine("Generating " + types.Count + " datatypes for version " + version);
if (types.Count == 0)
{
log.Warn("No version " + version + " data types found in database " + conn.Database);
}
for (int i = 0; i < types.Count; i++)
{
if (!((String)types[i]).Equals("*"))
{
make(targetDir, (System.String)types[i], version);
}
}
}
/// <summary> <p>Creates skeletal source code (without correct data structure but no business
/// logic) for all data types found in the normative database. For versions > 2.2, Primitive data types
/// are not generated, because they are coded manually (as of HAPI 0.3).
/// </summary>
public static void makeAll(System.String baseDirectory, System.String version)
{
//make base directory
if (!(baseDirectory.EndsWith("\\") || baseDirectory.EndsWith("/")))
{
baseDirectory = baseDirectory + "/";
}
System.IO.FileInfo targetDir = SourceGenerator.makeDirectory(baseDirectory + SourceGenerator.getVersionPackageDirectory(version) + "datatype");
SourceGenerator.makeDirectory(baseDirectory + SourceGenerator.getVersionPackageDirectory(version) + "datatype");
//get list of data types
System.Collections.ArrayList types = new System.Collections.ArrayList();
//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);
//get normal data types ...
//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 = "select data_type_code from HL7DataTypes, HL7Versions where HL7Versions.version_id = HL7DataTypes.version_id and HL7Versions.hl7_version = '" + version + "'";
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
while (rs.Read())
{
types.Add(System.Convert.ToString(rs[1 - 1]));
}
rs.Close();
//get CF, CK, CM, CN, CQ sub-types ...
System.Data.OleDb.OleDbCommand temp_OleDbCommand2;
temp_OleDbCommand2 = stmt;
temp_OleDbCommand2.CommandText = "select data_structure from HL7DataStructures, HL7Versions where (" + "data_type_code = 'CF' or " + "data_type_code = 'CK' or " + "data_type_code = 'CM' or " + "data_type_code = 'CN' or " + "data_type_code = 'CQ') and " + "HL7Versions.version_id = HL7DataStructures.version_id and HL7Versions.hl7_version = '" + version + "'";
rs = temp_OleDbCommand2.ExecuteReader();
while (rs.Read())
{
types.Add(System.Convert.ToString(rs[1 - 1]));
}
//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);
System.Console.Out.WriteLine("Generating " + types.Count + " datatypes for version " + version);
if (types.Count == 0)
{
//UPGRADE_ISSUE: Method 'java.lang.System.getProperty' was not converted. "ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?index='!DefaultContextWindowIndex'&keyword='jlca1000_javalangSystem'"
log.warn("No version " + version + " data types found in database " + conn.Database);
}
for (int i = 0; i < types.Count; i++)
{
if (!((String)types[i]).Equals("*"))
{
make(targetDir, (System.String)types[i], version);
}
}
}
public static void start_adress()
{
System.Data.OleDb.OleDbConnection con1 = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=D:/ASSEMBLER.mdb");
try
{
con1.Open();
System.Data.OleDb.OleDbDataReader reader = null;
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("select operand from read_pgm where operand='START'", con1);
reader = cmd.ExecuteReader();
while (reader.Read())
{
string opcode = reader["operand"].ToString();
if (opcode == "START")
{
// string f = "FIRST";
System.Data.OleDb.OleDbCommand cmd1 = new System.Data.OleDb.OleDbCommand("select op from read_pgm where operand ='START'", con1);
reader = cmd1.ExecuteReader();
while (reader.Read())
{
int lc = 0;
lc = lc + Convert.ToInt16(reader["op"].ToString());
System.Data.OleDb.OleDbConnection con2 = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=D:/ASSEMBLER.mdb");
con2.Open();
System.Data.OleDb.OleDbCommand top1 = new System.Data.OleDb.OleDbCommand("UPDATE read_pgm SET[Adress] = ? where opcode = ?", con2);
string cv = Convert.ToString(lc);
top1.Parameters.AddWithValue("?", Convert.ToString(lc));
top1.Parameters.AddWithValue("?", "FIRST");
top1.ExecuteNonQuery();
//lc = lc + 3;
con2.Close();
}
}
}
con1.Close();
// Form1 ob = new Form1();
// ob.pgm();
// this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.Source);
}
finally
{
Form obj = new Form2();
obj.Show();
}
}
public static string FetchGivenNamefromExcel(string TestName)
{
DirectoryInfo currentDir = new DirectoryInfo(Directory.GetCurrentDirectory());
path = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location).Replace("\\bin\\Debug", "") + "\\Input Files\\TestData.xlsx";
System.Data.OleDb.OleDbConnection MyConnection;
string sqlTest = null;
MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + path + "'; Extended Properties='Excel 12.0; HDR = YES'");
MyConnection.Open();
sqlTest = "select * from [" + ObjectRepository.ProjectName + "$] where TestCasesName =\"" + TestName + "\"";
System.Data.OleDb.OleDbCommand TestCommand = new System.Data.OleDb.OleDbCommand(sqlTest, MyConnection);
System.Data.OleDb.OleDbDataReader TestReader = TestCommand.ExecuteReader();
GetGivenName = new Dictionary <int, string>();
while (TestReader.Read())
{
int i = 1;
for (int Row = 1; Row < TestReader.FieldCount; Row++)
{
GetGivenName.Add(i, TestReader.GetValue(Row).ToString().Trim());
i++;
}
}
TestReader.Close();
return(GetGivenName[2].ToString());
}
/// <summary> Fetches the last modification time of the resource
/// *
/// </summary>
/// <param name="resource">Resource object we are finding timestamp of
/// </param>
/// <param name="i_operation">string for logging, indicating caller's intention
/// *
/// </param>
/// <returns>timestamp as long
///
/// </returns>
private long readLastModified(Resource resource, System.String i_operation)
{
/*
* get the template name from the resource
*/
System.String name = resource.Name;
try {
System.Data.OleDb.OleDbConnection conn = openDbConnection();
try {
//UPGRADE_TODO: The equivalent of java.sql.ResultSet must call Close() before performing any other operation with the associated connection. 'ms-help://MS.VSCC/commoner/redir/redirect.htm?keyword="jlca1129"'
System.Data.OleDb.OleDbDataReader rs = readData(conn, timestampColumn, name);
try {
if (rs.Read())
{
return((System.Convert.ToDateTime(rs[(timestampColumn)]).Ticks - 621355968000000000) / 10000);
}
else
{
System.Diagnostics.Process.error("DataSourceResourceLoader Error: while " + i_operation + " could not find resource " + name);
}
} finally {
rs.Close();
}
} finally {
closeDbConnection(conn);
}
} catch (System.Exception e) {
System.Diagnostics.Process.error("DataSourceResourceLoader Error: error while " + i_operation + " when trying to load resource " + name + ": " + e.ToString());
}
return(0);
}
public static void makeAll(System.String baseDirectory, System.String version)
{
//make base directory
if (!(baseDirectory.EndsWith("\\") || baseDirectory.EndsWith("/")))
{
baseDirectory = baseDirectory + "/";
}
System.IO.FileInfo targetDir = SourceGenerator.makeDirectory(baseDirectory + PackageManager.GetVersionPackagePath(version) + "EventMapping");
//get list of data types
System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection;
System.String sql = "SELECT * from HL7EventMessageTypes inner join HL7Versions on HL7EventMessageTypes.version_id = HL7Versions.version_id where HL7Versions.hl7_version = '" + version + "'";
System.Data.OleDb.OleDbCommand temp_OleDbCommand = new System.Data.OleDb.OleDbCommand();
temp_OleDbCommand.Connection = conn;
temp_OleDbCommand.CommandText = sql;
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
using (StreamWriter sw = new StreamWriter(targetDir.FullName + @"\EventMap.properties", false))
{
sw.WriteLine("#event -> structure map for " + version);
while (rs.Read())
{
string messageType = string.Format("{0}_{1}", rs["message_typ_snd"], rs["event_code"]);
string structure = (string)rs["message_structure_snd"];
sw.WriteLine(string.Format("{0} {1}", messageType, structure));
Console.WriteLine(string.Format("Mapping Event {0} to {1}", messageType, structure));
}
}
}
public static void Main(System.String[] args)
{
try
{
System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection;
System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn);
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText = "select * from TableValues";
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
while (rs.Read())
{
System.Object tabNum = rs.GetValue(1 - 1);
System.Object val = rs.GetValue(3 - 1);
System.Object desc = rs.GetValue(4 - 1);
System.Console.Out.WriteLine("Table: " + tabNum + " Value: " + val + " Description: " + desc);
}
}
catch (System.Data.OleDb.OleDbException e)
{
log.Error("test msg!!", e);
}
catch (System.Exception e)
{
log.Error("test msg!!", e);
}
}
private double soluongton(string mshs)
{
double kq = 0, kq1 = 0, kq2 = 0;
try
{
string sql1 = "Select ntan From baoan where Month(ntan) = '" + (double.Parse(cboThang.Text) - 1) + "' and mshs = '" + mshs + "' and BS = 1";
System.Data.OleDb.OleDbDataReader dr1 = KPBT.Modules.Connect.TruyVandr(sql1);
while (dr1.Read())
{
kq1 += 1;
}
dr1.Close();
string sql2 = "Select sophaithu From thutien inner join dmthu on thutien.makhthu = dmthu.makhthu where thang = " + (double.Parse(cboThang.Text) - 1) + " and thutien.mshs = '" + mshs + "' and dmthu.tenkhoanthu = 'Tiền ăn'";
System.Data.OleDb.OleDbDataReader dr2 = KPBT.Modules.Connect.TruyVandr(sql2);
while (dr2.Read())
{
kq2 += double.Parse(dr2["sophaithu"].ToString());
}
dr2.Close();
kq = kq2 - kq1;
}
catch { }
return(kq);
}
private void m_axCalendar_DoReadRPattern(object sender, AxXtremeCalendarControl._DCalendarControlEvents_DoReadRPatternEvent e)
{
if (!IsOpen())
{
return;
}
System.Data.OleDb.OleDbDataReader oleReader = null;
try
{
System.Data.OleDb.OleDbCommand oleDbCommand = m_oleDbConnection.CreateCommand();
oleDbCommand.CommandText = "SELECT * FROM CalendarRecurrencePatterns WHERE RecurrencePatternID = " + Convert.ToString(e.patternID);
oleReader = oleDbCommand.ExecuteReader();
if (oleReader.Read())
{
e.pPattern = m_DataHelper.CreateRPatternFromData(oleReader, m_oleDbConnection);
}
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.WriteLine("EXCEPTION! providerSQLServer.m_axCalendar_DoReadRPattern: " + ex.Message);
}
//================================================
if (oleReader != null && !oleReader.IsClosed)
{
oleReader.Close();
}
}
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();
}
/// <summary> Creates and writes source code for all Messages and Groups. </summary>
///
/// <param name="baseDirectory"> Pathname of the base directory. </param>
/// <param name="version"> The version. </param>
public static void makeAll(System.String baseDirectory, System.String version)
{
//get list of messages ...
using (System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection)
{
System.String sql = getMessageListQuery(version);
System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn);
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText = sql;
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
System.Collections.ArrayList messages = new System.Collections.ArrayList();
System.Collections.ArrayList chapters = new System.Collections.ArrayList();
while (rs.Read())
{
messages.Add(System.Convert.ToString(rs[1 - 1]));
chapters.Add(System.Convert.ToString(rs[2 - 1]));
}
rs.Close();
NormativeDatabase.Instance.returnConnection(conn);
if (messages.Count == 0)
{
log.Warn("No version " + version + " messages found in database " + conn.Database);
}
for (int i = 0; i < messages.Count; i++)
{
make((System.String)messages[i], baseDirectory, (System.String)chapters[i], version);
}
}
}
/// <summary> Returns the description matching the table and value given. As currently implemented
/// this method performs a database call each time - caching should probably be added,
/// although this method will probably not be used very often.
/// </summary>
public override System.String getDescription(int table, System.String value_Renamed)
{
System.String description = null;
System.Text.StringBuilder sql = new System.Text.StringBuilder("select Description from TableValues where table_id = ");
sql.Append(table);
sql.Append(" and table_value = '");
sql.Append(value_Renamed);
sql.Append("'");
try
{
System.Data.OleDb.OleDbConnection conn = NuGenNormativeDatabase.Instance.Connection;
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();
if (rs.Read())
{
description = System.Convert.ToString(rs[1 - 1]);
}
else
{
throw new NuGenUnknownValueException("The value " + value_Renamed + " could not be found in the table " + table + " - SQL: " + sql.ToString());
}
NuGenNormativeDatabase.Instance.returnConnection(conn);
}
catch (System.Data.OleDb.OleDbException e)
{
throw new NuGenLookupException("Can't find value " + value_Renamed + " in table " + table, e);
}
return(description);
}
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); }
}
//------------------------------------------------------------------
// Retrieve data values from database and put them in an array list
// of objects, and return it. This is used when executing a SELECT
// query
//------------------------------------------------------------------
public List <Object> getValues(string queryString)
{
List <Object> results = new List <Object>();
configureConnection();
using (conn)
{
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(queryString, conn);
try
{
conn.Open();
System.Data.OleDb.OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Object[] nextRow = new Object[reader.FieldCount];
reader.GetValues(nextRow);
results.Add(nextRow);
}
return(results);
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
return(null);
}
}
}
private void updateSpeciesFromTreeTable()
{
fieldSpcd.Clear();
using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(dbLc))
{
con.Open();
string sql = "SELECT DISTINCT PLT_CN, SPCD FROM TREE WHERE DIA >= 5 and SPCD > 0";
if (lt5)
{
sql = "SELECT DISTINCT PLT_CN, SPCD FROM TREE WHERE SPCD > 0";
}
System.Data.OleDb.OleDbCommand oleCom = new System.Data.OleDb.OleDbCommand(sql, con);
System.Data.OleDb.OleDbDataReader oleRd = oleCom.ExecuteReader();
while (oleRd.Read())
{
object[] vls = new object[2];
oleRd.GetValues(vls);
string pcn = vls[0].ToString().ToUpper();
if (fieldPltCn.Contains(pcn))
{
string spcd = vls[1].ToString();
fieldSpcd.Add(spcd);
}
}
oleRd.Close();
if (seedlings)
{
sql = "SELECT DISTINCT PLT_CN, SPCD FROM SEEDLING";
oleCom.CommandText = sql;
oleRd = oleCom.ExecuteReader();
while (oleRd.Read())
{
object[] vls = new object[2];
oleRd.GetValues(vls);
string pcn = vls[0].ToString().ToUpper();
if (fieldPltCn.Contains(pcn))
{
string spcd = vls[1].ToString();
fieldSpcd.Add(spcd);
}
}
}
con.Close();
}
populateSpeciesList();
populateDataTable();
}
/// <summary>
/// <p>Creates skeletal source code (without correct data structure but no business logic) for
/// all segments found in the normative database. </p>
/// </summary>
///
/// <param name="baseDirectory"> Pathname of the base directory. </param>
/// <param name="version"> The version. </param>
public static void makeAll(System.String baseDirectory, System.String version)
{
//make base directory
if (!(baseDirectory.EndsWith("\\") || baseDirectory.EndsWith("/")))
{
baseDirectory = baseDirectory + "/";
}
System.IO.FileInfo targetDir =
SourceGenerator.makeDirectory(baseDirectory + PackageManager.GetVersionPackagePath(version) + "Segment");
//get list of data types
System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection;
System.String sql =
"SELECT seg_code, [section] from HL7Segments, HL7Versions where HL7Segments.version_id = HL7Versions.version_id AND hl7_version = '"
+ version + "'";
System.Data.OleDb.OleDbCommand temp_OleDbCommand = new System.Data.OleDb.OleDbCommand();
temp_OleDbCommand.Connection = conn;
temp_OleDbCommand.CommandText = sql;
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
System.Collections.ArrayList segments = new System.Collections.ArrayList();
while (rs.Read())
{
System.String segName = System.Convert.ToString(rs[1 - 1]);
if (System.Char.IsLetter(segName[0]))
{
segments.Add(altSegName(segName));
}
}
temp_OleDbCommand.Dispose();
NormativeDatabase.Instance.returnConnection(conn);
if (segments.Count == 0)
{
log.Warn("No version " + version + " segments found in database " + conn.Database);
}
for (int i = 0; i < segments.Count; i++)
{
try
{
System.String seg = (System.String)segments[i];
System.String source = makeSegment(seg, version);
using (
System.IO.StreamWriter w =
new System.IO.StreamWriter(targetDir + @"\" + GetSpecialFilename(seg) + ".cs"))
{
w.Write(source);
w.Write("}");
}
}
catch (System.Exception e)
{
System.Console.Error.WriteLine("Error creating source code for all segments: " + e.Message);
SupportClass.WriteStackTrace(e, Console.Error);
}
}
}
/// <summary>
/// Returns a list of the values for the given table in the normative database.
/// </summary>
///
/// <exception cref="LookupException"> Thrown when a Lookup error condition occurs. </exception>
/// <exception cref="UndefinedTableException"> Thrown when an Undefined Table error condition
/// occurs. </exception>
///
/// <param name="table"> The table. </param>
///
/// <returns> An array of string. </returns>
public override System.String[] getValues(int table)
{
System.Int32 key = table;
System.String[] values = null;
//see if the value list exists in the cache
System.Object o = this.tables[key];
if (o != null)
{
values = (System.String[])o;
}
else
{
//not cached yet ...
int c;
System.String[] roomyValues = new System.String[this.bufferSize];
try
{
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("select table_value from TableValues where table_id = ");
sql.Append(table);
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText = sql.ToString();
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
c = 0;
while (rs.Read())
{
roomyValues[c++] = System.Convert.ToString(rs[1 - 1]);
}
stmt.Dispose();
NormativeDatabase.Instance.returnConnection(conn);
}
catch (System.Data.OleDb.OleDbException sqle)
{
throw new LookupException("Couldn't look up values for table " + table + ": " + sqle.Message);
}
if (c == 0)
{
throw new UndefinedTableException("No values found for table " + table);
}
values = new System.String[c];
Array.Copy(roomyValues, 0, values, 0, c);
this.tables[key] = values;
}
return(values);
}
/// <summary> <p>Creates skeletal source code (without correct data structure but no business
/// logic) for all segments found in the normative database. </p>
/// </summary>
public static void makeAll(System.String baseDirectory, System.String version)
{
//make base directory
if (!(baseDirectory.EndsWith("\\") || baseDirectory.EndsWith("/")))
{
baseDirectory = baseDirectory + "/";
}
System.IO.FileInfo targetDir = NuGenSourceGenerator.makeDirectory(baseDirectory + NuGenSourceGenerator.getVersionPackagePath(version) + "segment");
//get list of data types
System.Data.OleDb.OleDbConnection conn = NuGenNormativeDatabase.Instance.Connection;
System.Data.OleDb.OleDbCommand stmt = SupportClass.TransactionManager.manager.CreateStatement(conn);
System.String sql = "SELECT seg_code, section from HL7Segments, HL7Versions where HL7Segments.version_id = HL7Versions.version_id AND hl7_version = '" + version + "'";
//System.out.println(sql);
System.Data.OleDb.OleDbCommand temp_OleDbCommand;
temp_OleDbCommand = stmt;
temp_OleDbCommand.CommandText = sql;
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
System.Collections.ArrayList segments = new System.Collections.ArrayList();
while (rs.Read())
{
System.String segName = System.Convert.ToString(rs[1 - 1]);
if (System.Char.IsLetter(segName[0]))
{
segments.Add(altSegName(segName));
}
}
NuGenNormativeDatabase.Instance.returnConnection(conn);
if (segments.Count == 0)
{
}
for (int i = 0; i < segments.Count; i++)
{
try
{
System.String seg = (System.String)segments[i];
System.String source = makeSegment(seg, version);
System.IO.StreamWriter w = new System.IO.StreamWriter(new System.IO.StreamWriter(targetDir.ToString() + "/" + seg + ".java", false, System.Text.Encoding.Default).BaseStream, new System.IO.StreamWriter(targetDir.ToString() + "/" + seg + ".java", false, System.Text.Encoding.Default).Encoding);
w.Write(source);
w.Flush();
w.Close();
}
catch (System.Exception e)
{
System.Console.Error.WriteLine("Error creating source code for all segments: " + e.Message);
SupportClass.WriteStackTrace(e, Console.Error);
}
}
}
/*
* selectAccount selects the account from the database using the current object accountnumber
*/
public void selectAccount()
{
String query = "SELECT * FROM Accounts WHERE AcctNo = '" + AccountNumber + "'";
dr = db.SelectCommand(query);
dr.Read();
accountNumber = AccountNumber;
CustomerID = (dr.GetValue(1) + "");
Type = (dr.GetValue(2) + "");
Balance = (Double.Parse(dr.GetValue(3) + ""));
db.DBClose();
}
/// <summary>
/// 查询协议标识字典
/// </summary>
/// <param name="sql">查询语句</param>
/// <param name="AccessPath">Access数据库路径</param>
/// <param name="Ip">服务器数据库Ip地址</param>
/// <param name="UserName">服务器登录名</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
private DgnProtocolInfo GetProDLT645Dict(string sql, string AccessPath, string Ip, string UserName, string pwd)
{
DgnProtocolInfo Items = new DgnProtocolInfo();
bool flag = false;
if (Ip != "")
{
flag = ConnectDataBase("", Ip, UserName, pwd);
}
else if (AccessPath != "")
{
flag = ConnectDataBase(AccessPath, "", "", "");
}
else
{
flag = ConnectDataBase("", "", "", "");
}
try
{
if (!flag)
{
return(Items);
}
System.Data.OleDb.OleDbCommand Cmd = new System.Data.OleDb.OleDbCommand(sql, _Data.Con);
System.Data.OleDb.OleDbDataReader Reader = Cmd.ExecuteReader();
while (Reader.Read())
{
Items.Pd_dltID = Convert.ToInt32(Reader["dltID"].ToString()); //编号
Items.Pd_proNameNo = Convert.ToInt32(Reader["proNameNo"].ToString()); //国标协议代号
Items.Pd_intIdentType = Convert.ToInt32(Reader["intIdentType"].ToString()); //数据标识编码类型
Items.Pd_intClass = Convert.ToInt32(Reader["intClass"].ToString()); //权限
Items.Pd_chrItemName = Reader["chrItemName"].ToString(); //项目名称
Items.Pd_chrID = Reader["chrID"].ToString(); //数据标识
Items.Pd_intLength = Convert.ToInt32(Reader["intLength"].ToString()); //长度
Items.Pd_intDot = Convert.ToInt32(Reader["intDot"].ToString()); //小数位
Items.Pd_chrFormat = Reader["chrFormat"].ToString(); //格式串
Items.Pd_intType = Convert.ToInt32(Reader["intType"].ToString()); //操作方式
Items.Pd_chrDefValue = Reader["chrDefValue"].ToString(); //定义值
}
Reader.Close();
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message, "数据库操作错误", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
finally
{
_Data.CloseDB();
}
return(Items);
}
private void createAndFillRegenRef()
{
using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(dbLc))
{
con.Open();
//Console.WriteLine("opened the database");
string sql = "SELECT PLT_CN, SUBP, SPCD, TREECOUNT FROM SEEDLING";
System.Data.OleDb.OleDbCommand oleCom = new System.Data.OleDb.OleDbCommand(sql, con);
System.Data.OleDb.OleDbDataReader oleRd = oleCom.ExecuteReader();
while (oleRd.Read())
{
object[] vls = new object[4];
oleRd.GetValues(vls);
string pltCn = vls[0].ToString();
string subp = vls[1].ToString();
if (SubPlotField == "" || SubPlotField == null)
{
subp = "0";
}
string linkVl = pltCn + "_" + subp;
//Console.WriteLine("Link = " + linkVl.ToString());
if (unPlots.Contains(linkVl))
{
string spcd = vls[2].ToString();
string stcd = "1";
string grpCd = spcd;
if (groupstatuscode)
{
grpCd = spcd + "_" + stcd;
}
if (grp)
{
spcd = findGrp(grpCd);
}
rUnSp.Add(spcd);
int tCnt = System.Convert.ToInt32(vls[3]);
string lk = linkVl + "_" + spcd.ToString();
int vlOut;
if (rgDic.TryGetValue(lk, out vlOut))
{
rgDic[lk] = vlOut + tCnt;
}
else
{
rgDic.Add(lk, tCnt);
}
}
}
oleRd.Close();
con.Close();
}
}
private double sotien()
{
double kq = 0;
string sql = "Select sotien/soluong as tien From dmthu where tenkhoanthu = 'Tiền ăn'";
System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr(sql);
while (dr.Read())
{
kq = classdc.dungchung.kieudouble(dr["tien"].ToString());
}
dr.Close();
return(kq);
}
public string GetID()
{
string id_movimientos = null;
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT TOP 1 id_movimientos FROM Movimientos ORDER BY id_movimientos DESC");
while (reader.Read())
{
id_movimientos = reader["id_movimientos"].ToString();
}
database.Close_Database();
return(id_movimientos);
}
private string ho(string mshs)
{
string kq = "";
sql = "Select tenhs From hocsinh where mshs = '" + mshs + "'";
System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr(sql);
while (dr.Read())
{
kq = dr["tenhs"].ToString().Substring(0, dr["tenhs"].ToString().LastIndexOf(" "));
}
dr.Close();
return(kq);
}
public List <OpstiDomenskiObjekat> VratiListu(System.Data.OleDb.OleDbDataReader citac)
{
List <OpstiDomenskiObjekat> proizvodjaci = new List <OpstiDomenskiObjekat>();
while (citac.Read())
{
Proizvodjac p = new Proizvodjac();
p.prozvodjacID = citac.GetString(0);
p.Naziv = citac.GetString(1);
proizvodjaci.Add(p);
}
return(proizvodjaci);
}
static int SilentlyReadAllRows(System.Data.OleDb.OleDbDataReader reader)
{
int rowCount = 0;
while (reader.Read())
{
++rowCount;
object[] values = new object[reader.FieldCount];
reader.GetValues(values);
}
return(rowCount);
}
/*
* countCustomers searchs database and makes a count of Customers for new id identification
* @returns int
*/
public int countCustomers()
{
String query = "SELECT * FROM Customers";
int count = 0;
dr = db.SelectCommand(query);
while (dr.Read())
{
count++;
}
db.DBClose();
return(count);
}
public bool SelectProductoExiste(Producto producto)
{
bool exist = false;
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT * FROM Productos WHERE codigo = '" + producto.Codigo + "' AND estado = 'E'");
while (reader.Read())
{
exist = true;
}
database.Close_Database();
return(exist);
}
public bool SelectPersonaExiste(Persona persona) //Valida si existe una persona el mismo RUT.
{
bool exist = false;
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT * FROM Personas WHERE rut = '" + persona.Rut + "' AND estado = 'E'");
while (reader.Read())
{
exist = true;
}
database.Close_Database();
return(exist);
}
/*
* uses the db object to query the db and select the customer info based on customerid
*/
public void selectCustomer()
{
String query = "SELECT * FROM Customers WHERE CustID = '" + CustomerID + "'";
dr = db.SelectCommand(query);
dr.Read();
customerID = CustomerID;
Password = (dr.GetValue(1) + "");
FirstName = (dr.GetValue(2) + "");
LastName = (dr.GetValue(3) + "");
Address = (dr.GetValue(4) + "");
Email = (dr.GetValue(5) + "");
db.DBClose();
}
private void xoa()
{
try
{
if (rbtnDT.Checked == true)
{
if (MessageBox.Show("Bạn có muốn xóa khoản thu của học sinh này không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
cmd.CommandText = "Delete * From thutien Where mshs = '" + grvKQ.GetFocusedRowCellValue(colmshs).ToString() + "'" +
" and thang = " + classdc.dungchung.kieudouble(cboThang.Text);
KPBT.Modules.Connect.LuuDL(cmd);
grcKT.DataSource = null;
}
}
if (rbtnLop.Checked == true)
{
if (cbtenphongb.Text == "")
{
MessageBox.Show("Bạn chưa chọn phòng trước khi xóa. Bạn hãy thoát ra và chọn phòng cần xóa trước!", "Thông báo");
}
else
{
if (MessageBox.Show("Bạn có muốn xóa khoản thu của " + cbtenphongb.Text + " này không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr("Select mshs From hocsinh where tenphong = '" + cbtenphongb.Text + "'");
while (dr.Read())
{
cmd.CommandText = "Delete * From thutien Where mshs = '" + dr["mshs"].ToString() + "'" +
" and thang = " + classdc.dungchung.kieudouble(cboThang.Text);
KPBT.Modules.Connect.LuuDL(cmd);
}
grcKT.DataSource = null;
}
}
}
if (rbtnTruong.Checked == true)
{
if (MessageBox.Show("Bạn có muốn xóa khoản thu của học sinh tháng " + cboThang.Text + " này không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
cmd.CommandText = "Delete * From thutien Where thang = " + classdc.dungchung.kieudouble(cboThang.Text);
KPBT.Modules.Connect.LuuDL(cmd);
grcKT.DataSource = null;
}
}
}
catch { }
}
public byte[] GetLargeField(string strSql)
{
//string block="SELECT image from test_image WHERE id = 100";//INTO :b
this.command.Connection = this.Conn as System.Data.OleDb.OleDbConnection;
this.command.Transaction = Mder.FC.DB.DBTrans.Trans as System.Data.OleDb.OleDbTransaction;
command.CommandText = strSql + "";
command.CommandType = System.Data.CommandType.Text;
System.Data.OleDb.OleDbDataReader reader;
command.Parameters.Clear();
try
{
reader = command.ExecuteReader();
}
catch (System.Data.OleDb.OleDbException ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = ex.ErrorCode;
this.WriteErr();
return null;
}
catch (Exception ex)
{
this.Err = ex.Message;
this.WriteErr();
return null;
}
reader.Read();
byte[] byteData = new byte[0];
try
{
byteData = (byte[])(reader[0]);
}
catch (Exception ex)
{
this.Err = ex.Message;
reader.Close();
return null;
}
reader.Close();
return byteData;
}
