Example #1
0
 private void menu_Click(object sender, EventArgs e)
 {
     C1.C1Excel.C1XLBook c1XLBook1 = new C1.C1Excel.C1XLBook();;
     //string sql="";
     switch (mnu1.MenuItems.IndexOf((MenuItem)sender))
     {
     case 0:
         GP8000.Personnel.Report.ReportFromVS rpt = new GP8000.Personnel.Report.ReportFromVS();
         rpt.RPT2(c1XLBook1, vs, mnu1.MenuItems[mnu1.MenuItems.IndexOf((MenuItem)sender)].Text, "STD_TA_06");
         break;
     }
 }
Example #2
0
 private void cmd_print_Click(object sender, System.EventArgs e)
 {
     if (vs.Row > 0)
     {
         C1.C1Excel.C1XLBook c1XLBook1            = new C1.C1Excel.C1XLBook();
         GP8000.Personnel.Report.ReportFromVS rpt = new GP8000.Personnel.Report.ReportFromVS();
         string wh = "";
         wh = control1.GetWhere("FILB01A", true);
         if (ck.Checked)
         {
             if (wh != "")
             {
                 wh += " and ";
             }
             wh += " (ATT_DT between '" + DateTime.Parse(dt1.Value + "").ToString("yyyy/MM/dd") + "' and '"
                   + DateTime.Parse(dt2.Value + "").ToString("yyyy/MM/dd") + "')";
         }
         rpt.RPTta(c1XLBook1, vs.Rows[vs.Row]["RPT_ID"] + "", vs.Rows[vs.Row]["RPT_DR"] + "", wh);
     }
 }
Example #3
0
        string Convert(string fileName)
        {
            // load excel file
            var book = new C1.C1Excel.C1XLBook();

            book.Load(fileName);
            var sheet = book.Sheets[0];

            // get column names
            var columnNames = new Dictionary <int, string>();

            for (int c = 0; c < sheet.Columns.Count; c++)
            {
                var name = sheet[0, c].Value;
                if (name == null)
                {
                    break;
                }
                var colName = new StringBuilder();
                foreach (var chr in name.ToString().Trim().ToLower())
                {
                    if (char.IsLetterOrDigit(chr) || chr == '_')
                    {
                        colName.Append(chr);
                    }
                }
                columnNames[c] = colName.ToString();
            }

            // build JSON array for all items in the sheet
            var sbArr = new StringBuilder();

            for (int r = 1; r < sheet.Rows.Count; r++)
            {
                // build Json for this item
                var sbItem = new StringBuilder();
                foreach (var kn in columnNames)
                {
                    var value = sheet[r, kn.Key].Value;
                    if (value != null)
                    {
                        if (sbItem.Length > 0)
                        {
                            sbItem.Append(", ");
                        }
                        if (value is string)
                        {
                            var str = value.ToString().Trim().Replace('\"', '\'');
                            sbItem.AppendFormat("\"{0}\": \"{1}\"", kn.Value, str);
                        }
                        else
                        {
                            sbItem.AppendFormat("\"{0}\": {1}", kn.Value, value);
                        }
                    }
                }

                // empty item? exit
                if (sbItem.Length == 0)
                {
                    break;
                }

                // append this item to array
                sbArr.Append(sbArr.Length == 0 ? "[\r\n  { " : ",\r\n  { ");
                sbArr.Append(sbItem.ToString());
                sbArr.Append(" }");
            }
            if (sbArr.Length > 0)
            {
                sbArr.Append("\r\n]");
            }

            // return result
            return(sbArr.ToString());
        }
Example #4
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     this.c1XLBook1         = new C1.C1Excel.C1XLBook();
     this.panel1            = new System.Windows.Forms.Panel();
     this.panel2            = new System.Windows.Forms.Panel();
     this.panel5            = new System.Windows.Forms.Panel();
     this.splitter2         = new System.Windows.Forms.Splitter();
     this.panel7            = new System.Windows.Forms.Panel();
     this.panel8            = new System.Windows.Forms.Panel();
     this.panel10           = new System.Windows.Forms.Panel();
     this.panel16           = new System.Windows.Forms.Panel();
     this.vs3               = new C1.Win.C1FlexGrid.C1FlexGrid();
     this.panel15           = new System.Windows.Forms.Panel();
     this.cmd4              = new System.Windows.Forms.Button();
     this.cmd3              = new System.Windows.Forms.Button();
     this.nav3              = new Navigator1._0.NavigatorAuto();
     this.splitter3         = new System.Windows.Forms.Splitter();
     this.panel9            = new System.Windows.Forms.Panel();
     this.panel14           = new System.Windows.Forms.Panel();
     this.vs2               = new C1.Win.C1FlexGrid.C1FlexGrid();
     this.panel13           = new System.Windows.Forms.Panel();
     this.cmd5              = new System.Windows.Forms.Button();
     this.cmd2              = new System.Windows.Forms.Button();
     this.splitter1         = new System.Windows.Forms.Splitter();
     this.panel6            = new System.Windows.Forms.Panel();
     this.panel12           = new System.Windows.Forms.Panel();
     this.vs1               = new C1.Win.C1FlexGrid.C1FlexGrid();
     this.panel11           = new System.Windows.Forms.Panel();
     this.cmd1              = new System.Windows.Forms.Button();
     this.panel4            = new System.Windows.Forms.Panel();
     this.label6            = new System.Windows.Forms.Label();
     this.label5            = new System.Windows.Forms.Label();
     this.label4            = new System.Windows.Forms.Label();
     this.label3            = new System.Windows.Forms.Label();
     this.label2            = new System.Windows.Forms.Label();
     this.label1            = new System.Windows.Forms.Label();
     this.panel3            = new System.Windows.Forms.Panel();
     this.nav2              = new Navigator1._0.NavigatorAuto();
     this.nav1              = new Navigator1._0.NavigatorAuto();
     this.nav               = new Navigator1._0.NavigatorAuto();
     this.c1CommandDock1    = new C1.Win.C1Command.C1CommandDock();
     this.c1DockingTab1     = new C1.Win.C1Command.C1DockingTab();
     this.c1DockingTabPage1 = new C1.Win.C1Command.C1DockingTabPage();
     this.vs = new C1.Win.C1FlexGrid.C1FlexGrid();
     this.panel1.SuspendLayout();
     this.panel2.SuspendLayout();
     this.panel5.SuspendLayout();
     this.panel7.SuspendLayout();
     this.panel8.SuspendLayout();
     this.panel10.SuspendLayout();
     this.panel16.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.vs3)).BeginInit();
     this.panel15.SuspendLayout();
     this.panel9.SuspendLayout();
     this.panel14.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.vs2)).BeginInit();
     this.panel13.SuspendLayout();
     this.panel6.SuspendLayout();
     this.panel12.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.vs1)).BeginInit();
     this.panel11.SuspendLayout();
     this.panel4.SuspendLayout();
     this.panel3.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.c1CommandDock1)).BeginInit();
     this.c1CommandDock1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.c1DockingTab1)).BeginInit();
     this.c1DockingTab1.SuspendLayout();
     this.c1DockingTabPage1.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.vs)).BeginInit();
     this.SuspendLayout();
     //
     // panel1
     //
     this.panel1.Controls.Add(this.panel2);
     this.panel1.Controls.Add(this.c1CommandDock1);
     this.panel1.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel1.Location = new System.Drawing.Point(0, 0);
     this.panel1.Name     = "panel1";
     this.panel1.Size     = new System.Drawing.Size(936, 552);
     this.panel1.TabIndex = 1;
     //
     // panel2
     //
     this.panel2.Controls.Add(this.panel5);
     this.panel2.Controls.Add(this.panel4);
     this.panel2.Controls.Add(this.panel3);
     this.panel2.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel2.Location = new System.Drawing.Point(200, 0);
     this.panel2.Name     = "panel2";
     this.panel2.Size     = new System.Drawing.Size(736, 552);
     this.panel2.TabIndex = 1;
     //
     // panel5
     //
     this.panel5.Controls.Add(this.splitter2);
     this.panel5.Controls.Add(this.panel7);
     this.panel5.Controls.Add(this.splitter1);
     this.panel5.Controls.Add(this.panel6);
     this.panel5.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel5.Location = new System.Drawing.Point(0, 36);
     this.panel5.Name     = "panel5";
     this.panel5.Size     = new System.Drawing.Size(736, 448);
     this.panel5.TabIndex = 2;
     //
     // splitter2
     //
     this.splitter2.Dock     = System.Windows.Forms.DockStyle.Right;
     this.splitter2.Location = new System.Drawing.Point(733, 0);
     this.splitter2.Name     = "splitter2";
     this.splitter2.Size     = new System.Drawing.Size(3, 448);
     this.splitter2.TabIndex = 3;
     this.splitter2.TabStop  = false;
     //
     // panel7
     //
     this.panel7.Controls.Add(this.panel8);
     this.panel7.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel7.Location = new System.Drawing.Point(251, 0);
     this.panel7.Name     = "panel7";
     this.panel7.Size     = new System.Drawing.Size(485, 448);
     this.panel7.TabIndex = 2;
     //
     // panel8
     //
     this.panel8.Controls.Add(this.panel10);
     this.panel8.Controls.Add(this.splitter3);
     this.panel8.Controls.Add(this.panel9);
     this.panel8.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel8.Location = new System.Drawing.Point(0, 0);
     this.panel8.Name     = "panel8";
     this.panel8.Size     = new System.Drawing.Size(485, 448);
     this.panel8.TabIndex = 0;
     //
     // panel10
     //
     this.panel10.Controls.Add(this.panel16);
     this.panel10.Controls.Add(this.panel15);
     this.panel10.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel10.Location = new System.Drawing.Point(231, 0);
     this.panel10.Name     = "panel10";
     this.panel10.Size     = new System.Drawing.Size(254, 448);
     this.panel10.TabIndex = 2;
     //
     // panel16
     //
     this.panel16.Controls.Add(this.vs3);
     this.panel16.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel16.Location = new System.Drawing.Point(0, 40);
     this.panel16.Name     = "panel16";
     this.panel16.Size     = new System.Drawing.Size(254, 408);
     this.panel16.TabIndex = 11;
     //
     // vs3
     //
     this.vs3.BorderStyle  = C1.Win.C1FlexGrid.Util.BaseControls.BorderStyleEnum.XpThemes;
     this.vs3.ColumnInfo   = "10,1,0,0,0,100,Columns:0{Width:38;}\t";
     this.vs3.Dock         = System.Windows.Forms.DockStyle.Fill;
     this.vs3.KeyActionTab = C1.Win.C1FlexGrid.KeyActionEnum.MoveAcross;
     this.vs3.Location     = new System.Drawing.Point(0, 0);
     this.vs3.Name         = "vs3";
     this.vs3.Size         = new System.Drawing.Size(254, 408);
     this.vs3.Styles       = ((C1.Win.C1FlexGrid.CellStyleCollection)(new C1.Win.C1FlexGrid.CellStyleCollection("")));
     this.vs3.TabIndex     = 9;
     //
     // panel15
     //
     this.panel15.Controls.Add(this.cmd4);
     this.panel15.Controls.Add(this.cmd3);
     this.panel15.Controls.Add(this.nav3);
     this.panel15.Dock     = System.Windows.Forms.DockStyle.Top;
     this.panel15.Location = new System.Drawing.Point(0, 0);
     this.panel15.Name     = "panel15";
     this.panel15.Size     = new System.Drawing.Size(254, 40);
     this.panel15.TabIndex = 10;
     //
     // cmd4
     //
     this.cmd4.FlatStyle = System.Windows.Forms.FlatStyle.System;
     this.cmd4.Location  = new System.Drawing.Point(188, 4);
     this.cmd4.Name      = "cmd4";
     this.cmd4.Size      = new System.Drawing.Size(28, 32);
     this.cmd4.TabIndex  = 14;
     this.cmd4.Tag       = "N";
     this.cmd4.Text      = "<<";
     //
     // cmd3
     //
     this.cmd3.FlatStyle = System.Windows.Forms.FlatStyle.System;
     this.cmd3.Location  = new System.Drawing.Point(4, 4);
     this.cmd3.Name      = "cmd3";
     this.cmd3.Size      = new System.Drawing.Size(132, 32);
     this.cmd3.TabIndex  = 11;
     this.cmd3.Text      = "cmd3";
     //
     // nav3
     //
     this.nav3.BackColor     = System.Drawing.SystemColors.Control;
     this.nav3.Connection    = null;
     this.nav3.ConnectionDel = null;
     this.nav3.Font          = new System.Drawing.Font("Tahoma", 9.75F);
     this.nav3.form          = null;
     this.nav3.FormName      = null;
     this.nav3.Grid          = null;
     this.nav3.History       = false;
     this.nav3.IsNull        = true;
     this.nav3.Language      = "EN";
     this.nav3.Location      = new System.Drawing.Point(144, 4);
     this.nav3.MSG_Exit      = false;
     this.nav3.MulltiDel     = false;
     this.nav3.Name          = "nav3";
     this.nav3.Security      = 0;
     this.nav3.ShowPopupMenu = true;
     this.nav3.Size          = new System.Drawing.Size(36, 32);
     this.nav3.TabIndex      = 13;
     this.nav3.ToolBar_Auto  = true;
     this.nav3.UserID        = null;
     this.nav3.VisibleGrid   = true;
     this.nav3.Where         = null;
     //
     // splitter3
     //
     this.splitter3.Location = new System.Drawing.Point(228, 0);
     this.splitter3.Name     = "splitter3";
     this.splitter3.Size     = new System.Drawing.Size(3, 448);
     this.splitter3.TabIndex = 1;
     this.splitter3.TabStop  = false;
     //
     // panel9
     //
     this.panel9.Controls.Add(this.panel14);
     this.panel9.Controls.Add(this.panel13);
     this.panel9.Dock     = System.Windows.Forms.DockStyle.Left;
     this.panel9.Location = new System.Drawing.Point(0, 0);
     this.panel9.Name     = "panel9";
     this.panel9.Size     = new System.Drawing.Size(228, 448);
     this.panel9.TabIndex = 0;
     //
     // panel14
     //
     this.panel14.Controls.Add(this.vs2);
     this.panel14.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel14.Location = new System.Drawing.Point(0, 40);
     this.panel14.Name     = "panel14";
     this.panel14.Size     = new System.Drawing.Size(228, 408);
     this.panel14.TabIndex = 13;
     //
     // vs2
     //
     this.vs2.AllowEditing = false;
     this.vs2.BorderStyle  = C1.Win.C1FlexGrid.Util.BaseControls.BorderStyleEnum.XpThemes;
     this.vs2.ColumnInfo   = "10,1,0,0,0,100,Columns:0{Width:38;}\t";
     this.vs2.Dock         = System.Windows.Forms.DockStyle.Fill;
     this.vs2.KeyActionTab = C1.Win.C1FlexGrid.KeyActionEnum.MoveAcross;
     this.vs2.Location     = new System.Drawing.Point(0, 0);
     this.vs2.Name         = "vs2";
     this.vs2.Size         = new System.Drawing.Size(228, 408);
     this.vs2.Styles       = ((C1.Win.C1FlexGrid.CellStyleCollection)(new C1.Win.C1FlexGrid.CellStyleCollection("")));
     this.vs2.TabIndex     = 8;
     //
     // panel13
     //
     this.panel13.Controls.Add(this.cmd5);
     this.panel13.Controls.Add(this.cmd2);
     this.panel13.Dock     = System.Windows.Forms.DockStyle.Top;
     this.panel13.Location = new System.Drawing.Point(0, 0);
     this.panel13.Name     = "panel13";
     this.panel13.Size     = new System.Drawing.Size(228, 40);
     this.panel13.TabIndex = 12;
     //
     // cmd5
     //
     this.cmd5.FlatStyle = System.Windows.Forms.FlatStyle.System;
     this.cmd5.Location  = new System.Drawing.Point(120, 4);
     this.cmd5.Name      = "cmd5";
     this.cmd5.Size      = new System.Drawing.Size(108, 32);
     this.cmd5.TabIndex  = 11;
     this.cmd5.Text      = "button1";
     //
     // cmd2
     //
     this.cmd2.FlatStyle = System.Windows.Forms.FlatStyle.System;
     this.cmd2.Location  = new System.Drawing.Point(4, 4);
     this.cmd2.Name      = "cmd2";
     this.cmd2.Size      = new System.Drawing.Size(108, 32);
     this.cmd2.TabIndex  = 10;
     this.cmd2.Text      = "cmd2";
     //
     // splitter1
     //
     this.splitter1.Location = new System.Drawing.Point(248, 0);
     this.splitter1.Name     = "splitter1";
     this.splitter1.Size     = new System.Drawing.Size(3, 448);
     this.splitter1.TabIndex = 1;
     this.splitter1.TabStop  = false;
     //
     // panel6
     //
     this.panel6.Controls.Add(this.panel12);
     this.panel6.Controls.Add(this.panel11);
     this.panel6.Dock     = System.Windows.Forms.DockStyle.Left;
     this.panel6.Location = new System.Drawing.Point(0, 0);
     this.panel6.Name     = "panel6";
     this.panel6.Size     = new System.Drawing.Size(248, 448);
     this.panel6.TabIndex = 0;
     //
     // panel12
     //
     this.panel12.Controls.Add(this.vs1);
     this.panel12.Dock     = System.Windows.Forms.DockStyle.Fill;
     this.panel12.Location = new System.Drawing.Point(0, 40);
     this.panel12.Name     = "panel12";
     this.panel12.Size     = new System.Drawing.Size(248, 408);
     this.panel12.TabIndex = 9;
     //
     // vs1
     //
     this.vs1.AllowEditing = false;
     this.vs1.BorderStyle  = C1.Win.C1FlexGrid.Util.BaseControls.BorderStyleEnum.XpThemes;
     this.vs1.ColumnInfo   = "10,1,0,0,0,100,Columns:0{Width:38;}\t";
     this.vs1.Dock         = System.Windows.Forms.DockStyle.Fill;
     this.vs1.KeyActionTab = C1.Win.C1FlexGrid.KeyActionEnum.MoveAcross;
     this.vs1.Location     = new System.Drawing.Point(0, 0);
     this.vs1.Name         = "vs1";
     this.vs1.Size         = new System.Drawing.Size(248, 408);
     this.vs1.Styles       = ((C1.Win.C1FlexGrid.CellStyleCollection)(new C1.Win.C1FlexGrid.CellStyleCollection("")));
     this.vs1.TabIndex     = 7;
     //
     // panel11
     //
     this.panel11.Controls.Add(this.cmd1);
     this.panel11.Dock     = System.Windows.Forms.DockStyle.Top;
     this.panel11.Location = new System.Drawing.Point(0, 0);
     this.panel11.Name     = "panel11";
     this.panel11.Size     = new System.Drawing.Size(248, 40);
     this.panel11.TabIndex = 8;
     //
     // cmd1
     //
     this.cmd1.FlatStyle = System.Windows.Forms.FlatStyle.System;
     this.cmd1.Location  = new System.Drawing.Point(4, 4);
     this.cmd1.Name      = "cmd1";
     this.cmd1.Size      = new System.Drawing.Size(132, 32);
     this.cmd1.TabIndex  = 9;
     this.cmd1.Text      = "cmd1";
     //
     // panel4
     //
     this.panel4.Controls.Add(this.label6);
     this.panel4.Controls.Add(this.label5);
     this.panel4.Controls.Add(this.label4);
     this.panel4.Controls.Add(this.label3);
     this.panel4.Controls.Add(this.label2);
     this.panel4.Controls.Add(this.label1);
     this.panel4.Dock     = System.Windows.Forms.DockStyle.Bottom;
     this.panel4.Location = new System.Drawing.Point(0, 484);
     this.panel4.Name     = "panel4";
     this.panel4.Size     = new System.Drawing.Size(736, 68);
     this.panel4.TabIndex = 1;
     //
     // label6
     //
     this.label6.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
     this.label6.ForeColor   = System.Drawing.Color.Blue;
     this.label6.Location    = new System.Drawing.Point(348, 8);
     this.label6.Name        = "label6";
     this.label6.Size        = new System.Drawing.Size(124, 24);
     this.label6.TabIndex    = 6;
     this.label6.Tag         = "N";
     this.label6.TextAlign   = System.Drawing.ContentAlignment.MiddleCenter;
     //
     // label5
     //
     this.label5.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
     this.label5.ForeColor   = System.Drawing.Color.Blue;
     this.label5.Location    = new System.Drawing.Point(96, 8);
     this.label5.Name        = "label5";
     this.label5.Size        = new System.Drawing.Size(124, 24);
     this.label5.TabIndex    = 5;
     this.label5.Tag         = "N";
     this.label5.TextAlign   = System.Drawing.ContentAlignment.MiddleCenter;
     //
     // label4
     //
     this.label4.Location = new System.Drawing.Point(248, 12);
     this.label4.Name     = "label4";
     this.label4.Size     = new System.Drawing.Size(100, 20);
     this.label4.TabIndex = 4;
     this.label4.Text     = "label4";
     //
     // label3
     //
     this.label3.Location = new System.Drawing.Point(8, 12);
     this.label3.Name     = "label3";
     this.label3.Size     = new System.Drawing.Size(100, 20);
     this.label3.TabIndex = 2;
     this.label3.Text     = "label3";
     //
     // label2
     //
     this.label2.Anchor    = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
     this.label2.BackColor = System.Drawing.SystemColors.ControlText;
     this.label2.ForeColor = System.Drawing.SystemColors.ControlLightLight;
     this.label2.Location  = new System.Drawing.Point(532, 36);
     this.label2.Name      = "label2";
     this.label2.Size      = new System.Drawing.Size(196, 24);
     this.label2.TabIndex  = 1;
     this.label2.Tag       = "N";
     this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
     //
     // label1
     //
     this.label1.Anchor    = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
     this.label1.BackColor = System.Drawing.SystemColors.ControlText;
     this.label1.ForeColor = System.Drawing.SystemColors.ControlLightLight;
     this.label1.Location  = new System.Drawing.Point(332, 36);
     this.label1.Name      = "label1";
     this.label1.Size      = new System.Drawing.Size(196, 24);
     this.label1.TabIndex  = 0;
     this.label1.Tag       = "N";
     this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
     //
     // panel3
     //
     this.panel3.Controls.Add(this.nav2);
     this.panel3.Controls.Add(this.nav1);
     this.panel3.Controls.Add(this.nav);
     this.panel3.Dock     = System.Windows.Forms.DockStyle.Top;
     this.panel3.Location = new System.Drawing.Point(0, 0);
     this.panel3.Name     = "panel3";
     this.panel3.Size     = new System.Drawing.Size(736, 36);
     this.panel3.TabIndex = 0;
     //
     // nav2
     //
     this.nav2.BackColor     = System.Drawing.SystemColors.Control;
     this.nav2.Connection    = null;
     this.nav2.ConnectionDel = null;
     this.nav2.Font          = new System.Drawing.Font("Tahoma", 9.75F);
     this.nav2.form          = null;
     this.nav2.FormName      = null;
     this.nav2.Grid          = null;
     this.nav2.History       = false;
     this.nav2.IsNull        = true;
     this.nav2.Language      = "EN";
     this.nav2.Location      = new System.Drawing.Point(564, 4);
     this.nav2.MSG_Exit      = false;
     this.nav2.MulltiDel     = false;
     this.nav2.Name          = "nav2";
     this.nav2.Security      = 0;
     this.nav2.ShowPopupMenu = false;
     this.nav2.Size          = new System.Drawing.Size(36, 32);
     this.nav2.TabIndex      = 14;
     this.nav2.ToolBar_Auto  = true;
     this.nav2.UserID        = null;
     this.nav2.Visible       = false;
     this.nav2.VisibleGrid   = true;
     this.nav2.Where         = null;
     //
     // nav1
     //
     this.nav1.BackColor     = System.Drawing.SystemColors.Control;
     this.nav1.Connection    = null;
     this.nav1.ConnectionDel = null;
     this.nav1.Font          = new System.Drawing.Font("Tahoma", 9.75F);
     this.nav1.form          = null;
     this.nav1.FormName      = null;
     this.nav1.Grid          = null;
     this.nav1.History       = false;
     this.nav1.IsNull        = true;
     this.nav1.Language      = "EN";
     this.nav1.Location      = new System.Drawing.Point(496, 4);
     this.nav1.MSG_Exit      = false;
     this.nav1.MulltiDel     = false;
     this.nav1.Name          = "nav1";
     this.nav1.Security      = 0;
     this.nav1.ShowPopupMenu = false;
     this.nav1.Size          = new System.Drawing.Size(36, 32);
     this.nav1.TabIndex      = 12;
     this.nav1.ToolBar_Auto  = true;
     this.nav1.UserID        = null;
     this.nav1.Visible       = false;
     this.nav1.VisibleGrid   = true;
     this.nav1.Where         = null;
     //
     // nav
     //
     this.nav.BackColor     = System.Drawing.SystemColors.Control;
     this.nav.Connection    = null;
     this.nav.ConnectionDel = null;
     this.nav.Font          = new System.Drawing.Font("Tahoma", 9.75F);
     this.nav.form          = null;
     this.nav.FormName      = null;
     this.nav.Grid          = null;
     this.nav.History       = false;
     this.nav.IsNull        = true;
     this.nav.Language      = "EN";
     this.nav.Location      = new System.Drawing.Point(4, 4);
     this.nav.MSG_Exit      = false;
     this.nav.MulltiDel     = false;
     this.nav.Name          = "nav";
     this.nav.Security      = 0;
     this.nav.ShowPopupMenu = false;
     this.nav.Size          = new System.Drawing.Size(472, 32);
     this.nav.TabIndex      = 8;
     this.nav.ToolBar_Auto  = true;
     this.nav.UserID        = null;
     this.nav.VisibleGrid   = true;
     this.nav.Where         = null;
     //
     // c1CommandDock1
     //
     this.c1CommandDock1.Controls.Add(this.c1DockingTab1);
     this.c1CommandDock1.Dock     = System.Windows.Forms.DockStyle.Left;
     this.c1CommandDock1.Id       = 1;
     this.c1CommandDock1.Location = new System.Drawing.Point(0, 0);
     this.c1CommandDock1.Name     = "c1CommandDock1";
     this.c1CommandDock1.Size     = new System.Drawing.Size(200, 552);
     //
     // c1DockingTab1
     //
     this.c1DockingTab1.Alignment   = System.Windows.Forms.TabAlignment.Bottom;
     this.c1DockingTab1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
     this.c1DockingTab1.CanAutoHide = true;
     this.c1DockingTab1.CanMoveTabs = true;
     this.c1DockingTab1.Controls.Add(this.c1DockingTabPage1);
     this.c1DockingTab1.Location      = new System.Drawing.Point(0, 0);
     this.c1DockingTab1.Name          = "c1DockingTab1";
     this.c1DockingTab1.SelectedIndex = 0;
     this.c1DockingTab1.ShowCaption   = true;
     this.c1DockingTab1.ShowSingleTab = false;
     this.c1DockingTab1.Size          = new System.Drawing.Size(200, 552);
     this.c1DockingTab1.TabIndex      = 0;
     this.c1DockingTab1.TabSizeMode   = C1.Win.C1Command.TabSizeModeEnum.Fit;
     this.c1DockingTab1.TabStyle      = C1.Win.C1Command.TabStyleEnum.WindowsXP;
     //
     // c1DockingTabPage1
     //
     this.c1DockingTabPage1.Controls.Add(this.vs);
     this.c1DockingTabPage1.ImageIndex = -1;
     this.c1DockingTabPage1.Location   = new System.Drawing.Point(1, 1);
     this.c1DockingTabPage1.Name       = "c1DockingTabPage1";
     this.c1DockingTabPage1.Size       = new System.Drawing.Size(195, 550);
     this.c1DockingTabPage1.TabIndex   = 0;
     this.c1DockingTabPage1.Text       = "Page1";
     //
     // vs
     //
     this.vs.BorderStyle  = C1.Win.C1FlexGrid.Util.BaseControls.BorderStyleEnum.XpThemes;
     this.vs.ColumnInfo   = "10,1,0,0,0,100,Columns:0{Width:38;}\t";
     this.vs.Dock         = System.Windows.Forms.DockStyle.Fill;
     this.vs.KeyActionTab = C1.Win.C1FlexGrid.KeyActionEnum.MoveAcross;
     this.vs.Location     = new System.Drawing.Point(0, 23);
     this.vs.Name         = "vs";
     this.vs.Size         = new System.Drawing.Size(195, 527);
     this.vs.Styles       = ((C1.Win.C1FlexGrid.CellStyleCollection)(new C1.Win.C1FlexGrid.CellStyleCollection("")));
     this.vs.TabIndex     = 6;
     //
     // frmTaCardComparison
     //
     this.AutoScaleBaseSize = new System.Drawing.Size(6, 16);
     this.ClientSize        = new System.Drawing.Size(936, 552);
     this.Controls.Add(this.panel1);
     this.Font  = new System.Drawing.Font("Tahoma", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));
     this.Name  = "frmTaCardComparison";
     this.Text  = "frmTaCardComparison";
     this.Load += new System.EventHandler(this.frmTaCardComparison_Load);
     this.panel1.ResumeLayout(false);
     this.panel2.ResumeLayout(false);
     this.panel5.ResumeLayout(false);
     this.panel7.ResumeLayout(false);
     this.panel8.ResumeLayout(false);
     this.panel10.ResumeLayout(false);
     this.panel16.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.vs3)).EndInit();
     this.panel15.ResumeLayout(false);
     this.panel9.ResumeLayout(false);
     this.panel14.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.vs2)).EndInit();
     this.panel13.ResumeLayout(false);
     this.panel6.ResumeLayout(false);
     this.panel12.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.vs1)).EndInit();
     this.panel11.ResumeLayout(false);
     this.panel4.ResumeLayout(false);
     this.panel3.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.c1CommandDock1)).EndInit();
     this.c1CommandDock1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.c1DockingTab1)).EndInit();
     this.c1DockingTab1.ResumeLayout(false);
     this.c1DockingTabPage1.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.vs)).EndInit();
     this.ResumeLayout(false);
 }