protected void Button2_Click(object sender, EventArgs e)
{
string s_add, r_add, message, heading,muid;
s_add = Session["us_name"].ToString();
r_add = TextBox1.Text;
heading = TextBox3.Text;
message = TextBox2.Text;
rec_mail te = new rec_mail();
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
conn.Open();
cmd = new OleDbCommand("insert into messages values(m_id.nextval,'" + heading + "','" + message + "'," + file_name + "',sysdate,sysdate,'Draft')", conn);
dr = cmd.ExecuteReader();
cmd = new OleDbCommand("insert into mail_exchange values('" + s_add + "',m_id.currval,sysdate,sysdate,'" + r_add + "')", conn);
dr = cmd.ExecuteReader();
cmd = new OleDbCommand("insert into draft values(m_id.currval)", conn);
dr = cmd.ExecuteReader();
dr.Close();
cmd = new OleDbCommand("select m_id.currval from dual", conn);
dr = cmd.ExecuteReader();
dr.Read();
muid = dr[0].ToString();
dr.Close();
conn.Close();
Label1.Text = "Message Saved. Your message id is " + muid;
Label1.Visible = true;
dr.Close();
conn.Close();
}
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 void addGame(Game obj, int num)
{
try
{
database = new OleDbConnection(connectionString);
database.Open();
string queryString = "INSERT INTO Game (Title, Description, Publisher, ReleaseDate, Rating, PurchasePrice, Copies) " +
"VALUES ('" + obj.Title + "', '" + obj.Description + "', '" + obj.Publisher + "', '" + obj.ReleaseDate + "', '" +
obj.Rating + "', '" + obj.Price + "', '" + obj.Copies + "')";
string queryString2 = "SELECT * FROM Game WHERE Title = '" + obj.Title + "'";
string queryString3;
OleDbCommand cmd = new OleDbCommand(queryString, database);
OleDbCommand cmd2 = new OleDbCommand(queryString2, database);
count = cmd.ExecuteNonQuery();
reader = cmd2.ExecuteReader();
Game temp = new Game();
reader.Read();
temp.Id = Int32.Parse(reader["ID"].ToString());
temp.Title = reader["Title"].ToString();
temp.Description = reader["Description"].ToString();
temp.Publisher = reader["Publisher"].ToString();
temp.ReleaseDate = reader["ReleaseDate"].ToString();
temp.Rating = reader["Rating"].ToString();
temp.Price = Double.Parse(reader["PurchasePrice"].ToString());
temp.Copies = Int32.Parse(reader["Copies"].ToString());
queryString3 = "INSERT INTO GameCopy (CheckedOut, GameID) " +
"VALUES (false, '" + temp.Id + "')";
OleDbCommand cmd3 = new OleDbCommand(queryString3, database);
for (int i = 0; i < num; i++)
count2 = cmd3.ExecuteNonQuery();
if (count >= 1)
MessageBox.Show(obj.Title + " has been added!");
else
MessageBox.Show("Error: Could not add game!");
reader.Close();
database.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
reader.Close();
database.Close();
}
}
public void PopularBlog(int RED_ID)
{
rsBlog = objBD.ExecutaSQL("EXEC site_psPostBlog " + RED_ID + " ");
if (rsBlog == null)
{
throw new Exception();
}
if (rsBlog.HasRows)
{
while (rsBlog.Read())
{
ulPost.InnerHtml += " <li><a href=\"/post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\" title=\"Titulo da postagem\">";
if (string.IsNullOrWhiteSpace(rsBlog["POS_IMAGEM"].ToString()) == false)
{
ulPost.InnerHtml += " <img src='/upload/imagens/blog/thumb-" + rsBlog["POS_IMAGEM"].ToString() + "'>";
}
else
{
ulPost.InnerHtml += " <img src='images/img-post-blog-padrao.png'>";
}
ulPost.InnerHtml += " </a>";
ulPost.InnerHtml += " <p class=\"titu_post_home\"><a href=\"post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\">" + objUtils.CortarString(true, 36, rsBlog["POS_TITULO"].ToString()) + "</a></p>";
ulPost.InnerHtml += " <p class=\"desc_post_home\"><a href=\"post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\">" + objUtils.RemoveHTML(objUtils.CortarString(true, 110, rsBlog["POS_TEXTO"].ToString())) + "</a></p>";
//ulPost.InnerHtml += " <p class=\"desc_post_home\"> </p>";
ulPost.InnerHtml += " <a href=\"/post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\" class=\"btn\">LEIA MAIS</a>";
ulPost.InnerHtml += " </li>";
}
}
rsBlog.Dispose();
rsBlog.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();
}
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 void mudarGaleria(int id)
{
rsGaleria = objBD.ExecutaSQL("select AFO_ID, AFO_TITULO, AFO_KEY from AlbumFotos where AFO_ID = "+id+" order by AFO_DH_CADASTRO desc");
if (rsGaleria == null)
{
throw new Exception();
}
if (rsGaleria.HasRows)
{
rsGaleria.Read();
retorno += "<object width=\"468\" height=\"297\">";
retorno += " <param name=\"flashvars\" value=\"offsite=true&lang=en-us&page_show_url=%2Fphotos%2Fbrincamusicais%2Fsets%2F" + rsGaleria["AFO_KEY"] + "%2Fshow%2F&page_show_back_url=%2Fphotos%2Fbrincamusicais%2Fsets%2F" + rsGaleria["AFO_KEY"] + "%2F&set_id=" + rsGaleria["AFO_KEY"] + "&jump_to=\"></param>";
retorno += " <param name=\"movie\" value=\"https://www.flickr.com/apps/slideshow/show.swf?v=1811922554\"></param>";
retorno += " <param name=\"allowFullScreen\" value=\"true\"></param>";
retorno += " <embed type=\"application/x-shockwave-flash\" src=\"https://www.flickr.com/apps/slideshow/show.swf?v=1811922554\" allowfullscreen=\"true\" flashvars=\"offsite=true&lang=en-us&page_show_url=%2Fphotos%2Fbrincamusicais%2Fsets%2F" + rsGaleria["AFO_KEY"] + "%2Fshow%2F&page_show_back_url=%2Fphotos%2Fbrincamusicais%2Fsets%2F" + rsGaleria["AFO_KEY"] + "%2F&set_id=" + rsGaleria["AFO_KEY"] + "&jump_to=\" width=\"468\" height=\"297\"></embed>";
retorno += "</object>";
retorno += "|";
retorno += ""+id+"";
retorno += "|";
}
Response.Write(retorno);
rsGaleria.Close();
rsGaleria.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
mySelectCommand.CommandType = CommandType.Text;
mySelectCommand.CommandText = "SELECT Name, FoodTypeID FROM FoodType ORDER BY Name DESC";
myReader = mySelectCommand.ExecuteReader();
bool notEoF;
//read first row from database
notEoF = myReader.Read();
//read row by row until the last row
if (ddlCategory.Items.Count == 0)
{
ddlCategory.Items.Add("All Categories");
while (notEoF)
{
ddlCategory.Items.Add(myReader["Name"].ToString());
ddlCategory.Items[ddlCategory.Items.Count - 1].Value = myReader["FoodTypeID"].ToString();
notEoF = myReader.Read();
}
}
myReader.Close();
if(!Page.IsPostBack)
{
getDB();
}
}
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;
}
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;
}
}
/// <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);
}
}
}
public void PopulaTela()
{
rsListar = objBD.ExecutaSQL("EXEC site_psCriacaoDocumentadasPorID '" + Request["CDO_ID"] + "' ");
if (rsListar == null)
{
throw new Exception();
}
if (rsListar.HasRows)
{
rsListar.Read();
CDO_ID.Attributes.Add("value", Request["CDO_ID"].ToString());
titu_criacoes.InnerHtml = objUtils.RemoveHTML(rsListar["CDO_TAREFA"].ToString());
criador.InnerHtml = rsListar["ADM_NOME"].ToString();
data.InnerHtml = rsListar["CDO_DATA"].ToString();
box_descritivo.InnerHtml = rsListar["CDO_DESCRITIVO"].ToString();
video_criacoes.Attributes.Add("src", "https://www.youtube.com/embed/" + rsListar["CDO_VIDEO"].ToString());
// aRelato.Attributes.Add("href", "/enviar-relato.aspx?CDO_ID=" + Request["CDO_ID"] + "");
relato_detalhe.InnerHtml = "<strong>" + rsListar["TOTAL_RELATOS"].ToString() + " Relatos Enviados</strong>";
totalComentarios.InnerHtml = rsListar["TOTAL_COMENTARIOS"].ToString() + " Comentário";
if (Convert.ToInt16(rsListar["TOTAL_COMENTARIOS"]) > 1)
{
totalComentarios.InnerHtml += "s";
}
}
else
{
Response.Redirect("/criacoes-documentadas");
}
rsListar.Close();
rsListar.Dispose();
}
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;
}
}
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;
}
}
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);
}
}
//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;
}
// 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);
}
}
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;
}
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();
}
//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);
}
}
public void AlterarDados(tbVendedorDTO vendedor)
{
String sSQL = "";
sSQL += "UPDATE tbVendedor SET dsNome = @dsNome, dtNascimento = @dtNascimento WHERE idVendedor = @idVendedor ";
conexao = (OleDbConnection)CriaConexaoOleDb();
command = new OleDbCommand(sSQL, conexao);
command.CommandType = CommandType.Text;
OleDbParameter parametro = command.Parameters.Add("@dsNome", OleDbType.VarChar);
parametro.Value = vendedor.dsNome;
parametro = command.Parameters.Add("@dtNascimento", OleDbType.Date);
parametro.Value = vendedor.dtNascimento;
parametro = command.Parameters.Add("@idVendedor", OleDbType.Integer);
parametro.Value = vendedor.idVendedor;
try
{
drOleDb = command.ExecuteReader();
drOleDb.Close();
conexao.Close();
}
catch (SystemException e)
{
erro = e.Message;
}
}
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;
}
}
private void gen_btn_Click(object sender, EventArgs e)
{
string department = comboBox1.Text;
sqlQuery = "SELECT * FROM EMPLOYEES WHERE DEPARTMENT LIKE '" + department + "' ORDER BY last_name asc";
cmd.CommandText = sqlQuery;
cmd.Connection = cn;
dr = cmd.ExecuteReader();
using (StreamWriter sw = new StreamWriter("C:/Users/Developer/Desktop/itpl project/itplProject/payrolls/payroll_"+ department +"_"+ DateTime.Now.ToString("mm-dd-yy")+".txt"))
{
sw.WriteLine("Report Generated at : " + DateTime.Now);
sw.WriteLine(" Department, Last Name, First Name, Salary");
sw.WriteLine("---------------------------------");
while (dr.Read())
{
sw.Write(dr["department"].ToString());
sw.Write(", "+ dr["last_name"].ToString());
sw.Write(", " + dr["first_name"].ToString());
sw.Write(", " + dr["salary"].ToString());
sw.WriteLine();
}
sw.WriteLine("---------------------------------");
sw.Close();
dr.Close();
this.Close();
MessageBox.Show("Check your File Directory!");
}
}
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);
}
protected void Button1_Click(object sender, EventArgs e)
{
string raw,s_add, message, heading,muid;
string[] r_add = new string[100];
int i;
s_add = Session["us_name"].ToString();
raw = TextBox1.Text;
heading = TextBox3.Text;
message = TextBox2.Text;
r_add=raw.Split(',');
rec_mail te = new rec_mail();
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
conn.Open();
if (file_name == null)
file_name = "NA";
cmd = new OleDbCommand("insert into messages values(m_id.nextval,'" + heading + "','" + message + "','" + file_name + "',sysdate,sysdate,'delivered')", conn);
dr = cmd.ExecuteReader();
dr.Close();
for (i = 0; i < r_add.Length; i++)
{
cmd = new OleDbCommand("insert into mail_exchange values('" + s_add + "',m_id.currval,sysdate,sysdate,'" + r_add[i].ToString() + "')", conn);
dr = cmd.ExecuteReader();
}
dr.Close();
cmd = new OleDbCommand("select m_id.currval from dual", conn);
dr = cmd.ExecuteReader();
dr.Read();
muid=dr[0].ToString();
dr.Close();
conn.Close();
Label1.Text = "Message Sent. Your message id is " +muid;
Label1.Visible = true;
}
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();
}
/// <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 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 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;
}
}
//protected override int Fill(DataTable dataTable, IDataReader dataReader) {
// return base.Fill(dataTable, dataReader);
//}
private int FillFromRecordset(object data, UnsafeNativeMethods.ADORecordsetConstruction recordset, string?srcTable, out bool incrementResultCount)
{
incrementResultCount = false;
IntPtr chapter; /*ODB.DB_NULL_HCHAPTER*/
object?result;
try
{
result = recordset.get_Rowset();
chapter = recordset.get_Chapter();
}
catch (Exception e)
{
// UNDONE - should not be catching all exceptions!!!
if (!ADP.IsCatchableExceptionType(e))
{
throw;
}
throw ODB.Fill_EmptyRecordSet("ADODBRecordSet", e);
}
if (null != result)
{
CommandBehavior behavior = (MissingSchemaAction.AddWithKey != MissingSchemaAction) ? 0 : CommandBehavior.KeyInfo;
behavior |= CommandBehavior.SequentialAccess;
OleDbDataReader?dataReader = null;
try
{
// initialized with chapter only since we don't want ReleaseChapter called for this chapter handle
ChapterHandle chapterHandle = ChapterHandle.CreateChapterHandle(chapter);
dataReader = new OleDbDataReader(null, null, 0, behavior);
dataReader.InitializeIRowset(result, chapterHandle, ADP.RecordsUnaffected);
dataReader.BuildMetaInfo();
incrementResultCount = (0 < dataReader.FieldCount);
if (incrementResultCount)
{
if (data is DataTable)
{
return(base.Fill((DataTable)data, dataReader));
}
else
{
return(base.Fill((DataSet)data, srcTable !, dataReader, 0, 0));
}
}
}
finally
{
dataReader?.Close();
}
}
return(0);
}
public void PopulaTela()
{
rsListar = objBD.ExecutaSQL("EXEC site_psCriacaoDocumentadasPorID '" + Request["CDO_ID"] + "' ");
if (rsListar == null)
{
throw new Exception();
}
if (rsListar.HasRows)
{
rsListar.Read();
titu_criacoes.InnerHtml = objUtils.RemoveHTML(rsListar["CDO_TAREFA"].ToString());
criador.InnerHtml = rsListar["ADM_NOME"].ToString();
data.InnerHtml = rsListar["CDO_DATA"].ToString();
box_descritivo.InnerHtml = rsListar["CDO_DESCRITIVO"].ToString();
divDevolutiva.InnerHtml = rsListar["CDO_DEVOLUTIVA"].ToString();
if (!string.IsNullOrWhiteSpace(rsListar["CDO_VIDEO"].ToString()))
{
video_criacoes.Attributes.Add("src", "https://www.youtube.com/embed/" + rsListar["CDO_VIDEO"].ToString());
}
else
{
titulovideo.Visible = false;
video_criacoes.Visible = false;
}
if (!string.IsNullOrWhiteSpace(rsListar["CDO_VIDEO_DEVOLUTIVA"].ToString()))
{
video_devolutiva.Attributes.Add("src", "https://www.youtube.com/embed/" + rsListar["CDO_VIDEO_DEVOLUTIVA"].ToString());
}
else
{
titulovideodevolutiva.Visible = false;
video_criacoesdevolutiva.Visible = false;
}
idCDO.Attributes.Add("value", Request["CDO_ID"].ToString());
idCDO1.Attributes.Add("value", Request["CDO_ID"].ToString());
relato_detalhe.InnerHtml = "<strong>" + rsListar["TOTAL_RELATOS"].ToString() + " Relatos Enviados</strong>";
totalComentarios.InnerHtml = "<a href='javascript:void(0)' onClick='verComentarios2(1," + Request["CDO_ID"] + ");'> " + rsListar["TOTAL_COMENTARIOS"].ToString() + " Comentário";
if (Convert.ToInt16(rsListar["TOTAL_COMENTARIOS"]) > 1)
{
totalComentarios.InnerHtml += "s";
}
totalComentarios.InnerHtml += "</a>";
}
else
{
Response.Redirect("/criacoes-documentadas");
}
rsListar.Close();
rsListar.Dispose();
}
public void PopulaBlog()
{
rsBlog = objBD.ExecutaSQL("EXEC site_PostBlogPorTitulo '" + Request["titulo"] + "' ");
if (rsBlog == null)
{
throw new Exception();
}
if (rsBlog.HasRows)
{
rsBlog.Read();
//facebook
// metaTitle.Content = "Projeto Brincadeiras Musicais da Palavra Cantada - Blog";
metaTitle.Content = "" + rsBlog["POS_TITULO"].ToString() + "";
metaImage.Content = "http://projetopalavracantada.net/images/logo-fb.png";
//metaDescription.Content = "" + rsBlog["POS_TITULO"].ToString() + "";
metaDescription.Content = "" + rsBlog["POS_TEXTO"].ToString() + "";
metaURL.Content = "http://projetopalavracantada.net/post/" + Request["titulo"] + "";
var USU_ID_BLOG = rsBlog["USU_ID"].ToString();
if (!string.IsNullOrWhiteSpace(USU_ID_BLOG))
{
var USU_ID_SESSAO = Session["usuId"].ToString();
if (USU_ID_BLOG == USU_ID_SESSAO)
{
Response.Redirect("../meu-post/" + Request["titulo"]);
}
}
// liFace.InnerHtml = "<iframe src=\"//www.facebook.com/plugins/like.php?href=http%3A%2F%2Fprojetopalavracantada.net%2Fpost%2F" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "&width&layout=button_count&action=like&show_faces=true&share=true&height=21&appId=404437276390840\" scrolling=\"no\" frameborder=\"0\" style=\"border:none; overflow:hidden; height:21px;\" allowTransparency=\"true\"></iframe>";
if (!string.IsNullOrWhiteSpace(rsBlog["RED_ID"].ToString()))
{
//breadcrumb
breadcrumb.InnerHtml = "<a href='/' title='Home'>Home</a> >> <strong><a href=\"/blog-regional\">Blog-Regional</a></strong> >> " + rsBlog["POS_TITULO"] + " ";
}
else
{
//breadcrumb
breadcrumb.InnerHtml = "<a href='/' title='Home'>Home</a> >> <strong>Blog</strong> >> " + rsBlog["POS_TITULO"] + " ";
}
if (string.IsNullOrWhiteSpace(rsBlog["POS_IMAGEM"].ToString()) == true)
{
imgPost.Attributes.Add("style", "display:none;");
}
//imagem
imgPost.Src = "/upload/imagens/blog/big-" + rsBlog["POS_IMAGEM"].ToString() + "";
logPost.InnerHtml += "Publicado por <strong><i>" + rsBlog["USU_NOME"] + rsBlog["ADM_NOME"] + "</i></strong> em <strong><i>" + rsBlog["POS_DH_PUBLICACAO"].ToString() + "</i></strong> na categoria: <strong><i>" + rsBlog["PCA_TITULO"].ToString() + "</i></strong><br/><br/>";
//Texto
txtPost.InnerHtml += "<p class='tit_post'>" + rsBlog["POS_TITULO"] + "</p>";
txtPost.InnerHtml += "" + rsBlog["POS_TEXTO"].ToString() + "";
//liGPlus.InnerHtml = "<div class='g-plus' data-action='share' data-annotation='bubble' data-href='href=\"/post/" + objUtils.GerarURLAmigavel(rsBlog["POS_TITULO"].ToString()) + "\"'></div>";
}
rsBlog.Close();
rsBlog.Dispose();
}
public void FiltrarPesquisa(string RED_ID, string CDO_TAREFA)
{
rsLista = objBD.ExecutaSQL("EXEC admin_psCriacaoDocumentadaFiltro '" + RED_ID + "', '" + CDO_TAREFA + "'");
if (rsLista == null)
{
throw new Exception();
}
string resposta = "";
if (rsLista.HasRows)
{
resposta += " <thead>";
resposta += " <tr>";
resposta += " <th>Data</th>";
resposta += " <th style=\"width:300px;\">Proposta</th>";
resposta += " <th style=\"width:200px;\">Rede</th>";
resposta += " <th style=\"width:200px;\">Status</th>";
resposta += " <th style=\"width:85px;\">Ações</th>";
resposta += " </tr>";
resposta += " </thead>";
while (rsLista.Read())
{
resposta += " <tr id='tr_" + rsLista["CDO_ID"].ToString() + "' class=\"\">";
resposta += " <td>" + rsLista["CDO_DATA"].ToString() + "</td>";
resposta += " <td>" + objUtils.CortarString(true, 90, rsLista["CDO_TAREFA"].ToString()) + "</td>";
resposta += " <td>" + rsLista["RED_NOME"].ToString() + "</td>";
if (rsLista["CDO_STATUS"].ToString() == "Ativa")
{
resposta += " <td><select class='input' onchange='arquivar(" + rsLista["CDO_ID"].ToString() + ", this);'><option value='Ativa' selected='selected'>Ativa</option><option value='Arquivada'>Arquivada</option></select></td>";
}
else
{
resposta += " <td><select class='input' onchange='arquivar(" + rsLista["CDO_ID"].ToString() + ", this);'><option value='Ativa'>Ativa</option><option selected='selected' value='Arquivada'>Arquivada</option></select></td>";
}
resposta += " <td><ul class=\"icons_table\"><li><a id='" + rsLista["CDO_ID"].ToString() + "' onclick='popularFormulario(this.id);' href=\"javascript:void(0)\" class=\"img_del\"><img src=\"images/editar.png\"></a></li><li><a id='" + rsLista["CDO_ID"].ToString() + "' onclick='excluir(this.id);' href=\"javascript:void(0)\" class=\"img_del\"><img src=\"images/lixo.png\"></a></li></ul>";
resposta += " </tr>";
}
resposta += " </tbody>";
}
else
{
resposta += " <thead>";
resposta += " <tr>";
resposta += " <td colspan=\"5\">Nenhum resultado para esta pesquisa</td>";
resposta += " </tr>";
resposta += " </thead>";
}
Response.Write(resposta);
Response.End();
rsLista.Close();
rsLista.Dispose();
}
/// <summary>
/// 执行sql
/// </summary>
/// <param name="strSql"></param>
/// <param name="strDataSet"></param>
/// <returns></returns>
public int ExecQuery(string strSql, ref string strDataSet, string strXSLFileName)
{
this.command.Connection = this.con as OleDbConnection;
this.command.CommandType = System.Data.CommandType.Text;
this.command.Parameters.Clear();
this.command.CommandText = strSql + "";
try
{
this.TempReader1 = this.command.ExecuteReader();
XmlDocument doc = new XmlDocument();
XmlNode root;
XmlElement node, row;
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);
}
root = doc.CreateElement("Table");
doc.AppendChild(root);
while (this.TempReader1.Read())
{
row = doc.CreateElement("Row");
for (int i = 0; i < this.TempReader1.FieldCount; i++)
{
node = doc.CreateElement("Column");
node.SetAttribute("Name", this.TempReader1.GetName(i).ToString());
node.InnerText = this.TempReader1[i].ToString() + "";
row.AppendChild(node);
}
root.AppendChild(row);
}
strDataSet = doc.OuterXml;
TempReader1.Close();
}
catch (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.ErrorException = ex.InnerException + "+ " + ex.Source;
this.ErrCode = strSql;
this.WriteErr();
return(-1);
}
WriteDebug("执行查询sql语句！" + strSql);
return(0);
}
public Member CheckLogin(string _userName, string _password)
{
Member memer = null;
try
{
Conn = db.openConn();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append(" SELECT ID,UserName,PasswordMember,Email,MemberType FROM tbMember ");
sb.Append(" WHERE (UserName='******')");
sb.Append(" AND (PasswordMember='" + _password + "')");
string sql;
sql = sb.ToString();
com = new OleDbCommand();
com.CommandText = sql;
com.CommandType = CommandType.Text;
com.Connection = Conn;
dr = com.ExecuteReader();
if (dr.HasRows)
{
DataTable dt = new DataTable();
dt.Load(dr);
foreach (DataRow drw in dt.Rows)
{
memer = new Member();
memer.ID = Convert.ToInt32(drw["ID"].ToString());
memer.UserName = Convert.ToString (drw["UserName"].ToString());
memer.Password = Convert.ToString(drw["PasswordMember"].ToString());
memer.Email = Convert.ToString(drw["Email"].ToString());
memer.MemmerType = Convert.ToInt32(drw["MemberType"].ToString());
}
}
dr.Close();
}
catch (Exception ex)
{
Conn.Close();
return null;
throw ex;
}
finally
{
Conn.Close();
}
return memer;
}
public static System.Data.DataTable getTable(string 参数_数据库路径, string 参数_SQL语句)
{
//初始化
System.Data.DataTable dt = new System.Data.DataTable();
try
{
//1、建立连接 C#操作Access之读取mdb
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + 参数_数据库路径 + ";";
System.Data.OleDb.OleDbConnection odcConnection = new System.Data.OleDb.OleDbConnection(strConn);
//2、打开连接 C#操作Access之读取mdb
odcConnection.Open();
//建立SQL查询
System.Data.OleDb.OleDbCommand odCommand = odcConnection.CreateCommand();
//3、输入查询语句 C#操作Access之读取mdb
odCommand.CommandText = 参数_SQL语句;
//建立读取
System.Data.OleDb.OleDbDataReader odrReader = odCommand.ExecuteReader();
//查询并显示数据
int size = odrReader.FieldCount;
for (int i = 0; i < size; i++)
{
//Console.WriteLine("{0} {1}", "列", odrReader.GetName(i).ToString());
dt.Columns.Add(odrReader.GetName(i).ToString(), typeof(string));
}
while (odrReader.Read())
{
System.Data.DataRow dr = dt.NewRow();
for (int i = 0; i < size; i++)
{
//Console.WriteLine("{0} {1}", odrReader.GetName(i).ToString(), odrReader[odrReader.GetName(i)].ToString());
dr[odrReader.GetName(i).ToString()] = odrReader[odrReader.GetName(i)].ToString();
}
dt.Rows.Add(dr);
}
//关闭连接 C#操作Access之读取mdb
odrReader.Close();
odcConnection.Close();
return(dt);
}
catch
{
return(dt);
}
}
public void PopulaExcluidos()
{
divExcluidos.InnerHtml = "<table class=\"table\" id=\"tabela\" cellspacing=\"0\">";
rsLista = objBD.ExecutaSQL("EXEC admin_psRedesPorAtivo 0");
if (rsLista == null)
{
throw new Exception();
}
if (rsLista.HasRows)
{
divExcluidos.InnerHtml += " <thead>";
divExcluidos.InnerHtml += " <tr>";
divExcluidos.InnerHtml += " <th style=\"width:8px;\">ID</th>";
divExcluidos.InnerHtml += " <th>Titulo</th>";
divExcluidos.InnerHtml += " <th>Cidade</th>";
divExcluidos.InnerHtml += " <th>UF</th>";
divExcluidos.InnerHtml += " <th>Data de Criação</th>";
divExcluidos.InnerHtml += " <th>Quantidade de Usuários</th>";
divExcluidos.InnerHtml += " <th style=\"width:71px;\">Ações</th>";
divExcluidos.InnerHtml += " </tr>";
divExcluidos.InnerHtml += " </thead>";
divExcluidos.InnerHtml += " <tbody>";
while (rsLista.Read())
{
divExcluidos.InnerHtml += " <tr id='tr_" + rsLista["RED_ID"].ToString() + "' class=\"\">";
divExcluidos.InnerHtml += " <td>" + rsLista["RED_ID"].ToString() + "</td>";
divExcluidos.InnerHtml += " <td>" + rsLista["RED_TITULO"].ToString() + "</td>";
divExcluidos.InnerHtml += " <td>" + rsLista["RED_CIDADE"].ToString() + "</td>";
divExcluidos.InnerHtml += " <td>" + rsLista["RED_UF"].ToString() + "</td>";
divExcluidos.InnerHtml += " <td>" + rsLista["RED_DATA_CRIACAO"].ToString() + "</td>";
divExcluidos.InnerHtml += " <td>" + rsLista["RED_QTD_USUARIO"].ToString() + "</td>";
divExcluidos.InnerHtml += " <td><a href=\"javascript:void(0)\" id='" + rsLista["RED_ID"].ToString() + "' onclick='restoreRede(this.id);' class=\"img_del\"><img src=\"images/restore.png\"></a>";
divExcluidos.InnerHtml += " </tr>";
}
divExcluidos.InnerHtml += " </tbody>";
}
else
{
divExcluidos.InnerHtml += " <thead>";
divExcluidos.InnerHtml += " <tr>";
divExcluidos.InnerHtml += " <th>Nenhum registro cadastrado até o momento!</th>";
divExcluidos.InnerHtml += " </tr>";
divExcluidos.InnerHtml += " </thead>";
}
rsLista.Close();
rsLista.Dispose();
divExcluidos.InnerHtml += "</table>";
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtCompanyName.Text == string.Empty)
{
MessageBox.Show("Please enter company name", "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCompanyName.Focus();
return;
}
try
{
con = new OleDbConnection(cs);
con.Open();
var ct = "select CompanyName from Company where CompanyName='" + txtCompanyName.Text + "'";
cmd = new OleDbCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
MessageBox.Show("มีชื่อผู้ผลิตนี้อยู่แล้ว", "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCompanyName.Text = string.Empty;
txtCompanyName.Focus();
if ((rdr != null))
{
rdr.Close();
}
return;
}
con = new OleDbConnection(cs);
con.Open();
var cb = "insert into Company(CompanyName) VALUES ('" + txtCompanyName.Text + "')";
cmd = new OleDbCommand(cb);
cmd.Connection = con;
cmd.ExecuteReader();
con.Close();
MessageBox.Show("บันทึกข้อมูลสำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
Autocomplete();
btnSave.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ล้มเหลว", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 关闭数据库连接
/// </summary>
public static void Close(OleDbDataReader dr)
{
if (dr != null)
{
if ( !dr.IsClosed )
{
dr.Close();
}
dr.Dispose();
dr = null;
}
}
public void PopulaLista()
{
string objetolista = "";
objetolista = "<table class=\"table\" id=\"tabela\" cellspacing=\"0\">";
rsLista = objBD.ExecutaSQL("select * from SobreProjeto where SOB_ID = 2");
if (rsLista == null)
{
throw new Exception();
}
if (rsLista.HasRows)
{
objetolista += " <thead>";
objetolista += " <tr>";
objetolista += " <th style=\"width:60px;\">ID</th>";
objetolista += " <th style=\"width:600px;\">Titulo</th>";
objetolista += " <th style=\"width:90px;\">Ações</th>";
objetolista += " </tr>";
objetolista += " </thead>";
objetolista += " <tbody>";
while (rsLista.Read())
{
objetolista += " <tr id='tr_" + rsLista["SOB_ID"].ToString() + "' class=\"\">";
objetolista += " <td>" + rsLista["SOB_ID"].ToString() + "</td>";
objetolista += " <td>" + rsLista["SOB_TITULO"].ToString() + "</td>";
objetolista += " <td><ul class=\"icons_table\"><li><a href=\"javascript:void(0)\" id='" + rsLista["SOB_ID"].ToString() + "' onclick='popularFormulario(this.id);' class=\"img_edit\"><img src=\"images/editar.png\"></a></li></ul>";
objetolista += " </tr>";
}
objetolista += " </tbody>";
}
else
{
objetolista += " <thead>";
objetolista += " <tr>";
objetolista += " <th>Nenhum registro cadastrado até o momento!</th>";
objetolista += " </tr>";
objetolista += " </thead>";
}
rsLista.Close();
rsLista.Dispose();
objetolista += "</table>";
divLista.InnerHtml = objetolista;
}
public static List <string> GetReqInfo(int reqID)
{
//This Function is used for getting Req+ID info for populating rows. Each item pulls out into a list that can be referenced individually.
{
//make an Oledbcommandobject
OleDbCommand cmd = null;
//make an Oledbdatareader
System.Data.OleDb.OleDbDataReader Reader = null;
//Making Query
string query = "SELECT * FROM Requests WHERE Req_ID =" + reqID;
//connects to the database and catches if there is a problem connecting
List <string> reqIDList = new List <string>(); //Initializing list so things can be stored in it
cmd = new OleDbCommand(query, 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
{
reqIDList.Add(Convert.ToString(Reader["Travel"]));
reqIDList.Add(Convert.ToString(Reader["Est_Total_Cost"]));
reqIDList.Add(Convert.ToString(Reader["Emp_ID"]));
reqIDList.Add(Convert.ToString(Reader["Description"]));
reqIDList.Add(Convert.ToString(Reader["Begin_Date"]));
reqIDList.Add(Convert.ToString(Reader["End_Date"]));
reqIDList.Add(Convert.ToString(Reader["Decision_Date"]));
reqIDList.Add(Convert.ToString(Reader["Status"]));
reqIDList.Add(Convert.ToString(Reader["Current_Approval"]));
}
Reader.Close();
}
catch (InvalidOperationException)
{
Connection.Close();
}
Reader.Close();
return(reqIDList);
}
}
public static void GetAllProtocolIP()
{
string strSql;
try
{
tVehInfo nVehInfo = null;
System.Data.OleDb.OleDbCommand GetProTypeCommand = null;
System.Data.OleDb.OleDbDataReader GetProTypeReader = null;
strSql = "select distinct IpAddress,type,TaxiNo from vehicle";
GetProTypeCommand = myConn.CreateCommand();
GetProTypeCommand.CommandText = strSql;
GetProTypeReader = GetProTypeCommand.ExecuteReader();
CarInfo_Hash = new Hashtable();
while (GetProTypeReader.Read())
{
nVehInfo = new tVehInfo();
nVehInfo.ipaddress = GetProTypeReader["IpAddress"].ToString();
if (GetProTypeReader["type"].ToString().ToUpper() == "TCP")
{
nVehInfo.isendtype = 1;
}
else
{
nVehInfo.isendtype = 0;
}
if (CarInfo_Hash.ContainsKey((string)GetProTypeReader["IpAddress"]))
{
CarInfo_Hash[(string)GetProTypeReader["IpAddress"]] = nVehInfo;
}
else
{
CarInfo_Hash.Add((string)GetProTypeReader["IpAddress"], nVehInfo);
}
}
GetProTypeReader.Close();
GetProTypeReader = null;
GetProTypeCommand.Dispose();
}
catch (Exception ce)
{
GprsServer.WriteErrLog("GetAllProtocolIP", ce.Message.ToString() + ce.StackTrace.ToString());
if (myConn.State.ToString() == "Closed")
{
Conndb();
}
return;
}
}
/// <summary>
/// 执行sql语句 重载
/// </summary>
/// <param name="strSql"></param>
/// <param name="strDataSet">返回DataSet xml</param>
/// <returns></returns>
public int ExecQuery(string strSql, ref string strDataSet)
{
this.command.Connection = this.con as OleDbConnection;
this.command.CommandType = System.Data.CommandType.Text;
this.command.Parameters.Clear();
this.command.CommandText = strSql + "";
try
{
this.TempReader1 = this.command.ExecuteReader();
XmlDocument doc = new XmlDocument();
XmlNode root;
XmlNode node, table;
root = doc.CreateElement("DataSet");
doc.AppendChild(root);
while (this.TempReader1.Read())
{
table = doc.CreateElement("Table");
for (int i = 0; i < this.TempReader1.FieldCount; i++)
{
node = doc.CreateElement(this.TempReader1.GetName(i).ToString());
node.InnerText = this.TempReader1[i].ToString() + "";
table.AppendChild(node);
}
root.AppendChild(table);
}
strDataSet = doc.OuterXml;
TempReader1.Close();
}
catch (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.ErrorException = ex.InnerException + "+ " + ex.Source;
this.ErrCode = strSql;
this.WriteErr();
return(-1);
}
WriteDebug("执行查询sql语句！" + strSql);
return(0);
}
private int FillFromRecord(object data, UnsafeNativeMethods.ADORecordConstruction record, string srcTable)
{
object?result;
try
{
result = record.get_Row();
}
catch (Exception e)
{
// UNDONE - should not be catching all exceptions!!!
if (!ADP.IsCatchableExceptionType(e))
{
throw;
}
throw ODB.Fill_EmptyRecord("adodb", e);
}
if (null != result)
{
CommandBehavior behavior = (MissingSchemaAction.AddWithKey != MissingSchemaAction) ? 0 : CommandBehavior.KeyInfo;
behavior |= CommandBehavior.SequentialAccess | CommandBehavior.SingleRow;
OleDbDataReader?dataReader = null;
try
{
dataReader = new OleDbDataReader(null, null, 0, behavior);
dataReader.InitializeIRow(result, ADP.RecordsUnaffected);
dataReader.BuildMetaInfo();
if (data is DataTable)
{
return(base.Fill((DataTable)data, dataReader));
}
else
{
return(base.Fill((DataSet)data, srcTable, dataReader, 0, 0));
}
}
finally
{
dataReader?.Close();
}
}
return(0);
}
/// <summary>
/// 输出blob
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public byte[] OutputBlob(string strSql)
{
//string block="SELECT image from test_image WHERE id = 100";//INTO :b
// Set command to create Anonymous PL/SQL Block
command.CommandText = strSql + "";
command.CommandType = System.Data.CommandType.Text;
System.Data.OleDb.OleDbDataReader reader;
// The anonymous PL/SQL block retrieves the images as an output parameter
try
{
//cmd.ExecuteNonQuery();
reader = command.ExecuteReader();
}
catch (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.ErrorException = ex.InnerException + "+ " + ex.Source;
this.WriteErr();
return(null);
}
reader.Read();
// Create a byte array
byte[] byteData = new byte[0];
// fetch the value of Oracle parameter into the byte array
//byteData = (byte[])(cmd.Parameters[0].Value);
try
{
byteData = (byte[])(reader[0]);
}
catch {}
reader.Close();
return(byteData);
}
/// <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>
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
//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'"
using (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;
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);
}
}
private static bool checkTableExist(string tableName, System.Data.OleDb.OleDbConnection dbconn)
{
try
{
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand("select * from " + tableName, dbconn);
System.Data.OleDb.OleDbDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.Default);
reader.Close();
return(true);
}
catch (System.Data.OleDb.OleDbException exc)
{
// Older version than 1.1
if (exc.Message.IndexOf("cannot find the input table") == -1)
{
Trace.WriteLine("Ops, unknown System.Data.OleDb.OleDbException while checking for db upgrade:\r\n" +
exc.ToString());
}
return(false);
}
}
private string GetDBImage(int Index, Accusoft.ImagXpressSdk.ImageXView iXView)
{
string ImageName;
long retter;
int bufferSize = 16777216;
byte[] outByte = new byte[bufferSize - 1];
string stringConnection = (strProvider + strDataSource);
string stringSQL = "SELECT * FROM [tblImages]";
dbConnection.ConnectionString = (strProvider + strDataSource);
dbConnection.Open();
System.Data.OleDb.OleDbCommand dbCommandGet = new OleDbCommand(stringSQL, dbConnection);
System.Data.OleDb.OleDbDataReader dbReader = dbCommandGet.ExecuteReader(CommandBehavior.Default);
int i = 0;
while ((i <= Index))
{
dbReader.Read();
i = (i + 1);
}
retter = dbReader.GetBytes(2, 0, outByte, 0, bufferSize);
MemoryStream stmBLOBData = new MemoryStream(outByte);
ImageName = dbReader["ImageName"].ToString();
dbReader.Close();
try
{
iXView.Image = Accusoft.ImagXpressSdk.ImageX.FromStream(imagXpress1, stmBLOBData, loLoadOptions);
}
catch (Accusoft.ImagXpressSdk.ImagXpressException ex)
{
AccusoftError(ex, lblError);
}
if ((dbConnection.State == ConnectionState.Open))
{
dbConnection.Close();
dbConnection.Dispose();
}
return(ImageName);
}
public static string getStr(string 参数_数据库路径, string 参数_SQL语句)
{
//初始化
string 返回文本 = "";
try
{
//1、建立连接 C#操作Access之读取mdb
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + 参数_数据库路径 + ";";
System.Data.OleDb.OleDbConnection odcConnection = new System.Data.OleDb.OleDbConnection(strConn);
//2、打开连接 C#操作Access之读取mdb
odcConnection.Open();
//建立SQL查询
System.Data.OleDb.OleDbCommand odCommand = odcConnection.CreateCommand();
//3、输入查询语句 C#操作Access之读取mdb
odCommand.CommandText = 参数_SQL语句;
//建立读取
System.Data.OleDb.OleDbDataReader odrReader = odCommand.ExecuteReader();
//查询并显示数据
int size = odrReader.FieldCount;
odrReader.Read();
返回文本 = odrReader[odrReader.GetName(0)].ToString();
//关闭连接 C#操作Access之读取mdb
odrReader.Close();
odcConnection.Close();
return(返回文本);
}
catch
{
return(返回文本);
}
}
private void SaveColumnValues(OleDb.OleDbConnection conn, List <string> indexNames, ref Dictionary <string, int> dictionary)
{
//Call ReadColumnNames first!
int indexNumber = 0;
//just making sure column names are populated
if (indexNames.Count() == 0)
{
return;
}
foreach (string index in indexNames)
{
//no need to prepare this command
OleDb.OleDbCommand selectAll = new OleDb.OleDbCommand("SELECT `" + index + "` FROM `Sheet1$`", conn);
try {
OleDb.OleDbDataReader reader = selectAll.ExecuteReader();
while (reader.Read())
{
//potentially throws invalid cast exception (null)
if (!reader.IsDBNull(0))
{
string word = reader.GetString(0);
//clean word
string cleanWord = Globals.ThisAddIn.HighlightManager.CleanWord(word);
//save word
if (Globals.ThisAddIn.HighlightManager.CanAddToDictionary(cleanWord))
{
dictionary.Add(cleanWord, indexNumber);
}
}
}
reader.Close();
} catch (OleDb.OleDbException)
{
Forms.MessageBox.Show(Strings.error, Strings.errorCaption);
}
indexNumber++;
}
}
static void Main(string[] args)
{
var connection = new oleDB.OleDbConnection("Data Source=\"e:\\vic.mdb\";User ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";");
connection.Open();
var command = new oleDB.OleDbCommand("SELECT * From [Phones]", connection);
oleDB.OleDbDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
Console.WriteLine("Таблица БД:\n");
while (reader.Read() == true)
{
Console.WriteLine("{0,-3} {1, -15} {2, -15}", reader.GetValue(0), reader.GetValue(1), reader.GetValue(2));
}
reader.Close();
connection.Close();
Console.ReadKey();
}
/// <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>
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);
}
}
private static List <string> comboboxFiller(string String1)
{
var Connect = new OleDiBi.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Connect.Open();
var data = new List <string>();
OleDiBi.OleDbCommand COM = new OleDiBi.OleDbCommand(String1, Connect);
OleDiBi.OleDbDataReader RESULT = COM.ExecuteReader();
while (RESULT.Read() == true)
{
var map = RESULT[0].ToString();
data.Add(map);
}
RESULT.Close();
Connect.Close();
return(data);
}
//method to return id value
public static string GetID(String SQLquery)
{
//make an Oledbcommandobject
OleDbCommand cmd = null;
//make an Oledbdatareader
System.Data.OleDb.OleDbDataReader Reader = null;
string PrimaryKeyID = null;
//connects to the database and catches if there is a problem connecting
cmd = new OleDbCommand(SQLquery, Connection);
try
{
Reader = cmd.ExecuteReader();
}
catch (InvalidOperationException)
{
Connection.Close();
}
Reader.Close();
return(PrimaryKeyID);
}
public static void Deletar_Registro(System.String Codigo)
{
string myDeleteQuery = "DELETE FROM Produto WHERE Codigo='" + Codigo + "'";
OleDbCommand myCommand2 = new OleDbCommand(myDeleteQuery);
myCommand2.Connection = Geral.ECF.myConnection;
myConnection.Close();
myConnection.Open();
myCommand2.ExecuteNonQuery();
//Geral.ECF.myReader = Geral.ECF.myCommand.ExecuteReader();
/*OleDbCommand myCommand2 = new OleDbCommand(myDeleteQuery);
* myCommand2.Connection = myConnection;
* myConnection.Open();
* myCommand2.ExecuteNonQuery();
* myCommand2.Connection.Close();
*/
myReader.Close();
myConnection.Close();
}
/// <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 ...
//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'"
using (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.String sql = getMessageListQuery(version);
//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 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]));
}
//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'"
rs.Close();
NormativeDatabase.Instance.returnConnection(conn);
if (messages.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 + " 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);
}
}
}
private void Form1_Load(object sender, System.EventArgs e)
{
//***The SetSolutionName, SetSolutionKey and possibly the SetOEMLicenseKey methods must be called to distribute the runtime***
//imagXpress1.Licensing.SetSolutionName("YourSolutionName");
//imagXpress1.Licensing.SetSolutionKey(12345,12345,12345,12345);
//imagXpress1.Licensing.SetOEMLicenseKey("1.0.AStringForOEMLicensingContactAccusoftSalesForMoreInformation�");
// Because in this sample the ImageX object is always located in the ImageXView
// tell the ImageXView component to dispose of the ImageX object when itself is
// disposed. Otherwise, we would have to dispose of the ImageX object in the Form's
// Dispose method before the components.Dispose() section.
imageXView1.AutoImageDispose = true;
int bufferSize = 16777216;
byte[] outByte = new byte[bufferSize - 1];
string stringConnection = (strProvider + strDataSource);
string stringSQL = "SELECT * FROM [tblImages]";
try
{
//Create a new load options object so we can recieve events from the images we load
loLoadOptions = new Accusoft.ImagXpressSdk.LoadOptions();
}
catch (Accusoft.ImagXpressSdk.ImagXpressException ex)
{
AccusoftError(ex, lblError);
}
// Note that this database does not support 64-bit so the target platform
// for this project must be set to x86
strCurrentDatabase = Application.StartupPath + "..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\..\\Common\\Images\\DatabaseInteraction.mdb";
String strCurrentDir = System.IO.Path.Combine(Application.StartupPath, @"..\..\..\..\..\..\..\..\..\..\Common\Images\");
if (System.IO.Directory.Exists(strCurrentDir))
{
System.IO.Directory.SetCurrentDirectory(strCurrentDir);
}
strCurrentDir = System.IO.Directory.GetCurrentDirectory();
strDataSource = "Data Source=" + strCurrentDatabase;
stringSQL = "SELECT * FROM [tblImages]";
imageXView1.AutoScroll = true;
dbConnection = new OleDbConnection();
dbInsertCommand = new System.Data.OleDb.OleDbCommand();
dbInsertCommand.CommandText = "INSERT INTO tblImages([Image], ImageName) VALUES (?, ?)";
dbInsertCommand.Connection = dbConnection;
dbInsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Image", System.Data.OleDb.OleDbType.VarBinary, 0, "Image"));
dbInsertCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("ImageName", System.Data.OleDb.OleDbType.VarWChar, 255, "ImageName"));
dbDeleteCommand = new System.Data.OleDb.OleDbCommand();
dbUpdateCommand = new System.Data.OleDb.OleDbCommand();
dbDeleteCommand.CommandText = "DELETE FROM tblImages WHERE (ID = ?) AND (ImageName = ? OR ? IS NULL AND ImageName IS NULL)";
dbDeleteCommand.Connection = dbConnection;
dbDeleteCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ID", System.Data.DataRowVersion.Original, null));
dbDeleteCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ImageName", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ImageName", System.Data.DataRowVersion.Original, null));
dbDeleteCommand.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_ImageName1", System.Data.OleDb.OleDbType.VarWChar, 255, System.Data.ParameterDirection.Input, false, ((byte)(0)), ((byte)(0)), "ImageName", System.Data.DataRowVersion.Original, null));
dbConnection.ConnectionString = strProvider + strDataSource;
dbConnection.Open();
System.Data.OleDb.OleDbCommand dbCommandGet = new OleDbCommand(stringSQL, dbConnection);
System.Data.OleDb.OleDbDataReader dbReader = dbCommandGet.ExecuteReader(CommandBehavior.Default);
int i = 0;
while (dbReader.Read())
{
CmbBxImages.Items.Add(dbReader["ImageName"].ToString());
if ((i == 0))
{
CmbBxImages.Text = dbReader["ImageName"].ToString();
}
i = (i + 1);
}
dbReader.Close();
dbConnection.Close();
// Load the first Image in the List
GetDBImage(0, imageXView1);
bFormLoadComplete = true;
}
protected void Page_Load(object sender, System.EventArgs e)
{
string formato_html;
if (Session["loggeado"] == null)
{
Response.Redirect(System.Configuration.ConfigurationManager.AppSettings["urlRoot"].ToString() + "/ingreso.aspx", true);
}
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["BaseSqlServer"].ConnectionString;
string formato_id = Session["formato_id"].ToString();
string archivo_excel = Session["archivo_excel"].ToString();
using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
{
string strQuery = "SELECT html FROM matricula.mailxls_formato WHERE id = " + formato_id + ";";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strQuery, connection);
connection.Open();
System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
formato_html = dr[0].ToString();
connection.Close();
Session.Add("formato_html", formato_html);
}
System.Data.OleDb.OleDbConnection cnExcel = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(archivo_excel) + ";Extended Properties=Excel 8.0");
System.Data.OleDb.OleDbCommand cmdExcel = new System.Data.OleDb.OleDbCommand("select * from [Hoja1$]", cnExcel);
cnExcel.Open();
System.Data.OleDb.OleDbDataReader drExcel = cmdExcel.ExecuteReader();
int numero_campos = drExcel.FieldCount;
string[] nombre_campos = new string[numero_campos];
int j = 1;
for (int i = 0; i < numero_campos; i++)
{
nombre_campos[i] = "{" + drExcel.GetName(i).Trim() + "}";
}
if (drExcel.Read())
{
for (int i1 = 0; i1 < numero_campos; i1++)
{
formato_html = formato_html.Replace(nombre_campos[i1], drExcel[i1].ToString());
}
}
while (drExcel.Read())
{
if (drExcel[0].ToString() != "")
{
j++;
}
}
lblFormato.Text = "<p align=\"right\">" + numero_campos.ToString() + " campos ha reemplazar.<br />" + j.ToString() + " destinatarios.</p>";
drExcel.Close();
cnExcel.Close();
if (formato_html.Contains("\\'"))
{
formato_html = formato_html.Replace("\\'", "'");
}
if (formato_html.Contains("\\\""))
{
formato_html = formato_html.Replace("\\\"", "\"");
}
formato_html = Server.HtmlDecode(formato_html);
lblFormato.Text += formato_html;
}
//Image mainBackGroundImage;
public frmMainForm()
{
byte i = 0;
PrivateDataEncode pde = new PrivateDataEncode();
myConn = new OleDbConnection();
myCom = new OleDbCommand();
myCom.CommandText = "Select M_ID, M_Name, M_Type, M_Description From tblMasterInfor ORDER BY M_Type";
myCom.Connection = myConn;
myConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;Jet OLEDB:Database Password=whatthehellisgoingon";
try{
myConn.Open();
}catch (Exception e)
{
MessageBox.Show(ERROR_WHILE_LOADING_DATABASE + e.Message.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Dispose();
Application.Exit();
}
myReader = myCom.ExecuteReader();
System.ComponentModel.ComponentResourceManager resources1 = new System.ComponentModel.ComponentResourceManager(typeof(frmMainForm));
InitializeComponent();
if (myReader.HasRows)
{
while (myReader.Read())
{
this.tbTmp4LoadDynamic = new System.Windows.Forms.ToolStripButton();
this.tbTmp4LoadDynamic.Overflow = ToolStripItemOverflow.Never;
if (myReader.GetByte(2) == frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_DIAGNOSIS)
{
try{
this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\diagnosis.bmp");
}catch (System.IO.FileNotFoundException) {}
}
else if (myReader.GetByte(2) == frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_TREATMENT)
{ //treatment
try{
this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\treatment.bmp"); //career.bmp
}catch (System.IO.FileNotFoundException) {}
}
else
{
try{
this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\career.bmp");
}catch (System.IO.FileNotFoundException) {}
}
//this.tbTmp4LoadDynamic.Image = ((System.Drawing.Image)(resources.GetObject("mnuBtnPatientRecord.Image")));
this.tbTmp4LoadDynamic.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.tbTmp4LoadDynamic.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tbTmp4LoadDynamic.Name = "tb" + myReader.GetValue(0).ToString();
this.tbTmp4LoadDynamic.Size = new System.Drawing.Size(90, 40);
this.tbTmp4LoadDynamic.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.tbTmp4LoadDynamic.Click += new System.EventHandler(this.DynamicToolBarClick);
this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tbTmp4LoadDynamic.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.ImageAndText;
this.tbTmp4LoadDynamic.Text = myReader.GetString(1);
this.tbTmp4LoadDynamic.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageBeforeText;
this.tbTmp4LoadDynamic.DoubleClick += new EventHandler(DynamicToolBarClick);
sepTmp = new ToolStripSeparator();
sepTmp.Name = "auto" + i++.ToString();
sepTmp.Size = new System.Drawing.Size(6, 1);
this.tbMainToolBar.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { sepTmp, tbTmp4LoadDynamic });
} // myReader.Read()
} //myReader.HasRows
myReader.Close();
this.frmMainForm_SizeChanged(null, null);
}
public override bool Check(ref List <Error> checkResult)
{
//System.Diagnostics.Stopwatch MyWatch = new System.Diagnostics.Stopwatch();
//MyWatch.Start();
System.Data.OleDb.OleDbDataReader reader = null;
try
{
DataTable pRecordset = new DataTable();
if (m_structPara.strScript == "行政区层中行政区代码与行政区名称不匹配")
{
string strTemp = "select objectid,BSM,xzqdm, xzqmc,qsdwmc from(select a2.objectid,a2.BSM,a2.xzqdm,a2.xzqmc, a1.qsdwdm,a1.qsdwmc from qsdmb a1 inner join xzq a2 on left(a1.qsdwdm,12)=left(a2.xzqdm,12) where mid(qsdwdm,12,1)<>'0' and right(qsdwdm,7)='0000000') where Trim(a2.xzqmc)<>Trim(a1.qsdwmc)";
pRecordset = AdoDbHelper.GetDataTable(base.m_QueryConnection, strTemp);
if (pRecordset == null || pRecordset.Rows.Count == 0)
{
string strLog = "当前规则的SQL查询语句设置有误，无法执行多表关系检查!";
SendMessage(enumMessageType.RuleError, strLog);
return(false);
}
}
else if (m_structPara.strScript.Contains("权属代码表不一致") ||
m_structPara.strScript.Contains("权属单位代码表不一致"))
{
reader = AdoDbHelper.GetQueryReader(base.m_QueryConnection, m_structPara.strClause) as OleDbDataReader;
if (reader == null)
{
string strLog = "当前规则的SQL查询语句设置有误，无法执行多表关系检查!";
SendMessage(enumMessageType.RuleError, strLog);
return(false);
}
pRecordset.Load(reader);
}
else
{
pRecordset = AdoDbHelper.GetDataTable(base.m_QueryConnection, m_structPara.strClause);
if (pRecordset == null || pRecordset.Rows.Count == 0)
{
string strLog = "当前规则的SQL查询语句设置有误，无法执行多表关系检查!";
SendMessage(enumMessageType.RuleError, strLog);
return(false);
}
}
string strSql = "";
bool bTable = false;
if (FtName1.Contains("表") || FtName2.Contains("表"))
{
if (m_structPara.strFtName2.Equals("qsdmb", StringComparison.OrdinalIgnoreCase))
{
strSql = "update LR_ResultEntryRule set TargetFeatClass1= '" + FtName1 + "',TargetFeatClass2='" +
FtName2 + "|' where RuleInstID='" + base.m_InstanceID + "'";
}
else
{
strSql = "update LR_ResultEntryRule set TargetFeatClass1= '" + COMMONCONST.TABLENAME +
"',TargetFeatClass2='|' where RuleInstID='" + base.m_InstanceID + "'";
bTable = true;
}
}
else
{
strSql = "update LR_ResultEntryRule set TargetFeatClass1= '" + FtName1 + "',TargetFeatClass2='" +
FtName2 + "|' where RuleInstID='" + base.m_InstanceID + "'";
}
AdoDbHelper.ExecuteSql(m_ResultConnection, strSql);
//获取需要特殊处理的规则别名
Hashtable hashtable = GetEnumHash();
if (hashtable.Contains(m_structPara.strAlias))
{
if (m_structPara.strAlias.Equals("省级上报田坎系数与上报数据中田坎系数是否一致检查"))
{
checkResult = GetTKXSResult(pRecordset);
}
else
{
checkResult = GetAttrResult(pRecordset);
}
}
else
{
checkResult = GetResult(pRecordset, bTable);
}
if (pRecordset != null)
{
pRecordset.Dispose();
return(true);
}
}
catch (Exception ex)
{
SendMessage(enumMessageType.RuleError, string.Format("意外失败，信息：{0}", ex.Message));
SendMessage(enumMessageType.Exception, ex.ToString());
return(false);
}
finally
{
if (reader != null)
{
reader.Dispose();
reader.Close();
GC.Collect();
}
}
//MyWatch.Stop();
//System.Windows.Forms.MessageBox.Show("时间:" + MyWatch.ElapsedMilliseconds.ToString() + "毫秒");
return(true);
}
