/// <summary>
/// 修改库区上容器数量信息
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool UpdateContainer_Qty(T_Bllb_StorageLocation_tbsl obj)
{
string strSql = string.Format(@"UPDATE T_Bllb_StorageLocation_tbsl SET MaterialCode='{1}', Container_Qty= Container_Qty+{2},Container_Type='{3}',Status_Flag='{4}' WHERE Location_SN='{0}'", obj.Location_SN, obj.MaterialCode, obj.Container_Qty, obj.Container_Type, obj.Status_Flag);
return(CIT.Wcf.Utils.NMS.ExecTransql(PubUtils.uContext, strSql));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public static bool Insert(T_Bllb_StorageLocation_tbsl obj)
{
string strSql = string.Format(@"INSERT INTO T_Bllb_StorageLocation_tbsl (Location_SN,Location_Name,Area_SN,Enable_Flag) VALUES('{0}','{1}','{2}','{3}')", obj.Location_SN, obj.Location_Name, obj.Area_SN, obj.Enable_Flag);
return(CIT.Wcf.Utils.NMS.ExecTransql(PubUtils.uContext, strSql));
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public static bool Update(T_Bllb_StorageLocation_tbsl obj)
{
string strSql = string.Format(@"UPDATE T_Bllb_StorageLocation_tbsl SET Location_Name='{1}', Area_SN='{2}',Enable_Flag='{3}' WHERE Location_SN='{0}'", obj.Location_SN, obj.Location_Name, obj.Area_SN, obj.Enable_Flag);
return(CIT.Wcf.Utils.NMS.ExecTransql(PubUtils.uContext, strSql));
}
