/// <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())); }