public override IDataReader GetDataReader(string commandtext)
{
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
OleDbCommand cmd = new OleDbCommand(commandtext);
cmd.Connection = (OleDbConnection)this.connection;
if (isInTransaction)
{
cmd.Transaction = (OleDbTransaction)transaction;
}
try
{
System.Data.OleDb.OleDbDataReader reader = (OleDbDataReader)cmd.ExecuteReader();
return(reader);
}
catch (Exception e)
{
throw new Exception("操作数据库失败！参考：" + e.Message);
}
finally
{
//if (connection.State != ConnectionState.Closed && isInTransaction == false) connection.Close();
cmd.Dispose();
cmd = null;
}
}
protected void gravarVideo(object sender, EventArgs e)
{
try
{
rsGravar = objBD.ExecutaSQL("EXEC admin_piuUsuarioVideos '" + Request["VID_ID"] + "','" + Session["usuID"] + "', '" + Request["VID_TITULO"] + "','" + Request["VID_LINK"].Replace("http://youtu.be/", "").Replace("https://www.youtube.com/watch?v=", "").Replace("https://youtu.be/", "") + "','" + Request["VID_LINK"].Replace("http://youtu.be/", "http://i.ytimg.com/vi/").Replace("https://www.youtube.com/watch?v=", "http://i.ytimg.com/vi/").Replace("https://youtu.be/", "http://i.ytimg.com/vi/") + "/mqdefault.jpg', '" + Request["VID_DESCRICAO"] + "'");
if (rsGravar == null)
{
throw new Exception();
}
if (rsGravar.HasRows)
{
rsGravar.Read();
}
//Libera o BD e Memória
VerificarMedalhas();
rsGravar.Close();
rsGravar.Dispose();
//Retornar para a Listagem
Response.Redirect("meus-videos.aspx?alert=Vídeo publicado com sucesso!");
Response.End();
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Reads the selected file and places the contents into a DataTable.
/// </summary>
/// <returns>Datatable of students in file</returns>
public DataTable ReadFile()
{
DataTable data = new DataTable();
try
{
using (cmd = con.CreateCommand())
{
cmd.CommandText = string.Format("SELECT * from [{0}]", file.Name);
con.Open();
using (dr = cmd.ExecuteReader())
{
data.Load(dr);
}
}
}
catch (OleDbException oExe)
{
Debug.WriteLine(oExe.Message);
}
finally
{
con.Close();
}
return data;
}
// column1 column2 column3
// **** *** *****
// ** ***
// If inserting into column 2, we are inserting into an existing row
// if inserting into column 1 or 3, we are creating a new row
private bool ShouldInsertIntoNewRow(OleDb.OleDbConnection conn, string columnName)
{
OleDb.OleDbCommand command = new OleDb.OleDbCommand();
command.Connection = conn;
command.CommandText = "SELECT TOP 1 * FROM `Sheet1$` WHERE `" + columnName + "` IS NULL";
int ct = 0;
try
{
OleDb.OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ct++;
}
reader.Close();
} catch (OleDb.OleDbException)
{
Forms.MessageBox.Show(Strings.error, Strings.errorCaption);
}
if (ct > 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary> Creates and writes source code for all Messages and Groups.</summary>
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);
}
}
}
//Get all pictures from Database and save in a list
public List<byte[]> photos()
{
byte[] aBytes = null;
List<byte[]> pictures = new List<byte[]> {};
for (int i = 1; i <= 5000; i++)
{
try
{
int cont = 0;
string query = "SELECT image FROM Data WHERE counter = " + i + " AND image <> NULL;";
command = new OleDbCommand(query, connection);
reader = command.ExecuteReader();
while (reader.Read())
{
aBytes = (byte[])reader.GetValue(cont);
pictures.Add(aBytes);
cont++;
}
reader.Close();
}
catch (Exception e)
{
////The error message is not displayed to continue with the process.
//MessageBox.Show("I'm so sorry, we cannot get the images.\n" + e);
}
}
return pictures;
}
/**
* Obtener todos los campos de una tabla
*
* Sino se pasa la tabla, se obtendra los campos de la tabla del modelo instanciado
*
* @param string tabla de la cual se obtendran sus campos
* @return List<String> lista de campos
*/
public List <String> getFieldsDatabase(String table = "")
{
table = String.IsNullOrEmpty(table) ? this.table : table;
List <String> fieldsDatabase = new List <String>();
string sql = $"SELECT * FROM {table}";
System.Data.OleDb.OleDbDataReader oOleDbDataReader = this.oDataBase.executeSql(sql);
try
{
DataTable dtSchema = new DataTable("Schema");
dtSchema = oOleDbDataReader.GetSchemaTable();
foreach (DataRow schemarow in dtSchema.Rows)
{
fieldsDatabase.Add(schemarow.ItemArray[0].ToString());
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return(fieldsDatabase);
}
public Form1()
{
InitializeComponent();
var connection = new oleDB.OleDbConnection("Data Source=\"e:\\vic.mdb\";User ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";");
connection.Open();
oleDB.OleDbCommand command = new oleDB.OleDbCommand("Select * From [Phones]", connection);
oleDB.OleDbDataReader reader = command.ExecuteReader();
DataTable table = new DataTable();
table.Columns.Add(reader.GetName(0));
table.Columns.Add(reader.GetName(1));
table.Columns.Add(reader.GetName(2));
while (reader.Read() == true)
{
table.Rows.Add(new object[] { reader.GetValue(0), reader.GetValue(1), reader.GetValue(2) });
}
reader.Close();
connection.Close();
dataGridView1.DataSource = table;
}
public InstrumentBean( OleDbDataReader reader )
: base(_TABLE_NAME)
{
if( fieldMap.ContainsKey(_INSTRUMENT_UUID) )
fieldMap[_INSTRUMENT_UUID] = reader[_INSTRUMENT_UUID];
else
fieldMap.Add(_INSTRUMENT_UUID, reader[_INSTRUMENT_UUID]);
if( fieldMap.ContainsKey(_INSTRUMENT_NAME) )
fieldMap[_INSTRUMENT_NAME] = reader[_INSTRUMENT_NAME];
else
fieldMap.Add(_INSTRUMENT_NAME, reader[_INSTRUMENT_NAME]);
if( fieldMap.ContainsKey(_MODEL_NAME) )
fieldMap[_MODEL_NAME] = reader[_MODEL_NAME];
else
fieldMap.Add(_MODEL_NAME, reader[_MODEL_NAME]);
if( fieldMap.ContainsKey(_ATML) )
fieldMap[_ATML] = reader[_ATML];
else
fieldMap.Add(_ATML, reader[_ATML]);
if( fieldMap.ContainsKey(_DESCRIPTION) )
fieldMap[_DESCRIPTION] = reader[_DESCRIPTION];
else
fieldMap.Add(_DESCRIPTION, reader[_DESCRIPTION]);
if( fieldMap.ContainsKey(_PART_NUMBER) )
fieldMap[_PART_NUMBER] = reader[_PART_NUMBER];
else
fieldMap.Add(_PART_NUMBER, reader[_PART_NUMBER]);
initialize();
}
public void populaLista()
{
rsPlay = objBD.ExecutaSQL("select PLI_ID, PLI_TITULO, PLI_URL from PlayList where PLI_ATIVO = 1 order by PLI_DH_CADASTRO desc");
if (rsPlay == null)
{
throw new Exception();
}
if (rsPlay.HasRows)
{
while (rsPlay.Read())
{
if (aux == 1)
{
objVideo.InnerHtml += "<iframe width=\"480\" height=\"269\" src=\""+rsPlay["PLI_URL"].ToString()+"\" frameborder=\"0\" allowfullscreen></iframe>";
}
System.Web.UI.WebControls.ListItem R = new System.Web.UI.WebControls.ListItem();
R.Value = rsPlay["PLI_ID"].ToString();
R.Text = rsPlay["PLI_TITULO"].ToString();
slPlayList.Items.Add(R);
aux++;
}
}
rsPlay.Close();
rsPlay.Dispose();
}
public ElectricalDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber, CommonUtils.ImportType importType)
{
RowNumber = rowNumber;
WorkSheetName = workSheetName;
Tag = dr.SafeString((int) EquipmentColumn.Tag).Trim();
EquipmentType = dr.SafeString((int) EquipmentColumn.Type).Trim();
Description = dr.SafeString((int) EquipmentColumn.Description).Trim();
Notes = dr.SafeString((int) EquipmentColumn.Notes);
AreaNumber = dr.SafeString((int)EquipmentColumn.Area).Trim();
Specification = dr.SafeString((int)EquipmentColumn.Spec).Trim();
PandID = dr.SafeString((int)EquipmentColumn.PID).Trim();
MaintSysId = dr.SafeString((int)EquipmentColumn.MaintSysId);
string classifiedString = dr.SafeString((int)EquipmentColumn.Classified);
bool classified;
if (bool.TryParse(classifiedString, out classified))
{
Classified = classified;
}
string isActiveString = dr.SafeString((int)EquipmentColumn.IsActive);
bool isActive;
if (bool.TryParse(isActiveString, out isActive))
{
IsActive = isActive;
}
Validate(importType==CommonUtils.ImportType.CreateElectrical);
}
/// <summary>
/// Returns geometry Object IDs whose bounding box intersects 'bbox'
/// </summary>
/// <param name="bbox"></param>
/// <returns></returns>
public List <uint> GetObjectIDsInView(SharpMap.Geometries.BoundingBox bbox)
{
List <uint> objectlist = new List <uint>();
using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString))
{
string strSQL = "Select " + this.ObjectIdColumn + " FROM " + this.Table + " WHERE ";
if (_defintionQuery != null && _defintionQuery != "")
{
strSQL += _defintionQuery + " AND ";
}
//Limit to the points within the boundingbox
strSQL += this.XColumn + " BETWEEN " + bbox.Left.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.Right.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + this.YColumn +
" BETWEEN " + bbox.Bottom.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.Top.ToString(SharpMap.Map.numberFormat_EnUS);
using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn))
{
conn.Open();
using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
if (dr[0] != DBNull.Value)
{
objectlist.Add((uint)(int)dr[0]);
}
}
}
conn.Close();
}
}
return(objectlist);
}
private void RetrieveFieldsDetail(int mpPAGESIZE)
{
if (Session["mlFORMRANGEDATE"] != null && Session["FormRangeDate"] != null)
{
List <string> mlDATE = new List <string>();
mlDATATABLE1 = (DataTable)Session["FormRangeDate"];
mlDATE = (List <string>)Session["mlFORMRANGEDATE"];
countProceeds(mlDATE[0], mlDATE[1]);
countDelivered(mlDATE[0], mlDATE[1]);
countReturned(mlDATE[0], mlDATE[1]);
countDone(mlDATE[0], mlDATE[1]);
mlDGWORKSHEET.PageSize = mpPAGESIZE;
mlDGWORKSHEET.DataSource = mlDATATABLE1;
mlDGWORKSHEET.DataBind();
}
else
{
mlSql_2 = "SELECT * FROM INV_DELIVERY WHERE Disabled = '0' ORDER BY InvDate Desc";
//mlSql_2 = "SELECT * FROM INV_DELIVERY WHERE Disabled = '0' AND CompanyCode = '" + mlCOMPANYCODE + "' ORDER BY InvDate Desc";
mlREADER2 = mlOBJGS.DbRecordset(mlSql_2, "PB", mlCOMPANYID);
mlDATATABLE = InsertReaderToDatatable(mlDATATABLE, mlDATAROW, mlREADER2);
mlDGWORKSHEET.PageSize = mpPAGESIZE;
mlDGWORKSHEET.DataSource = mlDATATABLE;
mlDGWORKSHEET.DataBind();
}
}
private void SignUp_Click(object sender, EventArgs e)
{
try
{
sConn = " Provider=Microsoft.ACE.OLEDB.12.0 ; Data Source = finalprojectC#.accdb";
OleDbConnection dbConn = new OleDbConnection(sConn);
string firstname = first_NameTextBox.Text;
string lastname = last_NameTextBox.Text;
string adress = adressTextBox.Text;
string city = cityTextBox.Text;
string state = stateTextBox.Text;
string phone = phoneTextBox.Text;
string email = emailTextBox.Text;
string password = passwordTextBox.Text;
dbConn.Open();
// creaating a query
// sql = "INSERT INTO Customer_profil(customerid,firstname,lastname,adress,city,state,phone,email,password)" + "VALUES()";
OleDbCommand dbCmd = new OleDbCommand("INSERT into Customer_Profil VALUES(@customerid,@firstname,@lastname,@adress,@city,@state,@phone,@email,@password)");
// dbCmd.CommandText = sql;
dbCmd.Connection = dbConn;
//Create a dbreader object
dbReader = dbCmd.ExecuteReader();
}
catch (Exception exe)
{
label1.Text = exe.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
objBD = new bd();
objUtils = new utils();
rsRedes = objBD.ExecutaSQL("SELECT REP_CIDADE, REP_UF FROM RedesParticipantes where REP_ATIVO = 1");
if (rsRedes == null)
{
throw new Exception();
}
if (rsRedes.HasRows)
{
int contador = 1;
while (rsRedes.Read())
{
if (contador % 2 == 0)
{
listadireita.InnerHtml += "<li>" + rsRedes["REP_CIDADE"] + " - " + rsRedes["REP_UF"] + "</li>";
}
else
{
listaesquerda.InnerHtml += "<li>" + rsRedes["REP_CIDADE"] + " - " + rsRedes["REP_UF"] + "</li>";
}
contador++;
}
}
}
public static DataTable FunctionOfAdding(String stringsione)
{
var Database = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Database.Open();
dabse.OleDbCommand loadingOfTable = new dabse.OleDbCommand("Select * From " + stringsione, Database);
dabse.OleDbDataReader result = loadingOfTable.ExecuteReader();
DataTable table = new DataTable();
for (int i = 0; i < result.FieldCount; i++)
{
table.Columns.Add(result.GetName(i));
}
while (result.Read() == true)
{
object[] yacheiki = new object[result.FieldCount];
for (int i = 0; i < result.FieldCount; i++)
{
yacheiki[i] = result.GetValue(i);
}
table.Rows.Add(yacheiki);
}
result.Close();
Database.Close();
return(table);
}
private void bbatonishe_Click(object sender, EventArgs e)
{
dabse.OleDbCommand newCom = new dabse.OleDbCommand();
var comand = new dabse.OleDbCommand("SELECT Код, Название FROM Дисциплины WHERE Шифр_специальности=?", Date_baseone);
comand.Parameters.Add("Шфр_спц", dabse.OleDbType.Integer, 255).Value = int.Parse(shifrSpecialnosti.Text);
comand.Connection = Date_baseone;
dabse.OleDbDataReader Result = comand.ExecuteReader();
int x = Result.FieldCount;
String Name_disc, index_disk;
while (Result.Read() == true)
{
index_disk = Result.GetValue(0).ToString();
Name_disc = Result.GetValue(1).ToString();
dabse.OleDbCommand spisok = new dabse.OleDbCommand("insert into Дисциплины_обучение (Шифр_студента, Код_дисциплины) values (?, ?)", Date_baseone);
spisok.Parameters.Add("Шифр_студента", dabse.OleDbType.Integer, 255).Value = int.Parse(shifrStudenta.Text);
spisok.Parameters.Add("Код_дисциплины", dabse.OleDbType.Integer, 255).Value = int.Parse(index_disk);
spisok.Connection = Date_baseone;
//MessageBox.Show(spisok.CommandText);
spisok.ExecuteReader();
//spisok.Close();
}
MessageBox.Show("Всё хорошо!!!");
}
private System.Data.DataTable createTable(System.Data.DataTable mpTBLFIELD)
{
mpTBLFIELD = new DataTable();
if (mlDDLREPORTNAME.SelectedItem.Value != "InvDeliverySummary.rdlc")
{
mlSQLTEMP = "SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'INV_DELIVERY_STATUS_BRANCH'";
}
else
{
mlSQLTEMP = "SELECT COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'INV_DELIVERY_STATUS'";
}
mlRSTEMP = mlOBJGS.DbRecordset(mlSQLTEMP, "PB", mlCOMPANYID);
if (mlRSTEMP.HasRows)
{
//mlDATAROW = mpTBLFIELD.NewRow();
mlDCOL = new DataColumn("CHECK", typeof(System.Boolean));
mlDCOL.DefaultValue = false;
mpTBLFIELD.Columns.Add(mlDCOL);
while (mlRSTEMP.Read())
{
if (mlRSTEMP["DATA_TYPE"].ToString() == "varchar" || mlRSTEMP["DATA_TYPE"].ToString() == "nvarchar" || mlRSTEMP["DATA_TYPE"].ToString() == "char" || mlRSTEMP["DATA_TYPE"].ToString() == "nchar" || mlRSTEMP["DATA_TYPE"].ToString() == "ntext")
{
mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.String));
mlDCOL.DefaultValue = "";
}
else if (mlRSTEMP["DATA_TYPE"].ToString() == "decimal" || mlRSTEMP["DATA_TYPE"].ToString() == "numeric" || mlRSTEMP["DATA_TYPE"].ToString() == "float")
{
mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.Decimal));
mlDCOL.DefaultValue = 0;
}
else if (mlRSTEMP["DATA_TYPE"].ToString() == "bigint" || mlRSTEMP["DATA_TYPE"].ToString() == "int" || mlRSTEMP["DATA_TYPE"].ToString() == "smallint")
{
mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.Int64));
mlDCOL.DefaultValue = 0;
}
else if (mlRSTEMP["DATA_TYPE"].ToString() == "tinyint")
{
mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.Boolean));
mlDCOL.DefaultValue = 0;
}
else if (mlRSTEMP["DATA_TYPE"].ToString() == "datetime" || mlRSTEMP["DATA_TYPE"].ToString() == "smalldatetime" || mlRSTEMP["DATA_TYPE"].ToString() == "timestamp")
{
mlDCOL = new DataColumn(mlRSTEMP["COLUMN_NAME"].ToString(), typeof(System.DateTime));
mlDCOL.DefaultValue = DateTime.Now;
}
if (!string.IsNullOrEmpty(mlRSTEMP["DATA_TYPE"].ToString()))
{
mpTBLFIELD.Columns.Add(mlDCOL);
//mlDATAROW[mlRSTEMP["COLUMN_NAME"].ToString()] = mlDCOL.DefaultValue;
}
}
//mpTBLFIELD.Rows.Add(mlDATAROW);
}
return(mpTBLFIELD);
}
/// <summary>
/// 检验是否存在数据
/// </summary>
/// <returns></returns>
public bool ExistData(string SQL)
{
bool ret = false;
try
{
System.Data.OleDb.OleDbDataReader dr = ReturnDataReader(SQL);
if (dr.HasRows)
{
ret = true;
}
dr.Close();
}
catch (Exception Ex)
{
throw new Exception(SQL + Ex.ToString());
}
finally
{
if (null == transaction)
{
Close();
}
}
return(ret);
}
public List <Person> fillComboBox() //fill Combo
{
List <Person> personList = new List <Person>();
try
{
command.CommandText = "SELECT * FROM Tperson";
command.CommandType = CommandType.Text;
connection.Open();
System.Data.OleDb.OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Person p = new Person();
p.Id = Convert.ToInt32(reader["ID"].ToString());
p.FirstName = reader["FirstName"].ToString();
p.LastName = reader["LastName"].ToString();
personList.Add(p);
}
return(personList);
}
catch (Exception e)
{
throw e;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
private void actualizador()
{
Conector();
comando.CommandText = "select * from t_articulos";
Lector = comando.ExecuteReader();
int registros = 0;
while (Lector.Read() == true)
{
DatosCosa[registros]=new Articulo();
//Cosa = new Articulo();
DatosCosa[registros].CodigoArti = Convert.ToInt32(Lector["id_articulo"]);
DatosCosa[registros].NombreArti = Lector["n_articulo"].ToString();
DatosCosa[registros].Precio = Convert.ToDouble(Lector["precio"]);
// DatosCosa[registros] = Cosa;
registros++;
}
Lector.Close();
comando.CommandText = "select * from t_clientes";
Lector = comando.ExecuteReader();
registros = 0;
// DatosFulano = new Clientes[50];
while (Lector.Read() == true)
{//Fulano=new Clientes();
DatosFulano[registros]=new Clientes();
DatosFulano[registros].Barrio=Convert.ToInt32(Lector["id_barrio"]);
DatosFulano[registros].Calle=Lector["calle"].ToString();
DatosFulano[registros].CodigoClle=Convert.ToInt32(Lector["id_cliente"]);
DatosFulano[registros].NombreClie=Lector["n_cliente"].ToString();
DatosFulano[registros].NumeroCa=Convert.ToInt32(Lector["calle_nro"]);
//DatosFulano[registros]=Fulano;
registros++;
}
Lector.Close();
conexion.Close();
}
/// <summary>
/// Opens the connection to the database.
/// </summary>
static void openconnection()
{
dr = null;
String ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Public\\TRManager\\IncidentDB.accdb;Persist Security Info=False;";
connection = new OleDbConnection(ConnectionString);
connection.Open();
}
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);
}
}
}
public VendorDataAdapter(OleDbDataReader dr, int rowNumber)
{
ErrorMessages = new List<string>();
//Name
Name = dr.SafeString((int)VendorColumn.VendorName);
if (String.IsNullOrEmpty(Name))
{
ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", VendorColumn.VendorName, rowNumber));
}
//Number
string numberString = string.Empty;
numberString = dr.SafeString((int)VendorColumn.VendorNumber);
int number;
if (int.TryParse(numberString, out number))
{
Number = number;
}
else
{
ErrorMessages.Add(string.Format("Could not convert {0} '{1}' to number. Rown number '{2}'. Skipping ", VendorColumn.VendorNumber, numberString, rowNumber));
}
//City
City = dr.SafeString((int)VendorColumn.VendorCity);
if (String.IsNullOrEmpty(City))
{
ErrorMessages.Add(string.Format("{0} returned null, please check the format of this cell in Excel (set to Text). Row number '{1}'. Skipping ", VendorColumn.VendorCity, rowNumber));
}
}
/// <summary>
/// Returns the geometry corresponding to the Object ID
/// </summary>
/// <param name="oid">Object ID</param>
/// <returns>geometry</returns>
public IGeometry GetGeometryByID(int oid)
{
GeoAPI.Geometries.IGeometry geom = null;
using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString))
{
string strSQL = "Select " + this.XColumn + ", " + this.YColumn + " FROM " + this.Table + " WHERE " + this.ObjectIdColumn + "=" + oid.ToString();
using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn))
{
conn.Open();
using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader())
{
if (dr.Read())
{
//If the read row is OK, create a point geometry from the XColumn and YColumn and return it
if (dr[0] != DBNull.Value && dr[1] != DBNull.Value)
{
geom = SharpMap.Converters.Geometries.GeometryFactory.CreatePoint((double)dr[0], (double)dr[1]);
}
}
}
conn.Close();
}
}
return(geom);
}
public List <string> GetSqlList(String SQLquery)
{
//make an Oledbcommandobject
OleDbCommand cmd = null;
//make an Oledbdatareader
System.Data.OleDb.OleDbDataReader Reader = null;
//connects to the database and catches if there is a problem connecting
List <string> sqlViewRequests = new List <string>(); //Initializing list so things can be stored in it
cmd = new OleDbCommand(SQLquery, Connection);
try
{
Reader = cmd.ExecuteReader();
while (Reader.Read()) // while there is still information to be read, pull that information out and add it to the list
{
sqlViewRequests.Add(Convert.ToString((Reader[0]))); //Converting reader output to string
}
Reader.Close();
}
catch (InvalidOperationException)
{
Connection.Close();
}
Reader.Close();
return(sqlViewRequests);
}
public AccesoDatos()
{
conexion = null;
comando = null;
lector = null;
cadenaConexion = "";
}
public void loadData()
{
try
{
lvexaminee.Items.Clear();
//OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=db.accdb");
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM examineetbl", conn);
OleDbDataReader dr;
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
lvexaminee.Items.Add(dr[0].ToString());
lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[1].ToString());
lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[2].ToString());
lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[3].ToString());
lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[4].ToString());
lvexaminee.Items[lvexaminee.Items.Count - 1].SubItems.Add(dr[8].ToString());
}
}
dr.Close();
conn.Close();
}
catch (OleDbException ex)
{
MessageBox.Show(ex.Message);
throw;
}
}
public PipeDataAdapter(OleDbDataReader dr, string workSheetName, int rowNumber)
{
//setting parts via a data reader
ErrorMessages = new List<string>();
AreaNumber = string.Empty;
SequenceNumber =string.Empty;
Class = string.Empty;
Size = string.Empty;
FluidCode = string.Empty;
SpecialFeature =string.Empty;
PandID = string.Empty;
From = string.Empty;
To = string.Empty;
Category = string.Empty;
Description = string.Empty;
mRowNumber = rowNumber;
mWorkSheetName = workSheetName;
AreaNumber = dr.SafeString((int)PipeColumn.Area);
SequenceNumber = dr.SafeString((int)PipeColumn.Sequence);
Class = dr.SafeString((int)PipeColumn.PipeClass);
Size = dr.SafeString((int)PipeColumn.Size);
FluidCode = dr.SafeString((int)PipeColumn.FluidCode);
SpecialFeature = dr.SafeString((int)PipeColumn.SpecialFeature);
PandID = dr.SafeString((int)PipeColumn.PID);
From = dr.SafeString((int)PipeColumn.From);
To = dr.SafeString((int)PipeColumn.To);
Category = dr.SafeString((int)PipeColumn.Category);
Description = dr.SafeString((int)PipeColumn.Description);
IsActive = dr.SafeNullableBool((int) PipeColumn.IsActive);
}
public void listarBanner(int RED_ID)
{
try
{
rsBanner = objBD.ExecutaSQL("EXEC site_psBanner "+RED_ID+" ");
if (rsBanner == null)
{
throw new Exception();
}
if (rsBanner.HasRows)
{
while (rsBanner.Read())
{
banner.InnerHtml += "<div class='banner'>";
banner.InnerHtml += " <a href='" + rsBanner["BAN_LINK"] + "' title='" + rsBanner["BAN_LEGENDA"] + "'><img width='752px' height='208px' src='/upload/imagens/banners/" + rsBanner["BAN_IMAGEM"] + "' alt='" + rsBanner["BAN_LEGENDA"] + "'/></a>";
banner.InnerHtml += "</div>";
}
}
rsBanner.Close();
rsBanner.Dispose();
}
catch (Exception)
{
throw;
}
}
private void Disciplines_Load(object sender, EventArgs e)
{
//dataGridView1.DataSource = MainForm.FunctionOfAdding(nameoftable);
var data1 = new List <Dvapolya>();
Date_baseone = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Date_baseone.Open();
dabse.OleDbCommand com1 = new dabse.OleDbCommand("Select Название, Шифр FROM Специальности", Date_baseone);
dabse.OleDbDataReader resulter1 = com1.ExecuteReader();
while (resulter1.Read() == true)
{
var mc = new Dvapolya
{
secondpole = resulter1[0].ToString().Trim(),
firstpole = resulter1[1].ToString().Trim()
};
data1.Add(mc);
}
comboBox1.DataSource = data1;
comboBox1.DisplayMember = "secondpole";
comboBox1.ValueMember = "firstpole";
}
void LoadPicFile(Dictionary <string, ObjItem> dr)
{
string strSQL = "SELECT PICFILE FROM LKEQ.EQCARDEXPLAINREC WHERE CHOSCODE=" + dr["医疗机构编码"].ToString() + " AND CARDID=" + dr["卡片ID"].ToString();
string cnnstr = ConfigurationManager.AppSettings["LKEQ_Conn"].ToString();
//string cnnstr = "Provider = OraOLEDB.Oracle.1; Data Source = orcl; User ID = HIS; Password =linker;Persist Security Info=True";
//string cnnstr = System.Configuration.ConfigurationManager.ConnectionStrings["LKEQ_Conn"].ToString();
OleDbConnection con = new OleDbConnection(cnnstr);
try
{
con.Open();
}
catch
{ }
OleDbCommand cmd = new OleDbCommand(strSQL, con);
System.Data.OleDb.OleDbDataReader drSM = cmd.ExecuteReader();
while (drSM.Read())
{
if (drSM["PICFILE"] != DBNull.Value) //照片字段里有值才能进到方法体显示图片，否则清空pb
{
MemoryStream ms = new MemoryStream((byte[])drSM["PICFILE"]); //把照片读到MemoryStream里
bytPicLoad = (byte[])drSM["PICFILE"];
Image imageBlob = Image.FromStream(ms, true); //用流创建Image
pictureBox1.Image = imageBlob; //输出图片
}
else//照片字段里没值，清空pb
{
pictureBox1.Image = null;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
var Database = new OleDiBi.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Database.Open();
OleDiBi.OleDbCommand loadingOfTable = new OleDiBi.OleDbCommand(richTextBox1.Text, Database);
OleDiBi.OleDbDataReader result = loadingOfTable.ExecuteReader();
DataTable table = new DataTable();
for (int i = 0; i < result.FieldCount; i++)
{
table.Columns.Add(result.GetName(i));
}
while (result.Read() == true)
{
object[] yacheiki = new object[result.FieldCount];
for (int i = 0; i < result.FieldCount; i++)
{
yacheiki[i] = result.GetValue(i);
}
table.Rows.Add(yacheiki);
}
result.Close();
Database.Close();
dataGridView1.DataSource = table;
}
//Constructor - Initializes the object with data and connects to the database.
public MeasurementUncertainityCalculator()
{
string path;
path = Path.GetDirectoryName(Application.ExecutablePath);
try
{
connection = new OleDbConnection();
connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\DB\\UC.mdb;Persist Security Info=False";
connection.Open();
command = new OleDbCommand();
command.Connection = connection;
command.CommandText = "SELECT count(Sample_Number) FROM InputTable";
reader = command.ExecuteReader();
while (reader.Read())
{
no_of_obs = (Double.Parse(reader[0].ToString()));
}
reader.Close();
reader = null;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
/// <summary>
/// 返回一个DataReader
/// </summary>
/// <param name="commandText">SQL语句字符串</param>
/// <param name="timeOut">超时限制</param>
/// <returns></returns>
public override IDataReader GetDataReader(string commandText, int timeOut)
{
OleDbCommand cmd = new OleDbCommand(commandText);
cmd.Connection = (OleDbConnection)this.connection;
if (timeOut > 30)
{
cmd.CommandTimeout = timeOut;
}
if (isInTransaction)
{
cmd.Transaction = (OleDbTransaction)transaction;
}
try
{
System.Data.OleDb.OleDbDataReader reader = (OleDbDataReader)cmd.ExecuteReader();
return(reader);
}
catch (Exception err)
{
throw new EntityException(err.Message);
}
finally
{
cmd.Dispose();
cmd = null;
}
}
private void BookCatalog_Load(object sender, EventArgs e)
{
try{
// creating a connection
sConn = " Provider=Microsoft.ACE.OLEDB.12.0 ; Data Source = finalprojectC#.accdb";
OleDbConnection dbConn = new OleDbConnection(sConn);
dbConn.Open();
// creating a sql query
sql = "SELECT * FROM Books_online ORDER BY BookName ASC, Book_Price ASC;";
OleDbCommand dbCmd = new OleDbCommand();
dbCmd.CommandText = sql;
dbCmd.Connection = dbConn;
//Create a dbreader object
dbReader = dbCmd.ExecuteReader();
while (dbReader.Read())
{
// adding book name and price to listbox
fprice = Convert.ToDouble(dbReader["Book_Price"]);
this.listBox1.Items.Add(dbReader["BookName"].ToString() + " " + "$" + dbReader["Book_Price"]);
}
dbReader.Close();
dbConn.Close();
}
catch (System.Exception exc)
{
label1.Text = exc.Message;
}
}
public void ListarConfig(string ID)
{
if (string.IsNullOrWhiteSpace(ID) == false)
{
rsConfig = objBD.ExecutaSQL("EXEC site_psListarConfig " + ID);
if (rsConfig == null)
{
throw new Exception();
}
if (rsConfig.HasRows)
{
rsConfig.Read();
USU_ID.Attributes.Add("value", rsConfig["USU_ID"].ToString());
USU_NOME.Attributes.Add("value", rsConfig["USU_NOME"].ToString());
USU_EMAIL.Attributes.Add("value", rsConfig["USU_EMAIL"].ToString());
ListItem li = CAR_ID.Items.FindByValue(rsConfig["CAR_ID"].ToString());
li.Selected = true;
//pivacidade
if (rsConfig["PRI_PERFIL"].ToString() == "True") { sim_perfil.Checked = true; } else { nao_perfil.Checked = true; }
if (rsConfig["PRI_BLOG"].ToString() == "True") { sim_blog.Checked = true; } else { nao_blog.Checked = true; }
if (rsConfig["PRI_FOTOS"].ToString() == "True") { sim_midia.Checked = true; } else { nao_midia.Checked = true; }
if (rsConfig["PRI_FOTOS"].ToString() == "True") { sim_video.Checked = true; } else { nao_video.Checked = true; }
//notificaoes
if (rsConfig["NOT_BLOG"].ToString() == "True") { sim_blog2.Checked = true; } else { nao_blog2.Checked = true; }
if (rsConfig["NOT_GALERIA"].ToString() == "True") { sim_galeria.Checked = true; } else { nao_galeria.Checked = true; }
if (rsConfig["NOT_FORUM"].ToString() == "True") { sim_forum.Checked = true; } else { nao_forum.Checked = true; }
if (rsConfig["NOT_DOCUMENTADAS"].ToString() == "True") { sim_criacao.Checked = true; } else { nao_criacao.Checked = true; }
InsereCategoria(infantil);
InsereCategoria(fundamental);
}
}
}
public SignalAttributeMasterBean( OleDbDataReader reader )
: base(_TABLE_NAME)
{
if( fieldMap.ContainsKey(_SIGNAL_ATTRIBUTE_ID) )
fieldMap[_SIGNAL_ATTRIBUTE_ID] = reader[_SIGNAL_ATTRIBUTE_ID];
else
fieldMap.Add(_SIGNAL_ATTRIBUTE_ID, reader[_SIGNAL_ATTRIBUTE_ID]);
if( fieldMap.ContainsKey(_SIGNAL_ID) )
fieldMap[_SIGNAL_ID] = reader[_SIGNAL_ID];
else
fieldMap.Add(_SIGNAL_ID, reader[_SIGNAL_ID]);
if( fieldMap.ContainsKey(_ATTRIBUTE_NAME) )
fieldMap[_ATTRIBUTE_NAME] = reader[_ATTRIBUTE_NAME];
else
fieldMap.Add(_ATTRIBUTE_NAME, reader[_ATTRIBUTE_NAME]);
if( fieldMap.ContainsKey(_DEFAULT_VALUE) )
fieldMap[_DEFAULT_VALUE] = reader[_DEFAULT_VALUE];
else
fieldMap.Add(_DEFAULT_VALUE, reader[_DEFAULT_VALUE]);
if( fieldMap.ContainsKey(_TYPE) )
fieldMap[_TYPE] = reader[_TYPE];
else
fieldMap.Add(_TYPE, reader[_TYPE]);
if( fieldMap.ContainsKey(_FIXED_VALUE) )
fieldMap[_FIXED_VALUE] = reader[_FIXED_VALUE];
else
fieldMap.Add(_FIXED_VALUE, reader[_FIXED_VALUE]);
initialize();
}
public static string LoadById(int id)
{
string sql = "SELECT * FROM CUSTOMER WHERE CUSTID = " + id.ToString() + "";
string name = "";
try
{
cn = new OleDbConnection(path);
cn.Open();
cmd.Connection = cn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.TableDirect;
dr = cmd.ExecuteReader();
dr.Read();
name = dr[1].ToString();
}
catch (Exception e)
{
}
finally
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
cmd.Dispose();
cn.Close();
}
return name;
}
protected void Button1_Click(object sender, EventArgs e)
{
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
string u_name, password;
u_name = TextBox1.Text;
password = TextBox2.Text;
rec_mail rr = new rec_mail();
string comp=rr.un_enc(u_name, password);
//u_name = raw_u_name + password[2];
//Response.Write(u_name);
conn.Open();
cmd=new OleDbCommand ("select enc_fun(user_id,password) from username where user_id='"+ u_name +"'",conn);
dr = cmd.ExecuteReader();
//dr.Read();
//Response.Write(raw_u_name + dr["password"].ToString()[2]);
if (dr.HasRows == false)
Label2.Visible = true;
else
{
dr.Read();
if (dr[0].ToString() == comp)
{
Session["us_name"] = u_name;
Response.Redirect("Mail_box.aspx");
}
else
Label2.Visible = true;
}
dr.Close();
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
objUtils = new utils();
objBD = new bd();
switch (Request["acao"])
{
case ("editar"):
rsLista = objBD.ExecutaSQL("select EQU_ID, EQU_NOME, EQU_DESCRICAO from Equipe where EQU_ID ='" + Request["EQU_ID"] + "'");
if (rsLista == null)
{
throw new Exception();
}
if (rsLista.HasRows)
{
rsLista.Read();
Response.Write(rsLista["EQU_ID"] + "|" + rsLista["EQU_NOME"] + "|" + rsLista["EQU_DESCRICAO"]);
}
break;
default:
PopulaLista();
break;
}
}
public TestSignalLibraryBean( OleDbDataReader reader )
: base(_TABLE_NAME)
{
if( fieldMap.ContainsKey(_ID) )
fieldMap[_ID] = reader[_ID];
else
fieldMap.Add(_ID, reader[_ID]);
if( fieldMap.ContainsKey(_LIBRARY_NAME) )
fieldMap[_LIBRARY_NAME] = reader[_LIBRARY_NAME];
else
fieldMap.Add(_LIBRARY_NAME, reader[_LIBRARY_NAME]);
if( fieldMap.ContainsKey(_CONTENT) )
fieldMap[_CONTENT] = reader[_CONTENT];
else
fieldMap.Add(_CONTENT, reader[_CONTENT]);
if( fieldMap.ContainsKey(_FILE_NAME) )
fieldMap[_FILE_NAME] = reader[_FILE_NAME];
else
fieldMap.Add(_FILE_NAME, reader[_FILE_NAME]);
if( fieldMap.ContainsKey(_LAST_UPDATE) )
fieldMap[_LAST_UPDATE] = reader[_LAST_UPDATE];
else
fieldMap.Add(_LAST_UPDATE, reader[_LAST_UPDATE]);
if( fieldMap.ContainsKey(_TARGET_NAMESPACE) )
fieldMap[_TARGET_NAMESPACE] = reader[_TARGET_NAMESPACE];
else
fieldMap.Add(_TARGET_NAMESPACE, reader[_TARGET_NAMESPACE]);
initialize();
}
/// <summary>
/// Boundingbox of dataset
/// </summary>
/// <returns>boundingbox</returns>
public GeoAPI.Geometries.IEnvelope GetExtents()
{
GeoAPI.Geometries.IEnvelope box = null;
using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString))
{
string strSQL = "Select Min(" + this.XColumn + ") as MinX, Min(" + this.YColumn + ") As MinY, " +
"Max(" + this.XColumn + ") As MaxX, Max(" + this.YColumn + ") As MaxY FROM " + this.Table;
if (!String.IsNullOrEmpty(_defintionQuery)) //If a definition query has been specified, add this as a filter on the query
{
strSQL += " WHERE " + _defintionQuery;
}
using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn))
{
conn.Open();
using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader())
{
if (dr.Read())
{
//If the read row is OK, create a point geometry from the XColumn and YColumn and return it
if (dr[0] != DBNull.Value && dr[1] != DBNull.Value && dr[2] != DBNull.Value && dr[3] != DBNull.Value)
{
box = SharpMap.Converters.Geometries.GeometryFactory.CreateEnvelope((double)dr[0], (double)dr[1], (double)dr[2], (double)dr[3]);
}
}
}
conn.Close();
}
}
return(box);
}
public void AlterarDados(tbVendaDTO venda)
{
String sSQL = "";
sSQL += "UPDATE tbVenda SET idProduto = @idProduto, idVendedor = @idVendedor, qtQuantidade = @qtQuantidade WHERE idVenda = @idVenda ";
conexao = (OleDbConnection)CriaConexaoOleDb();
command = new OleDbCommand(sSQL, conexao);
command.CommandType = CommandType.Text;
OleDbParameter parametro = command.Parameters.Add("@idProduto", OleDbType.Integer);
parametro.Value = venda.Produto.idProduto;
parametro = command.Parameters.Add("@idVendedor", OleDbType.Integer);
parametro.Value = venda.Vendedor.idVendedor;
parametro = command.Parameters.Add("@qtQuantidade", OleDbType.Integer);
parametro.Value = venda.qtQuantidade;
parametro = command.Parameters.Add("@idVenda", OleDbType.Integer);
parametro.Value = venda.idVenda;
try
{
drOleDb = command.ExecuteReader();
drOleDb.Close();
conexao.Close();
}
catch (SystemException e)
{
erro = e.Message;
}
}
/// <summary>
/// Returns geometries within the specified bounding box
/// </summary>
/// <param name="bbox"></param>
/// <returns></returns>
public List <SharpMap.Geometries.Geometry> GetGeometriesInView(SharpMap.Geometries.BoundingBox bbox)
{
List <Geometries.Geometry> features = new List <SharpMap.Geometries.Geometry>();
using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString))
{
string strSQL = "Select " + this.XColumn + ", " + this.YColumn + " FROM " + this.Table + " WHERE ";
if (_defintionQuery != null && _defintionQuery != "")
{
strSQL += _defintionQuery + " AND ";
}
//Limit to the points within the boundingbox
strSQL += this.XColumn + " BETWEEN " + bbox.Left.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.Right.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " +
this.YColumn + " BETWEEN " + bbox.Bottom.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.Top.ToString(SharpMap.Map.numberFormat_EnUS);
using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn))
{
conn.Open();
using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
if (dr[0] != DBNull.Value && dr[1] != DBNull.Value)
{
features.Add(new SharpMap.Geometries.Point((double)dr[0], (double)dr[1]));
}
}
}
conn.Close();
}
}
return(features);
}
public SignalMasterBean( OleDbDataReader reader )
: base(_TABLE_NAME)
{
if( fieldMap.ContainsKey(_SIGNAL_ID) )
fieldMap[_SIGNAL_ID] = reader[_SIGNAL_ID];
else
fieldMap.Add(_SIGNAL_ID, reader[_SIGNAL_ID]);
if( fieldMap.ContainsKey(_SIGNAL_NAME) )
fieldMap[_SIGNAL_NAME] = reader[_SIGNAL_NAME];
else
fieldMap.Add(_SIGNAL_NAME, reader[_SIGNAL_NAME]);
if( fieldMap.ContainsKey(_PARENT_SIGNAL_ID) )
fieldMap[_PARENT_SIGNAL_ID] = reader[_PARENT_SIGNAL_ID];
else
fieldMap.Add(_PARENT_SIGNAL_ID, reader[_PARENT_SIGNAL_ID]);
if( fieldMap.ContainsKey(_XMLNS) )
fieldMap[_XMLNS] = reader[_XMLNS];
else
fieldMap.Add(_XMLNS, reader[_XMLNS]);
if( fieldMap.ContainsKey(_UUID) )
fieldMap[_UUID] = reader[_UUID];
else
fieldMap.Add(_UUID, reader[_UUID]);
initialize();
}
protected void Button1_Click1(object sender, EventArgs e)
{
string strGroupName, strGroupContent;
DateTime dtmCreateDate;
if (txtGroupName.Text == "")
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('请填写群组名称！')</script>");
return;
}
strGroupName = txtGroupName.Text;
strGroupContent = txtGroupName.Text;
string strsql;
myGroup = AccessDateHelper.ExecuteReader("select * from [Group] where UserID=" + Convert.ToInt16(myUserID) + "");
if (myGroup.Read())
{
strsql = "update [Group] set GroupName='" + strGroupName + "',GroupContent='" + strGroupContent + "' where GroupID=" + Convert.ToInt16(myGroup["GroupID"]) + "";
}
else
{
strsql = "insert into [Group] (GroupName,GroupContent,UserID) values ('" + strGroupName + "','" + strGroupContent + "',"+Convert.ToInt16(myUserID)+")";
}
if (AccessDateHelper.ExecuteNonQuery(strsql) > 0)
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('群组更改成功！');try{ window.opener.RefreshForm() }catch(e){};</script>");
}
else
{
this.RegisterStartupScript("newWindow", "<script language='javascript'>alert('新建试题失败！')</script>");
}
}
/// <summary>
/// Returns geometries within the specified bounding box
/// </summary>
/// <param name="bbox"></param>
/// <returns></returns>
public ICollection <IGeometry> GetGeometriesInView(IEnvelope bbox, double minGeometrySize)
{
Collection <GeoAPI.Geometries.IGeometry> features = new Collection <GeoAPI.Geometries.IGeometry>();
using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString))
{
string strSQL = "Select " + this.XColumn + ", " + this.YColumn + " FROM " + this.Table + " WHERE ";
if (!String.IsNullOrEmpty(_defintionQuery))
{
strSQL += _defintionQuery + " AND ";
}
//Limit to the points within the boundingbox
strSQL += this.XColumn + " BETWEEN " + bbox.MinX.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.MaxX.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " +
this.YColumn + " BETWEEN " + bbox.MaxY.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + bbox.MinY.ToString(SharpMap.Map.numberFormat_EnUS);
using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn))
{
conn.Open();
using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
if (dr[0] != DBNull.Value && dr[1] != DBNull.Value)
{
features.Add(SharpMap.Converters.Geometries.GeometryFactory.CreatePoint((double)dr[0], (double)dr[1]));
}
}
}
conn.Close();
}
}
return(features);
}
public void Ultimas()
{
rsLista = objBD.ExecutaSQL("select top 3 F.FTO_ID, U.USU_NOME, U.USU_USUARIO, FME_MENSAGEM, CONVERT(VARCHAR(10),FME_DH_PUBLICACAO, 103) AS FME_DH_PUBLICACAO, T.FTO_TITULO from ForumMensagem F inner join ForumTopicos T on (T.FTO_ID = F.FTO_ID) inner join Usuario U ON (U.USU_ID = F.USU_ID) where RED_ID = " + Session["redeID"] + " and F.FME_ATIVO = 1 order by F.FME_DH_PUBLICACAO desc");
if (rsLista == null)
{
throw new Exception();
}
if (rsLista.HasRows)
{
while (rsLista.Read())
{
ultimasMensagens.InnerHtml += " <div class=\"txt blog_txt txt_forum\">";
ultimasMensagens.InnerHtml += " <div class=\"txt\">";
ultimasMensagens.InnerHtml += " <a href=\"/forum-lista/" + objUtils.GerarURLAmigavel(rsLista["FTO_TITULO"].ToString()) + "/1\" title=\"" + rsLista["FTO_TITULO"] + "\"><p>" + objUtils.CortarString(true, 100, rsLista["FME_MENSAGEM"].ToString()) + "</p></a>";
ultimasMensagens.InnerHtml += " <p class=\"destque_forum\">Mensagem enviada por: <a href='/perfil/" + rsLista["USU_USUARIO"].ToString() + "' title='" + rsLista["USU_NOME"].ToString() + "'>" + rsLista["USU_NOME"].ToString() + "</a></p>";
ultimasMensagens.InnerHtml += " <p class=\"destque_forum\">Enviada em: <b>" + rsLista["FME_DH_PUBLICACAO"].ToString() + "</b></p>";
ultimasMensagens.InnerHtml += " <p class=\"destque_forum\">Tópico: <b><a href=\"/forum-lista/" + objUtils.GerarURLAmigavel(rsLista["FTO_TITULO"].ToString()) + "/1\" title=\"" + rsLista["FTO_TITULO"] + "\">" + rsLista["FTO_TITULO"].ToString() + "</a></b></p><br /><br />";
ultimasMensagens.InnerHtml += " </div>";
ultimasMensagens.InnerHtml += " </div>";
}
}
rsLista.Close();
rsLista.Dispose();
}
/// <summary>
/// Returns geometry Object IDs whose bounding box intersects 'envelope'
/// </summary>
/// <param name="envelope"></param>
/// <returns></returns>
public ICollection <int> GetObjectIDsInView(IEnvelope envelope)
{
Collection <int> objectlist = new Collection <int>();
using (System.Data.OleDb.OleDbConnection conn = new OleDbConnection(_ConnectionString))
{
string strSQL = "Select " + this.ObjectIdColumn + " FROM " + this.Table + " WHERE ";
if (!String.IsNullOrEmpty(_defintionQuery))
{
strSQL += _defintionQuery + " AND ";
}
//Limit to the points within the boundingbox
strSQL += this.XColumn + " BETWEEN " + envelope.MinX.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + envelope.MaxX.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + this.YColumn +
" BETWEEN " + envelope.MaxY.ToString(SharpMap.Map.numberFormat_EnUS) + " AND " + envelope.MinY.ToString(SharpMap.Map.numberFormat_EnUS);
using (System.Data.OleDb.OleDbCommand command = new OleDbCommand(strSQL, conn))
{
conn.Open();
using (System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
if (dr[0] != DBNull.Value)
{
objectlist.Add((int)dr[0]);
}
}
}
conn.Close();
}
}
return(objectlist);
}
public void Initialise()
{
string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=phonebook.accdb";
OleDbConnection conn = new OleDbConnection(connectionString);
string sql = "SELECT * FROM task ORDER BY id";
OleDbCommand cmd = new OleDbCommand(sql, conn);
try
{
conn.Open();
reader = cmd.ExecuteReader();
reader.Read();
lblTask.Text = reader.GetString(1).ToString();
txtTask.Text = reader.GetString(2).ToString();
reader.Close();
conn.Close();
}
catch
{
//MessageBox.Show(e.Message);
}
}
/// <summary>取得OleDbDataReader</summary>
/// <param name="strSQL">SQL 指令</param>
/// <param name="oleDbConn">連線物件(OleDbConnection)</param>
/// <returns>OleDbDataReader</returns>
/// <remarks></remarks>
public static OleDbDataReader getOleDbDataReader(string strSQL, System.Data.OleDb.OleDbConnection oleDbConn)
{
System.Data.OleDb.OleDbDataReader dr = null;
System.Data.OleDb.OleDbCommand cmd = null;
try
{
if (oleDbConn == null)
{
oleDbConn = createOleDbConnection();
}
if (!(oleDbConn.State == ConnectionState.Open))
{
oleDbConn.Open();
}
cmd = new System.Data.OleDb.OleDbCommand(strSQL, oleDbConn);
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception Ex)
{
//Message.alertMessage("C0001", null, Ex.Message.ToString(), null);
if (!(oleDbConn.State == ConnectionState.Closed))
{
oleDbConn.Close();
}
dr = null;
}
return(dr);
}
public void FillCombo()
{
try
{
con = new OleDbConnection(cs);
con.Open();
string ct = "select RTRIM(CategoryName) from Category order by CategoryName";
cmd = new OleDbCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
cmbCategory.Items.Add(rdr[0]);
}
con.Close();
con = new OleDbConnection(cs);
con.Open();
string ct1 = "select RTRIM(CompanyName) from Company order by CompanyName";
cmd = new OleDbCommand(ct1);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
cmbCompany.Items.Add(rdr[0]);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public InterlockDataAdapter(OleDbDataReader dr ,IList<string> dynamicList, int startColumn)
{
ControlSystemName = string.Empty;
InterlockTypeName =
Number = string.Empty;
Cause = string.Empty;
Description = string.Empty;
ControlSystemName = dr.SafeString((int)InterlockColumn.ControlSystemName).Trim();
InterlockTypeName = dr.SafeString((int)InterlockColumn.InterlockType).Trim();
Number = dr.SafeString((int)InterlockColumn.Number).Trim();
Cause = dr.SafeString((int)InterlockColumn.Cause).Trim();
Description = dr.SafeString((int)InterlockColumn.Description).Trim();
DynamicProperties = new List<DynamicProperty>();
if (dynamicList != null && dynamicList.Any())
{
for (int d = 0; d < dynamicList.Count(); d++)
{
string p = dynamicList[d];
DynamicProperty property = new DynamicProperty();
property.PropertyName = p;
property.PropertyValue = dr.SafeString(startColumn + d);
DynamicProperties.Add(property);
}
}
}
public void RetrieveFieldsDetail()
{
try
{
mlSQLM = " SELECT '01' AS ColInd, 'Admin' AS Description,'' AS ExecFile,'' AS SpecialParameter UNION ALL " +
" SELECT '02' AS ColInd, Description, ExecFile, SpecialParameter FROM AD_MENU WHERE " +
" MenuID IN (SELECT MenuID FROM AD_GROUPMENU WHERE GroupMenu = '" + mlGROUPMENU + "')" +
" AND ExecFile <> '' AND (SysID='IA') AND MenuTransType LIKE 'AD%' " +
"" +
" UNION ALL SELECT '03' AS ColInd,'^','','' " +
" UNION ALL SELECT '04'AS ColInd,'Master Data','','' UNION ALL " +
" SELECT '05',Description, ExecFile, SpecialParameter FROM AD_MENU WHERE " +
" MenuID IN (SELECT MenuID FROM AD_GROUPMENU WHERE GroupMenu = '" + mlGROUPMENU + "')" +
" AND ExecFile <> '' AND (SysID='IA') AND MenuTransType LIKE 'MS%' " +
"" +
" UNION ALL SELECT '06' AS ColInd,'^','','' " +
" UNION ALL SELECT '07' AS ColInd,'Transaction','','' UNION ALL " +
" SELECT '08', Description, ExecFile, SpecialParameter FROM AD_MENU WHERE " +
" MenuID IN (SELECT MenuID FROM AD_GROUPMENU WHERE GroupMenu = '" + mlGROUPMENU + "')" +
" AND ExecFile <> '' AND (SysID='IA') AND MenuTransType LIKE 'TR%' " +
"" +
" UNION ALL SELECT '09' AS ColInd,'^','','' " +
" UNION ALL SELECT '10' AS ColInd,'Posting','','' UNION ALL " +
" SELECT '11',Description, ExecFile, SpecialParameter FROM AD_MENU WHERE " +
" MenuID IN (SELECT MenuID FROM AD_GROUPMENU WHERE GroupMenu = '" + mlGROUPMENU + "')" +
" AND ExecFile <> '' AND (SysID='IA') AND MenuTransType LIKE 'PS%' " +
"" +
" UNION ALL SELECT '12' AS ColInd,'^','','' " +
" UNION ALL SELECT '13' AS ColInd,'Report','','' UNION ALL " +
" SELECT '14',Description, ExecFile, SpecialParameter FROM AD_MENU WHERE " +
" MenuID IN (SELECT MenuID FROM AD_GROUPMENU WHERE GroupMenu = '" + mlGROUPMENU + "')" +
" AND ExecFile <> '' AND (SysID='IA') AND MenuTransType LIKE 'RP%' " +
"" +
" UNION ALL SELECT '15' AS ColInd,'^','','' " +
" UNION ALL SELECT '16' AS ColInd,'Utility','','' UNION ALL " +
" SELECT '17',Description, ExecFile, SpecialParameter FROM AD_MENU WHERE " +
" MenuID IN (SELECT MenuID FROM AD_GROUPMENU WHERE GroupMenu = '" + mlGROUPMENU + "')" +
" AND ExecFile <> '' AND (SysID='IA') AND MenuTransType LIKE 'UT%' " +
"" +
" UNION ALL SELECT '18' AS ColInd,'^','','' " +
" UNION ALL SELECT '19' AS ColInd,'Monitoring Delivery','','' UNION ALL " +
" SELECT '20',Description, ExecFile, SpecialParameter FROM AD_MENU WHERE " +
" MenuID IN (SELECT MenuID FROM AD_GROUPMENU WHERE GroupMenu = '" + mlGROUPMENU + "')" +
" AND ExecFile <> '' AND (SysID='IA') AND MenuTransType LIKE 'MD%' " +
"" +
" UNION ALL SELECT '21' AS ColInd,'^','','' " +
" UNION ALL SELECT '22' AS ColInd,'','','' UNION ALL " +
" SELECT '23',Description, ExecFile, SpecialParameter FROM AD_MENU WHERE " +
" MenuID IN (SELECT MenuID FROM AD_GROUPMENU WHERE GroupMenu = '" + mlGROUPMENU + "')" +
" AND ExecFile <> '' AND (SysID='IA') AND MenuTransType LIKE 'BN%' " +
"" +
" ORDER BY ColInd,Description" +
"";
mlREADERM = mlOBJGS.DbRecordset(mlSQLM, "AD", "AD");
}
catch
{
}
}
private void button3_Click(object sender, EventArgs e)
{
String surname;
String groupName;
String specialityName;
String formOfEducation;
String yearsofEducation;
List <String> surnameMas = new List <String>();
List <String> groupNameMas = new List <String>();
List <String> specialityNameMas = new List <String>();
List <String> formOfEducationMas = new List <String>();
List <String> yearsofEducationMas = new List <String>();
var Command = new dabse.OleDbCommand("SELECT Студенты.Фамилия, Группы.Название, Специальности.Название, Студенты.Форма_обучения, Специальности.Срок_обучения FROM Группы, Группы_обучение, Студенты, Специальности WHERE Группы.Номер = Группы_обучение.Номер_группы AND Группы_обучение.Шифр_студента = Студенты.Шифр AND Студенты.Специальность = Специальности.Шифр AND Студенты.Шифр = " + thirdshifrsudenta.Text + "AND Группы_обучение.Год = " + thirdnameofsubject.Text, Date_baseone);
dabse.OleDbDataReader Ask3 = Command.ExecuteReader();
while (Ask3.Read() == true)
{
surname = Ask3[0].ToString();
groupName = Ask3[1].ToString();
specialityName = Ask3[2].ToString();
formOfEducation = Ask3[3].ToString();
yearsofEducation = Ask3[4].ToString();
surnameMas.Add(surname);
groupNameMas.Add(groupName);
specialityNameMas.Add(specialityName);
formOfEducationMas.Add(formOfEducation);
yearsofEducationMas.Add(yearsofEducation);
}
wooord.Application wordApp = new wooord.Application();
wordApp.Visible = true;
object oMissing = Type.Missing;
wooord.Document wordDoc;
wooord.Paragraph wordPar;
wooord.Range wordRan;
wordDoc = wordApp.Documents.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
//задаём форматирование для первого абзаца, которое будет так же и для всего документа, но
//это не страшно. Последующие абзацы будут иметь другое форматирование
Object begin = Type.Missing;
Object end = Type.Missing;
wordRan = wordDoc.Range(ref begin, ref end);
wordRan.ParagraphFormat.Alignment = wooord.WdParagraphAlignment.wdAlignParagraphCenter;
wordRan.Text = "Справка";
//теперь задаём форматирование следующего абзаца
wordPar = wordDoc.Paragraphs.Add(ref oMissing);
wordDoc.Paragraphs[2].Range.ParagraphFormat.Alignment = wooord.WdParagraphAlignment.wdAlignParagraphLeft;
wordDoc.Paragraphs[2].Range.Font.Size = 10;
wordDoc.Paragraphs[2].Range.Text = "Студент " + surnameMas[0] + " обучается в группе " + groupNameMas[0] + " по специальности " + specialityNameMas[0] + ". Форма обучения – " + formOfEducationMas[0] + ". Срок обучения – " + yearsofEducationMas[0] + ".";
}
public void Select_TabelaControleDeVendaDepartamento()
{
String _strSQL;
_strSQL = "SELECT * FROM TabelaControleDeVendaDepartamento;";
_OleDbCommand.CommandText = _strSQL;
_DataReader = _OleDbCommand.ExecuteReader();
}
public void Select_TabelaControleDeVendaProdutosEAN13(String _EAN13)
{
String _strSQL;
_strSQL = "SELECT * FROM TabelaControleDeVendaProdutoServico WHERE EAN13 = '" + _EAN13 + "'";
_OleDbCommand.CommandText = _strSQL;
_DataReader = _OleDbCommand.ExecuteReader();
}
public void Select_TabelaControleDeVendaProdutos()
{
String _strSQL;
_strSQL = "SELECT EAN13, NOME_PRODUTO_SERVICO FROM TabelaControleDeVendaProdutoServico Order by Nome_Produto_Servico;";
_OleDbCommand.CommandText = _strSQL;
_DataReader = _OleDbCommand.ExecuteReader();
}
public void Select_TabelaControleDeVendaOperacao()
{
String _strSQL;
_strSQL = "SELECT TIPO_OPERACAO, DESCRICAO FROM TabelaControleDeVendaTipo_Operacao Order by TIPO_OPERACAO;";
_OleDbCommand.CommandText = _strSQL;
_DataReader = _OleDbCommand.ExecuteReader();
}