/// <summary> /// Gets all rows from Excel sheet that is mapped to the used object type. /// </summary> /// <returns>Returns a list of type Metrics</returns> public IEnumerable <T> GetAll() { var currentType = typeof(T); var selectStatement = currentType.GetSelectStatement(); var itemsList = new List <T>(); using (OleDbConnection connection = new OleDbConnection(_connectionString)) { OleDbCommand command = new OleDbCommand(selectStatement, connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); while (reader != null && reader.Read()) { var item = new T(); foreach (var property in currentType.GetProperties()) { var value = reader[property.GetMappingColumn()]; if (value != DBNull.Value) { property.SetValue(item, value); } } itemsList.Add(item); } reader?.Close(); } return(itemsList); }
/// <summary> /// Run SQL Query over Excel file /// </summary> /// <param name="sql"> /// SQL Query to run /// </param> /// <param name="dataTable"> /// DataSet with result /// </param> /// <returns> /// True if operation completed successfully /// </returns> public void RunSql(string sql, ref DataTable dataTable) { OleDbConnection oConn = null; OleDbCommand oComm = null; OleDbDataReader oRdr = null; try { String sConnString = BuildConnectionString(); oConn = new OleDbConnection(sConnString); oConn.Open(); String sCommand = sql; oComm = new OleDbCommand(sCommand, oConn); oRdr = oComm.ExecuteReader(); dataTable.Load(oRdr); } finally { oRdr?.Close(); oRdr = null; oComm?.Dispose(); oConn.Close(); oConn.Dispose(); } }
/// <summary> /// Gets the row from Excel sheet that is mapped to the used object type, having the gived ID. /// </summary> /// <returns>Returns a row of type Metrics</returns> public T GetSingle(object id) { var currentType = typeof(T); var selectStatement = currentType.GetSelectStatementForSingle(id); using (OleDbConnection connection = new OleDbConnection(_connectionString)) { OleDbCommand command = new OleDbCommand(selectStatement, connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); if (reader != null && reader.Read()) { var item = new T(); foreach (var property in currentType.GetProperties()) { var value = reader[property.GetMappingColumn()]; if (value != DBNull.Value) { property.SetValue(item, value); } } return(item); } reader?.Close(); } return(null); }
public IEnumerable <TrainingRow> GetAllRows() { var rows = new List <TrainingRow>(); using (OleDbConnection connection = new OleDbConnection(_connectionString)) { OleDbCommand command = new OleDbCommand(GetSelectStatement(), connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); while (reader != null && reader.Read()) { var row = new TrainingRow(); var idColumn = reader[_idColumn]; if (idColumn != DBNull.Value) { row.IdColumn = idColumn.ToString(); row.Input = GetArrayOfVariables(reader, _inputVariables); row.Output = GetArrayOfVariables(reader, _outputVariables); rows.Add(row); } } reader?.Close(); } return(rows); }
/*---------------------------------------------------------------*/ protected List <BaseEntity> Select() { List <BaseEntity> list = new List <BaseEntity>(); try { Command.Connection = Con; Con.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { BaseEntity entity = NewEntity(); list.Add(CreateModel(entity)); } } catch (Exception e) { Console.WriteLine("Error! " + e.Message); } finally { Reader?.Close(); if (Con.State == ConnectionState.Open) { Con.Close(); } } return(list); }
/*================================================================================ * GET PLUSES *================================================================================*/ public static FullObservableCollection <Pluses> GetPluses() { // Creamos la lista y el comando que extrae las líneas. FullObservableCollection <Pluses> lista = new FullObservableCollection <Pluses>(); using (OleDbConnection conexion = new OleDbConnection(App.Global.CadenaConexion)) { string comandoSQL = "SELECT * FROM Pluses ORDER BY Año;"; OleDbCommand comando = new OleDbCommand(comandoSQL, conexion); OleDbDataReader lector = null; try { conexion.Open(); lector = comando.ExecuteReader(); while (lector.Read()) { Pluses pluses = new Pluses(lector); lista.Add(pluses); pluses.Nuevo = false; pluses.Modificado = false; } } catch (Exception ex) { Utils.VerError("BdPluses.GetPluses", ex); } finally { lector?.Close(); } } return(lista); }
//================================================================================ // GET GRAFICO //================================================================================ public static GraficoBase GetGrafico(int numero, DateTime validez) { GraficoBase grafico = null; OleDbDataReader lector = null; using (OleDbConnection conexion = new OleDbConnection(App.Global.CadenaConexion)) { try { conexion.Open(); OleDbCommand comando = new OleDbCommand(comandoGetGrafico, conexion); comando.Parameters.AddWithValue("@Validez", validez.ToString("yyyy-MM-dd")); comando.Parameters.AddWithValue("@Numero", numero); // Ejecutamos el comando y extraemos el gráfico. lector = comando.ExecuteReader(); if (lector.Read()) { grafico = new GraficoBase(lector); } } catch (Exception ex) { Utils.VerError("BdPijamas.GetGrafico", ex); } finally { lector?.Close(); } } return(grafico); }
/// <summary> /// Fills contents of passed combo box with values from database. /// </summary> /// <param name="comboBox"></param> /// <param name="dataItems"></param> /// <param name="query"></param> /// <param name="member"></param> /// <param name="value"></param> private void fillCombo(ComboBox comboBox, List <dataItem> dataItems, string query, string displayValue, string selector) { //Fill List with passed query's database results fillComboBoxList(dataItems, query); //Set list as combo box item source comboBox.ItemsSource = dataItems; //Set property from data item to display comboBox.DisplayMemberPath = displayValue; //Selector for record to display comboBox.SelectedValuePath = selector; //Procedure to query the database a fill list with result void fillComboBoxList(List <dataItem> items, string sql) { myConn.Open(); //create query OleDbCommand myCmd = myConn.CreateCommand(); //set passed SQL string to query myCmd.CommandText = sql; try { //run query myDR = myCmd.ExecuteReader(); while (myDR.Read()) { //null validation arrow function string outOfBounds(int i) => myDR.FieldCount > i ? myDR[i].ToString() : ""; //add new data item to items with values read from the database. items.Add(new dataItem { //add properties id = outOfBounds(0), prodName = outOfBounds(1) }); } } catch (Exception e) { //display unhelpful obtuse system generation error message MessageBox.Show(e.ToString()); } //close connections (prevents exception errors!) myConn?.Close(); myDR?.Close(); } }
public void createCatalagoCuentas() { string strAccessConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=database\\" + this.databaseFileName; string strAccessSelect = "SELECT * FROM [CatalogoCuentasSatVendor]"; DataSet myDataSet = new DataSet(); OleDbConnection myAccessConn = null; try { myAccessConn = new OleDbConnection(strAccessConn); } catch (Exception ex) { Console.WriteLine("Error: Failed to create a database connection. \n{0}", ex.Message); return; } try { myAccessConn.Open(); OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn); OleDbDataReader reader = myAccessCommand.ExecuteReader(); List <SatContabilidad.CatalogoCtas.CatalogoCtas> ctas = new List <SatContabilidad.CatalogoCtas.CatalogoCtas>(); while (reader.Read()) { SatContabilidad.CatalogoCtas.CatalogoCtas cta = new SatContabilidad.CatalogoCtas.CatalogoCtas(); Type code = typeof(CatalogoCtas.c_CodAgrup); foreach (CatalogoCtas.c_CodAgrup o in Enum.GetValues(typeof(CatalogoCtas.c_CodAgrup))) { if (GetXmlAttrNameFromEnumValue(o).Equals(reader["CodAgrupador"].ToString(), StringComparison.OrdinalIgnoreCase)) { cta.CodAgrup = o; } } cta.NumCta = reader["NumCta"].ToString(); cta.Desc = reader["Desc"].ToString(); cta.Natur = reader["Natur"].ToString(); cta.Nivel = int.Parse(reader["Nivel"].ToString()); ctas.Add(cta); } reader.Close(); myAccessConn.Close(); SatContabilidad.CatalogoCtas.Catalogo catalogo = new SatContabilidad.CatalogoCtas.Catalogo(); catalogo.schemaLocation = "www.sat.gob.mx/esquemas/ContabilidadE/1_1/CatalogoCuentas http://www.sat.gob.mx/esquemas/ContabilidadE/1_1/CatalogoCuentas/CatalogoCuentas_1_1.xsd"; catalogo.Ctas = ctas.ToArray <SatContabilidad.CatalogoCtas.CatalogoCtas>(); Type mes = typeof(CatalogoCtas.CatalogoMes); catalogo.Mes = (CatalogoCtas.CatalogoMes)Enum.Parse(mes, (int.Parse(this.month) - 1).ToString()); catalogo.Anio = int.Parse(this.year); catalogo.RFC = this.rfc; XmlSerializer serializer = new XmlSerializer(typeof(SatContabilidad.CatalogoCtas.Catalogo)); System.IO.TextWriter writer = new System.IO.StreamWriter(this.outputPath + this.rfc + this.year + this.month + "CT.xml"); serializer.Serialize(writer, catalogo); } catch (Exception ex) { Console.WriteLine("Error: Failed to retrive the required data from the Database.\n{0}", ex.Message); return; } finally { myAccessConn.Close(); } }
/*---------------------------------------------------------------*/ public int SaveChanges() { OleDbCommand command = new OleDbCommand(); OleDbTransaction trans = null; int recordsAffected = 0; int errorIndex = 0; try { Con.Open(); trans = Con.BeginTransaction(); command.Connection = Con; command.Transaction = trans; //inserted foreach (var item in Inserted) { command.Parameters.Clear(); item.CreateSql(item.Entity, command); recordsAffected += command.ExecuteNonQuery(); command.CommandText = "SELECT @@Identity"; //get last ID on this session int temp = (int)command.ExecuteScalar(); item.Entity.Id = temp; errorIndex++; } Inserted.Clear(); //updated, deleted foreach (var item in Updated) { command.Parameters.Clear(); item.CreateSql(item.Entity, command); recordsAffected += command.ExecuteNonQuery(); } Updated.Clear(); trans.Commit(); } catch (Exception e) { Debug.WriteLine("\n" + e.Message + "\nSQL:" + command.CommandText); try { trans.Rollback(); } catch (Exception ex2) { // This catch block will handle any errors that may have occurred // on the server that would cause the rollback to fail, such as // a closed connection. Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType()); Console.WriteLine(" Message: {0}", ex2.Message); } } finally { Reader?.Close(); if (Con.State == ConnectionState.Open) { Con.Close(); } } return(recordsAffected); }
public void loadNomenclature() { DateTime dt; ListViewItem ListViewItem_add; if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL) { oleDbConnection = new OleDbConnection(); oleDbConnection.ConnectionString = DataConfig.oledbConnectLineBegin + DataConfig.localDatabase + DataConfig.oledbConnectLineEnd + DataConfig.oledbConnectPass; oleDbConnection.Open(); oleDbCommand = new OleDbCommand("SELECT * FROM Counteragents WHERE (name = '" + Counteragent + "')", oleDbConnection); oleDbDataReader = oleDbCommand.ExecuteReader(); if (oleDbDataReader.Read()) { priceName = oleDbDataReader["excel_table_id"].ToString(); } else { MessageBox.Show("Контрагент " + "\"" + Counteragent + "\"" + " не существует в справочнике контрагентов.", "Сообщение"); } oleDbDataReader.Close(); if (priceName != "") { oleDbCommand = new OleDbCommand("SELECT * FROM " + priceName + " ", oleDbConnection); oleDbDataReader = oleDbCommand.ExecuteReader(); while (oleDbDataReader.Read()) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(oleDbDataReader["name"].ToString()); ListViewItem_add.StateImageIndex = 0; ListViewItem_add.SubItems.Add(oleDbDataReader["price"].ToString()); ListViewItem_add.SubItems.Add(oleDbDataReader["manufacturer"].ToString()); ListViewItem_add.SubItems.Add(oleDbDataReader["remainder"].ToString()); dt = new DateTime(); DateTime.TryParse(oleDbDataReader["term"].ToString(), out dt); ListViewItem_add.SubItems.Add(dt.ToString("dd.MM.yyyy")); ListViewItem_add.SubItems.Add(oleDbDataReader["discount1"].ToString()); ListViewItem_add.SubItems.Add(oleDbDataReader["discount2"].ToString()); ListViewItem_add.SubItems.Add(oleDbDataReader["discount3"].ToString()); ListViewItem_add.SubItems.Add(oleDbDataReader["discount4"].ToString()); ListViewItem_add.SubItems.Add(oleDbDataReader["code"].ToString()); ListViewItem_add.SubItems.Add(oleDbDataReader["series"].ToString()); ListViewItem_add.SubItems.Add(oleDbDataReader["article"].ToString()); ListViewItem_add.SubItems.Add(Counteragent); ListViewItem_add.SubItems.Add(priceName); listView1.Items.Add(ListViewItem_add); } oleDbDataReader.Close(); } else { MessageBox.Show("Контрагент " + Counteragent + " не содержит прайс-листа.", "Сообщение"); } oleDbConnection.Close(); } else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER) { sqlConnection = new SqlConnection(DataConfig.serverConnection); sqlConnection.Open(); sqlCommand = new SqlCommand("SELECT * FROM Counteragents WHERE (name = '" + Counteragent + "')", sqlConnection); sqlDataReader = sqlCommand.ExecuteReader(); if (sqlDataReader.Read()) { priceName = sqlDataReader["excel_table_id"].ToString(); } else { MessageBox.Show("Контрагент " + "\"" + Counteragent + "\"" + " не существует в справочнике контрагентов.", "Сообщение"); } sqlDataReader.Close(); if (priceName != "") { sqlCommand = new SqlCommand("SELECT * FROM " + priceName + " ", sqlConnection); sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { ListViewItem_add = new ListViewItem(); ListViewItem_add.SubItems.Add(sqlDataReader["name"].ToString()); ListViewItem_add.StateImageIndex = 0; ListViewItem_add.SubItems.Add(sqlDataReader["price"].ToString()); ListViewItem_add.SubItems.Add(sqlDataReader["manufacturer"].ToString()); ListViewItem_add.SubItems.Add(sqlDataReader["remainder"].ToString()); dt = new DateTime(); DateTime.TryParse(sqlDataReader["term"].ToString(), out dt); ListViewItem_add.SubItems.Add(dt.ToString("dd.MM.yyyy")); ListViewItem_add.SubItems.Add(sqlDataReader["discount1"].ToString()); ListViewItem_add.SubItems.Add(sqlDataReader["discount2"].ToString()); ListViewItem_add.SubItems.Add(sqlDataReader["discount3"].ToString()); ListViewItem_add.SubItems.Add(sqlDataReader["discount4"].ToString()); ListViewItem_add.SubItems.Add(sqlDataReader["code"].ToString()); ListViewItem_add.SubItems.Add(sqlDataReader["series"].ToString()); ListViewItem_add.SubItems.Add(sqlDataReader["article"].ToString()); ListViewItem_add.SubItems.Add(Counteragent); ListViewItem_add.SubItems.Add(priceName); listView1.Items.Add(ListViewItem_add); } sqlDataReader.Close(); } else { MessageBox.Show("Контрагент " + Counteragent + " не содержит прайс-листа.", "Сообщение"); } sqlConnection.Close(); } }
private void Showdata() { int varindex = 0; dataGridView1.Rows.Clear(); dataGridView1.ColumnCount = 8; dataGridView1.Columns[varindex].Name = "วันที่นำส่ง"; dataGridView1.Columns[varindex].Width = 130; varindex = varindex + 1; dataGridView1.Columns[varindex].Name = "ผู้เบิก"; dataGridView1.Columns[varindex].Visible = false; varindex = varindex + 1; dataGridView1.Columns[varindex].Name = "ชื่อผู้เบิก"; dataGridView1.Columns[varindex].Width = 170; varindex = varindex + 1; dataGridView1.Columns[varindex].Name = "จำนวนเงิน"; dataGridView1.Columns[varindex].Width = 110; varindex = varindex + 1; dataGridView1.Columns[varindex].Name = "ระหว่างวันที่"; dataGridView1.Columns[varindex].Width = 120; varindex = varindex + 1; dataGridView1.Columns[varindex].Name = "ถึงวันที่"; dataGridView1.Columns[varindex].Width = 120; varindex = varindex + 1; dataGridView1.Columns[varindex].Name = "รอบเงินเข้า"; dataGridView1.Columns[varindex].Width = 120; varindex = varindex + 1; dataGridView1.Columns[varindex].Name = "SEQ"; dataGridView1.Columns[varindex].Width = 45; string sql = ""; if (MyGlobal.GlobalAuthority == "Admin") { if (txtSearchUserID.Text == "") { sql = "Select * from EOD_AllowanceData order by SEQ"; txtUser.Text = ""; txtUserID.Text = ""; } else if (txtSearchUserID.Text != "") { sql = "Select * from EOD_AllowanceData where UserID like '%' + '" + txtSearchUserID.Text + "' + '%' order by SEQ"; } } else { if (txtSraStartDate.Text == "" && txtSearchEndDate.Text == "") { sql = "Select * from EOD_AllowanceData where UserID like '%' + '" + MyGlobal.GlobalUserID + "' + '%' order by SEQ"; } else if (txtSraStartDate.Text != "" && txtSearchEndDate.Text != "") { sql = "Select * from EOD_AllowanceData where UserID like '%' + '" + MyGlobal.GlobalUserID + "' + '%' and StartDate >= '" + txtSraStartDate.Text + "' and EndDate <= '" + txtSearchEndDate.Text + "' order by SEQ"; } } OleDbCommand com = new OleDbCommand(sql, conn); OleDbDataReader dr = com.ExecuteReader(); while (dr.Read()) { string varUserName = ""; string sql1 = "Select * from UserMaster where UserID = '" + dr["UserID"].ToString() + "' "; OleDbCommand com1 = new OleDbCommand(sql1, conn); OleDbDataReader dr1 = com1.ExecuteReader(); while (dr1.Read()) { varUserName = dr1["UserName"].ToString(); txtUser2.Text = dr1["UserName"].ToString(); } dr1.Close(); dataGridView1.Rows.Add(dr["DeliveryDate"].ToString(), dr["UserID"].ToString(), varUserName, dr["Amount"].ToString(), dr["StartDate"].ToString(), dr["EndDate"].ToString(), dr["PaymentPeriod"].ToString(), dr["SEQ"].ToString()); } foreach (DataGridViewColumn column in dataGridView1.Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; } dr.Close(); }
private string LoadViewSource() { string text = string.Empty; OleDbConnection cn = null; OleDbDataReader reader = null; try { string select = string.Format(@"SELECT CASE WHEN encrypted = 1 THEN NULL ELSE com.text END as Source FROM sysobjects o, syscomments com WHERE o.id = object_id(N'[{0}].[{1}]') and com.id=o.id and com.status=2 order by colid;", this.Schema, this.Name); cn = new OleDbConnection(dbRoot.ConnectionString); cn.Open(); cn.ChangeDatabase(this.Database.Name); OleDbCommand cmd = cn.CreateCommand(); cmd.CommandText = select; try { reader = cmd.ExecuteReader(); while (reader.Read()) { text += reader[0].ToString(); } reader.Close(); } catch { if (reader != null) { reader.Close(); } } if (text == string.Empty) { select = string.Format(@"SELECT CASE WHEN encrypted = 1 THEN NULL ELSE com.text END as Source FROM sysobjects o, syscomments com WHERE o.id = object_id(N'[{0}].[{1}]') and com.id=o.id order by colid;", this.Schema, this.Name); cmd = cn.CreateCommand(); cmd.CommandText = select; reader = cmd.ExecuteReader(); while (reader.Read()) { text += reader[0].ToString(); } reader.Close(); cn.Close(); } cn.Close(); text = text.TrimStart(' ', '\r', '\n', '\t'); } catch { if (reader != null) { reader.Close(); } if ((cn != null) && (cn.State != ConnectionState.Closed) && (cn.State != ConnectionState.Broken)) { cn.Close(); } } return(text); }
protected void Page_Load(object sender, EventArgs e) { UserManager manager = new UserManager(); //check if the user is a venue owner or a user, and make visible the correct panel if (manager.GetPhoneNumber(User.Identity.GetUserId()) != null) { ownerView.Visible = true; //query database for events booked at owner's venue string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnect"].ConnectionString; OleDbConnection c = new OleDbConnection(connectionString); c.Open(); OleDbCommand cmd = c.CreateCommand(); cmd.CommandType = CommandType.Text; //create query cmd.CommandText = "SELECT V.venueName FROM venue V WHERE V.owner = '" + User.Identity.GetUserName() + "' AND V.isClosed = 0"; //execute query OleDbDataReader reader = cmd.ExecuteReader(); //check if user owns a venue String venueName = ""; while (reader.Read()) { venueName = reader.GetString(0); } //c.Close(); reader.Close(); if (!venueName.Equals("")) { //check if there are events booked at the venue cmd.CommandText = "SELECT E.eventName, E.eventDate, E.category FROM event E WHERE E.location = '" + venueName + "'"; reader = cmd.ExecuteReader(); int i = 0; while (reader.Read()) { //only show events that are upcoming if (inFuture(reader.GetString(1))) { System.Web.UI.HtmlControls.HtmlGenericControl dynDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV"); dynDiv.ID = "dynDivCode" + i.ToString(); dynDiv.Attributes["class"] = "col-lg-4"; switch (reader.GetString(2)) { case "Music": dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/test3.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>"; break; case "Academic": dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/test1.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>"; break; case "Party": dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/eventhub3.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>"; break; case "Film": dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/test2.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>"; break; case "Fine Arts": dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/test2.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>"; break; case "Sports": dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/eventhub5.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>"; break; case "Other": dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/eventhub4.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>"; break; } ownerFiller.Controls.Add(dynDiv); i++; } } } reader.Close(); } else { userView.Visible = true; string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnect"].ConnectionString; OleDbConnection c = new OleDbConnection(connectionString); c.Open(); OleDbCommand cmd = c.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "select TOP 3 E.eventName, E.eventDate from event E INNER JOIN attendedEvents AE on E.eventName = AE.event where E.eventDate < '" + DateTime.Now.ToString("MM/dd/yyyy") + "' and AE.attendee = '" + User.Identity.GetUserName() + "'"; OleDbDataReader reader = cmd.ExecuteReader(); int i = 0; // reader = cmd.ExecuteReader(); while (reader.Read()) { if (i == 0) { attendedEvent1.Text = reader.GetString(0); attendedEventDate1.Text = reader.GetString(1); } if (i == 1) { attendedEvent2.Text = reader.GetString(0); attendedEventDate2.Text = reader.GetString(1); } if (i == 2) { attendedEvent3.Text = reader.GetString(0); attendedEventDate3.Text = reader.GetString(1); } i++; } reader.Close(); c.Close(); cmd.CommandText = "select TOP 3 E.eventName, E.eventDate from event E INNER JOIN attendedEvents AE on E.eventName = AE.event where E.eventDate >= '" + DateTime.Now.ToString("MM/dd/yyyy") + "' and AE.attendee = '" + User.Identity.GetUserName() + "'"; c.Open(); reader = cmd.ExecuteReader(); i = 0; // reader = cmd.ExecuteReader(); while (reader.Read()) { if (i == 0) { bookedEvent1.Text = reader.GetString(0); bookedEventDate1.Text = reader.GetString(1); } if (i == 1) { bookedEvent2.Text = reader.GetString(0); bookedEventDate2.Text = reader.GetString(1); } if (i == 2) { bookedEvent3.Text = reader.GetString(0); bookedEventDate3.Text = reader.GetString(1); } i++; } reader.Close(); c.Close(); } }
public void LoadPBImage() { String imgPath = ""; ImageLayout iLayout = ImageLayout.None; int layoutVal = 0; try { DBConnection.Open(); OleDbDataReader reader = DBConnection._Read("select * from BSetting where ID=1"); reader.Read(); if (reader.HasRows) { layoutVal = Convert.ToInt16(reader["bValue"]); imgPath = reader["path"].ToString(); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } finally { DBConnection.Close(); } //-----------> if (layoutVal == 0) { iLayout = ImageLayout.None; } else if (layoutVal == 1) { iLayout = ImageLayout.Center; } else if (layoutVal == 2) { iLayout = ImageLayout.Stretch; } else if (layoutVal == 3) { iLayout = ImageLayout.Tile; } else if (layoutVal == 4) { iLayout = ImageLayout.Zoom; } //--------------> if (!imgPath.Equals("")) { if (System.IO.File.Exists(imgPath)) { this.BackgroundImage = Image.FromFile(imgPath); this.Refresh(); this.BackgroundImageLayout = iLayout; } else { this.BackgroundImage = Sales_Management.Properties.Resources.unknown; this.Refresh(); this.BackgroundImageLayout = ImageLayout.Center; } } else { this.BackgroundImage = Sales_Management.Properties.Resources.unknown; this.Refresh(); this.BackgroundImageLayout = ImageLayout.Center; } }
public void Reset() { try { con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + lblpath.Text + "';"); con.Open(); cmd = con.CreateCommand(); cmd.CommandText = "SELECT MAX(VOCHERNO) as VOUCHERNO FROM LedgerPosting WHERE VOUCHERTYPE='" + "QUICK RECEIPT" + "' "; rdr = cmd.ExecuteReader(); if (rdr.Read()) { if (rdr.IsDBNull(rdr.GetOrdinal("VOUCHERNO"))) { txtReceiptNo.Text = Convert.ToString("1"); } else { txtReceiptNo.Text = Convert.ToString(Convert.ToInt64(rdr["VOUCHERNO"]) + 1); } } if ((rdr != null)) { rdr.Close(); } con.Close(); con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + lblpath.Text + "';"); con.Open(); String sql = "select ACCOUNTNAME from Account"; cmd = new OleDbCommand(sql, con); rdr = cmd.ExecuteReader(); while (rdr.Read()) { cmbCustomer.Items.Add(rdr[0]); } con.Close(); cmbCustomer.Text = ""; cmbpaymentmode.Text = "Cash"; txtChequeno.Text = ""; txttotalamount.Text = ""; txt_extra1.Text = ""; label1.Hide(); label4.Hide(); dtpChequeDate.Hide(); txtChequeno.Hide(); txttotalamount.Text = ""; btn_save.Enabled = true; btn_delete.Enabled = false; cmbCustomer.Focus(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
static void Main(string[] args) { // Setup a trace listener to the console Trace.AutoFlush = true; // First, determine the filename to use: string dir = Environment.CurrentDirectory + "\\"; string baseName = "hstlogfile." + DateTime.Now.ToShortDateString().Replace("/", "-"); string ext = ".txt"; // If this file exists, rename appropriately if (System.IO.File.Exists(dir + baseName + ext)) { int x = 1; while (System.IO.File.Exists(dir + baseName + "." + Convert.ToString(x) + ext)) { x++; } baseName = baseName + "." + Convert.ToString(x); } System.IO.FileStream traceLog = new System.IO.FileStream(dir + baseName + ext, System.IO.FileMode.OpenOrCreate); // Creates the new trace listener. System.Diagnostics.TextWriterTraceListener newListener = new System.Diagnostics.TextWriterTraceListener(traceLog); // Add the listener Trace.Listeners.Add(newListener); Trace.Listeners.Add(new TextWriterTraceListener(Console.Out)); // If the settings folder does not exist, create it if (!System.IO.Directory.Exists(Environment.CurrentDirectory + "\\settings")) { Trace.WriteLine("Settings folder was not found - it is being created."); System.IO.Directory.CreateDirectory(Environment.CurrentDirectory + "\\settings"); } Thread.CurrentThread.Priority = ThreadPriority.Lowest; // We don't want anything to interfere with // the game servers that are being managed. ////////////////////////////////////////////////////////////// // Initialization: Part One - Load settings from files ////////////////////////////////////////////////////////////// // Open the database connection string dbFile = Environment.CurrentDirectory + "\\settings\\global_settings.mdb"; if (!System.IO.File.Exists(dbFile)) { Trace.WriteLine("Database file not found - " + dbFile); Trace.WriteLine("Could not initialize - reinstall HST to repair this problem."); } DB.OpenDatabase(dbFile); // Start all of the server processes ServerManager.ServerList = new System.Collections.ArrayList(); // Load the server list from the database OleDbDataReader dr = DB.GetData("select * from servers"); if (dr.HasRows) { while (dr.Read()) { string startupFolder = dr.GetString(dr.GetOrdinal("installed_dir")); HaloServer h = new HaloServer(startupFolder); h.name = dr.GetString(dr.GetOrdinal("name")); h.id = Convert.ToString(dr.GetInt32(dr.GetOrdinal("server_id"))); h._ipAddress = System.Net.IPAddress.Parse(dr.GetString(dr.GetOrdinal("ip_address"))); h._port = dr.GetInt32(dr.GetOrdinal("port")); h._commandLine = dr.GetString(dr.GetOrdinal("commandline")); h._parameters = dr.GetString(dr.GetOrdinal("parameters")); ServerManager.ServerList.Add(h); h.Start(); } } else { Trace.WriteLine("No servers found."); } dr.Close(); string input; while (true) { input = Console.ReadLine().ToUpper(); if (input == "QUIT") { // There are still child threads running - we need to fix that. foreach (System.Collections.DictionaryEntry de in ServerManager.ServerList) { GameServer g = (GameServer)de.Value; g.Stop(); } break; } if (input.StartsWith("STOP")) { GameServer g = (GameServer)ServerManager.ServerList[0]; Trace.WriteLine("Stopping Server: " + g.name); g.Stop(); } if (input.StartsWith("START")) { GameServer g = (GameServer)ServerManager.ServerList[0]; Trace.WriteLine("Starting Server: " + g.name); g.Start(); } /*if (input.StartsWith("WEB")) * { * if (hServ.Active) * { * Trace.WriteLine("Web server active."); * Trace.WriteLine("IP: " + hServ.Ip); * Trace.WriteLine("Port: " + Convert.ToString(hServ.Port)); * Trace.WriteLine(" "); * } * else * { * Trace.WriteLine("Web Server not currently active."); * } * }*/ } }
public TestLoadXmlFromSvr(ITestOutputHelper output) { this.output = output; // retrieve metadata as xml from target server string sqlStatementForTablesToImport = @" select ( select mappingName = N'm_sync_' + tables.[name], mappingDescription = N'HSTG', [enabled] = 'true', [schemaExt] = ( select objectSchema = schema_name(tables.[schema_id]), objectName = tables.[name] for xml path('underlyingSource'), root('AzP_EDW'), type ), [source] = ( select dataStore = ( select connectionKey = 'HSTG_PRD' for xml path(''), type ), [language] = 'T-SQL', code = 'select * from ' + schema_name(tables.[schema_id]) + N'.' + tables.[name] + N' where OMD_INSERT_DATETIME > ? AND OMD_INSERT_DATETIME <= ?;' for xml path(''), type ), [target] = ( select dataStore = ( select connectionKey = 'HSTG' for xml path(''), type ), objectSchema = schema_name(tables.[schema_id]), objectName = tables.[name] for xml path(''), type ), mappedDataItems = ( select sourceDataItem = (select columnName = columns.[name] for xml path(''), type), targetColumn = (select columnName = columns.[name] for xml path(''), type) from sys.columns where columns.[object_id] = tables.[object_id] and columns.[name] not like 'OMD\_%' escape '\' order by columns.column_id for xml path('MappedDataItem'), type ) from EDW_150_History_Area.sys.tables inner join openquery(AUBIWSQLPRD, ' select schema_name(tables.[schema_id]) as [schema_name] , tables.[name] from EDW_150_History_Area.sys.tables; ') src on src.[schema_name] = schema_name(tables.[schema_id]) and src.[name] = tables.[name] where schema_name(tables.[schema_id]) = N'dbo' order by schema_name(tables.[schema_id]), tables.[name] for xml path('MappedDataSet'), root('ArrayOfMappedDataSet') ) as xmlColumn; "; using (OleDbConnection conn = new OleDbConnection(@"Provider=SQLNCLI11;Server=(local);Integrated Security=SSPI;Initial Catalog=EDW_150_History_Area;")) { OleDbCommand cmd = new OleDbCommand(sqlStatementForTablesToImport, conn); conn.Open(); OleDbDataReader reader = cmd.ExecuteReader(); string xmlString = ""; while (reader.Read()) { // read xml to string (assuming single row) xmlString = reader.GetString(0); } reader.Close(); // load to object model List<MappedDataSet> loaded = XmlLoader.LoadFromString(xmlString); loadedMappings.MappedDataSets.AddRange(loaded); } }
private void btnLoadDoc_Click(object sender, EventArgs e) { odc字典連線 = new System.Data.OleDb.OleDbConnection( @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\EN_" + cb目標語言.Text + ".dll"); odc詞頻典連線 = new System.Data.OleDb.OleDbConnection( @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\WordFrequency.dll"); DGVResult.Rows.Clear(); progressBar.Value = 0; panel1.Visible = true; this.Enabled = false; Dict各單字之雙語對照.Clear(); //1.建立文件清單,2.將所載入之文件加到清單中,3.再將清單丟給詞頻物件分析其詞頻 Docs = new List <WordFrequencyCounter.Document>(); //建立文件清單 Docs.Add(new WordFrequencyCounter.Document(tbDoc.Text, false, strArr忽略字)); //將所載入之文件加到清單中 wordFrequency = new WordFrequencyCounter.WordFrequency(Docs); //將清單丟給詞頻物件分析其詞頻 //此後,wordFrequency記錄著文章中的每個單字,以及其在文章中出現之頻率 progressBar.Maximum = wordFrequency.Frequencies.Count; //進度條最大值設為單字數 lbTotalWordNum.Text = progressBar.Maximum.ToString(); //「共多少單字要查」的label this.Refresh(); //重繪表單以顯示最新資訊 odc詞頻典連線.Open(); odc字典連線.Open(); odCmd查字典 = odc字典連線.CreateCommand(); //用來查單字解釋 odCmd查詞頻典 = odc詞頻典連線.CreateCommand(); //用來查詞頻 //將文章中的每個單字,查出其中文解釋,以及其語料詞頻排行 //str調整中單字原形:一個字串配對一個數字,即單字配對其文件詞頻 //str文中單字變化形.Key:單字;str文中單字變化形.Value:詞頻 string str調整中單字原形 = null; //驗證過程中,用來儲存改來改去的字 string str文中單字變化形 = null; //驗證過程中,用來儲存原本的字(可能為變化形) foreach (KeyValuePair <string, int> singleWord in wordFrequency.Frequencies) { Application.DoEvents(); try { odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + singleWord.Key + "'"; oddr查字典 = odCmd查字典.ExecuteReader(); #region 判斷單字的變化型態 str調整中單字原形 = str文中單字變化形 = singleWord.Key.ToLower(); if (!oddr查字典.Read()) { if (str調整中單字原形.EndsWith("s")) { if (str調整中單字原形.EndsWith("ies")) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y"; odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } else if (str調整中單字原形.EndsWith("es")) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } if (str調整中單字原形 == str文中單字變化形)//字尾有直接加s,為免與es混淆,不能用else { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 1, 1); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } } else if (str調整中單字原形.EndsWith("ed")) { if (str調整中單字原形.EndsWith("ied")) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y"; odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } else//驗證+ed { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } if (str調整中單字原形 == str文中單字變化形) //驗證:重覆字尾+ed { if (str調整中單字原形[str調整中單字原形.Length - 3] == str調整中單字原形[str調整中單字原形.Length - 4]) //驗證:重覆字尾+ed { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3); //刪除重覆的字尾+ed odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } } if (str調整中單字原形 == str文中單字變化形)//驗證:字尾有e,直接+d { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 1, 1); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } } else if (str調整中單字原形.EndsWith("r")) { if (str調整中單字原形.EndsWith("ier")) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y"; odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } else if (str調整中單字原形.EndsWith("er")) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; if (str調整中單字原形 == str文中單字變化形)//驗證字尾有e,直接+r { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 1, 1); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } } } else if (str調整中單字原形.EndsWith("t")) { if (str調整中單字原形.EndsWith("iest")) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 4, 4) + "y"; odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } else//驗證+est { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } } else if (str調整中單字原形.EndsWith("ly")) { if (str調整中單字原形.EndsWith("ally")) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 4, 4); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } else if (str調整中單字原形.EndsWith("ily"))//驗證去y+ily { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y"; odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } else//驗證+ly { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } if (str調整中單字原形 == str文中單字變化形)//驗證-e+ly { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2) + "e"; odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } } else if (str調整中單字原形.EndsWith("ing")) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3); odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; if (str調整中單字原形 == str文中單字變化形) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "e";//驗證 -e+ing odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } if (str調整中單字原形 == str文中單字變化形) { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y";//驗證 -y+ing odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } if (str調整中單字原形 == str文中單字變化形) { if (str調整中單字原形[str調整中單字原形.Length - 4] == str調整中單字原形[str調整中單字原形.Length - 5]) //驗證 重複字尾+ing { str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 4, 4); //刪除重複的字尾和ing odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形; } } } } else { str調整中單字原形 = str文中單字變化形; } #endregion 判斷單字變化型態 odCmd查字典.CommandText = "SELECT [解釋],[音標] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'"; oddr查字典.Close(); oddr查字典 = odCmd查字典.ExecuteReader(); //MessageBox.Show(str調整中單字原形); if (oddr查字典.Read()) { odCmd查詞頻典.CommandText = "SELECT [識別碼] FROM [15000Frequency] where [word] = '" + str調整中單字原形 + "'"; oddr查詞頻典 = odCmd查詞頻典.ExecuteReader(); //hSBDegree.Value:難度,該數字與每個單字語料詞頻的排名比較,是故越大則越難(越罕見) //識別碼是詞頻典中之PK,即每個單字語料詞頻的排名 if ((oddr查詞頻典.Read() && Int32.Parse(oddr查詞頻典["識別碼"].ToString()) >= hsb難度.Value) || !oddr查詞頻典.HasRows) { //把單字、中文、文章詞頻、語料詞頻排行一一放入詞頻分析表 //若在詞頻典中找不到,則其難度定為999999,使其在詞頻分析表中優先列出 //DGVResult.Rows.Add(singleWord.Key, oddr查字典["解釋"].ToString(), singleWord.Value, oddr查詞頻典.HasRows ? Int32.Parse(oddr查詞頻典["識別碼"].ToString()) : 999999); DGVResult.Rows.Add(singleWord.Key, oddr查字典["解釋"].ToString() + "||||" + oddr查字典["音標"], oddr查詞頻典.HasRows ? Int32.Parse(oddr查詞頻典["識別碼"].ToString()) : 999999, singleWord.Value); //目前的系統需求不需計算本文詞頻,所以singleWord.Value皆以0替代 Dict各單字之雙語對照.Add(singleWord.Key, oddr查字典["解釋"].ToString() + "||||" + oddr查字典["音標"]); } } oddr查字典.Close(); oddr查詞頻典.Close(); } catch (Exception ex) { //MessageBox.Show(ex.Message + ex.Source + ex.TargetSite + ex.); //oddr查字典.Close(); //oddr查詞頻典.Close(); } progressBar.Value++; lbDoneWordNum.Text = progressBar.Value.ToString(); this.Refresh();//每查一個詞頻就重繪表單以顯示最新進度 } odc詞頻典連線.Close(); //詞頻分析表中預設以語料詞頻排行降冪排序,即難字排上面 DGVResult.Sort(DGVResult.Columns["Degree"], ListSortDirection.Descending); panel1.Visible = false; this.Enabled = true; }
private void listViewEx1_MouseDoubleClick(object sender, MouseEventArgs e) { RezultateleCautarii rc = new RezultateleCautarii(); string cnp = listViewEx1.SelectedItems[0].SubItems[2].Text; string index = listViewEx1.SelectedItems[0].SubItems[0].Text; string[] s1 = { "Leucocite 22", "Rh 10", "Fibrinogen 17", "Timp trombina 15", "Grup sanguin 10", "Proteina S 55", "Proteina C 45" }; //bioch string[] s2 = { "Ca ionic 7", "Ca seric 9", "Mg seric 7", "Glucoza serica 7", "Trigliceride 9", "CK 9", "Profil lipidic 28", "ADNhepatitaC 390", "ArnhepatitaB 390" }; // markeri enodocrini string[] s4 = { "AFP 29", "Calcitonina 51", "CA125 35", "CA15-3 35", "Ca72-4 43", "SCC 44", "ACTH 36", "Cortisol 29", "Prolactina 30", "Insulina 29" }; //imun_ser string[] s3 = { "IgA 18", "IgB 18", "ASLO 13", "ANA 55", "AMA 45", "Anticorpi_antiADN 55" }; OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MedLab_DataBase.mdb"); aConnection.Open(); OleDbCommand aCommand = new OleDbCommand("SELECT * FROM Pacienti WHERE Cnp=@cnp", aConnection); aCommand.Parameters.Add("@cnp", OleDbType.VarChar, 100, "Cnp").Value = cnp; OleDbDataReader myreader = aCommand.ExecuteReader(CommandBehavior.CloseConnection); while (myreader.Read()) { rc.textBox1.Text = myreader.GetString(1); rc.textBox2.Text = myreader.GetString(0); rc.textBox3.Text = myreader.GetString(4); rc.textBox4.Text = myreader.GetString(2); rc.textBox5.Text = myreader.GetString(3); rc.textBox6.Text = myreader.GetString(5); } myreader.Close(); OleDbConnection aConnection2 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MedLab_DataBase.mdb"); aConnection2.Open(); OleDbCommand aCommand2 = new OleDbCommand("SELECT * FROM INREGISTRARi WHERE IDCerere=@index", aConnection2); aCommand2.Parameters.Add("@index", OleDbType.VarChar, 100, "Cnp").Value = index; OleDbDataReader myreader2 = aCommand2.ExecuteReader(CommandBehavior.CloseConnection); string Hemat; string ImSer; string Bioch; string Mend; myreader2.Read(); Hemat = myreader2.GetString(9); ImSer = myreader2.GetString(10); Bioch = myreader2.GetString(11); Mend = myreader2.GetString(12); rc.textBox7.Text = myreader2.GetString(7); rc.textBox8.Text = myreader2.GetString(4); rc.textBox9.Text = myreader2.GetString(5); rc.textBox10.Text = myreader2.GetString(6); Object[] obj; int nr_crt = 0, nr = 0; int nrH, nrB, nrIS, nrME; nrH = nrB = nrIS = nrME = 0; obj = new object[18]; //Console.WriteLine("nume" + myc.Nume + "\nadr" + myc.Adr + "\nhemat" + myc.Hemat + "\nbio" + myc.Bioch + "\ncnp" + myc.Cnp + "\ndanl" + myc.Danl + "\ndn" + myc.Dn + "\nemail" + myc.Email + "\nimser" + myc.ImSer + "\nmedic" + myc.Medic + "\nmend" + myc.Mend + "\nnrtel" + myc.Nrtel + "\nnrsp" + myc.Nrtel_spital + "\nsp" + myc.Spital); int i; for (i = 4; i < Hemat.Length; i++) { if (Hemat[i] != ';') { nr = nr * 10 + int.Parse(Hemat[i].ToString()); } else { nr_crt++; obj = new Object[3]; obj[0] = nr_crt; obj[1] = s1[nr].Substring(0, s1[nr].IndexOf(' ')); obj[2] = " "; rc.dataGridViewX1.Rows.Add(obj); nr = 0; } } nrH = nr_crt; nr = 0; //nr_crt = 0; for (i = 4; i < Bioch.Length; i++) { if (Bioch[i] != ';') { nr = nr * 10 + int.Parse(Bioch[i].ToString()); } else { nr_crt++; obj = new Object[3]; obj[0] = nr_crt; obj[1] = s2[nr].Substring(0, s2[nr].IndexOf(' ')); obj[2] = " "; rc.dataGridViewX1.Rows.Add(obj); nr = 0; } } nrB = nr_crt - nrH; nr = 0; // nr_crt = 0; for (i = 4; i < ImSer.Length; i++) { if (ImSer[i] != ';') { nr = nr * 10 + int.Parse(ImSer[i].ToString()); } else { nr_crt++; obj = new Object[3]; obj[0] = nr_crt; obj[1] = s3[nr].Substring(0, s3[nr].IndexOf(' ')); obj[2] = " "; rc.dataGridViewX1.Rows.Add(obj); nr = 0; } } nrIS = nr_crt - (nrB + nrH); nr = 0; //nr_crt = 0; //nr_crt = 0; for (i = 4; i < Mend.Length; i++) { if (Mend[i] != ';') { nr = nr * 10 + int.Parse(Mend[i].ToString()); } else { nr_crt++; obj = new Object[3]; obj[0] = nr_crt; obj[1] = s4[nr].Substring(0, s4[nr].IndexOf(' ')); obj[2] = " "; rc.dataGridViewX1.Rows.Add(obj); nr = 0; } } // nrME = nr_crt - (nrIS + nrH + nrB); myreader2.Close(); rc.index = Convert.ToInt32(index); rc.ShowDialog(); rc.Dispose(); rc.Focus(); }
private void button1_Click(object sender, EventArgs e) { conn = new OleDbConnection(str); conn.Open(); //判断是否为空 if (!Py()) { this.tabts.Text = "用户名/密码不能为空"; this.txtname.Text = ""; this.txtmi.Text = ""; this.txtyzm.Text = ""; FrmLogin_Load(null, null); return; } else { this.tabts.Text = ""; } string sql = "select count(UserName) from [tb_User] where UserName='******' "; //按照账号查询是否有该条 cmd = new OleDbCommand(sql, conn); string su1 = cmd.ExecuteScalar().ToString(); if (su1 == "0") //没有输出错误并且清空 { this.tabts.Text = "账号错误"; this.txtname.Text = ""; this.txtmi.Text = ""; this.txtyzm.Text = ""; FrmLogin_Load(null, null); return; } //按照账号和密码去验证输入的账号和密码是否正确 string sql1 = "select count(UserName) from [tb_User] where UserName='******' and UserPwd='" + this.txtmi.Text + "' "; cmd.CommandText = sql1; string su2 = cmd.ExecuteScalar().ToString(); if (su2 == "0")//没有输出错误并且清空 { this.tabts.Text = "密码错误"; this.txtname.Text = ""; this.txtmi.Text = ""; this.txtyzm.Text = ""; FrmLogin_Load(null, null); return; } //如果全部正确 查询 账号和密码赋值到变量为传值准备 string sql2 = "select * from [tb_User] where UserName='******' and UserPwd='" + this.txtmi.Text + "' "; cmd.CommandText = sql2; dr = cmd.ExecuteReader(); if (dr.Read()) { uspss = dr["UserPwd"].ToString(); usmen = dr["UserName"].ToString(); } dr.Close(); conn.Close(); //验证验证码是否正确 if (this.labyzm.Text != this.txtyzm.Text) { this.tabts.Text = "验证码错误"; this.txtname.Text = ""; this.txtmi.Text = ""; this.txtyzm.Text = ""; FrmLogin_Load(null, null); return; } //new 到主窗口 FrmMain f1 = new FrmMain(s); FrmMain.ry = usmen; this.Hide(); f1.ShowDialog(); this.Dispose(); }
protected async void Unnamed6_Click(object sender, EventArgs e) { int for_danger = 0; if (Names.Text == "") { Response.Write("<script>alert('Все поля должны быть заполнены!');</script>"); return; } if (Email.Text == "") { Response.Write("<script>alert('Все поля должны быть заполнены!');</script>"); return; } if (Login.Text == "") { Response.Write("<script>alert('Все поля должны быть заполнены!');</script>"); return; } if (Password.Text == "") { Response.Write("<script>alert('Все поля должны быть заполнены!');</script>"); return; } if (ConfirmPassword.Text == "") { Response.Write("<script>alert('Все поля должны быть заполнены!');</script>"); return; } if (for_danger == 0) { SqlConnection = new OleDbConnection(connectString); await SqlConnection.OpenAsync(); OleDbDataReader sqlReader = null; OleDbCommand command = new OleDbCommand("INSERT INTO [Пользователи] ([ФИО],[Адрес электронной почты],[Пароль],Логин,Статус)VALUES(@1,@2,@3,@4,@5)", SqlConnection); command.Parameters.AddWithValue("@1", Names.Text); command.Parameters.AddWithValue("@2", Email.Text); command.Parameters.AddWithValue("@3", Password.Text); command.Parameters.AddWithValue("@4", Login.Text); command.Parameters.AddWithValue("@5", "Ученик"); OleDbCommand command1 = new OleDbCommand("SELECT * FROM [Пользователи]", SqlConnection); sqlReader = command1.ExecuteReader(); while (sqlReader.Read()) { if (Login.Text == Convert.ToString(sqlReader["Логин"])) { Response.Write("<script>alert('Пользователь с таким логином заргестрирован');</script>"); return; } } sqlReader.Close(); await command.ExecuteNonQueryAsync(); string for_id = "1"; command = new OleDbCommand("SELECT * FROM [Пользователи]", SqlConnection); sqlReader = command.ExecuteReader(); while (sqlReader.Read()) { if (Login.Text == Convert.ToString(sqlReader["Логин"])) { for_id = Convert.ToString(sqlReader["Код"]); } } Response.Redirect("~/Default_page_past.aspx?userID=" + for_id, false); return; } }
private void ReceiveClientMessage(Socket ClientSocket) { string USERID = ""; while (true) { string ClientMessagePackage = ""; try { byte[] MessageBuffer = new byte[ClientSocket.ReceiveBufferSize - 1]; int MessageBufferSize = ClientSocket.Receive(MessageBuffer); ClientMessagePackage = Encoding.UTF8.GetString(MessageBuffer, 0, MessageBufferSize); } catch (ThreadAbortException) { return; } catch (Exception ex) { UnityModule.DebugPrint("接收客户端消息时遇到错误:{0}", ex.Message); UserSignOut(USERID, ref ClientSocket); UnityModule.DebugPrint("用户 {0} 异常下线,当前在线总数:{1}", USERID, SocketsDictionary.Count.ToString()); return; } string[] ClientMessages = ClientMessagePackage.Split('\n'); foreach (string TempClientMessage in ClientMessages) { try { if (string.IsNullOrEmpty(TempClientMessage)) { continue; } string ClientMessage = TempClientMessage + '\n'; UnityModule.DebugPrint("收到客户端发送来的数据:{0}", ClientMessage); string MessagePattern = ProtocolFormatter.GetCMDTypePattern(); Regex MessageRegex = new Regex(MessagePattern, RegexOptions.IgnoreCase | RegexOptions.Singleline); Match MessageMatchResult = MessageRegex.Match(ClientMessage); string cmdType = MessageMatchResult.Groups["CMDTYPE"].Value.ToUpper(); switch (cmdType) { case "CHATMESSAGE": { MessagePattern = ProtocolFormatter.GetProtocolPattern(ProtocolFormatter.CMDType.ChatMessage); MessageRegex = new Regex(MessagePattern, RegexOptions.IgnoreCase | RegexOptions.Singleline); MessageMatchResult = MessageRegex.Match(ClientMessage); string ToID = MessageMatchResult.Groups["TOID"].Value; string Message = MessageMatchResult.Groups["MESSAGE"].Value; UnityModule.DebugPrint("消息来自:{0} 发送给:{1} 内容:{2}", USERID, ToID, Encoding.UTF8.GetString(Convert.FromBase64String(Message))); //判断对方是否连接 if (SocketsDictionary.ContainsKey(ToID)) { string MessageID = null; UnityDBController.ExecuteNonQuery("INSERT INTO CHATBASE (FromID,ToID,ChatTime,Message,SentYet) VALUES ('{0}','{1}','{2}','{3}',YES)", USERID, ToID, DateTime.UtcNow, Message); MessageID = UnityDBController.ExecuteScalar("SELECT MAX(ID) FROM CHATBASE WHERE FROMID='{0}'\n", USERID).ToString(); SocketsDictionary[ToID].Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.ChatMessage, USERID, DateTime.UtcNow.ToString(), MessageID, Message))); } else { UnityDBController.ExecuteNonQuery("INSERT INTO CHATBASE (FromID,ToID,ChatTime,Message,SentYet) VALUES ('{0}','{1}','{2}','{3}',NO)", USERID, ToID, DateTime.UtcNow, Message); } break; } case "GETCHATHISTORY": { //TODO:获取历史聊天记录 break; } case "SIGNIN": { //用户登录消息 MessagePattern = ProtocolFormatter.GetProtocolPattern(ProtocolFormatter.CMDType.SignIn); MessageRegex = new Regex(MessagePattern, RegexOptions.IgnoreCase | RegexOptions.Singleline); MessageMatchResult = MessageRegex.Match(ClientMessage); string UserID = MessageMatchResult.Groups["USERID"].Value; string Password = MessageMatchResult.Groups["PASSWORD"].Value; object CheckUserID = UnityDBController.ExecuteScalar("SELECT UserID FROM UserBase WHERE UserID='{0}' AND Password='******';", UserID, Password); if (CheckUserID != null) { //用户登陆成功! UnityModule.DebugPrint("用户登录成功!{0}", CheckUserID as string); ClientSocket.Send(Encoding.ASCII.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.SignInSuccessfully, CheckUserID as string))); } else { //用户发生一次错误的密码验证! UnityModule.DebugPrint("用户登录失败!{0}", UserID); ClientSocket.Send(Encoding.ASCII.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.SignInUnsuccessfully, UserID as string))); } //验证成功后关闭Socket ClientSocket?.Close(); //验证完成后需要结束接收消息线程 return; } case "WHOAMI": { MessagePattern = ProtocolFormatter.GetProtocolPattern(ProtocolFormatter.CMDType.WhoAmI); MessageRegex = new Regex(MessagePattern, RegexOptions.IgnoreCase | RegexOptions.Singleline); MessageMatchResult = MessageRegex.Match(ClientMessage); USERID = MessageMatchResult.Groups["USERID"].Value; if (SocketsDictionary.ContainsKey(USERID)) { UnityModule.DebugPrint("用户 {0} 已经在 {1} 登录,即将被顶下线...", USERID, SocketsDictionary[USERID].RemoteEndPoint.ToString()); Socket TempSocket = SocketsDictionary[USERID]; TempSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.AnothorSignIn, USERID))); Thread TempThread = ReceiveThreadDictionary[TempSocket.RemoteEndPoint.ToString()]; ReceiveThreadDictionary.Remove(TempSocket.RemoteEndPoint.ToString()); TempThread.Abort(); SocketsDictionary.Remove(USERID); TempSocket?.Close(); } //以USERID为KEY,记录Socket SocketsDictionary.Add(USERID, ClientSocket); //好友登录 UserSignIn(USERID, ref ClientSocket); UnityModule.DebugPrint("用户 {0} 在 {1} 上线,当前在线总数:{2}", USERID, ClientSocket.RemoteEndPoint.ToString(), SocketsDictionary.Count.ToString()); break; } case "GETFRIENDSLIST": { OleDbDataReader FriendsListReader = UnityDBController.ExecuteReader("SELECT UserID,NickName,Signature,OnLine FROM UserBase WHERE UserID IN(SELECT Guest FROM FriendBase WHERE Host ='{0}')", USERID); if (FriendsListReader != null && FriendsListReader.HasRows) { while (FriendsListReader.Read()) { string FriendID = null; string NickName = null; string Signature = null; bool OnLine = false; try { FriendID = FriendsListReader["UserID"] as string; //??""很重要,否则封装协议消息时会因为string类型变量为引用而出错 NickName = FriendsListReader["NickName"] as string ?? "(无昵称)"; Signature = FriendsListReader["Signature"] as string ?? "(无签名)"; OnLine = (bool)FriendsListReader["OnLine"]; } catch (Exception ex) { UnityModule.DebugPrint("读取用户{0}的好友{1}信息时遇到错误:{2}", USERID, FriendID, ex.Message); } ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.GetFriendsList, FriendID, NickName, Signature, OnLine.ToString().ToUpper()))); } } FriendsListReader.Close(); //发送[好友列表发送完成]消息 ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.FriendsListComplete, USERID))); break; } case "GETMESSAGENOTSENDYET": { OleDbDataReader MessageNRYReader = UnityDBController.ExecuteReader("SELECT * FROM ChatBase WHERE ToID ='{0}' AND SentYet = NO", USERID); if (MessageNRYReader != null && MessageNRYReader.HasRows) { List <string> MessageIDList = new List <string>(); while (MessageNRYReader.Read()) { string MessageID = null; string FromID = null; string ChatTime = null; string ChatMessage = null; try { MessageID = MessageNRYReader["ID"].ToString(); FromID = MessageNRYReader["FromID"] as string; ChatTime = ((DateTime)MessageNRYReader["ChatTime"]).ToString(); ChatMessage = MessageNRYReader["Message"] as string; MessageIDList.Add(MessageID); } catch (Exception ex) { UnityModule.DebugPrint("读取消息ID{0}时遇到错误:{2}", MessageID, ex.Message); } ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.ChatMessage, FromID, ChatTime, MessageID, ChatMessage))); } MessageNRYReader?.Close(); foreach (string messageID in MessageIDList) { UnityDBController.ExecuteNonQuery("UPDATE ChatBase SET SentYet = YES WHERE ID = {0}", messageID); } } MessageNRYReader?.Close(); //发送[暂存消息发送完成]消息 ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.MessageNSYComplete, USERID))); break; } case "SIGNOUT": { UserSignOut(USERID, ref ClientSocket); UnityModule.DebugPrint("用户 {0} 正常下线,当前在线总数:{1}", USERID, SocketsDictionary.Count.ToString()); return; } default: { UnityModule.DebugPrint("遇到未知消息:{0}", ClientMessage); ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.ChatMessage, UnityModule.ServerNickName, DateTime.UtcNow.ToString(), "0", Convert.ToBase64String(Encoding.UTF8.GetBytes("服务端收到你发来未知的CMDTYPE:" + cmdType + " 消息原文:" + ClientMessage))))); break; } } } catch (ThreadAbortException) { return; } catch (Exception ex) { UnityModule.DebugPrint("分析并回应用户消息时发生错误:{0}", ex.Message); } } } }
protected void addColumnButton_Click(object sender, EventArgs e) { if (perm == "admin") { try { List <string> columnNames = new List <string>(); string tempAdder = String.Empty; string userID = String.Empty; assetsConn.Open(); assetsCmd.Connection = assetsConn; assetsCmd.CommandText = "SELECT * FROM People"; OleDbDataReader dr = assetsCmd.ExecuteReader(); for (int i = 0; i < dr.FieldCount; i++) { columnNames.Add(dr.GetName(i)); } dr.Close(); assetsConn.Close(); if (columnNames.Count <= 12) { assetsConn.Open(); assetsCmd.Connection = assetsConn; assetsCmd.CommandText = "ALTER TABLE People ADD " + columnBox.Text + " string"; assetsCmd.ExecuteNonQuery(); assetsConn.Close(); assetsCmd.Parameters.Clear(); } usersConn.Open(); usersCmd.CommandText = "SELECT ID FROM Users WHERE Login = @login"; usersCmd.Parameters.AddWithValue("@login", HttpContext.Current.User.Identity.Name); userID = usersCmd.ExecuteScalar().ToString(); usersCmd.Parameters.Clear(); usersConn.Close(); Scripts.OperationLogCreator op = new Scripts.OperationLogCreator(); op.OperationLog("UserID: " + userID + " || Operacja wykonana: dodanie pola opisowego: " + columnBox.Text + " do tabeli People"); ClearTextBoxes(); } catch (Exception exc) { Scripts.ErrorLogCreator err = new Scripts.ErrorLogCreator(); err.ErrorLog(exc.Message); errorLabel.Text = "Błąd! " + exc.Message; } finally { assetsConn.Close(); usersConn.Close(); } } }
// Display the result set recursively expanding chapterDepth deep static void DisplayReader(OleDbDataReader myDataReader, ref uint count, uint alignment, int chapterDepth) { try { // compute alignment StringBuilder indent = new StringBuilder((int)alignment); indent.Append(' ', (int)alignment); while (myDataReader.Read()) { // add alignment StringBuilder row = new StringBuilder(indent.ToString()); // for all columns for (int i = 0; i < myDataReader.FieldCount; i++) { // null columns if (myDataReader.IsDBNull(i)) { row.Append("NULL;"); } else { //vector columns object[] myArray = myDataReader.GetValue(i) as object[]; if (myArray != null) { DisplayValue(myArray, row); } else { //check for chapter columns from "group on" queries if (myDataReader.GetFieldType(i).ToString() != "System.Data.IDataReader") { //regular columns are displayed here row.Append(myDataReader.GetValue(i)); } else { //for a chapter column type just display the colum name row.Append(myDataReader.GetName(i)); } } row.Append(';'); } } if (chapterDepth >= 0) { Console.WriteLine(row); count++; } // for each chapter column for (int i = 0; i < myDataReader.FieldCount; i++) { if (myDataReader.GetFieldType(i).ToString() == "System.Data.IDataReader") { OleDbDataReader Reader = myDataReader.GetValue(i) as OleDbDataReader; DisplayReader(Reader, ref count, alignment + 8, chapterDepth - 1); } } } } finally { myDataReader.Close(); myDataReader.Dispose(); } }
protected void updateButton_Click(object sender, EventArgs e) { if (perm == "admin") { try { List <string> columnNames = new List <string>(); String[] values; string tempAdder = String.Empty; string userID = String.Empty; int counter = 2; int maxCounter = 0; assetsConn.Open(); assetsCmd.Connection = assetsConn; assetsCmd.CommandText = "SELECT * FROM People"; OleDbDataReader dr = assetsCmd.ExecuteReader(); for (int i = 0; i < dr.FieldCount; i++) { columnNames.Add(dr.GetName(i)); } values = DescriptionBox.Text.Split(';'); maxCounter = columnNames.Count; dr.Close(); assetsConn.Close(); for (int i = 2; i < maxCounter; i++) { if (i == maxCounter - 1) { tempAdder += columnNames[i] + " = @v" + (i - 1) + " "; } else { tempAdder += columnNames[i] + " = @v" + (i - 1) + ", "; } } assetsConn.Open(); if (UserNameBox.Text == String.Empty && DescriptionBox.Text != String.Empty) { assetsCmd.CommandText = "UPDATE People SET " + tempAdder + "WHERE ID = @id"; } else { assetsCmd.CommandText = "UPDATE People SET " + columnNames[1] + " = @v0, " + tempAdder + "WHERE ID = @id"; } assetsCmd.Parameters.AddWithValue("@v0", UserNameBox.Text); for (int i = 1; i < (maxCounter - 1); i++) { string v = "@v" + i; if (counter < maxCounter && values.Length == columnNames.Count - 2) { assetsCmd.Parameters.AddWithValue(v, values[counter - 2]); counter++; } else if (counter < maxCounter && values.Length < columnNames.Count - 2) { if (counter - 2 < values.Length) { assetsCmd.Parameters.AddWithValue(v, values[counter - 2]); } else { assetsCmd.Parameters.AddWithValue(v, String.Empty); } counter++; } else if (counter < maxCounter && values.Length > columnNames.Count - 2) { if (counter - 2 < columnNames.Count - 2) { assetsCmd.Parameters.AddWithValue(v, values[counter - 2]); } counter++; } } assetsCmd.Parameters.AddWithValue("@id", IDBox.Text); assetsCmd.ExecuteNonQuery(); assetsConn.Close(); assetsCmd.Parameters.Clear(); usersConn.Open(); usersCmd.CommandText = "SELECT ID FROM Users WHERE Login = @login"; usersCmd.Parameters.AddWithValue("@login", HttpContext.Current.User.Identity.Name); userID = usersCmd.ExecuteScalar().ToString(); usersCmd.Parameters.Clear(); usersConn.Close(); Scripts.OperationLogCreator op = new Scripts.OperationLogCreator(); op.OperationLog("UserID: " + userID + " || Operacja wykonana: aktualizacja danych o użytkowniku z ID: " + IDBox.Text + " w tabeli People"); ClearTextBoxes(); } catch (Exception exc) { Scripts.ErrorLogCreator err = new Scripts.ErrorLogCreator(); err.ErrorLog(exc.Message); errorLabel.Text = "Błąd! " + exc.Message; } finally { assetsConn.Close(); usersConn.Close(); } } }
public void createBalanza() { string strAccessConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=database\\" + this.databaseFileName; string strAccessSelect = "SELECT * FROM [Add Acumulados] INNER JOIN [CatalogoCuentasSatVendor] ON [Add Acumulados].[SUBCTA] = [CatalogoCuentasSatVendor].[NumCta]"; DataSet myDataSet = new DataSet(); OleDbConnection myAccessConn = null; try { myAccessConn = new OleDbConnection(strAccessConn); } catch (Exception ex) { Console.WriteLine("Error: Failed to create a database connection. \n{0}", ex.Message); return; } try { myAccessConn.Open(); OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn); OleDbDataReader reader = myAccessCommand.ExecuteReader(); List <SatContabilidad.Balanza.BalanzaCtas> balanzaCtas = new List <SatContabilidad.Balanza.BalanzaCtas>(); while (reader.Read()) { SatContabilidad.Balanza.BalanzaCtas balanzaCta = new Balanza.BalanzaCtas(); balanzaCta.NumCta = reader["SUBCTA"].ToString().Trim(); balanzaCta.SaldoIni = 0; balanzaCta.Debe = Decimal.Parse(reader["MOVDEB"].ToString()); balanzaCta.Haber = Decimal.Parse(reader["MOVHAB"].ToString()); balanzaCta.SaldoFin = balanzaCta.Haber - balanzaCta.Debe; balanzaCtas.Add(balanzaCta); } reader.Close(); myAccessConn.Close(); SatContabilidad.Balanza.Balanza balanza = new Balanza.Balanza(); balanza.TipoEnvio = "N"; balanza.schemaLocation = "www.sat.gob.mx/esquemas/ContabilidadE/1_1/BalanzaComprobacion http://www.sat.gob.mx/esquemas/ContabilidadE/1_1/BalanzaComprobacion/BalanzaComprobacion_1_1.xsd"; balanza.Anio = int.Parse(this.year); balanza.Ctas = balanzaCtas.ToArray <Balanza.BalanzaCtas>(); Type mes = typeof(Balanza.BalanzaMes); balanza.Mes = (Balanza.BalanzaMes)Enum.Parse(mes, (int.Parse(this.month) - 1).ToString()); balanza.RFC = this.rfc; XmlSerializer serializer = new XmlSerializer(typeof(SatContabilidad.Balanza.Balanza)); System.IO.TextWriter writer = new System.IO.StreamWriter(this.outputPath + this.rfc + this.year + this.month + "BN.xml"); XmlSerializerNamespaces ns = new XmlSerializerNamespaces(); ns.Add("BCE", "www.sat.gob.mx/esquemas/ContabilidadE/1_1/BalanzaComprobacion"); ns.Add("xsi", "http://www.w3.org/2001/XMLSchema-instance"); serializer.Serialize(writer, balanza, ns); } catch (Exception ex) { Console.WriteLine("Error: Failed to retrive the required data from the Database.\n{0}", ex.Message); return; } finally { myAccessConn.Close(); } }
// my Functions // for checking whether Control Exist or not private bool isControlExist() { bool ret = false; string Qry = "select * from Column_Tab where Clm_Name ='" + txtCntlrName.Text + "';"; if (cmbCntrlType.Text == "Column") { Qry = "select * from Column_Tab where Clm_Name ='" + txtCntlrName.Text + "';"; } else if (cmbCntrlType.Text == "Beam") { Qry = "select * from Beam_Tab where Bm_Name ='" + txtCntlrName.Text + "';"; } else if (cmbCntrlType.Text == "Wall") { Qry = "select * from Wall_Tab where Wl_Name ='" + txtCntlrName.Text + "';"; } else if (cmbCntrlType.Text == "Window" || cmbCntrlType.Text == "Door") { Qry = "select * from Window_Tab where Win_Name ='" + txtCntlrName.Text + "';"; } else if (cmbCntrlType.Text == "Base") { Qry = "select * from Base_Tab where BS_Name ='" + txtCntlrName.Text + "';"; } else if (cmbCntrlType.Text == "Roof") { Qry = "select * from Roof_Tab where Rf_Name ='" + txtCntlrName.Text + "';"; } try { OleDbConnection con = new OleDbConnection(ConStr); OleDbCommand cmd = new OleDbCommand(Qry, con); con.Open(); OleDbDataReader Dr = null; Dr = cmd.ExecuteReader(); if (Dr.HasRows) { while (Dr.Read()) { EdtCntrl = Dr.GetString(1); ret = true; } } else { MessageBox.Show("there is no such " + cmbCntrlType.Text, "Information", MessageBoxButtons.OK); } if (Dr != null) { Dr.Close(); } if (con != null) { con.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK); } return(ret); }
public void createPolizasPeriodo() { string strAccessConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=database\\" + this.databaseFileName; string strAccessSelect = "SELECT * FROM [Apuntes_Polizas_Import]"; DataSet myDataSet = new DataSet(); OleDbConnection myAccessConn = null; try { myAccessConn = new OleDbConnection(strAccessConn); } catch (Exception ex) { Console.WriteLine("Error: Failed to create a database connection. \n{0}", ex.Message); return; } try { myAccessConn.Open(); OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn); OleDbDataReader reader = myAccessCommand.ExecuteReader(); List <SatContabilidad.Polizas.PolizasPoliza> polizas = new List <SatContabilidad.Polizas.PolizasPoliza>(); while (reader.Read()) { SatContabilidad.Polizas.PolizasPoliza poliza = new SatContabilidad.Polizas.PolizasPoliza(); List <SatContabilidad.Polizas.PolizasPolizaTransaccion> transacciones = new List <Polizas.PolizasPolizaTransaccion>(); SatContabilidad.Polizas.PolizasPolizaTransaccion transaccion = new Polizas.PolizasPolizaTransaccion(); List <SatContabilidad.Polizas.PolizasPolizaTransaccionOtrMetodoPago> otrosMetodosdePago = new List <Polizas.PolizasPolizaTransaccionOtrMetodoPago>(); Polizas.PolizasPolizaTransaccionOtrMetodoPago otroMetodoPago = new Polizas.PolizasPolizaTransaccionOtrMetodoPago(); switch (reader["MONEDA"].ToString()) { case "DL": otroMetodoPago.Moneda = SatContabilidad.Polizas.c_Moneda.USD; otroMetodoPago.TipCamb = Decimal.Parse(reader["CAMAPU"].ToString()); otroMetodoPago.TipCambSpecified = true; break; default: otroMetodoPago.Moneda = SatContabilidad.Polizas.c_Moneda.MXN; otroMetodoPago.TipCambSpecified = false; break; } otroMetodoPago.MonedaSpecified = true; otroMetodoPago.Monto = Decimal.Parse(reader["IMPAPU"].ToString()); otroMetodoPago.RFC = this.rfc; otrosMetodosdePago.Add(otroMetodoPago); transaccion.OtrMetodoPago = otrosMetodosdePago.ToArray <SatContabilidad.Polizas.PolizasPolizaTransaccionOtrMetodoPago>(); transacciones.Add(transaccion); poliza.Transaccion = transacciones.ToArray <SatContabilidad.Polizas.PolizasPolizaTransaccion>(); polizas.Add(poliza); } reader.Close(); myAccessConn.Close(); SatContabilidad.Polizas.Polizas polizasLast = new SatContabilidad.Polizas.Polizas(); polizasLast.schemaLocation = "www.sat.gob.mx/esquemas/ContabilidadE/1_1/CatalogoCuentas/CatalogoCuentas_1_1.xsd"; polizasLast.Anio = int.Parse(this.year); Type mes = typeof(Polizas.PolizasMes); polizasLast.Mes = (Polizas.PolizasMes)Enum.Parse(mes, (int.Parse(this.month) - 1).ToString()); polizasLast.Poliza = polizas.ToArray <SatContabilidad.Polizas.PolizasPoliza>(); polizasLast.RFC = this.rfc; XmlSerializer serializer = new XmlSerializer(typeof(SatContabilidad.Polizas.Polizas)); System.IO.TextWriter writer = new System.IO.StreamWriter(this.outputPath + this.rfc + this.year + this.month + "PL.xml"); serializer.Serialize(writer, polizasLast); } catch (Exception ex) { Console.WriteLine("Error: Failed to retrive the required data from the Database.\n{0}", ex.Message); return; } finally { myAccessConn.Close(); } }
private void ToolStripTextBox1_TextChanged(object sender, EventArgs e) { baglanti(); DataGridView1.Rows.Clear(); if (ToolStripTextBox1.Text.Length < 1) { ToolStripTextBox1.BackColor = Color.DarkRed; } else { ToolStripTextBox1.BackColor = Color.LimeGreen; } if (StokKoduToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE StokKodu LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } if (CinsiToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Cinsi LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } if (BirimiToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Birimi LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } if (SınıfıToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Sinifi LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } if (GrubuToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Grubu LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } if (RafNumarasıToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE RafNo LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } if (GözNumarasıToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE GozNo LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } if (AçıklamaToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Aciklama LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } if (FiyatToolStripMenuItem.Checked) { DataGridView1.Rows.Clear(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Fiyat LIKE '%" + ToolStripTextBox1.Text + "%'", bag); OleDbDataReader oku = cmd.ExecuteReader(); while (oku.Read()) { DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString()); } oku.Close(); } }