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

最新文章

  1. SQL Server游标的使用【转】
  2. Nginx+Lua+Redis 对请求进行限制
  3. android source
  4. 关于 Python Iterator 协议的一点思考
  5. 打印机C++
  6. Akka Stream文档翻译:Quick Start Guide: Reactive Tweets
  7. Python属性、方法和类管理系列之----属性初探
  8. node.js(六) UTIL模块
  9. Technology_Roadmap
  10. Ubuntu Linux系统下的SVN客户端工具PySVN
  11. DOM元素拖拽效果
  12. msf入门学习笔记
  13. kerberos下JAVA代码操作hbase的方式(客户端方式,应用程序方式)
  14. 在腾讯云的ubuntu服务器上面安装git服务器
  15. 文件操作(open\read\write\close)
  16. VS 2013+ ArcGIS 10.3 AddIn 断点不断异常解决
  17. 获取多<a/>标签id值的点击事件
  18. 《ASP.NET Core In Action》读书笔记系列五 ASP.NET Core 解决方案结构解析1
  19. 第26月第25天 ubuntu openjdk-8-jdk jretty
  20. EntityFramework 优化建议(转)

热门文章

  1. 3D Computer Grapihcs Using OpenGL - 19 Vertex Array Object(顶点数组对象)
  2. 超实用的PHP代码片段!
  3. CDH搭建和集成spark、kafka操作
  4. sqli-lab(15)
  5. Access to the requested object is only available from the local network phpmyadmin
  6. gsensor架构和原理分析【转】
  7. 淘淘相关工具类【json,httpClient,id,FTP,exception,cookie(包括共享cookie的设置等)】
  8. 阶段2 JavaWeb+黑马旅游网_15-Maven基础_第3节 maven标准目录结构和常用命令_07maven常用命令
  9. Unity3D(C#)连接SQL Server2008
  10. cocos2dx基础篇(18) 数据存储CCUserDefault