/// <summary>
/// 更新是否不良
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public bool Update_ERROR_FLAG(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format(@"update T_Bllb_productInfo_tbpi set ERROR_FLAG='{1}' where SERIAL_NUMBER='{1}'
and LAST_FLAG='Y'", tbpi.SERIAL_NUMBER, tbpi.ERROR_FLAG);
return(NMS.ExecTransql(PubUtils.uContext, strSql));
}
/// <summary>
/// 查询产品SN是否已经报废
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable GetScrap(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format(@"SELECT S.TBPS_ID FROM T_Bllb_productInfo_tbpi AS Tbpi
LEFT JOIN T_Bllb_scrap_tbs AS S
ON S.TBPS_ID=Tbpi.TBPS_ID
WHERE Tbpi.TBPS_ID='{0}' ", tbpi.TbpsId);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
/// <summary>
/// 替换关键件日志查询
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable GetreplaceKeyList(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format(@"SELECT Tbpi.TBPS_ID,OLD_KEY_SN,NEW_KEY_SN,REPLACE_MAN,REPLACE_TIME FROM T_Bllb_productInfo_tbpi AS Tbpi
INNER JOIN T_Bllb_replaceKeyLog_tbrkl AS R
ON Tbpi.TBPS_ID=R.TBPS_ID
WHERE SERIAL_NUMBER='{0}'", tbpi.SERIAL_NUMBER);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
/// <summary>
/// 通过连接查询获得数据（产品状态表和产品信息表进行连接，查找TBPS_ID,SfcNo,通过产品条码进行过滤
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable GetList(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format(@"SELECT TBPI.TBPI_ID,TBPI.TBPS_ID,TBPI.SERIAL_NUMBER,TBPS.SfcNo FROM T_Bllb_productInfo_tbpi AS TBPI
INNER JOIN T_Bllb_productStatus_tbps AS TBPS
ON TBPI.TBPS_ID = TBPS.TBPS_ID
WHERE SERIAL_NUMBER = '{0}' and LAST_FLAG='Y'", tbpi.SERIAL_NUMBER);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
/// <summary>
/// 根据产品SN查找数据
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
//public DataTable GetList(T_Bllb_productInfo_tbpi tbpi)
//{
// string strSql = string.Format("select * from T_Bllb_productInfo_tbpi where SERIAL_NUMBER='{0}'", tbpi.SERIAL_NUMBER);
// return NMS.QueryDataTable(PubUtils.uContext, strSql);
//}
/// <summary>
/// 根据产品SN查找检验单
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable GetDocNoBySN(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format(@"select tbpi.SERIAL_NUMBER,tbap.DOC_NO,tbap.STATUS
from
T_Bllb_productInfo_tbpi as tbpi
inner join
T_Bllb_sampleProduct_tbap as tbap
on tbpi.TBPS_ID = tbap.TBPS_ID
LEFT JOIN T_Bllb_sampleDoc_tbsd tbsd on tbsd.DOC_NO=tbap.DOC_NO
where tbpi.SERIAL_NUMBER = '{0}' AND tbpi.LAST_FLAG='Y' ORDER BY tbsd.CREATE_TIME DESC", tbpi.SERIAL_NUMBER);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
/// <summary>
/// 判断是否产品代码一致
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public bool CheckProductSame(T_Bllb_productInfo_tbpi tbpi, ref string msg)
{
// string strSql = string.Format(@"SELECT A.TBPS_ID,W.Version from T_Bllb_productInfo_tbpi A LEFT JOIN dbo.SfcDatProduct B ON A.SfcNo=B.SfcNo
//LEFT JOIN dbo.T_Work_Number W ON B.WoCode=W.WoCode
// where SERIAL_NUMBER = '{0}' and B.Product = '{1}' AND LAST_FLAG = 'Y' AND W.Version='{2}'", tbpi.SERIAL_NUMBER, tbpi.ProductCode,tbpi.Version);
// return NMS.QueryDataTable(PubUtils.uContext, strSql).Rows.Count == 0 ? false : true;
string strSql = string.Format(@"SELECT W.C_PartNumber, B.Product,A.TBPS_ID,W.Version from T_Bllb_productInfo_tbpi A LEFT JOIN dbo.SfcDatProduct B ON A.SfcNo=B.SfcNo
LEFT JOIN dbo.T_Work_Number W ON B.WoCode=W.WoCode
where SERIAL_NUMBER = '{0}' AND LAST_FLAG = 'Y' ", tbpi.SERIAL_NUMBER, tbpi.ProductCode, tbpi.Version);
DataTable dt_check = NMS.QueryDataTable(PubUtils.uContext, strSql);
if (dt_check.Rows.Count > 0)
{
string str_product = SqlInput.ChangeNullToString(dt_check.Rows[0]["Product"]); //产品
string str_Version = SqlInput.ChangeNullToString(dt_check.Rows[0]["Version"]); //版本
string str_C_PartNumber = SqlInput.ChangeNullToString(dt_check.Rows[0]["C_PartNumber"]); //版本
if (str_product != tbpi.ProductCode)
{
msg = "产品有误，扫描产品为" + str_product;
return(false);
}
else if (str_Version != tbpi.Version)
{
msg = "产品版本有误，扫描产品版本为" + str_Version;
return(false);
}
else if (str_C_PartNumber != tbpi.C_PartNumber)
{
msg = "客户料号有误，扫描客户料号为" + str_C_PartNumber;
return(false);
}
msg = string.Empty;
return(true);
}
else
{
msg = "产品条码不存在";
return(false);
}
}
/// <summary>
/// 根据产品SN查找数据
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable SelectBySN(T_Bllb_productInfo_tbpi tbpi)
{
return(t_Bllb_productInfo_tbpi_DAL.GetList(tbpi));
}
/// <summary>
/// 更新是否不良字段
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public bool Update_ERROR_FLAG(T_Bllb_productInfo_tbpi tbpi)
{
return(t_Bllb_productInfo_tbpi_DAL.Update_ERROR_FLAG(tbpi));
}
/// <summary>
/// 判断是否产品代码一致
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public bool CheckProductSame(T_Bllb_productInfo_tbpi tbpi, ref string msg)
{
return(t_Bllb_productInfo_tbpi_DAL.CheckProductSame(tbpi, ref msg));
}
/// <summary>
/// 通过产品条码，查询TBPI_ID
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable SelectBySerialNumber(T_Bllb_productInfo_tbpi tbpi)
{
return(t_Bllb_productInfo_tbpi_DAL.GetBySerialNumber(tbpi));
}
/// <summary>
/// 查询产品SN是否已报废
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable SelectScrap(T_Bllb_productInfo_tbpi tbpi)
{
return(t_Bllb_productInfo_tbpi_DAL.GetScrap(tbpi));
}
/// <summary>
/// 更新是否报废字段
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public bool Update(T_Bllb_productInfo_tbpi tbpi)
{
return(t_Bllb_productInfo_tbpi_DAL.UpdateList(tbpi));
}
/// <summary>
/// 替换关键件日志查询
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable SelectreplaceKey(T_Bllb_productInfo_tbpi tbpi)
{
return(t_Bllb_productInfo_tbpi_DAL.GetreplaceKeyList(tbpi));
}
/// <summary>
/// 查询产品条码数据
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable GetSN(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format(@"SELECT TBPS_ID FROM T_Bllb_productInfo_tbpi WHERE SERIAL_NUMBER='{0}' AND LAST_FLAG='Y'", tbpi.SERIAL_NUMBER);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
/// <summary>
/// 更新是否报废字段
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public bool UpdateList(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format("update T_Bllb_productInfo_tbpi set SCRAP_FLAG='Y',SERIAL_NUMBER=SERIAL_NUMBER+'-BF' where TBPS_ID='{0}'", tbpi.TbpsId);
return(NMS.ExecTransql(PubUtils.uContext, strSql));
}
/// <summary>
/// 通过产品条码和制令单查询数据
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable GetBySfcAndSNr(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format("select * from T_Bllb_productInfo_tbpi where SERIAL_NUMBER='{0}' and SfcNo='{1}' and LAST_FLAG='Y'", tbpi.SERIAL_NUMBER, tbpi.SfcNo);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
/// <summary>
/// 通过产品条码，查询TBPI_ID
/// </summary>
/// <param name="tbpi"></param>
/// <returns></returns>
public DataTable GetBySerialNumber(T_Bllb_productInfo_tbpi tbpi)
{
string strSql = string.Format(@"select TBPI_ID,QTY,TBPS_ID from T_Bllb_productInfo_tbpi where SERIAL_NUMBER='{0}' and LAST_FLAG='Y'", tbpi.SERIAL_NUMBER);
return(NMS.QueryDataTable(PubUtils.uContext, strSql));
}
