GetMattressPackagMxExcutor.cs 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data.SqlClient;
  4. using System.Linq;
  5. using System.Text;
  6. using DirectService.Tools;
  7. using JLHHJSvr.BLL;
  8. using JLHHJSvr.Com;
  9. using JLHHJSvr.Com.Model;
  10. using JLHHJSvr.Helper;
  11. using JLHHJSvr.LJException;
  12. using JLHHJSvr.Tools;
  13. using LJLib.DAL.SQL;
  14. using LJLib.Net.SPI.Server;
  15. using LJLib.SQLEX;
  16. namespace JLHHJSvr.Excutor
  17. {
  18. internal sealed class GetMattressPackagMxExcutor : ExcutorBase<GetMattressPackagMxRequest, GetMattressPackagMxResponse>
  19. {
  20. protected override void ExcuteInternal(GetMattressPackagMxRequest request, object state, GetMattressPackagMxResponse rslt)
  21. {
  22. var tokendata = BllHelper.GetToken(request.token);
  23. if (tokendata == null)
  24. {
  25. rslt.ErrMsg = "会话已经中断,请重新登录";
  26. return;
  27. }
  28. if (request.mattresstypeid == 0)
  29. {
  30. rslt.ErrMsg = "床垫类别不能为0";
  31. return;
  32. }
  33. using (var con = GlobalVar.ConnectionString.NewSqlConnection())
  34. using (var cmd = con.CreateCommand())
  35. {
  36. con.Open();
  37. using (cmd.Transaction = con.BeginTransaction())
  38. {
  39. var helper = HelperBase.GetHelper<MattressHelper>(cmd, new HelperBase.Context() { tokendata = tokendata });
  40. var dw_2 = new List<u_mattress_mx_mtrl>();
  41. // 导入 2-按包装方式 的公式
  42. helper.wf_import_bz(request.packtype, ref dw_2);
  43. helper.wf_sort_mx(ref dw_2);
  44. helper.wf_default_mtrlid(request.pricelistid, ref dw_2);
  45. rslt.mattressMx = dw_2;
  46. }
  47. }
  48. }
  49. }
  50. }