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

66 lines
2.0 KiB

5 months ago
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Data;
  6. using ICSSoft.Frame.Data.DAL;
  7. using ICSSoft.Frame.Data.Entity;
  8. using System.Data.SqlClient;
  9. namespace ICSSoft.Frame.Data.BLL
  10. {
  11. public class ICSWBSSpecailTransferBLL
  12. {
  13. public static void Add(List<ICSWBSSpecialTransfer> InfoList, string dsconn)
  14. {
  15. try
  16. {
  17. if (string.IsNullOrWhiteSpace(dsconn))
  18. {
  19. throw new Exception("数据库连接字符串错误");
  20. }
  21. ICSWBSSpecailTransferDAL.AddAndEdit(InfoList, dsconn);
  22. }
  23. catch (Exception ex)
  24. {
  25. throw ex;
  26. }
  27. }
  28. #region 项目转换
  29. public static void UpdateWBS(SqlConnection sqlConnection, SqlTransaction trans,string LotCode,string QtyCode,string IDCode, string dsconn)
  30. {
  31. try
  32. {
  33. if (string.IsNullOrWhiteSpace(dsconn))
  34. {
  35. throw new Exception("数据库连接字符串错误");
  36. }
  37. ICSWBSSpecailTransferDAL.UpdateWBS(sqlConnection, trans, LotCode, QtyCode, IDCode,dsconn);
  38. }
  39. catch (Exception ex)
  40. {
  41. throw new Exception(ex.Message);
  42. }
  43. }
  44. #endregion
  45. #region 更新WMS
  46. public static void UpdateTransWMS(SqlConnection sqlConnection, SqlTransaction trans, List<ICSWBSSpecialTransfer> InfoList,List<ICSITEMLot> lotList,string dsconn)
  47. {
  48. try
  49. {
  50. if (string.IsNullOrWhiteSpace(dsconn))
  51. {
  52. throw new Exception("数据库连接字符串错误");
  53. }
  54. ICSWBSSpecailTransferDAL.UpdateTransWMS(sqlConnection, trans, InfoList, lotList, dsconn);
  55. }
  56. catch (Exception ex)
  57. {
  58. throw new Exception(ex.Message);
  59. }
  60. }
  61. #endregion
  62. }
  63. }