以文本方式查看主题 - Foxtable(狐表) (http://foxtable.net/bbs/index.asp) -- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2) ---- 引用 (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=137734) |
-- 作者:yetle -- 发布时间:2019/7/13 22:37:00 -- 引用 Dim wb As New WeUI Dim cmd As New SQLCommand Dim fl As String cmd.C cmd.CommandText = "SELECT sum(件数) as 件数 F rom 派发工序表 where 部门 = \'A.车间\' and 单据状态=\'已完成\' and 工序号=\'101\'" fl = cmd.ExecuteScalar With wb.AddListGroup("", "lsg3", "请选择车间") .Add("ls5","A车间", " fl ", "bzlb.htm?chejian=A") \'引用fl 是这么写的吗?? .Add("ls6","B车间", "", "bzlb.htm?chejian=B") .Add("ls7","C车间", "", "bzlb.htm?chejian=C") End With e.WriteString(wb.Build)
|
-- 作者:有点蓝 -- 发布时间:2019/7/15 10:06:00 -- .Add("ls5","A车间", fl, "bzlb.htm?chejian=A") 去掉双引号
|