我认为标题的措词不正确。我试图返回结果以填充视图。我在浏览器控制台中收到的错误消息是“序列化类型为对象的对象时检测到循环引用”，所有文档都说要展平对象并排除与模型无关的属性。创建一个匿名类型是一种变通方法，似乎可以解决某些问题。我都不能上班。如果我尝试类似的东西
var Results = from RS in results
select new
{
BundleId = RS.BundleId
};
intellisense确实可以接受。有什么建议？
控制器
{
public class BundleStatusController : Controller
{
public ActionResult BundleStatus()
{
return View();
}
[HttpPost]
public ActionResult BundleStatusRead([DataSourceRequest] DataSourceRequest request)
{
var span = DateTime.Today.AddDays(-1);
DataAccessAdapter adapter = new DataAccessAdapter();
EntityCollection allBundles = new EntityCollection(new CarrierBundleEntityFactory());
RelationPredicateBucket filter = new RelationPredicateBucket(CarrierBundleFields.Date <= span);
adapter.FetchEntityCollection(allBundles, filter);
var results = allBundles;
return Json(results.ToDataSourceResult(request));
}
}
}
看法
@{
ViewBag.Title = "BundleStatusGet";
}
<div>
@(Html.Kendo().Grid<ZoomAudits.DAL.EntityClasses.CarrierBundleEntity>()
.Name("grid")
.Columns(columns =>
{
columns.Bound(c => c.BundleId).Width(140);
columns.Bound(c => c.CarrierId).Width(190);
columns.Bound(c => c.Date);
columns.Bound(c => c.IsSent).Width(110);
})
.HtmlAttributes(new { style = "height: 380px;" })
.Scrollable()
.Groupable()
.Sortable()
.Pageable(pageable => pageable
.Refresh(true)
.PageSizes(true)
.ButtonCount(5))
.Selectable(selectable => selectable
.Mode(GridSelectionMode.Multiple)
.Type(GridSelectionType.Cell))
//.Events(events => events.Change("onChange").Sync("sync_handler")))
.DataSource(dataSource => dataSource
.Ajax()
.Read(read => read.Action("BundleStatusRead", "BundleStatus"))
//.Update(update => update.Action("EditingInline_Update", "Grid"))
)
)
更新的控制器
[HttpPost]
public ActionResult BundleStatusRead([DataSourceRequest] DataSourceRequest request)
{
var span = DateTime.Today.AddDays(-1);
DataAccessAdapter adapter = new DataAccessAdapter();
EntityCollection allBundles = new EntityCollection(new CarrierBundleEntityFactory());
RelationPredicateBucket filter = new RelationPredicateBucket(CarrierBundleFields.Date <= span);
adapter.FetchEntityCollection(allBundles, filter);
//...Using AutoMapper
**Mapper**.CreateMap<UtilityWebSite.Models.CarrierBundleModel, ZoomAudits.DAL.EntityClasses.CarrierBundleEntity>();
List<UtilityWebSite.Models.CarrierBundleModel> viewModelList = Mapper.Map<List<ZoomAudits.DAL.EntityClasses.CarrierBundleEntity>, List<UtilityWebSite.Models.CarrierBundleModel>>(allBundles);
return Json(viewModelList.ToDataSourceResult(request));
//...Not using AutoMapper
List<UtilityWebSite.Models.CarrierBundleModel> viewBundles = new List<UtilityWebSite.Models.CarrierBundleModel>();
foreach (ZoomAudits.DAL.EntityClasses.CarrierBundleEntity entityBundle in **EntityCollection**)
{
UtilityWebSite.Models.CarrierBundleModel model = new UtilityWebSite.Models.CarrierBundleModel();
model.BundleID = entityBundle.BundleId;
model.CarrierId = entityBundle.CarrierId;
viewBundles.Add(model);
}
return Json(viewBundles.ToDataSourceResult(request));
}
您面临的一个问题是您的数据实体对象需要与模型对象分开。最初，这似乎比需要的工作还要多，但是随着应用程序的增长，您将看到复制类的好处。这就是我的解决方法。
在您的LLBLGEN域类中
namespace ZoomAudits.DAL.EntityClasses
{
public class CarrierBundleEntity
{
//....Whatever is generated as your Bundle object from the DB
}
}
在您的模型MVC文件夹中
namespace MyProjectNamespace.Models
{
public class CarrierBundleModel
{
[Required]
[Display(Name = "Bundle ID")]
public int BundleID{get;set;}
[Required]
[Display(Name = "Bundle Name")]
public int BundleName{get;set;}
//...Other properties you will use in the UI That match the LLBLGen Bundle class
}
}
在您的控制器动作中
[HttpPost]
public ActionResult BundleStatusRead([DataSourceRequest] DataSourceRequest request)
{
var span = DateTime.Today.AddDays(-1);
DataAccessAdapter adapter = new DataAccessAdapter();
EntityCollection allBundles = new EntityCollection(new CarrierBundleEntityFactory());
RelationPredicateBucket filter = new RelationPredicateBucket(CarrierBundleFields.Date <= span);
adapter.FetchEntityCollection(allBundles, filter);
//...Using AutoMapper
Mapper.CreateMap<MyProjectNamespace.Models.CarrierBundleModel, ZoomAudits.DAL.EntityClasses.CarrierBundleEntity>();
List<MyProjectNamespace.Models.CarrierBundleModel> viewModelList =Mapper.Map<List<ZoomAudits.DAL.EntityClasses.CarrierBundleEntity>, List<MyProjectNamespace.Models.CarrierBundleModel>>(allBundles);
return Json(viewModelList.ToDataSourceResult(request));
//...Not using AutoMapper
List<MyProjectNamespace.Models.CarrierBundleModel> viewBundles=new List<MyProjectNamespace.Models.CarrierBundleModel>();
foreach(ZoomAudits.DAL.EntityClasses.CarrierBundleEntity entityBundle in allBundles)
{
MyProjectNamespace.Models.CarrierBundleModel model=new MyProjectNamespace.Models.CarrierBundleModel();
model.BundleID=entityBundle.BundleId;
model.CarrierId=entityBundle.CarrierId;
viewBundles.Add(model);
}
return Json(viewBundles.ToDataSourceResult(request));
}
在您看来
@(Html.Kendo().Grid<MyProject.Models.CarrierBundleModel>()
注意：我使用AutoMapper，这是一个很棒的映射库，您可以将其添加到项目中，并且如果模型与实体数据类型和名称之间存在一对一的匹配，则无需编写翻译。还有其他可用的映射工具。我只是为了向您展示从DAL实体转换为Model的替代快捷方式。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句