using AutoMapper; using GalaSoft.MvvmLight; using GalaSoft.MvvmLight.Command; using GroupLine.App.View; using GroupLine.Com; using GroupLine.Model; using NLog; using System; using System.Linq; using System.Windows; namespace GroupLine.App.ViewModel { public class OffsetConfigViewModel : ViewModelBase { //日志的实例化 private static Logger _Logger = LogManager.GetCurrentClassLogger(); private string CurrentMachineName = "绝缘垫CCD"; private string CurrentMachineNameTemplate = "InsulationPadTemplate.xlsx"; private IMapper autoMapper; public OffsetConfigViewModel() { try { //获取程序的配置信息 var SqlCon = ConfigHelper.GetValue("connecting"); offsetConfig = FSqlContext.FDb.Select().OrderByDescending(a => a.CreateTime).ToList().FirstOrDefault(); if (offsetConfig != null) { AGroupOffsetCount = offsetConfig.AGroupOffsetCount; BGroupOffsetCount = offsetConfig.BGroupOffsetCount; CGroupOffsetCount = offsetConfig.CGroupOffsetCount; } } catch (Exception ex) { _Logger.Error(String.Format("ErrSource : {0} ErrMsg : {1}", ex.StackTrace.ToString(), ex.Message.ToString())); } } public OffsetConfig offsetConfig { set; get; } /// /// 前组 /// private int _AGroupOffsetCount; public int AGroupOffsetCount { get { return _AGroupOffsetCount; } set { _AGroupOffsetCount = value; RaisePropertyChanged(() => AGroupOffsetCount); } } /// /// 后组 /// private int _BGroupOffsetCount; public int BGroupOffsetCount { get { return _BGroupOffsetCount; } set { _BGroupOffsetCount = value; RaisePropertyChanged(() => BGroupOffsetCount); } } /// /// 完成 /// private int _CGroupOffsetCount; public int CGroupOffsetCount { get { return _CGroupOffsetCount; } set { _CGroupOffsetCount = value; RaisePropertyChanged(() => CGroupOffsetCount); } } #region 命令 /// /// 改为理论稼动率的设置了 /// private RelayCommand _OffsetCmd; public RelayCommand OffsetCmd { get { if (_OffsetCmd == null) return new RelayCommand(() => CycleTimeCmdAction()); return _OffsetCmd; } set { _OffsetCmd = value; } } /// /// 配置保存 /// private void CycleTimeCmdAction() { try { InputMsg = string.Empty; MsgInput frm = new MsgInput(); frm.Accept += Frm_Accept; frm.ShowDialog(); if (!string.IsNullOrEmpty(InputMsg)) { if (InputMsg == "admin123") { //ConfigHelper.SetValue("CycleTime", CycleTime.ToString()); var data = FSqlContext.FDb.Update() .Set(a => a.AGroupOffsetCount, AGroupOffsetCount) .Set(a => a.BGroupOffsetCount, BGroupOffsetCount) .Set(a => a.CGroupOffsetCount, CGroupOffsetCount) .Where(a => a.Id == 1) .ExecuteAffrows(); //var GetFirstData = FSqlContext.FDb.Select().OrderByDescending(a => a.CreateTime).ToList().FirstOrDefault(); //GetFirstData.AGroupOffsetCount = AGroupOffsetCount; //GetFirstData.BGroupOffsetCount = BGroupOffsetCount; //GetFirstData.CGroupOffsetCount = CGroupOffsetCount; //_OffsetConfigDataContext.SubmitChanges(); MessageBox.Show("修改成功数据", "提示", MessageBoxButton.OK, MessageBoxImage.Information); } else { MessageBox.Show("密码错误", "提示", MessageBoxButton.OK, MessageBoxImage.Information); } } else { MessageBox.Show("未发现输入数据", "提示", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception ex) { _Logger.Error(String.Format("ErrSource : {0} ErrMsg : {1}", ex.StackTrace.ToString(), ex.Message.ToString())); } } private string InputMsg { set; get; } private void Frm_Accept(object sender, EventArgs e) { var data = (MsgInput)sender; InputMsg = data.Box.Text; } #endregion } }