Exemple #1
0
 /// <summary>
 /// 删除货品条码
 /// </summary>
 /// <param name="idcode"></param>
 public void DeleteMatIDCode(MatIDCode idcode)
 {
     using (IDataSession session = AppDataFactory.CreateMainSession())
     {
         session.Delete <MatIDCode>(idcode);
     }
 }
Exemple #2
0
        /// <summary>
        /// 删除信息
        /// </summary>
        /// <param name=""></param>
        /// <returns>删除个数</returns>
        public int Delete(CheckStockBill info)
        {
            int    count = 0;
            string sql   = "";

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    session.OpenTs();

                    count = session.Delete <CheckStockBill>(info);

                    sql = "delete from T_WH_CheckStockDetail where BillID = @BillID";
                    session.ExecuteSql(sql, new DataParameter("BillID", info.ID));

                    session.CommitTs();
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #3
0
        /// <summary>
        /// 删除信息
        /// </summary>
        /// <param name=""></param>
        /// <returns>删除个数</returns>
        public int Delete(ProductInfo model)
        {
            int count = 0;

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    //删除基本信息
                    count = session.Delete <ProductInfo>(model);
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #4
0
        /// <summary>
        /// 删除公告信息
        /// </summary>
        /// <param name="user">公告信息</param>
        /// <returns>删除个数</returns>
        public int Delete(NoticeInfo notice)
        {
            int count = 0;

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    //删除基本信息
                    count = session.Delete <NoticeInfo>(notice);
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Exemple #5
0
        /// <summary>
        /// 删除信息
        /// </summary>
        /// <param name=""></param>
        /// <returns>删除个数</returns>
        public int Delete(WHStockLimit info)
        {
            int count = 0;

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    //删除基本信息
                    count = session.Delete <WHStockLimit>(info);
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #6
0
        /// <summary>
        /// 逻辑删除信息
        /// </summary>
        /// <param name=""></param>
        /// <returns>删除个数</returns>
        public int Delete(WHOutMode model)
        {
            StringBuilder        sqlBuilder = new StringBuilder();
            List <DataParameter> parameters = new List <DataParameter>();
            int count = 0;

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    count = session.Delete <WHOutMode>(model);
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #7
0
        public void Delete(UseMatBill bill)
        {
            string sql = null;

            using (IDataSession session = AppDataFactory.CreateMainSession())
            {
                session.OpenTs();
                session.Delete <UseMatBill>(bill);

                sql = "delete from T_WH_UseMatAmount where USEID = @USEID";
                session.ExecuteSql(sql, new DataParameter("USEID", bill.PID));
                session.Insert <UseMatAmount>(bill.Amounts);

                sql = "delete from T_WH_UseMatDetail where USEID = @USEID";
                session.ExecuteSql(sql, new DataParameter("USEID", bill.PID));
                session.Insert <UseMatDetail>(bill.Details);
                session.CommitTs();
            }
        }
Exemple #8
0
        /// <summary>
        /// 删除信息
        /// </summary>
        /// <param name=""></param>
        /// <returns>删除个数</returns>
        public int Delete(WHQualityCheck model)
        {
            int count = 0;

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    //删除基本信息
                    count = session.Delete <WHQualityCheck>(model);
                    //删除明细信息
                    string sql = "DELETE FROM T_WH_QualityCheckResult WHERE CheckID = @CheckID";
                    session.ExecuteSql(sql, new DataParameter("CheckID", model.ID));
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #9
0
        /// <summary>
        /// 删除信息
        /// </summary>
        /// <param name=""></param>
        /// <returns>删除个数</returns>
        public int Delete(ProduceBOM model)
        {
            int count = 0;

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    //删除BOM信息
                    count = session.Delete <ProduceBOM>(model);
                    //删除BOM明细信息
                    string sql = "delete from T_FP_BOMDETAIL where BOMID = @BOMID";
                    session.ExecuteSql(sql, new DataParameter("BOMID", model.PID));
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #10
0
        /// <summary>
        /// 删除信息
        /// </summary>
        /// <param name=""></param>
        /// <returns>删除个数</returns>
        public int Delete(SupplyInfo model)
        {
            int count = 0;

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    //删除BOM信息
                    count = session.Delete <SupplyInfo>(model);
                    //删除BOM明细信息
                    string sql = "delete from T_FP_SUPPLYMATERIALINFO where SUPPLYID = @SUPPLYID";
                    session.ExecuteSql(sql, new DataParameter("SUPPLYID", model.PID));
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Exemple #11
0
        /// <summary>
        /// 删除信息
        /// </summary>
        /// <param name=""></param>
        /// <returns>删除个数</returns>
        public int Delete(QualityCheckInfo model)
        {
            int count = 0;

            try
            {
                using (IDataSession session = AppDataFactory.CreateMainSession())
                {
                    //删除BOM信息
                    count = session.Delete <QualityCheckInfo>(model);
                    //删除BOM明细信息
                    string sql = "DELETE FROM T_FP_QUALITYCHECKRESULT WHERE CheckID = @CheckID";
                    session.ExecuteSql(sql, new DataParameter("CheckID", model.ID));
                }
                return(count);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }