我是 ASP.NET MVC5 的新手。我有一个模型Shipping
and my dbo.Shippings.sql
是这样的:
CREATE TABLE [dbo].[Shippings]
(
[Id] INT IDENTITY (1, 1) NOT NULL,
[TruckerId] NVARCHAR (MAX) NULL,
.........more there...
CONSTRAINT [PK_dbo.Shippings]
PRIMARY KEY CLUSTERED ([Id] ASC),
CONSTRAINT [FK_dbo.Shippings_dbo.AspNetUsers_ApplicationUserId]
FOREIGN KEY ([ApplicationUserId]) REFERENCES [dbo].[AspNetUsers] ([Id]) ON DELETE CASCADE
);
CREATE NONCLUSTERED INDEX [IX_ApplicationUserId]
ON [dbo].[Shippings]([ApplicationUserId] ASC);
我的第一页必须显示所有未售出的发货(if shipping.truckerId == null
表示尚未售出)
In my ShippingController
我有以下内容:
// GET: Shipping
public ActionResult Index(string sortOrder, string currentFilter, string searchString, int? page)
{
//below is sorting
ViewBag.CurrentSort = sortOrder;
ViewBag.FromSortParm = String.IsNullOrEmpty(sortOrder) ? "from_desc" : "";
ViewBag.DestSortParm = sortOrder == "Destination" ? "dest_desc" : "Destination";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
//below is searching state and zipcode
var shippings = from s in db.Shippings
where s.TruckerId == null
select s;
if (!String.IsNullOrEmpty(searchString))
{
shippings = shippings.Where(s => s.FromState.Contains(searchString)//from state
|| s.DestState.Contains(searchString)//dest state
|| s.FromZipCode.Contains(searchString)//from zipcode
|| s.DestZipCode.Contains(searchString));//dest zipcode
}
switch (sortOrder)
{
case "from_desc":
shippings = shippings.OrderByDescending(s => s.From);
break;
case "Destination":
shippings = shippings.OrderBy(s => s.Destination); //not working
break;
case "dest_desc":
shippings = shippings.OrderByDescending(s => s.Destination); //not working
break;
default:
shippings = shippings.OrderByDescending(s => s.OrderDateTime);
break;
}
int pageSize = 10;
int pageNumber = (page ?? 1);
return View(shippings.ToPagedList(pageNumber, pageSize));
//return View(shippings.ToList());
}
I think:
var shippings = from s in db.Shippings
where s.TruckerId == null
select s;
这不是获得发货的聪明方法,而且如果数据库变大,速度会非常慢。
我只需要显示它的 FromCity、FromState、FromZipCode、PickUpDateTime、DestCity、DestState、DestZipCode、Price、Content 和 TruckerId(表明它是否已售出)。
请帮忙!
编辑和更新:当我问这个问题时,我对网络开发和数据库相当陌生。
通过为数据库创建索引,我能够获得更好的性能。所以可以快速查找。
我还重新设计了Web应用程序的架构。
我还创建了一个未售出的运输视图。因此,如果网络总是从数据库访问视图,则无需花费时间进行过滤。