锐腾搅拌上料功能
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

141 lines
3.5 KiB

5 months ago
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using ICSSoft.Frame.Data.Entity;
  6. using ICSSoft.Frame.Data.DAL;
  7. using System.Data;
  8. using ICSSoft.Frame.APP.Entity;
  9. namespace ICSSoft.Frame.Data.BLL
  10. {
  11. public class ICSEQPSTPBLL
  12. {
  13. #region 新增和修改
  14. public static void Add(ICSEQPSTP Info, string dsconn)
  15. {
  16. try
  17. {
  18. if (string.IsNullOrWhiteSpace(dsconn))
  19. {
  20. throw new Exception("数据库连接字符串错误");
  21. }
  22. List<ICSEQPSTP> InfoList = new List<ICSEQPSTP>() { Info };
  23. ICSEQPSTPDAL.Add(InfoList, dsconn);
  24. }
  25. catch (Exception ex)
  26. {
  27. throw ex;
  28. }
  29. }
  30. #endregion
  31. #region 新增和修改List
  32. public static string AddList(List<FormICSEQPSTPUIModelNew> InfoList, string dsconn)
  33. {
  34. try
  35. {
  36. if (string.IsNullOrWhiteSpace(dsconn))
  37. {
  38. throw new Exception("数据库连接字符串错误");
  39. }
  40. return ICSEQPSTPDAL.AddList(InfoList, dsconn);
  41. }
  42. catch (Exception ex)
  43. {
  44. throw ex;
  45. }
  46. }
  47. #endregion
  48. #region 通过ID查询
  49. public static DataTable searchInfoByID(string ID, string dsconn)
  50. {
  51. try
  52. {
  53. return ICSEQPSTPDAL.searchInfoByID(ID, dsconn);
  54. }
  55. catch (Exception ex)
  56. {
  57. throw ex;
  58. }
  59. }
  60. #endregion
  61. #region 是否存在
  62. public static bool IsIncluding(string ItemCode, string OPCode, string eqptype, string dsconn)
  63. {
  64. try
  65. {
  66. return ICSEQPSTPDAL.IsIncluding(ItemCode, OPCode, eqptype, dsconn);
  67. }
  68. catch (Exception ex)
  69. {
  70. throw ex;
  71. }
  72. }
  73. #endregion
  74. #region 删除
  75. public static void deleteInfo(List<string> codeList, string dsconn)
  76. {
  77. try
  78. {
  79. ICSEQPSTPDAL.deleteInfo(codeList, dsconn);
  80. }
  81. catch (Exception ex)
  82. {
  83. throw ex;
  84. }
  85. }
  86. #endregion
  87. #region 审核
  88. public static void checkInfo(List<string> codeList, string dsconn)
  89. {
  90. try
  91. {
  92. ICSEQPSTPDAL.checkInfo(codeList, dsconn);
  93. }
  94. catch (Exception ex)
  95. {
  96. throw ex;
  97. }
  98. }
  99. #endregion
  100. public static void Import(List<ICSEQPSTP> InfoList, string dsconn)
  101. {
  102. ICSEQPSTPDAL.Import(InfoList, dsconn);
  103. }
  104. public static DataTable GetEQ(string conn, string wp)
  105. {
  106. return ICSEQPSTPDAL.GetEQ(conn, wp);
  107. }
  108. public static DataTable GetFIXEQ(string conn, string wp)
  109. {
  110. return ICSEQPSTPDAL.GetFIXEQ(conn, wp);
  111. }
  112. public static DataTable GetINV(string conn, string wp)
  113. {
  114. return ICSEQPSTPDAL.GetINV(conn, wp);
  115. }
  116. public static void ImportFromErp(string conn, List<ITEM2ROUTE2OP2TIMEawt> list)
  117. {
  118. ICSEQPSTPDAL.ImportFromErp(conn, list);
  119. }
  120. public static DataTable GetBaseOP(string conn, string wp)
  121. {
  122. return ICSEQPSTPDAL.GetBaseOP(conn, wp);
  123. }
  124. }
  125. }