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