flexがwebserviceのカスタムクラスを呼び出す方法
4272 ワード
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;
}
}
Flexコード:
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/>]]>
<br/>