public ST_S_PlayerWeaponRec[] GetList_weapon_all_where_idx(int a_idx) { if (_db == null) { _db = new SQLiteDB(); } // ST_S_PlayerWeaponRec rec; List <ST_S_PlayerWeaponRec> rtnlist = new List <ST_S_PlayerWeaponRec>(); string filename = GetFileName_DB(); try { _db.Open(filename); SQLiteQuery qr; string strsql = string.Format(_querySelect_all_where_idx, a_idx); // qr = new SQLiteQuery(_db, strsql); while (qr.Step()) { ST_S_PlayerWeaponRec rec = new ST_S_PlayerWeaponRec(); // idx, hero_ix, slot_no, weapon_datacode, up_level, up_dur, up_attack, up_critical_ratio rec.idx = qr.GetInteger("idx"); rec.hero_ix = qr.GetInteger("hero_ix"); rec.slot_no = qr.GetInteger("slot_no"); rec.weapon_datacode = qr.GetString("weapon_datacode"); rec.up_level = qr.GetInteger("up_level"); rec.up_dur = qr.GetInteger("up_dur"); rec.up_attack = qr.GetInteger("up_attack"); rec.up_critical_ratio = (float)qr.GetDouble("up_critical_ratio"); rec.upgrade_limit = qr.GetInteger("upgrade_limit"); rec.up_attack_speed = (float)qr.GetDouble("up_attack_speed"); rec.class_no = qr.GetInteger("class_no"); rec.count = qr.GetInteger("count"); rtnlist.Add(rec); } qr.Release(); _db.Close(); } catch (Exception e) { if (_db != null) { _db.Close(); } UnityEngine.Debug.LogError(e.ToString()); } return(rtnlist.ToArray()); }
public void Update_all_where_idx( int a_idx, ST_S_PlayerWeaponRec rec ) { if (_db == null) { _db = new SQLiteDB(); } try { _db.Open(GetFileName_DB()); SQLiteQuery qr; string strsql = string.Format(_queryUpdate_all_where_idx, a_idx); // qr = new SQLiteQuery(_db, strsql); qr.Bind(rec.slot_no); qr.Bind(rec.weapon_datacode); qr.Bind(rec.up_level); qr.Bind(rec.up_dur); qr.Bind(rec.up_attack); qr.Bind(rec.up_critical_ratio); qr.Bind(rec.upgrade_limit); qr.Bind(rec.up_attack_speed); qr.Bind(rec.class_no); qr.Bind(rec.count); qr.Step(); qr.Release(); _db.Close(); } catch (Exception e) { if (_db != null) { _db.Close(); } UnityEngine.Debug.LogError(e.ToString()); } return; }