Beispiel #1
0
        /// <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));
        }
Beispiel #2
0
        /// <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));
        }
Beispiel #3
0
        /// <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));
        }