Flex读取XML文件内容，和webservice交互

这段时间学了点Flex的东西，做了个案例：

 

 1<?xml version="1.0" encoding="utf-8"?>
 2<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" backgroundAlpha="0" initialize="myService.send();" fontSize="13">
 3    <mx:Script>
 4      <![CDATA[
 5          import mx.controls.Alert;
 6          import mx.rpc.events.ResultEvent;
 7          import mx.collections.ArrayCollection;
 8          
 9          private function resultHandler(event:ResultEvent):void {
            WS.wsdl = event.result.WebServiceUrl.LocalUrl.value;
            WS.GetProductGroup.send();
        }
          private function SetStock(e:ResultEvent):void
        {
            areachart1.dataProvider = e.result as ArrayCollection;
            WS.GetPriceFromGroup.send();
        }
        private function SetPrice(e:ResultEvent):void
        {
            line1.dataProvider = e.result as ArrayCollection;
        }
        private function BindComboBox(e:ResultEvent):void
        {
            cbxProductID.dataProvider = e.result as ArrayCollection;
            WS.GetStockFromProductGroup.send();
        }
        private function BindAreaChart():void
        {
            WS.GetStockFromProductGroup.send();//Alert.show(cbxProductID.selectedItem.ProductID.toString());
        }
      ]]>
  </mx:Script>
    <mx:Panel y="43" width="100%" height="100%" backgroundAlpha="0" layout="absolute" horizontalCenter="0" fontSize="12"
         title="LME、SHFE、Comex、LME三月价格叠加图表">
        <mx:AreaChart y="0" id="areachart1" height="100%" width="100%" fontSize="12" x="0">
            <mx:horizontalAxis>
                <!--<mx:CategoryAxis categoryField="LmeTDate"/>-->
                <mx:DateTimeAxis dataUnits="days" displayLocalTime="true" interval="70" />
            </mx:horizontalAxis>
            <mx:verticalAxis>
                <mx:LinearAxis title=""/>
            </mx:verticalAxis>
            <mx:secondVerticalAxis>
                <mx:LinearAxis title=""/>
            </mx:secondVerticalAxis>
            <mx:series>
                <mx:AreaSeries displayName="LME库存" yField="LMEStock" xField="Date"/>
                <mx:AreaSeries displayName="Comex库存" yField="ComexStock" xField="Date"/>
                <mx:AreaSeries displayName="SHFE库存" yField="SHFEStock" xField="Date"/>
            </mx:series>
            <mx:secondSeries>
                <mx:LineSeries id="line1" yField="Price" xField="Date" form="curve" displayName="LME三月价格">
                    <mx:lineStroke>
                <mx:Stroke weight="1" alpha="1"/>
             </mx:lineStroke>
                </mx:LineSeries>
            </mx:secondSeries>
        </mx:AreaChart>
        <mx:Legend dataProvider="{areachart1}" y="10" direction="vertical" fontSize="35" fontWeight="normal"
             alpha="1.0" backgroundAlpha="1.0" cornerRadius="0" borderStyle="none" fontFamily="Verdana" x="80"/>
    </mx:Panel>
    <mx:HTTPService id="myService" url="WebServiceUrl.xml" result="{resultHandler(event);}"/>
    <mx:WebService id="WS" fault="Alert.show(event.fault.faultString, 'Error')" showBusyCursor="true">
        <mx:operation name="GetProductGroup" resultFormat="object" result="BindComboBox(event);"/>
        <mx:operation name="GetStockFromProductGroup" resultFormat="object" result="SetStock(event);">
            <mx:request xmlns="">
                <ProductGroup>
                    {cbxProductID.selectedItem.Group}
                </ProductGroup>
            </mx:request>
        </mx:operation>
        <mx:operation name="GetPriceFromGroup" resultFormat="object" result="SetPrice(event);">
            <mx:request xmlns="">
                <group>
                    {cbxProductID.selectedItem.Group}
                </group>
            </mx:request>
        </mx:operation>
    </mx:WebService>
    <mx:ComboBox x="84" y="10" id="cbxProductID" change="BindAreaChart();" labelField="ProductName"
         openDuration="250" closeDuration="250"></mx:ComboBox>
    <mx:Label x="0" y="13" text="请选择产品:"/>
</mx:Application>

 

下面是webservice代码：

 

  1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Web;
  6using System.Web.Services;
  7using System.Web.Services.Protocols;
  8using System.Data.OleDb;
  9using System.Data.SqlClient;
 10using FDPS.Entity;
 11using FDPS.Provider.Factory;
 12using FDPS.Provider.SqlClient;
 13using System.Collections.Generic;
 14
 15namespace FlexDataProvideService.WebService
 16{
 17    /**//// <summary>
 18    /// FirstFlexAppData 的摘要说明
 19    /// </summary>
 20    [WebService(Namespace = "http://tempuri.org/")]
 21    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
 22    [ToolboxItem(false)]
 23    // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
 24    // [System.Web.Script.Services.ScriptService]
 25    public class FirstFlexAppData : System.Web.Services.WebService
 26    {
 27
 28        [WebMethod]
 29        public string HelloWorld()
 30        {
 31            return "Hello World";
 32        }
 33
 34        获取上海/LME铜比价#region 获取上海/LME铜比价
 35        [WebMethod]
 36        [System.Xml.Serialization.XmlInclude(typeof(TongBiJia))]
 37        public ArrayList GetDataSetToArray()
 38        {
 39            SqlQuery sql = new SqlQuery();
 40            sql.TableName = new LineChartDateEntity().TableName;
 41            sql.SqlReturnField = "*";
 42            sql.SqlOrderField = "ID";
 43            sql.OrderType = false;
 44            List<SqlParam> _param = new List<SqlParam>();
 45            _param.Add(new SqlParam("@ParentID", DbType.Int32, 1));
 46            sql.SqlWhere = "1=1";
 47            sql.Param = _param;
 48            DataSet ds = DataFactory<LineChartDateSqlProvider>.CreateProvider.GetFieldsDataSet(sql);
 49            ArrayList al = new ArrayList();
 50            DateTime dt;
 51            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
 52            {
 53                TongBiJia tbj = new TongBiJia();
 54                tbj.CjtDate = ds.Tables[0].Rows[i]["CjtDate"].ToString().Trim();
 55                tbj.CjtPrice = ds.Tables[0].Rows[i]["CjtPrice"].ToString().Trim();
 56
 57                dt = Convert.ToDateTime(ds.Tables[0].Rows[i]["LmeTDate"].ToString().Trim());
 58                tbj.LmeTDate = dt.Year + "/" + dt.Month + "/" + dt.Day;
 59                tbj.LmeTPrice = ds.Tables[0].Rows[i]["LmeTPrice"].ToString().Trim();
 60                tbj.BJ = ds.Tables[0].Rows[i]["BJ"].ToString().Trim();
 61                al.Add(tbj);
 62            }
 63            return al;
 64        }
 65        #endregion
 66
 67        根据产品ID获取库存数据#region 根据产品ID获取库存数据
 68        [WebMethod]
 69        [System.Xml.Serialization.XmlInclude(typeof(Stock))]
 70        public ArrayList GetStockArray(string productid)
 71        {
 72            GetStockFromProductIDEntity se = new GetStockFromProductIDEntity();
 73            se.ProductID = int.Parse(productid);
 74            DataSet ds = StoreProcedureProvider<GetStockFromProductIDEntity>.ExecStoreProcduce(se);
 75            ArrayList al = new ArrayList();
 76            DateTime dt;
 77            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
 78            {
 79                Stock sk = new Stock();
 80                dt = Convert.ToDateTime(ds.Tables[0].Rows[i]["Date"].ToString().Trim());
 81                sk.Date = dt.Year + "/" + dt.Month + "/" + dt.Day;
 82                sk.Open = ds.Tables[0].Rows[i]["Open"].ToString().Trim();
 83                sk.High = ds.Tables[0].Rows[i]["High"].ToString().Trim();
 84                sk.Low = ds.Tables[0].Rows[i]["Low"].ToString().Trim();
 85                sk.Last = ds.Tables[0].Rows[i]["Last"].ToString().Trim();
 86                sk.ProductName = ds.Tables[0].Rows[i]["ProductName"].ToString().Trim();
 87                sk.MarketName = ds.Tables[0].Rows[i]["MarketName"].ToString().Trim();
 88                al.Add(sk);
 89            }
 90            return al;
 91        }
 92        #endregion
 93
 94        获取产品组和名称#region 获取产品组和名称
 95        [WebMethod]
 96        [System.Xml.Serialization.XmlInclude(typeof(ProductGroup))]
 97        public ArrayList GetProductGroup()
 98        {
 99            SqlQuery sql = new SqlQuery();
            sql.TableName = new ProductEntity().TableName;
            sql.SqlReturnField = "distinct ProductName,[Group],[Order]";
            sql.SqlOrderField = "[Order]";
            sql.OrderType = true;
            List<SqlParam> _param = new List<SqlParam>();
            _param.Add(new SqlParam("@ParentID", DbType.Int32, 1));
            sql.SqlWhere = "1=1";
            sql.Param = _param;
            DataSet ds = DataFactory<ProductSqlProvider>.CreateProvider.GetFieldsDataSet(sql);
            ArrayList al = new ArrayList();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                ProductGroup pe = new ProductGroup();
                pe.ProductName = ds.Tables[0].Rows[i]["ProductName"].ToString().Trim();
                pe.Group = ds.Tables[0].Rows[i]["Group"].ToString().Trim();
                al.Add(pe);
            }
            return al;
        }
        #endregion

        根据产品组获取价格#region 根据产品组获取价格
        [WebMethod]
        [System.Xml.Serialization.XmlInclude(typeof(PriceGroup))]
        public ArrayList GetPriceFromGroup(string group)
        {
            DataSet ds = DataFactory<PriceSqlProvider>.CreateProvider.GetPriceFromGroup(group);
            ArrayList al = new ArrayList();
            DateTime dt;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                PriceGroup pe = new PriceGroup();
                dt = Convert.ToDateTime(ds.Tables[0].Rows[i]["Date"].ToString().Trim());
                pe.Date = dt.Year + "/" + dt.Month + "/" + dt.Day;
                pe.Price = ds.Tables[0].Rows[i]["Last"].ToString().Trim();
                al.Add(pe);
            }
            return al;
        }
        #endregion

        根据产品分组获取SHFE、LME、Comex产品库存#region 根据产品分组获取SHFE、LME、Comex产品库存
        [WebMethod]
        [System.Xml.Serialization.XmlInclude(typeof(LmeShfeComex))]
        public ArrayList GetStockFromProductGroup(string ProductGroup)
        {
            GetStockFromProductGroupEntity se = new GetStockFromProductGroupEntity();
            se.Group = ProductGroup;
            DataSet ds = StoreProcedureProvider<GetStockFromProductGroupEntity>.ExecStoreProcduce(se);
            ArrayList al = new ArrayList();
            DateTime dt;
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                LmeShfeComex sk = new LmeShfeComex();
                dt = Convert.ToDateTime(ds.Tables[0].Rows[i]["Date"].ToString().Trim());
                sk.Date = dt.Year + "/" + dt.Month + "/" + dt.Day;
                sk.SHFEStock = ds.Tables[0].Rows[i]["ShCU"].ToString().Trim();
                sk.LMEStock = ds.Tables[0].Rows[i]["MCU"].ToString().Trim();
                sk.ComexStock = ds.Tables[0].Rows[i]["Comex"].ToString().Trim();
                al.Add(sk);
            }
            return al;
        }
        #endregion

        获取所有市场#region 获取所有市场
        [WebMethod]
        [System.Xml.Serialization.XmlInclude(typeof(Market))]
        public ArrayList GetAllMarket()
        {
            IList<MarketEntity> ds = DataFactory<MarketSqlProvider>.CreateProvider.GetAll();
            ArrayList al = new ArrayList();
            for (int i = 0; i < ds.Count; i++)
            {
                Market sk = new Market();
                sk.MarketID = ds[i].MarketID.ToString();
                sk.MarketName = ds[i].MarketName;
                al.Add(sk);
            }
            return al;
        }
        #endregion

        根据市场ID获取产品#region 根据市场ID获取产品
        [WebMethod]
        [System.Xml.Serialization.XmlInclude(typeof(Product))]
        public ArrayList GetProductFromMarketID(string marketid)
        {
            SqlQuery sql = new SqlQuery();
            sql.TableName = new ProductEntity().TableName;
            sql.SqlReturnField = "*";
            sql.SqlOrderField = "ProductID";
            sql.OrderType = true;
            sql.SqlWhere = "MarketID = "+marketid;
            IList<ProductEntity> ds = DataFactory<ProductSqlProvider>.CreateProvider.GetEntityList(sql);
            ArrayList al = new ArrayList(10);
            for (int i = 0; i < ds.Count; i++)
            {
                Product sk = new Product();
                sk.ProductID = ds[i].ProductID.ToString();
                sk.ProductName = ds[i].ProductName;
                al.Add(sk);
            }
            return al;
        }
        #endregion

        铜比价#region 铜比价
        public class TongBiJia
        {
            public string CjtDate;
            public string CjtPrice;
            public string LmeTDate;
            public string LmeTPrice;
            public string BJ;
        }
        #endregion

        库存#region 库存
        public class Stock
        {
            public string Date;
            public string Open;
            public string High;
            public string Low;
            public string Last;
            public string ProductName;
            public string MarketName;
        }
        #endregion

        市场#region 市场
        public class Market
        {
            public string MarketID;
            public string MarketName;
        }
        #endregion

        产品#region 产品
        public class Product
        {
            public string ProductID;
            public string ProductName;
        }
        #endregion

        public class ProductGroup
        {
            public string ProductName;
            public string Group;
        }

        public class PriceGroup
        {
            public string Date;
            public string Price;
        }

        LME、SHFE、Comex、LME三个月价格叠加图表数据类#region LME、SHFE、Comex、LME三个月价格叠加图表数据类
        public class LmeShfeComex
        {
            public string Date;
            public string SHFEStock;
            public string LMEStock;
            public string ComexStock;
        }
        #endregion
    }
}

 

以下是XML文件内容：

<?xml version="1.0" encoding="utf-8"?>
<WebServiceUrl>
<item>
<value>http://172.20.67.231/WebService/ProductOrderWebService.asmx?WSDL</value>
</item>
<LocalUrl>
<value>http://localhost:8081/WebService/FirstFlexAppData.asmx?WSDL</value>
</LocalUrl>
</WebServiceUrl>

 

运行效果：