background image


userId = "0001",
userName = "guoHu",
gender="Man",
age=25,education="underGraduate",
workExperience = WorkExperience.GetWorkExperience("0001")
}
};
 
}
}
[Serializable]

public

 

class

 WorkExperience

{

public

 string userId { get; set; }

public

 string companyName { get; set; }

public

 string seniority { get; set; }

 

public

 

static

 List<WorkExperience> GetWorkExperience(string userId)

{
List<WorkExperience> workExperience = 

new

 List<WorkExperience>();

Unity unity = Unity.GetInstance();
DataTable table = 

new

 DataTable();

unity.GetTable(out table);
 

var

 experiences = (from experience in table.AsEnumerable()

where experience.Field<string>("UserId") == userId
select 

new

{
companyName = experience.Field<string>("CompanyName"),
seniority = experience.Field<string>("Seniority")
}).ToList();
experiences.ForEach(e => workExperience.Add(

new

 WorkExperience() { companyName = 

e.companyName, seniority = e.seniority }));

return

 workExperience;

}
}

public

 

class

 Unity

{

public

 

static

 DataTable tables = 

new

 DataTable();

public

 

static

 DataRow dr;

public

 

static

 DataColumn dc = 

new

 DataColumn();