public DBItemController()
{
database =
DependencyService.Get <IDatabaseConnection>().
DbConnection();
this.Items =
new ObservableCollection <ItemDBModel>(database.Table <ItemDBModel>());
// If the table is empty, initialize the collection
if (!database.Table <ItemDBModel>().Any())
{
ItemDBModel c1 = new ItemDBModel {
Name = "Mjollnir", Desc = "Thor's very own hammer", Str = 10, Dex = 5
};
ItemDBModel c2 = new ItemDBModel {
Name = "Excalibur", Desc = "An ancient holy sword", Def = 10, Str = 5
};
ItemDBModel c3 = new ItemDBModel {
Name = "Muramasa", Desc = "A cursed Japanese blade", Def = -10, Dex = 15, Health = -5, Str = 15
};
ItemDBModel c4 = new ItemDBModel {
Name = "Odin's Shield", Desc = "The shield used to defend Asgard", Def = 10, Health = 5
};
SaveItem(c1);
SaveItem(c2);
SaveItem(c3);
SaveItem(c4);
}
}
async void DeleteItem(object sender, EventArgs args)
{
ItemDBModel Item = viewModel.GetItem();
itemview.DeleteItem(Item);
await Navigation.PopToRootAsync();
}
public int DeleteItem(ItemDBModel item)
{
var id = item.Id;
if (id != 0)
{
lock (collisionLock)
{
database.Delete <ItemDBModel>(id);
}
}
this.Items.Remove(item);
return(id);
}
/// <summary>
/// 加载表格
/// </summary>
public void LoadDataTable()
{
//每个表都 LoadData
ChapterDBModel.LoadData();
GameLevelDBModel.LoadData();
TaskDBModel.LoadData();
JobDBModel.LoadData();
JobLevelDBModel.LoadData();
ShopDBModel.LoadData();
EquipDBModel.LoadData();
ItemDBModel.LoadData();
MaterialDBModel.LoadData();
WorldMapDBModel.LoadData();
SkillDBModel.LoadData();
SkillLevelDBModel.LoadData();
}
public int SaveItem(ItemDBModel item)
{
lock (collisionLock)
{
if (item.Id != 0)
{
database.Update(item);
return(item.Id);
}
else
{
database.Insert(item);
return(item.Id);
}
}
}
/// <summary>
/// 初始化DBModel
/// </summary>
private void InitDBModel()
{
//每个表都new
ChapterDBModel = new ChapterDBModel();
GameLevelDBModel = new GameLevelDBModel();
TaskDBModel = new TaskDBModel();
JobDBModel = new JobDBModel();
JobLevelDBModel = new JobLevelDBModel();
ShopDBModel = new ShopDBModel();
EquipDBModel = new EquipDBModel();
ItemDBModel = new ItemDBModel();
MaterialDBModel = new MaterialDBModel();
WorldMapDBModel = new WorldMapDBModel();
SkillDBModel = new SkillDBModel();
SkillLevelDBModel = new SkillLevelDBModel();
}
async void UpdateItem(object sender, EventArgs args)
{
ItemDBModel Item = viewModel.GetItem();
await Navigation.PushAsync(new NewItemPage(Item));
}
public FileSelector()
{
InitializeComponent();
db = MainWindow.Database;
}
