public void DeleteList(string _id) { try { for (int x = 0; x < allTodoItemLists.Count; x++) { if (allTodoItemLists[x].id == _id) { //先删除list里边所有的item deleteAllItemsFromId(_id); allTodoItemLists.RemoveAt(x); break; } } var db = App.myMidProject; using (var statement = db.Prepare("DELETE FROM List WHERE Id = ?")) { statement.Bind(1, _id); statement.Step(); } selectedTodoItemList = null; } catch (Exception ex) { var i = new MessageDialog(ex.ToString()).ShowAsync(); } }
public void loadAllItems() { var db = App.myMidProject; using (var statement = db.Prepare("SELECT Id, Name, Itemsid FROM List")) { while (SQLiteResult.ROW == statement.Step()) { if (statement.DataCount != 0) { var newitem = new Models.TodoItemList((string)statement[0], (string)statement[1], (string)statement[2]); allTodoItemLists.Add(newitem); getItemsFromId(newitem.id); } } } }
public void AddList(string _listName, string[] _itemsid) { var db = App.myMidProject; try { var tmp = new Models.TodoItemList(_listName, _itemsid); allTodoItemLists.Add(tmp); using (var statement = db.Prepare("INSERT INTO List (Id, Name, Itemsid) VALUES (?, ?, ?)")) { statement.Bind(1, tmp.id); statement.Bind(2, tmp.listName); statement.Bind(3, getAllItemId(tmp.id)); statement.Step(); } } catch (Exception ex) { var i = new MessageDialog(ex.ToString()).ShowAsync(); } }
//没有用这个函数 public void AddList(string _listName, Models.TodoItem[] _items) { var tmp = new Models.TodoItemList(_listName, _items); allTodoItemLists.Add(tmp); }