public DBGodEquipGoodsItem GetData(uint id)
{
DBGodEquipGoodsItem ad = null;
if (!data.TryGetValue(id, out ad))
{
string query_str = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\" ", mTableName, "gid", id.ToString());
var table_reader = DBManager.Instance.ExecuteSqliteQueryToReader(mFileName, VoiceTableName, query_str);
if (table_reader == null)
{
data[id] = null;
return(null);
}
if (!table_reader.HasRows)
{
data[id] = null;
table_reader.Close();
table_reader.Dispose();
return(null);
}
if (!table_reader.Read())
{
data[id] = null;
table_reader.Close();
table_reader.Dispose();
return(null);
}
ad = new DBGodEquipGoodsItem();
ad.Gid = DBTextResource.ParseUI(GetReaderString(table_reader, "gid"));
ad.Pos = DBTextResource.ParseUI(GetReaderString(table_reader, "pos_id"));
ad.LvStep = DBTextResource.ParseUI(GetReaderString(table_reader, "lv_step"));
ad.SwallowExpValue = DBTextResource.ParseUI(GetReaderString(table_reader, "value"));
ad.GrooveNum = DBTextResource.ParseUI(GetReaderString(table_reader, "groove_num"));
ad.BasicAttrs = DBTextResource.ParseDictionaryUintUint(GetReaderString(table_reader, "attrs"));
data.Add(ad.Gid, ad);
table_reader.Close();
table_reader.Dispose();
}
return(ad);
}
public LightWeaponSoul GetData(uint GID)
{
if (data.ContainsKey(GID))
{
return(data[GID]);
}
string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "id", GID);
var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query);
if (reader == null)
{
data[GID] = null;
return(null);
}
if (!reader.HasRows || !reader.Read())
{
data[GID] = null;
reader.Close();
reader.Dispose();
return(null);
}
var soul = new LightWeaponSoul();
soul.GID = DBTextResource.ParseUI_s(GetReaderString(reader, "id"), 0);
List <uint> Pos = DBTextResource.ParseArrayUint(GetReaderString(reader, "position"), ",");
soul.Pos_Type = Pos[0];
soul.Pos_Index = Pos[1];
var Resolve = DBTextResource.ParseArrayUint(GetReaderString(reader, "break"), ",");
soul.ResolveType = Resolve[0];
soul.ResolveAmount = Resolve[1];
soul.BasicAttrs = DBTextResource.ParseDictionaryUintUint(GetReaderString(reader, "base_attrs"));
data[GID] = soul;
reader.Close();
reader.Dispose();
return(soul);
}
protected override void ParseData(SqliteDataReader reader)
{
mInfos.Clear();
DBBaptizeGrooveInfo info;
if (reader != null)
{
if (reader.HasRows == true)
{
while (reader.Read())
{
info = new DBBaptizeGrooveInfo();
info.Id = DBTextResource.ParseUI_s(GetReaderString(reader, "id"), 0);
info.Cost = DBTextResource.ParseDictionaryUintUint(GetReaderString(reader, "cost"));
info.AttrAddition = DBTextResource.ParseUI_s(GetReaderString(reader, "attr_addition"), 0);
info.BaseRank = DBTextResource.ParseUI_s(GetReaderString(reader, "base_rank"), 0);
mInfos[info.Id] = info;
}
}
}
}
/// <summary>
/// 获取某个副本的信息
/// </summary>
/// <returns>The instance info.</returns>
/// <param name="id">Identifier.</param>
public InstanceInfo GetInstanceInfo(uint id)
{
InstanceInfo info = null;
if (mInstanceInfos.TryGetValue(id, out info))
{
return(info);
}
string queryStr = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "id", id.ToString());
var table_reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, queryStr);
if (table_reader == null)
{
mInstanceInfos.Add(id, null);
return(null);
}
if (!table_reader.HasRows)
{
mInstanceInfos.Add(id, null);
table_reader.Close();
table_reader.Dispose();
return(null);
}
if (!table_reader.Read())
{
mInstanceInfos.Add(id, null);
table_reader.Close();
table_reader.Dispose();
return(null);
}
info = new InstanceInfo();
Type gameConstType = typeof(GameConst);
info.mId = DBTextResource.ParseUI_s(GetReaderString(table_reader, "id"), 0);
info.mMaxTime = DBTextResource.ParseI(GetReaderString(table_reader, "max_time"));
info.mNeedGoods = DBTextResource.ParseDictionaryUintUint(GetReaderString(table_reader, "need_goods"));
info.mDyNeedGoods = DBTextResource.ParseArrayUintUint(GetReaderString(table_reader, "dy_need_goods"));
info.mNeedLv = DBTextResource.ParseUS_s(GetReaderString(table_reader, "need_lv"), 0);
info.mLvUpLimit = DBTextResource.ParseUS_s(GetReaderString(table_reader, "lv_up_limit"), 0);
info.mRecommendAttrs = ParseRecommendAttrs(GetReaderString(table_reader, "recommend_attrs"));
info.mSingleEnter = DBTextResource.ParseI(GetReaderString(table_reader, "single_enter")) == 1 ? true : false;
string mbCountStr = GetReaderString(table_reader, "mb_count");
ushort mbCount = 0;
/* 进入人数四种要求:
* 0：可单人，也可以任意组队(不用配)
* 1：必须单人(可以没有队伍，也可以在只有他一个人的队伍中)
* N(N>=2)：必须N人以上组队
* {M,N}：大于等于M且小于等于N */
if (string.IsNullOrEmpty(mbCountStr) == true)
{
info.mMinMemberCount = 0;
info.mMaxMemberCount = GameConstHelper.GetShort("GAME_TEAM_MEMBER_LIMIT");
}
else if (ushort.TryParse(mbCountStr, out mbCount) == true)
{
info.mMinMemberCount = mbCount;
if (info.mMinMemberCount == 0)
{
info.mMaxMemberCount = GameConstHelper.GetShort("GAME_TEAM_MEMBER_LIMIT");
}
else if (info.mMinMemberCount == 1)
{
info.mMinMemberCount = 0;
info.mMaxMemberCount = 1;
}
else
{
info.mMaxMemberCount = GameConstHelper.GetShort("GAME_TEAM_MEMBER_LIMIT");
}
}
else
{
List <uint> mbCountList = DBTextResource.ParseArrayUint(mbCountStr, ",");
if (mbCountList.Count >= 2)
{
info.mMinMemberCount = (ushort)mbCountList[0];
info.mMaxMemberCount = (ushort)mbCountList[1];
}
}
info.mSweepCosts = DBTextResource.ParseDictionaryUintUint(GetReaderString(table_reader, "sweep_costs"));
info.mSweepLimit = DBTextResource.ParseVector2(GetReaderString(table_reader, "sweep_limit"));
info.mName = GetReaderString(table_reader, "name");
//System.Reflection.FieldInfo fieldInfo = null;
//string warTypeStr = GetReaderString(table_reader, "war_type");
//if (mGameConstUintValueCache.ContainsKey(warTypeStr) == true)
//{
// info.mWarType = mGameConstUintValueCache[warTypeStr];
//}
//else
//{
// fieldInfo = gameConstType.GetField(warTypeStr);
// if (fieldInfo != null)
// {
// info.mWarType = Convert.ToUInt32(fieldInfo.GetValue(null));
// mGameConstUintValueCache[warTypeStr] = info.mWarType;
// }
// else
// {
// GameDebug.LogError("Can not find war type " + warTypeStr + " in db instance!!!");
// }
//}
//string warsubTypeStr = GetReaderString(table_reader, "war_subtype");
//if (string.IsNullOrEmpty(warsubTypeStr) == false)
//{
// if (mGameConstUintValueCache.ContainsKey(warsubTypeStr) == true)
// {
// info.mWarSubType = mGameConstUintValueCache[warsubTypeStr];
// }
// else
// {
// fieldInfo = gameConstType.GetField(warsubTypeStr);
// if (fieldInfo != null)
// {
// info.mWarSubType = Convert.ToUInt32(fieldInfo.GetValue(null));
// mGameConstUintValueCache[warsubTypeStr] = info.mWarSubType;
// }
// else
// {
// GameDebug.LogError("Can not find sub war type " + warsubTypeStr + " in db instance!!!");
// }
// }
//}
uint warType = 0;
uint warSubType = 0;
string warTypeStr = GetReaderString(table_reader, "war_type");
string warSubTypeStr = GetReaderString(table_reader, "war_subtype");
ConvertWarType(warTypeStr, warSubTypeStr, out warType, out warSubType);
info.mWarType = warType;
info.mWarSubType = warSubType;
info.mDesc = GetReaderString(table_reader, "desc");
info.mStages.Clear();
string stagesStr = GetReaderString(table_reader, "stages");
List <string> stages = DBTextResource.ParseArrayString(stagesStr);
for (int j = 0; j < stages.Count; j++)
{
if (!String.IsNullOrEmpty(stages[j]))
{
info.mStages.Add(DBTextResource.ParseUI(stages[j]));
}
}
info.mPKType = DBTextResource.ParseI(GetReaderString(table_reader, "pk_type"));
info.mReviveTimes = DBTextResource.ParseUS(GetReaderString(table_reader, "revive_times"));
info.mReadyCountDown = DBTextResource.ParseUS(GetReaderString(table_reader, "ready_count_down"));
info.mResultCountDown = DBTextResource.ParseUI(GetReaderString(table_reader, "result_count_down"));
info.mIsReloadSceneWhenTheSame = DBTextResource.ParseI(GetReaderString(table_reader, "is_reload_scene_when_the_same")) == 0 ? false : true;
info.mMinPos = DBTextResource.ParseVector2(GetReaderString(table_reader, "mini_map_pos_x"));
info.mMaxPos = DBTextResource.ParseVector2(GetReaderString(table_reader, "mini_map_pos_y"));
info.mMiniMapWidth = info.mMaxPos.x - info.mMinPos.x;
info.mMiniMapHeight = info.mMaxPos.y - info.mMinPos.y;
info.mMiniMapName = GetReaderString(table_reader, "mini_map");
info.mIsCanOpenMiniMap = DBTextResource.ParseI(GetReaderString(table_reader, "is_open_mini_map")) == 0 ? false : true;
string isShowMarkStr = GetReaderString(table_reader, "is_show_mark");
if (isShowMarkStr == string.Empty || isShowMarkStr == "0")
{
info.mIsShowMark = false;
}
else
{
info.mIsShowMark = true;
}
string isAutoFightStr = GetReaderString(table_reader, "is_auto_fight");
if (isAutoFightStr == string.Empty || isAutoFightStr == "0")
{
info.mIsAutoFight = false;
}
else
{
info.mIsAutoFight = true;
}
string canNotRideStr = GetReaderString(table_reader, "can_not_ride");
if (canNotRideStr == string.Empty || canNotRideStr == "0")
{
info.mCanNotRide = false;
}
else
{
info.mCanNotRide = true;
}
info.mRewardIds = DBTextResource.ParseArrayUint(GetReaderString(table_reader, "reward_1"), ",");
info.mShowRewardIds = DBTextResource.ParseArrayUint(GetReaderString(table_reader, "show_rewards"), ",");
info.mNeedTaskId = DBTextResource.ParseUI_s(GetReaderString(table_reader, "need_task_id"), 0);
info.mPlanesInstanceId = DBTextResource.ParseUI_s(GetReaderString(table_reader, "planes_dg_id"), 0);
info.mStartTimeline = DBTextResource.ParseUI_s(GetReaderString(table_reader, "start_timeline"), 0);
info.mGuardedNpcId = DBTextResource.ParseUI_s(GetReaderString(table_reader, "npc_id"), 0);
string showBossAssStr = GetReaderString(table_reader, "show_boss_assistant");
if (showBossAssStr == string.Empty || showBossAssStr == "0")
{
info.mShowBossAssistant = false;
}
else
{
info.mShowBossAssistant = true;
}
info.mForbidJumpOutAnimationOut = DBTextResource.ParseUI_s(GetReaderString(table_reader, "forbid_jump_out_animation_out"), 0) == 1;
info.mForbidWaterWaveEffect = DBTextResource.ParseUI_s(GetReaderString(table_reader, "forbid_water_wave_effect"), 0) == 1;
info.mIsCanSendPosition = DBTextResource.ParseUI_s(GetReaderString(table_reader, "is_can_send_position"), 0) == 1;
info.mMergeLevel = DBTextResource.ParseUI_s(GetReaderString(table_reader, "merge_level"), 0);
info.mMergeConsume = DBTextResource.ParseDictionaryUintUint(GetReaderString(table_reader, "merge_consume"));
#if UNITY_EDITOR
if (mInstanceInfos.ContainsKey(info.mId))
{
GameDebug.LogError(string.Format("[{0}]表重复添加的域id[{1}]", mTableName, info.mId));
table_reader.Close();
table_reader.Dispose();
return(info);
}
#endif
mInstanceInfos.Add(info.mId, info);
table_reader.Close();
table_reader.Dispose();
return(info);
}
