C# (CSharp) eu.sig.training.ch02 Query.AddColumn示例

AddColumn() public method

public AddColumn ( string s ) : Query
s	string
return	Query

示例#1

文件： Employees.cs 项目： ishara/building_maintainable_software

 // tag::printDepartmentEmployees[]
 public static void PrintDepartmentEmployees(string department) {
     Query q = new Query();
     foreach (Employee e in q.AddColumn("FamilyName")
         .AddColumn("Initials")
         .AddColumn("GivenName")
         .AddColumn("AddressLine1")
         .AddColumn("ZIPcode")
         .AddColumn("City")
         .AddTable("EMPLOYEES")
         .AddWhere("EmployeeDep='" + department + "'")
         .Execute()) {
         Console.WriteLine("<div name='addressDiv'" + e.FamilyName
             + ", " + e.Initials + "<br />" + e.AddressLine1
             + "<br />" + e.ZipCode + e.City + "</div>");
     }
 }

示例#2

文件： Employees.cs 项目： oreillymedia/building_maintainable_software

 // tag::printDepartmentEmployees[]
 public static void PrintDepartmentEmployees(string department)
 {
     Query q = new Query();
     foreach (Employee e in q.AddColumn("FamilyName")
         .AddColumn("Initials")
         .AddColumn("GivenName")
         .AddColumn("AddressLine1")
         .AddColumn("ZIPcode")
         .AddColumn("City")
         .AddTable("EMPLOYEES")
         .AddWhere($"EmployeeDep='{department}'")
         .Execute())
     {
         Console.WriteLine($@"<div name='addressDiv'>
             {e.FamilyName}, {e.Initials}<br />" +
             "{e.AddressLine1}<br />{e.ZipCode}{e.City}</div>");
     }
 }

示例#3

        // tag::printDepartmentEmployees[]
        public static void PrintDepartmentEmployees(string department)
        {
            Query q = new Query();

            foreach (Employee e in q.AddColumn("FamilyName")
                     .AddColumn("Initials")
                     .AddColumn("GivenName")
                     .AddColumn("AddressLine1")
                     .AddColumn("ZIPcode")
                     .AddColumn("City")
                     .AddTable("EMPLOYEES")
                     .AddWhere($"EmployeeDep='{department}'")
                     .Execute())
            {
                Console.WriteLine($@"<div name='addressDiv'>
                    {e.FamilyName}, {e.Initials}<br />" +
                                  "{e.AddressLine1}<br />{e.ZipCode}{e.City}</div>");
            }
        }

示例#4

文件： Employees.cs 项目： wilecoyote1/building_maintainable_software

        // tag::printDepartmentEmployees[]
        public static void PrintDepartmentEmployees(string department)
        {
            Query q = new Query();

            foreach (Employee e in q.AddColumn("FamilyName")
                     .AddColumn("Initials")
                     .AddColumn("GivenName")
                     .AddColumn("AddressLine1")
                     .AddColumn("ZIPcode")
                     .AddColumn("City")
                     .AddTable("EMPLOYEES")
                     .AddWhere("EmployeeDep='" + department + "'")
                     .Execute())
            {
                Console.WriteLine("<div name='addressDiv'" + e.FamilyName
                                  + ", " + e.Initials + "<br />" + e.AddressLine1
                                  + "<br />" + e.ZipCode + e.City + "</div>");
            }
        }