/// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Commodity_Stage_Price model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Commodity_Stage_Price>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.CommodityId.IsNullOrEmpty())
                {
                    delete.Where(p => p.CommodityId == model.CommodityId);
                }
                if (!model.StageAmount.IsNullOrEmpty())
                {
                    delete.Where(p => p.StageAmount == model.StageAmount);
                }
                if (!model.StagePrice.IsNullOrEmpty())
                {
                    delete.Where(p => p.StagePrice == model.StagePrice);
                }
                if (!model.DiscountRate.IsNullOrEmpty())
                {
                    delete.Where(p => p.DiscountRate == model.DiscountRate);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Message model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Message>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.MainTitle.IsNullOrEmpty())
                {
                    delete.Where(p => p.MainTitle == model.MainTitle);
                }
                if (!model.Title.IsNullOrEmpty())
                {
                    delete.Where(p => p.Title == model.Title);
                }
                if (!model.Content.IsNullOrEmpty())
                {
                    delete.Where(p => p.Content == model.Content);
                }
                if (!model.MessageTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.MessageTime == model.MessageTime);
                }
                if (!model.IsDelete.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsDelete == model.IsDelete);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 3
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Distribution model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Distribution>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.ProductionId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ProductionId == model.ProductionId);
                }
                if (!model.procedures.IsNullOrEmpty())
                {
                    delete.Where(p => p.procedures == model.procedures);
                }
                if (!model.productionTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.productionTime == model.productionTime);
                }
                if (!model.productionMan.IsNullOrEmpty())
                {
                    delete.Where(p => p.productionMan == model.productionMan);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Comm_Discount model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Comm_Discount>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.CommodityId.IsNullOrEmpty())
                {
                    delete.Where(p => p.CommodityId == model.CommodityId);
                }
                if (!model.rate.IsNullOrEmpty())
                {
                    delete.Where(p => p.rate == model.rate);
                }
                if (!model.ValidityTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.ValidityTime == model.ValidityTime);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(User_Tips model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <User_Tips>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.UserId.IsNullOrEmpty())
                {
                    delete.Where(p => p.UserId == model.UserId);
                }
                if (!model.TipsId.IsNullOrEmpty())
                {
                    delete.Where(p => p.TipsId == model.TipsId);
                }
                if (!model.IsClick.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsClick == model.IsClick);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
        /// <summary>
        /// 根据主键删除数据
        /// </summary>
        /// <param name="KeyId">主键Id</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteById(int KeyId, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Commodity_Stage_Price>();

            delete.Where(p => p.Id == KeyId);
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 7
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Erploginuer model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Erploginuer>();

            if (model != null)
            {
                if (!model.erpLoginId.IsNullOrEmpty())
                {
                    delete.Where(p => p.erpLoginId == model.erpLoginId);
                }
                if (!model.ErproleId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ErproleId == model.ErproleId);
                }
                if (!model.erpLoginName.IsNullOrEmpty())
                {
                    delete.Where(p => p.erpLoginName == model.erpLoginName);
                }
                if (!model.erpLoginPwd.IsNullOrEmpty())
                {
                    delete.Where(p => p.erpLoginPwd == model.erpLoginPwd);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 8
0
        /// <summary>
        /// 根据主键删除数据
        /// </summary>
        /// <param name="KeyId">主键Id</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteById(int KeyId, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Erploginuer>();

            delete.Where(p => p.erpLoginId == KeyId);
            return(delete.GetDeleteResult(connection, transaction));
        }
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Orderdetaildesign model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Orderdetaildesign>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.OrderDetailId.IsNullOrEmpty())
                {
                    delete.Where(p => p.OrderDetailId == model.OrderDetailId);
                }
                if (!model.Content.IsNullOrEmpty())
                {
                    delete.Where(p => p.Content == model.Content);
                }
                if (!model.PrintingPosition.IsNullOrEmpty())
                {
                    delete.Where(p => p.PrintingPosition == model.PrintingPosition);
                }
                if (!model.Image.IsNullOrEmpty())
                {
                    delete.Where(p => p.Image == model.Image);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 10
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Reply model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Reply>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.CreateTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.CreateTime == model.CreateTime);
                }
                if (!model.Content.IsNullOrEmpty())
                {
                    delete.Where(p => p.Content == model.Content);
                }
                if (!model.EvalinfoId.IsNullOrEmpty())
                {
                    delete.Where(p => p.EvalinfoId == model.EvalinfoId);
                }
                if (!model.ImageList.IsNullOrEmpty())
                {
                    delete.Where(p => p.ImageList == model.ImageList);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 11
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Sales_Return model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Sales_Return>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.DetailId.IsNullOrEmpty())
                {
                    delete.Where(p => p.DetailId == model.DetailId);
                }
                if (!model.ReturnText.IsNullOrEmpty())
                {
                    delete.Where(p => p.ReturnText == model.ReturnText);
                }
                if (!model.ISRetuen.IsNullOrEmpty())
                {
                    delete.Where(p => p.ISRetuen == model.ISRetuen);
                }
                if (!model.ReturnReason.IsNullOrEmpty())
                {
                    delete.Where(p => p.ReturnReason == model.ReturnReason);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 12
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Carousel_Image model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Carousel_Image>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.Image.IsNullOrEmpty())
                {
                    delete.Where(p => p.Image == model.Image);
                }
                if (!model.OrderID.IsNullOrEmpty())
                {
                    delete.Where(p => p.OrderID == model.OrderID);
                }
                if (!model.AUrl.IsNullOrEmpty())
                {
                    delete.Where(p => p.AUrl == model.AUrl);
                }
                if (!model.IsCarousel.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsCarousel == model.IsCarousel);
                }
                if (!model.IsPC.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsPC == model.IsPC);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 13
0
        /// <summary>
        /// 根据主键删除数据
        /// </summary>
        /// <param name="KeyId">主键Id</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteByGradeId(int gradeId, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Grade_Attr>();

            delete.Where(p => p.GradeId == gradeId);
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 14
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Commshow model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Commshow>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.GradeId.IsNullOrEmpty())
                {
                    delete.Where(p => p.GradeId == model.GradeId);
                }
                if (!model.OrderId.IsNullOrEmpty())
                {
                    delete.Where(p => p.OrderId == model.OrderId);
                }
                if (!model.CommId.IsNullOrEmpty())
                {
                    delete.Where(p => p.CommId == model.CommId);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 15
0
        /// <summary>
        /// 根据主键删除数据
        /// </summary>
        /// <param name="KeyId">主键Id</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteById(int KeyId, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Hot_Search>();

            delete.Where(p => p.Id == KeyId);
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 16
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Commrecommend model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Commrecommend>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.CommId.IsNullOrEmpty())
                {
                    delete.Where(p => p.CommId == model.CommId);
                }
                if (!model.OrderID.IsNullOrEmpty())
                {
                    delete.Where(p => p.OrderID == model.OrderID);
                }
                if (!model.FrontImage.IsNullOrEmpty())
                {
                    delete.Where(p => p.FrontImage == model.FrontImage);
                }
                if (!model.AttrSpan.IsNullOrEmpty())
                {
                    delete.Where(p => p.AttrSpan == model.AttrSpan);
                }
                if (!model.BehindImage.IsNullOrEmpty())
                {
                    delete.Where(p => p.BehindImage == model.BehindImage);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 17
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Message_Grant model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Message_Grant>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.UserId.IsNullOrEmpty())
                {
                    delete.Where(p => p.UserId == model.UserId);
                }
                if (!model.MessageId.IsNullOrEmpty())
                {
                    delete.Where(p => p.MessageId == model.MessageId);
                }
                if (!model.IsWatch.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsWatch == model.IsWatch);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 18
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Producerinvoice model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Producerinvoice>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.ProducerId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ProducerId == model.ProducerId);
                }
                if (!model.CompanyName.IsNullOrEmpty())
                {
                    delete.Where(p => p.CompanyName == model.CompanyName);
                }
                if (!model.InvoiceNumber.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoiceNumber == model.InvoiceNumber);
                }
                if (!model.InvoiceTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoiceTime == model.InvoiceTime);
                }
                if (!model.InvoiceMoney.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoiceMoney == model.InvoiceMoney);
                }
                if (!model.InvoiceIdentify.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoiceIdentify == model.InvoiceIdentify);
                }
                if (!model.InvoicePhone.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoicePhone == model.InvoicePhone);
                }
                if (!model.InvoiceAddress.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoiceAddress == model.InvoiceAddress);
                }
                if (!model.InvoiceBank.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoiceBank == model.InvoiceBank);
                }
                if (!model.InvoiceContext.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoiceContext == model.InvoiceContext);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 19
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Invoice model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Invoice>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.UserId.IsNullOrEmpty())
                {
                    delete.Where(p => p.UserId == model.UserId);
                }
                if (!model.OrderId.IsNullOrEmpty())
                {
                    delete.Where(p => p.OrderId == model.OrderId);
                }
                if (!model.Title.IsNullOrEmpty())
                {
                    delete.Where(p => p.Title == model.Title);
                }
                if (!model.DutyParagraph.IsNullOrEmpty())
                {
                    delete.Where(p => p.DutyParagraph == model.DutyParagraph);
                }
                if (!model.TypeInvoice.IsNullOrEmpty())
                {
                    delete.Where(p => p.TypeInvoice == model.TypeInvoice);
                }
                if (!model.InvoiceTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.InvoiceTime == model.InvoiceTime);
                }
                if (!model.MobliePhone.IsNullOrEmpty())
                {
                    delete.Where(p => p.MobliePhone == model.MobliePhone);
                }
                if (!model.OpeningBank.IsNullOrEmpty())
                {
                    delete.Where(p => p.OpeningBank == model.OpeningBank);
                }
                if (!model.BankAccount.IsNullOrEmpty())
                {
                    delete.Where(p => p.BankAccount == model.BankAccount);
                }
                if (!model.Address.IsNullOrEmpty())
                {
                    delete.Where(p => p.Address == model.Address);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 20
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Evaluate model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Evaluate>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.UserId.IsNullOrEmpty())
                {
                    delete.Where(p => p.UserId == model.UserId);
                }
                if (!model.CommodityId.IsNullOrEmpty())
                {
                    delete.Where(p => p.CommodityId == model.CommodityId);
                }
                if (!model.ImageList.IsNullOrEmpty())
                {
                    delete.Where(p => p.ImageList == model.ImageList);
                }
                if (!model.CreateTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.CreateTime == model.CreateTime);
                }
                if (!model.Content.IsNullOrEmpty())
                {
                    delete.Where(p => p.Content == model.Content);
                }
                if (!model.Start.IsNullOrEmpty())
                {
                    delete.Where(p => p.Start == model.Start);
                }
                if (!model.FrontView.IsNullOrEmpty())
                {
                    delete.Where(p => p.FrontView == model.FrontView);
                }
                if (!model.BackView.IsNullOrEmpty())
                {
                    delete.Where(p => p.BackView == model.BackView);
                }
                if (!model.ParentId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ParentId == model.ParentId);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 21
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Grade model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Grade>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.Name.IsNullOrEmpty())
                {
                    delete.Where(p => p.Name == model.Name);
                }
                if (!model.Image.IsNullOrEmpty())
                {
                    delete.Where(p => p.Image == model.Image);
                }
                if (!model.BigImage.IsNullOrEmpty())
                {
                    delete.Where(p => p.BigImage == model.BigImage);
                }
                if (!model.ParentId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ParentId == model.ParentId);
                }
                if (!model.HotGradeTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.HotGradeTime == model.HotGradeTime);
                }
                if (!model.GradeAttrName.IsNullOrEmpty())
                {
                    delete.Where(p => p.GradeAttrName == model.GradeAttrName);
                }
                if (!model.IsDelete.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsDelete == model.IsDelete);
                }
                if (!model.IsScene.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsScene == model.IsScene);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Materials_Producer model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Materials_Producer>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.ProducerId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ProducerId == model.ProducerId);
                }
                if (!model.MaterialsId.IsNullOrEmpty())
                {
                    delete.Where(p => p.MaterialsId == model.MaterialsId);
                }
                if (!model.FactoryNumber.IsNullOrEmpty())
                {
                    delete.Where(p => p.FactoryNumber == model.FactoryNumber);
                }
                if (!model.PurchasePrice.IsNullOrEmpty())
                {
                    delete.Where(p => p.PurchasePrice == model.PurchasePrice);
                }
                if (!model.QuotationDate.IsNullOrEmpty())
                {
                    delete.Where(p => p.QuotationDate == model.QuotationDate);
                }
                if (!model.ProCycle.IsNullOrEmpty())
                {
                    delete.Where(p => p.ProCycle == model.ProCycle);
                }
                if (!model.MinQuantity.IsNullOrEmpty())
                {
                    delete.Where(p => p.MinQuantity == model.MinQuantity);
                }
                if (!model.PriceTag.IsNullOrEmpty())
                {
                    delete.Where(p => p.PriceTag == model.PriceTag);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 23
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Receive model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Receive>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.ProductionId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ProductionId == model.ProductionId);
                }
                if (!model.receiveStatus.IsNullOrEmpty())
                {
                    delete.Where(p => p.receiveStatus == model.receiveStatus);
                }
                if (!model.receiveOutTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.receiveOutTime == model.receiveOutTime);
                }
                if (!model.receiveTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.receiveTime == model.receiveTime);
                }
                if (!model.receiveContext.IsNullOrEmpty())
                {
                    delete.Where(p => p.receiveContext == model.receiveContext);
                }
                if (!model.receiveSinglePerson.IsNullOrEmpty())
                {
                    delete.Where(p => p.receiveSinglePerson == model.receiveSinglePerson);
                }
                if (!model.receiveSingleTime.IsNullOrEmpty())
                {
                    delete.Where(p => p.receiveSingleTime == model.receiveSingleTime);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Producerconectinfo model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Producerconectinfo>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.ConectName.IsNullOrEmpty())
                {
                    delete.Where(p => p.ConectName == model.ConectName);
                }
                if (!model.Position.IsNullOrEmpty())
                {
                    delete.Where(p => p.Position == model.Position);
                }
                if (!model.ConectSex.IsNullOrEmpty())
                {
                    delete.Where(p => p.ConectSex == model.ConectSex);
                }
                if (!model.Telephone.IsNullOrEmpty())
                {
                    delete.Where(p => p.Telephone == model.Telephone);
                }
                if (!model.Phone.IsNullOrEmpty())
                {
                    delete.Where(p => p.Phone == model.Phone);
                }
                if (!model.Email.IsNullOrEmpty())
                {
                    delete.Where(p => p.Email == model.Email);
                }
                if (!model.ProducerId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ProducerId == model.ProducerId);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 25
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Customerservice model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Customerservice>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.ServiceName.IsNullOrEmpty())
                {
                    delete.Where(p => p.ServiceName == model.ServiceName);
                }
                if (!model.ServicePwd.IsNullOrEmpty())
                {
                    delete.Where(p => p.ServicePwd == model.ServicePwd);
                }
                if (!model.IsService.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsService == model.IsService);
                }
                if (!model.ServiceQQ.IsNullOrEmpty())
                {
                    delete.Where(p => p.ServiceQQ == model.ServiceQQ);
                }
                if (!model.ServiceWechat.IsNullOrEmpty())
                {
                    delete.Where(p => p.ServiceWechat == model.ServiceWechat);
                }
                if (!model.ServiceALWW.IsNullOrEmpty())
                {
                    delete.Where(p => p.ServiceALWW == model.ServiceALWW);
                }
                if (!model.ServicePhone.IsNullOrEmpty())
                {
                    delete.Where(p => p.ServicePhone == model.ServicePhone);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 26
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Showgradeinfo model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Showgradeinfo>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.GradeId.IsNullOrEmpty())
                {
                    delete.Where(p => p.GradeId == model.GradeId);
                }
                if (!model.OrderCount.IsNullOrEmpty())
                {
                    delete.Where(p => p.OrderCount == model.OrderCount);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 27
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Warehouse model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Warehouse>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.Name.IsNullOrEmpty())
                {
                    delete.Where(p => p.Name == model.Name);
                }
                if (!model.IsDelete.IsNullOrEmpty())
                {
                    delete.Where(p => p.IsDelete == model.IsDelete);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 28
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Hot_Search model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Hot_Search>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.SearchWord.IsNullOrEmpty())
                {
                    delete.Where(p => p.SearchWord == model.SearchWord);
                }
                if (!model.Amount.IsNullOrEmpty())
                {
                    delete.Where(p => p.Amount == model.Amount);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 29
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Grade_Attr model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Grade_Attr>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.GradeId.IsNullOrEmpty())
                {
                    delete.Where(p => p.GradeId == model.GradeId);
                }
                if (!model.Content.IsNullOrEmpty())
                {
                    delete.Where(p => p.Content == model.Content);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }
Ejemplo n.º 30
0
        /// <summary>
        /// 根据模型删除数据
        /// </summary>
        /// <param name="model">模型</param>
        /// <param name="connection">连接</param>
        /// <param name="transaction">事务</param>
        /// <returns>是否成功</returns>
        public bool DeleteModel(Materials_Colorinfo model = null, IDbConnection connection = null, IDbTransaction transaction = null)
        {
            var delete = new LambdaDelete <Materials_Colorinfo>();

            if (model != null)
            {
                if (!model.Id.IsNullOrEmpty())
                {
                    delete.Where(p => p.Id == model.Id);
                }
                if (!model.MaterialsId.IsNullOrEmpty())
                {
                    delete.Where(p => p.MaterialsId == model.MaterialsId);
                }
                if (!model.SKU.IsNullOrEmpty())
                {
                    delete.Where(p => p.SKU == model.SKU);
                }
                if (!model.ColorId.IsNullOrEmpty())
                {
                    delete.Where(p => p.ColorId == model.ColorId);
                }
                if (!model.MinStockNum.IsNullOrEmpty())
                {
                    delete.Where(p => p.MinStockNum == model.MinStockNum);
                }
                if (!model.SKUImage.IsNullOrEmpty())
                {
                    delete.Where(p => p.SKUImage == model.SKUImage);
                }
                if (!model.PositionInfo.IsNullOrEmpty())
                {
                    delete.Where(p => p.PositionInfo == model.PositionInfo);
                }
            }
            return(delete.GetDeleteResult(connection, transaction));
        }