Employees.TBL.Delete(Employees._FirstName =="Fan");

     数据查询

      System.Collections.IList lst = Orders.TBL.Where(
         Orders._OrderDate >= DateTime.Parse("1997-1-1")&
         Orders._OrderDate < DateTime.Parse("1997-8-1")
         ).SelectObject();
     foreach(Orders item in lst)
     {
         Console.WriteLine(item.OrderID);
     }

     统计查询

     System.Data.DataSet ds = Orders.TBL.INNER(OrderDetails.TBL,OrderDetails._OrderID)
         .Where(Orders._OrderDate >= DateTime.Parse("1997-8-1"))
        .OrderBy(Orders._EmployeeID.DESC)
        .GroupBy(Orders._EmployeeID)
     .Select(SqlMath.Sum(OrderDetails._Quantity*OrderDetails._UnitPrice*(1-OrderDetails._Discount)).As("account"),Orders._EmployeeID);
     foreach(System.Data.DataRow row in ds.Tables[0].Rows)
     {
        Console.WriteLine(row["account"]);
    

上一页  [1] [2] [3] [4] [5] [6] 下一页