账号通
    

账号  

密码  

1698

查看

2

回复
主题:[IMALL]IMALL IF语句判断乱码,不能解析正常 [收藏主题]  
a77303383 当前离线

694

主题

86

广播

4

粉丝
添加关注
级别:六年级

用户积分:4470 分
登录次数:648 次
注册时间:2007/7/21
最后登录:2023/6/25
a77303383 发表于:2017/4/18 8:52:12   | 只看该作者 查看该作者主题 楼主 
做在线知识付费 选科汛云开店
你好,我用的IMALL做查询,查询的内容比较多。用到了IF语句做判断。但是页面显示结果IF语句经常判断不了,然后直接原语句出来了。也不是每次都这样的。

点击查看原图


SELECT RIGHT('0000000'+CONVERT(VARCHAR(8),dbo.KS_FormRecord43.RecordID),7) AS Expr6,RIGHT('000000'+CONVERT(VARCHAR(7),dbo.KS_FormRecord43.RecordID),6) AS Expr66,dbo.KS_FormRecord43.RecordID,dbo.KS_FormRecord50.UserName AS Expr1,dbo.KS_FormRecord43.AddDate,dbo.KS_FormRecord43.item0,dbo.KS_FormRecord43.item6 AS Expr5,dbo.KS_FormRecord43.item9,dbo.KS_FormRecord43.item5,dbo.KS_FormRecord43.item7,dbo.KS_FormRecord43.item11,dbo.KS_FormRecord43.item12,dbo.KS_FormRecord43.item13,dbo.KS_FormRecord50.UserName,dbo.KS_FormRecord50.item0 AS Expr2,dbo.KS_FormRecord50.item4,dbo.KS_FormRecord50.item6,dbo.KS_FormRecord51.copyNO AS Expr4,dbo.KS_FormRecord50.AddDate AS Expr7,dbo.KS_FormRecord47.item0 AS Expr8,dbo.KS_FormRecord47.item4 AS Expr9,dbo.KS_FormRecord47.item1 AS Expr10,dbo.KS_FormRecord47.item3,dbo.KS_FormRecord51.item3 AS Expr11,dbo.KS_FormRecord51.item4 AS Expr12,dbo.KS_FormRecord51.UserName AS Expr13,dbo.KS_FormRecord51.AddDate AS Expr14,dbo.KS_FormRecord47.UserName AS Expr15,dbo.KS_FormRecord47.AddDate AS Expr16,dbo.KS_FormRecord45.item0 AS Expr17,dbo.KS_FormRecord45.item1 AS Expr18,dbo.KS_FormRecord45.UserName AS Expr19,dbo.KS_FormRecord46.UserName AS Expr21,dbo.KS_FormRecord46.AddDate AS Expr22,dbo.KS_FormRecord46.item6 AS Expr23,dbo.KS_FormRecord46.item2 AS Expr25,dbo.KS_FormRecord46.item3 AS Expr26,dbo.KS_FormRecord46.item5 AS Expr27,dbo.KS_FormRecord50.item9 AS Expr3,dbo.KS_FormRecord43.item13 FROM dbo.KS_FormRecord43 LEFT OUTER JOIN dbo.KS_FormRecord46 ON dbo.KS_FormRecord43.RecordID=dbo.KS_FormRecord46.CopyNO LEFT OUTER JOIN dbo.KS_FormRecord45 ON dbo.KS_FormRecord43.RecordID=dbo.KS_FormRecord45.CopyNO LEFT OUTER JOIN dbo.KS_FormRecord47 ON dbo.KS_FormRecord43.RecordID=dbo.KS_FormRecord47.CopyNO LEFT OUTER JOIN dbo.KS_FormRecord50 ON dbo.KS_FormRecord43.RecordID=dbo.KS_FormRecord50.COPYNO LEFT OUTER JOIN dbo.KS_FormRecord51 ON dbo.KS_FormRecord43.RecordID=dbo.KS_FormRecord51.copyNO WHERE (dbo.KS_FormRecord43.item13 = N'焊枪') ORDER BY dbo.KS_FormRecord43.RecordID DESC






<span id="spnCmdBar">
关键词: <input type="text" id="keywd" style="width: 80px;" />
<input type="button" id="btnFind" value="查找本页中的" /> </span>
<span id="btnHide" class="clsLinkButton" style="margin-left: 150px;">隐藏所选</span>
<span id="btnShowAll" class="clsLinkButton">显示全部</span>
    <form name="form1" method="post" action="SuperTable.aspx" id="form1">
<div>

    <div>

<table cellspacing="0" border="1" id="GridView1" style="font-size:9pt;border-collapse:collapse;">

  <tr>
  <th scope="col" colspan="9">生 产 部</th>
  <th scope="col" colspan="6">调 试 部</th>
  <th scope="col" colspan="4">质 量 部</th>
  <th scope="col" colspan="4">仓库入库</th>
  <th scope="col" colspan="3">仓库出库</th>
  <th scope="col" colspan="6">维 修 部</th>
  </tr>
<tr>
  <th scope="col">流程号</th>
  <th scope="col">产品物号</th>
  <th scope="col">机器描述</th>
  <th scope="col">任务日期</th>
  <th scope="col">交货日期</th>
  <th scope="col">标准|SCO</th>
  <th scope="col">是否改装</th>
  <th scope="col">改装前的流程号</th>
  <th scope="col">任务目标</th>

  <th scope="col">标签打印</th>
  <th scope="col">操作人</th>
  <th scope="col">是否调试</th>
  <th scope="col">调试时间</th>
  <th scope="col">主板程序</th>
  <th scope="col">调试备注</th>

  <th scope="col">检验员</th>
  <th scope="col">是否合格</th>
  <th scope="col">检验时间</th>
  <th scope="col">备注</th>

  <th scope="col">操作人</th>
  <th scope="col">是否入库</th>
  <th scope="col">入库时间</th>
  <th scope="col">备注</th>


  <th scope="col">操作人</th>
  <th scope="col">出库时间</th>
  <th scope="col">最终客户|经销商</th>


  <th scope="col">是否维修</th>
  <th scope="col">维修时间</th>
  <th scope="col">操作人</th>
  <th scope="col">维修照片</th>
  <th scope="col">更换部件</th>
  <th scope="col">问题描述</th>
</tr>



[Loop Times="100"]
<tr>

    <td class="style1">
        {KS:IF("{$Field(item13,text,0)}"=="焊枪")}
           TK{$Field(Expr66,text,0,...,2,)}
        {KS:ELSE}
           K{$Field(Expr6,text,0,...,2,)}
        {/KS:IF}
    </td>

    <td align="right">{$Field(item0,text,0,...,2,)}</td>
    <td align="right">{$Field(item9,text,0,...,2,)}</td>
    <td id="GridView1" align="right">{$Field(AddDate,date,YY-MM-DD,3,red)}</td>
    <td align="right">{$Field(Expr9,text,0,...,2,)}</td>
    <td align="right">{$Field(item5,text,0,...,2,)}</td>
    <td align="right">{$Field(item7,text,0,...,2,)}</td>
    <td align="right">{$Field(item11,text,0,...,2,)}</td>
    <td align="right">{$Field(item12,text,0,...,2,)}</td>

    <td align="right"><a href="http://192.168.1.180:81/a/1144.aspx?RecordID={$Field(RecordID,text,0,...,2,)}" target="_blank">点击打印</a></td>
    <td align="right">{$Field(Expr1,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr2,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr7,date,YY-MM-DD,3,red)}</td>
    <td align="right">{$Field(item4,text,0,...,2,)}</td>
    <td align="right">{$Field(item6,text,0,...,2,)}</td>

    <td align="right">{$Field(Expr15,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr8,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr16,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr10,text,0,...,2,)}</td>

    <td align="right">{$Field(Expr13,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr11,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr14,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr12,text,0,...,2,)}</td>

    <td align="right">{$Field(Expr19,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr17,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr18,text,0,...,2,)}</td>

    <td align="right">{$Field(Expr23,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr22,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr21,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr27,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr25,text,0,...,2,)}</td>
    <td align="right">{$Field(Expr26,text,0,...,2,)}</td>

  </tr>

[/Loop]


  </table>
</div>
    </form>
 
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
keyi 当前离线

3123

主题

8

广播

18

粉丝
添加关注
级别:大二

用户积分:11924 分
登录次数:2527 次
注册时间:2008/12/24
最后登录:2023/12/14
keyi 发表于:2017/4/18 11:48:51   | 只看该作者 查看该作者主题 沙发 
科汛在线商城系统(NET)
用前端脚本控制。少用系统的判断。性能不好。
 
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
freecms 当前离线

331

主题

1

广播

0

粉丝
添加关注
级别:三年级

用户积分:393 分
登录次数:32 次
注册时间:2015/10/21
最后登录:2020/2/20
freecms 发表于:2017/4/18 16:35:51   | 只看该作者 查看该作者主题 藤椅 
 
  支持(0) | 反对(0) 回到顶部顶端 回到底部底部
<上一主题 | 下一主题 >
Powered By KesionCMS Version X1
厦门科汛软件有限公司 © 2006-2016 页面执行0.15723秒 powered by KesionCMS 9.0