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));
}
