MVC会话过期 - 继续离开(MVC session expires - continue where left)
我们有一个需要登录的内部ASP.NET MVC应用程序。 登录工作很好，并做到了预期的。 我们有5分钟的会话过期。 在那段时间坐在单页上之后，用户已经失去了会话。 如果他们尝试刷新当前页面或浏览到另一页面，他们将获得登录页面。
我的问题是（在重新登录后）在哪里告诉MVCto重定向到他们的（刷新/浏览）尝试，而不是始终获取HOME控制器页面？
We have an internal ASP.NET MVC application that requires a logon. Log on works great and does what's expected. We have a session expiration of 5 minutes. After sitting on a single page for that period of time, the user has lost the session. If they attempt to refresh the current page or browse to another, they will get a log on page.
My question is (after reloggin in) where to tell MVCto redirect to their (refresh/browse) attempt instead of getting HOME controller page always ?
原文：https://stackoverflow.com/questions/19518846
更新时间：2023-07-29 15:07
最满意答案
做一个加入..
;with Firstquery as ( SELECT ReviewID, SUM(CASE Score_CorrectID_Accuracy WHEN 'Error' THEN 1 ELSE 0 END + CASE Score_ProperlyIdentified_Accuracy WHEN 'Error' THEN 1 ELSE 0 END) AS GeneralErrors FROM Reviews WHERE (UserID IS NOT NULL AND UserID <> '') GROUP BY Reviews.ReviewID ) ,Secondquery as ( SELECT Reviews.ReviewID ,COUNT(RehabMetricsCalls.ReviewID) AS RehabErrors FROM RehabMetrics INNER JOIN RehabMetricsCalls ON RehabMetrics.RehabMetricID = RehabMetricsCalls.RehabMetricID RIGHT OUTER JOIN Reviews ON RehabMetricsCalls.ReviewID = Reviews.ReviewID WHERE (UserID IS NOT NULL AND UserID <> '') GROUP BY Reviews.ReviewID ) select fs.reviewid,fs.generalerrors,sq.rehaberrors from firstquery fs join secondquery sq on fs.reviewid=sq.reviewiddo a join..
;with Firstquery as ( SELECT ReviewID, SUM(CASE Score_CorrectID_Accuracy WHEN 'Error' THEN 1 ELSE 0 END + CASE Score_ProperlyIdentified_Accuracy WHEN 'Error' THEN 1 ELSE 0 END) AS GeneralErrors FROM Reviews WHERE (UserID IS NOT NULL AND UserID <> '') GROUP BY Reviews.ReviewID ) ,Secondquery as ( SELECT Reviews.ReviewID ,COUNT(RehabMetricsCalls.ReviewID) AS RehabErrors FROM RehabMetrics INNER JOIN RehabMetricsCalls ON RehabMetrics.RehabMetricID = RehabMetricsCalls.RehabMetricID RIGHT OUTER JOIN Reviews ON RehabMetricsCalls.ReviewID = Reviews.ReviewID WHERE (UserID IS NOT NULL AND UserID <> '') GROUP BY Reviews.ReviewID ) select fs.reviewid,fs.generalerrors,sq.rehaberrors from firstquery fs join secondquery sq on fs.reviewid=sq.reviewid
相关问答
更多-
SQL Server 2008阵列查询(SQL Server 2008 Array Query)[2022-05-26]
您可以使用除设置操作外的： SELECT n FROM (VALUES(1),(2),(3),(4),(5),(6)) AS Nums(n) EXCEPT SELECT RecoveryID from table1 You can use Except set operation as : SELECT n FROM (VALUES(1),(2),(3),(4),(5),(6)) AS Nums(n) EXCEPT SELECT RecoveryID from table1 -
做一个加入.. ;with Firstquery as ( SELECT ReviewID, SUM(CASE Score_CorrectID_Accuracy WHEN 'Error' THEN 1 ELSE 0 END + CASE Score_ProperlyIdentified_Accuracy WHEN 'Error' THEN 1 ELSE 0 END) AS GeneralErrors FROM Reviews WHERE (UserID IS NOT NULL AND ...
-
请尝试以下版本的查询： SET DATEFORMAT dmy DECLARE @time time(0) Select DISTINCT P.PATIENT_ID as 'Patient ID', P.SEX as 'Sex', CONVERT(VARCHAR(11),P.DOB) as 'DOB', CONVERT(VARCHAR,TYPE1.DateTime,101)as 'BP Measure DATES', CONVERT(VARCHAR,TYPE2.Dat ...
-
这应该在Transact-SQL中有效： insert into GoodTable select top 500 * from OtherTable order by newid() 编辑：这可能会更好，它会自动为您创建GoodTable（而不是需要事先用适当的列手动创建它）： select top 500 * into GoodTable from OtherTable order by newid() This should work in Transact-SQL: insert into Go ...
-
你在表2中有4条记录，ID为1.你为什么要计算3？ 如果要计算每列中column2中不同值的数量，请执行 select t1.id, count(distinct column2) RecCount from @table1 t1 join @table2 t2 on t1.id = t2.id group by t1.id 虽然在这种情况下，不需要连接，并且 select id, count(distinct column2) RecCount from @table2 group by id ...
-
如果要获取Order表的最后5行，为什么要将TOP应用于Customer表？ SELECT TOP 5 A.[FirstName],B.[OrderId],B.[OrderDate],B.[TotalAmount],B.[OrderStatusId] FROM [schema].[Order] B LEFT JOIN [schema].[Customer] A ON A.[CustomerId]=B.[CustomerId] WHERE B.[CustomerId]=1 ORDER BY B.[O ...
-
加入等价于Not IN子句的查询（SQL Server 2008）(Join query equivalent to Not IN clause (SQL Server 2008))[2021-07-28]
SELECT * FROM Company C LEFT JOIN CrossRef R ON R.SenderID = C.CompanyID LEFT JOIN [User] U ON U.company_id = C.id WHERE R.SenderID IS NULL AND U.company_id IS NULL SELECT * FROM Company C LEFT JOIN CrossRef R ON R.SenderID = C.CompanyID LEFT JOIN [User ... -
有人可以告诉我为什么将LOOP提示应用于我的所有查询是一个糟糕的主意。 我在某处读取LOOP JOIN是查询优化器的默认JOIN方法，但无法验证语句的有效性？ 因为这会让优化者有机会考虑其他更高效的方法。 何时使用JOIN提示？ 当sh * t击中球迷并且鬼城不在城里时？ 当数据分布（优化器作出决定时）严重偏斜，统计数据无法正确表示。 LOOP，HASH和MERGE提示有什么区别？ BOL指出MERGE似乎是最慢的，但每个提示的应用是什么？ 这些是不同的算法。 LOOP是嵌套循环：对于来自外部表的每条记录， ...
-
如果要在连接表中包含没有任何匹配项的记录，则需要使用left join ，并对连接表中的列进行count ，如下所示： select o.patientno,o.loccode,o.status,o.sDate, count(t.sdate) as cnt from patient o left join targetpatient t on o.patientno = t.patientno and o.loccode = t.loccode ...
-
如评论中所示，列中有一个字符太多。 那么要么调整你的java import（ String#trim() ？），要么更新表中的值： UPDATE table SET colName = SUB(colName,0,LEN(colName)) WHERE ASCII(SUBSTRING(colName,LEN(colName),1)) = 0 谨防！ 这是未经测试的，因此在使用它之前将其包装在事务中。 As seen in the comments, there is one character to ...