home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / JDesignerPro / Jdp3_0.exe / data1.cab / Program_Files / SalesOrder.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-04-09  |  16.6 KB  |  652 lines
  1. import java.awt.BorderLayout;
  2. import java.awt.Color;
  3. import java.awt.Container;
  4. import java.awt.Event;
  5. import java.awt.Label;
  6. import java.awt.List;
  7. import java.awt.Panel;
  8. import java.awt.TextField;
  9. import java.util.StringTokenizer;
  10. import java.util.Vector;
  11.  
  12. public class SalesOrder extends JDPClassLayout {
  13.    JDPUser user;
  14.    JDPJagg jaggSQL;
  15.    JDPPopupMessage popuppanel;
  16.    JDPMaskEdit JDPMaskEditMain;
  17.    String moduleParameter;
  18.    Panel Main;
  19.    Panel Panel1;
  20.    JDPTextGrid DetailGrid1;
  21.    Panel Columns1;
  22.    JDPScrollPanel ScrollPanel1;
  23.    Label stor_idLabel1;
  24.    TextField stor_id1;
  25.    Label stor_nameLabel1;
  26.    TextField stor_name1;
  27.    Label stor_addressLabel1;
  28.    TextField stor_address1;
  29.    Label cityLabel1;
  30.    Panel cityLine1;
  31.    TextField city1;
  32.    TextField state1;
  33.    TextField zip1;
  34.    JDPButtons JDPButtons1;
  35.    Panel Panel2;
  36.    JDPSearchResults ResultList1;
  37.    JDPWhereClause SearchPanel1;
  38.  
  39.    public void InitClass(JDPUser var1, Panel var2, String var3) {
  40.       this.user = var1;
  41.       this.moduleParameter = var3;
  42.       super.targetPanel = var2;
  43.       this.jaggSQL = new JDPJagg(var1.jaggPath);
  44.       ((Container)this).setLayout(new BorderLayout());
  45.       this.popuppanel = new JDPPopupMessage(var1, this);
  46.       ((Container)this).add(this.popuppanel);
  47.       this.JDPMaskEditMain = new JDPMaskEdit();
  48.       this.Main = new Panel();
  49.       this.Panel1 = new Panel();
  50.       this.DetailGrid1Main();
  51.       this.Columns1 = new Panel();
  52.       this.ScrollPanel1 = new JDPScrollPanel();
  53.       this.stor_idLabel1 = new Label("Store Id:", 0);
  54.       this.stor_id1 = new TextField("stor_id", 6);
  55.       this.stor_nameLabel1 = new Label("Name:", 0);
  56.       this.stor_name1 = new TextField("stor_name", 42);
  57.       this.stor_addressLabel1 = new Label("Address:", 0);
  58.       this.stor_address1 = new TextField("stor_address", 42);
  59.       this.cityLabel1 = new Label("", 0);
  60.       this.cityLine1 = new Panel();
  61.       this.city1 = new TextField("city", 22);
  62.       this.state1 = new TextField("state", 4);
  63.       this.zip1 = new TextField("zip", 7);
  64.       String[] var4 = new String[]{"Save", "Delete", "Reset"};
  65.       int[] var5 = new int[]{JDPButton.getIconValue("Save"), JDPButton.getIconValue("Delete"), JDPButton.getIconValue("Undo")};
  66.       this.JDPButtons1 = new JDPButtons(var1, var4, var5, JDPButtons.getAlignmentValue("Horizontal"));
  67.       this.Panel2 = new Panel();
  68.       this.ResultList1Main();
  69.       this.SearchPanel1Main();
  70.       this.Main.setLayout(new BorderLayout());
  71.       ((Container)this).add("Center", this.Main);
  72.       this.Main.add("Center", this.Panel1);
  73.       this.Panel1.setLayout(new BorderLayout());
  74.       this.Panel1.add("Center", this.DetailGrid1);
  75.       this.Panel1.add("North", this.Columns1);
  76.       this.Columns1.setLayout(new BorderLayout());
  77.       this.Columns1Main();
  78.       this.Columns1.add("Center", this.ScrollPanel1);
  79.       this.ScrollPanel1.add("Left", this.stor_idLabel1);
  80.       this.ScrollPanel1.add("Right", this.stor_id1);
  81.       this.ScrollPanel1.add("Left", this.stor_nameLabel1);
  82.       this.ScrollPanel1.add("Right", this.stor_name1);
  83.       this.ScrollPanel1.add("Left", this.stor_addressLabel1);
  84.       this.ScrollPanel1.add("Right", this.stor_address1);
  85.       this.ScrollPanel1.add("Left", this.cityLabel1);
  86.       this.ScrollPanel1.add("Right", this.cityLine1);
  87.       this.cityLine1.setLayout(new JDPLineLayout());
  88.       this.cityLine1.add("Left", this.city1);
  89.       this.cityLine1.add("Left", this.state1);
  90.       this.cityLine1.add("Left", this.zip1);
  91.       this.Panel1.add("South", this.JDPButtons1);
  92.       this.Main.add("West", this.Panel2);
  93.       this.Panel2.setLayout(new BorderLayout());
  94.       this.Panel2.add("Center", this.ResultList1);
  95.       this.Panel2.add("North", this.SearchPanel1);
  96.       this.popuppanel.addComponent(this.stor_id1, "Stor Id", "");
  97.       this.popuppanel.addComponent(this.stor_name1, "Stor  name", "");
  98.       this.popuppanel.addComponent(this.stor_address1, "Stor Address", "");
  99.       this.popuppanel.addComponent(this.city1, "City", "");
  100.       this.popuppanel.addComponent(this.state1, "State", "");
  101.       this.popuppanel.addComponent(this.zip1, "Zip", "");
  102.       this.popuppanel.addComponent(this.JDPButtons1.button[0], "Save Changes", "Save changes to the database");
  103.       this.popuppanel.addComponent(this.JDPButtons1.button[1], "Delete Rows", "Remove the selected rows from this order");
  104.       this.popuppanel.addComponent(this.JDPButtons1.button[2], "Restore", "Restore this order from the database");
  105.       this.InitComponents();
  106.       var1.gParm.addElement(this);
  107.    }
  108.  
  109.    public boolean handleEvent(Event var1) {
  110.       switch (var1.id) {
  111.          case 503:
  112.          case 504:
  113.          case 505:
  114.             this.popuppanel.postEvent(var1);
  115.             return false;
  116.          case 1001:
  117.             if (var1.target.equals(this.JDPButtons1.button[0])) {
  118.                this.DetailGrid1UpdateRows(this.ResultList1.getSelectedKey());
  119.                return true;
  120.             } else if (var1.target.equals(this.JDPButtons1.button[1])) {
  121.                this.DetailGrid1DeleteRows(this.ResultList1.getSelectedKey());
  122.                return true;
  123.             } else if (var1.target.equals(this.JDPButtons1.button[2])) {
  124.                this.DetailGrid1LoadGrid(this.ResultList1.getSelectedKey());
  125.                return true;
  126.             } else if (var1.target.equals(this.ResultList1)) {
  127.                this.Columns1Load(this.ResultList1.getSelectedKey());
  128.                this.DetailGrid1LoadGrid(this.ResultList1.getSelectedKey());
  129.                return true;
  130.             } else {
  131.                if (var1.target.equals(this.SearchPanel1)) {
  132.                   this.ResultList1.clearList();
  133.                   this.ResultList1.setFromWhereClause(this.SearchPanel1.getFromWhereClause());
  134.                   this.ResultList1.loadList();
  135.                   return true;
  136.                }
  137.  
  138.                return false;
  139.             }
  140.          default:
  141.             return false;
  142.       }
  143.    }
  144.  
  145.    public void InitComponents() {
  146.    }
  147.  
  148.    public void DetailGrid1Main() {
  149.       this.DetailGrid1SetGridSettings();
  150.    }
  151.  
  152.    public void DetailGrid1LoadGrid(String[] var1) {
  153.       JDPTextGrid var2 = this.DetailGrid1;
  154.       if (var1 != null && var1.length >= 0) {
  155.          int var4 = 0;
  156.          Vector var5 = new Vector();
  157.          String var6 = this.jaggSQL.getSEP();
  158.          int var7 = 0;
  159.          byte var9 = 3;
  160.          new Vector();
  161.          new Vector();
  162.          String var10 = "SELECT stor_id, ord_num, title_id, title_id, qty, payterms FROM dbo_sales WHERE (1=1)  ";
  163.          if (var1.length > 0 && var1[0] != null) {
  164.             var10 = var10 + " AND stor_id='" + var1[0] + "'";
  165.          }
  166.  
  167.          if (var1.length > 1 && var1[1] != null) {
  168.             var10 = var10 + " AND ord_num='" + var1[1] + "'";
  169.          }
  170.  
  171.          if (var1.length > 2 && var1[2] != null) {
  172.             var10 = var10 + " AND title_id='" + var1[2] + "'";
  173.          }
  174.  
  175.          this.user.mainmsg.setStatusMsg("Accessing database...", 0);
  176.          this.jaggSQL.setDSN("JDP Tutorial");
  177.          this.jaggSQL.setCSTR("DSN=JDP Tutorial;UID=;PWD=;");
  178.          this.jaggSQL.setMRW("1000");
  179.          this.jaggSQL.setTOUT("60");
  180.          var4 = this.jaggSQL.execSQL(var10, var5);
  181.          if (var4 == -1) {
  182.             this.user.u.setSqlMessage(this.jaggSQL, var10);
  183.          } else {
  184.             var2.totalDataRows = this.jaggSQL.getRowCount();
  185.             var7 = this.jaggSQL.getRowCount() + 20;
  186.             var2.currentText = new String[var9][var7];
  187.             var2.cellChanged = null;
  188.             var2.rowChanged = null;
  189.             var2.columnSelected = null;
  190.             byte var11 = 3;
  191.             var2.rowKey = new String[var7][var11];
  192.  
  193.             for(int var13 = 0; var13 < var7 - 20; ++var13) {
  194.                String var8 = (String)var5.elementAt(var13);
  195.                if (var8 != null && var8.trim().compareTo("") != 0) {
  196.                   StringTokenizer var3 = new StringTokenizer(var8);
  197.  
  198.                   for(int var14 = 0; var14 < var11; ++var14) {
  199.                      var2.rowKey[var13][var14] = var3.nextToken(var6).trim();
  200.                   }
  201.  
  202.                   for(int var15 = 0; var15 < var9; ++var15) {
  203.                      String var12 = var3.nextToken(var6).trim();
  204.                      var2.currentText[var15][var13] = var12;
  205.                      if (var15 == 0 && var2.pullDownValue[0][0].indexOf(var12) >= 0) {
  206.                         var2.currentText[var15][var13] = var2.pullDownList[0][0].getItem(var2.pullDownValue[0][0].indexOf(var12));
  207.                      }
  208.  
  209.                      if (var15 == 2 && var2.pullDownValue[2][0].indexOf(var12) >= 0) {
  210.                         var2.currentText[var15][var13] = var2.pullDownList[2][0].getItem(var2.pullDownValue[2][0].indexOf(var12));
  211.                      }
  212.                   }
  213.                }
  214.             }
  215.  
  216.             for(int var18 = var7 - 20; var18 < var7; ++var18) {
  217.                for(int var19 = 0; var19 < var1.length; ++var19) {
  218.                   var2.rowKey[var18][var19] = var1[var19];
  219.                }
  220.             }
  221.  
  222.             var2.newTable();
  223.             this.user.mainmsg.clearStatusMsg();
  224.          }
  225.       } else {
  226.          this.DetailGrid1LoadEmptyGrid();
  227.       }
  228.    }
  229.  
  230.    public void DetailGrid1UpdateRows(String[] var1) {
  231.       JDPTextGrid var2 = this.DetailGrid1;
  232.       if (var1 != null && var1.length >= 0) {
  233.          int var3 = 0;
  234.          int var4 = 0;
  235.          int var5 = 1;
  236.          int var6 = 1;
  237.  
  238.          for(int var7 = 0; var7 < var2.rowChanged.length; ++var7) {
  239.             if (var2.rowChanged[var7]) {
  240.                if (var7 >= var2.totalDataRows) {
  241.                   ++var4;
  242.                } else {
  243.                   ++var3;
  244.                }
  245.             }
  246.          }
  247.  
  248.          for(int var8 = 0; var8 < var2.rowChanged.length; ++var8) {
  249.             if (var2.rowChanged[var8]) {
  250.                if (var8 >= var2.totalDataRows) {
  251.                   this.user.mainmsg.setStatusMsg("Inserting row " + Integer.toString(var6++) + " of " + Integer.toString(var4) + "...", 0);
  252.                   this.DetailGrid1SaveData(var8, "I");
  253.                } else {
  254.                   this.user.mainmsg.setStatusMsg("Updating row " + Integer.toString(var5++) + " of " + Integer.toString(var3) + "...", 0);
  255.                   this.DetailGrid1SaveData(var8, "U");
  256.                }
  257.  
  258.                var2.rowChanged[var8] = false;
  259.             }
  260.          }
  261.  
  262.          if (var4 > 0) {
  263.             this.DetailGrid1LoadGrid(var1);
  264.          }
  265.  
  266.       } else {
  267.          this.DetailGrid1LoadEmptyGrid();
  268.       }
  269.    }
  270.  
  271.    public void DetailGrid1DeleteRows(String[] var1) {
  272.       JDPTextGrid var2 = this.DetailGrid1;
  273.       if (var1 != null && var1.length >= 0) {
  274.          int var3 = 0;
  275.          int var4 = 1;
  276.  
  277.          for(int var5 = 0; var5 < var2.rowChanged.length; ++var5) {
  278.             if (var2.rowSelected[var5]) {
  279.                ++var3;
  280.             }
  281.          }
  282.  
  283.          for(int var6 = 0; var6 < var2.rowChanged.length; ++var6) {
  284.             if (var2.rowSelected[var6]) {
  285.                this.user.mainmsg.setStatusMsg("Deleting row " + Integer.toString(var4++) + " of " + Integer.toString(var3) + "...", 0);
  286.                this.DetailGrid1SaveData(var6, "D");
  287.             }
  288.          }
  289.  
  290.          if (var3 > 0) {
  291.             this.DetailGrid1LoadGrid(var1);
  292.          }
  293.  
  294.       } else {
  295.          this.DetailGrid1LoadEmptyGrid();
  296.       }
  297.    }
  298.  
  299.    boolean DetailGrid1SaveData(int var1, String var2) {
  300.       JDPTextGrid var3 = this.DetailGrid1;
  301.       int var4 = 0;
  302.       Vector var5 = new Vector();
  303.       this.jaggSQL.getSEP();
  304.       String var6 = "";
  305.       this.jaggSQL.setDSN("JDP Tutorial");
  306.       this.jaggSQL.setCSTR("DSN=JDP Tutorial;UID=;PWD=;");
  307.       this.jaggSQL.setMRW("1000");
  308.       this.jaggSQL.setTOUT("60");
  309.       if (var2.equals("I")) {
  310.          var6 = "INSERT INTO dbo_sales (stor_id, ord_num, title_id, qty, payterms) VALUES('" + var3.rowKey[var1][0] + "', " + "'" + var3.rowKey[var1][1] + "', " + "'" + (String)var3.pullDownValue[0][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[0][0], var3.currentText[0][var1])) + "', " + "" + var3.currentText[1][var1] + ", " + "'" + (String)var3.pullDownValue[2][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[2][0], var3.currentText[2][var1])) + "')";
  311.       } else if (var2.equals("D")) {
  312.          var6 = "DELETE FROM dbo_sales WHERE stor_id='" + var3.rowKey[var1][0] + "'" + " AND ord_num='" + var3.rowKey[var1][1] + "'" + " AND title_id='" + var3.rowKey[var1][2] + "'";
  313.       } else {
  314.          var6 = "UPDATE dbo_sales SET qty = " + var3.currentText[1][var1] + ", " + "payterms = '" + (String)var3.pullDownValue[2][0].elementAt(this.user.u.listIndexOf(var3.pullDownList[2][0], var3.currentText[2][var1])) + "'" + " WHERE stor_id='" + var3.rowKey[var1][0] + "'" + " AND ord_num='" + var3.rowKey[var1][1] + "'" + " AND title_id='" + var3.rowKey[var1][2] + "'";
  315.       }
  316.  
  317.       var4 = this.jaggSQL.execSQL(var6, var5);
  318.       if (this.user.DEBUG) {
  319.          System.out.println("saveData CNT: " + Integer.toString(var4));
  320.       }
  321.  
  322.       if (var4 == -1) {
  323.          this.user.u.setSqlMessage(this.jaggSQL, var6);
  324.          return false;
  325.       } else {
  326.          if (var4 == 1) {
  327.             if (var2.equals("I")) {
  328.                this.user.mainmsg.setStatusMsg("Record successfully added.", 3);
  329.             } else if (var2.equals("D")) {
  330.                this.user.mainmsg.setStatusMsg("Record successfully removed.", 3);
  331.             } else {
  332.                this.user.mainmsg.setStatusMsg("Record successfully updated.", 3);
  333.             }
  334.          } else {
  335.             this.user.u.setSqlMessage(this.jaggSQL, var6);
  336.          }
  337.  
  338.          return true;
  339.       }
  340.    }
  341.  
  342.    public void DetailGrid1LoadEmptyGrid() {
  343.       JDPTextGrid var1 = this.DetailGrid1;
  344.       byte var2 = 3;
  345.       var1.currentText = new String[var2][50];
  346.       var1.cellChanged = null;
  347.       var1.rowChanged = null;
  348.       var1.columnSelected = null;
  349.       var1.rowKey = new String[50][1];
  350.       var1.newTable();
  351.       var1.totalDataRows = 0;
  352.    }
  353.  
  354.    void DetailGrid1SetGridSettings() {
  355.       if (this.DetailGrid1 == null) {
  356.          this.DetailGrid1 = new JDPTextGrid(this.user);
  357.       }
  358.  
  359.       JDPTextGrid var1 = this.DetailGrid1;
  360.       byte var2 = 3;
  361.       var1.columnHeader = new String[var2];
  362.       var1.columnHeaderStyle = new int[var2];
  363.       var1.columnStyle = new int[var2];
  364.       var1.columnHeaderColor = new Color[var2];
  365.       var1.columnColor = new Color[var2];
  366.       var1.columnBGColor = new Color[var2];
  367.       var1.columnProtected = new boolean[var2];
  368.       var1.columnWidth = new int[var2];
  369.       var1.rightJustify = new boolean[var2];
  370.       var1.rowHeader = null;
  371.       var1.columnHeight = null;
  372.  
  373.       for(int var3 = 0; var3 < var2; ++var3) {
  374.          var1.columnHeaderStyle[var3] = 1;
  375.          var1.columnStyle[var3] = 0;
  376.          var1.columnHeaderColor[var3] = Color.black;
  377.          var1.columnColor[var3] = Color.black;
  378.          var1.columnBGColor[var3] = Color.white;
  379.          var1.columnStyle[var3] = 0;
  380.       }
  381.  
  382.       var1.columnProtected[0] = true;
  383.       var1.columnProtected[2] = true;
  384.       var1.columnWidth[0] = 265;
  385.       var1.columnWidth[1] = 32;
  386.       var1.columnWidth[2] = 98;
  387.       var1.rightJustify[1] = true;
  388.       var1.columnHeader[0] = "Title Id";
  389.       var1.columnHeader[1] = "Qty";
  390.       var1.columnHeader[2] = "Payterms";
  391.       this.DetailGrid1LoadEmptyGrid();
  392.       this.DetailGrid1LoadChoices();
  393.    }
  394.  
  395.    void DetailGrid1LoadChoices() {
  396.       JDPTextGrid var1 = this.DetailGrid1;
  397.       byte var2 = 3;
  398.       this.jaggSQL.setDSN("JDP Tutorial");
  399.       this.jaggSQL.setCSTR("DSN=JDP Tutorial;UID=;PWD=;");
  400.       this.jaggSQL.setMRW("1000");
  401.       this.jaggSQL.setTOUT("60");
  402.       var1.isPullDownCol = new boolean[var2];
  403.       var1.pullDownList = new List[var2][1];
  404.       var1.isPullDownCol[0] = true;
  405.       var1.isPullDownCol[2] = true;
  406.       var1.pullDownList[0][0] = new List();
  407.       var1.pullDownList[2][0] = new List();
  408.       var1.pullDownValue[2][0] = new Vector();
  409.       var1.pullDownList[2][0].addItem("Net 30");
  410.       var1.pullDownValue[2][0].addElement("Net 30");
  411.       var1.pullDownList[2][0].addItem("Net 60");
  412.       var1.pullDownValue[2][0].addElement("Net 60");
  413.       var1.pullDownList[2][0].addItem("ON invoice");
  414.       var1.pullDownValue[2][0].addElement("ON invoice");
  415.       var1.pullDownValue[0][0] = new Vector();
  416.       new JDPLoadChoice(this.user, this.jaggSQL, var1.pullDownList[0][0], "title", "title_id", "dbo_titles", "(1=1)", var1.pullDownValue[0][0]);
  417.    }
  418.  
  419.    public void Columns1Main() {
  420.       this.Columns1LoadChoices();
  421.       this.Columns1ClearFields();
  422.    }
  423.  
  424.    public void Columns1Load(String[] var1) {
  425.       int var3 = 0;
  426.       Vector var4 = new Vector();
  427.       String var5 = this.jaggSQL.getSEP();
  428.       if (var1 != null && var1.length >= 0) {
  429.          String var7 = "SELECT stor_id,stor_name,stor_address,city,state,zip FROM dbo_stores WHERE (1=1)";
  430.          if (var1.length > 0 && var1[0] != null) {
  431.             var7 = var7 + " AND stor_id='" + var1[0] + "'";
  432.          }
  433.  
  434.          this.jaggSQL.setDSN("JDP Tutorial");
  435.          this.jaggSQL.setJdbcDriver("");
  436.          this.jaggSQL.setJdbcPrefix("");
  437.          this.jaggSQL.setJdbcSuffix("");
  438.          this.jaggSQL.setUID("");
  439.          this.jaggSQL.setPWD("");
  440.          this.jaggSQL.setCSTR("DSN=JDP Tutorial;UID=;PWD=;");
  441.          this.jaggSQL.setMRW("1000");
  442.          this.jaggSQL.setTOUT("60");
  443.          this.user.mainmsg.setStatusMsg("Accessing database...", 0);
  444.          var3 = this.jaggSQL.execSQL(var7, var4);
  445.          if (var3 == -1) {
  446.             this.user.u.setSqlMessage(this.jaggSQL, var7);
  447.          } else if (var3 >= 1) {
  448.             String var6 = (String)var4.elementAt(0);
  449.             if (var6 != null && var6.trim().compareTo("") != 0) {
  450.                StringTokenizer var2 = new StringTokenizer(var6);
  451.                this.stor_id1.setText(var2.nextToken(var5).trim());
  452.                this.stor_name1.setText(var2.nextToken(var5).trim());
  453.                this.stor_address1.setText(var2.nextToken(var5).trim());
  454.                this.city1.setText(var2.nextToken(var5).trim());
  455.                this.state1.setText(var2.nextToken(var5).trim());
  456.                this.zip1.setText(var2.nextToken(var5).trim());
  457.             }
  458.  
  459.             if (var3 > 1) {
  460.                this.user.mainmsg.setStatusMsg("Multiple records found - first match only displayed.", 10);
  461.             } else {
  462.                this.user.mainmsg.clearStatusMsg();
  463.             }
  464.          } else {
  465.             this.user.mainmsg.setStatusMsg("Requested entry does not exist.", 10);
  466.             this.Columns1ClearFields();
  467.          }
  468.       } else {
  469.          this.Columns1ClearFields();
  470.       }
  471.    }
  472.  
  473.    public boolean Columns1updateRow(String[] var1) {
  474.       return this.Columns1CheckFields() ? this.Columns1Save(var1, "U") : false;
  475.    }
  476.  
  477.    public boolean Columns1insertRow(String[] var1) {
  478.       return this.Columns1CheckFields() ? this.Columns1Save(var1, "I") : false;
  479.    }
  480.  
  481.    public boolean Columns1removeRow(String[] var1) {
  482.       return this.Columns1Save(var1, "D");
  483.    }
  484.  
  485.    boolean Columns1Save(String[] var1, String var2) {
  486.       int var3 = 0;
  487.       Vector var4 = new Vector();
  488.       this.jaggSQL.getSEP();
  489.       String var5 = "";
  490.       if (var2.equals("I")) {
  491.          var5 = "INSERT INTO dbo_stores (stor_id, stor_name, stor_address, city, state, zip) VALUES('" + this.user.u.replace(this.stor_id1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.stor_name1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.stor_address1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.city1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.state1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.zip1.getText(), "'", "''") + "')";
  492.       } else {
  493.          if (var1 == null || var1.length == 0) {
  494.             this.user.mainmsg.setStatusMsg("You must first make a selection", 5);
  495.             return false;
  496.          }
  497.  
  498.          if (var2.equals("D")) {
  499.             var5 = "DELETE FROM dbo_stores WHERE stor_id='" + var1[0] + "'";
  500.          } else {
  501.             var5 = "UPDATE dbo_stores SET stor_name = '" + this.user.u.replace(this.stor_name1.getText(), "'", "''") + "', " + "stor_address = '" + this.user.u.replace(this.stor_address1.getText(), "'", "''") + "', " + "city = '" + this.user.u.replace(this.city1.getText(), "'", "''") + "', " + "state = '" + this.user.u.replace(this.state1.getText(), "'", "''") + "', " + "zip = '" + this.user.u.replace(this.zip1.getText(), "'", "''") + "'" + " WHERE stor_id='" + var1[0] + "'";
  502.          }
  503.       }
  504.  
  505.       this.jaggSQL.setDSN("JDP Tutorial");
  506.       this.jaggSQL.setJdbcDriver("");
  507.       this.jaggSQL.setJdbcPrefix("");
  508.       this.jaggSQL.setJdbcSuffix("");
  509.       this.jaggSQL.setUID("");
  510.       this.jaggSQL.setPWD("");
  511.       this.jaggSQL.setCSTR("DSN=JDP Tutorial;UID=;PWD=;");
  512.       this.jaggSQL.setMRW("1000");
  513.       this.jaggSQL.setTOUT("60");
  514.       this.user.mainmsg.setStatusMsg("Accessing database...", 0);
  515.       var3 = this.jaggSQL.execSQL(var5, var4);
  516.       if (var3 == -1) {
  517.          this.user.u.setSqlMessage(this.jaggSQL, var5);
  518.          return false;
  519.       } else {
  520.          if (var3 == 1) {
  521.             if (var2.equals("I")) {
  522.                this.user.mainmsg.setStatusMsg("Record successfully added.", 3);
  523.             } else if (var2.equals("D")) {
  524.                this.user.mainmsg.setStatusMsg("Record successfully removed.", 3);
  525.             } else {
  526.                this.user.mainmsg.setStatusMsg("Record successfully updated.", 3);
  527.             }
  528.          } else {
  529.             this.user.u.setSqlMessage(this.jaggSQL, var5);
  530.          }
  531.  
  532.          return true;
  533.       }
  534.    }
  535.  
  536.    public void Columns1ClearFields() {
  537.       this.stor_id1.setText("");
  538.       this.stor_name1.setText("");
  539.       this.stor_address1.setText("");
  540.       this.city1.setText("");
  541.       this.state1.setText("");
  542.       this.zip1.setText("");
  543.    }
  544.  
  545.    void Columns1LoadChoices() {
  546.       this.jaggSQL.setDSN("JDP Tutorial");
  547.       this.jaggSQL.setJdbcDriver("");
  548.       this.jaggSQL.setJdbcPrefix("");
  549.       this.jaggSQL.setJdbcSuffix("");
  550.       this.jaggSQL.setUID("");
  551.       this.jaggSQL.setPWD("");
  552.       this.jaggSQL.setCSTR("DSN=JDP Tutorial;UID=;PWD=;");
  553.       this.jaggSQL.setMRW("1000");
  554.       this.jaggSQL.setTOUT("60");
  555.    }
  556.  
  557.    public boolean Columns1CheckFields() {
  558.       return true;
  559.    }
  560.  
  561.    public void ResultList1Main() {
  562.       String var1 = "a.stor_id,a.ord_num";
  563.       String[] var2 = new String[]{"a.ord_num"};
  564.       String var3 = "(1=1)";
  565.       String[] var4 = new String[]{"Store  name", "Store Address"};
  566.       String[] var5 = new String[]{"b.stor_name", "b.stor_address"};
  567.       this.jaggSQL.setDSN("JDP Tutorial");
  568.       this.jaggSQL.setCSTR("DSN=JDP Tutorial;UID=;PWD=;");
  569.       this.jaggSQL.setMRW("1000");
  570.       this.jaggSQL.setTOUT("60");
  571.       this.ResultList1 = new JDPSearchResults(this.user, super.targetPanel, true, this.jaggSQL, false, var1, var2, var3, var4, var5, var5, "", true, "Total Entries:");
  572.       int[] var6 = new int[]{3, 5, 8, 0, 0};
  573.       this.ResultList1.setMinWidth(170);
  574.       this.ResultList1.setIcons(var6);
  575.       this.ResultList1.setFromWhereClause(" FROM dbo_sales a,dbo_stores b WHERE a.stor_id = b.stor_id AND (1=1)");
  576.       this.ResultList1.clearList("");
  577.       this.ResultList1.loadList();
  578.    }
  579.  
  580.    public void SearchPanel1Main() {
  581.       String[] var1 = new String[6];
  582.       String[] var2 = new String[6];
  583.       Vector var3 = new Vector();
  584.       Vector var4 = new Vector();
  585.       var1[0] = "Order Num";
  586.       var2[0] = "a.ord_num";
  587.       var1[1] = "Quantity";
  588.       var2[1] = "a.qty";
  589.       var1[2] = "Store name";
  590.       var2[2] = "b.stor_name";
  591.       var1[3] = "Store Address";
  592.       var2[3] = "b.stor_address";
  593.       var1[4] = "City";
  594.       var2[4] = "b.city";
  595.       var1[5] = "State";
  596.       var2[5] = "b.state";
  597.       var3.addElement(new Vector());
  598.       var4.addElement(new Vector());
  599.       var3.addElement(new Vector());
  600.       var4.addElement(new Vector());
  601.       var3.addElement(new Vector());
  602.       var4.addElement(new Vector());
  603.       var3.addElement(new Vector());
  604.       var4.addElement(new Vector());
  605.       var3.addElement(new Vector());
  606.       var4.addElement(new Vector());
  607.       var3.addElement(new Vector());
  608.       var4.addElement(new Vector());
  609.       ((Vector)var3.elementAt(0)).addElement("Begins with");
  610.       ((Vector)var4.elementAt(0)).addElement("like");
  611.       ((Vector)var3.elementAt(0)).addElement("Contains");
  612.       ((Vector)var4.elementAt(0)).addElement("like");
  613.       ((Vector)var3.elementAt(1)).addElement("Greater than");
  614.       ((Vector)var4.elementAt(1)).addElement(">");
  615.       ((Vector)var3.elementAt(1)).addElement("Less than");
  616.       ((Vector)var4.elementAt(1)).addElement("<");
  617.       ((Vector)var3.elementAt(1)).addElement("Equal to");
  618.       ((Vector)var4.elementAt(1)).addElement("=");
  619.       ((Vector)var3.elementAt(2)).addElement("Begins with");
  620.       ((Vector)var4.elementAt(2)).addElement("like");
  621.       ((Vector)var3.elementAt(2)).addElement("Contains");
  622.       ((Vector)var4.elementAt(2)).addElement("like");
  623.       ((Vector)var3.elementAt(3)).addElement("Begins with");
  624.       ((Vector)var4.elementAt(3)).addElement("like");
  625.       ((Vector)var3.elementAt(3)).addElement("Contains");
  626.       ((Vector)var4.elementAt(3)).addElement("like");
  627.       ((Vector)var3.elementAt(4)).addElement("Begins with");
  628.       ((Vector)var4.elementAt(4)).addElement("like");
  629.       ((Vector)var3.elementAt(4)).addElement("Contains");
  630.       ((Vector)var4.elementAt(4)).addElement("like");
  631.       ((Vector)var3.elementAt(5)).addElement("Begins with");
  632.       ((Vector)var4.elementAt(5)).addElement("like");
  633.       ((Vector)var3.elementAt(5)).addElement("Contains");
  634.       ((Vector)var4.elementAt(5)).addElement("like");
  635.       int[] var5 = new int[6];
  636.       boolean[] var6 = new boolean[6];
  637.       var5[0] = 8;
  638.       var6[0] = true;
  639.       var5[1] = 24;
  640.       var6[1] = false;
  641.       var5[2] = 20;
  642.       var6[2] = true;
  643.       var5[3] = 6;
  644.       var6[3] = true;
  645.       var5[4] = 16;
  646.       var6[4] = true;
  647.       var5[5] = 10;
  648.       var6[5] = true;
  649.       this.SearchPanel1 = new JDPWhereClause(this.user, super.targetPanel, "", true, "Stor name", var1, var2, var3, var4, (String[][])null, (String[][])null, var5, var6, "FROM dbo_sales a,dbo_stores b WHERE a.stor_id = b.stor_id AND (1=1)");
  650.    }
  651. }
  652.