/// <summary> /// Creates a new instance of the ViewAuditoriaListaVerificacionDetalleCross class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewAuditoriaListaVerificacionDetalleCrossInfo MakeViewAuditoriaListaVerificacionDetalleCross(SqlDataReader dataReader) { ViewAuditoriaListaVerificacionDetalleCrossInfo viewAuditoriaListaVerificacionDetalleCross = new ViewAuditoriaListaVerificacionDetalleCrossInfo(); if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleCargoId) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionDetalleCargoId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleCargoId); if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId); if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId); if (dataReader.IsDBNull(CargoId) == false) viewAuditoriaListaVerificacionDetalleCross.CargoId = dataReader.GetInt32(CargoId); if (dataReader.IsDBNull(Cargo) == false) viewAuditoriaListaVerificacionDetalleCross.Cargo = dataReader.GetString(Cargo); if (dataReader.IsDBNull(Activo) == false) viewAuditoriaListaVerificacionDetalleCross.Activo = dataReader.GetBoolean(Activo); if (dataReader.IsDBNull(AuditoriaPunto) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaPunto = dataReader.GetString(AuditoriaPunto); if (dataReader.IsDBNull(AuditoriaControl) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaControl = dataReader.GetString(AuditoriaControl); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewAuditoriaListaVerificacionDetalleCross.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(Empresa) == false) viewAuditoriaListaVerificacionDetalleCross.Empresa = dataReader.GetString(Empresa); if (dataReader.IsDBNull(Orden) == false) viewAuditoriaListaVerificacionDetalleCross.Orden = dataReader.GetByte(Orden); return viewAuditoriaListaVerificacionDetalleCross; }
/// <summary> /// 数据转用户实体 /// </summary> public static UserInfo DataToModel(SqlDataReader rdr) { UserInfo user = new UserInfo(); if (!rdr.IsDBNull(0)) user.UserID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) user.UserName = rdr.GetString(1); if (!rdr.IsDBNull(2)) user.UserPassword = rdr.GetString(2); if (!rdr.IsDBNull(3)) user.UserNickName = rdr.GetString(3); if (!rdr.IsDBNull(4)) user.UserImage = rdr.GetString(4); if (!rdr.IsDBNull(5)) user.UserPhone = rdr.GetString(5); if (!rdr.IsDBNull(6)) user.UserEmail = rdr.GetString(6); if (!rdr.IsDBNull(7)) user.UserTheme = rdr.GetString(7); if (!rdr.IsDBNull(8)) user.UserLevel = rdr.GetByte(8); if (!rdr.IsDBNull(9)) user.UserFrom = rdr.GetString(9); if (!rdr.IsDBNull(10)) user.ModifyDate = rdr.GetDateTime(10); if (!rdr.IsDBNull(11)) user.CreateDate = rdr.GetDateTime(11); if (!rdr.IsDBNull(12)) user.UserCity = rdr.GetString(12); if (!rdr.IsDBNull(13)) user.UserMoney = rdr.GetDecimal(13); if (!rdr.IsDBNull(14)) user.UserWorkDay = rdr.GetString(14); if (!rdr.IsDBNull(15)) user.UserFunction = rdr.GetString(15); if (!rdr.IsDBNull(16)) user.CategoryRate = rdr.GetInt32(16); if (!rdr.IsDBNull(17)) user.Synchronize = rdr.GetByte(17); if (!rdr.IsDBNull(18)) user.MoneyStart = rdr.GetDecimal(18); if (!rdr.IsDBNull(19)) user.IsUpdate = rdr.GetByte(19); return user; }
/// <summary> /// 数据转专题实体 /// </summary> public static ZhuanTiInfo DataToModel(SqlDataReader rdr) { ZhuanTiInfo zhuanTi = new ZhuanTiInfo(); if (!rdr.IsDBNull(0)) zhuanTi.ZhuanTiID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) zhuanTi.ZhuanTiName = rdr.GetString(1); if (!rdr.IsDBNull(2)) zhuanTi.ZhuanTiImage = rdr.GetString(2); if (!rdr.IsDBNull(3)) zhuanTi.UserID = rdr.GetInt32(3); if (!rdr.IsDBNull(4)) zhuanTi.ZhuanTiLive = rdr.GetByte(4); if (!rdr.IsDBNull(5)) zhuanTi.Synchronize = rdr.GetByte(5); if (!rdr.IsDBNull(6)) zhuanTi.ModifyDate = rdr.GetDateTime(6); if (!rdr.IsDBNull(7)) zhuanTi.ZTID = rdr.GetInt32(7); return zhuanTi; }
public override void Map(SqlDataReader sqlDataReader) { this.Id = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("Id")); this.Name = sqlDataReader.GetString(sqlDataReader.GetOrdinal("Name")); this.Level = sqlDataReader.GetByte(sqlDataReader.GetOrdinal("Level")); this.CountryId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("CountryId")); }
/// <summary> /// 数据转转账实体 /// </summary> public static ZhuanZhangInfo DataToModel(SqlDataReader rdr) { ZhuanZhangInfo zhang = new ZhuanZhangInfo(); if (!rdr.IsDBNull(0)) zhang.ZhuanZhangID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) zhang.ZhuanZhangFrom = rdr.GetInt32(1); if (!rdr.IsDBNull(2)) zhang.ZhuanZhangTo = rdr.GetInt32(2); if (!rdr.IsDBNull(3)) zhang.ZhuanZhangDate = rdr.GetDateTime(3); if (!rdr.IsDBNull(4)) zhang.ZhuanZhangMoney = rdr.GetDecimal(4); if (!rdr.IsDBNull(5)) zhang.ZhuanZhangLive = rdr.GetByte(5); if (!rdr.IsDBNull(7)) zhang.Synchronize = rdr.GetByte(6); if (!rdr.IsDBNull(6)) zhang.ModifyDate = rdr.GetDateTime(7); if (!rdr.IsDBNull(7)) zhang.UserID = rdr.GetInt32(8); if (!rdr.IsDBNull(7)) zhang.ZhuanZhangNote = rdr.GetString(9); if (!rdr.IsDBNull(7)) zhang.ZZID = rdr.GetInt32(10); return zhang; }
/// <summary> /// 数据转钱包实体 /// </summary> public static CardInfo DataToModel(SqlDataReader rdr) { CardInfo card = new CardInfo(); if (!rdr.IsDBNull(0)) card.CardID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) card.CardName = rdr.GetString(1); if (!rdr.IsDBNull(2)) card.CardNumber = rdr.GetString(2); if (!rdr.IsDBNull(3)) card.CardImage = rdr.GetString(3); if (!rdr.IsDBNull(4)) card.CardMoney = rdr.GetDecimal(4); if (!rdr.IsDBNull(5)) card.CardLive = rdr.GetByte(5); if (!rdr.IsDBNull(6)) card.Synchronize = rdr.GetByte(6); if (!rdr.IsDBNull(7)) card.ModifyDate = rdr.GetDateTime(7); if (!rdr.IsDBNull(8)) card.CDID = rdr.GetInt32(8); if (!rdr.IsDBNull(9)) card.UserID = rdr.GetInt32(9); if (!rdr.IsDBNull(10)) card.MoneyStart = rdr.GetDecimal(10); if (!rdr.IsDBNull(11)) card.CardShow = rdr.GetByte(11); return card; }
private string GetObjectValue(System.Data.SqlClient.SqlDataReader reader, int i) { string fieldType = reader.GetFieldType(i).ToString(); object FieldValue = null;; if (fieldType.Contains("Int32")) { FieldValue = reader.GetInt32(i); } else if (fieldType.Contains("Int64")) { FieldValue = reader.GetInt64(i); } else if (fieldType.Contains("Decimal")) { FieldValue = reader.GetDecimal(i); } else if (fieldType.Contains("Double")) { FieldValue = reader.GetDouble(i); } else if (fieldType.Contains("DateTime")) { FieldValue = reader.GetDateTime(i); } else if (fieldType.Contains("String")) { FieldValue = reader.GetString(i); } else if (fieldType.Contains("Boolean")) { FieldValue = reader.GetBoolean(i); } else if (fieldType.Contains("Byte")) { FieldValue = reader.GetByte(i); } else if (fieldType.Contains("Guid")) { FieldValue = reader.GetGuid(i); } else { FieldValue = reader.GetString(i); } if (FieldValue != null) { return(FieldValue.ToString()); } else { return(""); } }
/// <summary> /// 数据转查询实体 /// </summary> public static UserQueryInfo DataToModel(SqlDataReader rdr) { UserQueryInfo query = new UserQueryInfo(); if (!rdr.IsDBNull(0)) query.UserQueryID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) query.UserQueryName = rdr.GetString(1); if (!rdr.IsDBNull(2)) query.UserQueryURL = rdr.GetString(2); if (!rdr.IsDBNull(3)) query.UserQueryValue = rdr.GetString(3); if (!rdr.IsDBNull(4)) query.UserQueryLive = rdr.GetByte(4); if (!rdr.IsDBNull(5)) query.UserID = rdr.GetInt32(5); if (!rdr.IsDBNull(6)) query.ModifyDate = rdr.GetDateTime(6); return query; }
/////////////////////////////////////////////////////////////////////////// // Grab pet information packet /////////////////////////////////////////////////////////////////////////// public static byte[] Pet_Information_grab(pet_obj o, byte slot) { PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_PET_INFORMATION); try { ////////////////////////////////////////////////////////////////////////////////////// // Grabpet structure ////////////////////////////////////////////////////////////////////////////////////// Writer.DWord(o.UniqueID); //Unique ID Writer.DWord(o.Model); //Pet Model Writer.DWord(0x00006D); //Settings Writer.DWord(0x00006D); //Settings Writer.DWord(0x000047); //Settings 0x47 grab pet active 0 disabled if (o.Petname != "No name") //############### { Writer.Text(o.Petname); // Name region } else // { Writer.Word(0); //############### } Writer.Byte(o.Slots); //Slots count inventory pet ////////////////////////////////////////////////////////////////////////////////////// // Grabpet item inventory ////////////////////////////////////////////////////////////////////////////////////// Systems.MsSQL ms = new Systems.MsSQL("SELECT * FROM char_items WHERE owner='" + o.OwnerID + "' AND pet_storage_id='" + o.UniqueID + "'"); Writer.Byte(ms.Count()); using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { while (reader.Read()) { Item.AddItemPacket(Writer, reader.GetByte(5), reader.GetInt32(2), reader.GetByte(4), reader.GetInt16(6), reader.GetInt32(7), reader.GetInt32(0), reader.GetInt32(9), reader.GetInt32(30)); } } ms.Close(); ////////////////////////////////////////////////////////////////////////////////////// // Other ////////////////////////////////////////////////////////////////////////////////////// Writer.DWord(o.OwnerID); //Character ID Writer.Byte(slot); //Slot location of the pet ////////////////////////////////////////////////////////////////////////////////////// } catch (Exception ex) { Console.WriteLine("Pet load error: " + ex); } return(Writer.GetBytes()); }
/// <summary> /// 数据转第三方登录实体 /// </summary> public static OAuthInfo DataToModel(SqlDataReader rdr) { OAuthInfo oauth = new OAuthInfo(); if (!rdr.IsDBNull(0)) oauth.OAuthID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) oauth.OpenID = rdr.GetString(1); if (!rdr.IsDBNull(2)) oauth.AccessToken = rdr.GetString(2); if (!rdr.IsDBNull(3)) oauth.UserID = rdr.GetInt32(3); if (!rdr.IsDBNull(4)) oauth.OldUserID = rdr.GetInt32(4); if (!rdr.IsDBNull(5)) oauth.OAuthBound = rdr.GetByte(5); if (!rdr.IsDBNull(6)) oauth.OAuthFrom = rdr.GetString(6); if (!rdr.IsDBNull(7)) oauth.ModifyDate = rdr.GetDateTime(7); return oauth; }
SqlJobMetrics build_sql_job_metric_from_reader(SqlDataReader reader) { var metric = new SqlJobMetrics(); metric.job_name = reader.GetString(0); metric.message = reader.GetString(1); var job_outcome_key = reader.GetByte(2); metric.job_status = get_job_outcome_from_key(job_outcome_key); metric.last_run = reader.GetDateTime(3); metric.job_step = reader.GetInt16(4); return metric; }
public static byte[] OpenWarehouse2(byte storageslots, player c) { PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_OPEN_WAREPROB); Writer.Byte(storageslots); Systems.MsSQL ms = new Systems.MsSQL("SELECT * FROM char_items WHERE storageacc='" + c.ID + "' AND storagetype='1'"); Writer.Byte(ms.Count()); using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { while (reader.Read()) { Item.AddItemPacket(Writer, reader.GetByte(5), reader.GetInt32(2), reader.GetByte(4), reader.GetInt16(6), reader.GetInt32(7), reader.GetInt32(0), reader.GetInt32(9), reader.GetInt32(30)); } } ms.Close(); return(Writer.GetBytes()); }
// Select a Credit Card ID record to edit protected void DropDownListSelectCreditCardID_SelectedIndexChanged(object sender, EventArgs e) { // Store selected credit card id value into variable string tempID = DropDownListSelectCreditCardID.SelectedValue; creditCardSelected = true; // Create temporary variables to store selected record information string tempCardType = ""; string tempCardNumber = ""; Byte tempExpMonth = 0; Int16 tempExpYear = 0; // Select record from database at selected credit card ID value sc.Open(); String query2 = "SELECT * FROM [Sales].[CreditCard] WHERE [CreditCardID] = @tempid;"; System.Data.SqlClient.SqlCommand sqlCom2 = new System.Data.SqlClient.SqlCommand(query2, sc); sqlCom2.Parameters.AddWithValue("@tempid", tempID); sqlCom2.ExecuteNonQuery(); // Use Reader and assign temporary variables with data from selected record System.Data.SqlClient.SqlDataReader reader = sqlCom2.ExecuteReader(); while (reader.Read()) { tempCardType = reader.GetString(1); tempCardNumber = reader.GetString(2); tempExpMonth = reader.GetByte(3); tempExpYear = reader.GetInt16(4); } reader.Close(); //Display selected data in the textboxes in the web form DropDownListCardType.SelectedValue = DropDownListCardType.Items.FindByText(tempCardType).Value; TextBoxCardNumber.Text = tempCardNumber; DropDownListExpMonth.SelectedValue = DropDownListExpMonth.Items.FindByValue(tempExpMonth.ToString()).Value; DropDownListExpYear.SelectedValue = DropDownListExpYear.Items.FindByValue(tempExpYear.ToString()).Value; TextBoxResult.Text = creditCardSelected.ToString(); }
public static byte[] GuildStorageData(character c) { Systems.MsSQL getstorage = new Systems.MsSQL("SELECT * FROM char_items WHERE guild_storage_id='" + c.Network.Guild.Guildid + "' AND storagetype='3'"); int itemcount = getstorage.Count(); PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_GUILD_STORAGE3); Writer.Byte(c.Network.Guild.StorageSlots); Writer.Byte(itemcount); if (itemcount != 0) { using (System.Data.SqlClient.SqlDataReader reader = getstorage.Read()) { while (reader.Read()) { Item.AddItemPacket(Writer, reader.GetByte(5), reader.GetInt32(2), reader.GetByte(4), reader.GetInt16(6), reader.GetInt32(7), reader.GetInt32(0), reader.GetInt32(9), reader.GetInt32(30)); } } } getstorage.Close(); return(Writer.GetBytes()); }
private void ReadKeyData(SqlDataReader reader, Dictionary<Guid, IDictionary<XName, InstanceValue>> associatedInstanceKeys, Dictionary<Guid, IDictionary<XName, InstanceValue>> completedInstanceKeys) { if ((StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader) == null) && !reader.IsDBNull(1)) { do { Guid guid = reader.GetGuid(1); bool boolean = reader.GetBoolean(2); InstanceEncodingOption @byte = (InstanceEncodingOption) reader.GetByte(3); Dictionary<Guid, IDictionary<XName, InstanceValue>> dictionary = boolean ? associatedInstanceKeys : completedInstanceKeys; if (!reader.IsDBNull(4)) { dictionary[guid] = SerializationUtilities.DeserializeKeyMetadata((byte[]) reader.GetValue(4), @byte); } else { dictionary[guid] = new Dictionary<XName, InstanceValue>(); } } while (reader.Read()); } }
private void ReadInstanceMetadataChanges(SqlDataReader reader, Dictionary<XName, InstanceValue> instanceMetadata) { if ((StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader) != null) || !reader.IsDBNull(1)) { do { InstanceEncodingOption @byte = (InstanceEncodingOption) reader.GetByte(1); byte[] serializedMetadataProperties = (byte[]) reader.GetValue(2); foreach (KeyValuePair<XName, InstanceValue> pair in SerializationUtilities.DeserializeMetadataPropertyBag(serializedMetadataProperties, @byte)) { XName key = pair.Key; InstanceValue value2 = pair.Value; if (value2.Value is DeletedMetadataValue) { instanceMetadata.Remove(key); } else { instanceMetadata[key] = value2; } } } while (reader.Read()); } }
protected override Exception ProcessSqlResult(SqlDataReader reader) { Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader); if (nextResultSet == null) { Guid instanceId = reader.GetGuid(1); reader.GetInt64(2); byte[] primitiveDataProperties = reader.IsDBNull(3) ? null : ((byte[]) reader.GetValue(3)); byte[] complexDataProperties = reader.IsDBNull(4) ? null : ((byte[]) reader.GetValue(4)); byte[] serializedMetadataProperties = reader.IsDBNull(5) ? null : ((byte[]) reader.GetValue(5)); InstanceEncodingOption @byte = (InstanceEncodingOption) reader.GetByte(6); InstanceEncodingOption instanceEncodingOption = (InstanceEncodingOption) reader.GetByte(7); long instanceVersion = reader.GetInt64(8); bool boolean = reader.GetBoolean(9); bool flag2 = reader.GetBoolean(10); InstancePersistenceCommand instancePersistenceCommand = base.InstancePersistenceCommand; LoadWorkflowByInstanceKeyCommand command = base.InstancePersistenceCommand as LoadWorkflowByInstanceKeyCommand; if (!base.InstancePersistenceContext.InstanceView.IsBoundToInstance) { base.InstancePersistenceContext.BindInstance(instanceId); } if (!base.InstancePersistenceContext.InstanceView.IsBoundToInstanceOwner) { base.InstancePersistenceContext.BindInstanceOwner(base.StoreLock.LockOwnerId, base.StoreLock.LockOwnerId); } if (!base.InstancePersistenceContext.InstanceView.IsBoundToLock) { ((InstanceLockTracking) base.InstancePersistenceContext.UserContext).TrackStoreLock(instanceId, instanceVersion, base.DependentTransaction); base.InstancePersistenceContext.BindAcquiredLock(instanceVersion); } this.instanceData = SerializationUtilities.DeserializePropertyBag(primitiveDataProperties, complexDataProperties, @byte); this.instanceMetadata = SerializationUtilities.DeserializeMetadataPropertyBag(serializedMetadataProperties, instanceEncodingOption); if (!flag2) { this.ReadInstanceMetadataChanges(reader, this.instanceMetadata); this.ReadKeyData(reader, this.associatedInstanceKeys, this.completedInstanceKeys); } else if (command != null) { foreach (KeyValuePair<Guid, IDictionary<XName, InstanceValue>> pair in command.InstanceKeysToAssociate) { this.associatedInstanceKeys.Add(pair.Key, pair.Value); } if (!this.associatedInstanceKeys.ContainsKey(command.LookupInstanceKey)) { base.InstancePersistenceContext.AssociatedInstanceKey(command.LookupInstanceKey); this.associatedInstanceKeys.Add(command.LookupInstanceKey, new Dictionary<XName, InstanceValue>()); } } if (command != null) { foreach (KeyValuePair<Guid, IDictionary<XName, InstanceValue>> pair2 in command.InstanceKeysToAssociate) { base.InstancePersistenceContext.AssociatedInstanceKey(pair2.Key); if (pair2.Value != null) { foreach (KeyValuePair<XName, InstanceValue> pair3 in pair2.Value) { base.InstancePersistenceContext.WroteInstanceKeyMetadataValue(pair2.Key, pair3.Key, pair3.Value); } } } } base.InstancePersistenceContext.LoadedInstance(boolean ? InstanceState.Initialized : InstanceState.Uninitialized, this.instanceData, this.instanceMetadata, this.associatedInstanceKeys, this.completedInstanceKeys); return nextResultSet; } if (nextResultSet is InstanceLockLostException) { base.InstancePersistenceContext.InstanceHandle.Free(); } return nextResultSet; }
/// <summary> /// Creates a new instance of the TipoAlerta class and populates it with data from the specified SqlDataReader. /// </summary> private static TipoAlertaInfo MakeTipoAlerta(SqlDataReader dataReader) { TipoAlertaInfo tipoAlerta = new TipoAlertaInfo(); if (dataReader.IsDBNull(TipoAlertaId) == false) tipoAlerta.TipoAlertaId = dataReader.GetInt32(TipoAlertaId); if (dataReader.IsDBNull(Descripcion) == false) tipoAlerta.Descripcion = dataReader.GetString(Descripcion); if (dataReader.IsDBNull(ColorRojo) == false) tipoAlerta.ColorRojo = dataReader.GetByte(ColorRojo); if (dataReader.IsDBNull(ColorVerde) == false) tipoAlerta.ColorVerde = dataReader.GetByte(ColorVerde); if (dataReader.IsDBNull(ColorAzul) == false) tipoAlerta.ColorAzul = dataReader.GetByte(ColorAzul); if (dataReader.IsDBNull(ColorAlfa) == false) tipoAlerta.ColorAlfa = dataReader.GetByte(ColorAlfa); return tipoAlerta; }
private List<Column> GetColumns(SqlDataReader reader) { var list = new List<Column>(); while (reader.Read()) { var column = new Column(); column.Name = reader.GetString(0); column.Type = reader.GetString(1); column.Length = reader.GetInt16(2); column.IsNullable = reader.GetInt32(3) == 0; if (reader.FieldCount >= 5) { column.Scale = reader.GetByte(4); column.Precision = reader.GetByte(5); column.IsPrimaryKey = reader.GetInt32(6) == 1; column.Default = reader.GetString(7); if (column.Default.StartsWith("((")) column.Default = column.Default.Substring(1, column.Default.Length - 2); } list.Add(column); } return list; }
internal static void FillCompatibleITypedSettersFromReader(SmiEventSink_Default sink, ITypedSettersV3 setters, SmiMetaData[] metaData, SqlDataReader reader) { for (int i = 0; i < metaData.Length; i++) { if (reader.IsDBNull(i)) { SetDBNull_Unchecked(sink, setters, i); continue; } switch (metaData[i].SqlDbType) { case SqlDbType.BigInt: { SetInt64_Unchecked(sink, setters, i, reader.GetInt64(i)); continue; } case SqlDbType.Binary: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } case SqlDbType.Bit: { SetBoolean_Unchecked(sink, setters, i, reader.GetBoolean(i)); continue; } case SqlDbType.Char: { SetSqlChars_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlChars(i), 0); continue; } case SqlDbType.DateTime: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.Decimal: { SetSqlDecimal_Unchecked(sink, setters, i, reader.GetSqlDecimal(i)); continue; } case SqlDbType.Float: { SetDouble_Unchecked(sink, setters, i, reader.GetDouble(i)); continue; } case SqlDbType.Image: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } case SqlDbType.Int: { SetInt32_Unchecked(sink, setters, i, reader.GetInt32(i)); continue; } case SqlDbType.Money: { SetSqlMoney_Unchecked(sink, setters, i, metaData[i], reader.GetSqlMoney(i)); continue; } case SqlDbType.NChar: case SqlDbType.NText: case SqlDbType.NVarChar: { SetSqlChars_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlChars(i), 0); continue; } case SqlDbType.Real: { SetSingle_Unchecked(sink, setters, i, reader.GetFloat(i)); continue; } case SqlDbType.UniqueIdentifier: { SetGuid_Unchecked(sink, setters, i, reader.GetGuid(i)); continue; } case SqlDbType.SmallDateTime: { SetDateTime_Checked(sink, setters, i, metaData[i], reader.GetDateTime(i)); continue; } case SqlDbType.SmallInt: { SetInt16_Unchecked(sink, setters, i, reader.GetInt16(i)); continue; } case SqlDbType.SmallMoney: { SetSqlMoney_Checked(sink, setters, i, metaData[i], reader.GetSqlMoney(i)); continue; } case SqlDbType.Text: { SetSqlChars_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlChars(i), 0); continue; } case SqlDbType.Timestamp: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } case SqlDbType.TinyInt: { SetByte_Unchecked(sink, setters, i, reader.GetByte(i)); continue; } case SqlDbType.VarBinary: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } case SqlDbType.VarChar: { SetSqlChars_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlChars(i), 0); continue; } case SqlDbType.Variant: { object sqlValue = reader.GetSqlValue(i); ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCode(sqlValue); SetCompatibleValue(sink, setters, i, metaData[i], sqlValue, typeCode, 0); continue; } case SqlDbType.Xml: { SetSqlXml_Unchecked(sink, setters, i, reader.GetSqlXml(i)); continue; } case SqlDbType.Udt: { SetSqlBytes_LengthChecked(sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0); continue; } } throw ADP.NotSupported(); } }
public void GetByteTest () { cmd.CommandText = string.Format (query, "tinyint", "tinyint", "int"); reader = cmd.ExecuteReader (); reader.Read (); // Test for standard exceptions GetMethodTests("Byte"); // Test if data is returned correctly Assert.AreEqual (numericRow["type_tinyint"], reader.GetByte(0), "#2 DataValidation Failed"); // Test for standard exceptions GetMethodTests("SqlByte"); // Test if data is returned correctly Assert.AreEqual (numericRow["type_tinyint"], reader.GetSqlByte(0).Value, "#4 DataValidation Failed"); reader.Close (); }
//////////////////////////////////////////////////////////////////////////////////////////////////////////// // Character listening packet //////////////////////////////////////////////////////////////////////////////////////////////////////////// public static byte[] CharacterListing(string name) { Systems.MsSQL ms = new Systems.MsSQL("SELECT TOP 4 * FROM character WHERE account='" + name + "'"); PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_CHARACTERSCREEN); // Select opcode Writer.Byte(2); // Static byte 2 Writer.Byte(1); // Static byte 1 Writer.Byte(ms.Count()); // Byte Character Count using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { while (reader.Read()) { Writer.DWord(reader.GetInt32(3)); // DWord Skin Model Writer.Text(reader.GetString(2)); // String Name Writer.Byte(reader.GetByte(4)); // Byte Skin Volume Writer.Byte(reader.GetByte(5)); // Byte Level Writer.LWord(reader.GetInt64(12)); // Long Experience Writer.Word(reader.GetInt16(6)); // Word STR Writer.Word(reader.GetInt16(7)); // Word INT Writer.Word(reader.GetInt16(8)); // Attribute points Writer.DWord(reader.GetInt32(9)); // HP Writer.DWord(reader.GetInt32(10)); // MP TimeSpan ts = Convert.ToDateTime(reader.GetDateTime(43)) - DateTime.Now; double time = ts.TotalMinutes; if (Math.Round(time) > 0) { Writer.Byte(1); Writer.DWord(Math.Round(time)); } else { Writer.Byte(0); } if (Math.Round(time) < 0 && DateTime.Now != reader.GetDateTime(43)) { Systems.MsSQL.UpdateData("UPDATE character SET deleted='1' Where id='" + reader.GetInt32(0) + "'"); } Writer.Word(0); Writer.Byte(0); Function.Items.PrivateItemPacket(Writer, reader.GetInt32(0), 8, 0,false); Function.Items.PrivateItemPacket(Writer, reader.GetInt32(0), 5, 1,false); } //Jobtype information int jobinfo = Systems.MsSQL.GetDataInt("SELECT * FROM users WHERE id='"+ name +"'", "jobtype"); Writer.Byte(Convert.ToByte(jobinfo)); } ms.Close(); return Writer.GetBytes(); }
public void LoadGuildMembers() { //Wrap our code in a try to catch bad exception errors try { //Load guild member id's LoadGuildMemberIds(Character.Network.Guild.Guildid, ref Character.Network.Guild.Members); //Repeat for each member in the guild member list foreach (int Guildmember in Character.Network.Guild.Members) { //Set new guild player information Global.guild_player PlayerGuild = new Global.guild_player(); //Set guildmember id PlayerGuild.MemberID = Guildmember; //Create new mssql query to get player information Systems.MsSQL ms = new Systems.MsSQL("SELECT * FROM character WHERE id='" + Guildmember + "'"); //Create mssql data reader using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { //While the reader is reading while (reader.Read()) { //Get player model PlayerGuild.Model = reader.GetInt32(3); //Get player xsector PlayerGuild.Xsector = reader.GetByte(16); //Get player ysector PlayerGuild.Ysector = reader.GetByte(17); //Get player level PlayerGuild.Level = reader.GetByte(5); //Get player name PlayerGuild.Name = reader.GetString(2); //Get player online state PlayerGuild.Online = (reader.GetInt32(47) == 1); //If player is online if (PlayerGuild.Online) { //Get detailed player information Systems sys = GetPlayerMainid(Guildmember); //Make sure sys is not null if (sys != null) { //Add the character client to the client list this.Character.Network.Guild.MembersClient.Add(sys.client); } } } } //Create new query to select from table guild_members ms = new Systems.MsSQL("SELECT * FROM guild_members WHERE guild_member_id='" + Guildmember + "'"); //Create new sql data reader using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { //While the sql data reader is reading while (reader.Read()) { //Get player rights PlayerGuild.joinRight = (reader.GetByte(7) == 1); PlayerGuild.withdrawRight = (reader.GetByte(8) == 1); PlayerGuild.unionRight = (reader.GetByte(9) == 1); PlayerGuild.guildstorageRight = (reader.GetByte(10) == 1); PlayerGuild.noticeeditRight = (reader.GetByte(11) == 1); PlayerGuild.FWrank = reader.GetByte(6); //Get player donated gp PlayerGuild.DonateGP = reader.GetInt32(4); //Get player rank PlayerGuild.Rank = reader.GetByte(3); } } //Close mssql ms.Close(); //Add our character to the guild member info Character.Network.Guild.MembersInfo.Add(PlayerGuild); } } //Catch bad exceptions catch (Exception ex) { //Write error to the console Console.WriteLine(ex); //Write error to the debug log file Systems.Debugger.Write(ex); } }
public override void Map(SqlDataReader sqlDataReader) { this.Id = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("Id")); this.Key = sqlDataReader.GetString(sqlDataReader.GetOrdinal("Key")); this.Date = sqlDataReader.GetDateTime(sqlDataReader.GetOrdinal("Date")); this.HomeTeamId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("HomeTeamId")); this.AwayTeamId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("AwayTeamId")); this.SeasonId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("SeasonId")); this.LeagueId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("LeagueId")); this.CountryId = sqlDataReader.GetGuid(sqlDataReader.GetOrdinal("CountryId")); this.HomeGoals = sqlDataReader.GetByte(sqlDataReader.GetOrdinal("HomeGoals")); this.AwayGoals = sqlDataReader.GetByte(sqlDataReader.GetOrdinal("AwayGoals")); }
/// <summary> /// Wrapper for the SqlDataReader.GetByte() function. /// </summary> /// <param name="reader">The SqlDataReader object where data will be retrieved.</param> /// <param name="columnName">The name of the column to retrieve.</param> /// <returns>The data value.</returns> public static byte? GetByte(SqlDataReader reader, string columnName) { int ord = reader.GetOrdinal(columnName); return (reader.IsDBNull(ord) ? null : (byte?)reader.GetByte(ord)); }
private static Dictionary<XName, object> ReadLockOwnerMetadata(SqlDataReader reader) { Dictionary<XName, object> dictionary = new Dictionary<XName, object>(); InstanceEncodingOption @byte = (InstanceEncodingOption) reader.GetByte(3); byte[] bytes = reader.IsDBNull(4) ? null : ((byte[]) reader.GetValue(4)); byte[] buffer2 = reader.IsDBNull(5) ? null : ((byte[]) reader.GetValue(5)); IObjectSerializer objectSerializer = ObjectSerializerFactory.GetObjectSerializer(@byte); Dictionary<XName, object>[] dictionaryArray = new Dictionary<XName, object>[2]; if (bytes != null) { dictionaryArray[0] = (Dictionary<XName, object>) objectSerializer.DeserializeValue(bytes); } if (buffer2 != null) { dictionaryArray[1] = objectSerializer.DeserializePropertyBag(buffer2); } foreach (Dictionary<XName, object> dictionary2 in dictionaryArray) { if (dictionary2 != null) { foreach (KeyValuePair<XName, object> pair in dictionary2) { dictionary.Add(pair.Key, pair.Value); } } } return dictionary; }
static Dictionary<XName, object> ReadLockOwnerMetadata(SqlDataReader reader) { Dictionary<XName, object> lockOwnerProperties = new Dictionary<XName, object>(); InstanceEncodingOption encodingOption = (InstanceEncodingOption)(reader.GetByte(3)); byte[] serializedPrimitiveLockOwnerData = reader.IsDBNull(4) ? null : (byte[]) reader.GetValue(4); byte[] serializedComplexLockOwnerData = reader.IsDBNull(5) ? null : (byte[]) reader.GetValue(5); IObjectSerializer serializer = ObjectSerializerFactory.GetObjectSerializer(encodingOption); Dictionary<XName, object>[] lockOwnerPropertyBags = new Dictionary<XName, object>[2]; if (serializedPrimitiveLockOwnerData != null) { lockOwnerPropertyBags[0] = (Dictionary<XName, object>)serializer.DeserializeValue(serializedPrimitiveLockOwnerData); } if (serializedComplexLockOwnerData != null) { lockOwnerPropertyBags[1] = serializer.DeserializePropertyBag(serializedComplexLockOwnerData); } foreach (Dictionary<XName, object> propertyBag in lockOwnerPropertyBags) { if (propertyBag != null) { foreach (KeyValuePair<XName, object> property in propertyBag) { lockOwnerProperties.Add(property.Key, property.Value); } } } return lockOwnerProperties; }
/// <summary> /// 数据转商品实体 /// </summary> public static ItemInfo DataToModel(SqlDataReader rdr) { ItemInfo item = new ItemInfo(); if (!rdr.IsDBNull(0)) item.ItemID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) item.ItemName = rdr.GetString(1); if (!rdr.IsDBNull(2)) item.CategoryTypeID = rdr.GetInt32(2); if (!rdr.IsDBNull(3)) item.ItemPrice = rdr.GetDecimal(3); if (!rdr.IsDBNull(4)) item.ItemBuyDate = rdr.GetDateTime(4); if (!rdr.IsDBNull(5)) item.UserID = rdr.GetInt32(5); if (!rdr.IsDBNull(6)) item.Recommend = rdr.GetByte(6); if (!rdr.IsDBNull(7)) item.ModifyDate = rdr.GetDateTime(7); if (!rdr.IsDBNull(8)) item.Synchronize = rdr.GetByte(8); if (!rdr.IsDBNull(9)) item.ItemAppID = rdr.GetInt32(9); if (!rdr.IsDBNull(10)) item.RegionID = rdr.GetInt32(10); if (!rdr.IsDBNull(11)) item.RegionType = rdr.GetString(11); if (!rdr.IsDBNull(12)) item.ItemType = rdr.GetString(12); if (!rdr.IsDBNull(13)) item.ZhuanTiID = rdr.GetInt32(13); if (!rdr.IsDBNull(14)) item.CardID = rdr.GetInt32(14); return item; }
public static byte[] UnionInfo(Systems c) { PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_GUILD_UNIONS); Writer.DWord(c.Character.Information.CharacterID); // Union owner id Writer.DWord(7); // ??Need to check Writer.DWord(c.Character.Network.Guild.Guildid); // Union leader guild id Writer.Byte(c.Character.Network.Guild.Unions.Count); // Count guilds in union //Get all guilds details foreach (int guild in c.Character.Network.Guild.Unions) { //Load other guild data Systems.MsSQL guild_data = new Systems.MsSQL("SELECT * FROM guild WHERE id='" + guild + "'"); using (System.Data.SqlClient.SqlDataReader reader = guild_data.Read()) { while (reader.Read()) { string Guildname = reader.GetString(1); byte Guildlevel = reader.GetByte(2); byte Guildmembercount = reader.GetByte(6); int Ownerid = reader.GetInt32(9); string Charname = Systems.MsSQL.GetData("SELECT name FROM character WHERE id='" + Ownerid + "'", "name").ToString(); int Charmodel = Convert.ToInt32(Systems.MsSQL.GetData("SELECT chartype FROM character WHERE id='" + Ownerid + "'", "chartype")); Writer.DWord(guild); //Guild ID Writer.Text(reader.GetString(1)); //Guildname Writer.Byte(reader.GetByte(2)); //Guildlevel Writer.Text(Charname); //Ownername Writer.DWord(Charmodel); //Owner model Writer.Byte(reader.GetByte(6)); //Guild member count //Get guild details Systems Guildmembers = Systems.GetGuildPlayer(guild); //Add clients that are online to union list //Null check if (Guildmembers != null) { foreach (int member in Guildmembers.Character.Network.Guild.Members) { //make sure member isnt 0 if (member != 0) { //Get player details Systems getmember = Systems.GetPlayerMainid(member); //Make sure that the player is there if (getmember != null) { //Add client to union list c.Character.Network.Guild.UnionMembers.Add(getmember.Character.Information.CharacterID); //Add to member if (c.Character.Information.CharacterID != getmember.Character.Information.CharacterID) { getmember.Character.Network.Guild.UnionMembers.Add(c.Character.Information.CharacterID); } } } } } } } } return(Writer.GetBytes()); }
public void LoadPlayerGuildInfo(bool logon) { try { MsSQL ms = new MsSQL("SELECT * FROM guild_members WHERE guild_member_id='" + Character.Information.CharacterID + "'"); using (System.Data.SqlClient.SqlDataReader reader = ms.Read()) { while (reader.Read()) { Character.Network.Guild.Guildid = reader.GetInt32(1); Character.Network.Guild.GrantName = reader.GetString(5); Character.Network.Guild.FWrank = reader.GetByte(6); Character.Network.Guild.DonateGP = reader.GetInt32(4); Character.Network.Guild.LastDonate = Character.Network.Guild.DonateGP; Character.Network.Guild.joinRight = (reader.GetByte(7) == 1); Character.Network.Guild.withdrawRight = (reader.GetByte(8) == 1); Character.Network.Guild.unionRight = (reader.GetByte(9) == 1); Character.Network.Guild.guildstorageRight = (reader.GetByte(10) == 1); Character.Network.Guild.noticeeditRight = (reader.GetByte(11) == 1); } } ms = new MsSQL("SELECT * FROM guild WHERE id='" + Character.Network.Guild.Guildid + "'"); using (System.Data.SqlClient.SqlDataReader reader2 = ms.Read()) { while (reader2.Read()) { Character.Network.Guild.Name = reader2.GetString(1); Character.Network.Guild.Level = reader2.GetByte(2); Character.Network.Guild.PointsTotal = reader2.GetInt32(3); Character.Network.Guild.NewsTitle = reader2.GetString(4); Character.Network.Guild.NewsMessage = reader2.GetString(5); Character.Network.Guild.StorageSlots = reader2.GetInt32(7); Character.Network.Guild.Wargold = reader2.GetInt32(8); Character.Network.Guild.StorageGold = reader2.GetInt64(11); Character.Network.Guild.GuildOwner = reader2.GetInt32(9); } } ms = new MsSQL("SELECT * FROM guild_members WHERE guild_id='" + Character.Network.Guild.Guildid + "'"); Character.Network.Guild.TotalMembers = Convert.ToByte(ms.Count()); ms.Close(); //Set max players allowed in guild switch (Character.Network.Guild.Level) { case 1: Character.Network.Guild.MaxMembers = 20; break; case 2: Character.Network.Guild.MaxMembers = 25; break; case 3: Character.Network.Guild.MaxMembers = 30; break; case 4: Character.Network.Guild.MaxMembers = 35; break; case 5: Character.Network.Guild.MaxMembers = 50; break; } //Only load on player login if (logon) { LoadGuildMembers(); } } catch (Exception ex) { Systems.Debugger.Write(ex); Console.WriteLine("LoadPlayerGuildInfo error {0}", ex); } }
/// <summary> /// Creates a new instance of the Cargo class and populates it with data from the specified SqlDataReader. /// </summary> private static CargoInfo MakeCargo(SqlDataReader dataReader) { CargoInfo cargo = new CargoInfo(); if (dataReader.IsDBNull(CargoId) == false) cargo.CargoId = dataReader.GetInt32(CargoId); if (dataReader.IsDBNull(Descripcion) == false) cargo.Descripcion = dataReader.GetString(Descripcion); if (dataReader.IsDBNull(Empresa) == false) cargo.Empresa = dataReader.GetString(Empresa); if (dataReader.IsDBNull(Orden) == false) cargo.Orden = dataReader.GetByte(Orden); return cargo; }
/// <summary> /// Creates a new instance of the ViewResultadoAuditoriaTipo class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewResultadoAuditoriaTipoInfo MakeViewResultadoAuditoriaTipo(SqlDataReader dataReader) { ViewResultadoAuditoriaTipoInfo viewResultadoAuditoriaTipo = new ViewResultadoAuditoriaTipoInfo(); if (dataReader.IsDBNull(AuditoriaId) == false) viewResultadoAuditoriaTipo.AuditoriaId = dataReader.GetInt32(AuditoriaId); if (dataReader.IsDBNull(AuditoriaTipoId) == false) viewResultadoAuditoriaTipo.AuditoriaTipoId = dataReader.GetInt32(AuditoriaTipoId); if (dataReader.IsDBNull(AuditoriaTipo) == false) viewResultadoAuditoriaTipo.AuditoriaTipo = dataReader.GetString(AuditoriaTipo); if (dataReader.IsDBNull(Periodo) == false) viewResultadoAuditoriaTipo.Periodo = dataReader.GetString(Periodo); if (dataReader.IsDBNull(Territorio) == false) viewResultadoAuditoriaTipo.Territorio = dataReader.GetString(Territorio); if (dataReader.IsDBNull(Grupo) == false) viewResultadoAuditoriaTipo.Grupo = dataReader.GetString(Grupo); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewResultadoAuditoriaTipo.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(PuntajeObtenido) == false) viewResultadoAuditoriaTipo.PuntajeObtenido = dataReader.GetDecimal(PuntajeObtenido); if (dataReader.IsDBNull(Cargo) == false) viewResultadoAuditoriaTipo.Cargo = dataReader.GetString(Cargo); if (dataReader.IsDBNull(ResultadoCargo) == false) viewResultadoAuditoriaTipo.ResultadoCargo = dataReader.GetDecimal(ResultadoCargo); if (dataReader.IsDBNull(Orden) == false) viewResultadoAuditoriaTipo.Orden = dataReader.GetByte(Orden); return viewResultadoAuditoriaTipo; }
// Jika tidak menggunakan constructor // hapus pada baris yg di comment // ==================================== // | Alt + Insert untuk meng-generate | // | construktor dari class yg dibuat | // ==================================== public string PengecekField(SqlDataReader hasilPembaca, byte kolom) { string hasil = ""; if (hasilPembaca.IsDBNull(kolom)) { if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Byte") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Boolean") hasil = "false"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int32") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int16") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.String") hasil = ""; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Decimal") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int64") hasil = "0"; else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.DateTime") hasil = "0"; else { MessageBox.Show(Resources.CAlat_PengecekField_Tipe_data_tidak_di_kenali, Resources.CAlat_PengecekField_Infomasi, MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Byte") hasil = hasilPembaca.GetByte(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Boolean") hasil = hasilPembaca.GetBoolean(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int32") hasil = hasilPembaca.GetInt32(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int16") hasil = hasilPembaca.GetInt16(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.String") hasil = hasilPembaca.GetString(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Decimal") hasil = hasilPembaca.GetDecimal(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.Int64") hasil = hasilPembaca.GetInt64(kolom).ToString().Trim(); else if (hasilPembaca.GetFieldType(kolom).ToString().Trim() == "System.DateTime") hasil = string.Format("{0:MM/dd/yyyy}", hasilPembaca.GetDateTime(kolom)); else { MessageBox.Show(Resources.CAlat_PengecekField_Tipe_data_tidak_di_kenali, Resources.CAlat_PengecekField_Infomasi, MessageBoxButtons.OK, MessageBoxIcon.Information); } } return hasil; }
public static short getFieldValue(SqlDataReader dr, int ind, short def) { short val = def; if (!dr.IsDBNull(ind)) { System.TypeCode tp = System.Type.GetTypeCode(dr.GetFieldType(ind)); System.TypeCode typeCode = tp; switch (typeCode) { case System.TypeCode.Boolean: val = (dr.GetBoolean(ind) ? System.Convert.ToInt16(1) : System.Convert.ToInt16(0)); break; case System.TypeCode.Char: case System.TypeCode.SByte: case System.TypeCode.UInt16: break; case System.TypeCode.Byte: val = System.Convert.ToInt16(dr.GetByte(ind)); break; case System.TypeCode.Int16: val = dr.GetInt16(ind); break; case System.TypeCode.Int32: val = System.Convert.ToInt16(dr.GetInt32(ind)); break; default: if (typeCode == System.TypeCode.Decimal) { val = System.Convert.ToInt16(dr.GetDecimal(ind)); } break; } } return val; }
/// <summary> /// Creates a new instance of the ViewAuditoriaListaVerificacionDetalle class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewAuditoriaListaVerificacionDetalleInfo MakeViewAuditoriaListaVerificacionDetalle(SqlDataReader dataReader) { ViewAuditoriaListaVerificacionDetalleInfo viewAuditoriaListaVerificacionDetalle = new ViewAuditoriaListaVerificacionDetalleInfo(); if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId); if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId); if (dataReader.IsDBNull(AuditoriaPuntoId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaPuntoId = dataReader.GetInt32(AuditoriaPuntoId); if (dataReader.IsDBNull(AuditoriaControlId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaControlId = dataReader.GetInt32(AuditoriaControlId); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewAuditoriaListaVerificacionDetalle.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(AuditoriaPunto) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaPunto = dataReader.GetString(AuditoriaPunto); if (dataReader.IsDBNull(AuditoriaControl) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaControl = dataReader.GetString(AuditoriaControl); if (dataReader.IsDBNull(Orden) == false) viewAuditoriaListaVerificacionDetalle.Orden = dataReader.GetByte(Orden); if (dataReader.IsDBNull(Activo) == false) viewAuditoriaListaVerificacionDetalle.Activo = dataReader.GetBoolean(Activo); return viewAuditoriaListaVerificacionDetalle; }
public static bool getFieldValue(SqlDataReader dr, int ind, bool def) { bool val = def; if (!dr.IsDBNull(ind)) { switch (System.Type.GetTypeCode(dr.GetFieldType(ind))) { case System.TypeCode.Boolean: val = dr.GetBoolean(ind); break; case System.TypeCode.Byte: val = System.Convert.ToBoolean(dr.GetByte(ind)); break; case System.TypeCode.Int16: val = System.Convert.ToBoolean(dr.GetInt16(ind)); break; case System.TypeCode.Int32: val = System.Convert.ToBoolean(dr.GetInt32(ind)); break; } } return val; }
private IEnumerable<Tuple<int, SPParameter>> getParameters(SqlDataReader reader) { var index = reader.GetColumnLookup(); foreach (var r in reader) { var procId = reader.GetInt32(index["ProcedureId"]); var typeName = reader.GetString(index["t.name"]); var maxLength = reader.GetInt16(index["t.maxLen"]); var precision = reader.GetByte(index["t.precision"]); var scale = reader.GetByte(index["t.scale"]); var typeInfo = new DbTypeInfo(typeName, null, maxLength, precision, scale); var name = reader.GetString(index["Name"]); var position = reader.GetInt32(index["position"]); var isOutput = reader.GetBoolean(index["output"]); var isReadOnly = reader.GetBoolean(index["readonly"]); var defaultValue = reader.GetValue(index["defaultValue"]); var param = new SPParameter(name, typeInfo, position, isOutput, isReadOnly, defaultValue); yield return Tuple.Create(procId, param); } }
public static System.DateTime getFieldValue(SqlDataReader dr, int ind, System.DateTime def) { System.DateTime val = def; if (!dr.IsDBNull(ind)) { System.TypeCode tp = System.Type.GetTypeCode(dr.GetFieldType(ind)); System.TypeCode typeCode = tp; switch (typeCode) { case System.TypeCode.Byte: val = System.Convert.ToDateTime(dr.GetByte(ind)); break; case System.TypeCode.Int16: val = System.Convert.ToDateTime(dr.GetInt16(ind)); break; case System.TypeCode.UInt16: break; case System.TypeCode.Int32: val = System.Convert.ToDateTime(dr.GetInt32(ind)); break; default: if (typeCode == System.TypeCode.DateTime) { val = dr.GetDateTime(ind); } break; } } return val; }
// Copy multiple fields from reader to ITypedSettersV3 // Assumes caller enforces that reader and setter metadata are compatible internal static void FillCompatibleITypedSettersFromReader( SmiEventSink_Default sink, ITypedSettersV3 setters, SmiMetaData[] metaData, SqlDataReader reader ) { for ( int i = 0; i < metaData.Length; i++ ) { if ( reader.IsDBNull(i) ) { ValueUtilsSmi.SetDBNull_Unchecked( sink, setters, i ); } else { switch ( metaData[i].SqlDbType ) { case SqlDbType.BigInt: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int64 ) ); ValueUtilsSmi.SetInt64_Unchecked( sink, setters, i, reader.GetInt64(i) ); break; case SqlDbType.Binary: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); ValueUtilsSmi.SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; case SqlDbType.Bit: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Boolean ) ); SetBoolean_Unchecked( sink, setters, i, reader.GetBoolean(i) ); break; case SqlDbType.Char: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) ); SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 ); break; case SqlDbType.DateTime: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.DateTime ) ); SetDateTime_Checked( sink, setters, i, metaData[i], reader.GetDateTime(i) ); break; case SqlDbType.Decimal: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlDecimal ) ); SetSqlDecimal_Unchecked( sink, setters, i, reader.GetSqlDecimal(i) ); break; case SqlDbType.Float: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Double ) ); SetDouble_Unchecked( sink, setters, i, reader.GetDouble(i) ); break; case SqlDbType.Image: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; case SqlDbType.Int: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int32 ) ); SetInt32_Unchecked( sink, setters, i, reader.GetInt32(i) ); break; case SqlDbType.Money: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlMoney ) ); SetSqlMoney_Unchecked( sink, setters, i, metaData[i], reader.GetSqlMoney(i) ); break; case SqlDbType.NChar: case SqlDbType.NText: case SqlDbType.NVarChar: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) ); SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 ); break; case SqlDbType.Real: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Single ) ); SetSingle_Unchecked( sink, setters, i, reader.GetFloat(i) ); break; case SqlDbType.UniqueIdentifier: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Guid ) ); SetGuid_Unchecked( sink, setters, i, reader.GetGuid(i) ); break; case SqlDbType.SmallDateTime: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.DateTime ) ); SetDateTime_Checked( sink, setters, i, metaData[i], reader.GetDateTime(i) ); break; case SqlDbType.SmallInt: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Int16 ) ); SetInt16_Unchecked( sink, setters, i, reader.GetInt16(i) ); break; case SqlDbType.SmallMoney: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlMoney ) ); SetSqlMoney_Checked( sink, setters, i, metaData[i], reader.GetSqlMoney(i) ); break; case SqlDbType.Text: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlChars ) ); SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 ); break; case SqlDbType.Timestamp: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; case SqlDbType.TinyInt: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.Byte ) ); SetByte_Unchecked( sink, setters, i, reader.GetByte(i) ); break; case SqlDbType.VarBinary: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; case SqlDbType.VarChar: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.String ) ); SetSqlChars_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlChars(i), 0 ); break; case SqlDbType.Xml: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlXml ) ); SetSqlXml_Unchecked( sink, setters, i, reader.GetSqlXml(i) ); break; case SqlDbType.Variant: object o = reader.GetSqlValue(i); ExtendedClrTypeCode typeCode = MetaDataUtilsSmi.DetermineExtendedTypeCode( o ); SetCompatibleValue( sink, setters, i, metaData[i], o, typeCode, 0 ); break; case SqlDbType.Udt: Debug.Assert( CanAccessSetterDirectly( metaData[i], ExtendedClrTypeCode.SqlBytes ) ); SetSqlBytes_LengthChecked( sink, setters, i, metaData[i], reader.GetSqlBytes(i), 0 ); break; default: // In order for us to get here we would have to have an // invalid instance of SqlDbType, or one would have to add // new member to SqlDbType without adding a case in this // switch, hence the assert - it must be Debug.Assert( false, "unsupported DbType:" + metaData[i].SqlDbType.ToString() ); throw ADP.NotSupported(); } } } }
public static byte[] Load(character c) { PacketWriter Writer = new PacketWriter(); Writer.Create(Systems.SERVER_PLAYERDATA); /////////////////////////////////////////////////////// Character basic info #region Basic info Writer.DWord(c.Ids.GetLoginID); Writer.DWord(c.Information.Model); Writer.Byte(c.Information.Volume); Writer.Byte(c.Information.Level); Writer.Byte(c.Information.Level); Writer.LWord(c.Information.XP); Writer.DWord(c.Information.SpBar); Writer.LWord(c.Information.Gold); Writer.DWord(c.Information.SkillPoint); Writer.Word(c.Information.Attributes); Writer.Byte(c.Information.BerserkBar); Writer.DWord(0); Writer.DWord(c.Stat.SecondHp); Writer.DWord(c.Stat.SecondMP); Writer.Bool(c.Information.Level < 20 ? true : false); #endregion /////////////////////////////////////////////////////// Character Player Kill Info #region Pk information //Mssql perfection reading with multiple data adapters... while this one is open i can still read anything else from the database //With no speed reduction... Systems.MsSQL checkpk = new Systems.MsSQL("SELECT * FROM character WHERE name ='" + c.Information.Name + "'"); using (System.Data.SqlClient.SqlDataReader getinfo = checkpk.Read()) { while (getinfo.Read()) { byte dailypk = getinfo.GetByte(48); byte pklevel = getinfo.GetByte(49); byte murderlevel = getinfo.GetByte(50); Writer.Byte(dailypk); Writer.Word(pklevel); Writer.DWord(murderlevel); if (murderlevel != 0) c.Information.Murderer = true; } } #endregion /////////////////////////////////////////////////////// Character Title #region Title Writer.Byte(c.Information.Title); #endregion /////////////////////////////////////////////////////// Character Pvpstate #region Pvp Writer.Byte(c.Information.Pvpstate); if (c.Information.Pvpstate > 0) c.Information.PvP = true; #endregion /////////////////////////////////////////////////////// Character Items #region Item Writer.Byte(c.Information.Slots); Systems.MsSQL ms = new Systems.MsSQL("SELECT * FROM char_items WHERE owner='" + c.Information.CharacterID + "' AND slot >= '0' AND slot <= '" + c.Information.Slots + "' AND inavatar='0' AND storagetype='0'"); Writer.Byte(ms.Count()); using (System.Data.SqlClient.SqlDataReader msreader = ms.Read()) { while (msreader.Read()) { short amount = msreader.GetInt16(6); if (amount < 1) amount = 1; Systems.MsSQL.InsertData("UPDATE char_items SET quantity='" + amount + "' WHERE owner='" + c.Information.CharacterID + "' AND itemid='" + msreader.GetInt32(2) + "' AND id='" + msreader.GetInt32(0) + "' AND storagetype='0'"); if (msreader.GetByte(5) == 6) c.Information.Item.wID = Convert.ToInt32(msreader.GetInt32(2)); if (msreader.GetByte(5) == 7) { c.Information.Item.sID = msreader.GetInt32(2); c.Information.Item.sAmount = msreader.GetInt16(6); } Item.AddItemPacket(Writer, msreader.GetByte(5), msreader.GetInt32(2), msreader.GetByte(4), amount, msreader.GetInt32(7),msreader.GetInt32(0), msreader.GetInt32(9), msreader.GetInt32(30)); } } ms.Close(); //Avatar Writer.Byte(5); ms = new Systems.MsSQL("SELECT * FROM char_items WHERE owner='" + c.Information.CharacterID + "' AND slot >= '0' AND slot <= '" + c.Information.Slots + "' AND inavatar='1' AND storagetype='0'"); Writer.Byte(ms.Count()); using (System.Data.SqlClient.SqlDataReader msreader = ms.Read()) { while (msreader.Read()) { Item.AddItemPacket(Writer, msreader.GetByte(5), msreader.GetInt32(2), msreader.GetByte(4), msreader.GetInt16(6), msreader.GetInt32(7), msreader.GetInt32(0), msreader.GetInt32(9),msreader.GetInt32(30)); } } ms.Close(); Writer.Byte(0); // job mastery Writer.Byte(0x0B); Writer.Byte(0); Writer.Byte(0); #endregion /////////////////////////////////////////////////////// Mastery #region Mastery if (c.Information.Model <= 12000) { for (byte i = 1; i <= 8; i++) { Writer.Byte(1); Writer.DWord(c.Stat.Skill.Mastery[i]); Writer.Byte(c.Stat.Skill.Mastery_Level[i]); } } else { if (c.Information.Model >= 14000) { for (byte i = 1; i < 8; i++) { Writer.Byte(1); Writer.DWord(c.Stat.Skill.Mastery[i]); Writer.Byte(c.Stat.Skill.Mastery_Level[i]); } } } #endregion /////////////////////////////////////////////////////// Skills #region Skill Writer.Byte(2); Writer.Byte(0); for (int i = 1; i <= c.Stat.Skill.AmountSkill; i++) { Writer.Byte(1); Writer.DWord(c.Stat.Skill.Skill[i]); Writer.Byte(1); } Writer.Byte(2); #endregion /////////////////////////////////////////////////////// Quests #region Quest Writer.Word(1); // how many Quest ids completed/aborted Writer.DWord(1);// Quest id Writer.Byte(0);//number of Quests that are live #endregion Writer.Byte(0);//? for now /////////////////////////////////////////////////////// Talisman #region Talisman Writer.DWord(1);//new Writer.DWord(1);//new Writer.DWord(0);//? for now Writer.DWord(0x0C);//new #endregion /////////////////////////////////////////////////////// Position + id + speed #region Character id / Position / Speed Writer.DWord(c.Information.UniqueID); Writer.Byte(c.Position.xSec); Writer.Byte(c.Position.ySec); if (!File.FileLoad.CheckCave(c.Position.xSec, c.Position.ySec)) { Writer.Float(Formule.packetx(c.Position.x, c.Position.xSec)); Writer.Float(c.Position.z); Writer.Float(Formule.packety(c.Position.y, c.Position.ySec)); } else { Writer.Float(Formule.cavepacketx(c.Position.x));// Added for cave Coords Writer.Float(c.Position.z); Writer.Float(Formule.cavepackety(c.Position.y));// Added for cave Coords } Writer.Word(0); // Angle Writer.Byte(0); Writer.Byte(1); Writer.Byte(0); Writer.Word(0); // Angle Writer.Word(0); Writer.Byte(0); Writer.Bool(false); //berserk Writer.Byte(0);//new ? Writer.Float(c.Speed.WalkSpeed); Writer.Float(c.Speed.RunSpeed); Writer.Float(c.Speed.BerserkSpeed); #endregion /////////////////////////////////////////////////////// Premium Tickets #region Premium ticket Writer.Byte(0); //ITEM_MALL_GOLD_TIME_SERVICE_TICKET_4W #endregion /////////////////////////////////////////////////////// GM Check + Name #region GM Check + Name Writer.Text(c.Information.Name); #endregion /////////////////////////////////////////////////////// Character jobs #region Character Job / hunter thief trader ( old job things ) //Writer info with job name when on job /*if (c.Job.state == 1 && c.Job.Jobname != "0") { Writer.Text(c.Job.Jobname); Writer.Byte(3); Writer.Byte(1); Writer.DWord(0); Writer.DWord(0); Writer.DWord(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); } //Write basic info noname if (c.Job.Jobname == "0") { Writer.Word(0); Writer.Byte(3); Writer.Byte(1); Writer.DWord(0); Writer.DWord(0); Writer.DWord(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); } //Write no info else { Writer.Word(0); Writer.Byte(0); Writer.Byte(1); Writer.DWord(0); Writer.DWord(0); Writer.DWord(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); }*/ #endregion #region New job system if (c.Job.state == 1) { Writer.Text(c.Job.Jobname); Writer.Byte(1); Writer.Byte(c.Job.level);//Level job Writer.Byte(c.Information.Level);//Level char Writer.Byte(1); // job level? myb Writer.LWord(0);// job exp probably y Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); } else { Writer.Word(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(2); // job type Writer.Byte(1); // job level? myb Writer.LWord(0);// job exp probably y Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); Writer.Byte(0); } #endregion /////////////////////////////////////////////////////// Pvp / Pk State #region Pvp / Pk State if (c.Information.Pvpstate == 1 || c.Information.Murderer) { Writer.Byte(0x22); } else if (c.Information.Pvpstate == 0 || !c.Information.Murderer) { Writer.Byte(0xFF); } #endregion /////////////////////////////////////////////////////// Guide Data #region Guide Data this data stacks on itself so if guide id is 0400000000000000 and next guide is 0300000000000000 the data to send is 0700000000000000 for (int i = 0; i < 8; ++i)//Main Guide Packet Info { Writer.Byte(c.Guideinfo.G1[i]);//Reads From Int Array } #endregion /////////////////////////////////////////////////////// Account / Gm Check #region Account ID + Gm Check Writer.DWord(c.Account.ID); Writer.Byte(0);//c.Information.GM #endregion /////////////////////////////////////////////////////// Quickbar + Autopotion #region Bar information Writer.Byte(7); PacketReader reader = new PacketReader(System.IO.File.ReadAllBytes(Environment.CurrentDirectory + @"\player\info\quickbar\" + c.Information.Name + ".dat")); PlayerQuickBar(reader, Writer); reader = new PacketReader(System.IO.File.ReadAllBytes(Environment.CurrentDirectory + @"\player\info\autopot\" + c.Information.Name + ".dat")); PlayerAutoPot(reader, Writer); #endregion /////////////////////////////////////////////////////// Academy #region Academy Writer.Byte(0); // number of player in academy /* // if we have players there Writer.Byte(1); Writer.Text("asd"); */ Writer.Byte(0);//added byte today for 1.310 Writer.Byte(0); Writer.Word(1); Writer.Word(1); Writer.Byte(0); Writer.Byte(1); #endregion return Writer.GetBytes(); }