public WriteLocalities ( OracleCommand oCmd ) : void | ||
oCmd | OracleCommand | |
Результат | void |
public void WriteLocalities(OracleCommand oCmd)
{
oCmd.CommandText = "select * from Table";
oCmd.CommandType = CommandType.Text;
OracleDataReader oDataReader = oCmd.ExecuteReader();
while (oDataReader.Read()) {
WriteStartElement("locality");
_oXmlWriter.WriteAttributeString("id", oDataReader["id"].ToString());
_oXmlWriter.WriteElementString("name", oDataReader["name"].ToString());
_oXmlWriter.WriteElementString("state_id", oDataReader["state_id"].ToString());
_oXmlWriter.WriteElementString("type", oDataReader["type"].ToString());
WriteEndElement();
}
}
public static void Main(String[] args) { DateTime oScriptStart = DateTime.UtcNow; NameValueCollection oVipSettings = new NameValueCollection(); NameValueCollection oXmlSettings = ConfigurationManager.GetSection("xmlWriterSettings") as NameValueCollection; //NameValueCollection oElectionAdminSettings = ConfigurationManager.GetSection("electionOfficial") as NameValueCollection; oVipSettings.Add("ScriptStart", oScriptStart.ToString("yyyy-MM-ddTHH:mm:ss")); oVipSettings.Add(ConfigurationManager.GetSection("vipSettings") as NameValueCollection); FeedWriter oFeedWriter = new FeedWriter( oVipSettings.Get("FilePath"), oVipSettings.Get("StateFIPS"), oXmlSettings ); oFeedWriter.WriteStartElement("vip_object"); oFeedWriter.WriteHeader(oVipSettings); // this may not be necessary if the election_officials are stored in the db //oFeedWriter.WriteElementFromConfig("election_official", oElectionAdminSettings); try { oFeedWriter.WritePollingPlaces(); oFeedWriter.WriteStreetSegments(); oFeedWriter.WritePrecincts(); oFeedWriter.WritePrecinctSplits(); oFeedWriter.WriteLocalities(); } catch (Exception ex) { // TODO: Write success or failure to a text file Console.WriteLine(ex.Message.ToString()); } oFeedWriter.WriteEndElement(); }