InsertNavTask.cs 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Linq.Expressions;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace SqlSugar
  8. {
  9. public class InsertNavTaskInit<Root, T> where T : class, new() where Root : class, new()
  10. {
  11. internal SqlSugarProvider Context { get; set; }
  12. internal InsertNavProvider<Root, Root> insertNavProvider { get; set; }
  13. internal NavContext NavContext { get; set; }
  14. public InsertNavMethodInfo IncludeByNameString(string navMemberName, UpdateNavOptions updateNavOptions = null)
  15. {
  16. InsertNavMethodInfo result = new InsertNavMethodInfo();
  17. result.Context = insertNavProvider._Context;
  18. var entityInfo = result.Context.EntityMaintenance.GetEntityInfo<T>();
  19. Type properyItemType;
  20. bool isList;
  21. Expression exp = UtilMethods.GetIncludeExpression(navMemberName, entityInfo, out properyItemType, out isList);
  22. var method = this.GetType().GetMyMethod("Include", 2, isList)
  23. .MakeGenericMethod(properyItemType);
  24. var obj = method.Invoke(this, new object[] { exp, updateNavOptions });
  25. result.MethodInfos = obj;
  26. return result;
  27. }
  28. public InsertNavMethodInfo IncludesAllFirstLayer(params string[] ignoreColumns)
  29. {
  30. if (ignoreColumns == null)
  31. {
  32. ignoreColumns = new string[] { };
  33. }
  34. this.Context = insertNavProvider._Context;
  35. var navColumns = this.Context.EntityMaintenance.GetEntityInfo<Root>().Columns.Where(it => !ignoreColumns.Contains(it.PropertyName) || !ignoreColumns.Any(z => z.EqualCase(it.DbColumnName))).Where(it => it.Navigat != null).ToList();
  36. var updateNavs = this;
  37. InsertNavMethodInfo methodInfo = updateNavs.IncludeByNameString(navColumns[0].PropertyName);
  38. foreach (var item in navColumns.Skip(1))
  39. {
  40. methodInfo = methodInfo.IncludeByNameString(item.PropertyName);
  41. }
  42. return methodInfo;
  43. }
  44. public InsertNavTask<Root, TChild> Include<TChild>(Expression<Func<Root, TChild>> expression) where TChild : class, new()
  45. {
  46. Check.ExceptionEasy(typeof(TChild).FullName.Contains("System.Collections.Generic.List`"), " need where T: class, new() ", "需要Class,new()约束,并且类属性中不能有required修饰符");
  47. this.Context = insertNavProvider._Context;
  48. insertNavProvider.NavContext = this.NavContext;
  49. InsertNavTask<Root, TChild> result = new InsertNavTask<Root, TChild>();
  50. Func<InsertNavProvider<Root, TChild>> func = () => insertNavProvider.ThenInclude(expression);
  51. result.PreFunc = func;
  52. result.Context = this.Context;
  53. result.NavContext = this.NavContext;
  54. return result;
  55. }
  56. public InsertNavTask<Root, TChild> Include<TChild>(Expression<Func<Root, List<TChild>>> expression) where TChild : class, new()
  57. {
  58. this.Context = insertNavProvider._Context;
  59. insertNavProvider.NavContext = this.NavContext;
  60. InsertNavTask<Root, TChild> result = new InsertNavTask<Root, TChild>();
  61. Func<InsertNavProvider<Root, TChild>> func = () => insertNavProvider.ThenInclude(expression);
  62. result.PreFunc = func;
  63. result.Context = this.Context;
  64. result.NavContext = this.NavContext;
  65. return result;
  66. }
  67. public InsertNavTask<Root, TChild> Include<TChild>(Expression<Func<Root, TChild>> expression,InsertNavOptions options) where TChild : class, new()
  68. {
  69. Check.ExceptionEasy(typeof(TChild).FullName.Contains("System.Collections.Generic.List`"), " need where T: class, new() ", "需要Class,new()约束,并且类属性中不能有required修饰符");
  70. this.Context = insertNavProvider._Context;
  71. insertNavProvider.NavContext = this.NavContext;
  72. InsertNavTask<Root, TChild> result = new InsertNavTask<Root, TChild>();
  73. Func<InsertNavProvider<Root, TChild>> func = () => insertNavProvider.ThenInclude(expression, options);
  74. result.PreFunc = func;
  75. result.Context = this.Context;
  76. result.NavContext = this.NavContext;
  77. return result;
  78. }
  79. public InsertNavTask<Root, TChild> Include<TChild>(Expression<Func<Root, List<TChild>>> expression, InsertNavOptions options) where TChild : class, new()
  80. {
  81. this.Context = insertNavProvider._Context;
  82. insertNavProvider.NavContext =this.NavContext;
  83. InsertNavTask<Root, TChild> result = new InsertNavTask<Root, TChild>();
  84. Func<InsertNavProvider<Root, TChild>> func = () => insertNavProvider.ThenInclude(expression, options);
  85. result.PreFunc = func;
  86. result.Context = this.Context;
  87. result.NavContext = this.NavContext;
  88. return result;
  89. }
  90. }
  91. public class InsertNavTask<Root, T> where T : class, new() where Root : class, new()
  92. {
  93. public SqlSugarProvider Context { get; set; }
  94. public Func<InsertNavProvider<Root, T>> PreFunc { get; set; }
  95. internal NavContext NavContext { get; set; }
  96. public InsertNavTask<Root, TChild> ThenInclude<TChild>(Expression<Func<T, TChild>> expression) where TChild : class, new()
  97. {
  98. InsertNavTask<Root, TChild> result = new InsertNavTask<Root, TChild>();
  99. Func<InsertNavProvider<Root, TChild>> func = () => {
  100. var nav = PreFunc().ThenInclude(expression);
  101. nav.NavContext = this.NavContext;
  102. return nav;
  103. };
  104. result.PreFunc = func;
  105. result.Context = this.Context;
  106. result.NavContext = this.NavContext;
  107. return result;
  108. }
  109. public InsertNavTask<Root, TChild> ThenInclude<TChild>(Expression<Func<T, List<TChild>>> expression) where TChild : class, new()
  110. {
  111. InsertNavTask<Root, TChild> result = new InsertNavTask<Root, TChild>();
  112. Func<InsertNavProvider<Root, TChild>> func = () =>
  113. {
  114. var nav = PreFunc().ThenInclude(expression);
  115. nav.NavContext = this.NavContext;
  116. return nav;
  117. };
  118. result.PreFunc = func;
  119. result.Context = this.Context;
  120. result.NavContext = this.NavContext;
  121. return result;
  122. }
  123. public InsertNavTask<Root, TChild> Include<TChild>(Expression<Func<Root, TChild>> expression) where TChild : class, new()
  124. {
  125. return AsNav().ThenInclude(expression);
  126. }
  127. public InsertNavTask<Root, TChild> Include<TChild>(Expression<Func<Root, List<TChild>>> expression) where TChild : class, new()
  128. {
  129. return AsNav().ThenInclude(expression);
  130. }
  131. public InsertNavTask<Root, TChild> ThenInclude<TChild>(Expression<Func<T, TChild>> expression,InsertNavOptions options) where TChild : class, new()
  132. {
  133. InsertNavTask<Root, TChild> result = new InsertNavTask<Root, TChild>();
  134. Func<InsertNavProvider<Root, TChild>> func = () => PreFunc().ThenInclude(expression,options);
  135. result.PreFunc = func;
  136. result.Context = this.Context;
  137. result.NavContext = this.NavContext;
  138. return result;
  139. }
  140. public InsertNavTask<Root, TChild> ThenInclude<TChild>(Expression<Func<T, List<TChild>>> expression, InsertNavOptions options) where TChild : class, new()
  141. {
  142. InsertNavTask<Root, TChild> result = new InsertNavTask<Root, TChild>();
  143. Func<InsertNavProvider<Root, TChild>> func = () => PreFunc().ThenInclude(expression, options);
  144. result.PreFunc = func;
  145. result.Context = this.Context;
  146. result.NavContext = this.NavContext;
  147. return result;
  148. }
  149. public InsertNavTask<Root, TChild> Include<TChild>(Expression<Func<Root, TChild>> expression, InsertNavOptions options) where TChild : class, new()
  150. {
  151. return AsNav().ThenInclude(expression, options);
  152. }
  153. public InsertNavTask<Root, TChild> Include<TChild>(Expression<Func<Root, List<TChild>>> expression, InsertNavOptions options) where TChild : class, new()
  154. {
  155. return AsNav().ThenInclude(expression, options);
  156. }
  157. public Root ExecuteReturnEntity()
  158. {
  159. var hasTran = this.Context.Ado.Transaction != null;
  160. if (hasTran)
  161. {
  162. return (Root)PreFunc()?._RootList?.FirstOrDefault();
  163. }
  164. else
  165. {
  166. Root result = null;
  167. this.Context.Ado.UseTran(() =>
  168. {
  169. result= (Root)PreFunc()?._RootList?.FirstOrDefault();
  170. }, ex => throw ex);
  171. return result;
  172. }
  173. }
  174. public async Task<Root> ExecuteReturnEntityAsync()
  175. {
  176. Root result = null;
  177. await Task.Run(async () =>
  178. {
  179. result=ExecuteReturnEntity();
  180. await Task.Delay(0);
  181. });
  182. return result;
  183. }
  184. public bool ExecuteCommand()
  185. {
  186. var hasTran = this.Context.Ado.Transaction != null;
  187. if (hasTran)
  188. {
  189. PreFunc();
  190. }
  191. else
  192. {
  193. this.Context.Ado.UseTran(() =>
  194. {
  195. PreFunc();
  196. }, ex => throw ex);
  197. }
  198. return true;
  199. }
  200. public async Task<bool> ExecuteCommandAsync()
  201. {
  202. await Task.Run(async () =>
  203. {
  204. ExecuteCommand();
  205. await Task.Delay(0);
  206. });
  207. return true;
  208. }
  209. private InsertNavTask<Root, Root> AsNav()
  210. {
  211. InsertNavTask<Root, Root> result = new InsertNavTask<Root, Root>();
  212. Func<InsertNavProvider<Root, Root>> func = () => {
  213. var navas= PreFunc().AsNav();
  214. navas.NavContext = this.NavContext;
  215. navas.IsNav = true;
  216. return navas;
  217. };
  218. result.PreFunc = func;
  219. result.Context = this.Context;
  220. result.NavContext = this.NavContext;
  221. return result;
  222. }
  223. }
  224. }