Package nu.lazy8.ledger.jdbc

Examples of nu.lazy8.ledger.jdbc.UniqNumGenerator

760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
      }
      //get rid of all uniq num posts for period ids
      dc.con.createStatement().executeQuery(dc.filterSQL(
        "DELETE FROM UniqNum WHERE UniqName LIKE 'PeriodId=%'"));
      //adjust the periodid for each activity
      UniqNumGenerator uniqnum = new UniqNumGenerator();
      ResultSet rsPeriods=null;
      String select="SELECT CompId,Act_id,InvDate FROM Activity2 ";
      if (inCompId>0)
        select+=" WHERE CompId=" + inCompId;
      select+=" ORDER BY CompId,Act_id";
      ResultSet rsOldTrans = dc.con.createStatement().executeQuery(dc.filterSQL(select));
      int lastCompId=-1;
      rsOldTrans.last();
      int numRecs=rsOldTrans.getRow();
      rsOldTrans.beforeFirst();
      while (rsOldTrans.next()) {
        if (lastCompId!=rsOldTrans.getInt(1)){
          //get all the periods for the CompId
          lastCompId=rsOldTrans.getInt(1);
          rsPeriods=dc.con.createStatement().executeQuery(dc.filterSQL(
            "SELECT StartPeriod,EndPeriod FROM AccountingPeriods WHERE CompId=" + lastCompId));
        }
        Date invoiceDate=rsOldTrans.getDate(3);
        int periodId=0;
        rsPeriods.beforeFirst();
        //find the appropriate period if it exists.
        while (rsPeriods.next()) {
          if (invoiceDate.compareTo(rsPeriods.getDate(1))>=0 && invoiceDate.compareTo(rsPeriods.getDate(2))<=0){
            //increment period id counter
            periodId=uniqnum.GetUniqueNumber("PeriodId="+ rsPeriods.getDate(1) + "-"
              + rsPeriods.getDate(2), 1, 999999999,new Integer(lastCompId));
            break; //we found the period we need
          }
        }
        dc.con.createStatement().executeQuery(dc.filterSQL(
View Full Code Here
114
115
116
117
118
119
120
  /**
   *  Description of the Method
   */
  public void AfterGoodDelete() {
    super.AfterGoodDelete();
    EditBus.send(new AccountListChanged(this, "no parameters"));
  }//}}}
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
  }//}}}

  //{{{ +AfterGoodChange() : void
  public void AfterGoodChange() {
    super.AfterGoodChange();
    EditBus.send(new AccountListChanged(this, "no parameters"));
    wasWriteOk = true;
    if (parent != null && bIsAddOnly) {
      parent.setVisible(false);
    }
  }//}}}
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
  /**
   *  Description of the Method
   */
  public void AfterGoodWrite() {
    super.AfterGoodWrite();
    EditBus.send(new AccountListChanged(this, "no parameters"));
    wasWriteOk = true;
    if (parent != null && bIsAddOnly) {
      parent.setVisible(false);
    }
  }//}}}
View Full Code Here
95
96
97
98
99
100
101
  /**
   *  Description of the Method
   */
  public void AfterGoodDelete() {
    super.AfterGoodDelete();
    EditBus.send(new AccountTypeListChanged(this, "no parameters"));
  }//}}}
View Full Code Here
101
102
103
104
105
106
107
  }//}}}

  //{{{ +AfterGoodChange() : void
  public void AfterGoodChange() {
    super.AfterGoodChange();
    EditBus.send(new AccountTypeListChanged(this, "no parameters"));
  }//}}}
View Full Code Here
110
111
112
113
114
115
116
  /**
   *  Description of the Method
   */
  public void AfterGoodWrite() {
    super.AfterGoodWrite();
    EditBus.send(new AccountTypeListChanged(this, "no parameters"));
  }//}}}
View Full Code Here
169
170
171
172
173
174
175
        }
      }
    }
    EditBus.send(new CompanyListChanged(null, "no parameters"));
    EditBus.send(new CustomerListChanged(null, "no parameters"));
    EditBus.send(new AccountTypeListChanged(null, "no parameters"));
  }//}}}
View Full Code Here
82
83
84
85
86
87
88
89
90
91
      st.executeUpdate(dcc.filterSQL("DELETE FROM AccountType WHERE CompId=" + companyId));
      if (deleteCompanyDef) {
        st = dcc.con.createStatement();
        st.executeUpdate(dcc.filterSQL("DELETE FROM Company WHERE CompId=" + companyId));
      }
      EditBus.send(new CompanyListChanged(null, "no parameters"));
    } catch (Exception e) {
      Log.log(Log.DEBUG, null, "Error in RemoveCompanyFromDatabase= " + e);
    }
  }//}}}
View Full Code Here
126
127
128
129
130
131
132
   */
  public void AfterGoodDelete() {
    //just make sure everything is gone.  Call function that deletes everything
    DeleteCompany.RemoveCompanyFromDatabase(textField1.getInteger().intValue(), view, false);
    super.AfterGoodDelete();
    EditBus.send(new CompanyListChanged(this, "no parameters"));
  }//}}}
View Full Code Here
TOP

Related Classes of nu.lazy8.ledger.jdbc.UniqNumGenerator

  • infoviewer.InfoViewer
  • lazy8ledger.Lazy8LedgerPlugin
  • nu.lazy8.ledger.forms.AccountForm
  • nu.lazy8.ledger.forms.AccountTypeForm
  • nu.lazy8.ledger.forms.ChangeLanguagesDialogs
  • nu.lazy8.ledger.forms.CompanyComponents
  • nu.lazy8.ledger.forms.CompanyForm
  • nu.lazy8.ledger.forms.CreateNewCompany
  • nu.lazy8.ledger.forms.CustomerForm
  • nu.lazy8.ledger.forms.DataConnectDialog
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.