TestOperViewModel.cs 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445
  1. using AutoMapper;
  2. using BizService;
  3. using MiniExcelLibs;
  4. using Model.Dto;
  5. using Model.Entities;
  6. using NLog;
  7. using Prism.Commands;
  8. using Prism.Mvvm;
  9. using Prism.Services.Dialogs;
  10. using System;
  11. using System.Collections.Generic;
  12. using System.Collections.ObjectModel;
  13. using System.Linq;
  14. using System.Text;
  15. using System.Threading.Tasks;
  16. using System.Windows;
  17. namespace PLCTool.ViewModels.BusinessManageViewModel
  18. {
  19. public class TestOperViewModel : BindableBase
  20. {
  21. private readonly IDialogService _dialog;
  22. private readonly IOptionConfigService _optionConfigService;
  23. private readonly IBasicPlcTestSchemeService _basicPlcTestSchemeService;
  24. private readonly IBasicPlcTestSchemeDtlService _basicPlcTestSchemeDtlService;
  25. private readonly ILogger _logger;
  26. private readonly IMapper _mapper;
  27. private readonly IMenuService _menuService;
  28. private List<BasicPlcTestSchemeDto> allConfigList = new List<BasicPlcTestSchemeDto>();//所有方案
  29. private List<BasicPlcTestSchemeDto> conditionConfig = new List<BasicPlcTestSchemeDto>();//所有方案
  30. private const int PageCount = 1; //每一页显示个数
  31. public TestOperViewModel(IDialogService dialog, IMenuService menuService, IOptionConfigService optionConfigService, IBasicPlcTestSchemeService basicPlcTestSchemeService, IBasicPlcTestSchemeDtlService basicPlcTestSchemeDtlService, IMapper mapper)
  32. {
  33. _dialog = dialog;
  34. _optionConfigService = optionConfigService;
  35. _basicPlcTestSchemeService = basicPlcTestSchemeService;
  36. _basicPlcTestSchemeDtlService = basicPlcTestSchemeDtlService;
  37. //_logger = logger;
  38. _mapper = mapper;
  39. _menuService = menuService;
  40. QueryCommand = new DelegateCommand<object>(Query);
  41. ResetCommand = new DelegateCommand<object>(Reset);
  42. ExportCommand = new DelegateCommand<string>(Export);
  43. EditCommand = new DelegateCommand<object>(Edit);
  44. DeleteCommand = new DelegateCommand<object>(Delete);
  45. //手动 自动测试
  46. AutoTestCommand = new DelegateCommand<object>(AutoDest);
  47. ManualTestCommand = new DelegateCommand<object>(ManualTest);
  48. OnLoadCommand = new DelegateCommand(OnLoad);
  49. GetConfigOption();
  50. }
  51. #region 私有方法
  52. private void OnLoad()
  53. {
  54. GetContent();
  55. }
  56. private void ManualTest(object obj)
  57. {
  58. //测试方案明细主键ID
  59. long id = Convert.ToInt64(obj);
  60. DialogParameters parm = new DialogParameters();
  61. parm.Add("Key", id);
  62. //弹出详情对话框
  63. //弹出详情对话框
  64. _dialog.ShowDialog("ManualTestView", parm, async callback =>
  65. {
  66. if (callback.Result == ButtonResult.OK)
  67. {
  68. //更新表格,重新获取
  69. GetContent();
  70. }
  71. });
  72. }
  73. /// <summary>
  74. /// 自动测试
  75. /// </summary>
  76. /// <param name="obj"></param>
  77. private void AutoDest(object obj)
  78. {
  79. //测试方案明细主键ID
  80. long id = Convert.ToInt64(obj);
  81. DialogParameters parm = new DialogParameters();
  82. parm.Add("Key", id);
  83. //弹出详情对话框
  84. //弹出详情对话框
  85. _dialog.ShowDialog("AutoTestView",parm, async callback =>
  86. {
  87. if (callback.Result == ButtonResult.OK)
  88. {
  89. //更新表格,重新获取
  90. GetContent();
  91. }
  92. });
  93. }
  94. /// <summary>
  95. /// 重置
  96. /// </summary>
  97. /// <param name="obj"></param>
  98. private void Reset(object obj)
  99. {
  100. ScheduleName = string.Empty;
  101. DeviceName = string.Empty;
  102. TestName = string.Empty;
  103. SelectTest = string.Empty;
  104. }
  105. /// <summary>
  106. /// 查询
  107. /// </summary>
  108. /// <param name="obj"></param>
  109. private void Query(object obj)
  110. {
  111. if ((!string.IsNullOrEmpty(StartTime)) && (!string.IsNullOrEmpty(EndTime)))
  112. {
  113. if (Convert.ToDateTime(StartTime) > Convert.ToDateTime(EndTime))
  114. {
  115. MessageBox.Show("起始时间大于结束时间,请重新输入", "确认", MessageBoxButton.OK, MessageBoxImage.Warning);
  116. return;
  117. }
  118. if (Convert.ToDateTime(StartTime).AddDays(2) < Convert.ToDateTime(EndTime))
  119. {
  120. MessageBox.Show("起始时间和结束时间间隔不能大于2天,请重新输入", "确认", MessageBoxButton.OK, MessageBoxImage.Warning);
  121. return;
  122. }
  123. }
  124. conditionConfig = (from a in allConfigList
  125. where (EndTime == string.Empty ? true : (a.CreateTime < Convert.ToDateTime(EndTime)) && (Convert.ToDateTime(StartTime) < a.CreateTime))
  126. && (string.IsNullOrEmpty(ScheduleName) ? true : (a.SchemeName == ScheduleName))
  127. && (string.IsNullOrEmpty(TestName) ? true : (a.ItemName == TestName))
  128. && (string.IsNullOrEmpty(DeviceName) ? true : (a.DeviceName == DeviceName))
  129. && (string.IsNullOrEmpty(SelectTest) ? true : (a.ItemType == SelectTest))
  130. select a).ToList();
  131. //默认显示的第一页
  132. Getpage();
  133. //BaseConfigList = new ObservableCollection<BasicPlcTestSchemeDto>(conditionConfig);
  134. }
  135. /// <summary>
  136. /// 获取配置
  137. /// </summary>
  138. private void GetConfigOption()
  139. {
  140. var configList = _optionConfigService.QueryList();
  141. var _optionConfigs = _mapper.Map<List<OptionConfig>, List<OptionConfigDto>>(configList);
  142. var tests = _optionConfigs.FindAll(x => x.TypeID == 1);
  143. TestKinds = new List<string>();
  144. foreach (var test in tests)
  145. {
  146. TestKinds.Add(test.ContentOption);
  147. }
  148. }
  149. /// <summary>
  150. /// 编辑
  151. /// </summary>
  152. /// <param name="obj"></param>
  153. private void Edit(object obj)
  154. {
  155. //测试方案明细主键ID
  156. long id = Convert.ToInt64(obj);
  157. DialogParameters parm = new DialogParameters();
  158. parm.Add("Key", id);
  159. //弹出详情对话框
  160. _dialog.ShowDialog("AddOrEditSchView", parm, async callback =>
  161. {
  162. if (callback.Result == ButtonResult.OK)
  163. {
  164. //更新表格,重新获取
  165. GetContent();
  166. }
  167. });
  168. }
  169. /// <summary>
  170. /// 删除操作
  171. /// </summary>
  172. /// <param name="obj"></param>
  173. private void Delete(object obj)
  174. {
  175. int id = Convert.ToInt32(obj);
  176. MessageBoxResult boxResult = MessageBox.Show("确认删除此条数据?", "确认", MessageBoxButton.OKCancel, MessageBoxImage.Question);
  177. if (boxResult == MessageBoxResult.OK)
  178. {
  179. _basicPlcTestSchemeDtlService.Delete(id);
  180. //更新表格,重新获取
  181. GetContent();
  182. }
  183. }
  184. /// <summary>
  185. /// excel导出
  186. /// </summary>
  187. /// <param name="obj"></param>
  188. private void Export(object obj)
  189. {
  190. using (System.Windows.Forms.SaveFileDialog saveFileDialog = new System.Windows.Forms.SaveFileDialog()
  191. {
  192. //设置文件类型
  193. //书写规则例如:txt files(*.txt)|*.txt
  194. Filter = "Excel files(*.xlsx)|*.xlsx|All files(*.*)|*.*",
  195. //设置默认文件名(可以不设置)
  196. FileName = "配置导出",
  197. //获取或设置一个值,该值指示如果用户省略扩展名,文件对话框是否自动在文件名中添加扩展名。(可以不设置)
  198. AddExtension = true,
  199. //保存对话框是否记忆上次打开的目录
  200. RestoreDirectory = true
  201. })
  202. {
  203. // Show save file dialog box
  204. //点了保存按钮进入
  205. if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
  206. {
  207. try
  208. {
  209. //获得文件路径
  210. string localFilePath = saveFileDialog.FileName.ToString();
  211. //string filePathWithName = localFilePath + ".xlsx";
  212. //获取文件内容
  213. MiniExcel.SaveAs(localFilePath, BaseConfigList);
  214. }
  215. catch (Exception ex)
  216. {
  217. }
  218. }
  219. }
  220. }
  221. /// <summary>
  222. /// 获取解决方案
  223. /// </summary>
  224. private void GetContent()
  225. {
  226. //所有测试方案
  227. var schlist = _basicPlcTestSchemeService.QueryList();
  228. var configList = _mapper.Map<List<bas_plc_test_scheme>, List<BasicPlcTestSchemeDto>>(schlist);
  229. //清空集合
  230. BaseConfigList.Clear();
  231. allConfigList.Clear();
  232. conditionConfig.Clear();
  233. //查找测试项名称
  234. foreach (var sch in configList)
  235. {
  236. long schId = sch.SchemeId;
  237. //在解决方案详细表中查找所有的测试项
  238. var items = _basicPlcTestSchemeDtlService.FindAllBySchId(schId);
  239. foreach (var item in items)
  240. {
  241. BasicPlcTestSchemeDto basicPlcTestSchemeDto = new BasicPlcTestSchemeDto();
  242. basicPlcTestSchemeDto.SchemeId = item.scheme_dtl_id;
  243. basicPlcTestSchemeDto.SchemeName = sch.SchemeName;
  244. basicPlcTestSchemeDto.DeviceName = sch.DeviceName;
  245. switch (item.item_type)
  246. {
  247. case 0:
  248. basicPlcTestSchemeDto.ItemType = "前置项";
  249. break;
  250. case 1:
  251. basicPlcTestSchemeDto.ItemType = "PLC点位测试项";
  252. break;
  253. case 2:
  254. basicPlcTestSchemeDto.ItemType = "Robot动作测试";
  255. break;
  256. }
  257. basicPlcTestSchemeDto.ItemName = item.item_name;
  258. basicPlcTestSchemeDto.CreateBy = sch.CreateBy;
  259. basicPlcTestSchemeDto.CreateTime = sch.CreateTime;
  260. allConfigList.Add(basicPlcTestSchemeDto);
  261. conditionConfig.Add(basicPlcTestSchemeDto);
  262. }
  263. //默认显示的第一页
  264. Getpage();
  265. }
  266. }
  267. /// <summary>
  268. /// 获取页面
  269. /// </summary>
  270. private void Getpage()
  271. {
  272. CurrentPage = 1;
  273. TotalCount = conditionConfig.Count;
  274. CurrentPageChanged();
  275. }
  276. /// <summary>
  277. /// 页面变化
  278. /// </summary>
  279. private void CurrentPageChanged()
  280. {
  281. BaseConfigList.Clear();
  282. foreach (var i in conditionConfig.Skip((CurrentPage - 1) * CountPerPage).Take(CountPerPage))
  283. {
  284. BaseConfigList.Add(i);
  285. }
  286. }
  287. #endregion
  288. #region 命令绑定
  289. public DelegateCommand<object> EditCommand { set; get; }
  290. public DelegateCommand<string> AddPlanCommand { set; get; }
  291. public DelegateCommand<object> QueryCommand { set; get; }
  292. public DelegateCommand<object> ResetCommand { set; get; }
  293. public DelegateCommand<object> DeleteCommand { set; get; }
  294. public DelegateCommand<string> ExportCommand { set; get; }
  295. public DelegateCommand PageUpdatedCmd { set; get; }
  296. public DelegateCommand<object> AutoTestCommand { set; get; }
  297. public DelegateCommand<object> ManualTestCommand { set; get; }
  298. public DelegateCommand OnLoadCommand { set; get; }
  299. #endregion
  300. #region 数据绑定
  301. /// <summary>
  302. /// 测试方案编码
  303. /// </summary>
  304. private string scheduleName;
  305. public string ScheduleName
  306. {
  307. get { return scheduleName; }
  308. set { scheduleName = value; RaisePropertyChanged(); }
  309. }
  310. /// <summary>
  311. /// 设备名称
  312. /// </summary>
  313. private string deviceName;
  314. public string DeviceName
  315. {
  316. get { return deviceName; }
  317. set { deviceName = value; RaisePropertyChanged(); }
  318. }
  319. /// <summary>
  320. /// 测试项名称
  321. /// </summary>
  322. private string testName;
  323. public string TestName
  324. {
  325. get { return testName; }
  326. set { testName = value; RaisePropertyChanged(); }
  327. }
  328. /// <summary>
  329. /// 测试项类型
  330. /// </summary>
  331. private List<string> testKinds = new List<string>();
  332. public List<string> TestKinds
  333. {
  334. get { return testKinds; }
  335. set { testKinds = value; RaisePropertyChanged(); }
  336. }
  337. /// <summary>
  338. ///
  339. /// </summary>
  340. private string selectTest;
  341. public string SelectTest
  342. {
  343. get { return selectTest; }
  344. set { selectTest = value; RaisePropertyChanged(); }
  345. }
  346. private string startTime = string.Empty;
  347. public string StartTime
  348. {
  349. get { return startTime; }
  350. set { startTime = value; RaisePropertyChanged(); }
  351. }
  352. private string endTime = string.Empty;
  353. public string EndTime
  354. {
  355. get { return endTime; }
  356. set { endTime = value; RaisePropertyChanged(); }
  357. }
  358. /// <summary>
  359. /// 总条数
  360. /// </summary>
  361. private int totalCount;
  362. public int TotalCount
  363. {
  364. get { return totalCount; }
  365. set { totalCount = value; RaisePropertyChanged(); CurrentPageChanged(); }
  366. }
  367. /// <summary>
  368. /// 每页数量
  369. /// </summary>
  370. private int countPerPage = 10;
  371. public int CountPerPage
  372. {
  373. get { return countPerPage; }
  374. set { countPerPage = value; RaisePropertyChanged(); CurrentPageChanged(); }
  375. }
  376. /// <summary>
  377. /// 单前页
  378. /// </summary>
  379. private int currentPage = 1;
  380. public int CurrentPage
  381. {
  382. get { return currentPage; }
  383. set { currentPage = value; RaisePropertyChanged(); CurrentPageChanged(); }
  384. }
  385. private ObservableCollection<BasicPlcTestSchemeDto> baseConfigList = new ObservableCollection<BasicPlcTestSchemeDto>();
  386. public ObservableCollection<BasicPlcTestSchemeDto> BaseConfigList
  387. {
  388. get { return baseConfigList; }
  389. set { SetProperty(ref baseConfigList, value); }
  390. }
  391. #endregion
  392. }
  393. }