public Data() { InitializeComponent(); InitDataTypeTable(); InitDataInfTable(); DataTypeTable.DataTableSelect("select * from Types", "更新"); InfType.Content = infnum.InfTotalSet("Types"); DataInfTable.DataTableSelect("select * from ArmsData", "更新"); Inf.Content = infnum.InfTotalSet("ArmsData"); InitRightBm(); }
private void InitDataInfTable() { DataInfTable.InitTableHeightWidth(420, 518); DataInfTable.SetCanUserAddRows(false); DataInfTable.AddColumns("DataNo", "资料编号", 100); DataInfTable.AddColumns("DataName", "资料名称", 100); DataInfTable.AddColumns("TypeId", "分类编号", 100); DataInfTable.AddColumns("ICount", "数量", 50); DataInfTable.AddColumns("IPrice", "价格", 50); DataInfTable.AddColumns("Memo", "创建日期", 100); }
public void DataInfEventContent(object sender, RoutedEventArgs e) { DaInmoinf = new MoreInf(); string[] Table_Str = { "DataNo", "DataName", "TypeId", "ICount", "IPrice", "Memo", "GreateDate" }; if (DataInfTable.dataGrid.SelectedIndex != -1) { DaInmoinf.SetValues(DataInfTable.Getdt(), DataInfTable.dataGrid.SelectedIndex, DataInfTable.Rows, Table_Str, DataInfStr, 7); DaInmoinf.Show(); } else { MessageBox.Show("当前未选中任何行!"); } }
public void InitRightBm() { MenuItem DataTypeMenu = DataTypeTable.AddMenuItem("更多信息"); MenuItem DataInfMenu = DataInfTable.AddMenuItem("更多信息"); MenuItem DeletRowMenu1 = DataTypeTable.AddMenuItem("删除选中的行"); MenuItem DeletRowMenu2 = DataInfTable.AddMenuItem("删除选中的行"); DataTypeMenu.Click += DataTypeEventContent; DataInfMenu.Click += DataInfEventContent; DeletRowMenu1.Click += DeletRows1; DeletRowMenu2.Click += DeletRows2; DataTypeTable.dgMenu.Items.Add(DataTypeMenu); DataTypeTable.dgMenu.Items.Add(DeletRowMenu1); DataInfTable.dgMenu.Items.Add(DataInfMenu); DataInfTable.dgMenu.Items.Add(DeletRowMenu2); }
private void DataInfExport_Click(object sender, RoutedEventArgs e) { DataInfTable.ExportExcel("select * from ArmsData", DataInfStr, "资料信息表格.xlsx"); }