AIR版的通讯簿(二十一)

private function doIt():void{
    if(editObj==null){
     saveIt();
    }else{
     updateIt();
    }
   }
   private function clearPage():void{
    chooseDate.selectedDate=null;
    chooseDate.text="";
    currFee.text="";
    useWay.selectedIndex=-1;
    desc.text="";
   }
   private function saveIt():void{
    stat=new SQLStatement();
    stat.sqlConnection=conn;
    stat.text="insert into ql_money_day(create_date,used_money,used_way,desc)" +
        " values(?,?,?,?)";
    stat.parameters[0]=chooseDate.selectedDate==null?new Date():chooseDate.selectedDate;
    stat.parameters[1]=currFee.text;
    stat.parameters[2]=useWay.selectedItem==null?'1':useWay.selectedItem.id;
    stat.parameters[3]=desc.text;
    stat.addEventListener(SQLErrorEvent.ERROR,insertErrorResult);
    stat.addEventListener(SQLEvent.RESULT,insertOKResult);
    stat.execute();
   }
   private function updateIt():void{
    var aid:String=myDg.selectedItem.theid;
    stat=new SQLStatement();
    stat.sqlConnection=conn;
    stat.text=" update  ql_money_day set create_date=?,used_money=?,used_way=?,desc=?" +
        " where theid=? ";
    stat.parameters[0]=chooseDate.selectedDate==null?new Date():chooseDate.selectedDate;
    stat.parameters[1]=currFee.text;
    stat.parameters[2]=useWay.selectedItem==null?'1':useWay.selectedItem.id;
    stat.parameters[3]=desc.text;
    stat.parameters[4]=aid;
    stat.addEventListener(SQLErrorEvent.ERROR,insertErrorResult);
    stat.addEventListener(SQLEvent.RESULT,insertOKResult);
    stat.execute();
   }
   private function insertOKResult(event:SQLEvent):void{
     queryList();
     Alert.show("保存成功!","提示");
     returnList();
   }