/// <summary>
/// 报废
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool Scapt(T_Bllb_StockInfo_tbsi obj)
{
string strSql = string.Format(@" Update T_Bllb_StockInfo_tbsi set Enable='N',Scrapt_Time=getdate() WHERE SerialNumber='{0}'", obj.SerialNumber);
return(NMS.ExecTransql(PubUtils.uContext, strSql.ToString()));
}
/// <summary>
/// 盘点
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool UpdateByCheckMaterial(T_Bllb_StockInfo_tbsi obj)
{
string strSql = string.Format(@" Update T_Bllb_StockInfo_tbsi set QTY={1},Location_SN='{2}',Status_Flag='{3}',MaterialCode='{4}',PLCode='{5}' WHERE SerialNumber='{0}'", obj.SerialNumber, obj.QTY, obj.Location_SN, obj.Status_Flag, obj.MaterialCode, obj.PLCode);
return(NMS.ExecTransql(PubUtils.uContext, strSql.ToString()));
}
/// <summary>
/// 调拨
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool UpdateLoacation(T_Bllb_StockInfo_tbsi obj)
{
string strSql = string.Format(@" Update T_Bllb_StockInfo_tbsi set Location_SN='{1}',Area_SN='{2}',Storage_SN='{3}' WHERE SerialNumber='{0}'", obj.SerialNumber, obj.Location_SN, obj.Area_SN, obj.Storage_SN);
return(NMS.ExecTransql(PubUtils.uContext, strSql.ToString()));
}
/// <summary>
/// 修改物料数量
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool UpdateQty(T_Bllb_StockInfo_tbsi obj)
{
string strSql = string.Format(@" Update T_Bllb_StockInfo_tbsi set QTY={1} WHERE SerialNumber='{0}'", obj.SerialNumber, obj.QTY);
return(NMS.ExecTransql(PubUtils.uContext, strSql.ToString()));
}
