IDTOpenCode.cs 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141
  1. using FCS.Models;
  2. using FCS.Models.Entity;
  3. using System.Collections.Generic;
  4. namespace FCS.Interface
  5. {
  6. /// <summary>
  7. /// 地方彩相关数据服务接口
  8. /// </summary>
  9. public interface IDTOpenCode
  10. {
  11. /// <summary>
  12. /// 存取国家信息
  13. /// </summary>
  14. /// <param name="lottery"></param>
  15. /// <param name="model"></param>
  16. /// <returns></returns>
  17. bool AddArea(FCSLottery lottery, F_Area model);
  18. /// <summary>
  19. /// 赛事添加
  20. /// </summary>
  21. /// <param name="lottery"></param>
  22. /// <param name="model"></param>
  23. /// <returns></returns>
  24. bool AddEvents(FCSLottery lottery, F_Events model);
  25. /// <summary>
  26. /// 获取枚举值
  27. /// </summary>
  28. /// <returns></returns>
  29. List<DataItemDetail> GetDataItem(DataItemDetailEnum dateItem);
  30. /// <summary>
  31. /// 添加球队信息
  32. /// </summary>
  33. /// <param name="lottery"></param>
  34. /// <param name="model"></param>
  35. /// <returns></returns>
  36. bool AddTeam(FCSLottery lottery, F_Team model);
  37. /// <summary>
  38. /// 添加球队信息
  39. /// </summary>
  40. /// <param name="lottery"></param>
  41. /// <param name="model"></param>
  42. /// <returns></returns>
  43. bool AddPlayers(FCSLottery lottery, F_Players model);
  44. /// <summary>
  45. /// 添加球队球员信息
  46. /// </summary>
  47. /// <param name="lottery"></param>
  48. /// <param name="model"></param>
  49. /// <returns></returns>
  50. bool AddRelation(FCSLottery lottery, F_Relation model);
  51. /// <summary>
  52. /// 根据国家名字查错Guid
  53. /// </summary>
  54. /// <param name="lottery"></param>
  55. /// <param name="model"></param>
  56. /// <returns></returns>
  57. F_EuropeanEvents GetAreaId(string Name);
  58. /// <summary>
  59. /// 批量新增(SqlBulkCopy)
  60. /// </summary>
  61. /// <typeparam name="T"></typeparam>
  62. /// <param name="list"></param>
  63. void SqlBulkCopyAdd<T>(IEnumerable<T> list);
  64. /// <summary>
  65. /// 获取球队列表
  66. /// </summary>
  67. /// <returns></returns>
  68. List<F_Team> GetTeamList();
  69. /// <summary>
  70. /// 获取球员列表
  71. /// </summary>
  72. /// <returns></returns>
  73. List<F_Players> GetPlayerList();
  74. /// <summary>
  75. /// 获取国家列表
  76. /// </summary>
  77. /// <returns></returns>
  78. List<F_Area> GetContryList();
  79. /// <summary>
  80. /// 单表查询
  81. /// </summary>
  82. /// <typeparam name="T"></typeparam>
  83. /// <returns></returns>
  84. IEnumerable<T> Query<T>(string where = "", string json = "", string select = "a.*");
  85. /// <summary>
  86. /// 单表查询
  87. /// </summary>
  88. /// <typeparam name="T"></typeparam>
  89. /// <returns></returns>
  90. IEnumerable<T> Query_delete<T>(string sql);
  91. /// <summary>
  92. /// 表查询
  93. /// </summary>
  94. /// <typeparam name="T">表名对象</typeparam>
  95. /// <typeparam name="U">转换类型</typeparam>
  96. /// <param name="where">条件</param>
  97. /// <param name="json">join条件(默认第一个是a开头)</param>
  98. /// <param name="select">查询字段</param>
  99. /// <returns></returns>
  100. IEnumerable<U> Query<T, U>(string where = "", string json = "", string select = "a.*");
  101. /// <summary>
  102. /// 单表查询
  103. /// </summary>
  104. /// <typeparam name="T"></typeparam>
  105. /// <returns></returns>
  106. IEnumerable<T> Query1<T>(string where = "");
  107. void Delete<T>(string where = "");
  108. void Update<T>(string where = "");
  109. #region 新闻相关
  110. /// <summary>
  111. /// 新闻添加
  112. /// </summary>
  113. /// <param name="lottery"></param>
  114. /// <param name="model"></param>
  115. /// <returns></returns>
  116. bool AddNews(NewsTypeEnum news, Base_News model);
  117. #endregion
  118. /// <summary>
  119. /// 获取篮球球队
  120. /// </summary>
  121. /// <returns></returns>
  122. List<B_Team> GetBasketTeamList();
  123. /// <summary>
  124. /// 获取篮球球员
  125. /// </summary>
  126. /// <returns></returns>
  127. List<B_Players> GetBasketPalyerList();
  128. }
  129. }