Case "addnewtxl.htm"

        If e.PostValues.Count = 0 Then

            wb.AddForm("","form1","addnewtxl.htm")

            With wb.AddInputGroup("form1","ipg1","干警信息")               

                Dim filter11 As String = "表名 = \'干警信息\' and 列名 = \'所在单位\' and 停用 = false"

                Dim fdr11 As DataRow = DataTables("列项设置").Find(filter11)

                If fdr11 IsNot Nothing Then

                    Dim abc11 As String=fdr11("下拉选项").replace(",", "|")

                    .AddSelect("所在单位","所在单位","|"&abc11)

                End If              

                .AddInput("姓名","姓名","Text") \'前一个"姓名"是ID,后一个"姓名"是标题

                .AddInput("电话","电话","number")

                .AddInput("电子邮件","电子邮件","text")

                .AddInput("QQ号","QQ号","text")

                .AddInput("微信号","微信号","text") 

                Dim filter As String = "表名 = \'干警信息\' and 列名 = \'身份属性\' and 停用 = false"

                Dim fdr As DataRow = DataTables("列项设置").Find(filter)

                If fdr IsNot Nothing Then

                    Dim abc As String=fdr("下拉选项").replace(",", "|")

                    .AddSelect("身份属性","身份属性","|"&abc)

                End If  

                Dim filter1 As String = "表名 = \'干警信息\' and 列名 = \'关注领域\' and 停用 = false"

                Dim fdr1 As DataRow = DataTables("列项设置").Find(filter1)

                If fdr1 IsNot Nothing Then

                    Dim abc1 As String=fdr1("下拉选项").replace(",", "|")

                    .AddSelect("关注领域","关注领域","|"&abc1)

                End If  

            End With

            With wb.AddButtonGroup("form1","btg1",True)

                .Add("btn1", "确定", "submit")

                .Add("btn2","取消","reset")

            End With

            

            With wb.AddTable("","Table1")

                .RowHead = 1

                .ColWidth = "12px"

                Dim nms() As String = {"姓名","电话","电子邮件","身份属性","所在单位"}

                .Head.AddRow(nms)

                Dim cnt As Integer

                For Each r As DataRow In DataTables("干警信息").Select("姓名 <>\'\'")

                    cnt = cnt + 1

                    With .Body.AddRow(r("姓名"),r("电话"),r("电子邮件"),r("身份属性"),r("所在单位"))

                        \'.AddCell(Format(r("单价"),"#0.00"))

                        \'.AddCell(Format(r("日期"),"MM月dd日"))

                    End With

                Next

            End With

            e.WriteString(wb.Build)

        Else

            Dim nms() As String = {"姓名","电话"} \'不能为空的列名数组

            For Each nm As String In nms

                If e.PostValues.ContainsKey(nm) = False Then \'生成错误提示页

                    With wb.AddMsgPage("","msgpage","增加失败", nm & "列不能为空!")

                        .icon = "Warn" \'改变图标

                        .AddButton("btn1","返回").Attribute = ""

                    End With

                    e.WriteString(wb.Build)

                    Return \'必须返回

                End If

            Next

            nms = New String() {"姓名","电话","电子邮件","身份属性","所在单位","关注领域","微信号","QQ号"}  \'重新定义了nms数组,增加了两列.

            Dim dr As DataRow = DataTables("干警信息").AddNew()

            For Each nm As String In nms

                If e.PostValues.ContainsKey(nm) Then

                    dr(nm) = e.PostValues(nm)                    

                End If

            Next

            If dr("所在单位") <>"" Then

                Dim dr11 As DataRow

                dr11 = DataTables("行政区域").Find("所在单位 = \'"&dr("所在单位")&"\' ")

                dr("所在省份")=dr11("所在省份")

                dr("所在地区")=dr11("所在地区")

                dr("所在县份")=dr11("所在县市")

            End If

            With wb.AddMsgPage("","msgpage","增加成功", "好好学习,天天向上") \'生成成功提示页

                .AddButton("btn1","继续增加","addnewtxl.htm")

            End With           

            e.WriteString(wb.Build)

        End If