是否到达已经在列表中取到值,怎样加上是否到达为检索条件,在列表中取到的是否到达值是通过 strSql += " case when (SELECT count(1) FROM officedba.SellSend AS sod WHERE sod.FromType = '1' AND sod.FromBillID = s.ID)>0 then '已发货' ";
strSql += " when (select count(1) yp from dbo.SetlerBills sb ";
strSql += " where sb.ContractID=s.ContractNo and sb.Yprice/s.TotalFee*100>=s.TalkProcess)>0 then '已达到' ";
strSql += " else '未达到' end ispass "; 取到的, 数据库没字段,不知道怎样加是否达到为检索条件
strSql += " when (select count(1) yp from dbo.SetlerBills sb ";
strSql += " where sb.ContractID=s.ContractNo and sb.Yprice/s.TotalFee*100>=s.TalkProcess)>0 then '已达到' ";
strSql += " else '未达到' end ispass "; 取到的, 数据库没字段,不知道怎样加是否达到为检索条件
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货