SELECT TOP 50 sColorTemplateNo = A.sBillNo,A.sTemplateName,A.sParentColorNo
,sRemark=dbo.fnpbConcatStringEx(b.sColorNo + '('+CAST( CAST(b.nRate AS DECIMAL(18,2)) AS NVARCHAR)+'%)-'+c.sMaterialNo,' / ')
FROM dbo.tmDyeingColorTemplate A(NOLOCK)
JOIN dbo.tmDyeingColorTemplateDtl b ON a.iIden=b.iHdrId
LEFT JOIN dbo.mmMaterial c ON b.iMaterialId=c.iIden
WHERE A.iBillStatus= 2
AND A.bUsable=1
AND 1=1
GROUP BY a.sBillNo,a.sTemplateName,a.sParentColorNo
查询出前50行的模板配方编号和模版配方名称，大色号，配方=色号+单纱比例+%-物料编号，当模版配方头表的单据状态为已审核的时候，查出的信息按照编号，模板名称和色号分类。
9、出货地点:从销售交地表sdDestination中查询出可用的出货地点名称和出货地点ID
10、物料:
IF :iDyeingType IN(1,3)
BEGIN
--染绒时取绒
SELECT /*TOP*/ A.sMaterialNo,A.sMaterialName,iMaterialId = A.iIden,A.iUnitId,sUnitName=A.sUnit
FROM dbo.mmMaterial A(NOLOCK)
WHERE A.iMaterialCategoryId = 2 AND A.bUsable=1
AND (/*Condition*/)
END
ELSE BEGIN
--染纱时取原纱库的库存物料
SELECT /*TOP*/ A.sMaterialNo,A.sMaterialName,iMaterialId = A.iIden,A.iUnitId,sUnitName=A.sUnit
FROM dbo.mmMaterial A WITH(NOLOCK)
WHERE A.iMaterialCategoryId = 4 AND a.bUsable=1
AND (/*Condition*/)
END
--当参数传过来的物料类型为1或3的时候（染绒、脱色）都取绒的物料，否则都取纱的物料
11、单位：从单位表pbUnit中查询出可用的单位名称和单位ID
