public static void Read(this Beatmap beatmap, SQLiteDataReader reader) { int i = 1; beatmap.TitleRoman = reader.GetString(i); i++; beatmap.ArtistRoman = reader.GetString(i); i++; beatmap.TitleUnicode = reader.GetString(i); i++; beatmap.ArtistUnicode = reader.GetString(i); i++; beatmap.Creator = reader.GetString(i); i++; beatmap.DiffName = reader.GetString(i); i++; beatmap.Mp3Name = reader.GetString(i); i++; beatmap.Md5 = reader.GetString(i); i++; beatmap.OsuFileName = reader.GetString(i); i++; beatmap.MaxBpm = reader.GetDouble(i); i++; beatmap.MinBpm = reader.GetDouble(i); i++; beatmap.Tags = reader.GetString(i); i++; beatmap.State = reader.GetByte(i); i++; beatmap.Circles = (short)reader.GetInt32(i); i++; beatmap.Sliders = (short)reader.GetInt32(i); i++; beatmap.Spinners = (short)reader.GetInt32(i); i++; beatmap.EditDate = reader.GetDateTime(i).ToUniversalTime(); i++; beatmap.ApproachRate = (float)reader.GetDouble(i); i++; beatmap.CircleSize = (float)reader.GetDouble(i); i++; beatmap.HpDrainRate = (float)reader.GetDouble(i); i++; beatmap.OverallDifficulty = (float)reader.GetDouble(i); i++; beatmap.SliderVelocity = reader.GetDouble(i); i++; beatmap.DrainingTime = reader.GetInt32(i); i++; beatmap.TotalTime = reader.GetInt32(i); i++; beatmap.PreviewTime = reader.GetInt32(i); i++; beatmap.MapId = reader.GetInt32(i); i++; beatmap.MapSetId = reader.GetInt32(i); i++; beatmap.ThreadId = reader.GetInt32(i); i++; /*beatmap.MapRating =*/ reader.GetInt32(i); i++; beatmap.Offset = (short)reader.GetInt32(i); i++; var stackLeniency = reader.SafeGetDouble(i); i++; beatmap.StackLeniency = double.IsNaN(stackLeniency) ? 0 : (float)stackLeniency;//TODO: (CollectionManager) StackLeniency has to be nullable beatmap.PlayMode = (PlayMode)reader.GetByte(i); i++; beatmap.Source = reader.GetString(i); i++; beatmap.AudioOffset = (short)reader.GetInt32(i); i++; beatmap.LetterBox = reader.GetString(i); i++; beatmap.Played = reader.GetBoolean(i); i++; beatmap.LastPlayed = reader.GetDateTime(i).ToUniversalTime(); i++; beatmap.IsOsz2 = reader.GetBoolean(i); i++; beatmap.Dir = reader.GetString(i); i++; beatmap.LastSync = reader.GetDateTime(i).ToUniversalTime(); i++; beatmap.DisableHitsounds = reader.GetBoolean(i); i++; beatmap.DisableSkin = reader.GetBoolean(i); i++; beatmap.DisableSb = reader.GetBoolean(i); i++; beatmap.BgDim = reader.GetInt16(i); i++; beatmap.Somestuff = reader.GetInt16(i); i++; beatmap.DeSerializeStars((byte[])reader.GetValue(i)); i++; i++; // beatmapChecksum beatmap.MainBpm = reader.GetDouble(i); }
private static void ReadPlayerInfo(SQLiteDataReader reader, Player player) { player.Id = (uint)reader.GetInt32(0); player.Name = reader.GetString(1); player.Gender = (Gender)reader.GetByte(2); player.Vocation = (Vocation)reader.GetByte(3); player.Level = (ushort)reader.GetInt16(4); player.MagicLevel = reader.GetByte(5); player.Experience = (uint)reader.GetInt32(6); player.MaxHealth = (ushort)reader.GetInt16(7); player.MaxMana = (ushort)reader.GetInt16(8); player.Capacity = (uint)reader.GetInt32(9); player.Outfit.LookType = (ushort)reader.GetInt16(10); player.Outfit.Head = reader.GetByte(11); player.Outfit.Body = reader.GetByte(12); player.Outfit.Legs = reader.GetByte(13); player.Outfit.Feet = reader.GetByte(14); player.Outfit.Addons = reader.GetByte(15); if (reader.GetInt64(20) > 0) { int x = reader.GetInt32(16); int y = reader.GetInt32(17); int z = reader.GetInt32(18); player.SavedLocation = new Location(x, y, z); player.Direction = (Direction)reader.GetByte(19); player.LastLogin = new DateTime(reader.GetInt64(20)); } player.Speed = (ushort)(220 + (2 * (player.Level - 1))); }
public static void Read(this Beatmap beatmap, SQLiteDataReader reader) { int i = 1; beatmap.TitleRoman = reader.GetString(i); i++; beatmap.ArtistRoman = reader.GetString(i); i++; beatmap.TitleUnicode = reader.GetString(i); i++; beatmap.ArtistUnicode = reader.GetString(i); i++; beatmap.Creator = reader.GetString(i); i++; beatmap.DiffName = reader.GetString(i); i++; beatmap.Mp3Name = reader.GetString(i); i++; beatmap.Md5 = reader.GetString(i); i++; beatmap.OsuFileName = reader.GetString(i); i++; beatmap.MaxBpm = reader.GetDouble(i); i++; beatmap.MinBpm = reader.GetDouble(i); i++; beatmap.Tags = reader.GetString(i); i++; beatmap.State = reader.GetByte(i); i++; beatmap.Circles = (short)reader.GetInt32(i); i++; beatmap.Sliders = (short)reader.GetInt32(i); i++; beatmap.Spinners = (short)reader.GetInt32(i); i++; beatmap.EditDate = reader.GetDateTime(i); i++; beatmap.ApproachRate = (float)reader.GetDouble(i); i++; beatmap.CircleSize = (float)reader.GetDouble(i); i++; beatmap.HpDrainRate = (float)reader.GetDouble(i); i++; beatmap.OverallDifficulty = (float)reader.GetDouble(i); i++; beatmap.SliderVelocity = reader.GetDouble(i); i++; beatmap.DrainingTime = reader.GetInt32(i); i++; beatmap.TotalTime = reader.GetInt32(i); i++; beatmap.PreviewTime = reader.GetInt32(i); i++; beatmap.MapId = reader.GetInt32(i); i++; beatmap.MapSetId = reader.GetInt32(i); i++; beatmap.ThreadId = reader.GetInt32(i); i++; beatmap.MapRating = reader.GetInt32(i); i++; beatmap.Offset = (short)reader.GetInt32(i); i++; beatmap.StackLeniency = (float)reader.GetDouble(i); i++; beatmap.Mode = reader.GetByte(i); i++; beatmap.Source = reader.GetString(i); i++; beatmap.AudioOffset = (short)reader.GetInt32(i); i++; beatmap.LetterBox = reader.GetString(i); i++; beatmap.Played = reader.GetBoolean(i); i++; beatmap.LastPlayed = reader.GetDateTime(i); i++; beatmap.IsOsz2 = reader.GetBoolean(i); i++; beatmap.Dir = reader.GetString(i); i++; beatmap.LastSync = reader.GetDateTime(i); i++; beatmap.DisableHitsounds = reader.GetBoolean(i); i++; beatmap.DisableSkin = reader.GetBoolean(i); i++; beatmap.DisableSb = reader.GetBoolean(i); i++; beatmap.BgDim = reader.GetInt16(i); i++; beatmap.Somestuff = reader.GetInt16(i); i++; beatmap.VideoDir = reader.GetString(i); }
private void AddFromRecordSet(SQLiteDataReader rs) { try { if (!rs.IsDBNull(0)) { _class_id = (ExtendedProperty_Type)rs.GetByte(0); } if (!rs.IsDBNull(1)) { _class_desc = rs.GetString(1); } if (!rs.IsDBNull(2)) { _major_id = rs.GetInt32(2); } if (!rs.IsDBNull(3)) { _minor_id = rs.GetInt32(3); } if (!rs.IsDBNull(4)) { _name = rs.GetString(4); } if (!rs.IsDBNull(5)) { _value = rs.GetValue(5); } } catch (Exception) { throw; } }
private void Window_Loaded(object sender, RoutedEventArgs e) { using (SQLiteConnection con = new SQLiteConnection(Adress)) using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Users WHERE userName=@uName", con)) { con.Open(); cmd.Parameters.AddWithValue("@uName", TEMP.active_User); using (SQLiteDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { reader.Read(); UserNameTxt.Content = reader.GetString(0); RealNameTbox.Text = reader.GetString(2); TelNoTbox.Text = reader.GetInt64(3).ToString(); AccTypeTbox.Content = (reader.GetByte(4) == 1) ? "Admin" : "User"; reader.Close(); } else { MessageBox.Show("Sorunla karşılaşıldı", "OPPPS", MessageBoxButton.OK, MessageBoxImage.Error); } } con.Close(); cmd.Dispose(); } }
public static List <EquipmentData> GetListByTime2(string equipmentID, DateTime dt1, DateTime dt2) { //dt2 = dt2.AddDays(1); string sql = string.Format("select a.EquipmentID,a.Chroma,a.Temperature,a.Humidity,a.AddTime,b.UnitType from tb_EquipmentData a left join tb_Equipment b on a.EquipmentID=b.ID where EquipmentID in ({0}) and AddTime >='{1}' and AddTime <='{2}'", equipmentID, dt1.ToString("yyyy-MM-dd HH:mm:ss"), dt2.ToString("yyyy-MM-dd HH:mm:ss")); List <EquipmentData> list = new List <EquipmentData>(); Stopwatch watch = new Stopwatch(); watch.Start(); using (SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql)) { Trace.WriteLine("ExecuteReader: " + watch.Elapsed); watch.Restart(); while (reader.Read()) { EquipmentData eq = new EquipmentData(); eq.EquipmentID = reader.GetInt32(0); eq.Chroma = reader.GetFloat(1); eq.Chroma = eq.Chroma < 10000 ? eq.Chroma : 0; eq.AddTimeStr = reader[4].ToString(); eq.UnitType = reader.GetByte(5); list.Add(eq); } Trace.WriteLine("read: " + watch.Elapsed); } watch.Stop(); return(list); }
public static IEnumerable <Item> GetChildItems(int uniqueItemId) { parentUniqueIdParam.Value = uniqueItemId; SQLiteDataReader reader = ((SQLiteCommand)selectChildItemsCommand.Clone()).ExecuteReader(); try { while (reader.Read()) { int uniqueId = reader.GetInt32(0); ushort itemId = (ushort)reader.GetInt32(1); byte extra = reader.GetByte(2); Item item = Item.Create(itemId); item.Extra = extra; if (item is Container) { foreach (var i in GetChildItems(uniqueId)) { ((Container)item).AddItem(i); } } yield return(item); } } finally { reader.Close(); } }
public static IEnumerable <KeyValuePair <SlotType, Item> > GetPlayerInventory(uint playerId) { playerIdParam.Value = playerId; SQLiteDataReader reader = selectInventoryCommand.ExecuteReader(); try { while (reader.Read()) { SlotType slot = (SlotType)reader.GetInt32(0); int uniqueId = reader.GetInt32(1); ushort itemId = (ushort)reader.GetInt32(2); byte extra = reader.GetByte(3); Item item = Item.Create(itemId); item.Extra = extra; if (item is Container) { foreach (var i in GetChildItems(uniqueId)) { ((Container)item).AddItem(i); } } yield return(new KeyValuePair <SlotType, Item>(slot, item)); } } finally { reader.Close(); } }
private void recordsInList(SQLiteDataReader r) { liRecord lir = new liRecord(); lstLicentieRecord.Clear(); while (r.Read()) { //Maak list van geselecteerde rijen lir.Id = r.GetInt32(r.GetOrdinal("Lic_Id")); lir.Actief = r.GetInt16(r.GetOrdinal("Lic_Actief")); lir.Programma = r.GetString(r.GetOrdinal("Lic_Programma")); lir.Nr = r.GetInt32(r.GetOrdinal("Lic_Nr")); lir.Code = r.GetString(r.GetOrdinal("Lic_Code")); lir.Type = r.GetByte(r.GetOrdinal("Lic_Type")); lir.Usermode = r.GetInt16(r.GetOrdinal("Lic_Usermode")); lir.Naamlh = r.GetString(r.GetOrdinal("Lic_Naamlh")); lir.Displaynaamlh = r.GetString(r.GetOrdinal("Lic_Displaynaamlh")); lir.Contactpersoonlh = r.GetString(r.GetOrdinal("Lic_Contactpersoonlh")); lir.Adreslh = r.GetString(r.GetOrdinal("Lic_Adreslh")); lir.Postcodelh = r.GetString(r.GetOrdinal("Lic_Postcodelh")); lir.Woonplaatslh = r.GetString(r.GetOrdinal("Lic_Woonplaatslh")); lir.Telefoonnummerlh = r.GetString(r.GetOrdinal("Lic_Telefoonnummerlh")); lir.Emailadreslh = r.GetString(r.GetOrdinal("Lic_Emailadreslh")); lir.OudeControleCode = r.GetString(r.GetOrdinal("Lic_OudeControleCode")); lir.NieuweControleCode = r.GetString(r.GetOrdinal("Lic_NieuweControlecode")); lir.ControleCodeType = r.GetInt32(r.GetOrdinal("Lic_ControleCodetype")); lir.Mutatiedatum = r.GetDateTime(r.GetOrdinal("Lic_Mutatiedatum")); lir.Opmerking = r.GetString(r.GetOrdinal("Lic_Opmerking")); lstLicentieRecord.Add(lir); } }
public static void UpdateUserList() { Users.Clear(); using (SQLiteConnection connection = new SQLiteConnection("DataSource = " + _fullPathToDatabase + ";")) { connection.Open(); string commandText = "SELECT * FROM USERS ORDER BY NumberOfWins DESC;"; SQLiteCommand command = new SQLiteCommand(commandText, connection); using (SQLiteDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { string username = reader["Username"].ToString() ?? ""; Users.Add(reader.GetInt64(0), new User(username, reader.GetInt32(2), reader.GetByte(3))); } } } connection.Close(); } }
public IEnumerable <Country> GetAllCountries() { SQLiteConnection connection = GetConnectionForTable("azusa.countries"); SQLiteCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM azusa.countries"; SQLiteDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { Country country = new Country(); country.ID = dataReader.GetInt32(0); country.DisplayName = dataReader.GetString(1); country.BroadcastTelevisionSystem = dataReader.GetString(2); country.CurrencyName = dataReader.GetString(3); country.CurrencyConversion = dataReader.GetDouble(4); country.LanguageId = dataReader.GetInt32(5); if (!dataReader.IsDBNull(6)) { country.PowerVoltage = dataReader.GetInt16(6); } if (!dataReader.IsDBNull(7)) { country.PowerFrequency = dataReader.GetByte(7); } if (!dataReader.IsDBNull(8)) { country.DvdRegion = dataReader.GetByte(8); } if (!dataReader.IsDBNull(9)) { country.BlurayRegion = dataReader.GetString(9)[0]; } if (!dataReader.IsDBNull(10)) { country.DateAdded = dataReader.GetDateTime(10); } yield return(country); } dataReader.Dispose(); cmd.Dispose(); }
private void AddFromRecordSet(SQLiteDataReader rs) { try { if (!rs.IsDBNull(0)) { _object_id = rs.GetInt32(0); } if (!rs.IsDBNull(1)) { _index_id = rs.GetInt32(1); } if (!rs.IsDBNull(2)) { _index_column_id = rs.GetInt32(2); } if (!rs.IsDBNull(3)) { _column_id = rs.GetInt32(3); } if (!rs.IsDBNull(4)) { _key_ordinal = rs.GetByte(4); } if (!rs.IsDBNull(5)) { _partition_ordinal = rs.GetByte(5); } if (!rs.IsDBNull(6)) { _is_descending_key = rs.GetBoolean(6); } if (!rs.IsDBNull(7)) { _is_included_column = rs.GetBoolean(7); } } catch (Exception) { throw; } }
public void Load(T item) { _selectCommand.Parameters["@id"].Value = item.id; using (SQLiteDataReader reader = _selectCommand.Command.ExecuteReader()) { if (reader.Read()) { for (int i = 0; i < _allProperties.Count; i++) { PropertyInfo p = _allProperties[i]; if (p.PropertyType == typeof(string)) { p.SetValue(item, reader.GetString(i)); } else if (p.PropertyType == typeof(bool)) { p.SetValue(item, reader.GetBoolean(i)); } else if (p.PropertyType == typeof(Int64)) { p.SetValue(item, reader.GetInt64(i)); } else if (p.PropertyType == typeof(Int32)) { p.SetValue(item, reader.GetInt32(i)); } else if (p.PropertyType == typeof(Int16)) { p.SetValue(item, reader.GetInt16(i)); } else if (p.PropertyType == typeof(byte)) { p.SetValue(item, reader.GetByte(i)); } else if (p.PropertyType == typeof(Nullable <Int64>)) { object val = reader.GetValue(i); if (val is DBNull) { p.SetValue(item, null); } else if (val is long) { p.SetValue(item, (long)val); } } else { throw new Exception("Unhandled property type."); } } } } }
OutgoingFlow GetOutgoingMessage(SQLiteDataReader reader) { return(new OutgoingFlow() { PacketId = (ushort)reader.GetInt32(0), Retain = reader.GetBoolean(1), Topic = reader.GetString(2), Qos = GetQosLevel(reader.GetByte(3)), Payload = this.GetBlob(reader, 4), Received = reader.GetBoolean(5) }); }
private CountEntry ParseCountEntry(SQLiteDataReader rd) { CountEntry entry = new CountEntry(); entry.Itmref = rd.GetString(0); entry.LabelNumber = rd.GetInt32(1); entry.Time = rd.GetDateTime(2); entry.Value = (double)rd.GetDecimal(3); entry.Unit = rd.GetString(4); entry.IsDeleted = rd.GetByte(5) != 0; entry.Sync = (CountEntry.SyncStatus)rd.GetInt32(6); entry.Hash = rd.GetString(7); entry.SyncCode = rd.GetInt32(8); entry.Location = rd.IsDBNull(9) ? string.Empty : rd.GetString(9); return(entry); }
public Byte GetByte(ulong which) { string str = m_record.TranslateQueryValue(which); int i; for (i = 0; i < m_reader.FieldCount; ++i) { if (m_reader.GetName(i).Equals(str)) { break; } } if (i < m_reader.FieldCount) { return(m_reader.GetByte(0)); } throw new IndexOutOfRangeException(); }
private void recordsInList(SQLiteDataReader r) { pdRecord pdr = new pdRecord(); lstProductRecord.Clear(); pdListCount = 0; pdListTCount = 0; while (r.Read()) { //Maak list van geselecteerde rijen pdListTCount++; pdr.Prod_Id = r.GetInt32(r.GetOrdinal("Prod_Id")); pdr.Prod_StatusId = r.GetInt32(r.GetOrdinal("Prod_StatusId")); pdr.Prod_DispStatus = r.GetString(r.GetOrdinal("Prod_DispStatus")); if (r.GetInt32(r.GetOrdinal("Prod_StatusId")) != 170009) { pdListCount++; } pdr.Prod_Naamkort = r.GetString(r.GetOrdinal("Prod_Naamkort")); pdr.Prod_Naamlang = r.GetString(r.GetOrdinal("Prod_Naamlang")); pdr.Prod_Kleur = r.GetString(r.GetOrdinal("Prod_Kleur")); pdr.Prod_Code = r.GetString(r.GetOrdinal("Prod_Code")); pdr.Prod_Soort = r.GetString(r.GetOrdinal("Prod_Soort")); pdr.Prod_ActiefJN = r.GetInt16(r.GetOrdinal("Prod_ActiefJN")); pdr.Prod_Dispactief = r.GetString(r.GetOrdinal("Prod_Dispactief")); pdr.Prod_Waarde = r.GetDecimal(r.GetOrdinal("Prod_Waarde")); pdr.Prod_Aantaleenhedenperproduct = r.GetByte(r.GetOrdinal("Prod_Aantaleenhedenperproduct")); pdr.Prod_Verzamelnaam = r.GetString(r.GetOrdinal("Prod_Verzamelnaam")); pdr.Prod_Waardepereenheid = r.GetDecimal(r.GetOrdinal("Prod_Waardepereenheid")); pdr.Prod_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Prod_Mutatiedatum")); pdr.Prod_Opmerking = ""; try { pdr.Prod_Opmerking = r.GetString(r.GetOrdinal("Prod_Opmerking")); } catch (Exception) { } lstProductRecord.Add(pdr); } }
private void recordsInList(SQLiteDataReader r) { blRecord blr = new blRecord(); lstBestelregelRecord.Clear(); blListCount = 0; blListTCount = 0; while (r.Read()) { //Maak list van geselecteerde rijen blListTCount++; blr.Bstlr_Id = r.GetInt32(r.GetOrdinal("Bstlr_Id")); blr.Bstlr_BstlId = r.GetInt32(r.GetOrdinal("Bstlr_BstlId")); blr.Bstlr_StatusId = r.GetInt32(r.GetOrdinal("Bstlr_StatusId")); if (r.GetInt32(r.GetOrdinal("Bstlr_StatusId")) != 135009) { blListCount++; } blr.Bstlr_DispStatus = r.GetString(r.GetOrdinal("Bstlr_DispStatus")); blr.Bstlr_ProdId = r.GetInt32(r.GetOrdinal("Bstlr_ProdId")); blr.Bstlr_DispProduct = r.GetString(r.GetOrdinal("Bstlr_DispProduct")); blr.Bstlr_Aantal = r.GetByte(r.GetOrdinal("Bstlr_Aantal")); blr.Bstlr_Beginnr = r.GetInt64(r.GetOrdinal("Bstlr_Beginnr")); blr.Bstlr_Eindnr = r.GetInt64(r.GetOrdinal("Bstlr_Eindnr")); blr.Bstlr_Voorraad = r.GetInt64(r.GetOrdinal("Bstlr_Voorraad")); blr.Bstlr_Extranr1 = r.GetInt64(r.GetOrdinal("Bstlr_Extranr1")); blr.Bstlr_Extranr2 = r.GetInt64(r.GetOrdinal("Bstlr_Extranr2")); blr.Bstlr_Extranr3 = r.GetInt64(r.GetOrdinal("Bstlr_Extranr3")); blr.Bstlr_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Bstlr_Mutatiedatum")); try { blr.Bstlr_Opmerking = r.GetString(r.GetOrdinal("Bstlr_Opmerking")); } catch (Exception) { } lstBestelregelRecord.Add(blr); } }
private void recordsInList(SQLiteDataReader r) { ilRecord ilr = new ilRecord(); lstInstellingenRecord.Clear(); while (r.Read()) { //Maak list van geselecteerde rijen ilListTCount++; ilr.Instl_Id = r.GetInt32(r.GetOrdinal("Instl_Id")); ilr.Instl_Systeemsetting = r.GetInt32(r.GetOrdinal("Instl_Systeemsetting")); ilr.Instl_StatusId = r.GetInt32(r.GetOrdinal("Instl_StatusId")); ilr.Instl_DispStatus = r.GetString(r.GetOrdinal("Instl_DispStatus")); if (r.GetInt32(r.GetOrdinal("Instl_StatusId")) != 185009) { ilListCount++; } ilr.Instl_Naam = r.GetString(r.GetOrdinal("Instl_Naam")); ilr.Instl_Gegtype = r.GetByte(r.GetOrdinal("Instl_Gegtype")); ilr.Instl_Actief = r.GetInt32(r.GetOrdinal("Instl_Actief")); ilr.Instl_String = r.GetString(r.GetOrdinal("Instl_String")); ilr.Instl_JN = r.GetInt32(r.GetOrdinal("Instl_JN")); ilr.Instl_Integer = r.GetInt64(r.GetOrdinal("Instl_Integer")); ilr.Instl_Real = r.GetDecimal(r.GetOrdinal("Instl_Real")); ilr.Instl_Memo = r.GetString(r.GetOrdinal("Instl_Memo")); ilr.Instl_Datum = r.GetDateTime(r.GetOrdinal("Instl_Datum")); ilr.Instl_Tijd = r.GetDateTime(r.GetOrdinal("Instl_Tijd")); ilr.Instl_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Instl_Mutatiedatum")); try { ilr.Instl_Opmerking = r.GetString(r.GetOrdinal("Instl_Opmerking")); } catch (Exception) { } lstInstellingenRecord.Add(ilr); } }
static public string GetData(SQLiteDataReader reader, string column) { switch (Type.GetTypeCode(reader.GetFieldType(reader.GetOrdinal(column)))) { case TypeCode.Boolean: return(reader.GetBoolean(reader.GetOrdinal(column)).ToString()); case TypeCode.Byte: return(reader.GetByte(reader.GetOrdinal(column)).ToString()); case TypeCode.Char: return(reader.GetChar(reader.GetOrdinal(column)).ToString()); case TypeCode.DateTime: return(reader.GetDateTime(reader.GetOrdinal(column)).ToString("yyyy/mm/dd HH:mm:ss")); case TypeCode.Decimal: return(reader.GetDecimal(reader.GetOrdinal(column)).ToString()); case TypeCode.Double: return(reader.GetDouble(reader.GetOrdinal(column)).ToString()); case TypeCode.Int16: return(reader.GetInt16(reader.GetOrdinal(column)).ToString()); case TypeCode.Int32: return(reader.GetInt32(reader.GetOrdinal(column)).ToString()); case TypeCode.Int64: return(reader.GetInt64(reader.GetOrdinal(column)).ToString()); case TypeCode.String: return(reader.GetString(reader.GetOrdinal(column))); default: return(""); } }
public IEnumerable <Packet> ReadPackets(string file) { using (var connection = new SQLiteConnection("Data Source=" + file)) { var packets = new List <Packet>(); connection.Open(); SQLiteCommand command = connection.CreateCommand(); command.CommandText = "SELECT COUNT(*) FROM packets;"; command.Prepare(); var rows = (long)command.ExecuteScalar(); command.CommandText = "SELECT direction, opcode, data FROM packets ORDER BY id;"; command.Prepare(); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { //worker.ReportProgress((int)((float)m_packets.Count / (float)rows * 100.0f)); try { var direction = (Direction)reader.GetByte(0); var opcode = (OpCodes)reader.GetInt16(1); var data = (byte[])reader.GetValue(2); packets.Add(new Packet(direction, opcode, data, 0, 0)); } catch { } } return(packets); } }
public List <TableInfo> SelectAllFromTableInfo() { List <TableInfo> _list = new List <TableInfo>(); try { OpenConnection(); using (SQLiteConnection sqlConn = new SQLiteConnection(connectionDB)) using (SQLiteCommand cmd = new SQLiteCommand(sqlConn)) { cmd.CommandText = "SELECT * FROM info"; { using (SQLiteDataReader reader = cmd.ExecuteReader()) while (reader.Read()) { TableInfo item = new TableInfo(); item.ID = reader.GetInt64(0); item.Fio = reader.GetString(1); item.TabelNumb = reader.GetString(2); item.Shift = reader.GetString(3); item.NormDoc = reader.GetString(4); item.Specification = reader.GetString(5); item.Drawing = reader.GetString(6); item.SteelType = reader.GetString(7); item.SopNumb = reader.GetString(8); item.Lot = reader.GetString(9); item.LotNumb = reader.GetString(10); item.HeatNumb = reader.GetString(11); item.BundleNumb = reader.GetString(12); item.SerialNumb = reader.GetString(13); item.AddNumb1 = reader.GetString(14); item.AddNumb2 = reader.GetString(15); item.AddNumb3 = reader.GetString(16); item.AddNumb4 = reader.GetString(17); item.AddNumb5 = reader.GetString(18); item.ObjectLength = reader.GetDouble(19); item.ObjectWidth = reader.GetDouble(20); item.ObjectHeight = reader.GetDouble(21); item.ObjectSpeed = reader.GetDouble(22); item.ObjectOuterDiameter = reader.GetDouble(23); item.ObjectInnerDiameter = reader.GetDouble(24); item.ObjectWallThickness = reader.GetDouble(25); item.ObjectA = reader.GetDouble(26); item.ObjectB = reader.GetDouble(27); item.ObjectC = reader.GetDouble(28); item.ObjectD = reader.GetDouble(29); item.ObjectE = reader.GetDouble(30); item.ObjectF = reader.GetDouble(31); item.ObjectG = reader.GetDouble(32); item.ObjectH = reader.GetDouble(33); item.ObjectI = reader.GetDouble(34); item.ObjectJ = reader.GetDouble(35); item.ObjectK = reader.GetDouble(36); item.ObjectL = reader.GetDouble(37); item.ObjectM = reader.GetDouble(38); item.ObjectN = reader.GetDouble(39); item.ObjectO = reader.GetDouble(40); item.ObjectP = reader.GetDouble(41); item.ObjectQ = reader.GetDouble(42); item.ObjectR = reader.GetDouble(43); item.ObjectS = reader.GetDouble(44); item.ObjectT = reader.GetDouble(45); item.ObjectU = reader.GetDouble(46); item.ObjectV = reader.GetDouble(47); item.ObjectW = reader.GetDouble(48); item.ObjectX = reader.GetDouble(49); item.ObjectY = reader.GetDouble(50); item.ObjectZ = reader.GetDouble(51); item.UsFilesPath = reader.GetString(52); item.ControlResult = reader.GetByte(53); item.DateTimeStump = reader.GetDateTime(54); _list.Add(item); } ; } } return(_list); } catch (Exception) { throw; } finally { CloseConnection(); } }
/// <summary> /// /// </summary> /// <param name="column"></param> /// <param name="valueIfNull"></param> /// <returns></returns> public byte GetTinyInt(int column, byte valueIfNull) { return(IsDBNull(column) ? valueIfNull : currentReader.GetByte(column)); }
private static bool ParseFile(FileInfo f) { DateTime filestarttime = DateTime.Now; Console.Write("Parsing {0}...", f.Name); SQLiteConnection connection = new SQLiteConnection("Data Source=" + f.FullName); SQLiteCommand command = new SQLiteCommand(connection); connection.Open(); command.CommandText = "SELECT id, sess_id, timestamp, direction, opcode, data FROM packets ORDER BY id;"; command.Prepare(); SQLiteDataReader reader = command.ExecuteReader(); MemoryStream ms = new MemoryStream(); while (reader.Read()) { uint id = (uint)reader.GetInt32(0); uint sess_id = (uint)reader.GetInt32(1); string timestamp = reader.GetString(2); byte direction = reader.GetByte(3); ushort opcode = (ushort)reader.GetInt32(4); if (opcode > 1054) { Console.WriteLine(opcode); throw new Exception("Test"); } byte[] data_ = (byte[])reader.GetValue(5); uint size = sizeof(uint) + sizeof(uint) + (uint)timestamp.Length + 1 + sizeof(byte) + sizeof(ushort) + (uint)data_.Length; byte[] id_arr = BitConverter.GetBytes(id); byte[] sessid_arr = BitConverter.GetBytes(sess_id); byte[] time_arr = Encoding.ASCII.GetBytes(timestamp); byte[] op = BitConverter.GetBytes(opcode); byte[] sz = BitConverter.GetBytes(size); ms.Write(sz, 0, sz.Length); ms.Write(id_arr, 0, id_arr.Length); ms.Write(sessid_arr, 0, sessid_arr.Length); ms.Write(time_arr, 0, time_arr.Length); ms.WriteByte(0); ms.WriteByte(direction); ms.Write(op, 0, op.Length); ms.Write(data_, 0, data_.Length); } reader.Close(); connection.Close(); GenericReader gr = new GenericReader(ms, Encoding.ASCII); gr.BaseStream.Position = 0; string error_log = f.FullName + ".errors.txt"; StreamWriter swe = new StreamWriter(error_log); string database_log = f.FullName + ".data.txt"; StreamWriter data = new StreamWriter(database_log); string hex_log = f.FullName + ".hex.log"; StreamWriter hex = new StreamWriter(hex_log); string ofn = f.FullName + ".data_out.txt"; StreamWriter sw = new StreamWriter(ofn); sw.AutoFlush = true; swe.AutoFlush = true; data.AutoFlush = true; hex.AutoFlush = true; while (gr.PeekChar() >= 0) { //try //{ if (ParseHeader(gr, sw, swe, data, hex)) { packet++; } //} //catch (Exception exc) //{ // MessageBox.Show(exc.ToString()); // swe.WriteLine("error in pos " + gr.BaseStream.Position.ToString("X16")); //} } // clear objects list... m_objects.Clear(); sw.Close(); swe.Close(); data.Close(); hex.Close(); gr.Close(); TimeSpan fileworktime = DateTime.Now - filestarttime; Console.WriteLine(" Parsed in {0}", fileworktime); return(true); }
void Button_Click(object sender, EventArgs e) { //string login = this.Login1.UserName; //string haslo = this.Login1.Password; string login = this.TextBox1.Text; string haslo = this.TextBox2.Text; //byte[] hash; //using (MD5 md5 = MD5.Create()) //{ // hash = md5.ComputeHash(Encoding.UTF8.GetBytes(haslo)); //} //string haslo2 = hash.ToString(); //string sql1 = string.Format("SELECT COUNT(*) from Uzytkownicy where login = {0} and haslo = {1};", login, hash); string sql1 = string.Format("SELECT 1 from Uzytkownicy where login = '******' and haslo = '{1}';", login, haslo); string sql2 = string.Format("SELECT czy_glosowal, czy_admin from Uzytkownicy where login = '******' and haslo = '{1}';", login, haslo); //string sql3 = "CREATE TABLE Ankiety (id INTEGER PRIMARY KEY AUTOINCREMENT, opcja_pierwsza VARCHAR(20), glosy_pierwsza INTEGER, opcja_druga VARCHAR(20), glosy_druga INTEGER, opcja_trzecia VARCHAR(20), glosy_trzecia INTEGER, aktualna_liczba_glosow INTEGER, koncowa_liczba_glosow INTEGER, data VARCHAR(10), aktywna TINYINT(1), nazwa VARCHAR(45));"; string sql3 = string.Format("SELECT 1 from Ankiety where aktywna = 1"); SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=J:\\SEMESTR VII\\PIS\\AKTUALNE\\WebApplication1\\baza.sqlite;Version=3;"); m_dbConnection.Open(); SQLiteCommand selectCheckCommand = new SQLiteCommand(sql1, m_dbConnection); SQLiteCommand selectUserCommand = new SQLiteCommand(sql2, m_dbConnection); SQLiteCommand selectAnkietaCommand = new SQLiteCommand(sql3, m_dbConnection); int count = Convert.ToInt32(selectCheckCommand.ExecuteScalar()); SQLiteDataReader sqlReader = selectUserCommand.ExecuteReader(); Int32 czy_admin = 0; Int32 czy_glosowal = 0; while (sqlReader.Read()) { czy_glosowal = sqlReader.GetByte(0); czy_admin = sqlReader.GetByte(1); } sqlReader.Close(); int ankieta = 0; ankieta = Convert.ToInt32(selectAnkietaCommand.ExecuteScalar()); if (count == 1 && czy_admin == 1) { SQLiteCommand sessionCommand = new SQLiteCommand(string.Format("INSERT OR REPLACE INTO Sesja (login, admin) values ('{0}', '{1}')", login, czy_admin), m_dbConnection); sessionCommand.ExecuteNonQuery(); m_dbConnection.Close(); if (ankieta == 1) { Response.Redirect("SurveyResults.aspx"); } else { Response.Redirect("AdminAccount.aspx"); } } else if (count == 1 && czy_admin == 0) { SQLiteCommand sessionCommand = new SQLiteCommand(string.Format("INSERT OR REPLACE INTO Sesja (login, admin) values ('{0}', '{1}')", login, czy_admin), m_dbConnection); sessionCommand.ExecuteNonQuery(); m_dbConnection.Close(); if (czy_glosowal == 0) { Response.Redirect("Survey.aspx"); } else if (czy_glosowal == 1) { Response.Redirect("UserAccount.aspx"); } } }
private void AddFromRecordSet(SQLiteDataReader rs) { try { if (!rs.IsDBNull(0)) { _collation_name = rs.GetString(0); } if (!rs.IsDBNull(1)) { _column_id = rs.GetInt32(1); } if (!rs.IsDBNull(2)) { _default_object_id = rs.GetInt32(2); } if (!rs.IsDBNull(3)) { _is_ansi_padded = rs.GetBoolean(3); } if (!rs.IsDBNull(4)) { _is_computed = rs.GetBoolean(4); } if (!rs.IsDBNull(5)) { _is_dts_replicated = rs.GetBoolean(5); } if (!rs.IsDBNull(6)) { _is_filestream = rs.GetBoolean(6); } if (!rs.IsDBNull(7)) { _is_identity = rs.GetBoolean(7); } if (!rs.IsDBNull(8)) { _is_merge_published = rs.GetBoolean(8); } if (!rs.IsDBNull(9)) { _is_non_sql_subscribed = rs.GetBoolean(9); } if (!rs.IsDBNull(10)) { _is_nullable = rs.GetBoolean(10); } if (!rs.IsDBNull(11)) { _is_replicated = rs.GetBoolean(11); } if (!rs.IsDBNull(12)) { _is_rowguidcol = rs.GetBoolean(12); } if (!rs.IsDBNull(13)) { _is_xml_document = rs.GetBoolean(13); } if (!rs.IsDBNull(14)) { _max_length = rs.GetInt16(14); } if (!rs.IsDBNull(15)) { _name = rs.GetString(15); } if (!rs.IsDBNull(16)) { _object_id = rs.GetInt32(16); } if (!rs.IsDBNull(17)) { _precision = rs.GetByte(17); } if (!rs.IsDBNull(18)) { _rule_object_id = rs.GetInt32(18); } if (!rs.IsDBNull(19)) { _scale = rs.GetByte(19); } if (!rs.IsDBNull(20)) { _system_type_id = rs.GetByte(20); } if (!rs.IsDBNull(21)) { _user_type_id = rs.GetInt32(21); } if (!rs.IsDBNull(22)) { _xml_collection_id = rs.GetInt32(22); } } catch (Exception) { throw; } }
private void AddFromRecordSet(SQLiteDataReader rs) { try { if (!rs.IsDBNull(0)) { _name = rs.GetString(0); } if (!rs.IsDBNull(1)) { _object_id = rs.GetInt32(1); } if (!rs.IsDBNull(2)) { _principal_id = rs.GetInt32(2); } if (!rs.IsDBNull(3)) { _schema_id = rs.GetInt32(3); } if (!rs.IsDBNull(4)) { _parent_object_id = rs.GetInt32(4); } if (!rs.IsDBNull(5)) { _type = (Object_Type)Enum.Parse(typeof(Object_Type), rs.GetString(5)); } if (!rs.IsDBNull(6)) { _type_desc = rs.GetString(6); } if (!rs.IsDBNull(7)) { _create_date = rs.GetDateTime(7); } if (!rs.IsDBNull(8)) { _modify_date = rs.GetDateTime(8); } if (!rs.IsDBNull(9)) { _is_ms_shipped = rs.GetBoolean(9); } if (!rs.IsDBNull(10)) { _is_published = rs.GetBoolean(10); } if (!rs.IsDBNull(11)) { _is_schema_published = rs.GetBoolean(11); } if (!rs.IsDBNull(12)) { _referenced_object_id = rs.GetInt32(12); } if (!rs.IsDBNull(13)) { _key_index_id = rs.GetInt32(13); } if (!rs.IsDBNull(14)) { _is_disabled = rs.GetBoolean(14); } if (!rs.IsDBNull(15)) { _is_not_for_replication = rs.GetBoolean(15); } if (!rs.IsDBNull(16)) { _is_not_trusted = rs.GetBoolean(16); } if (!rs.IsDBNull(17)) { _delete_referential_action = rs.GetByte(17); } if (!rs.IsDBNull(18)) { _delete_referential_action_desc = rs.GetString(18); } if (!rs.IsDBNull(19)) { _update_referential_action = rs.GetByte(19); } if (!rs.IsDBNull(20)) { _update_referential_action_desc = rs.GetString(20); } if (!rs.IsDBNull(21)) { _is_system_named = rs.GetBoolean(21); } } catch (Exception) { throw; } }
private void AddFromRecordSet(SQLiteDataReader rs) { try { if (!rs.IsDBNull(0)) { _object_id = rs.GetInt32(0); } if (!rs.IsDBNull(1)) { _name = rs.GetString(1); } if (!rs.IsDBNull(2)) { _index_id = rs.GetInt32(2); } if (!rs.IsDBNull(3)) { byte tmptype = rs.GetByte(3); _type = (Index_type)tmptype; //switch (tmptype) //{ // case 0: // _type = Index_type.Heap; // break; // case 1: // _type = Index_type.Clustered; // break; // case 2: // _type = Index_type.Nonclustered; // break; // case 3: // _type = Index_type.XML; // break; // default: // break; //} } if (!rs.IsDBNull(4)) { _type_desc = rs.GetString(4); } if (!rs.IsDBNull(5)) { _is_unique = rs.GetBoolean(5); } if (!rs.IsDBNull(6)) { _data_space_id = rs.GetInt32(6); } if (!rs.IsDBNull(7)) { _ignore_dup_key = rs.GetBoolean(7); } if (!rs.IsDBNull(8)) { _is_primary_key = rs.GetBoolean(8); } if (!rs.IsDBNull(9)) { _is_unique_constraint = rs.GetBoolean(9); } if (!rs.IsDBNull(10)) { _fill_factor = rs.GetByte(10); } if (!rs.IsDBNull(11)) { _is_padded = rs.GetBoolean(11); } if (!rs.IsDBNull(12)) { _is_disabled = rs.GetBoolean(12); } if (!rs.IsDBNull(13)) { _is_hypothetical = rs.GetBoolean(13); } if (!rs.IsDBNull(14)) { _allow_row_locks = rs.GetBoolean(14); } if (!rs.IsDBNull(15)) { _allow_page_locks = rs.GetBoolean(15); } } catch (Exception) { throw; } }
public void loadStationsFromDB(Dictionary <string, Station> stationDic) { // string sql = @"SELECT name,positionX,positionY,btnX,btnY,next // FROM station // WHERE (ownerMap = @ownerMap)"; string sql = @"SELECT name,positionX,positionY,btnX,btnY,next,cardID,stationID FROM station WHERE (ownerMap = @ownerMap)"; SQLiteParameter[] parameters = new SQLiteParameter[] { new SQLiteParameter("@ownerMap", mapName), }; SQLiteDBHelper db = getDataBase(); try { using (SQLiteDataReader reader = db.ExecuteReader(sql, parameters)) { while (reader.Read()) { //Console.WriteLine("indexNo:{0},shape:{1}", /*reader.GetInt64(0)*/1, reader.GetString(1)); Station s = new Station(reader.GetString(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetByte(6), reader.GetInt32(7));//select语句的顺序 stationDic.Add(reader.GetString(0), s); if (!reader.IsDBNull(5)) { s.Next = reader.GetString(5); } } } } catch (Exception x) { Console.WriteLine(x.Message); } }
public static bool GetTinyIntBoolean(this SQLiteDataReader rdr, int ordinal) { return(rdr.GetByte(ordinal) != 0); }