public ScenicSpot FindById(string mapName, string id)
{
this.cs = Document.Instance.GetSheet(mapName);
if (this.cs == null)
{
return(null);
}
ScenicSpot ss = new ScenicSpot();
DataRow[] drs = this.cs.Data.Select("Id='" + id + "'");
if (drs.Length > 0)
{
DataRow dr = drs[0];
ss.Id = dr["Id"].ToString();
ss.Name = dr["Name"].ToString();
ss.Summary = dr["Summary"].ToString();
ss.AudioUrl = dr["AudioUrl"].ToString();
ss.AudioSegments = dr["AudioSegments"].ToString();
ss.PictureUrl = dr["PictureUrl"].ToString();
ss.StarLevel = dr["StarLevel"].ToString();
ss.Kind = dr["Kind"].ToString();
}
return(ss);
}
public ITEM FindById(string id)
{
XxdwDebugger.Log("hhhhhhhhhh");
this.cs = Document.Instance.GetSheet("ITEM");
if (this.cs == null)
{
return(null);
}
ITEM ss = new ITEM();
DataRow[] drs = this.cs.Data.Select("NUM='" + id + "'");
if (drs.Length > 0)
{
XxdwDebugger.Log("hhhhhhhhhh");
DataRow dr = drs[0];
ss.NUM = dr["NUM"].ToString();
ss.NAME = dr["NAME"].ToString();
ss.DAZE_TIME = int.Parse(dr["DAZE_TIME"].ToString());
ss.POISON_TIME = int.Parse(dr["POISON_TIME"].ToString());
ss.POISON_DAM = int.Parse(dr["POISON_DAM"].ToString());
ss.FREEZE_TIME = int.Parse(dr["FREEZE_TIME"].ToString());
ss.DAMAGE_PCT = int.Parse(dr["DAMAGE_PCT"].ToString());
ss.TELEPORT = int.Parse(dr["TELEPORT"].ToString());
ss.TARGET = int.Parse(dr["TARGET"].ToString());
ss.USE_REP = bool.Parse(dr["USE_REP"].ToString());
ss.CD = int.Parse(dr["CD"].ToString());
ss.LV_UP = int.Parse(dr["LV_UP"].ToString());
ss.LV_DOWN = int.Parse(dr["LV_DOWN"].ToString());
}
return(ss);
}
public List <ScenicSpot> GetAll(string mapName)
{
List <ScenicSpot> list = new List <ScenicSpot>();
this.cs = Document.Instance.GetSheet(mapName);
if (this.cs == null)
{
return(list);
}
DataRow[] drs = this.cs.Data.Select();
foreach (DataRow dr in drs)
{
ScenicSpot ss = new ScenicSpot();
ss.Id = dr["Id"].ToString();
ss.Name = dr["Name"].ToString();
ss.Summary = dr["Summary"].ToString();
ss.AudioUrl = dr["AudioUrl"].ToString();
ss.AudioSegments = dr["AudioSegments"].ToString();
ss.PictureUrl = dr["PictureUrl"].ToString();
ss.StarLevel = dr["StarLevel"].ToString();
ss.Kind = dr["Kind"].ToString();
list.Add(ss);
}
return(list);
}
public Role FindroleById(string ROLE_NUM)
{
this.cs = Document.Instance.GetSheet("ROLE");
if (this.cs == null)
{
return(null);
}
Role ss = new Role();
DataRow[] drs = this.cs.Data.Select("ROLE_NUM='" + ROLE_NUM + "'");
if (drs.Length > 0)
{
DataRow dr = drs[0];
ss.ROLE_NUM = dr["ROLE_NUM"].ToString();
ss.NAME = dr["NAME"].ToString();
ss.LEVEL = int.Parse(dr["LEVEL"].ToString());
ss.HP = int.Parse(dr["HP"].ToString());
ss.HP_BASE = int.Parse(dr["HP_BASE"].ToString());
ss.HP_ADD = double.Parse(dr["HP_ADD"].ToString());
ss.ATK = int.Parse(dr["ATK"].ToString());
ss.ATK_BASE = int.Parse(dr["ATK_BASE"].ToString());
ss.ATK_ADD = double.Parse(dr["ATK_ADD"].ToString());
ss.SPD = int.Parse(dr["SPD"].ToString());
ss.ATK_JULI = int.Parse(dr["ATK_JULI"].ToString());
ss.JUMP = int.Parse(dr["JUMP"].ToString());
}
return(ss);
}
public List <ITEM> GetAll()
{
List <ITEM> list = new List <ITEM>();
this.cs = Document.Instance.GetSheet("ITEM");
if (this.cs == null)
{
return(list);
}
DataRow[] drs = this.cs.Data.Select();
foreach (DataRow dr in drs)
{
ITEM ss = new ITEM();
ss.NUM = dr["NUM"].ToString();
ss.NAME = dr["NAME"].ToString();
ss.DAZE_TIME = int.Parse(dr["DAZE_TIME"].ToString());
ss.POISON_TIME = int.Parse(dr["POISON_TIME"].ToString());
ss.POISON_DAM = double.Parse(dr["POISON_DAM"].ToString());
ss.FREEZE_TIME = int.Parse(dr["FREEZE_TIME"].ToString());
ss.DAMAGE_PCT = int.Parse(dr["DAMAGE_PCT"].ToString());
ss.TELEPORT = int.Parse(dr["TELEPORT"].ToString());
ss.TARGET = int.Parse(dr["TARGET"].ToString());
ss.USE_REP = bool.Parse(dr["USE_REP"].ToString());
ss.CD = int.Parse(dr["CD"].ToString());
ss.LV_UP = int.Parse(dr["LV_UP"].ToString());
ss.LV_DOWN = int.Parse(dr["LV_DOWN"].ToString());
list.Add(ss);
}
return(list);
}
public Player FindById(string PLAY_NUM)
{
this.cs = Document.Instance.GetSheet("ROLE");
this.cs2 = Document.Instance.GetSheet("PLAYER");
if (this.cs == null)
{
return(null);
}
if (this.cs2 == null)
{
return(null);
}
Player ss = new Player();
DataRow[] drs = this.cs.Data.Select("ROLE_NUM='" + PLAY_NUM + "'");
DataRow[] drs2 = this.cs2.Data.Select("PLAYER_NUM='" + PLAY_NUM + "'");
if (drs.Length > 0 && drs2.Length > 0)
{
DataRow dr = drs[0];
DataRow dr2 = drs2[0];
ss.PLAY_NUM = int.Parse(dr2["PLAYER_NUM"].ToString());
ss.NAME = dr["NAME"].ToString();
ss.LEVEL = int.Parse(dr["LEVEL"].ToString());
ss.HP = int.Parse(dr["HP"].ToString());
ss.HP_BASE = int.Parse(dr["HP_BASE"].ToString());
ss.HP_ADD = double.Parse(dr["HP_ADD"].ToString());
ss.ATK = int.Parse(dr["ATK"].ToString());
ss.ATK_BASE = int.Parse(dr["ATK_BASE"].ToString());
ss.ATK_ADD = double.Parse(dr["ATK_ADD"].ToString());
ss.SPD = int.Parse(dr["SPD"].ToString());
ss.ATK_JULI = int.Parse(dr["ATK_JULI"].ToString());
ss.JUMP = int.Parse(dr["JUMP"].ToString());
}
return(ss);
}
public Skill FindById(string SKILL_NUM)
{
this.cs = Document.Instance.GetSheet("SKILL");
if (this.cs == null)
{
return(null);
}
Skill ss = new Skill();
DataRow[] drs = this.cs.Data.Select("SKILL_NUM='" + SKILL_NUM + "'");
if (drs.Length > 0)
{
DataRow dr = drs[0];
ss.SKILL_NUM = int.Parse(dr["SKILL_NUM"].ToString());
ss.PLAYER_NUM = int.Parse(dr["PLAYER_NUM"].ToString());
ss.LEVEL = int.Parse(dr["LEVEL"].ToString());
ss.DIST = int.Parse(dr["DIST"].ToString());
ss.SCOPE = int.Parse(dr["SCOPE"].ToString());
ss.CD = double.Parse(dr["CD"].ToString());
ss.DAMAGE_PCT = double.Parse(dr["DAMAGE_PCT"].ToString());
ss.HPR_PCT = double.Parse(dr["HPR_PCT"].ToString());
ss.HPX_PCT = double.Parse(dr["HPX_PCT"].ToString());
ss.HPX_TIME = int.Parse(dr["HPX_TIME"].ToString());
ss.DEBUFF_DEL = bool.Parse(dr["DEBUFF_DEF"].ToString());
}
return(ss);
}
public Boss FindById(string BOSS_NUM)
{
this.cs = Document.Instance.GetSheet("BOSS");
if (this.cs == null)
{
return(null);
}
Boss ss = new Boss();
DataRow[] drs = this.cs.Data.Select("BOSS_NUM='" + BOSS_NUM + "'");
if (drs.Length > 0)
{
DataRow dr = drs[0];
ss.BOSS_NUM = int.Parse(dr["BOSS_NUM"].ToString());
ss.NAME = dr["NAME"].ToString();
ss.LEVEL = int.Parse(dr["LEVEL"].ToString());
ss.HP = int.Parse(dr["HP"].ToString());
ss.HP_BASE = int.Parse(dr["HP_BASE"].ToString());
ss.HP_ADD = double.Parse(dr["HP_ADD"].ToString());
ss.ATK = int.Parse(dr["ATK"].ToString());
ss.ATK_BASE = int.Parse(dr["ATK_BASE"].ToString());
ss.ATK_ADD = double.Parse(dr["ATK_ADD"].ToString());
ss.SPD = int.Parse(dr["SPD"].ToString());
ss.ATK_JULI = int.Parse(dr["ATK_JULI"].ToString());
ss.JUMP = int.Parse(dr["JUMO"].ToString());
ss.GOLD = int.Parse(dr["GOLD"].ToString());
ss.MOVE_RULE = int.Parse(dr["MOVE_RULE"].ToString());
ss.ITEM_NUM = int.Parse(dr["ITEM_NUM"].ToString());
}
return(ss);
}
public List <BUFF> GetAll()
{
List <BUFF> list = new List <BUFF>();
this.cs = Document.Instance.GetSheet("BUFF");
if (this.cs == null)
{
return(list);
}
DataRow[] drs = this.cs.Data.Select();
foreach (DataRow dr in drs)
{
BUFF ss = new BUFF();
ss.NUM = dr["NUM"].ToString();
ss.NAME = dr["NAME"].ToString();
ss.LEVEL = int.Parse(dr["LEVEL"].ToString());
ss.ATK_UP = double.Parse(dr["ATK_UP"].ToString());
ss.SPD_UP = double.Parse(dr["SPD_UP"].ToString());
ss.DEF_UP = double.Parse(dr["DEF_UP"].ToString());
ss.HPR_PCT = double.Parse(dr["HRP_PCT"].ToString());
ss.CS_PCT = double.Parse(dr["CS_PCT"].ToString());
ss.QG = bool.Parse(dr["QG"].ToString());
ss.TIME = int.Parse(dr["TIME"].ToString());
ss.BBACK_DIST = int.Parse(dr["BBACK_DIST"].ToString());
ss.TRIGGER_TIME = int.Parse(dr["TRIGGER_TIME"].ToString());
ss.TRIGGER_PCT = double.Parse(dr["TRIGGER_PCT"].ToString());
ss.FREEZE_TIME = int.Parse(dr["FREEZE_TIME"].ToString());
ss.POISON_TIME = int.Parse(dr["POISON_TIME"].ToString());
ss.POISON_DAM = double.Parse(dr["POISON_DAM"].ToString());
ss.DAZE_TIME = int.Parse(dr["DAZE_TIME"].ToString());
ss.CD_DOWN = double.Parse(dr["CD_DOWN"].ToString());
ss.DEAD = bool.Parse(dr["DEAD"].ToString());
ss.CHUNGE = bool.Parse(dr["CHUNGE"].ToString());
ss.ARMOR = double.Parse(dr["ARMOR"].ToString());
ss.JUMP_UP = int.Parse(dr["JUMP_UP"].ToString());
ss.LV = dr["LV"].ToString();
list.Add(ss);
}
return(list);
}
public BUFF FindById(string id)
{
this.cs = Document.Instance.GetSheet("BUFF");
if (this.cs == null)
{
return(null);
}
BUFF ss = new BUFF();
DataRow[] drs = this.cs.Data.Select("NUM='" + id + "'");
if (drs.Length > 0)
{
DataRow dr = drs[0];
ss.NUM = dr["NUM"].ToString();
ss.NAME = dr["NAME"].ToString();
ss.LEVEL = int.Parse(dr["LEVEL"].ToString());
ss.ATK_UP = double.Parse(dr["ATK_UP"].ToString());
ss.SPD_UP = double.Parse(dr["SPD_UP"].ToString());
ss.DEF_UP = double.Parse(dr["DEF_UP"].ToString());
ss.HPR_PCT = double.Parse(dr["HRP_PCT"].ToString());
ss.CS_PCT = double.Parse(dr["CS_PCT"].ToString());
ss.QG = bool.Parse(dr["QG"].ToString());
ss.TIME = int.Parse(dr["TIME"].ToString());
ss.BBACK_DIST = int.Parse(dr["BBACK_DIST"].ToString());
ss.TRIGGER_TIME = int.Parse(dr["TRIGGER_TIME"].ToString());
ss.TRIGGER_PCT = double.Parse(dr["TRIGGER_PCT"].ToString());
ss.FREEZE_TIME = int.Parse(dr["FREEZE_TIME"].ToString());
ss.POISON_TIME = int.Parse(dr["POISON_TIME"].ToString());
ss.POISON_DAM = int.Parse(dr["POISON_DAM"].ToString());
ss.DAZE_TIME = int.Parse(dr["DAZE_TIME"].ToString());
ss.CD_DOWN = double.Parse(dr["CD_DOWN"].ToString());
ss.DEAD = bool.Parse(dr["DEAD"].ToString());
ss.CHUNGE = bool.Parse(dr["CHUNGE"].ToString());
ss.ARMOR = int.Parse(dr["ARMOR"].ToString());
ss.JUMP_UP = int.Parse(dr["JUMP_UP"].ToString());
ss.LV = dr["LV"].ToString();
}
return(ss);
}
public TIGER_ITEM FindById(string id1, string id2)
{
this.cs = Document.Instance.GetSheet("TIGER_ITEM");
if (this.cs == null)
{
return(null);
}
TIGER_ITEM ss = new TIGER_ITEM();
DataRow[] drs = this.cs.Data.Select("TIGER_NUM='" + id1 + "'and ITEM_NUM='" + id2 + "'");
if (drs.Length > 0)
{
DataRow dr = drs[0];
ss.TIGER_NUM = dr["TIGER_NUM"].ToString();
ss.ITEM_NUM = dr["ITEM_NUM"].ToString();
ss.PCT = double.Parse(dr["PCT"].ToString());
}
return(ss);
}
public TIGER_MACHINE FindById(string id)
{
this.cs = Document.Instance.GetSheet("TIGER_MACHINE");
if (this.cs == null)
{
return(null);
}
TIGER_MACHINE ss = new TIGER_MACHINE();
DataRow[] drs = this.cs.Data.Select("NUM='" + id + "'");
if (drs.Length > 0)
{
DataRow dr = drs[0];
ss.NUM = dr["NUM"].ToString();
ss.GOLD = int.Parse(dr["GOLD"].ToString());
ss.HP = double.Parse(dr["HP"].ToString());
ss.NULL_PCT = double.Parse(dr["NULL_PCT"].ToString());
}
return(ss);
}
public List <TIGER_ITEM> GetAll()
{
List <TIGER_ITEM> list = new List <TIGER_ITEM>();
this.cs = Document.Instance.GetSheet("TIGER_ITEM");
if (this.cs == null)
{
return(list);
}
DataRow[] drs = this.cs.Data.Select();
foreach (DataRow dr in drs)
{
TIGER_ITEM ss = new TIGER_ITEM();
ss.TIGER_NUM = dr["TIGER_NUM"].ToString();
ss.ITEM_NUM = dr["ITEM_NUM"].ToString();
ss.PCT = double.Parse(dr["PCT"].ToString());
list.Add(ss);
}
return(list);
}
public List <string> GetAllKinds(string mapName)
{
List <string> list = new List <string>();
this.cs = Document.Instance.GetSheet(mapName);
if (this.cs == null)
{
return(list);
}
string others = "";
DataRow[] drs = this.cs.Data.Select();
foreach (DataRow dr in drs)
{
string tmp = dr["Kind"].ToString();
int index = list.BinarySearch(tmp);
if (index < 0)
{
if (tmp == "QT" || tmp == "Others")
{
others = tmp;
}
else
{
list.Insert(~index, tmp);
}
}
}
if (others != "")
{
list.Add(others);
}
return(list);
}
public List <TIGER_MACHINE> GetAll()
{
List <TIGER_MACHINE> list = new List <TIGER_MACHINE>();
this.cs = Document.Instance.GetSheet("TIGER_MACHINE");
if (this.cs == null)
{
return(list);
}
DataRow[] drs = this.cs.Data.Select();
foreach (DataRow dr in drs)
{
TIGER_MACHINE ss = new TIGER_MACHINE();
ss.NUM = dr["NUM"].ToString();
ss.GOLD = int.Parse(dr["GOLD"].ToString());
ss.HP = double.Parse(dr["HP"].ToString());
ss.NULL_PCT = double.Parse(dr["NULL_PCT"].ToString());
list.Add(ss);
}
return(list);
}
