йаду мне, йаду!
May. 17th, 2006 03:49 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
а-а-а-а-а!!!!! бедный мой мозК, или то, что от него осталось!
дазае достала меня эта as400 java в чистом виде! just look at this nightmare!
public void validLine(String tran) {
company = "21";
// String mlt = T1QJWCH.getCurrentRow().getData("JHMULT").getString();
exp = "0";
VSResultSet rs = T2JWCLL02.getResultSet();
int lineno = rs.current().getData("WLINE").getInt();
VSRow row = rs.first();
// Delete rows without item number
while ( row != null ) {
if (tran.compareTo("1") == 0) {
if ( row.getData("WPROD").getString().trim().compareTo("") == 0 && row.getData("WNAMT").getString().trim().compareTo("") == 0 && row.getData("WLGLCD").getString().trim().compareTo("") == 0 && row.getData("WLINE").getInt() !=lineno && row.getData("WPRID").getString().trim().compareTo("") == 0 ){
rs.delete();
lineNumber-- ;
}
} else {
if ( row.getData("WPROD").getString().trim().compareTo("") == 0 && row.getData("WNAMT").getString().trim().compareTo("") == 0 && row.getData("WLGLCD").getString().trim().compareTo("") == 0 && row.getData("WPRID").getString().trim().compareTo("") == 0 ){
rs.delete();
lineNumber-- ;
}
}
row = rs.next();
}
row = rs.first();
while ( row != null ) {
//Initialize fields
row.getData("WLLINE").setString(row.getData("WLINE").getString());
String item1 = row.getData("WPROD").getString().trim();
String item2 = row.getData("WITEM").getString().trim();
if (item2.compareTo("")==0 || item2.compareTo(" ")==0 ){
if (item1.compareTo("")==0) {
row.getData("WITEM").setString(" ");
}
else {
row.getData("WITEM").setString(item1);
}
}
if ( row.getData("WDESC").getString().trim().compareTo("") == 0){
row.getData("WDESC").setString(" ");
}
if ( row.getData("WQORD2").getString().trim().compareTo("") == 0 ){
row.getData("WQORD2").setString("0");
}
if ( row.getData("WNAMT").getString().trim().compareTo("") == 0 ){
row.getData("WNAMT").setString("0");
}
// Special charge edit
if ( row.getData("WPROD").getString().trim().compareTo("") != 0 && row.getData("WLGLCD").getString().trim().compareTo("") != 0 && row.getData("WPROD").getString().toUpperCase().trim().compareTo("*SPECIAL") != 0){
row.getData("WLGLCD").setString("");
}
if ( row.getData("WPROD").getString().trim().compareTo("") == 0 && row.getData("WLGLCD").getString().trim().compareTo("") != 0 ){
row.getData("WQORD2").setString("0");
row.getData("WNET").setString("0");
}
if ( row.getData("WPROD").getString().toUpperCase().trim().compareTo("*SPECIAL") == 0){
row.getData("WQORD2").setString("0");
row.getData("WNET").setString("0");
}
// Default the line request date from the header if the request date is blank
if ( row.getData("WVRDTE").getString() == "" ) {
row.getData("WVRDTE").setString(reqdt);
// System.out.println("compare 1");
}
if (row.getData("WSTAT").getString().trim().compareTo("1") != 0) {
if ( row.getData("WVRDTE").getString().trim().compareTo(row.getData("WLRDTE").getString().trim()) == 0 )
{
row.getData("WSTAT").setString("0") ;
}
else {
row.getData("WSTAT").setString("1") ;
}
}
System.out.println("expdt = " + expdt);
if ( row.getData("WVSDTE").getString() == "" ) {
row.getData("WVSDTE").setString(reqdt);
}
if ( row.getData("WLGLCD").getString() == "" ) {
row.getData("WLGLCD").setString(" ");
}
if ( row.getData("WDESC").getString() == "" ) {
row.getData("WDESC").setString(" ");
}
if ( row.getData("WPROD").getString() == "" ) {
row.getData("WPROD").setString(" ");
}
// Validate the line request date
String lrDate = row.getData("WVRDTE").getString().trim();
String srDate = row.getData("WVSDTE").getString().trim();
exDate = row.getData("WVEDTE").getString().trim();
System.out.println("validline1 exDate = " + exDate );
if (exDate.compareTo("")==0) {
exDate = "00/00/00";
}
System.out.println("validline2 lrDate = " + lrDate );
if (lrDate.trim().compareTo("00/00/00") != 0 ){
String lr6 = Utility.setDateMDY(lrDate);
String lr8 = Utility.setDateYYMMDD(lrDate);
row.getData("WVRDTE").setString(lr6);
row.getData("WRDTE").setString(lr8);
System.out.println("validline3 lrDate = " + lr6);
}
if (srDate.trim().compareTo("00/00/00") != 0 ){
String sr6 = Utility.setDateMDY(srDate);
row.getData("WVSDTE").setString(sr6);
}
System.out.println("validline4 exDate = " + exDate);
if (exDate.trim().compareTo("00/00/00") != 0 ){
String sr6 = Utility.setDateMDY(exDate);
row.getData("WVEDTE").setString(sr6);
}
// String mult2 = row.getData("WLMULT").getString();
// Set the multiplier override & Net price flag
java.util.Properties newv = row.getNewValues();
java.util.Properties oldv = row.getOldValues();
String multnew = newv.getProperty("WLMULT") ;
String netnew = newv.getProperty("WNET") ;
String multold = oldv.getProperty("WLMULT") ;
String netold = oldv.getProperty("WNET") ;
System.out.println("multnew1 : " + item1 + " " + multnew);
System.out.println("netnew1 : " + item1 + " " + netnew);
System.out.println("multold1 : " + item1 + " " + multold );
System.out.println("netold1 : " + item1 + " " + netold);
if (multold != null) {
BigDecimal muold = new BigDecimal(multold ).setScale(3, 6);
multold = "" + muold;
}
else {
multold = "0.000";
}
if (netold != null) {
BigDecimal ntold = new BigDecimal(netold).setScale(3, 6) ;
netold = "" + ntold;
}
else {
netold = "0.000";
}
System.out.println("multnew2 : " + item1 + " " + multnew);
System.out.println("netnew2 : " + item1 + " " + netnew);
System.out.println("multold2 : " + item1 + " " + multold );
System.out.println("netold2 : " + item1 + " " + netold);
row.getData("WERR4").setString("0") ;
row.getData("WERR5").setString("0") ;
if(multnew != null) {
if(multold.compareTo(multnew) != 0 || multnew.compareTo("0.000") == 0) {
row.getData("WERR4").setString("1") ;
row.getData("WERR8").setString("1") ;
}
}
System.out.println("netold1: " );
if(netnew != null) {
if(netold.compareTo(netnew) != 0 || netnew.compareTo("0.000") == 0) {
System.out.println("netold: " + (netold.compareTo(netnew) != 0 ));
System.out.println("netnew: " + (netnew.compareTo("0.000") == 0));
row.getData("WERR5").setString("1") ;
row.getData("WERR8").setString("1") ;
}
}
System.out.println("netold2: " );
if ( row.getData("WNET").getString().trim().compareTo("") == 0){
row.getData("WNET").setString("0");
}
System.out.println("netold3: " );
// Default other header info
String rsncd = row.getData("WLLRSN").getString().trim() ;
String hldcd = row.getData("WLLHLD").getString().trim() ;
String mktcd = row.getData("WLMKTC").getString().trim() ;
System.out.println("netold4: " );
if ( rsncd.compareTo("") == 0 ) {
if (rsn.compareTo("") !=0) {
row.getData("WLLRSN").setString(rsn);
}
else {
row.getData("WLLRSN").setString(" ");
}
}
else {
row.getData("WLLRSN").setString(row.getData("WLLRSN").getString().trim().toUpperCase() );
}
System.out.println("netold5: " + hldcd + " " + hld);
if ( hldcd.compareTo("") == 0 ) {
System.out.println("netold5.1: " + hldcd + " " + hld);
if (hld.compareTo("") !=0) {
System.out.println("netold5.2: " + hldcd + " " + hld);
row.getData("WLLHLD").setString(hld);
System.out.println("netold5.3: " + hldcd + " " + hld);
}
else {
System.out.println("netold5.4: " + hldcd + " " + hld);
row.getData("WLLHLD").setString(" ");
System.out.println("netold5.5: " + hldcd + " " + hld);
}
}
else {
System.out.println("netold5.6: " + hldcd + " " + hld);
row.getData("WLLHLD").setString(row.getData("WLLHLD").getString().trim().toUpperCase() );
}
System.out.println("netold5.1: " );
if ( mktcd.compareTo("") == 0 ) {
if (mkt.compareTo("") !=0) {
row.getData("WLMKTC").setString(mkt);
}
else {
row.getData("WLMKTC").setString(" ");
}
}
else {
row.getData("WLMKTC").setString(row.getData("WLMKTC").getString().trim().toUpperCase() );
}
System.out.println("netold6: " );
row = rs.next();
System.out.println("netold7: " );
}
rs.updateDataSource();
System.out.println("netold8: " );
rs.last();
System.out.println("netold9: " );
}
да
public void validLine(String tran) {
company = "21";
// String mlt = T1QJWCH.getCurrentRow().getData("JHMULT").getString();
exp = "0";
VSResultSet rs = T2JWCLL02.getResultSet();
int lineno = rs.current().getData("WLINE").getInt();
VSRow row = rs.first();
// Delete rows without item number
while ( row != null ) {
if (tran.compareTo("1") == 0) {
if ( row.getData("WPROD").getString().trim().compareTo("") == 0 && row.getData("WNAMT").getString().trim().compareTo("") == 0 && row.getData("WLGLCD").getString().trim().compareTo("") == 0 && row.getData("WLINE").getInt() !=lineno && row.getData("WPRID").getString().trim().compareTo("") == 0 ){
rs.delete();
lineNumber-- ;
}
} else {
if ( row.getData("WPROD").getString().trim().compareTo("") == 0 && row.getData("WNAMT").getString().trim().compareTo("") == 0 && row.getData("WLGLCD").getString().trim().compareTo("") == 0 && row.getData("WPRID").getString().trim().compareTo("") == 0 ){
rs.delete();
lineNumber-- ;
}
}
row = rs.next();
}
row = rs.first();
while ( row != null ) {
//Initialize fields
row.getData("WLLINE").setString(row.getData("WLINE").getString());
String item1 = row.getData("WPROD").getString().trim();
String item2 = row.getData("WITEM").getString().trim();
if (item2.compareTo("")==0 || item2.compareTo(" ")==0 ){
if (item1.compareTo("")==0) {
row.getData("WITEM").setString(" ");
}
else {
row.getData("WITEM").setString(item1);
}
}
if ( row.getData("WDESC").getString().trim().compareTo("") == 0){
row.getData("WDESC").setString(" ");
}
if ( row.getData("WQORD2").getString().trim().compareTo("") == 0 ){
row.getData("WQORD2").setString("0");
}
if ( row.getData("WNAMT").getString().trim().compareTo("") == 0 ){
row.getData("WNAMT").setString("0");
}
// Special charge edit
if ( row.getData("WPROD").getString().trim().compareTo("") != 0 && row.getData("WLGLCD").getString().trim().compareTo("") != 0 && row.getData("WPROD").getString().toUpperCase().trim().compareTo("*SPECIAL") != 0){
row.getData("WLGLCD").setString("");
}
if ( row.getData("WPROD").getString().trim().compareTo("") == 0 && row.getData("WLGLCD").getString().trim().compareTo("") != 0 ){
row.getData("WQORD2").setString("0");
row.getData("WNET").setString("0");
}
if ( row.getData("WPROD").getString().toUpperCase().trim().compareTo("*SPECIAL") == 0){
row.getData("WQORD2").setString("0");
row.getData("WNET").setString("0");
}
// Default the line request date from the header if the request date is blank
if ( row.getData("WVRDTE").getString() == "" ) {
row.getData("WVRDTE").setString(reqdt);
// System.out.println("compare 1");
}
if (row.getData("WSTAT").getString().trim().compareTo("1") != 0) {
if ( row.getData("WVRDTE").getString().trim().compareTo(row.getData("WLRDTE").getString().trim()) == 0 )
{
row.getData("WSTAT").setString("0") ;
}
else {
row.getData("WSTAT").setString("1") ;
}
}
System.out.println("expdt = " + expdt);
if ( row.getData("WVSDTE").getString() == "" ) {
row.getData("WVSDTE").setString(reqdt);
}
if ( row.getData("WLGLCD").getString() == "" ) {
row.getData("WLGLCD").setString(" ");
}
if ( row.getData("WDESC").getString() == "" ) {
row.getData("WDESC").setString(" ");
}
if ( row.getData("WPROD").getString() == "" ) {
row.getData("WPROD").setString(" ");
}
// Validate the line request date
String lrDate = row.getData("WVRDTE").getString().trim();
String srDate = row.getData("WVSDTE").getString().trim();
exDate = row.getData("WVEDTE").getString().trim();
System.out.println("validline1 exDate = " + exDate );
if (exDate.compareTo("")==0) {
exDate = "00/00/00";
}
System.out.println("validline2 lrDate = " + lrDate );
if (lrDate.trim().compareTo("00/00/00") != 0 ){
String lr6 = Utility.setDateMDY(lrDate);
String lr8 = Utility.setDateYYMMDD(lrDate);
row.getData("WVRDTE").setString(lr6);
row.getData("WRDTE").setString(lr8);
System.out.println("validline3 lrDate = " + lr6);
}
if (srDate.trim().compareTo("00/00/00") != 0 ){
String sr6 = Utility.setDateMDY(srDate);
row.getData("WVSDTE").setString(sr6);
}
System.out.println("validline4 exDate = " + exDate);
if (exDate.trim().compareTo("00/00/00") != 0 ){
String sr6 = Utility.setDateMDY(exDate);
row.getData("WVEDTE").setString(sr6);
}
// String mult2 = row.getData("WLMULT").getString();
// Set the multiplier override & Net price flag
java.util.Properties newv = row.getNewValues();
java.util.Properties oldv = row.getOldValues();
String multnew = newv.getProperty("WLMULT") ;
String netnew = newv.getProperty("WNET") ;
String multold = oldv.getProperty("WLMULT") ;
String netold = oldv.getProperty("WNET") ;
System.out.println("multnew1 : " + item1 + " " + multnew);
System.out.println("netnew1 : " + item1 + " " + netnew);
System.out.println("multold1 : " + item1 + " " + multold );
System.out.println("netold1 : " + item1 + " " + netold);
if (multold != null) {
BigDecimal muold = new BigDecimal(multold ).setScale(3, 6);
multold = "" + muold;
}
else {
multold = "0.000";
}
if (netold != null) {
BigDecimal ntold = new BigDecimal(netold).setScale(3, 6) ;
netold = "" + ntold;
}
else {
netold = "0.000";
}
System.out.println("multnew2 : " + item1 + " " + multnew);
System.out.println("netnew2 : " + item1 + " " + netnew);
System.out.println("multold2 : " + item1 + " " + multold );
System.out.println("netold2 : " + item1 + " " + netold);
row.getData("WERR4").setString("0") ;
row.getData("WERR5").setString("0") ;
if(multnew != null) {
if(multold.compareTo(multnew) != 0 || multnew.compareTo("0.000") == 0) {
row.getData("WERR4").setString("1") ;
row.getData("WERR8").setString("1") ;
}
}
System.out.println("netold1: " );
if(netnew != null) {
if(netold.compareTo(netnew) != 0 || netnew.compareTo("0.000") == 0) {
System.out.println("netold: " + (netold.compareTo(netnew) != 0 ));
System.out.println("netnew: " + (netnew.compareTo("0.000") == 0));
row.getData("WERR5").setString("1") ;
row.getData("WERR8").setString("1") ;
}
}
System.out.println("netold2: " );
if ( row.getData("WNET").getString().trim().compareTo("") == 0){
row.getData("WNET").setString("0");
}
System.out.println("netold3: " );
// Default other header info
String rsncd = row.getData("WLLRSN").getString().trim() ;
String hldcd = row.getData("WLLHLD").getString().trim() ;
String mktcd = row.getData("WLMKTC").getString().trim() ;
System.out.println("netold4: " );
if ( rsncd.compareTo("") == 0 ) {
if (rsn.compareTo("") !=0) {
row.getData("WLLRSN").setString(rsn);
}
else {
row.getData("WLLRSN").setString(" ");
}
}
else {
row.getData("WLLRSN").setString(row.getData("WLLRSN").getString().trim().toUpperCase() );
}
System.out.println("netold5: " + hldcd + " " + hld);
if ( hldcd.compareTo("") == 0 ) {
System.out.println("netold5.1: " + hldcd + " " + hld);
if (hld.compareTo("") !=0) {
System.out.println("netold5.2: " + hldcd + " " + hld);
row.getData("WLLHLD").setString(hld);
System.out.println("netold5.3: " + hldcd + " " + hld);
}
else {
System.out.println("netold5.4: " + hldcd + " " + hld);
row.getData("WLLHLD").setString(" ");
System.out.println("netold5.5: " + hldcd + " " + hld);
}
}
else {
System.out.println("netold5.6: " + hldcd + " " + hld);
row.getData("WLLHLD").setString(row.getData("WLLHLD").getString().trim().toUpperCase() );
}
System.out.println("netold5.1: " );
if ( mktcd.compareTo("") == 0 ) {
if (mkt.compareTo("") !=0) {
row.getData("WLMKTC").setString(mkt);
}
else {
row.getData("WLMKTC").setString(" ");
}
}
else {
row.getData("WLMKTC").setString(row.getData("WLMKTC").getString().trim().toUpperCase() );
}
System.out.println("netold6: " );
row = rs.next();
System.out.println("netold7: " );
}
rs.updateDataSource();
System.out.println("netold8: " );
rs.last();
System.out.println("netold9: " );
}
no subject
Date: 2006-05-17 09:08 pm (UTC)ЗЫ. Уважаю! :)
no subject
Date: 2006-05-17 09:10 pm (UTC)no subject
Date: 2006-05-17 09:19 pm (UTC)в 1979 г после этого:
row.getData
System.out.println
могу сказать- ВОВРЕМЯ Я ЗАВЯЗАЛ!!!:)
no subject
Date: 2006-05-17 09:21 pm (UTC)no subject
Date: 2006-05-18 03:20 pm (UTC)no subject
Date: 2006-05-18 08:11 pm (UTC)пришел- сунулся в асю- там клюква развесистая вместо изумрудов-
ушел не солоно хлебамши:(
no subject
Date: 2006-05-19 02:52 am (UTC)no subject
Date: 2006-05-18 06:38 am (UTC)no subject
Date: 2006-05-18 03:21 pm (UTC)no subject
Date: 2006-05-18 12:01 pm (UTC)no subject
Date: 2006-05-18 03:18 pm (UTC)