Foxtable(狐表)用户栏目专家坐堂 → [求助]关于AddSelect 值改变,则显示的


  共有2174人关注过本帖树形打印复制链接

主题:[求助]关于AddSelect 值改变,则显示的

帅哥哟,离线,有人找我吗?
2900819580
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:六尾狐 帖子:1312 积分:9533 威望:0 精华:0 注册:2015/6/30 8:46:00
[求助]关于AddSelect 值改变,则显示的  发帖心情 Post By:2020/1/4 15:18:00 [只看该作者]

Dim e As RequestEventArgs = args(0)
Dim wb As New weui
wb.AddPageTitle("","pageheader","2020","春节联欢晚会")
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
wb.AddForm("","form1","win.htm")
With wb.AddInputGroup("form1","ipg1","节目上报")
    .AddSe lect("lb","类别","小品|相声|唱歌|舞台剧|魔术|舞蹈")   
End With

 

With wb.AddTable("","Table1")
    .Highlight = 0 '关闭高亮显示
    .Alternate = 2 '每两行显示一个不同背景颜色的行
    .RowHead = 1
    .ActiveSheet = "menu"
    .Primarykey = "_Identify" '设置主键
    .CreateFromDataTable(DataTables("itemlist"),False,"name = ‘" & e.PostValues(key) & "'","sn","sn","ltd","bm","lb","name")
End With

 

wb.AddPageFooter("","pf1","").AddLink("返回主页","homepage.htm")
e.WriteString(wb.Build)

 

老师,我想做到Select控件改变值时,同步刷新数据表,代码应该怎么样修改。

[此贴子已经被作者于2020/1/4 16:48:48编辑过]

 回到顶部
帅哥哟,离线,有人找我吗?
有点蓝
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:107135 积分:544918 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2020/1/4 15:29:00 [只看该作者]

参考这里:http://www.foxtable.com/mobilehelp/topics/0110.htm
需要使用ajax,分2个函数处理,把按钮的事件搬到Select控件即可

With wb.AddInputGroup("form1","ipg1","节目上报")
    .AddSe lect("lb","类别","小品|相声|唱歌|舞台剧|魔术|舞蹈").Attribute"onchange= 'tongji2()'"
End With

 回到顶部
帅哥哟,离线,有人找我吗?
2900819580
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:六尾狐 帖子:1312 积分:9533 威望:0 精华:0 注册:2015/6/30 8:46:00
  发帖心情 Post By:2020/1/4 17:06:00 [只看该作者]

老师,想将它们放在一个页面上,但出现了以下图片的情况

 
此主题相关图片如下:无标题.png
按此在新窗口浏览图片

 

function filb(){
        var result = submitAjaxForm('form1','',false);
     document.getElementById("p1").innerHTML=result;
}

Dim e As RequestEventArgs = args(0)
Dim wb As New weui
wb.AddPageTitle("","pageheader","2020","春节联欢晚会")
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dim dt As DataTable = DataTables("奖项明细表")
If e.PostValues.ContainsKey("lb") AndAlso e.PostValues("lb") > "" Then
    Dim fr As DataRow = dt.SQLFind("奖项名称 = '" & e.PostValues("lb") & "'")
    With wb.AddTable("","Table1")
        .Highlight = 0 '关闭高亮显示
        .Alternate = 2 '每两行显示一个不同背景颜色的行
        .RowHead = 1
        .ActiveSheet = "menu"
        .Primarykey = "_Identify" '设置主键
        .CreateFromDataTable(DataTables("人员表"),False,fr("奖项类别") & "= " & fr("序号"),"序号","序号","公司","部门","姓名")
    End With
Else   
    Dim lss As String = dt.SQLGetComboListString("奖项名称","中奖数量 > 0 or 中奖数量 is not null","序号 desc")
    wb.AddForm("","form1","win.htm")
    With wb.AddInputGroup("form1","ipg1","节目上报")
        .AddSe lect("lb","奖项名称",lss).Attribute = ""
    End With
End If
'PopMessage(22)
wb.AddPageFooter("","pf1","").AddLink("返回主页","homepage.htm")
wb.AppendHTML("<div id='p1' style='margin:0.5em'></div>")  '插入一个div,用于显示服务器返回的 页面
wb.AppendHTML("<script src='./lib/win.js'></script>")  '引入脚本文件
e.WriteString(wb.Build)

 

 


 回到顶部
帅哥哟,离线,有人找我吗?
有点蓝
  4楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:107135 积分:544918 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2020/1/4 17:11:00 [只看该作者]

不要放到一起,分开2个函数

 回到顶部