public PopupWindowAllEventsViewModel() { _realTableNameDict = new Dictionary <string, string>() { { "事件记录表", "awms_events_dhl" }, { "设备表", "awms_device_dhl" }, { "灯信息表", "awms_lights_dhl" }, { "灯任务表", "awms_lights_tasks_dhl" }, { "LPN表", "awms_lpn_dhl" }, { "订单表", "awms_orders_dhl" }, { "发货单表", "awms_orders_tasks_dhl" }, { "栈板表", "awms_pallets_dhl" }, { "原始数据表", "awms_source_dhl" }, { "库位表", "awms_storges_dhl" } }; TableNames = new ObservableCollection <string>(); foreach (var x in _realTableNameDict.Keys) { TableNames.Add(x); } SelectedTableName = TableNames[0]; PageSize = 50; ViewRefresh(); PageSizeChanged = new DelegateCommand(() => { if (PageSize <= 0) { MessageBox.Show("页数必须是大于0的整数", "错误"); return; } CurrentPage = 1; string tableName = _realTableNameDict[SelectedTableName]; TotalCount = DbHelper.GetTabelRecordCount(tableName); //AllEvents = DbHelper.GetDataByPage(tableName, CurrentPage, PageSize); if (null != AllEvents) { AllEvents.Dispose(); AllEvents = null; } AllEvents = DbHelper.GetAllFromTableByName(tableName); TotalPages = (TotalCount + PageSize - 1) / PageSize; }); ViewRefreshCommand = new DelegateCommand(ViewRefresh); }
void ViewRefresh() { if (PageSize <= 0) { return; } string tableName = _realTableNameDict[SelectedTableName]; TotalCount = DbHelper.GetTabelRecordCount(tableName); // AllEvents = DbHelper.GetDataByPage(tableName,CurrentPage, PageSize); if (null != AllEvents) { AllEvents.Dispose(); AllEvents = null; } AllEvents = DbHelper.GetAllFromTableByName(tableName); TotalPages = (TotalCount + PageSize - 1) / PageSize; }