[SqlSugarException: 中文提示 : 多表查询存在别名不一致,请把Where中的u改成p就可以了,特殊需求可以使用.Select((x,y)=>new{ id=x.id,name=y.name}).MergeTable().Orderby(xxx=>xxx.Id)功能将Select中的多表结果集变成单表,这样就可以不限制别名一样
English Message : Join p needs to be the same as Where u]
SqlSugar.Check.Exception(Boolean isException, String message, String[] args) +139
SqlSugar.QueryBuilder.CheckExpression(Expression expression, String methodName) +809
SqlSugar.QueryableProvider`1._Where(Expression expression) +104
SqlSugar.QueryableProvider`3.Where(Expression`1 expression) +52
PoketFrame.Core.Services.ProductService.GetProductsBySiteId(Int32 portalId) +1279
ASP.templates_detail_aspx.__RenderContent1(HtmlTextWriter __w, Control parameterContainer) +1675
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +276
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +11661639
System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +47
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +53
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +169
System.Web.UI.Page.Render(HtmlTextWriter writer) +40
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +80
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4239
|