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;
}
