日期:2014-05-20 浏览次数:20960 次
                var query = from order in orders.AsEnumerable()
                            orderby order.Field<int>("Status") ascending, order.Field<DateTime>("CreateOn") descending
                            select new
                            {
                                OrderID = order.Field<int>("OrderID"),
                                ProductName = order.Field<string>("ProductName"),
                                Price = order.Field<decimal>("Price"),
                                Count = order.Field<int>("Count"),
                                Status = order.Field<int>("Status"),
                                PayMoney = order.Field<decimal>("PayMoney"),
                                PayDate = order.Field<DateTime>("PayDate"),
                                CheckName = order.Field<string>("CheckName"),
                                Tel = order.Field<string>("Tel"),
                                CheckAddress = order.Field<string>("CheckAddress"),
                                Freight = order.Field<int>("Freight")
                            };