asp.net-mvc - 会话中还有其他线程正在运行
问题描述
我的控制器代码:
public ActionResult groupeditSubmit(List<string> barC, int PID = -1, int TID = -1, string DateT = "", int nPID = -1, int nTID = -1, string nDateT = "")
{
ViewBag.PID = new SelectList(db.Places, "ID", "Name", 0);
ViewBag.TID = new SelectList(db.Transferees, "ID", "FullName", 0);
ViewBag.DateT = DateT;
var studentList = db.Database.ExecuteSqlCommand("Update Barcode set PID = '"+nPID+ "' ,TID='"+nTID+ "' , DateT = '"+nDateT+ "' where (PID = "+PID+ " AND TID = "+TID+ " AND DateT = '"+ DateT + "' )");
db.SaveChanges();
return RedirectToAction("groupedit");
}
我的视图代码:
@model IEnumerable<barkod.Models.Barcode>
@{
ViewBag.Title = "groupedit";
Layout = "~/Views/Shared/_LayoutPanel.cshtml";
}
</form>
@if (Model.Count() > 0)
{
<div class="row text-center">
<form method="post" action="groupeditSubmit">
<table class="table table-responsive">
<tr>
<th>
بارکد
</th>
<th>
مکان
</th>
<th>
تحویل گیرنده
</th>
<th>
تاریخ تحویل
</th>
</tr>
@foreach (var item in Model)
{
<tr>
<td>
<input name="barc" value="@Html.DisplayFor(modelItem => item.barC)" class="hidden" />
@Html.DisplayFor(modelItem => item.barC)
</td>
<td>
@Html.DisplayFor(modelItem => item.Place.Name)
</td>
<td>
@Html.DisplayFor(modelItem => item.Transferee.FullName)
</td>
<td>
@Html.DisplayFor(modelItem => item.DateT)
</td>
</tr>
}
</table>
<div class="form-group">
<div class="col-md-10">
@Html.DropDownList("nTID", null, htmlAttributes: new { @class = "form-control", required = "required" })
</div>
</div>
<div class="form-group">
<div class="col-md-10">
@Html.DropDownList("nPID", null, htmlAttributes: new { @class = "form-control", required = "required" })
</div>
</div>
<div class="form-group">
<div class="col-md-10">
@Html.Editor("nDateT", new
{
htmlAttributes = new
{
@class = "form-control"@*, Type = "date"*@,
required = "required",
@Value = ViewBag.DateT
}
})
@*<input type="button" id= "exampleI" class="btn-danger" value="#" name="Date" data-mddatetimepicker="true" data-placement="right" data-trigger="click" data-targetselector="#exampleI" required />*@
</div>
</div>
<div class="form-group hidden">
<div class="col-md-10">
@Html.DropDownList("TID", null, htmlAttributes: new { @class = "form-control", required = "required" })
</div>
</div>
<div class="form-group hidden">
<div class="col-md-10">
@Html.DropDownList("PID", null, htmlAttributes: new { @class = "form-control", required = "required" })
</div>
</div>
<div class="form-group hidden">
<div class="col-md-10">
@Html.Editor("DateT", new
{
htmlAttributes = new
{
@class = "form-control"@*, Type = "date"*@,
required = "required",
@Value = ViewBag.DateT
}
})
@*<input type="button" id= "exampleI" class="btn-danger" value="#" name="Date" data-mddatetimepicker="true" data-placement="right" data-trigger="click" data-targetselector="#exampleI" required />*@
</div>
</div>
<input type="submit" class="btn btn-success" value="ویرایش گروهی" />
</form>
</div>
}
在我的本地主机中没问题,但是当它在服务器中运行时,它给了我这个错误:
“/”应用程序中的服务器错误。不允许新事务,因为会话中还有其他线程在运行。说明:执行当前 Web 请求期间发生未处理的异常。请查看堆栈跟踪以获取有关错误及其源自代码的位置的更多信息。异常详细信息:System.Data.SqlClient.SqlException:不允许新事务,因为会话中还有其他线程在运行。
解决方案
推荐阅读
- powershell - 将自定义行添加到 $String | 选择 | 格式表输出请求
- java - 如何使用 Hibernate 会话批量执行 SQL 查询
- javascript - Gulp - 如果 CSS 大小大于 50 kb,则 gulp 进程失败
- c# - 如何以正确的方式在 ScrollView 中滚动 DataGrid?
- azure - Azure 市场 Sendgrid 用户名
- sql - 按周分组并将星期六视为一周的开始日
- azure-table-storage - 如何使用数据工厂将 csv 文件数据加载到 azure datalake 的表存储中
- sql - 理解PostgreSQL中FROM子句中子查询的语义
- java - 将混合/Web 客户端应用程序与由一组 WSDL 描述的现有远程 Web 服务连接
- r - Create Histogram, grouping by a column and then sum by another in R