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 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 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++;
}
}
}
/// <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();
}
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";
}
/// <summary>
/// Connect to user meal database and finds record for current user. If current user does not exist, creates a generic record for user in db.
/// </summary>
private void ConnectToDb()
{
conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= userMeals.mdb;";
try
{
conn.Open();
cmd = new OleDbCommand(selectString, conn);
reader = cmd.ExecuteReader();
//Reads all records into two lists, one with users, the other with the user meals. Each index corresponds 1 to 1.
while(reader.Read())
{
customMealProfiles.Add(reader["UserName"].ToString());
customMeals.Add(new CustomMeals(reader["Meal 1"].ToString(), reader["Meal 2"].ToString(),
reader["Meal 3"].ToString(), reader["Meal 4"].ToString(), reader["Meal 5"].ToString(), reader["Meal 6"].ToString(),
reader["Meal 7"].ToString(), reader["Meal 8"].ToString(), reader["Meal 9"].ToString(), reader["Meal 10"].ToString()));
}
//Is user does not exist, creates generic record for user in db.
if(!customMealProfiles.Contains(CurrentUser))
{
string insertString = "INSERT INTO userMeals ([UserName],[Meal 1],[Meal 2],[Meal 3],[Meal 4],[Meal 5],[Meal 6],[Meal 7],[Meal 8],[Meal 9],[Meal 10]) VALUES (@User, @Meal1, @meal2, @meal3, @meal4, @meal5, @meal6, @meal7, @meal8, @meal9, @meal10)";
cmd = new OleDbCommand(insertString, conn);
cmd.Parameters.AddWithValue("@User", CurrentUser);
cmd.Parameters.AddWithValue("@Meal1", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal2", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal3", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal4", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal5", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal6", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal7", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal8", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal9", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.Parameters.AddWithValue("@Meal10", "Combo #1 $5.29;Spicy Dog $1.99");
cmd.ExecuteNonQuery();
}
else
{
int index = customMealProfiles.IndexOf(CurrentUser);
meals = new List<string>();
meals.Add(customMeals.ElementAt(index).Meal1);
meals.Add(customMeals.ElementAt(index).Meal2);
meals.Add(customMeals.ElementAt(index).Meal3);
meals.Add(customMeals.ElementAt(index).Meal4);
meals.Add(customMeals.ElementAt(index).Meal5);
meals.Add(customMeals.ElementAt(index).Meal6);
meals.Add(customMeals.ElementAt(index).Meal7);
meals.Add(customMeals.ElementAt(index).Meal8);
meals.Add(customMeals.ElementAt(index).Meal9);
meals.Add(customMeals.ElementAt(index).Meal10);
}
}
catch(Exception ex)
{
MessageBox.Show("Error encounters. Error message as follows: " + ex.Message);
}
finally
{
conn.Close();
}
}
// 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>
/// 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 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);
}
}
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);
}
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 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 void SimpleValue()
{
try
{
BeginCase("check simple value");
//prepare data
base.PrepareDataForTesting(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString);
con = new OleDbConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString);
con.Open();
cmd = new OleDbCommand("Select BirthDate From Employees where EmployeeID = 100", con);
rdr = cmd.ExecuteReader();
rdr.Read();
DateTime dt = rdr.GetDateTime(0); //will be 1988-May-31 15:33:44
Compare(dt,new DateTime(1988,5,31,15,33,44,00));
}
catch(Exception ex)
{
exp = ex;
}
finally
{
if (rdr != null && !rdr.IsClosed)
{
rdr.Close();
}
if (con != null && con.State != ConnectionState.Closed)
{
con.Close();
}
EndCase(exp);
exp = null;
}
}
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);
}
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;
}
/// <summary>
/// 重写application的内容
/// </summary>
public static void reWriteApplication()
{
ListItem li;
BulletedList fulllist = new BulletedList();
newClasses.superConn scnn = new newClasses.superConn("DATA.MDB");
scnn.open();
string _sql = "SELECT * FROM T_SUBMENU WHERE MENU_ENABLE=TRUE ORDER BY MENU_CLASSID,MENU_ORDER DESC";
System.Data.OleDb.OleDbDataReader dr = scnn.GetDataReader(_sql);
while (dr.Read())
{
li = new ListItem();
li.Text = dr["menu_ttl"].ToString();
li.Value = dr["menu_url"].ToString();
li.Attributes.Add("classid", dr["menu_classid"].ToString());//增加一个classid属性
fulllist.Items.Add(li);
}
scnn.close();
HttpContext.Current.Application.Lock();
HttpContext.Current.Application["submenu"] = fulllist;
HttpContext.Current.Application.UnLock();
}
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();
}
public void ExcluirFoto()
{
rs = objBD.ExecutaSQL("select USU_ID, USU_FOTO from Usuario where USU_ID = '" + Session["usuID"] + "' ");
if (rs == null)
{
throw new Exception();
}
if (rs.HasRows)
{
rs.Read();
if (rs["USU_FOTO"].ToString().Length < 1)
{
Response.Redirect("editar-foto-perfil");
Response.End();
}
else
{
//Excluir a foto fisicamente
//File.Delete(Server.MapPath("~/upload/imagens/usuarios/" + rs["USU_FOTO"].ToString()));
//File.Delete(Server.MapPath("~/upload/imagens/usuarios/" + rs["USU_FOTO"].ToString().Replace("" + rs["USU_ID"] + "_", "")));
//Excluir a foto do BD;
objBD.ExecutaSQL("update Usuario set USU_FOTO = null where USU_ID = '" + Session["usuID"] + "' ");
}
}
//Retornar para a Listagem
Response.Redirect("editar-foto-perfil");
Response.End();
}
/// <summary>
/// Get result of a Query in String form
/// </summary>
/// <param name="sqlStatment">The SQL Query</param>
/// <returns>Result of Query in a String</returns>
public String GetData(String sqlStatment)
{
string outputString = "null";
try
{
OpenConection();
cmd = new OleDbCommand(sqlStatment, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["Deleted"].ToString().Equals("False"))
{
outputString = reader["Lec_Name"].ToString();
outputString += "$" + reader["Initials"].ToString();
outputString += "$" + reader["Email"].ToString();
outputString += "$" + reader["MaxHours"].ToString();
outputString += "$" + reader["MaxConsecHours"].ToString();
outputString += "$" + reader["MinSlotsPerDay"].ToString();
outputString += "$";
}
else
{
outputString = "N/A";
}
}
CloseConnection();
}
catch
{
// MessageBox.Show("Failed to get data from source");
}
return outputString;
}
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();
}
}
}
public tbProdutividadeDTO BuscaPorID(tbProdutividadeDTO prodDTO)
{
String sSQL = MontaQuery(prodDTO);
tbProdutividadeDTO prodAux = new tbProdutividadeDTO();
//tbFabricanteDTO fabri = new tbFabricanteDTO();
//tbFabricanteBLL fabriBLL = new tbFabricanteBLL();
try
{
conexao = (OleDbConnection)CriaConexaoOleDb();
drOleDb = cria_DataReader_OleDb(sSQL, conexao);
while (drOleDb.Read())
{
prodAux.idProdutividade = (int)drOleDb["idProdutividade"];
prodAux.dsLinguagem = (string)drOleDb["dsLinguagem"];
prodAux.vlAlta = (float)(double)drOleDb["vlAlta"];
prodAux.vlBaixa = (float)(double)drOleDb["vlBaixa"];
prodAux.vlMedia = (float)(double)drOleDb["vlMedia"];
//tbFabricanteDTO fabriAux = new tbFabricanteDTO();
//fabriAux.idFabricante = (int)drOleDb["idFabricante"];
//prodAux.fabricante = fabriBLL.BuscaPorID(fabriAux);
}
}
catch (SystemException e)
{
erro = e.Message;
}
return prodAux;
}
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;
}
private void SUBMIT_Click(object sender, EventArgs e)
{
if (DAY.Text != "" )
{
com.Connection = con;
com.CommandText = "select * from MCA1 where DAY='" + DAY.Text + "' ";
dr1 = com.ExecuteReader();
if (dr1.Read())
{
MessageBox.Show("data has been read");
/* DAY.Text = " ";
DAY.Enabled = false;
SUBMIT.Text = " ";
SUBMIT.Enabled = false;
string count0 = Convert.ToString(dr.GetString(2));
SUBCODE.Text = count0;
*/
}
else
{
MessageBox.Show("opppsss");
}
}
else
{
MessageBox.Show("Plzzz insert all entries ");
}
}
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!");
}
}
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("Всё хорошо!!!");
}
/// <summary>
/// get all the items from the db
/// </summary>
public void ConnectToAccess()
{
conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= nuwaymenu.mdb;";
try
{
conn.Open();
cmd = new OleDbCommand(selectString, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
string st = reader["Item"].ToString() + "-" + reader["Description"] + " $" + reader["Price"];
items.Add(st);
}
}
catch (Exception ex)
{
MessageBox.Show("Failed to connect to data source");
}
finally
{
conn.Close();
}
}
public bool sprawdzHaslo(String login, String haslo)
{
bool czyLogin = false;
com = new OleDbCommand("Select login,haslo FROM Konto WHERE login='******'", MyConn);
MyConn.Open();
dr = com.ExecuteReader();
while (dr.Read())
{
if (dr[0].ToString() == login)
{
czyLogin = true;
}
else
{
czyLogin = false;
}
}
if (czyLogin == true)
{
com = new OleDbCommand("Select haslo FROM Konto WHERE login='******'", MyConn);
}
return true;
}
/// <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 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;
}
}
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 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 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);
}
}
}
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 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);
}
}
private void cbLevel_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
lvRanking.Items.Clear();
sqlStr = "SELECT TOP 10 * FROM rankinglogs WHERE levelnumber = " + cbLevel.Text.Substring(6).Trim() + " ORDER BY Point";
conn.Open();
cmd = new OleDbCommand(sqlStr,conn);
reader = cmd.ExecuteReader();
int i = 1;
while(reader.Read())
{
ListViewItem lvi = new ListViewItem(i+"");
lvi.SubItems.Add(reader["Nickname"].ToString());
lvi.SubItems.Add(reader["Point"].ToString());
lvi.SubItems.Add(reader["TimeSave"].ToString());
lvRanking.Items.Add(lvi);
i++;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
try
{
conn.Close();
}
catch
{
}
}
}
/// <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);
}
/// <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);
}
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>
/// 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);
}
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;
}
}
//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);
}
}
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;
}
}
}
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();
}
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>
/// 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);
}
//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;
}
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>");
}
}
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;
}
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] + ".";
}
private void button1_Click(object sender, EventArgs e)
{
String name;
String mark;
List <String> one = new List <String>();
List <String> two = new List <String>();
command = new dabse.OleDbCommand("Select Дисциплины.Название, Дисциплины_обучение.Балл From Дисциплины, Дисциплины_обучение, Студенты Where Дисциплины.Код = Дисциплины_обучение.Код_дисциплины and Студенты.Шифр = Дисциплины_обучение.Шифр_студента and Студенты.Шифр = " + firststudensshifr.Text + " order by Дисциплины_обучение.Балл, Дисциплины.Название", Date_baseone);
dabse.OleDbDataReader result = command.ExecuteReader();
wooord.Application app = new wooord.Application();
Object missing = Type.Missing;
app.Documents.Add(ref missing, ref missing, ref missing, ref missing);
wooord.Document docec = app.ActiveDocument;
wooord.Range range = docec.Paragraphs[docec.Paragraphs.Count].Range;
while (result.Read())
{
name = result[1].ToString();
mark = result[0].ToString();
one.Add(name);
two.Add(mark);
}
int len = two.Count;
docec.Tables.Add(range, len + 1, 2, ref missing, ref missing);
docec.Tables[1].Cell(1, 1).Range.Text = "Название дисциплины";
docec.Tables[1].Cell(1, 2).Range.Text = "Балл";
for (int i = 0; i < len; i++)
{
docec.Tables[1].Cell(i + 2, 1).Range.Text = two[i];
docec.Tables[1].Cell(i + 2, 2).Range.Text = one[i];
}
wooord.Border[] bords = new wooord.Border[6];
wooord.Table table = docec.Tables[docec.Tables.Count];
bords[0] = table.Borders[wooord.WdBorderType.wdBorderLeft];
bords[1] = table.Borders[wooord.WdBorderType.wdBorderRight];
bords[2] = table.Borders[wooord.WdBorderType.wdBorderTop];
bords[3] = table.Borders[wooord.WdBorderType.wdBorderBottom];
bords[4] = table.Borders[wooord.WdBorderType.wdBorderVertical];
bords[5] = table.Borders[wooord.WdBorderType.wdBorderHorizontal];
foreach (wooord.Border border in bords)
{
border.LineStyle = wooord.WdLineStyle.wdLineStyleSingle;
border.Color = wooord.WdColor.wdColorBlack;
}
app.Visible = true;
}
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);
}
}
private void GroupsStudy_Load(object sender, EventArgs e)
{
Date_baseone.Open();
var data1 = new List <Dvapolya>();
var data2 = new List <Dvapolya>();
var data3 = new List <string>();
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);
}
dabse.OleDbCommand com2 = new dabse.OleDbCommand("Select Фамилия, Имя, Отчество, Шифр FROM Студенты", Date_baseone);
dabse.OleDbDataReader resulter2 = com2.ExecuteReader();
while (resulter2.Read() == true)
{
var mc = new Dvapolya
{
secondpole = resulter2[0].ToString().Trim() + " " + resulter2[1].ToString().Trim() + " " + resulter2[2].ToString().Trim(),
firstpole = resulter2[3].ToString().Trim()
};
data2.Add(mc);
}
dabse.OleDbCommand com3 = new dabse.OleDbCommand("SELECT DISTINCT (Группы_обучение.Год) FROM Группы_обучение", Date_baseone);
dabse.OleDbDataReader resulter3 = com3.ExecuteReader();
while (resulter3.Read() == true)
{
var mc = resulter3[0].ToString().Trim();
data3.Add(mc);
}
comboBox1.DataSource = data1;
comboBox1.DisplayMember = "secondpole";
comboBox1.ValueMember = "firstpole";
comboBox2.DataSource = data2;
comboBox2.DisplayMember = "secondpole";
comboBox2.ValueMember = "firstpole";
comboBox3.DataSource = data3;
}
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;
}
}
public static void Carregar_Banco_Dados()
{
myConnection.Open();
myReader = myCommand.ExecuteReader();
MessageBox.Show("ServerVersion: " + myConnection.ServerVersion
+ "\nDataSource: " + myConnection.DataSource.ToString());
while (myReader.Read())
{
MessageBox.Show("Codigo:" + myReader["Codigo"]);
}
}
private void countReturned(string mpDATEAWAL, string mpDATEAKHIR)
{
mlSQL = "SELECT RETURNED FROM INV_DELIVERY_STATUS WHERE RETURNEDDATE BETWEEN '" + mpDATEAWAL + "' AND '" + mpDATEAKHIR + "'";
mlREADER = mlOBJGS.DbRecordset(mlSQL, "PB", mlCOMPANYID);
if (mlREADER.HasRows)
{
while (mlREADER.Read())
{
this.mlRETURNED.Text = mlREADER["RETURNED"].ToString();
}
}
else
{
this.mlRETURNED.Text = "0";
}
}
private void countProceeds(string mpDATEAWAL, string mpDATEAKHIR)
{
mlSQL = "SELECT PROCEEDS FROM INV_DELIVERY_STATUS WHERE PROCEEDSDATE BETWEEN '" + mpDATEAWAL + "' AND '" + mpDATEAKHIR + "'";
mlREADER = mlOBJGS.DbRecordset(mlSQL, "PB", mlCOMPANYID);
if (mlREADER.HasRows)
{
while (mlREADER.Read())
{
this.mlPROCEEDS.Text = mlREADER["PROCEEDS"].ToString();
}
}
else
{
this.mlPROCEEDS.Text = "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);
}
private void Students_Load(object sender, EventArgs e)
{
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 resulter = com1.ExecuteReader();
while (resulter.Read() == true)
{
var mc = new Dvapolya
{
secondpole = resulter[0].ToString().Trim(),
firstpole = resulter[1].ToString().Trim()
};
data1.Add(mc);
}
specialnost.DataSource = data1;
specialnost.DisplayMember = "secondpole";
specialnost.ValueMember = "firstpole";
var data2 = new List <Dvapolya>();
var nc = new Dvapolya
{
secondpole = "обучается",
firstpole = "1"
};
data2.Add(nc);
var nc1 = new Dvapolya
{
secondpole = "отчислен",
firstpole = "2"
};
data2.Add(nc1);
priznakotchis.DataSource = data2;
priznakotchis.DisplayMember = "secondpole";
priznakotchis.ValueMember = "firstpole";
}
/// <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);
}
}
