锐腾搅拌上料功能
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.

89 lines
2.3 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. namespace ICSSoft.Frame.Data.BLL
  8. {
  9. public class ICSAQLBLL
  10. {
  11. #region 新增和修改
  12. public static void Add(FormICSAQLUIModel aqlInfo, string dsconn)
  13. {
  14. try
  15. {
  16. if (string.IsNullOrWhiteSpace(dsconn))
  17. {
  18. throw new Exception("数据库连接字符串错误");
  19. }
  20. List<FormICSAQLUIModel> aqlInfoList = new List<FormICSAQLUIModel>() { aqlInfo };
  21. ICSAQLDAL.Add(aqlInfoList, dsconn);
  22. }
  23. catch (Exception ex)
  24. {
  25. throw ex;
  26. }
  27. }
  28. #endregion
  29. #region 代码是否存在
  30. public static bool IsIncluding(int AQLSEQ, string AQLLEVEL,string workpoint, string dsconn)
  31. {
  32. try
  33. {
  34. return ICSAQLDAL.IsIncluding(AQLSEQ, AQLLEVEL, workpoint,dsconn);
  35. }
  36. catch (Exception ex)
  37. {
  38. throw ex;
  39. }
  40. }
  41. #endregion
  42. #region 通过guid查询
  43. public static FormICSAQLUIModel SearchAQLInfoByID(string aqlid, string dsconn)
  44. {
  45. try
  46. {
  47. List<FormICSAQLUIModel> returnlist = ICSAQLDAL.SearchAQLInfoByID(aqlid, dsconn);
  48. return returnlist[0];
  49. }
  50. catch (Exception ex)
  51. {
  52. throw ex;
  53. }
  54. }
  55. #endregion
  56. #region 删除
  57. public static void deleteInfo(List<string> aqlid, string dsconn)
  58. {
  59. try
  60. {
  61. ICSAQLDAL.deleteInfo(aqlid, dsconn);
  62. }
  63. catch (Exception ex)
  64. {
  65. throw ex;
  66. }
  67. }
  68. #endregion
  69. #region 通过检验标准查询
  70. public static List<FormICSAQLUIModel> SearchAQLInfoByLevel(string aqllevel, string dsconn)
  71. {
  72. try
  73. {
  74. List<FormICSAQLUIModel> returnlist = ICSAQLDAL.SearchAQLInfoByLevel(aqllevel, dsconn);
  75. return returnlist;
  76. }
  77. catch (Exception ex)
  78. {
  79. throw ex;
  80. }
  81. }
  82. #endregion
  83. }
  84. }