GetSysUserFileStringExcutor.cs 2.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data.SqlClient;
  4. using System.Diagnostics;
  5. using System.IO;
  6. using System.IO.Compression;
  7. using System.Linq;
  8. using System.Text;
  9. using JLHHJSvr.BLL;
  10. using JLHHJSvr.Com;
  11. using JLHHJSvr.DBA.DBModle;
  12. using LJLib.Net.SPI.Server;
  13. namespace JLHHJSvr.Excutor
  14. {
  15. internal sealed class GetSysUserFileStringExcutor : ExcutorBase<GetSysUserFileStringRequest, GetSysUserFileStringResponse>
  16. {
  17. protected override void ExcuteInternal(GetSysUserFileStringRequest request, object state, GetSysUserFileStringResponse rslt)
  18. {
  19. if (request.empid == null)
  20. {
  21. rslt.ErrMsg = "参数错误,empid不能为null";
  22. return;
  23. }
  24. if (request.dwname == null)
  25. {
  26. rslt.ErrMsg = "参数错误,dwname不能为null";
  27. return;
  28. }
  29. if (request.itemname == null)
  30. {
  31. rslt.ErrMsg = "参数错误,itemname不能为null";
  32. return;
  33. }
  34. var tokendata = BllHelper.GetToken(request.token);
  35. if (tokendata == null)
  36. {
  37. rslt.ErrMsg = "会话已经中断";
  38. return;
  39. }
  40. //if (string.IsNullOrEmpty(tokendata.ConStr))
  41. //{
  42. // rslt.ErrMsg = "当前账套未设置数据库";
  43. // return;
  44. //}
  45. using (var con = new SqlConnection(GlobalVar.ConnectionString))
  46. using (var cmd = con.CreateCommand())
  47. {
  48. con.Open();
  49. //var ufs = HelperBase.GetHelper<SysUserFileString>(cmd);
  50. rslt.itemvalue = BllHelper.GetValue(cmd, request.empid.Value, request.dwname, request.itemname, string.Empty, request.ifcompress == 1 ? true : false);
  51. if (string.IsNullOrEmpty(rslt.itemvalue))//如果没有自己的布局方案,尝试获取系统的布局方案
  52. {
  53. rslt.itemvalue = BllHelper.GetValue(cmd, -1, request.dwname, request.itemname, string.Empty, request.ifcompress == 1 ? true : false);
  54. }
  55. if (request.ifdel != null && request.ifdel == 1)
  56. {
  57. BllHelper.delLayout(cmd, tokendata.userid, request.dwname, request.itemname);
  58. }
  59. }
  60. }
  61. }
  62. }