/// <summary>
/// 在应用程序由最终用户正常启动时进行调用。
/// 将在启动应用程序以打开特定文件等情况下使用。
/// </summary>
/// <param name="e">有关启动请求和过程的详细信息。</param>
///
public async static void change_tile(module.module m)
{
XmlDocument xd = await XmlDocument.LoadFromFileAsync(await StorageFile.GetFileFromApplicationUriAsync(new Uri("ms-appx:///tile.xml")));
string xd1 = xd.GetXml().Replace("title", m.title).Replace("details", m.detail);
XmlDocument xd2 = new XmlDocument();
xd2.LoadXml(xd1);
TileNotification tn = new TileNotification(xd2);
TileUpdateManager.CreateTileUpdaterForApplication().Update(tn);
}
private void serch_Click(object sender, RoutedEventArgs e)
{
//using (var statement = App.conn.Prepare("SELECT Id, Title, Detail, Date FROM Item WHERE Title LIKE '%'+?+'%'"))
//{
// statement.Bind(1, seach_block.Text);
string sql_q = "SELECT Id, Title, Detail, Date FROM Item WHERE Id LIKE '%" + seach_block.Text + "%' OR Title LIKE '%" + seach_block.Text + "%' OR Detail LIKE '%" + seach_block.Text + "%' OR Date LIKE '%" + seach_block.Text + "%'";
using (var statement = App.conn.Prepare(sql_q))
{
//"SELECT Id, Title, Detail, Date FROM Item WHERE Id LIKE '%kk%' OR Title LIKE \'%?%\' OR Detail LIKE \'%?%\' OR Date LIKE \'%?%\'"
//statement.Bind(4, seach_block.Text);
//statement.Bind(1, seach_block.Text);
//statement.Bind(2, seach_block.Text);
//statement.Bind(3, seach_block.Text);
// '1996-01-01'
while (SQLiteResult.ROW == statement.Step())
{
var modu = new module.module();
modu.id = (string)statement[0];
modu.title = (string)statement[1];
modu.detail = (string)statement[2];
modu.date = DateTime.Parse((string)statement[3]);
search_items.Add(modu);
// // = new Customer()
// //{
// // Id = (long)statement[0],
// // Name = (string)statement[1],
// // City = (string)statement[2],
// // Contact = (string)statement[3]
// // };
}
}
string context = null;
for (int i = 0; i < search_items.Count; i++)
{
context += "id: " + Search_items[i].id + "; title: " + Search_items[i].title + "; detail: " + Search_items[i].detail + "; date: " + Search_items[i].date.ToString() + "\n";
}
if (context != null)
{
var massage = new MessageDialog(context).ShowAsync();
}
else
{
var message = new MessageDialog("null").ShowAsync();
}
}
