public EtcData GetEtcData(int itemCode)
{
EtcData foundData = null;
bool isSuccess = etcDatas.TryGetValue(itemCode, out foundData);
if (isSuccess)
{
return(foundData);
}
else
{
Debug.Log($"{itemCode}아이템을 찾을 수 없습니다.");
return(null);
}
}
public string LoadItemDB()
{
string weaponQuery = $"SELECT * FROM dbo.Weapon";
DataSet weaponDataset = ConnectDB_GetDataSet("Item_DB", weaponQuery);
if (weaponDataset == null)
{
return("Fail");
}
DataRowCollection weaponRow = weaponDataset.Tables[0].Rows;
for (int i = 0; i < weaponRow.Count; ++i)
{
object[] items = weaponRow[i].ItemArray;
string jsonSTR = items[1].ToString();
WeaponData newWeapon = JsonUtility.FromJson <WeaponData>(jsonSTR);
ItemDB.Instance.ContainWeaponData(newWeapon);
}
string expendableQuery = $"SELECT * FROM dbo.Expendable";
DataSet expendableDataset = ConnectDB_GetDataSet("Item_DB", expendableQuery);
if (expendableDataset == null)
{
return("Fail");
}
DataRowCollection expendableRow = expendableDataset.Tables[0].Rows;
for (int i = 0; i < expendableRow.Count; ++i)
{
object[] items = expendableRow[i].ItemArray;
string jsonSTR = items[1].ToString();
ExpendableData newExpendable = JsonUtility.FromJson <ExpendableData>(jsonSTR);
ItemDB.Instance.ContainExpandableData(newExpendable);
}
string accesorieQuery = $"SELECT * FROM dbo.Accesorie";
DataSet accesorieDataset = ConnectDB_GetDataSet("Item_DB", accesorieQuery);
if (accesorieDataset == null)
{
return("Fail");
}
DataRowCollection accesorieRow = accesorieDataset.Tables[0].Rows;
for (int i = 0; i < accesorieRow.Count; ++i)
{
object[] items = accesorieRow[i].ItemArray;
string jsonSTR = items[1].ToString();
AccesorieData newAccesorie = JsonUtility.FromJson <AccesorieData>(jsonSTR);
ItemDB.Instance.ContainAccesorieData(newAccesorie);
}
string etcQuery = $"SELECT * FROM dbo.Etc";
DataSet etcDataset = ConnectDB_GetDataSet("Item_DB", etcQuery);
if (etcDataset == null)
{
return("Fail");
}
DataRowCollection etcRow = etcDataset.Tables[0].Rows;
for (int i = 0; i < etcRow.Count; ++i)
{
object[] items = etcRow[i].ItemArray;
string jsonSTR = items[1].ToString();
EtcData newETC = JsonUtility.FromJson <EtcData>(jsonSTR);
ItemDB.Instance.ContainEtcData(newETC);
}
return("Success");
}
public void ContainEtcData(EtcData data)
{
etcDatas.Add(data.ItemCode, data);
}
