示例#1
0
        public static XmlDocument CountryToXML(Country country)
        {
            StringBuilder sb = new StringBuilder();
            XmlWriter writer = XmlWriter.Create(sb);

            writer.WriteStartDocument();
            writer.WriteStartElement("country");

            writer.WriteStartElement("field");
            writer.WriteAttributeString("zero_x", country.field.zero_x.ToString());
            writer.WriteAttributeString("zero_y", country.field.zero_y.ToString());
            writer.WriteAttributeString("size_x", country.field.size_x.ToString());
            writer.WriteAttributeString("size_y", country.field.size_y.ToString());

            foreach (VegetableOnField veg in country.field.vegetables)
            {
                writer.WriteStartElement(veg.VegetableNameID.ToString());
                writer.WriteAttributeString("id", veg.id.ToString());
                writer.WriteAttributeString("x", veg.x.ToString());
                writer.WriteAttributeString("y", veg.y.ToString());
                writer.WriteAttributeString("growstage", veg.growstage.ToString());
                writer.WriteEndElement();
            }

            writer.WriteEndElement();
            writer.WriteEndElement();
            writer.WriteEndDocument();

            writer.Flush();

            XmlDocument xmlDocument = new XmlDocument();
            xmlDocument.LoadXml(sb.ToString());
            return xmlDocument;
        }
示例#2
0
文件: FarmDB.cs 项目: AndreyHub/Farm
        public static Country GetCountry(int FieldID)
        {
            Country country = new Country();
            Field field = new Field();

            SqlParameter paramFieldID = CreateSqlParam(SqlQueriesConst.ParamFieldID, DBNull.Value, SqlDbType.Int);
            paramFieldID.Value = 1;

            DataTable dt = GetSqlQueryDataTable(Connection, Queries.GetField, new SqlParameter[] { paramFieldID });

            if (dt != null && dt.Rows.Count > 0)
            {
                field.Populate(dt.Rows[0]);
            }
            field.vegetables = GetAllVegetablesOnField(FieldID);

            country.field = field;

            return country;
        }