flexがwebserviceのカスタムクラスを呼び出す方法

 
  
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 = "     (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 = "     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; 
  
} 
  
} 
  
 
 

 
  
 
  
xmlns:s="library://ns.adobe.com/flex/spark" 
  
xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600" creationComplete="application1_creationCompleteHandler(event)"> 
  
 
  <br/>import mx.collections.ArrayCollection; 
  <br/>import mx.controls.Alert; 
  <br/>import mx.events.FlexEvent; 
  <br/>import mx.rpc.events.FaultEvent; 
  <br/>import mx.rpc.events.ResultEvent; 
  <br/> 
  <br/>public var arr:ArrayCollection=new ArrayCollection(); 
  <br/>public var aaa:String=new String(); 
  <br/> 
  <br/>protected function webservice1_faultHandler(event:FaultEvent):void 
  <br/>{ 
  <br/>Alert.show(event.fault.toString()); 
  <br/>} 
  <br/>protected function getLinkDTByImgNameHandler(event:ResultEvent):void 
  <br/>{ 
  <br/>// aaa=this.myweb.getLinkDTByImgName.lastResult.curIndex; 
  <br/>// arr=this.myweb.getLinkDTByImgName.lastResult.idxList.Tables.Table.Rows; 
  <br/> 
  <br/>aaa=event.result.curIndex; 
  <br/>arr=event.result.idxList.Tables.Table.Rows; 
  <br/>Alert.show(aaa+" "+arr.length.toString()); 
  <br/>} 
  <br/> 
  <br/> 
  <br/>protected function application1_creationCompleteHandler(event:FlexEvent):void 
  <br/>{ 
  <br/>myweb.getLinkDTByImgName("PanView","20131019072740-0000150"); 
  <br/>} 
  <br/> 
  <br/>]]&gt; 
  <br/>