public void ResetData(string type)
{
try
{
var sql = new ZinSQL("game_data");
var paramList = new List <MySqlParameter>();
sql.SetQuery("DataType", type);
Delete(sql, paramList);
}
catch (Exception ex)
{
// LogHelper.WriteErrorLog(ex);
// LogHelper.WriteErrorLog(string.Format("Delete Data {0} Error", type));
}
}
/// <summary>
/// 保存数据
/// </summary>
public void SaveData <T>(string type, T data, DatabaseConfig config = null)
where T : new()
{
#if NoneWriteSQL
return;
#endif
try
{
var sql = new ZinSQL("game_data");
var paramList = new List <MySqlParameter>();
paramList.Add(sql.AddParam("DataValue", SerializationHelper.Serialize <T>(data)));
paramList.Add(sql.AddParam("DataType", type));
sql.SetQuery("DataType", type);
sql.Config = config;
InsertOrUpdate(sql, paramList);
}
catch (Exception ex)
{
// LogHelper.WriteErrorLog(ex);
// LogHelper.WriteErrorLog(string.Format("Save Data {0} Error", type));
}
}
/// <summary>
/// 初始化数据
/// </summary>
public T LoadData <T>(string type, DatabaseConfig config = null)
where T : new()
{
// 生成SQL
var sql = new ZinSQL("game_data");
sql.AddField("DataValue");
sql.SetQuery("DataType", type);
sql.Config = config;
// 获取数据
var data = Get(sql);
if (data != null && data[0] != DBNull.Value)
{
var value = SerializationHelper.Deserialize <T>((byte[])data[0]);
if (value != null)
{
return(value);
}
}
return(new T());
}
