SaveShrinkageExcutor.cs 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data.SqlClient;
  4. using System.Linq;
  5. using System.Text;
  6. using JLHHJSvr.BLL;
  7. using JLHHJSvr.Com;
  8. using JLHHJSvr.LJException;
  9. using JLHHJSvr.Tools;
  10. using LJLib.DAL.SQL;
  11. using LJLib.Net.SPI.Server;
  12. using LJLib.SQLEX;
  13. namespace JLHHJSvr.Excutor
  14. {
  15. internal sealed class SaveShrinkageExcutor : ExcutorBase<SaveShrinkageRequest, SaveShrinkageResponse>
  16. {
  17. protected override void ExcuteInternal(SaveShrinkageRequest request, object state, SaveShrinkageResponse rslt)
  18. {
  19. var tokendata = BllHelper.GetToken(request.token);
  20. if (tokendata == null)
  21. {
  22. rslt.ErrMsg = "会话已经中断,请重新登录";
  23. return;
  24. }
  25. if (request.shrinkage == null)
  26. {
  27. rslt.ErrMsg = "未提交裥棉收缩率";
  28. return;
  29. }
  30. using (var con = GlobalVar.ConnectionString.NewSqlConnection())
  31. using (var cmd = con.CreateCommand())
  32. {
  33. con.Open();
  34. var dtNow = DateTime.Now;
  35. AutoInit.AutoInitS(cmd, request.shrinkage);
  36. if (request.shrinkage.minvalue > request.shrinkage.maxvalue)
  37. {
  38. rslt.ErrMsg = "裥棉收缩率错误,下限不能大于上限!";
  39. return;
  40. }
  41. using (cmd.Transaction = con.BeginTransaction())
  42. {
  43. try
  44. {
  45. if (request.shrinkage.shrinkageid <= 0)
  46. {
  47. request.shrinkage.shrinkageid = BllHelper.GetID(cmd, "u_shrinkage");
  48. request.shrinkage.createtime = dtNow;
  49. request.shrinkage.createby = tokendata.username;
  50. var fields = @"shrinkageid,minvalue,maxvalue,shrinkage,createtime,createby";
  51. DbSqlHelper.Insert(cmd, "u_shrinkage", null, request.shrinkage, fields);
  52. }
  53. else
  54. {
  55. //修改
  56. request.shrinkage.createtime = dtNow;
  57. request.shrinkage.createby = tokendata.username;
  58. var fields = @"minvalue,maxvalue,shrinkage,createtime,createby";
  59. DbSqlHelper.Update(cmd, "u_shrinkage", null, request.shrinkage, "shrinkageid", fields);
  60. }
  61. cmd.Transaction.Commit();
  62. }
  63. catch (Exception e)
  64. {
  65. cmd.Transaction.Rollback();
  66. rslt.ErrMsg = e.ToString();
  67. }
  68. }
  69. }
  70. }
  71. }
  72. }