internal static void buildAttribute(List <SUrl> _suList, List <SUrlAttribute> _attrList)
{
for (int index = 0; index < _suList.Count; index++)
{
SUrl url = _suList[index];
for (int inx = 0; inx < _attrList.Count; inx++)
{
SUrlAttribute attr = _attrList[inx];
if (attr.UrlCode == url.Code)
{
url.Attrs.Add(attr);
_attrList.RemoveAt(inx--);
}
}
}
}
public static List <SUrlAttribute> FetchObject(MysqlDBHelper helper)
{
initMap();
List <SUrlAttribute> rtnResult = new List <SUrlAttribute>();
String cmdString = buildQueryCmd();
MySqlCommand cmd = new MySqlCommand(cmdString, helper.DbConnector);
//查询结果读取器
MySqlDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
SUrlAttribute cfg = new SUrlAttribute();
for (int index = 0; index < MapList.Count; index++)
{
Attr2FieldMap map = MapList[index];
Attr2FieldMap.setValue(cfg, reader[index], map.Attrbute);
}
rtnResult.Add(cfg);
}
}
catch (Exception ex)
{
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(rtnResult);
}
