wpf笔记
button动态弹出ContextMenu上下文菜单
http://www.cnblogs.com/lyghost/archive/2012/11/02/2751584.html
http://wenwen.soso.com/z/q221186332.htm
http://blog.sina.com.cn/s/blog_3e653ee60100ne19.html
http://www.cnblogs.com/chengxingliang/archive/2011/02/14/1954399.html
-------------------------------------------------------------------------------------------------------------------------------------
环境变量： 一边程序在下次启动的时候 可以读取上次启动的时候的配置项。（这样就可以避免使用ini，xml的配置文件了）
IDictionary environment = Environment.GetEnvironmentVariables(EnvironmentVariableTarget.User);
Environment.SetEnvironmentVariable("PMB_CONNSTRS", conns, EnvironmentVariableTarget.Machine);
-------------------------------------------------------------------------------------------------------------------------------------
http://zhidao.baidu.com/question/124595286.html
ComboBox Editing, Sorting, Grouping ListView
http://www.codeproject.com/Articles/29516/ComboBox-Editing-Sorting-Grouping-ListView
下面这套组件 要收费，不过可以对xlsx 进行导入到一个空间中并显示等等功能：ComponentOne Studio for WPF。
EPPlus这个工具是免费的，可以对xlsx进行读取，不需要额外的组件。
--------------------------------------------------------------listview动态绑定列，添加，删除行，滚动到最后一行
http://zhidao.baidu.com/question/124595286.html
http://www.cnblogs.com/whalechen/archive/2010/01/25/1655685.html
http://tech.ddvip.com/2009-02/1234417341108422.html
<Window x:Class="XLSX_Report.Window1"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" WindowStartupLocation="CenterScreen"
Title="XLSX_Report" Width="800" Height="850"
xmlns:lx="clr-namespace:XLSX_Report">
<!--<Window.Resources>
<lx:xlsx x:Key="xlsx"/>
</Window.Resources>-->
<Grid>
<Grid.RowDefinitions>
<RowDefinition Height="700"/>
<RowDefinition Height="100"/>
</Grid.RowDefinitions>
<ListView Grid.Row="0" Name="BscAndMscListView" IsSynchronizedWithCurrentItem="True" ItemsSource="{Binding}" >
<ListView.View>
<GridView AllowsColumnReorder="True">
<GridViewColumn Header="Operate">
<GridViewColumn.CellTemplate>
<DataTemplate>
<Button Content="Delete" Tag="{Binding}" Click="Btn_Delete_Click" />
</DataTemplate>
</GridViewColumn.CellTemplate>
</GridViewColumn>
</GridView>
</ListView.View>
</ListView>
<StackPanel Grid.Row="1" Orientation="Horizontal">
<Button Width="200" Content="Add some" Click="Btn_Add_Click" HorizontalAlignment="Center"/>
<Button Width="200" Content="Apply" Click="Btn_Add_Click" HorizontalAlignment="Center"/>
</StackPanel>
</Grid>
</Window>using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data;
using System.IO;
using OfficeOpenXml;
namespace XLSX_Report
{
/// <summary>
/// Window1.xaml 的交互逻辑
/// </summary>
public partial class Window1 : Window
{
static DataTable resultTable = null;
public Window1()
{
InitializeComponent();
GridView tempGridView = (GridView)this.BscAndMscListView.View;
//xlsx xls = (xlsx)this.Resources["xlsx"];
FileStream ffss = new FileStream("POI类型--属性对应配置表_For830.xlsx", FileMode.Open);
resultTable = xlsx.ReadByExcelLibrary(ffss);
ffss.Close();
//删除第一行文字标题列
//resultTable.Rows.RemoveAt(0);
for (int i = 0; i < resultTable.Rows.Count; )
{
DataRow dr = resultTable.Rows[i];
string s = Convert.ToString(dr[5]).Trim();
if (s.Equals(""))
{
resultTable.Rows.RemoveAt(i);
}
else
{
i++;
}
}
for (int i = 0; i < resultTable.Columns.Count; i++ )
{
//这些不显示
if (i>0 && i != 5 && i < 12) continue;
DataColumn col = resultTable.Columns[i];
/******************************************/
GridViewColumn column = new GridViewColumn();
GridViewColumnHeader h = new GridViewColumnHeader();
h.Content = col.ColumnName;
h.Tag = "*******";
column.Header = h;
DataTemplate dt = new DataTemplate();
FrameworkElementFactory fef = new FrameworkElementFactory(typeof(TextBox));
Binding binding = new Binding();
binding.Path = new PropertyPath(col.ColumnName);
fef.SetBinding(TextBox.TextProperty, binding);
fef.SetValue(TextBox.BackgroundProperty, Brushes.AliceBlue);
//fef.SetValue(TextBox.WidthProperty,20.0);
dt.VisualTree = fef;
column.CellTemplate = dt;
tempGridView.Columns.Add(column);
/******************************************/
}
this.BscAndMscListView.DataContext = resultTable;
}
private void Btn_Delete_Click(object sender, RoutedEventArgs e)
{
DataRowView drv = (sender as Button).DataContext as DataRowView;
DataRow dr = drv.Row;
resultTable.Rows.Remove(dr);
}
private void Btn_Add_Click(object sender, RoutedEventArgs e)
{
DataRow dr = resultTable.NewRow();
resultTable.Rows.Add();
int lastLine = BscAndMscListView.Items.Count - 1;
//跑到最后一行中
BscAndMscListView.ScrollIntoView(BscAndMscListView.Items[lastLine]);
//设定选中行
BscAndMscListView.SelectedItem = BscAndMscListView.Items[lastLine];
}
}
public class xlsx : DataTable//System.Collections.ObjectModel.ObservableCollection<DataRow>
{
public static DataTable ReadByExcelLibrary(Stream xlsStream)
{
DataTable table = new DataTable();
using (ExcelPackage package = new ExcelPackage(xlsStream))
{
//ExcelWorksheet sheet = package.Workbook.Worksheets[1];
ExcelWorksheet sheet=null;
foreach (ExcelWorksheet sht in package.Workbook.Worksheets)
{
string sheetname = sht.Name.Trim();
if (sheetname.Equals("POI类型-属性配置表", StringComparison.CurrentCultureIgnoreCase))
{
sheet = sht;
break;
}
}
int colCount = sheet.Dimension.End.Column;
int rowCount = sheet.Dimension.End.Row;
for (ushort j = 1; j <= colCount; j++)
{
if (sheet.Cells[1, j].Value != null)
{
table.Columns.Add(new DataColumn(sheet.Cells[1, j].Value.ToString()));
}
else
{
table.Columns.Add("");
}
}
for (ushort i = 1; i <= rowCount; i++)
{
DataRow row = table.NewRow();
for (ushort j = 1; j <= colCount; j++)
{
if (sheet.Cells[i, j].Value != null)
{
row[j - 1] = sheet.Cells[i, j].Value;
}
else
{
row[j - 1] = "";
}
}
table.Rows.Add(row);
}
}
return table;
}
}
}
----------------------------------绑定IsEnabled属性
<DockPanel>
<RadioButton Name="rbtn1" IsChecked="True" GroupName="group1"></RadioButton>
<TextBox Height="50" IsEnabled="{Binding ElementName=rbtn1, Path=IsChecked}"
Background="AliceBlue" AcceptsReturn="True">输入XLSX全路径</TextBox>
</DockPanel>
