CustomerManagePage.mxml页面内容(1)
?xml version="1.0" encoding="utf-8"?>
<mx:VBox xmlns:mx="http://www.adobe.com/2006/mxml" width="100%" height="100%" paddingTop="5"
paddingLeft="2" paddingRight="2" creationComplete="init()">
<mx:Script>
<![CDATA[
import mx.events.CloseEvent;
import mx.managers.PopUpManager;
import mx.collections.ArrayCollection;
import mx.controls.Alert;
import mx.core.WindowedApplication;
public var conn:SQLConnection;
private var stat:SQLStatement;
private var file:File;
[Bindable]private var fileFilter:Array=[new FileFilter("图片文件(*.jpg,*.bmp,*.gif,*,png)",("*.jpg;*.bmp;*.gif;*.png)"))];
[Bindable]private var dataList:ArrayCollection=new ArrayCollection();
[Bindable]private var editObj:Object;
private function init():void{
file=new File();
file.addEventListener(Event.SELECT,selectFileHandler);
queryList();
}
private function queryList():void{
dataList.removeAll();
stat=new SQLStatement();
stat.sqlConnection=conn;
var sql:String=" select * from ql_customer where 1=1";
if(queryName.text!=null&&queryName.text!=""){
sql+=" and customer_name like '%"+queryName.text+"%'";
}
if(queryPhone.text!=null&&queryPhone.text!=""){
sql+="and customer_mobile like '%"+queryPhone.text+"%'";
}
stat.text=sql;
stat.execute(-1,new Responder(getCusList,errorHandler));
}
private function getCusList(result:SQLResult):void{
if(result.data!=null){
var numResults:int =result.data.length;
for (var i:int = 0; i < numResults; i++){
var row:Object = result.data[i];
dataList.addItem(row);
}
}
}
private function errorHandler(error:SQLError):void{
Alert.show("查询客户列表出错");
Alert.show(error.details);
}