/// <summary> /// 删除 /// </summary> /// <param name="obj"></param> /// <returns></returns> public static bool Delete(Model.T_Bllb_LocationContainer_tblc obj) { string strSql = string.Format(@"DELETE FROM T_Bllb_LocationContainer_tblc WHERE Location_SN='{0}' AND Container_Type='{1}'", obj.Location_SN, obj.Container_Type); return(CIT.Wcf.Utils.NMS.ExecTransql(PubUtils.uContext, strSql)); }
/// <summary> /// 修改 /// </summary> /// <param name="obj"></param> /// <returns></returns> public static bool Update(Model.T_Bllb_LocationContainer_tblc obj) { string strSql = string.Format(@"Update T_Bllb_LocationContainer_tblc set QTY='{2}' WHERE Location_SN='{0}' AND Container_Type='{1}'", obj.Location_SN, obj.Container_Type, obj.QTY); return(CIT.Wcf.Utils.NMS.ExecTransql(PubUtils.uContext, strSql)); }
/// <summary> /// 新增 /// </summary> /// <param name="obj"></param> /// <returns></returns> public static bool Insert(Model.T_Bllb_LocationContainer_tblc obj) { string strSql = string.Format(@"INSERT INTO T_Bllb_LocationContainer_tblc(Location_SN,Container_Type,QTY) VALUES('{0}','{1}',{2})", obj.Location_SN, obj.Container_Type, obj.QTY); return(CIT.Wcf.Utils.NMS.ExecTransql(PubUtils.uContext, strSql)); }