public override bool select()
{
if (!isValid(new List<string>() { "pID", "lContent", "lMapLayerName", "lIsChoosed"}))
return false;
string sqlCommand = String.Format(@"select * from Label where lID={0}", lID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectLabel(sqlCommand);
this.initBySqlDataReader(reader);
sql.closeConnection();
return true;
}
public static Label GetLabelByMapLayerName(string mapLayerName)
{
string sqlCommand = String.Format(@"select * from Label where lMapLayerName='{0}'", mapLayerName);
Sql sql = new Sql();
SqlDataReader reader = sql.selectLabelByMapLayerName(sqlCommand);
Label label = new Label();
label.initBySqlDataReader(reader);
sql.closeConnection();
return label;
}
public override bool select()
{
if (!isValid(new List<string>() { "prID", "vName", "vBoundary", "vInUse" }))
return false;
string sqlCommand = String.Format("select * from Village where vID={0}", vID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectVillage(sqlCommand);
initBySqlDataReader(reader);
sql.closeConnection();
return true;
}
public ObservableCollection<House> getAllRelatedHouse()
{
if (!isValid(new List<string>() { "prID", "vName", "vBoundary", "vInUse" }))
return null;
ObservableCollection<House> houseList = new ObservableCollection<House>();
string sqlCommand = String.Format("select hID from House where vID={0}", vID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectHouseIDByVID(sqlCommand);
if (reader.HasRows)
{
while (reader.Read())
{
int hID = Int32.Parse(reader[0].ToString());
House house = new House();
house.id = hID;
house.select();
houseList.Add(house);
}
sql.closeConnection();
return houseList;
}
else
{
sql.closeConnection();
return null;
}
}
public ObservableCollection<InnerRoad> getAllRelatedInnerRoad()
{
if (!isValid(new List<string>() { "prName", "pID" }))
return null;
ObservableCollection<InnerRoad> innerRoadList = new ObservableCollection<InnerRoad>();
string sqlCommand = String.Format(@"select irID from InnerRoad where prID={0}", prID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectAllInnerRoadByPrID(sqlCommand);
if (reader.HasRows)
{
while (reader.Read())
{
int irID = Int32.Parse(reader[0].ToString());
InnerRoad innerRoad = new InnerRoad();
innerRoad.id = irID;
innerRoad.select();
innerRoadList.Add(innerRoad);
}
sql.closeConnection();
return innerRoadList;
}
else
{
sql.closeConnection();
return null;
}
}
public override bool select()
{
if (chID == C.ERROR_INT)
return false;
string sqlCommand = String.Format("select * from CommonHouse where chID={0}", chID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectCommonHouse(sqlCommand);
initBySqlDataReader(reader);
sql.closeConnection();
return true;
}
public ObservableCollection<Condition> getAllRelatedCondition()
{
if (!isValid(new List<string>() { "prName", "pID" }))
return null;
ObservableCollection<Condition> conditionList = new ObservableCollection<Condition>();
string sqlCommand = String.Format("select cdID from Condition where prID={0}", prID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectConditionIDByPrID(sqlCommand);
while (reader.Read())
{
int cdID = Int32.Parse(reader[0].ToString());
Condition condition = new Condition();
condition.id = cdID;
condition.select();
conditionList.Add(condition);
}
sql.closeConnection();
return conditionList;
}
public override bool select()
{
if (!isValid(new List<string> { "nsWidth", "nsHeight", "prID"}))
return false;
string sqlCommand = String.Format(@"select * from NetSize where nsID={0}", nsID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectNetSize(sqlCommand);
if (!reader.HasRows)
return false;
initBySqlDataReader(reader);
sql.closeConnection();
return true;
}
public override bool select()
{
if (!isValid(new List<string>() { "fInUse", "fScore", "prID" }))
return false;
string sqlCommand = String.Format("select * from Feature where fID={0}", fID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectFeature(sqlCommand);
reader.Read();
InitBySqlDataReader(reader);
sql.closeConnection();
return true;
}
public override bool select()
{
if (!isValid(new List<string>() { "prName", "pID" }))
return false;
string sqlCommand = String.Format("select * from Program where prID={0}", prID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectProgram(sqlCommand);
reader.Read();
InitBySqlDataReader(reader);
sql.closeConnection();
return true;
}
public ObservableCollection<Label> getAllRelatedLabel()
{
if (!isValid())
return null;
ObservableCollection<Label> labelList = new ObservableCollection<Label>();
string sqlCommand = String.Format("select lID from Label where pID = {0}", pID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectAllLabelIDByPID(sqlCommand);
while (reader.Read())
{
int lID = Int32.Parse(reader[0].ToString());
Label label = new Label();
label.id = lID;
label.select();
labelList.Add(label);
}
sql.closeConnection();
return labelList;
}
public ObservableCollection<Program> getAllRelatedProgram()
{
if (!isValid())
return null;
ObservableCollection<Program> programList = new ObservableCollection<Program>();
string sqlCommand = String.Format("select prID from Program where pID = {0}", pID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectProgramIDByPmID(sqlCommand);
while (reader.Read())
{
int prID = Int32.Parse(reader[0].ToString());
Program program = new Program();
program.id = prID;
program.select();
programList.Add(program);
}
sql.closeConnection();
return programList;
}
public override bool select()
{
if (!isValid(new List<string>() { "pName", "pPath", "pBaseMapIndex" }))
return false;
string sqlCommand = String.Format("select * from Project where pID={0}", pID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectProjectAndMap(sqlCommand);
reader.Read();
id = Int32.Parse(reader[0].ToString());
name = reader[1].ToString();
path = reader[2].ToString();
baseMapIndex = Int32.Parse(reader[3].ToString());
sql.closeConnection();
return true;
}
public override bool select()
{
if (cpsID == C.ERROR_INT)
return false;
string sqlCommand = String.Format("select * from CityPlanStandard where cpsID = {0}", cpsID.ToString());
Sql sql = new Sql();
SqlDataReader reader = sql.selectCityPlanStandard(sqlCommand);
reader.Read();
cpsID = Int32.Parse(reader[0].ToString());
cpsNumber = reader[1].ToString();
cpsShortDescription = reader[2].ToString();
cpsLongDescription = reader[3].ToString();
sql.closeConnection();
return true;
}
public ObservableCollection<Village> getAllRelatedVillage()
{
if (!isValid(new List<string>() { "prName", "pID" }))
return null;
ObservableCollection<Village> villageList = new ObservableCollection<Village>();
string sqlCommand = String.Format(@"select vID from Village where prID={0}", prID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectAllVillageByPrID(sqlCommand);
if (reader.HasRows)
{
while (reader.Read())
{
int vID = Int32.Parse(reader[0].ToString());
Village village = new Village();
village.id = vID;
village.select();
villageList.Add(village);
}
sql.closeConnection();
return villageList;
}
else
{
sql.closeConnection();
return null;
}
}
public override bool select()
{
if (!isValid(new List<string>() { "prID", "mrName", "mrPath" }))
return false;
string sqlCommand = String.Format(@"select * from MainRoad where mrID={0}", mrID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectMainRoad(sqlCommand);
initBySqlDataReader(reader);
sql.closeConnection();
return true;
}
public override bool select()
{
if (!isValid(new List<string>() { "prID", "cdID", "cfValue" }))
return false;
string sqlCommand = String.Format("select * from Config where cfID={0}", cfID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectConfig(sqlCommand);
reader.Read();
InitBySqlDataReader(reader);
sql.closeConnection();
return true;
}