“/”应用程序中的服务器错误。

sql:select count(1) as co from [zxal] where  zxal.columnId=@columnId and zxal.state=@State and zxal.IsExpire=@IsExpire and zxal.IsOnline=@IsOnline and 1=1 and jqmj >200,error:在将 nvarchar 值 '108㎡' 转换成数据类型 int 时失败。

说明: 执行当前 Web 请求期间,出现未经处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Exception: sql:select count(1) as co from [zxal] where  zxal.columnId=@columnId and zxal.state=@State and zxal.IsExpire=@IsExpire and zxal.IsOnline=@IsOnline and 1=1 and jqmj >200,error:在将 nvarchar 值 '108㎡' 转换成数据类型 int 时失败。

源错误:


行 124:            <div class="row">
行 125:                <ul>
行 126:                    @foreach (dynamic item in Html.InfoDataList(new { ColumnId = Html.CurrentColumnId(),OrderBy=OrderBy }, where, null, pageInfo))
行 127:                    {  
行 128:                        string url = Html.InfoDataUrl((int)item.ColumnId, (int)item.Id);

源文件: d:\wwwroot\youranwl\wwwroot\Templates\CompanyDefault\views\装修案例\AnliList.cshtml    行: 126

堆栈跟踪:


[Exception: sql:select count(1) as co from [zxal] where  zxal.columnId=@columnId and zxal.state=@State and zxal.IsExpire=@IsExpire and zxal.IsOnline=@IsOnline and 1=1 and jqmj >200,error:在将 nvarchar 值 '108㎡' 转换成数据类型 int 时失败。]
   PageAdmin.Utils.ORM.DbSqlServer.GetField(String sql, DbKeyValueList param) +427
   PageAdmin.Utils.ORM.DbDataBasicMethod.GetField(DataBaseContext dbContext, String sql) +110
   PageAdmin.Utils.ORM.DbDataBasicMethod.GetField(DataBaseContext dbContext, String table, String field, String sqlCondition, String sqlOrderBy) +175
   PageAdmin.Utils.ORM.QueryToDynamic.Query(DataBaseContext dbContext, String table, String fields, String sqlCondition, String sqlOrderBy, PageInfo pageInfo) +150
   PageAdmin.Common.InfoData.GetList(PageInfo pageInfo, String columnIds, String showFields, String sqlCondition, DbKeyValueList dbKeyValueList, String orderBy) +1903
   System.Web.Mvc.Html.HtmlHelperInfoDataMethod.InfoDataList(HtmlHelper htmlHelper, T objParams, String sqlCondition, Object sqlParamters, PageInfo pageInfo) +3911
   ASP._Page_Templates_CompanyDefault_Views_装修案例_AnliList_cshtml.Execute() in d:\wwwroot\youranwl\wwwroot\Templates\CompanyDefault\views\装修案例\AnliList.cshtml:126
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy() +197
   System.Web.Mvc.WebViewPage.ExecutePageHierarchy() +105
   System.Web.WebPages.StartPage.RunPage() +17
   System.Web.WebPages.StartPage.ExecutePageHierarchy() +73
   System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +78
   System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance) +256
   System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer) +107
   System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context) +294
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext, ActionResult actionResult) +13
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +56
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +422
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +422
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +422
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilterRecursive(IList`1 filters, Int32 filterIndex, ResultExecutingContext preContext, ControllerContext controllerContext, ActionResult actionResult) +422
   System.Web.Mvc.ControllerActionInvoker.InvokeActionResultWithFilters(ControllerContext controllerContext, IList`1 filters, ActionResult actionResult) +52
   System.Web.Mvc.Async.<>c__DisplayClass3_6.<BeginInvokeAction>b__4() +198
   System.Web.Mvc.Async.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult) +100
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +44
   System.Web.Mvc.<>c.<BeginExecuteCore>b__152_1(IAsyncResult asyncResult, ExecuteCoreState innerState) +11
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +64
   System.Web.Mvc.<>c.<BeginExecute>b__151_2(IAsyncResult asyncResult, Controller controller) +13
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +22
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +45
   System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10
   System.Web.Mvc.<>c.<BeginProcessRequest>b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) +28
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +45
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9851493
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +50
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +163


版本信息: Microsoft .NET Framework 版本:4.0.30319; ASP.NET 版本:4.8.4700.0