public DataTable GetDataTable()

    {

        THS.Logic.PublicLogic.PublicLogic objPublicLogic = new THS.Logic.PublicLogic.PublicLogic("datadict", "SerialID");

        DataTable dt = new DataTable();

        dt = objPublicLogic.getQueryDS("select * from datadict where  1=1 and tablename='user'    and colSearch='yes'  order by colnull,conSort asc").Tables[0];

        return dt;



    }









    public void GetTable()

    {



        DataTable dt = new DataTable();

        dt = GetDataTable();

        TableRow tr = new TableRow();

        string lblItemName="";

        string lblItemContent = "";

        string txtItemName="";

        int txtItemLen = 0;

        int upIValue = -1000;

        bool upIsNewRow = false;

        int upLen = -1;

        int nextItemLen = -1;

        for (int i = 0; i < dt.Rows.Count; i++)

        {





            lblItemContent = dt.Rows[i]["ColNote"].ToString().ToLower();

            lblItemName = "lbl_" + dt.Rows[i]["ColName"].ToString().ToLower();

            txtItemName = "input_" + dt.Rows[i]["ColName"].ToString().ToLower(); //dr["ColName"].ToString(); 

            txtItemLen = Convert.ToInt32(dt.Rows[i]["ColLen"].ToString().ToLower());

            if (i != dt.Rows.Count - 1)

            {

                nextItemLen = Convert.ToInt32(dt.Rows[i + 1]["ColLen"].ToString().ToLower());

            }





            if (i % 4 == 0)

            {

                tr = new TableRow();

            }

            //if (txtItemLen > 100 || i % 4 == 0)

            //{

            //    //this.Table1.Rows.Add(tr);

            //    tr = new TableRow();

            //    upIValue = i;

            //    upIsNewRow = true;

            //}



            //if (upIValue == i - 1 && upIsNewRow == true)

            //{

            //    tr = new TableRow();

            //    upIValue = i;

            //    upIsNewRow = true;

            //}

            //else

            //{

                //if (i % 4 == 0)

                //{

                //    tr = new TableRow();

                //}

            //}



            TableCell tcItemLetter = new TableCell();

            TableCell tcItemContent = new TableCell();

            if (txtItemLen > 100)

            {

                tcItemContent.ColumnSpan = 7;

            }

            tcItemLetter.CssClass = "tdbg5";

            tcItemContent.CssClass = "tdbg6";

            //tcItemLetter.HorizontalAlign = HorizontalAlign.Center;

            //tcItemLetter.Width = Unit.Percentage(10);

            ////tcItemLetter.BackColor = System.Drawing.Color.Beige;

            //tcItemContent.HorizontalAlign = HorizontalAlign.Left;

            Label lblItemLetter = new Label();

            lblItemLetter.ID = lblItemName;

            lblItemLetter.Text = lblItemContent;

            tcItemLetter.Controls.Add(lblItemLetter);

            TextBox txtItemContent = new TextBox();

            if (txtItemLen > 100)

            {

                txtItemContent.Width = Unit.Percentage(99);

                txtItemContent.Height = Unit.Parse("84px");// Unit.Percentage(99);

            }

            txtItemContent.ID = txtItemName;//"txtItemContent" + (i.ToString());

            tcItemContent.Controls.Add(txtItemContent);

            tr.Cells.Add(tcItemLetter);

            tr.Cells.Add(tcItemContent);







            if (txtItemLen > 100)

            {//加行

                this.Table1.Rows.Add(tr);

                if (i != dt.Rows.Count - 1)

                {//不等于最后一行

                    if ((i + 1) % 4 == 0 || nextItemLen > 100)

                    {//下次取摸为0 或者 下次长度大于100

                        tr = new TableRow();

                        upIValue = i;

                        upIsNewRow = true;

                        upLen = txtItemLen;

                    }



                    if (upIValue == i - 1 && upIsNewRow == true)

                    {

                        tr = new TableRow();

                    }

                }

                

            }



            if (i % 4 == 0)

            {

                this.Table1.Rows.Add(tr);

                //if (i != dt.Rows.Count - 1)

                //{//不等于最后一行



                //    if (i != 0)

                //    {

                //        tr = new TableRow();

                //        upIValue = i;

                //        upIsNewRow = true;

                //        upLen = txtItemLen;

                //    }

                //}



                

            }



            if (i == dt.Rows.Count - 1)

            {

                this.Table1.Rows.Add(tr);

            }







            

        }



    }