你好，我用的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>