以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 动态下拉 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=152643) |
-- 作者:刘林 -- 发布时间:2020/7/17 9:54:00 -- 动态下拉 Dim e As RequestEventArgs = args(0) Dim path As String = "foxtableAppTest" Dim wb As new weui wb.appendHTML("<meta name=\'viewport\' c />",True) wb.AppendHTML("<script type=\'text/javascript\' src=\'/" & path & "/js/common.js\'></script>", True) wb.AppendHTML("<link rel=\'stylesheet\' href=\'/" & path & "/css/common.css\' Type=\'text/css\' charset=\'utf-8\'/>", True) wb.appendHTML("<script src=\'../mui/js/mui.min.js\'></script>",True) wb.appendHTML("<script Type=\'text/javascript\' charset=\'utf-8\'>mui.init();</script>",True) wb.appendHTML("<style>.fox_page_title{color:white}</style>",True) wb.appendHTML("<style>.fox_page_subtitle{color:white;}</style>",True) wb.appendHTML("<style>.fox_page_header{background-color:dodgerblue;}</style>",True) wb.appendHTML("<style>.weui_label{color:dodgerblue;}</style>",True) wb.appendHTML("<style>h5,p{margin:8px 16px;}</style>",True) Dim cmd1 As new SQLCommand cmd1.C cmd1.CommandText ="Se/ect DISTINCT 单位,部门,角色 from {单位用户} where 角色=\'班务\'" Dim dt1 As DataTable = cmd1.ExecuteReader Dim xxs As List(of String)=dt1.GetValues("单位") wb.AddPageTitle("","ph1","新生报名","请扫描学校给定的报名码") wb.AddForm("","form1","bmxx.htm") With wb.AddInputGroup("form1","ipg1","") \' Dim In1 = .AddInput("身份证号","身份证号:","Text") In1.readonly = True In1.value = e.Cookies("username") Dim In2= .AddInput("学生姓名","学生姓名:","Text") In2.readonly = True In2.value = e.Cookies("userxm") Dim cmd As new SQLCommand cmd.C cmd.CommandText = "SE/ECT 身份证件号,申读学校,申读班级,录取类型,问题 FROM {学生信息} where 身份证件号 =\'" & e.Cookies("username") & "\'" Dim dt As DataTable = cmd.ExecuteReader() Dim dr As DataRow If dt.DataRows.Count>0 dr = dt.DataRows(0) If dr("录取类型")>"" Dim Int1= .AddSelect("申读学校","申读学校:",dr("申读学校")) int1.enabled=False Dim Int2= .Addselect("申读班级","申读班级:",dr("申读班级")) int2.enabled=False Else Dim Int1 =.AddSelect("申读学校","申读学校:"," |" & String.join("|",xxs.Toarray).replace(dr("申读学校"), "[" & dr("申读学校") & "]")) Int1.attribute="" Dim Int2= .Addselect("申读班级","申读班级:","") End If Else Dim Int1 =.AddSelect("申读学校","申读学校:"," |" & String.join("|",xxs.Toarray)) Int1.attribute="" Dim Int2= .Addselect("申读班级","申读班级:","") End If .AddHiddenValue("类型","a") With wb.AddButtonGroup("form1","btg1",False) Dim btn1= .Add("btn1", "扫报名码", "button") If dr IsNot Nothing AndAlso dr("录取类型")>"" btn1.kind=1 btn1.enabled=False Else btn1.Attribute = " & path & "/plus/barcode_scan.html\',true,true);""" btn1.kind=1 End If Dim btn2= .Add("btn2", "信息填报", "submit") btn2.kind=1 Dim btn3= .Add("btn3", "返回", "button") btn3.kind=1 btn3.Attribute="" End With If dr IsNot Nothing AndAlso dr("问题")>"" wb.InSertHtml("form1","<p style= \'font-size:15px;color:red;\'>存在信息问题,请修改提交:</P>") wb.InSertHtml("form1","<p style= \'font-size:15px;\'>" & dr("问题") & "</P>") End If If dr IsNot Nothing AndAlso dr("录取类型")>"" wb.InSertHtml("form1","<div style= \'background:url(../picture/nqbj.jpg);height:150px;background-size:cover\'>" ) wb.InSertHtml("form1","<p style= \'text-align:center;font-size:20px;color:white;margin-top:20px;\'>录取通知</P>") wb.InSertHtml("form1","<p style = \'text-indent:2em;color:white;\'>经学校招生小组审核同意,你已被我校录取,请按相关时间安排入学就读,如有申读学校变更,需经学校教务处同意方可进行变更。</P>") wb.InSertHtml("form1","</div>") End If End With wb.InsertHTML("<script>function scaned( t, r, f ) {document.getElementById(\'申读学校\').value=r.split(\',\')[0]; document.getElementById(\'申读班级\').value=r.split(\',\')[1];document.getElementById(\'类型\').value=r.split(\',\')[2]}</script>") For Each xx As String In xxs wb.InsertHTML("<p hidden id=\'" & xx & "\'>" & " |" & dt1.GetComboListString("部门","单位=\'" & xx & "\'") & "</p>") Next wb.AppendHTML("<script src=./lib/getsdbj.js></script>") e.WriteString(wb.Build) e.Handled=True 请问老师,上面的动态下拉,红色的第三句,应是当打开时能显示当前的申读班级,也可以有下拉内容,该怎么写才行 |
-- 作者:有点蓝 -- 发布时间:2020/7/17 10:22:00 -- 不就是这个? Dim Int2= .Addselect("申读班级","申读班级:",dr("申读班级"))
|
-- 作者:刘林 -- 发布时间:2020/7/17 10:35:00 -- 老师我是这个意思,当dr("申读班级")有值就显示,同时下拉也有其他班级供选择,这样子就是固定的了,当选错了就不能再修改了 |
-- 作者:有点蓝 -- 发布时间:2020/7/17 10:41:00 -- 如果使用了js设置动态下拉,这里肯定也可以下拉呀 |
-- 作者:刘林 -- 发布时间:2020/7/17 10:47:00 -- function getsdbj(){ var xx=document.getElementById("申读学校").value; setOptions("申读班级",document.getElementById(xx).innerHTML); } 现在是要将申读班级重新换选一个才有,申读班级才有下拉,也就changed才有
|
-- 作者:有点蓝 -- 发布时间:2020/7/17 11:00:00 -- 如果要默认就有,那就和下面一样,先从数据库取值啊 Dim Int1 =.AddSelect("申读学校","申读学校:"," |" & String.join("|",xxs.Toarray).replace(dr("申读学校"), "[" & dr("申读学校") & "]"))
|