public CommonHouse selectRelatedCommonHouse()
{
if (!isValid(new List<string>() { "prName", "pID" }))
return null;
CommonHouse commonHouse = new CommonHouse();
string sqlCommand = String.Format("select chID from CommonHouse where prID={0}", prID);
Sql sql = new Sql();
int chID = sql.selectCommonHouseIDByPrID(sqlCommand);
if (chID == -1)
return null;
commonHouse.id = chID;
commonHouse.select();
return commonHouse;
}