using DyeingComputer.UserClass; using DyeingComputer.View; using DyeingComputer.ViewModel; using DyeingComputer.Windows; using System; using System.Collections.Generic; using System.Linq; using System.Net; using System.Text; using System.Threading.Tasks; 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 static DyeingComputer.UserClass.SqliteHelper; namespace DyeingComputer { /// /// MainWindow.xaml 的交互逻辑 /// public partial class MainWindow : Window { public MainWindow() { InitializeComponent(); SQLiteStrat(); DataContext = new MainWindowViewModel();//绑定后台 container.Content = new TechnologicalProcessView();//默认打开信息页面(TechnologicalProcessView) MainWindowViewModel.ViewID = 1; } public static SQLiteHelper SQLiteChartAdress = null; //定义数据库 public static SQLiteHelper SQLiteHelpers = null; //定义数据库 private readonly string ChartAdress = Environment.CurrentDirectory + "\\DataBase\\Chart.db"; //数据库路径 private readonly string DBAddress = Environment.CurrentDirectory + "\\DataBase\\800COMPUTER.db"; //数据库路径 /// /// 数据库检查读取 /// /// private bool SQLiteStrat() { SQLiteHelpers = new SQLiteHelper(DBAddress); //数据库连接路径 SQLiteHelpers.Open(); //打开数据库 SQLiteChartAdress = new SQLiteHelper(ChartAdress); //数据库连接路径 SQLiteChartAdress.Open(); //打开数据库 bool result_System = SQLiteHelpers.TableExists("System"); //检查表格是否存在(存在返回true) bool result_IOName = SQLiteHelpers.TableExists("IOName"); bool result_ProgramName = SQLiteHelpers.TableExists("ProgramName"); bool result_ProgramSteps = SQLiteHelpers.TableExists("ProgramSteps"); bool result_RUN = SQLiteHelpers.TableExists("RUN"); bool result_Dyelot = SQLiteHelpers.TableExists("Dyelot"); bool result_Parameters = SQLiteHelpers.TableExists("Parameters"); bool result_WorkOrder = SQLiteHelpers.TableExists("WorkOrder"); bool result_WorkorderSteps = SQLiteHelpers.TableExists("WorkorderSteps"); if (!result_System) LogGing.LogGingDATA("Master_System_Table_Loss"); if (!result_IOName) LogGing.LogGingDATA("Master_IOName_Table_Loss"); if (!result_ProgramName) LogGing.LogGingDATA("Master_ProgramName_Table_Loss"); if (!result_ProgramSteps) LogGing.LogGingDATA("Master_ProgramSteps_Table_Loss"); if (!result_RUN) LogGing.LogGingDATA("Master_RUN_Table_Loss"); if (!result_Dyelot) LogGing.LogGingDATA("Master_Dyelot_Table_Loss"); if (!result_Parameters) LogGing.LogGingDATA("Master_Parameters_Table_Loss"); if (!result_WorkOrder) LogGing.LogGingDATA("Master_WorkOrder_Table_Loss"); if (!result_WorkorderSteps) LogGing.LogGingDATA("Master_WorkorderSteps_Table_Loss"); if (!result_System || !result_IOName || !result_ProgramName || !result_ProgramSteps || !result_RUN || !result_Dyelot || !result_Parameters || !result_WorkOrder || !result_WorkorderSteps) { // SQLiteHelpers.Close(); MessageBox.Show(Properties.Resources.SysDatLoss); return true; } else { // SQLiteHelpers.Close(); return false; } } /// /// 工具栏状态 /// /// /// private void RadioButton_toolbar(object sender, RoutedEventArgs e) { if (!(sender is RadioButton button)) return; if (string.IsNullOrEmpty(button.Name.ToString())) return; switch (button.Name.ToString()) { case "Next": this.In_Out.Visibility = Visibility.Visible; this.Sys_Set.Visibility = Visibility.Visible; this.Parameter_Set.Visibility = Visibility.Visible; this.Program_group.Visibility = Visibility.Visible; this.Engineer_Set.Visibility = Visibility.Visible; this.Previous.Visibility = Visibility.Visible; this.Work_Order.Visibility = Visibility.Collapsed; this.Technological_Process.Visibility = Visibility.Collapsed; this.Curve_Diagram.Visibility = Visibility.Collapsed; this.Equipment_Simulation.Visibility = Visibility.Collapsed; this.History_Records.Visibility = Visibility.Collapsed; this.Next.Visibility = Visibility.Collapsed; break; case "Previous": this.In_Out.Visibility = Visibility.Collapsed; this.Sys_Set.Visibility = Visibility.Collapsed; this.Parameter_Set.Visibility = Visibility.Collapsed; this.Program_group.Visibility = Visibility.Collapsed; this.Engineer_Set.Visibility = Visibility.Collapsed; this.Previous.Visibility = Visibility.Collapsed; this.Work_Order.Visibility = Visibility.Visible; this.Technological_Process.Visibility = Visibility.Visible; this.Curve_Diagram.Visibility = Visibility.Visible; this.Equipment_Simulation.Visibility = Visibility.Visible; this.History_Records.Visibility = Visibility.Visible; this.Next.Visibility = Visibility.Visible; break; default: break; } } /// /// 功能页面 /// /// /// private void RadioButton_Page(object sender, RoutedEventArgs e) { if (!(sender is RadioButton button)) return; if (string.IsNullOrEmpty(button.Name.ToString())) return; switch (button.Name.ToString()) { case "Work_Order": container.Content = new WorkOrderView(); MainWindowViewModel.ViewID = 0; break; case "Technological_Process": container.Content = new TechnologicalProcessView(); MainWindowViewModel.ViewID = 1; break; case "Curve_Diagram": container.Content = new CurveDiagramView(); MainWindowViewModel.ViewID = 2; break; case "Equipment_Simulation": container.Content = new EquipmentSimulationView(); MainWindowViewModel.ViewID = 3; break; case "History_Records": container.Content = new HistoryRecordsView(); MainWindowViewModel.ViewID = 4; break; case "In_Out": container.Content = new InOutView(); MainWindowViewModel.ViewID = 5; break; case "Sys_Set": container.Content = new SysSetView(); MainWindowViewModel.ViewID = 6; break; case "Parameter_Set": container.Content = new ParameterSetView(); MainWindowViewModel.ViewID = 7; break; case "Program_group": container.Content = new ProgramgroupView(); MainWindowViewModel.ViewID = 8; break; case "Engineer_Set": container.Content = new EngineerSetView(); MainWindowViewModel.ViewID = 9; break; default: break; } } private void Image_MouseLeftButtonDown(object sender, MouseButtonEventArgs e) { ((Image)sender).RenderTransform = new ScaleTransform(0.9,0.9); } private void Image_MouseLeftButtonUp(object sender, MouseButtonEventArgs e) { ((Image)sender).RenderTransform = Transform.Identity; MainWindowViewModel.UserInfoStart = 901; MainWindowViewModel.UserInfo = Properties.Resources.Unlock; }//解锁 private void Image_MouseLeftButtonDown_1(object sender, MouseButtonEventArgs e) { ((Image)sender).RenderTransform = new ScaleTransform(0.9, 0.9); } private void Image_MouseLeftButtonUp_1(object sender, MouseButtonEventArgs e) { ((Image)sender).RenderTransform = Transform.Identity; MainWindowViewModel.UserInfoStart = 901; if (MainWindowViewModel._AUTO_bool) { MainWindowViewModel.UserInfo = Properties.Resources.Auto; } else { MainWindowViewModel.UserInfo = Properties.Resources.Manual; } }//手动 } }