EapFunction.cs 3.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. using Cksoft.Unity;
  2. using System;
  3. using System.Collections.Generic;
  4. namespace DllUfpEntity
  5. {
  6. [Table("Function")]
  7. public class EapFunction : BaseEntity
  8. {
  9. ////自动产生代码开始&&此行不能删除
  10. #region 自动产生代码
  11. public EapFunction()
  12. {
  13. base.EntityStatusID = 1;
  14. }
  15. [ColDetail(10, "ID", 1, 1, 100, 1, "a.ID", "", 1, 1)]
  16. [Key]
  17. [Identity]
  18. public int ID { get; set; }
  19. [ColDetail(20, "FCode", 1, 1, 100, 1, "a.FCode", "", 1, 1)]
  20. public string FCode { get; set; }
  21. [ColDetail(30, "FName", 1, 1, 100, 1, "a.FName", "", 1, 1)]
  22. public string FName { get; set; }
  23. [ColDetail(40, "Url", 1, 1, 100, 1, "a.Url", "", 1, 1)]
  24. public string Url { get; set; }
  25. [ColDetail(50, "Remark", 1, 1, 100, 1, "a.Remark", "", 1, 1)]
  26. public string Remark { get; set; }
  27. [ColDetail(60, "ParentID", 1, 1, 100, 1, "a.ParentID", "", 1, 1)]
  28. public int? ParentID { get; set; }
  29. [ColDetail(70, "RecCode", 1, 1, 100, 1, "a.RecCode", "", 1, 1)]
  30. public string RecCode { get; set; }
  31. [ColDetail(80, "RecTime", 1, 1, 100, 1, "a.RecTime", "", 1, 1)]
  32. public DateTime RecTime { get; set; }
  33. [ColDetail(90, "ModCode", 1, 1, 100, 1, "a.ModCode", "", 1, 1)]
  34. public string ModCode { get; set; }
  35. [ColDetail(100, "ModTime", 1, 1, 100, 1, "a.ModTime", "", 1, 1)]
  36. public DateTime ModTime { get; set; }
  37. [ColDetail(110, "Icon", 1, 1, 100, 1, "a.Icon", "", 1, 1)]
  38. public string Icon { get; set; }
  39. [ColDetail(120, "Rank", 1, 1, 100, 1, "a.Rank", "", 1, 1)]
  40. public int? Rank { get; set; }
  41. [ColDetail(130, "SystemId", 1, 1, 100, 1, "a.SystemId", "", 1, 1)]
  42. public int? SystemId { get; set; }
  43. [ColDetail(130, "SystemId", 1, 1, 100, 1, "a.Hidden", "", 1, 1)]
  44. public int? Hidden { get; set; }
  45. [ColDetail(140, "SystemName", 1, 0, 100, 1, "b.FName", "", 1, 1)]
  46. public string SystemName { get; set; }
  47. [ColDetail(150, "ExternalLink", 1, 1, 100, 1, "a.ExternalLink", "", 1, 1)]
  48. public int ExternalLink { get; set; }
  49. public override string GetSelectSql()
  50. {
  51. return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
  52. }
  53. public override string GetQueryColSql()
  54. {
  55. string sqlstr = "a.ID ID,a.FCode FCode,a.FName FName,a.Url Url,a.Remark Remark,a.ParentID ParentID,a.RecCode RecCode,a.RecTime RecTime,a.ModCode ModCode";
  56. sqlstr += ",a.ModTime ModTime,a.Icon Icon,a.Hidden Hidden,a.Rank Rank,a.ExternalLink ExternalLink,b.FName SystemName,0 EntityStatusID";
  57. return sqlstr;
  58. }
  59. public override string GetQueryTabSql()
  60. {
  61. string sqlstr = " Function a ";
  62. sqlstr += " left join System b on a.SystemId=b.id ";
  63. return sqlstr;
  64. }
  65. public override string GetQuerySortSql()
  66. {
  67. return "";
  68. }
  69. #endregion
  70. ////自动产生代码结束&&此行不能删除
  71. ///
  72. /// <summary>
  73. /// 是否是叶子节点
  74. /// </summary>
  75. public bool IsLeaf { get; set; } = false;
  76. public IEnumerable<EapFunction> Children { get; set; }
  77. }
  78. }