home *** CD-ROM | disk | FTP | other *** search
/ CD Actual Thematic 7: Programming / CDAT7.iso / Share / Java / JDesignerPro / Jdp3_0.exe / data1.cab / Program_Files / SalesInquiry.class (.txt) < prev    next >
Encoding:
Java Class File  |  1999-04-09  |  14.6 KB  |  570 lines
  1. import java.awt.BorderLayout;
  2. import java.awt.Checkbox;
  3. import java.awt.CheckboxGroup;
  4. import java.awt.Color;
  5. import java.awt.Container;
  6. import java.awt.Event;
  7. import java.awt.Font;
  8. import java.awt.Label;
  9. import java.awt.Panel;
  10. import java.awt.TextField;
  11. import java.util.StringTokenizer;
  12. import java.util.Vector;
  13.  
  14. public class SalesInquiry extends JDPClassLayout {
  15.    JDPUser user;
  16.    JDPJagg jaggSQL;
  17.    JDPPopupMessage popuppanel;
  18.    JDPMaskEdit JDPMaskEditMain;
  19.    String moduleParameter;
  20.    Panel Main;
  21.    JDPSearchResults ResultList1;
  22.    JDPFormatDoc Formatter1;
  23.    Panel Panel1;
  24.    Panel Columns1;
  25.    JDPScrollPanel ScrollPanel1;
  26.    Label stor_idLabel1;
  27.    TextField stor_id1;
  28.    Label ord_numLabel1;
  29.    JDPComboBox ord_num1;
  30.    Vector valueord_num1;
  31.    Label ord_dateLabel1;
  32.    JDPDate ord_date1;
  33.    Label qtyLabel1;
  34.    JDPSpinner qty1;
  35.    Label paytermsLabel1;
  36.    Panel paytermsLine1;
  37.    Checkbox payterms1;
  38.    Checkbox payterms11;
  39.    Checkbox payterms12;
  40.    Label title_idLabel1;
  41.    TextField title_id1;
  42.    JDPButtons JDPButtons1;
  43.    JDPTextGrid ReportLayout1;
  44.  
  45.    public void InitClass(JDPUser var1, Panel var2, String var3) {
  46.       this.user = var1;
  47.       this.moduleParameter = var3;
  48.       this.jaggSQL = new JDPJagg(var1.jaggPath);
  49.       ((Container)this).setLayout(new BorderLayout());
  50.       this.popuppanel = new JDPPopupMessage(var1, this);
  51.       ((Container)this).add(this.popuppanel);
  52.       this.JDPMaskEditMain = new JDPMaskEdit();
  53.       CheckboxGroup var4 = new CheckboxGroup();
  54.       this.Main = new Panel();
  55.       this.ResultList1Main();
  56.       this.Formatter1 = new JDPFormatDoc(var1);
  57.       this.Panel1 = new Panel();
  58.       this.Columns1 = new Panel();
  59.       this.ScrollPanel1 = new JDPScrollPanel();
  60.       this.stor_idLabel1 = new Label("Stor Id:", 0);
  61.       this.stor_id1 = new TextField("stor_id", 6);
  62.       this.ord_numLabel1 = new Label("Ord Num:", 0);
  63.       this.ord_num1 = new JDPComboBox(var1);
  64.       this.ord_dateLabel1 = new Label("Ord Date:", 0);
  65.       this.ord_date1 = new JDPDate(var1, "", 18);
  66.       this.qtyLabel1 = new Label("Qty:", 0);
  67.       this.qty1 = new JDPSpinner(var1, "", 4);
  68.       this.paytermsLabel1 = new Label("Payterms:", 0);
  69.       this.paytermsLine1 = new Panel();
  70.       this.payterms1 = new Checkbox("Net 30", var4, true);
  71.       this.payterms11 = new Checkbox("Net 60", var4, false);
  72.       this.payterms12 = new Checkbox("ON invoice", var4, false);
  73.       this.title_idLabel1 = new Label("Title Id:", 0);
  74.       this.title_id1 = new TextField("title_id", 8);
  75.       String[] var5 = new String[]{"Print"};
  76.       int[] var6 = new int[]{JDPButton.getIconValue("Printer")};
  77.       this.JDPButtons1 = new JDPButtons(var1, var5, var6, JDPButtons.getAlignmentValue("Horizontal"));
  78.       this.ReportLayout1Main();
  79.       this.Main.setLayout(new BorderLayout());
  80.       ((Container)this).add("Center", this.Main);
  81.       this.Main.add("West", this.ResultList1);
  82.       this.Main.add("Center", this.Panel1);
  83.       this.Panel1.setLayout(new BorderLayout());
  84.       this.Panel1.add("North", this.Columns1);
  85.       this.Columns1.setLayout(new BorderLayout());
  86.       this.Columns1Main();
  87.       this.Columns1.add("Center", this.ScrollPanel1);
  88.       this.ScrollPanel1.add("Left", this.stor_idLabel1);
  89.       this.ScrollPanel1.add("Right", this.stor_id1);
  90.       this.ScrollPanel1.add("Left", this.ord_numLabel1);
  91.       this.ScrollPanel1.add("Right", this.ord_num1);
  92.       this.ScrollPanel1.add("Left", this.ord_dateLabel1);
  93.       this.ScrollPanel1.add("Right", this.ord_date1);
  94.       this.ScrollPanel1.add("Left", this.qtyLabel1);
  95.       this.ScrollPanel1.add("Right", this.qty1);
  96.       this.ScrollPanel1.add("Left", this.paytermsLabel1);
  97.       this.ScrollPanel1.add("Right", this.paytermsLine1);
  98.       this.paytermsLine1.setLayout(new JDPLineLayout());
  99.       this.paytermsLine1.add("Left", this.payterms1);
  100.       this.paytermsLine1.add("Left", this.payterms11);
  101.       this.paytermsLine1.add("Left", this.payterms12);
  102.       this.ScrollPanel1.add("Left", this.title_idLabel1);
  103.       this.ScrollPanel1.add("Right", this.title_id1);
  104.       this.Panel1.add("South", this.JDPButtons1);
  105.       this.Panel1.add("Center", this.ReportLayout1);
  106.       this.InitComponents();
  107.       var1.gParm.addElement(this);
  108.    }
  109.  
  110.    public boolean handleEvent(Event var1) {
  111.       switch (var1.id) {
  112.          case 503:
  113.          case 504:
  114.          case 505:
  115.             this.popuppanel.postEvent(var1);
  116.             return false;
  117.          case 1001:
  118.             if (var1.target.equals(this.ResultList1)) {
  119.                this.Columns1Load(this.ResultList1.getSelectedKey());
  120.                this.ReportLayout1LoadGrid(this.ResultList1.getSelectedKey());
  121.                return true;
  122.             } else {
  123.                if (var1.target.equals(this.JDPButtons1.button[0])) {
  124.                   this.Formatter1.initDocument(0);
  125.                   this.Formatter1.setBody("");
  126.                   this.Formatter1.addComponent(this.Columns1);
  127.                   this.Formatter1.addReport(this.ReportLayout1);
  128.                   this.Formatter1.finishOutput();
  129.                   this.Formatter1.loadDocument();
  130.                   return true;
  131.                }
  132.  
  133.                return false;
  134.             }
  135.          default:
  136.             return false;
  137.       }
  138.    }
  139.  
  140.    public void InitComponents() {
  141.    }
  142.  
  143.    public void ResultList1Main() {
  144.       String var1 = "stor_id,ord_num,title_id";
  145.       String[] var2 = new String[]{"ord_num", "title_id"};
  146.       String var3 = "(1=1)";
  147.       String[] var4 = new String[]{"Stor Id"};
  148.       String[] var5 = new String[]{"stor_id"};
  149.       this.jaggSQL.setDSN("JDP Tutorial");
  150.       this.jaggSQL.setJdbcDriver("sun.jdbc.odbc.JdbcOdbcDriver");
  151.       this.jaggSQL.setJdbcPrefix("jdbc:odbc:");
  152.       this.jaggSQL.setJdbcSuffix("JDP Tutorial");
  153.       this.jaggSQL.setUID("");
  154.       this.jaggSQL.setPWD("");
  155.       this.jaggSQL.setCSTR(" ");
  156.       this.jaggSQL.setMRW("1000");
  157.       this.jaggSQL.setTOUT("60");
  158.       this.ResultList1 = new JDPSearchResults(this.user, super.targetPanel, true, this.jaggSQL, false, var1, var2, var3, var4, var5, var5, "", true, "Total Entries:");
  159.       int[] var6 = new int[8];
  160.       var6[0] = 3;
  161.       var6[1] = 5;
  162.       var6[2] = 1;
  163.       var6[3] = 8;
  164.       this.ResultList1.setMinWidth(130);
  165.       this.ResultList1.setIcons(var6);
  166.       this.ResultList1.setFromWhereClause(" FROM dbo_sales WHERE (1=1)");
  167.       this.ResultList1.clearList("");
  168.       this.ResultList1.loadList();
  169.    }
  170.  
  171.    public void Columns1Main() {
  172.       this.Columns1LoadChoices();
  173.       this.Columns1ClearFields();
  174.    }
  175.  
  176.    public void Columns1Load(String[] var1) {
  177.       int var3 = 0;
  178.       Vector var4 = new Vector();
  179.       String var5 = this.jaggSQL.getSEP();
  180.       if (var1 != null && var1.length >= 0) {
  181.          String var8 = "SELECT stor_id,ord_num,format(ord_date, 'mm/dd/yy'),qty,payterms,title_id FROM dbo_sales WHERE (1=1)";
  182.          if (var1.length > 0 && var1[0] != null) {
  183.             var8 = var8 + " AND stor_id='" + var1[0] + "'";
  184.          }
  185.  
  186.          if (var1.length > 1 && var1[1] != null) {
  187.             var8 = var8 + " AND ord_num='" + var1[1] + "'";
  188.          }
  189.  
  190.          if (var1.length > 2 && var1[2] != null) {
  191.             var8 = var8 + " AND title_id='" + var1[2] + "'";
  192.          }
  193.  
  194.          this.jaggSQL.setDSN("JDP Tutorial");
  195.          this.jaggSQL.setJdbcDriver("sun.jdbc.odbc.JdbcOdbcDriver");
  196.          this.jaggSQL.setJdbcPrefix("jdbc:odbc:");
  197.          this.jaggSQL.setJdbcSuffix("JDP Tutorial");
  198.          this.jaggSQL.setUID("");
  199.          this.jaggSQL.setPWD("");
  200.          this.jaggSQL.setCSTR(" ");
  201.          this.jaggSQL.setMRW("1000");
  202.          this.jaggSQL.setTOUT("60");
  203.          this.user.mainmsg.setStatusMsg("Accessing database...", 0);
  204.          var3 = this.jaggSQL.execSQL(var8, var4);
  205.          if (var3 == -1) {
  206.             this.user.u.setSqlMessage(this.jaggSQL, var8);
  207.          } else if (var3 >= 1) {
  208.             String var6 = (String)var4.elementAt(0);
  209.             if (var6 != null && var6.trim().compareTo("") != 0) {
  210.                StringTokenizer var2 = new StringTokenizer(var6);
  211.                this.stor_id1.setText(var2.nextToken(var5).trim());
  212.                this.ord_num1.setText(var2.nextToken(var5).trim());
  213.                this.ord_date1.setText(var2.nextToken(var5).trim());
  214.                this.qty1.setText(var2.nextToken(var5).trim());
  215.                String var7 = var2.nextToken(var5).trim();
  216.                this.payterms1.setState(var7.equals("Net 30"));
  217.                this.payterms11.setState(var7.equals("Net 60"));
  218.                this.payterms12.setState(var7.equals("ON invoice"));
  219.                this.title_id1.setText(var2.nextToken(var5).trim());
  220.             }
  221.  
  222.             if (var3 > 1) {
  223.                this.user.mainmsg.setStatusMsg("Multiple records found - first match only displayed.", 10);
  224.             } else {
  225.                this.user.mainmsg.clearStatusMsg();
  226.             }
  227.          } else {
  228.             this.user.mainmsg.setStatusMsg("Requested entry does not exist.", 10);
  229.             this.Columns1ClearFields();
  230.          }
  231.       } else {
  232.          this.Columns1ClearFields();
  233.       }
  234.    }
  235.  
  236.    public boolean Columns1updateRow(String[] var1) {
  237.       return this.Columns1CheckFields() ? this.Columns1Save(var1, "U") : false;
  238.    }
  239.  
  240.    public boolean Columns1insertRow(String[] var1) {
  241.       return this.Columns1CheckFields() ? this.Columns1Save(var1, "I") : false;
  242.    }
  243.  
  244.    public boolean Columns1removeRow(String[] var1) {
  245.       return this.Columns1Save(var1, "D");
  246.    }
  247.  
  248.    boolean Columns1Save(String[] var1, String var2) {
  249.       int var3 = 0;
  250.       Vector var4 = new Vector();
  251.       this.jaggSQL.getSEP();
  252.       String var5 = "";
  253.       if (var2.equals("I")) {
  254.          var5 = "INSERT INTO dbo_sales (stor_id, ord_num, ord_date, qty, payterms, title_id) VALUES('" + this.user.u.replace(this.stor_id1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.ord_num1.getText(), "'", "''") + "', " + "'" + this.user.u.replace(this.ord_date1.getText(), "'", "''") + "', " + "" + JDPUtils.tonum(this.qty1.getText()) + ", " + "'" + (this.payterms1.getState() ? "Net 30" : (this.payterms11.getState() ? "Net 60" : (this.payterms12.getState() ? "ON invoice" : " "))) + "', " + "'" + this.user.u.replace(this.title_id1.getText(), "'", "''") + "')";
  255.       } else {
  256.          if (var1 == null || var1.length == 0) {
  257.             this.user.mainmsg.setStatusMsg("You must first make a selection", 5);
  258.             return false;
  259.          }
  260.  
  261.          if (var2.equals("D")) {
  262.             var5 = "DELETE FROM dbo_sales WHERE stor_id='" + var1[0] + "'" + " AND ord_num='" + var1[1] + "'" + " AND title_id='" + var1[2] + "'";
  263.          } else {
  264.             var5 = "UPDATE dbo_sales SET ord_date = '" + this.user.u.replace(this.ord_date1.getText(), "'", "''") + "', " + "qty = " + JDPUtils.tonum(this.qty1.getText()) + ", " + "payterms = '" + (this.payterms1.getState() ? "Net 30" : (this.payterms11.getState() ? "Net 60" : (this.payterms12.getState() ? "ON invoice" : " "))) + "'" + " WHERE stor_id='" + var1[0] + "'" + " AND ord_num='" + var1[1] + "'" + " AND title_id='" + var1[2] + "'";
  265.          }
  266.       }
  267.  
  268.       this.jaggSQL.setDSN("JDP Tutorial");
  269.       this.jaggSQL.setJdbcDriver("sun.jdbc.odbc.JdbcOdbcDriver");
  270.       this.jaggSQL.setJdbcPrefix("jdbc:odbc:");
  271.       this.jaggSQL.setJdbcSuffix("JDP Tutorial");
  272.       this.jaggSQL.setUID("");
  273.       this.jaggSQL.setPWD("");
  274.       this.jaggSQL.setCSTR(" ");
  275.       this.jaggSQL.setMRW("1000");
  276.       this.jaggSQL.setTOUT("60");
  277.       this.user.mainmsg.setStatusMsg("Accessing database...", 0);
  278.       var3 = this.jaggSQL.execSQL(var5, var4);
  279.       if (var3 == -1) {
  280.          this.user.u.setSqlMessage(this.jaggSQL, var5);
  281.          return false;
  282.       } else {
  283.          if (var3 == 1) {
  284.             if (var2.equals("I")) {
  285.                this.user.mainmsg.setStatusMsg("Record successfully added.", 3);
  286.             } else if (var2.equals("D")) {
  287.                this.user.mainmsg.setStatusMsg("Record successfully removed.", 3);
  288.             } else {
  289.                this.user.mainmsg.setStatusMsg("Record successfully updated.", 3);
  290.             }
  291.          } else {
  292.             this.user.u.setSqlMessage(this.jaggSQL, var5);
  293.          }
  294.  
  295.          return true;
  296.       }
  297.    }
  298.  
  299.    public void Columns1ClearFields() {
  300.       this.stor_id1.setText("");
  301.       this.ord_num1.setText("");
  302.       this.ord_date1.setText("");
  303.       this.qty1.setText("");
  304.       this.payterms1.setState(false);
  305.       this.payterms11.setState(false);
  306.       this.payterms12.setState(false);
  307.       this.title_id1.setText("");
  308.    }
  309.  
  310.    void Columns1LoadChoices() {
  311.       this.jaggSQL.setDSN("JDP Tutorial");
  312.       this.jaggSQL.setJdbcDriver("sun.jdbc.odbc.JdbcOdbcDriver");
  313.       this.jaggSQL.setJdbcPrefix("jdbc:odbc:");
  314.       this.jaggSQL.setJdbcSuffix("JDP Tutorial");
  315.       this.jaggSQL.setUID("");
  316.       this.jaggSQL.setPWD("");
  317.       this.jaggSQL.setCSTR(" ");
  318.       this.jaggSQL.setMRW("1000");
  319.       this.jaggSQL.setTOUT("60");
  320.       new JDPLoadChoice(this.user, this.jaggSQL, this.ord_num1, "ord_num", "ord_num", "dbo_sales", "(1=1)", (Vector)null);
  321.    }
  322.  
  323.    public boolean Columns1CheckFields() {
  324.       return true;
  325.    }
  326.  
  327.    public void ReportLayout1Main() {
  328.       this.ReportLayout1SetGridSettings();
  329.    }
  330.  
  331.    public void ReportLayout1LoadGrid(String[] var1) {
  332.       JDPTextGrid var2 = this.ReportLayout1;
  333.       if (var1 != null && var1.length >= 0) {
  334.          int var4 = 0;
  335.          Vector var5 = new Vector();
  336.          String var6 = this.jaggSQL.getSEP();
  337.          int var7 = 0;
  338.          byte var11 = 6;
  339.          this.jaggSQL.setDSN("JDP Tutorial");
  340.          this.jaggSQL.setUID("");
  341.          this.jaggSQL.setPWD("");
  342.          this.jaggSQL.setMRW("1000");
  343.          this.jaggSQL.setTOUT("60");
  344.          new Vector();
  345.          new Vector();
  346.          String var12 = "SELECT stor_id, ord_num, format(ord_date, 'mm/dd/yy'), qty, payterms, title_id FROM dbo_sales WHERE (1=1)  ";
  347.          if (var1.length > 0 && var1[0] != null) {
  348.             var12 = var12 + " AND stor_id='" + var1[0] + "'" + " ORDER BY stor_id,ord_num";
  349.          }
  350.  
  351.          this.user.mainmsg.setStatusMsg("Accessing database...", 0);
  352.          var4 = this.jaggSQL.execSQL(var12, var5);
  353.          if (var4 == -1) {
  354.             this.user.u.setSqlMessage(this.jaggSQL, var12);
  355.          } else {
  356.             var7 = this.jaggSQL.getRowCount();
  357.             var2.currentText = new String[var11][var7 + 30];
  358.             var2.cellFont = new Font[var11][var7 + 30];
  359.             var2.gridColor = Color.white;
  360.             boolean[] var13 = new boolean[var11];
  361.             String[] var14 = new String[var11];
  362.             boolean[] var15 = new boolean[6];
  363.             boolean[] var16 = new boolean[6];
  364.             byte var17 = 2;
  365.             var15[1] = true;
  366.             var16[0] = true;
  367.             var13[3] = true;
  368.             float[][] var9 = new float[1][1];
  369.             float[][] var10 = new float[1][1];
  370.             int var18 = 0;
  371.             int var19 = var11 / 2 - 1;
  372.             if (var19 < 0) {
  373.                var19 = 0;
  374.             }
  375.  
  376.             var2.currentText[var19][1] = " REPORT";
  377.             var2.cellFont[var19][1] = new Font(this.user.plainFont.getName(), 1, this.user.plainFont.getSize() + 4);
  378.  
  379.             for(int var20 = 0; var20 < var11; ++var20) {
  380.                var2.cellFont[var20][3] = this.user.boldFont;
  381.             }
  382.  
  383.             var2.currentText[0][3] = "Stor Id";
  384.             var2.currentText[1][3] = "Ord Num";
  385.             var2.currentText[2][3] = "Ord Date";
  386.             var2.currentText[3][3] = "Qty";
  387.             var2.currentText[4][3] = "Payterms";
  388.             var2.currentText[5][3] = "Title Id";
  389.             var18 = 4;
  390.             var9 = new float[var17][var11];
  391.             var10 = new float[var17][var11];
  392.  
  393.             int var21;
  394.             for(var21 = 0; var21 < var7; ++var21) {
  395.                String var8 = (String)var5.elementAt(var21);
  396.                if (var8 != null && var8.trim().compareTo("") != 0) {
  397.                   StringTokenizer var3 = new StringTokenizer(var8);
  398.  
  399.                   for(int var22 = 0; var22 < var11; ++var22) {
  400.                      var2.currentText[var22][var21 + var18] = var3.nextToken(var6).trim();
  401.                      if (var2.maskEdit[var22] != null) {
  402.                         if (var2.maskType[var22] == "Float") {
  403.                            var2.currentText[var22][var21 + var18] = this.JDPMaskEditMain.formatFloat(var2.currentText[var22][var21 + var18], var2.maskEdit[var22]);
  404.                         } else {
  405.                            var2.currentText[var22][var21 + var18] = this.JDPMaskEditMain.formatString(var2.currentText[var22][var21 + var18], var2.maskEdit[var22]);
  406.                         }
  407.                      }
  408.                   }
  409.  
  410.                   for(int var23 = var11 - 1; var23 >= 0; --var23) {
  411.                      String var24 = var2.currentText[var23][var21 + var18];
  412.                      if (var17 > var23 && var21 > 0) {
  413.                         if (var24.equals(var14[var23])) {
  414.                            var2.currentText[var23][var21 + var18] = "";
  415.                         } else {
  416.                            if (var15[var23]) {
  417.                               for(int var25 = 0; var25 < var11; ++var25) {
  418.                                  var2.currentText[var25][var21 + var18 + 1] = var2.currentText[var25][var21 + var18];
  419.                                  var2.currentText[var25][var21 + var18] = "";
  420.                                  var2.cellFont[var25][var21 + var18 + 1] = var2.cellFont[var25][var21 + var18];
  421.                                  var2.cellFont[var25][var21 + var18] = null;
  422.                               }
  423.  
  424.                               var2.currentText[var23][var21 + var18] = "Subtotal";
  425.                               var2.cellFont[var23][var21 + var18] = this.user.boldFont;
  426.  
  427.                               for(int var26 = var23 + 1; var26 < var11; ++var26) {
  428.                                  if (var13[var26]) {
  429.                                     var2.currentText[var26][var21 + var18] = this.JDPMaskEditMain.formatFloat(var9[var23][var26], var2.maskEdit[var26]);
  430.                                     var2.cellFont[var26][var21 + var18] = this.user.boldFont;
  431.                                  }
  432.  
  433.                                  var9[var23][var26] = 0.0F;
  434.                               }
  435.  
  436.                               ++var18;
  437.                            }
  438.  
  439.                            var2.currentText[var23][var21 + var18] = var24;
  440.                         }
  441.                      }
  442.  
  443.                      if (var17 > 0 && var21 > 0) {
  444.                         try {
  445.                            float var40 = Float.valueOf(this.JDPMaskEditMain.stripFloat(var14[var23]));
  446.  
  447.                            for(int var42 = 0; var42 < var17; ++var42) {
  448.                               var9[var42][var23] += var40;
  449.                               var10[var42][var23] += var40;
  450.                            }
  451.                         } catch (Exception var28) {
  452.                         }
  453.                      }
  454.  
  455.                      var14[var23] = var24;
  456.                   }
  457.                }
  458.             }
  459.  
  460.             for(int var34 = 0; var34 < var11; ++var34) {
  461.                try {
  462.                   float var35 = Float.valueOf(this.JDPMaskEditMain.stripFloat(var14[var34]));
  463.  
  464.                   for(int var37 = 0; var37 < var17; ++var37) {
  465.                      var9[var37][var34] += var35;
  466.                      var10[var37][var34] += var35;
  467.                   }
  468.                } catch (Exception var27) {
  469.                }
  470.             }
  471.  
  472.             for(int var36 = var11 - 1; var36 >= 0; --var36) {
  473.                if (var17 > var36 && var15[var36]) {
  474.                   var2.currentText[var36][var21 + var18] = "Subtotal";
  475.                   var2.cellFont[var36][var21 + var18] = this.user.boldFont;
  476.  
  477.                   for(int var38 = var36 + 1; var38 < var11; ++var38) {
  478.                      if (var13[var38]) {
  479.                         var2.currentText[var38][var21 + var18] = this.JDPMaskEditMain.formatFloat(var9[var36][var38], var2.maskEdit[var38]);
  480.                         var2.cellFont[var38][var21 + var18] = this.user.boldFont;
  481.                      }
  482.                   }
  483.  
  484.                   ++var18;
  485.                }
  486.             }
  487.  
  488.             for(int var39 = var11 - 1; var39 >= 0; --var39) {
  489.                if (var17 > var39 && var16[var39]) {
  490.                   var2.currentText[var39][var21 + var18] = "Total";
  491.                   var2.cellFont[var39][var21 + var18] = this.user.boldFont;
  492.  
  493.                   for(int var41 = var39 + 1; var41 < var11; ++var41) {
  494.                      if (var13[var41]) {
  495.                         var2.currentText[var41][var21 + var18] = this.JDPMaskEditMain.formatFloat(var10[var39][var41], var2.maskEdit[var41]);
  496.                         var2.cellFont[var41][var21 + var18] = this.user.boldFont;
  497.                      }
  498.                   }
  499.  
  500.                   ++var18;
  501.                }
  502.             }
  503.  
  504.             var2.newTable();
  505.             this.user.mainmsg.clearStatusMsg();
  506.          }
  507.       } else {
  508.          this.ReportLayout1LoadEmptyGrid();
  509.       }
  510.    }
  511.  
  512.    public void ReportLayout1LoadEmptyGrid() {
  513.       JDPTextGrid var1 = this.ReportLayout1;
  514.       byte var2 = 6;
  515.       var1.currentText = new String[var2][50];
  516.       var1.cellChanged = null;
  517.       var1.rowChanged = null;
  518.       var1.columnSelected = null;
  519.       var1.rowKey = new String[50][1];
  520.       var1.newTable();
  521.       var1.totalDataRows = 0;
  522.    }
  523.  
  524.    void ReportLayout1SetGridSettings() {
  525.       if (this.ReportLayout1 == null) {
  526.          this.ReportLayout1 = new JDPTextGrid(this.user);
  527.       }
  528.  
  529.       JDPTextGrid var1 = this.ReportLayout1;
  530.       byte var2 = 6;
  531.       var1.columnHeader = null;
  532.       var1.columnHeaderStyle = new int[var2];
  533.       var1.columnStyle = new int[var2];
  534.       var1.columnHeaderColor = new Color[var2];
  535.       var1.columnColor = new Color[var2];
  536.       var1.columnBGColor = new Color[var2];
  537.       var1.columnProtected = new boolean[var2];
  538.       var1.columnWidth = new int[var2];
  539.       var1.rightJustify = new boolean[var2];
  540.       var1.rowHeader = null;
  541.       var1.columnHeight = null;
  542.       var1.maskEdit = new String[var2];
  543.       var1.maskType = new String[var2];
  544.  
  545.       for(int var3 = 0; var3 < var2; ++var3) {
  546.          var1.columnHeaderStyle[var3] = 1;
  547.          var1.columnStyle[var3] = 0;
  548.          var1.columnHeaderColor[var3] = Color.black;
  549.          var1.columnColor[var3] = Color.black;
  550.          var1.columnBGColor[var3] = Color.white;
  551.          var1.columnStyle[var3] = 0;
  552.       }
  553.  
  554.       var1.columnProtected[0] = true;
  555.       var1.columnProtected[1] = true;
  556.       var1.columnProtected[2] = true;
  557.       var1.columnProtected[3] = true;
  558.       var1.columnProtected[4] = true;
  559.       var1.columnProtected[5] = true;
  560.       var1.columnWidth[0] = 46;
  561.       var1.columnWidth[1] = 150;
  562.       var1.columnWidth[2] = 126;
  563.       var1.columnWidth[3] = 32;
  564.       var1.columnWidth[4] = 98;
  565.       var1.columnWidth[5] = 56;
  566.       var1.rightJustify[3] = true;
  567.       this.ReportLayout1LoadEmptyGrid();
  568.    }
  569. }
  570.