dsLinq.Count() 引发了“System.NullReferenceException”类型的异常
2024-08-29 21:24:25
DataTable dt = PurchaseArriveInfoBus.GetPurchaseArriveInfo(companyCD, txtArriveNo, txtTitle, txtProvider);
XElement dsXML = ConvertDataTableToXML(dt);
//linq排序
var dsLinq =
(order == "ascending") ?
(from x in dsXML.Descendants("Data")
orderby x.Element(orderBy).Value ascending
select new DataSourceModel()
{
ID = x.Element("ID").Value,
ArriveNo = x.Element("ArriveNo").Value,
Title = x.Element("Title").Value,
ProviderID = x.Element("ProviderName").Value,
Purchaser = x.Element("Purchaser").Value,
ProductNo = x.Element("ProductNo").Value,
ProductName = x.Element("ProductName").Value,
ColorName = x.Element("ColorName").Value, TotalPrice = x.Element("TotalPrice").Value,
ProductCount = x.Element("ProductCount").Value,
InCount = x.Element("InCount").Value,
DetailID = x.Element("DetailID").Value,
UnitName = x.Element("UnitName").Value,
JiBenCount = x.Element("JiBenCount").Value,
UnitPrice = IsDisplayPrice ? x.Element("UnitPrice").Value : "0.000000" })
:
(from x in dsXML.Descendants("Data")
orderby x.Element(orderBy).Value descending
select new DataSourceModel()
{
ID = x.Element("ID").Value,
ArriveNo = x.Element("ArriveNo").Value,
Title = x.Element("Title").Value,
ProviderID = x.Element("ProviderName").Value,
Purchaser = x.Element("Purchaser").Value,
ProductNo = x.Element("ProductNo").Value,
ProductName = x.Element("ProductName").Value,
ColorName = x.Element("ColorName").Value, TotalPrice = x.Element("TotalPrice").Value,
ProductCount = x.Element("ProductCount").Value,
InCount = x.Element("InCount").Value,
DetailID = x.Element("DetailID").Value,
UnitName = x.Element("UnitName").Value,
JiBenCount = x.Element("JiBenCount").Value,
UnitPrice = IsDisplayPrice ? x.Element("UnitPrice").Value : "0.000000"
});
int totalCount = dsLinq.Count();
dsLinq.Count() 引发了“System.NullReferenceException”类型的异常,其中任何字段都不能为null
最新文章
- SQL Server游标的使用【转】
- Nginx+Lua+Redis 对请求进行限制
- android source
- 关于 Python Iterator 协议的一点思考
- 打印机C++
- Akka Stream文档翻译:Quick Start Guide: Reactive Tweets
- Python属性、方法和类管理系列之----属性初探
- node.js(六) UTIL模块
- Technology_Roadmap
- Ubuntu Linux系统下的SVN客户端工具PySVN
- DOM元素拖拽效果
- msf入门学习笔记
- kerberos下JAVA代码操作hbase的方式(客户端方式,应用程序方式)
- 在腾讯云的ubuntu服务器上面安装git服务器
- 文件操作(open\read\write\close)
- VS 2013+ ArcGIS 10.3 AddIn 断点不断异常解决
- 获取多<;a/>;标签id值的点击事件
- 《ASP.NET Core In Action》读书笔记系列五 ASP.NET Core 解决方案结构解析1
- 第26月第25天 ubuntu openjdk-8-jdk jretty
- EntityFramework 优化建议(转)
热门文章
- 3D Computer Grapihcs Using OpenGL - 19 Vertex Array Object(顶点数组对象)
- 超实用的PHP代码片段!
- CDH搭建和集成spark、kafka操作
- sqli-lab(15)
- Access to the requested object is only available from the local network phpmyadmin
- gsensor架构和原理分析【转】
- 淘淘相关工具类【json,httpClient,id,FTP,exception,cookie(包括共享cookie的设置等)】
- 阶段2 JavaWeb+黑马旅游网_15-Maven基础_第3节 maven标准目录结构和常用命令_07maven常用命令
- Unity3D(C#)连接SQL Server2008
- cocos2dx基础篇(18) 数据存储CCUserDefault