/// <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);
}
}
}
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 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();
}
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();
}
}
/// <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);
}
}
}
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);
}
/// <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);
}
}
}
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();
}
}
/// <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 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);
}
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 string getEmail()
//{
// return loggedEmail;
//}
internal bool Login(string email, string password)
{
System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand();
comm.CommandType = System.Data.CommandType.Text;
comm.CommandText = "SELECT [Email], [Password] FROM USERS\nWHERE [Email] = \'" + email + "\' AND [Password] = \'" + password + "\';";
comm.Connection = conn;
conn.Open();
System.Data.OleDb.OleDbDataReader result = null;
try
{
//comm.Connection.Open();
result = comm.ExecuteReader();
//MessageBox.Show((string)returnValue);
}
catch (Exception e)
{
conn.Close();
MessageBox.Show(e.Message);
}
//MessageBox.Show("Reader:" + result.ToString()+"\n"+result[0]);
if (result.HasRows)
{
//LOG THE F**K IN
conn.Close();
result.Close();
loggedEmail = email;
return(true);
}
else
{
MessageBox.Show("Email and/or password are invalid ¯\\_(ツ)_/¯");
}
conn.Close();
result.Close();
return(false);
//throw new NotImplementedException();
}
private string kt(string ngaydanhgia, string lop)
{
string kq = "";
string sql = "Select theodoisk.ngaydanhgia,hocsinh.tenphong" +
" From theodoisk inner join hocsinh on theodoisk.mahocsinh = hocsinh.mshs" +
" where theodoisk.ngaydanhgia = #" + classdc.dungchung.thaydoi(ngaydanhgia) + "# and hocsinh.tenphong = '" + lop + "'";
System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr(sql);
while (dr.Read())
{
kq = "C";
}
dr.Close();
return(kq);
}
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();
}
private void pmCal1()
{
//conn = new System.Data.OleDb.OleDbConnection(App.ConnectionString);
//conn2 = new System.Data.OleDb.OleDbConnection(App.ConnectionString);
//conn.Open();
//conn2.Open();
//pmCal1();
//conn.Close();
//conn2.Close();
//conn.Dispose();
//conn2.Dispose();
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("select * from EMPROJ where CCORP = ? and CTYPE = 'G' and CCODE between ? and ? and CPRPROJ = '' ", conn);
cmd.Parameters.AddWithValue("@P1", App.ActiveCorp.RowID);
cmd.Parameters.AddWithValue("@P2", this.txtBegQcProj1.Text.Trim());
cmd.Parameters.AddWithValue("@P3", this.txtEndQcProj1.Text.Trim());
System.Data.OleDb.OleDbCommand cmd2 = new System.Data.OleDb.OleDbCommand("select * from EMPROJ where CPRPROJ = ? ", conn);
cmd2.Parameters.AddWithValue("@P1", "");
System.Data.OleDb.OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DataRow dtrPLine = this.dtsDataEnv.Tables[this.mstrTemBg].NewRow();
dtrPLine["cQcProj"] = dr["cCode"].ToString().TrimEnd();
dtrPLine["cQnProj"] = dr["cName"].ToString().TrimEnd();
this.dtsDataEnv.Tables[this.mstrTemBg].Rows.Add(dtrPLine);
//cmd2.Parameters.Clear();
cmd2.Parameters["@P1"].Value = dr["cRowID"].ToString();
System.Data.OleDb.OleDbDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
DataRow dtrPLine2 = this.dtsDataEnv.Tables[this.mstrTemBg].NewRow();
dtrPLine2["cQcProj"] = dr2["cCode"].ToString().TrimEnd();
dtrPLine2["cQnProj"] = dr2["cName"].ToString().TrimEnd();
this.dtsDataEnv.Tables[this.mstrTemBg].Rows.Add(dtrPLine2);
}
dr2.Close();
}
dr.Close();
cmd2.Dispose();
cmd.Dispose();
}
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>
/// 查询通讯协议
/// </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 GetProtocolInfo(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.Pro_ProtocolID = Convert.ToInt32(Reader["ProtocolID"].ToString()); //协议编号
Items.Pro_proNameNo = Convert.ToInt32(Reader["proNameNo"].ToString()); //通讯协议归属
Items.Pro_chrPname = Reader["chrPname"].ToString(); //协议名称
Items.Pro_intInfoNo = Convert.ToInt32(Reader["intInfoNo"].ToString()); //信息序号
Items.Pro_chrValue = Reader["chrValue"].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 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>
/// xls文件转数据表
/// </summary>
/// <param name="fileName">文件名</param>
/// <returns></returns>
public static System.Data.DataTable XlsToData(string fileName)
{
string fileExtenSion;
fileExtenSion = System.IO.Path.GetExtension(fileName);
if (fileExtenSion.ToLower() != ".xls" && fileExtenSion.ToLower() != ".xlsx")
{
return null;
}
System.Data.OleDb.OleDbConnection conn = null;
try
{
//HDR=Yes，这代表第一行是标题，不做为数据使用 ，如果用HDR=NO，则表示第一行不是标题，做为数据来使用。系统默认的是YES
string connstr2003 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'";
string connstr2007 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
if (fileExtenSion.ToLower() == ".xls")
{
conn = new System.Data.OleDb.OleDbConnection(connstr2003);
}
else
{
conn = new System.Data.OleDb.OleDbConnection(connstr2007);
}
conn.Open();
string sql = "select * from [Sheet1$]";
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sql, conn);
System.Data.DataTable dt = new System.Data.DataTable();
System.Data.OleDb.OleDbDataReader sdr = cmd.ExecuteReader();
dt.Load(sdr);
sdr.Close();
conn.Close();
return dt;
}
catch
{
return null;
}
finally
{
if (conn != null)
conn.Close();
}
}
private void ReportFooter_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e)
{
double kq = 0;
System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr("Select distinct TEN1 From TblDC");
if (dr != null)
{
while (dr.Read())
{
kq += 1;
}
dr.Close();
}
if (kq == 1)
{
xrTblTC.Visible = false;
}
}
public override void Render(Pink.Request req, object o)
{
req.WriteString("<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<meta charset=\"UTF-8\">\r\n<title>Blog Index</title" +
">\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/style.css\">\r\n</head>\r\n<body" +
">\r\n<img src=\"/img/pinkserver.png\" style=\"text-align: center;\">\r\n<h1>Pink Server " +
"Blog</h1>\r\n<i>");
req.WriteString(string.Format("{0}", DateTime.Now));
req.WriteString("</i>\r\n<p>This the front page of the Pink Blog.</p>\r\n<table>\r\n");
System.Data.OleDb.OleDbDataReader reader = Blog.DB.Query("SELECT ID, Title, Author, Date FROM Pages;", 10);;
req.WriteString("\r\n<tr>\r\n ");
for (int i = 0; i < reader.FieldCount; i++)
{
;
req.WriteString(" \r\n <th> ");
req.WriteString(string.Format("{0}", reader.GetName(i)));
req.WriteString(" </th>\r\n ");
}
;
req.WriteString("\r\n <th>link</th>\r\n</tr>\r\n");
while (reader.Read())
{
;
req.WriteString("\r\n<tr>\r\n ");
for (int i = 0; i < reader.FieldCount; i++)
{
;
req.WriteString("\r\n <td> ");
req.WriteString(string.Format("{0}", reader[i]));
req.WriteString(" </td>\r\n ");
}
;
req.WriteString("\r\n <td><a href=\"/article/");
req.WriteString(string.Format("{0}", reader[0]));
req.WriteString("\">");
req.WriteString(string.Format("{0}", reader[1]));
req.WriteString("</a></td>\r\n</tr>\r\n");
}
reader.Close();;
req.WriteString("\r\n</table>\r\n<p><a href=\"/editor/-1\">new article</a></p>\r\n<p>");
req.WriteString(string.Format("{0}", req.Method));
req.WriteString("</p>\r\n<p>");
req.WriteString(string.Format("{0}", req.URL));
req.WriteString("</p>\r\n</body>\r\n</html>");
}
protected void ReadRPatternExceptions(CalendarRecurrencePattern pPattern,
System.Data.OleDb.OleDbConnection pOleDbConn)
{
if (pPattern == null || pOleDbConn == null)
{
System.Diagnostics.Debug.Assert(false);
return;
}
System.Data.OleDb.OleDbDataReader oleReader = null;
try
{
int nPatternID = pPattern.Id;
String strSQL = "SELECT * FROM CalendarEvents WHERE \r\n";
strSQL += " RecurrenceState = " + Convert.ToString((int)CalendarEventRecurrenceState.xtpCalendarRecurrenceException);
strSQL += " AND RecurrencePatternID = " + Convert.ToString(nPatternID);
System.Data.OleDb.OleDbCommand oleDbCommand = pOleDbConn.CreateCommand();
oleDbCommand.CommandText = strSQL;
oleReader = oleDbCommand.ExecuteReader();
while (oleReader.Read())
{
CalendarEvent axEvent = _CreateEventFromData(oleReader, true);
if (axEvent != null)
{
pPattern.SetException(axEvent);
}
}
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.WriteLine("EXCEPTION! SQLDataHelper.ReadRPatternExceptions: " + ex.Message);
}
//================================================
if (oleReader != null && !oleReader.IsClosed)
{
oleReader.Close();
}
}
/// <summary> Get an InputStream so that the Runtime can build a
/// template with it.
/// *
/// </summary>
/// <param name="name">name of template
/// </param>
/// <returns>InputStream containing template
///
/// </returns>
//UPGRADE_NOTE: Synchronized keyword was removed from method 'getResourceStream'. Lock expression was added. 'ms-help://MS.VSCC/commoner/redir/redirect.htm?keyword="jlca1027"'
public override System.IO.Stream getResourceStream(System.String name)
{
lock (this) {
if (name == null || name.Length == 0)
{
throw new ResourceNotFoundException("Need to specify a template 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, templateColumn, name);
try {
if (rs.Read())
{
//UPGRADE_ISSUE: Method 'java.sql.ResultSet.getAsciiStream' was not converted. 'ms-help://MS.VSCC/commoner/redir/redirect.htm?keyword="jlca1000_javasqlResultSetgetAsciiStream_javalangString"'
return(new System.IO.BufferedStream(rs.getAsciiStream(templateColumn)));
}
else
{
System.String msg = "DataSourceResourceLoader Error: cannot find resource " + name;
System.Diagnostics.Process.error(msg);
throw new ResourceNotFoundException(msg);
}
} finally {
rs.Close();
}
} finally {
closeDbConnection(conn);
}
} catch (System.Exception e) {
System.String msg = "DataSourceResourceLoader Error: database problem trying to load resource " + name + ": " + e.ToString();
System.Diagnostics.Process.error(msg);
throw new ResourceNotFoundException(msg);
}
}
}
private void populateSpeciesDictionary()
{
int pltCnt = fieldPltCn.Count;
using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(dbLc))
{
con.Open();
string sql = "SELECT SPCD, COMMON_NAME FROM REF_SPECIES ORDER BY SPCD";
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 jVl = vls[0].ToString() + " | " + vls[1].ToString();
spDic.Add(vls[0].ToString(), vls[1].ToString());
//lstSpecies.Items.Add(jVl);
}
oleRd.Close();
con.Close();
}
}
private string[] getStatusCodes()
{
HashSet <string> statusCodeHash = new HashSet <string>();
using (System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(dbLc))
{
con.Open();
string sql = "SELECT DISTINCT STATUSCD FROM TREE";
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[1];
oleRd.GetValues(vls);
string spcd = vls[0].ToString();
statusCodeHash.Add(spcd);
}
oleRd.Close();
con.Close();
}
return(statusCodeHash.ToArray());
}
/// <summary>
/// Queries the normative database for a list of segments comprising the message structure. The
/// returned list may also contain strings that denote repetition and optionality. Choice
/// indicators (i.e. begin choice, next choice, end choice) for alternative segments are ignored,
/// so that the class structure allows all choices. The matter of enforcing that only a single
/// choice is populated can't be handled by the class structure, and should be handled elsewhere.
/// </summary>
///
/// <param name="message"> The message. </param>
/// <param name="version"> The version. </param>
///
/// <returns> An array of segment definition. </returns>
private static SegmentDef[] getSegments(System.String message, System.String version)
{
/*String sql = "select HL7Segments.seg_code, repetitional, optional, description " +
* "from (HL7MsgStructIDSegments inner join HL7Segments on HL7MsgStructIDSegments.seg_code = HL7Segments.seg_code " +
* "and HL7MsgStructIDSegments.version_id = HL7Segments.version_id) " +
* "where HL7Segments.version_id = 6 and message_structure = '" + message + "' order by seq_no";*/
System.String sql = getSegmentListQuery(message, version);
//System.out.println(sql.toString());
SegmentDef[] segments = new SegmentDef[200]; //presumably there won't be more than 200
using (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 = sql;
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
int c = -1;
while (rs.Read())
{
System.String name = SegmentGenerator.altSegName(System.Convert.ToString(rs[1 - 1]));
bool repeating = rs.GetBoolean(2 - 1);
bool optional = rs.GetBoolean(3 - 1);
System.String desc = System.Convert.ToString(rs[4 - 1]);
System.String groupName = System.Convert.ToString(rs[6 - 1]);
//ignore the "choice" directives ... the message class structure has to include all choices ...
// if this is enforced (i.e. exception thrown if >1 choice populated) this will have to be done separately.
if (!(name.Equals("<") || name.Equals("|") || name.Equals(">")))
{
c++;
segments[c] = new SegmentDef(name, groupName, !optional, repeating, desc);
}
}
rs.Close();
SegmentDef[] ret = new SegmentDef[c + 1];
Array.Copy(segments, 0, ret, 0, c + 1);
return(ret);
}
}
protected IList <movimento> Read(int anno)
{
string query = "SELECT * from " + _tableName + " where anno = " + anno.ToString();
System.Data.OleDb.OleDbConnection c = new System.Data.OleDb.OleDbConnection(_connStringAccessDB);
c.Open();
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, c);
System.Data.OleDb.OleDbDataReader r = cmd.ExecuteReader();
IList <movimento> movimenti = new List <movimento>();
while (r.Read())
{
DoLoadMovimenti(r, movimenti);
}
r.Close();
c.Close();
return(movimenti);
}
private string laydanhgia(string cannang, string gioitinh, string thangtuoi, string chieucao)
{
string kq = "";
System.Data.OleDb.OleDbDataReader dr = KPBT.Modules.Connect.TruyVandr("Select * From tblBMI ");
while (dr.Read())
{
if (gioitinh == dr["gioitinh"].ToString())
{
if (double.Parse(thangtuoi) == double.Parse(dr["thang"].ToString()))
{
if (BMI(cannang, chieucao) <= double.Parse(dr["SD3duoi"].ToString()))
{
kq = "Rất gầy";
}
if (BMI(cannang, chieucao) <= double.Parse(dr["SD2duoi"].ToString()) && BMI(cannang, chieucao) > double.Parse(dr["SD3duoi"].ToString()))
{
kq = "Gầy";
}
if (BMI(cannang, chieucao) < double.Parse(dr["SD1tren"].ToString()) && BMI(cannang, chieucao) > double.Parse(dr["SD2duoi"].ToString()))
{
kq = "Bình thường";
}
if (BMI(cannang, chieucao) < double.Parse(dr["SD2tren"].ToString()) && BMI(cannang, chieucao) >= double.Parse(dr["SD1tren"].ToString()))
{
kq = "Thừa cân";
}
if (BMI(cannang, chieucao) >= double.Parse(dr["SD2tren"].ToString()))
{
kq = "Béo phì";
}
}
}
}
dr.Close();
return(kq);
}
//==================================================================
private void m_axCalendar_DoRetrieveDayEvents(object sender, AxXtremeCalendarControl._DCalendarControlEvents_DoRetrieveDayEventsEvent e)
{
if (!IsOpen())
{
return;
}
System.Data.OleDb.OleDbDataReader oleReader = null;
try
{
System.Data.OleDb.OleDbCommand oleDbCommand = m_oleDbConnection.CreateCommand();
oleDbCommand.CommandText = m_DataHelper.MakeRetrieveDayEventsSQL(e.dtDay);
oleReader = oleDbCommand.ExecuteReader();
while (oleReader.Read())
{
CalendarEvent axEvent = m_DataHelper.CreateEventFromData(oleReader);
if (axEvent != null)
{
e.events.Add(axEvent);
}
}
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.WriteLine("EXCEPTION! providerSQLServer.m_axCalendar_DoRetrieveDayEvents: " + ex.Message);
}
//================================================
if (oleReader != null && !oleReader.IsClosed)
{
oleReader.Close();
}
}
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;
}
