SystemConfigWorkflow.cs 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. using System;
  2. using System.Linq;
  3. using WCS_Client.Models;
  4. namespace WCS_Client.Workflow
  5. {
  6. public class SystemConfigWorkflow
  7. {
  8. /// <summary>
  9. /// 系统配置写入
  10. /// </summary>
  11. /// <param name="convNo">设备编号</param>
  12. /// <param name="isStop">是否启用</param>
  13. /// <returns></returns>
  14. /// <exception cref="Exception"></exception>
  15. public static string SystemConfigSet(string convNo, bool isStop)
  16. {
  17. string result = TryCachHelper.TryExecute((db) =>
  18. {
  19. //var srmoutinInfo = db.Queryable<WCS_SRMOUTININFO>().First(v => v.SRMOUTIN_CONVNO == convNo);
  20. var systemConfig = db.Queryable<WCS_SystemConfig>().First(v => v.DEVICECODE == convNo);
  21. if (systemConfig == null)
  22. {
  23. throw new Exception(string.Format("未查询到堆垛机出入口[{0}]信息", convNo));
  24. }
  25. else
  26. {
  27. if (db.Updateable<WCS_SystemConfig>()
  28. .UpdateColumns(it => new WCS_SystemConfig
  29. {
  30. ENABLED = isStop,
  31. UPDATETIME = DateTime.Now
  32. })
  33. .Where(v => v.DEVICECODE == convNo).ExecuteCommand() < 0)
  34. {
  35. throw new Exception(string.Format("堆垛机出入口[{0}]禁(启)用失败", convNo));
  36. }
  37. }
  38. });
  39. return result;
  40. }
  41. }
  42. }