588
社区成员
发帖
与我相关
我的任务
分享
string sql = @"select distinct
pos.billNo as '单据编号',
pos.projectCode as '项目编号',
pro.projectName as '项目名称',
pos.subProject as '项目子项',
case when cs.conMemberCode is not NULL then cs.conMemberCode else mat.materailCode end as '构件编码',
case when cmd.conMember is not NULL then cmd.conMember else mat.materialName end as '材料名称',
case when cs.conMemberCode is not NULL then '构件' else '物料' end as '类型',
mad.model as '规格型号',
t2.dicItem as '材质',
mad.qty as '调拨数量',
t1.dicItem as '单位',
--bpd.weight as '单量',
t4.dicItem as '单量单位',
--convert(decimal(10,2),(cmd.weight*posd.qty)) as '总量',
t3.dicItem as '总量单位',
posd.qty as '出库数量'
from Pro_ProductOutstorageDet posd
join Pro_ProductOutStorage pos on pos.id=posd.parentId
join Pro_MatAllotDet mad on posd.matAllotDetId=mad.id
join Pro_MatAllot ma on ma.id=mad.parentID and ma.status=2
left join Pro_MatStock ms on ms.id=mad.matStockId and mad.memberType=1
left join Pro_ConStock cs on cs.id=mad.matStockId and mad.memberType=0
left join sys_material mat on mat.materailCode=ms.mat.materailCode
left join Pro_ConPurInstore cpi on cs.billNo=cpi.billCode
left join Pro_ConPurInstoreDet cpid on cpi.id=cpid.parentId and cs.billId=cpi.id
left join dbo.Pro_ConGoodsDet cgd on cgd.id=cpid.conGoodsDetId
left join dbo.Pro_ConPurchaseContractDet cpcd on cpcd.id=cgd.conContractDetId
left join dbo.Pro_ConPurchasePlanDet cppd on cppd.id=cpcd.conPlanDetID
left join dbo.Pro_ConMemberDet cmd on cmd.id=cppd.conMemberDetId
left join Pro_Info pro on pos.projectCode=pro.projectNum
left join sys_dicDetail t1 on t1.dicItemcode=mad.unitCode
left join sys_dicDetail t2 on t2.dicItemcode=mad.qulity
left join sys_dicDetail t3 on t3.dicItemcode=cmd.allWeightUnit
left join sys_dicDetail t4 on t4.dicItemcode=cmd.weightUnit
" + where;
return sql.ToString();