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();
}
public static IList <string> ReadExcel()
{
IList <RvtRoom> rooms = new List <RvtRoom>();
IList <string> types = new List <string>();
// Connection string
string connectionString =
ConfigurationManager.ConnectionStrings["excel"].ConnectionString;
// Select using a Named range
//string selectString = "SELECT * FROM Cutomers";
// Select using a worksheet name
//string selectStringSheet = "SELECT * FROM [Sheet1$]";
using (System.Data.OleDb.OleDbConnection connection
= new System.Data.OleDb.OleDbConnection(connectionString)) {
connection.Open();
string sheetName =
connection.GetOleDbSchemaTable
(System.Data.OleDb.OleDbSchemaGuid.Tables, null).Rows[0]["TABLE_NAME"] as string;
string selectString = "SELECT mcRm_SubZone FROM [ZONE_1$]";
System.Data.OleDb.OleDbCommand myCommand =
new System.Data.OleDb.OleDbCommand(selectString, connection);
using (System.Data.OleDb.OleDbDataReader reader =
myCommand.ExecuteReader()) {
try {
while (reader.Read())
{
//Room room = new Room(reader.GetString(0), reader.GetString(4),
//reader.GetString(6), reader.GetString(8), reader.GetString(14), reader.GetString(21));
//rooms.Add(room);
types.Add(reader.GetString(0));
}
}
catch (Exception ex) {
Trace.Write(string.Format("{0}\n{1}", ex.Message, ex.StackTrace));
}
}
}
//return rooms;
return(types);
}
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>
/// 查询通讯协议
/// </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);
}
public Persona GetPersonaRUT(string rut) //Obtiene una persona con un RUT.
{
Persona persona = new Persona();
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT * FROM Personas WHERE rut = '" + rut + "'");
while (reader.Read())
{
persona.Id_personas = Convert.ToInt32(reader["id_personas"].ToString());
persona.Rut = reader["rut"].ToString();
persona.First_name = reader["first_name"].ToString();
persona.Last_name = reader["last_name"].ToString();
persona.Tipo = Convert.ToChar(reader["tipo"].ToString());
}
database.Close_Database();
return(persona);
}
public Movimiento GetMovimiento(string id_movimientos)
{
Movimiento movimiento = new Movimiento();
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT * FROM Movimientos WHERE id_movimientos = " + id_movimientos);
while (reader.Read())
{
movimiento.Id_movimientos = Convert.ToInt32(reader["id_movimientos"].ToString());
movimiento.Factura = Convert.ToInt32(reader["factura"].ToString());
movimiento.Fecha = Convert.ToDateTime(reader["fecha"].ToString());
movimiento.Dinero = Convert.ToSingle(reader["dinero"].ToString());
movimiento.Id_personas = Convert.ToInt32(reader["id_personas"].ToString());
}
database.Close_Database();
return(movimiento);
}
/// <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();
}
}
public List <OpstiDomenskiObjekat> VratiListu(System.Data.OleDb.OleDbDataReader citac)
{
List <OpstiDomenskiObjekat> rentiranja = new List <OpstiDomenskiObjekat>();
while (citac.Read())
{
Rentiranje rent = new Rentiranje();
Klijent k = new Klijent();
Automobil a = new Automobil();
Zaposleni zz = new Zaposleni();
Zaposleni zr = new Zaposleni();
rent.rentiranjeID = citac.GetString(0);
a.AutomobilID = citac.GetString(1);
k.KlijentID = citac.GetString(2);
rent.datumZaduzenja = citac.GetDateTime(3);
if (!citac.IsDBNull(4))
{
rent.datumRazduzenja = citac.GetDateTime(4);
}
rent.ukupnaCena = Convert.ToDouble(citac["UkupnaCena"]);
rent.razduzeno = citac.GetBoolean(6);
rent.stornirano = citac.GetBoolean(7);
zz.ZaposleniID = citac.GetString(8);
if (!citac.IsDBNull(9))
{
zr.ZaposleniID = citac.GetString(9);
}
else
{
zr.ZaposleniID = "/";
}
rent.klijent = k;
rent.automobil = a;
rent.zaduzioID = zz;
rent.razduzioID = zr;
rentiranja.Add(rent);
}
return(rentiranja);
}
/*
* findAccounts creates a arraylist of all accounts connected to the current customer id
*/
public void findAccounts()
{
String query = "SELECT * FROM Accounts WHERE Cid = '" + CustomerID + "'";
Account tempAccount;
acctList.emptylist();
dr = db.SelectCommand(query);
while (dr.Read())
{
tempAccount = new Account();
tempAccount.AccountNumber = dr.GetValue(0) + "";
tempAccount.CustomerID = dr.GetValue(1) + "";
tempAccount.Type = dr.GetValue(2) + "";
tempAccount.Balance = Double.Parse(dr.GetValue(3) + "");
acctList.addAccount(tempAccount);
}
db.DBClose();
}
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();
}
}
//Controladores de Productos ---------------------------------------------------
public List <Producto> SelectProducto()
{
List <Producto> producto_list = new List <Producto>();
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT * FROM Productos");
while (reader.Read())
{
Producto producto = new Producto();
producto.Id_productos = Convert.ToInt32(reader["id_productos"].ToString());
producto.Codigo = (reader["codigo"].ToString());
producto.Cantidad = Convert.ToInt32(reader["cantidad"].ToString());
producto.Estado = Convert.ToChar(reader["estado"].ToString());
producto_list.Add(producto);
}
database.Close_Database();
return(producto_list);
}
/// <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);
}
}
}
public List <Producto> SelectMovimientos_Productos(int id_movimientos)
{
List <Producto> movimiento_producto_list = new List <Producto>();
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT * FROM Movimientos_Productos INNER JOIN Productos ON Movimientos_Productos.id_productos = Productos.id_productos WHERE Movimientos_Productos.id_movimientos = " + id_movimientos);
while (reader.Read())
{
Producto producto = new Producto();
producto.Id_productos = Convert.ToInt32(reader["Productos.id_productos"].ToString());
producto.Codigo = (reader["codigo"].ToString());
producto.Cantidad = Convert.ToInt32(reader["Movimientos_Productos.cantidad"].ToString());
producto.Estado = Convert.ToChar(reader["estado"].ToString());
movimiento_producto_list.Add(producto);
}
database.Close_Database();
return(movimiento_producto_list);
}
public Persona GetPersonaID(string id_personas) //Obtiene una persona con un ID.
{
Persona persona = new Persona();
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT * FROM Personas WHERE id_personas = " + id_personas);
while (reader.Read())
{
persona.Id_personas = Convert.ToInt32(reader["id_personas"].ToString());
persona.Rut = reader["rut"].ToString();
persona.First_name = reader["first_name"].ToString();
persona.Last_name = reader["last_name"].ToString();
persona.Tipo = Convert.ToChar(reader["tipo"].ToString());
persona.Correo = reader["correo"].ToString();
persona.Numero_cuenta = reader["numero_cuenta"].ToString();
persona.Banco = reader["banco"].ToString();
}
database.Close_Database();
return(persona);
}
public List <Movimiento> SelectMovimiento()
{
List <Movimiento> movimiento_list = new List <Movimiento>();
Database database = new Database();
System.Data.OleDb.OleDbDataReader reader = database.ReadDB("SELECT * FROM Movimientos ORDER BY id_movimientos ASC");
while (reader.Read())
{
Movimiento movimiento = new Movimiento();
movimiento.Id_movimientos = Convert.ToInt32(reader["id_movimientos"].ToString());
movimiento.Factura = Convert.ToInt32(reader["factura"].ToString());
movimiento.Fecha = Convert.ToDateTime(reader["fecha"].ToString());
movimiento.Dinero = Convert.ToSingle(reader["dinero"].ToString());
movimiento.Id_personas = Convert.ToInt32(reader["id_personas"].ToString());
movimiento_list.Add(movimiento);
}
database.Close_Database();
return(movimiento_list);
}
public System.Data.OleDb.OleDbDataReader SelectByProcedure(string procedureName, System.Data.SqlClient.SqlParameter[] sqlParameter)
{
System.Data.OleDb.OleDbDataReader dr = null;
try
{
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(procedureName, managerDB.OpenApp());
command.CommandType = System.Data.CommandType.StoredProcedure;
for (int i = 0; i < sqlParameter.Length; i++)
{
command.Parameters.Add(sqlParameter[i]);
}
dr = command.ExecuteReader();
}
catch (Exception exception)
{
IAppLog log = (IAppLog)AppLogFactory.LogProduct();
log.writeLog(this.GetType().Name, "执行存储过程" + procedureName + "查询数据出错!" + exception.ToString());
}
return(dr);
}
/// <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
{
//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);
//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();
if (rs.Read())
{
description = System.Convert.ToString(rs[1 - 1]);
}
else
{
throw new UnknownValueException("The value " + value_Renamed + " could not be found in the table " + table + " - SQL: " + sql.ToString());
}
//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);
}
catch (System.Data.OleDb.OleDbException e)
{
throw new LookupException("Can't find value " + value_Renamed + " in table " + table, e);
}
return(description);
}
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());
}
public EspecialZonesDataGrid(EntitiesCollections entitiesCollections) : base(entitiesCollections)
{
InitializeComponent();
string query = null;
string Contract = null;
List <string> listazonas = new List <string>();
query = "SELECT DISTINCT(Nombre) FROM ZonaBasica";
reader = DataBaseManager.ReadData(query);
while (reader.Read())
{
Contract = (reader.GetString(0));
listazonas.Add(Contract);
}
DataBaseManager.DbConnection.Close();
// Contrato.DataContext = lista;
(NameColumn).ItemsSource = listazonas; // Country.GetCountries();
EspecialZonesCollectionViewModel items = ItemsSource as EspecialZonesCollectionViewModel;
if (items.Count == 1)
{
EspecialZoneViewModel item = items[0] as EspecialZoneViewModel;
if (item.Name == null)
{
CurrentColumn = NameColumn;
NameColumn.IsReadOnly = false;
IndiceIniColumn.IsReadOnly = false;
IndiceFinColumn.IsReadOnly = false;
}
}
}
public override void ExecuteQuery(CommerceServer.Foundation.CommerceQueryOperation queryOperation, CommerceServer.Foundation.OperationCacheDictionary operationCache, CommerceServer.Foundation.CommerceQueryOperationResponse response)
{
CommerceModelSearch search = queryOperation.GetSearchCriteria <CommerceModelSearch>();
ParameterChecker.CheckForNull(search, "searchCriteria");
if (!String.IsNullOrEmpty(search.WhereClause))
{
var sqlFormat = " SELECT u_user_id, u_first_name, u_last_name, u_email_address FROM [BEK_Commerce_profiles].[dbo].[UserObject] {0}";
var sql = string.Format(sqlFormat, search.WhereClause.IndexOf("where", StringComparison.CurrentCultureIgnoreCase) >= 0 ? search.WhereClause : "WHERE " + search.WhereClause);
CommerceServer.Core.Runtime.Configuration.CommerceResourceCollection csResources = SiteHelper.GetCsConfig();
String connStr = csResources["Biz Data Service"]["s_BizDataStoreConnectionString"].ToString();
using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connStr))
{
conn.Open();
using (System.Data.OleDb.OleDbCommand cmdRead = new System.Data.OleDb.OleDbCommand(sql, conn))
{
using (System.Data.OleDb.OleDbDataReader dataReader = cmdRead.ExecuteReader())
{
while (dataReader.Read())
{
CommerceEntity org = new CommerceEntity("UserProfile");
org.Id = dataReader.GetString("u_user_id");
org.SetPropertyValue("FirstName", dataReader.GetString("u_first_name"));
org.SetPropertyValue("LastName", dataReader.GetString("u_last_name"));
org.SetPropertyValue("Email", dataReader.GetString("u_email_address"));
response.CommerceEntities.Add(org);
}
}
}
}
}
else
{
base.ExecuteQuery(queryOperation, operationCache, response);
}
}
public void loadResult()
{
int total = 0, pass = 0, obtain = 0;
dataGridView2.Rows.Clear();
richTextBox1.Text = "";
try
{
studentInfo = db.studentInfo(textBox6.Text.ToString());
while (studentInfo.Read())
{
textBox5.Text = studentInfo[1].ToString();
textBox7.Text = studentInfo[2].ToString();
textBox8.Text = studentInfo[3].ToString();
textBox9.Text = studentInfo[4].ToString();
}
result = db.getResult(textBox6.Text, textBox13.Text);
for (int i = 0; i < result.Count; i++)
{
dataGridView2.Rows.Add(result[i][5], result[i][6], result[i][7], result[i][8]);
total += Int32.Parse(result[i][6]);
pass += Int32.Parse(result[i][7]);
obtain += Int32.Parse(result[i][8]);
if (Int32.Parse(result[i][8]) < Int32.Parse(result[i][7]))
{
richTextBox1.Text += "Fail in " + result[i][5] + "\n";
}
}
textBox14.Text = total.ToString();
textBox16.Text = pass.ToString();
textBox15.Text = obtain.ToString();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
/// <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);
}
}
public List <OpstiDomenskiObjekat> VratiListu(System.Data.OleDb.OleDbDataReader citac)
{
List <OpstiDomenskiObjekat> automobili = new List <OpstiDomenskiObjekat>();
while (citac.Read())
{
Automobil a = new Automobil();
Proizvodjac p = new Proizvodjac();
a.automobilID = citac.GetString(0);
a.modelAutomobila = citac.GetString(1);
a.GodinaProizvodnje = Convert.ToInt32(citac["GodinaProizvodnje"]);
a.registarskiBroj = citac.GetString(3);
a.cenaRentiranja = Convert.ToDouble(citac["CenaRentiranja"]);
p.ProzvodjacID = citac.GetString(5);
p.Naziv = citac.GetString(7);
a.proizvodjac = p;
automobili.Add(a);
}
return(automobili);
}
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 void EnumerateDataSourceNames()
{
// Perform the enumeration
DataTable dataTable = new DataTable();
dataTable.Locale = System.Globalization.CultureInfo.InvariantCulture;
try
{
// Use the MSDAORA enumerator
System.Data.OleDb.OleDbDataReader reader = System.Data.OleDb.OleDbEnumerator.GetEnumerator(Type.GetTypeFromCLSID(NativeMethods.CLSID_MSDASQL_ENUMERATOR));
using (reader)
{
dataTable.Load(reader);
}
}
catch
{
}
// Create the object array of data source names (with instances appended)
_dataSourceNames = new object[dataTable.Rows.Count];
for (int i = 0; i < _dataSourceNames.Length; i++)
{
_dataSourceNames[i] = dataTable.Rows[i]["SOURCES_NAME"] as string;
}
// Sort the list
Array.Sort(_dataSourceNames);
// Populate the server combo box items (must occur on the UI thread)
if (Thread.CurrentThread == _uiThread)
{
PopulateDataSourceNameComboBox();
}
else if (this.IsHandleCreated)
{
BeginInvoke(new ThreadStart(PopulateDataSourceNameComboBox));
}
}
/// <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>
///
/// <exception cref="UnknownValueException"> Thrown when an Unknown Value error condition
/// occurs. </exception>
/// <exception cref="LookupException"> Thrown when a Lookup error condition occurs. </exception>
///
/// <param name="table"> The table. </param>
/// <param name="value_Renamed"> The value renamed. </param>
///
/// <returns> The description. </returns>
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 = 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.ToString();
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
if (rs.Read())
{
description = System.Convert.ToString(rs[1 - 1]);
}
else
{
throw new UnknownValueException(
"The value " + value_Renamed + " could not be found in the table " + table + " - SQL: " + sql);
}
stmt.Dispose();
NormativeDatabase.Instance.returnConnection(conn);
}
catch (System.Data.OleDb.OleDbException e)
{
throw new LookupException("Can't find value " + value_Renamed + " in table " + table, e);
}
return(description);
}
//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();
}
/// <summary>
/// 执行语句并返回结果
/// </summary>
public void ExecuteReader() {
Conn.Open();
Reader = SQLCmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
}
/// <summary>
/// 执行语句并返回结果
/// </summary>
/// <param name="SQL"></param>
public void ExecuteReader(String SQL) {
Conn.Open();
SQLCmd = new System.Data.OleDb.OleDbCommand(SQL, Conn);
Reader = SQLCmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
}
public int Query(string strSql, ref string strDataSet, string strXSLFileName)
{
this.command.Connection = this.Conn as System.Data.OleDb.OleDbConnection;
this.command.Transaction = Mder.FC.DB.DBTrans.Trans as System.Data.OleDb.OleDbTransaction;
this.command.CommandType = System.Data.CommandType.Text;
this.command.Parameters.Clear();
this.command.CommandText = strSql + "";
try
{
this.tmpReader1 = this.command.ExecuteReader();
XmlDocument doc = new XmlDocument();
XmlNode rootNode;
XmlElement node, rowNode;
doc.AppendChild(doc.CreateXmlDeclaration("1.0", "GB2312", ""));
if (strXSLFileName != null && strXSLFileName != "")
{
string PI = "type='text/xsl' href='" + strXSLFileName + "'";
System.Xml.XmlProcessingInstruction xmlProcessingInstruction = doc.CreateProcessingInstruction("xml-stylesheet", PI);
doc.AppendChild(xmlProcessingInstruction);
}
rootNode = doc.CreateElement("Table");
doc.AppendChild(rootNode);
while (this.tmpReader1.Read())
{
rowNode = doc.CreateElement("Row");
for (int i = 0; i < this.tmpReader1.FieldCount; i++)
{
node = doc.CreateElement("Column");
node.SetAttribute("Name", this.tmpReader1.GetName(i).ToString());
node.InnerText = this.tmpReader1[i].ToString() + "";
rowNode.AppendChild(node);
}
rootNode.AppendChild(rowNode);
}
strDataSet = doc.OuterXml;
this.tmpReader1.Close();
}
catch (System.Data.OleDb.OleDbException ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = ex.ErrorCode;
this.WriteErr();
return -1;
}
catch (Exception ex)
{
this.Err = "执行语句产生错误!" + ex.Message;
this.ErrCode = strSql;
this.WriteErr();
return -1;
}
WriteDebug("执行查询sql语句！" + strSql);
return 0;
}
public int Query(string strSql, ref string strDataSet)
{
this.command.Connection = this.Conn as System.Data.OleDb.OleDbConnection;
this.command.Transaction = Mder.FC.DB.DBTrans.Trans as System.Data.OleDb.OleDbTransaction;
this.command.CommandType = System.Data.CommandType.Text;
this.command.Parameters.Clear();
this.command.CommandText = strSql + "";
try
{
this.tmpReader1 = this.command.ExecuteReader();
XmlDocument doc = new XmlDocument();
XmlNode rootNode;
XmlNode node, tableNode;
rootNode = doc.CreateElement("DataSet");
doc.AppendChild(rootNode);
while (this.tmpReader1.Read())
{
tableNode = doc.CreateElement("Table");
for (int i = 0; i < this.tmpReader1.FieldCount; i++)
{
node = doc.CreateElement(this.tmpReader1.GetName(i).ToString());
node.InnerText = this.tmpReader1[i].ToString() + "";
tableNode.AppendChild(node);
}
rootNode.AppendChild(tableNode);
}//while
strDataSet = doc.OuterXml;
this.tmpReader1.Close();
}
catch (System.Data.OleDb.OleDbException ex)
{
this.Err = "执行产生错误!" + ex.Message;
this.ErrCode = strSql;
this.DBErrCode = ex.ErrorCode;
this.WriteErr();
return -1;
}
catch (Exception ex)
{
this.Err = "执行语句产生错误!" + ex.Message;
this.ErrCode = strSql;
this.WriteErr();
return -1;
}
WriteDebug("执行查询sql语句！" + strSql);
return 0;
}
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;
}
public OleDB() {
Reader = null;
}
public OleDB(string ConnStr) {
Reader = null;
setConn(ConnStr);
}
