/// <summary>
/// 查询过站统计数据
/// </summary>
/// <param name="tbgs"></param>
/// <returns></returns>
public DataTable GetTbgs(T_Bllb_groupStatistics_tbgs tbgs)
{
string strSql = string.Format(@"SELECT T.SfcNo,T.TBTG_ID,G.GROUP_NAME,T.PASS_NUM,T.ERROR_NUM
,SUM(CASE P.LAST_FLAG WHEN 'Y' THEN 1 ELSE 0 END) WIP_QTY
FROM T_Bllb_groupStatistics_tbgs T
LEFT JOIN T_Bllb_technologyGroup_tbtg M ON M.TBTG_ID=T.TBTG_ID
LEFT JOIN T_Bllb_group_tbg G ON M.TBG_ID=G.TBG_ID
LEFT JOIN T_Bllb_productStatus_tbps S ON T.TBTG_ID=S.WIP_TBTG_ID AND T.SfcNo=S.SfcNo
LEFT JOIN T_Bllb_productInfo_tbpi P ON T.SfcNo=P.SfcNo AND S.TBPS_ID=P.TBPS_ID
WHERE T.SfcNo='{0}'
GROUP BY T.SfcNo,T.TBTG_ID,G.GROUP_NAME,T.PASS_NUM,T.ERROR_NUM" , tbgs.SfcNo);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
/// <summary>
/// 查询过站统计数据
/// </summary>
/// <param name="tbgs"></param>
/// <returns></returns>
public DataTable SelectTbgs(T_Bllb_groupStatistics_tbgs tbgs)
{
return(t_Bllb_groupStatistics_tbgs_DAL.GetTbgs(tbgs));
}
