flex调用webservice中的自定义类的方法
flex调用webservice中的自定义类的方法
发布时间:2016-12-29 来源:查字典编辑
摘要:复制代码代码如下:publicclassReturnResult{publicintcurIndex{get;set;}publicData...

复制代码 代码如下:

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>

推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
相关阅读
网友关注
最新Flex学习
热门Flex学习
编程开发子分类