private void Window_KeyUp(object sender, KeyEventArgs e)
{
if (e.Key==Key.F5)
{
using (ShujukuDataContext shujuku=new ShujukuDataContext())
{
tabsUI.SelectedIndex = 0;
var biaos = shujuku.ExecuteQuery<Biaos>(
@"SELECT a.name biaoming, b.rows xintiaoshu FROM sysobjects a WITH(NOLOCK)
JOIN sysindexes b WITH(NOLOCK) ON b.id = a.id WHERE a.xtype = 'U ' AND b.indid IN (0, 1)
ORDER By a.name ASC");
if (shujuyuan_biaos==null)
{
shujuyuan_biaos = biaos.ToList();
}
else
{
foreach (var biao in biaos)
{
shujuyuan_biaos.Where(z => z.biaoming.Equals(biao.biaoming)).Single().xintiaoshu = biao.xintiaoshu;
}
}
var ls = shujuyuan_biaos;
shujuyuan_biaos = null;
shujuyuan_biaos = ls;
}
}
}
private void biaos_dataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
var dg = sender as DataGrid;
var xuandehang = dg.SelectedItem as Biaos;
if (dg!=null && dg.SelectedIndex!=-1 && xuandehang.bianhua>0)
{
using (ShujukuDataContext shujuku = new ShujukuDataContext())
{
Type t = Assembly.Load("Jiance").GetType("Jiance."+xuandehang.biaoming);
Console.WriteLine(@"select top " + xuandehang.bianhua + " * from " + xuandehang.biaoming + "order by id desc");
var ls = shujuku.ExecuteQuery(t, @"select top "+xuandehang.bianhua+" * from " + xuandehang.biaoming+" order by id desc");
xiangxiUI.ItemsSource = null;
xiangxiUI.ItemsSource = ls;
}
}
}