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