flex调用webservice中的自定义类

来源:互联网 发布:igbt芯片 知乎 编辑:程序博客网 时间:2024/06/10 19:25

public class ReturnResult    {        public int curIndex { get; set; }        public DataTable idxList { get; set; }    }    //测试数据库连接    [WebMethod(Description = "!!!测试数据库连接,链接字符串在web.config中")]    public bool conectDB()    {        strCon = ConfigurationSettings.AppSettings["sqlConDuke"];        conn = new SqlConnection(strCon);        try        {            conn.Open();            return true;        }        catch (Exception)        {            return false;        }        finally        {            conn.Close();        }    }
[WebMethod(Description = "根据 <b>照片名</b> 获得详细数据(DataTable),strTb,eg:PanView;strImgName,eg:20131019072740-0000150")]    public DataTable getInfoByImgName(string strTb, string strImgName)    {        bool ifCon = conectDB();        if (ifCon)        {            string sql_BfCar = "SELECT * FROM dbo." + strTb + " where ImageName LIKE '%" + strImgName + "%'";            da = new SqlDataAdapter(sql_BfCar, conn);            myds = new DataSet();            da.Fill(myds);            return myds.Tables[0];        }        else        {            return null;        }    }    [WebMethod(Description = "根据 <b>照片名</b> 获得所在Link的所有数据(ReturnResult),strTb,eg:PanView;strImgName,eg:20131019072740-0000150")]    public ReturnResult getLinkDTByImgName(string strTb, string strImgName)    {        ReturnResult returnResult = new ReturnResult();        bool ifCon = conectDB();        if (ifCon)        {            returnResult.curIndex = Convert.ToInt32(getInfoByImgName(strTb, strImgName).Rows[0][0]);            string strLinkGuid = getInfoByImgName(strTb, strImgName).Rows[0][1].ToString();            string sql_BfCar = "SELECT * FROM dbo." + strTb + " where LinkGuid LIKE '%" + strLinkGuid + "%'";            da = new SqlDataAdapter(sql_BfCar, conn);            myds = new DataSet();            da.Fill(myds);            returnResult.idxList = myds.Tables[0];            return returnResult;        }        else        {            return null;        }    }
Flex代码:

<?xml version="1.0" encoding="utf-8"?><s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"    xmlns:s="library://ns.adobe.com/flex/spark"    xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600" creationComplete="application1_creationCompleteHandler(event)"><fx:Script><![CDATA[import mx.collections.ArrayCollection;import mx.controls.Alert;import mx.events.FlexEvent;import mx.rpc.events.FaultEvent;import mx.rpc.events.ResultEvent;public var arr:ArrayCollection=new ArrayCollection();public var aaa:String=new String();protected function webservice1_faultHandler(event:FaultEvent):void{Alert.show(event.fault.toString());}protected function getLinkDTByImgNameHandler(event:ResultEvent):void{//aaa=this.myweb.getLinkDTByImgName.lastResult.curIndex;//arr=this.myweb.getLinkDTByImgName.lastResult.idxList.Tables.Table.Rows;aaa=event.result.curIndex;arr=event.result.idxList.Tables.Table.Rows;Alert.show(aaa+" "+arr.length.toString());}protected function application1_creationCompleteHandler(event:FlexEvent):void{myweb.getLinkDTByImgName("PanView","20131019072740-0000150");}]]></fx:Script><fx:Declarations><!-- 将非可视元素(例如服务、值对象)放在此处 --><s:WebService id="myweb" wsdl="http://10.19.1.55/serverPano/WebServiceDuke.asmx?WSDL" fault="webservice1_faultHandler(event)"><s:operation name="getLinkDTByImgName" result="getLinkDTByImgNameHandler(event)"></s:operation></s:WebService></fx:Declarations></s:Application>








原创粉丝点击