UnLockUserExcutor.cs 1.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  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.DBA.DBModle;
  9. using LJLib.DAL.SQL;
  10. using LJLib.Net.SPI.Server;
  11. using LJLib.Tools.DEncrypt;
  12. using LJLib.Tools.Encry;
  13. namespace JLHHJSvr.Excutor
  14. {
  15. internal sealed class UnLockUserExcutor : ExcutorBase<UnLockUserRequest, UnLockUserResponse>
  16. {
  17. protected override void ExcuteInternal(UnLockUserRequest request, object state, UnLockUserResponse rslt)
  18. {
  19. var tokendata = BllHelper.GetToken(request.token);
  20. if (tokendata == null)
  21. {
  22. rslt.ErrMsg = "会话已经中断,请重新登录";
  23. return;
  24. }
  25. if (request.useridList == null || request.useridList.Count == 0)
  26. {
  27. rslt.ErrMsg = "至少提交一条需要解锁的记录";
  28. return;
  29. }
  30. using (var con = new SqlConnection(GlobalVar.ConnectionString))
  31. using (var cmd = con.CreateCommand())
  32. {
  33. con.Open();
  34. using (cmd.Transaction = con.BeginTransaction())
  35. {
  36. try
  37. {
  38. UserHelper.UnLock(cmd, request.useridList);
  39. cmd.Transaction.Commit();
  40. }
  41. catch (Exception e)
  42. {
  43. cmd.Transaction.Rollback();
  44. rslt.ErrMsg = e.Message;
  45. }
  46. }
  47. }
  48. }
  49. }
  50. }