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 wsdl="http://10.19.1.55/serverPano/WebServiceDuke.asmx?WSDL" fault="webservice1_faultHandler(event)"> <s:operation result="getLinkDTByImgNameHandler(event)"></s:operation> </s:WebService> </fx:Declarations> </s:Application>
(编辑:厦门站长网)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|