NutzCN Logo
问答 为啥我执行.fetch会出现对象名 'SD61102_20200222.dbo.l_goods' 无效。
发布于 7天前 作者 ThxYouForComing 38 次浏览 复制 上一个帖子 下一个帖子
标签:

public Object detail(String goodsid) {
String str = "Select top 1 a.goodsid as goodsid,a.code, a.name, a.specs, a.Kind, u.unitname as unitname, ";
str += "CONVERT(DECIMAL(13,2),b.masterqty) as masterqty ,b.useTime,b.Pretime,b.state from l_goods a ";
str += "left join l_goodsunit u on (a.goodsid = u.goodsid and u.isbase = 1) ";
str += "left join l_goodsbom b on (a.goodsid = b.goodsid) where a.goodsid = "+goodsid;

    List<BOM> bom = bomService.customQuery(str);
    bom.get(0).setHasChildren(true);
    BasDrawing drawing = drawingService.fetch(Cnd.where("goodsid", "=", bom.get(0).getGoodsid()));

// if(null!=drawing){
// bom.get(0).setDrawid(drawing.getId()+"");
// bom.get(0).setPath(drawing.getPath());
// }
return bom;
}

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名 'SD61102_20200222.dbo.l_goods' 无效。
0 回复
添加回复
请先登陆
回到顶部