public static short GetInt16(System.Data.IDataReader dataReader, int i) { if (dataReader.IsDBNull(i)) { return(short.MinValue); } return(dataReader.GetInt16(i)); }
/// <summary> /// /// </summary> /// <param name="dataReader"></param> /// <param name="i"></param> /// <returns></returns> public static short?GetInt16Nullable(System.Data.IDataReader dataReader, int i) { if (dataReader.IsDBNull(i)) { return(null); } return(dataReader.GetInt16(i)); }
private static T_Entity DataReader2Entity(System.Data.IDataReader dataReader) { T_Entity obj = new T_Entity { FLong = dataReader.GetInt64(0), FString = dataReader.GetString(1), FDecimal = dataReader.GetDecimal(2), FNullDecimal = dataReader.IsDBNull(3) ? default(decimal?) : dataReader.GetDecimal(3), FBool = dataReader.GetBoolean(4), FNullBool = dataReader.IsDBNull(5) ? default(bool?) : dataReader.GetBoolean(5), Status = (EntityStatus)Enum.ToObject(_entityStatusType, dataReader.GetInt16(7)), NullStatus = dataReader.IsDBNull(8) ? default(EntityStatus?) : (EntityStatus)Enum.ToObject(_entityStatusType, dataReader.GetInt16(8)), CreationTime = dataReader.GetDateTime(9), LastUpdateTime = dataReader.IsDBNull(10) ? default(DateTime?) : dataReader.GetDateTime(10), }; return(obj); }
public bool RestoreData(string bakFullName) { string arg; string dataSource; using (System.Data.Common.DbConnection dbConnection = this.database.CreateConnection()) { arg = dbConnection.Database; dataSource = dbConnection.DataSource; } System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(string.Format("Data Source={0};Initial Catalog=master;Integrated Security=SSPI", dataSource)); bool result; try { sqlConnection.Open(); System.Data.SqlClient.SqlCommand sqlCommand = new System.Data.SqlClient.SqlCommand(string.Format("SELECT spid FROM sysprocesses ,sysdatabases WHERE sysprocesses.dbid=sysdatabases.dbid AND sysdatabases.Name='{0}'", arg), sqlConnection); ArrayList arrayList = new ArrayList(); using (System.Data.IDataReader dataReader = sqlCommand.ExecuteReader()) { while (dataReader.Read()) { arrayList.Add(dataReader.GetInt16(0)); } } for (int i = 0; i < arrayList.Count; i++) { sqlCommand = new System.Data.SqlClient.SqlCommand(string.Format("KILL {0}", arrayList[i].ToString()), sqlConnection); sqlCommand.ExecuteNonQuery(); } sqlCommand = new System.Data.SqlClient.SqlCommand(string.Format("RESTORE DATABASE [{0}] FROM DISK = '{1}' WITH REPLACE", arg, bakFullName), sqlConnection); sqlCommand.ExecuteNonQuery(); result = true; } catch { result = false; } finally { sqlConnection.Close(); } return(result); }
private static T_Entity DataReader2Entity_GetValue(System.Data.IDataReader dataReader) { var FNullDecimal = dataReader.GetValue(3); var FNullBool = dataReader.GetValue(5); var NullStatus = dataReader.GetValue(8); var LastUpdateTime = dataReader.GetValue(10); T_Entity obj = new T_Entity { FLong = dataReader.GetInt64(0), FString = dataReader.GetString(1), FDecimal = dataReader.GetDecimal(2), FNullDecimal = FNullDecimal == DBNull.Value ? default(decimal?) : (decimal)FNullDecimal, FBool = dataReader.GetBoolean(4), FNullBool = FNullBool == DBNull.Value ? default(bool?) : (bool)FNullBool, Status = (EntityStatus)Enum.ToObject(_entityStatusType, dataReader.GetInt16(7)), NullStatus = NullStatus == DBNull.Value ? default(EntityStatus?) : (EntityStatus)Enum.ToObject(_entityStatusType, NullStatus), CreationTime = dataReader.GetDateTime(9), LastUpdateTime = LastUpdateTime == DBNull.Value ? default(DateTime?) : (DateTime)LastUpdateTime, }; return(obj); }
public IQuest ParseQuest(System.Data.IDataReader reader) { dbReader = DatabaseReader.Instance(); IQuest currentQuest = null; string name = reader.GetString(0); string description = reader.GetString(1); int type = reader.GetInt32(2); int rewardExp = reader.GetInt32(3); int rewardMoney = reader.GetInt16(4); double prevValue = reader.GetDouble(5); double requireValue = reader.GetDouble(6); switch (type) { case 0: // Distance double totalDistance = dbReader.totalDistance; currentQuest = new DistanceQuest (name, description, requireValue, prevValue, rewardExp, rewardMoney); break; case 1: // Share int totalShare = dbReader.totalShare; currentQuest = new FacebookQuest( name, description, (int)prevValue, (int)requireValue, rewardExp, rewardMoney); break; default: break; } return(currentQuest); }
public static short Short(System.Data.IDataReader reader, MapPoint mapPoint, short defaultValue = 0) { try { return(mapPoint.IsInResultSet() && !reader.IsDBNull(mapPoint.Index) ? reader.GetInt16(mapPoint.Index) : defaultValue); } catch (Exception) { throw; } }
public void SetFromReader <T>(T obj, System.Data.IDataReader reader, Action <T, string, object> setMethod) where T : class { if (!reader.IsDBNull(this.Index)) { switch (this.SqlType) { case System.Data.SqlDbType.BigInt: setMethod(obj, FieldName, reader.GetInt64(this.Index)); break; case System.Data.SqlDbType.Image: case System.Data.SqlDbType.VarBinary: case System.Data.SqlDbType.Binary: long size = reader.GetBytes(this.Index, 0, null, 0, 0); byte[] values = new byte[size]; int bufferSize = 1024; long bytesRead = 0; int curPos = 0; while (bytesRead < size) { bytesRead += reader.GetBytes(this.Index, curPos, values, curPos, bufferSize); curPos += bufferSize; } setMethod(obj, FieldName, values); break; case System.Data.SqlDbType.Bit: setMethod(obj, FieldName, reader.GetBoolean(this.Index)); break; case System.Data.SqlDbType.Char: setMethod(obj, FieldName, reader.GetChar(this.Index)); break; case System.Data.SqlDbType.SmallDateTime: case System.Data.SqlDbType.Date: case System.Data.SqlDbType.DateTime: case System.Data.SqlDbType.DateTime2: setMethod(obj, FieldName, reader.GetDateTime(this.Index)); break; case System.Data.SqlDbType.SmallMoney: case System.Data.SqlDbType.Money: case System.Data.SqlDbType.Decimal: setMethod(obj, FieldName, reader.GetDecimal(this.Index)); break; case System.Data.SqlDbType.Float: setMethod(obj, FieldName, reader.GetDouble(this.Index)); break; case System.Data.SqlDbType.Int: setMethod(obj, FieldName, reader.GetInt32(this.Index)); break; case System.Data.SqlDbType.Text: case System.Data.SqlDbType.NVarChar: case System.Data.SqlDbType.NText: case System.Data.SqlDbType.VarChar: case System.Data.SqlDbType.NChar: setMethod(obj, FieldName, reader.GetString(this.Index)); break; case System.Data.SqlDbType.Real: setMethod(obj, FieldName, reader.GetFloat(this.Index)); break; case System.Data.SqlDbType.SmallInt: setMethod(obj, FieldName, reader.GetInt16(this.Index)); break; case System.Data.SqlDbType.TinyInt: setMethod(obj, FieldName, reader.GetByte(this.Index)); break; case System.Data.SqlDbType.UniqueIdentifier: setMethod(obj, FieldName, reader.GetGuid(this.Index)); break; default: break; } } else { setMethod(obj, FieldName, null); } }
public static short GetInt16(System.Data.IDataReader reader, int rowNum, short defaultValue) { return(reader.IsDBNull(rowNum) ? defaultValue : reader.GetInt16(rowNum)); }
public static short?GetInt16(System.Data.IDataReader reader, int rowNum) { return(reader.IsDBNull(rowNum) ? (short?)null : reader.GetInt16(rowNum)); }
short System.Data.IDataRecord.GetInt16(int i) { return(_dataReader.GetInt16(i)); }