/// <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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <summary> /// 根据模型删除数据 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool DeleteModel(News model = null, IDbConnection connection = null, IDbTransaction transaction = null) { var delete = new LambdaDelete <News>(); if (model != null) { if (!model.Id.IsNullOrEmpty()) { delete.Where(p => p.Id == model.Id); } if (!model.Title.IsNullOrEmpty()) { delete.Where(p => p.Title == model.Title); } if (!model.MainTitle.IsNullOrEmpty()) { delete.Where(p => p.MainTitle == model.MainTitle); } if (!model.Content.IsNullOrEmpty()) { delete.Where(p => p.Content == model.Content); } if (!model.ValidityTime.IsNullOrEmpty()) { delete.Where(p => p.ValidityTime == model.ValidityTime); } } return(delete.GetDeleteResult(connection, transaction)); }
/// <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="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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <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="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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <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(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)); }
/// <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)); }
/// <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(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)); }
/// <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)); }
/// <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)); }
/// <summary> /// 根据模型删除数据 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool DeleteModel(Receive_Materials model = null, IDbConnection connection = null, IDbTransaction transaction = null) { var delete = new LambdaDelete <Receive_Materials>(); if (model != null) { if (!model.Id.IsNullOrEmpty()) { delete.Where(p => p.Id == model.Id); } if (!model.receiveId.IsNullOrEmpty()) { delete.Where(p => p.receiveId == model.receiveId); } if (!model.raw_materialsId.IsNullOrEmpty()) { delete.Where(p => p.raw_materialsId == model.raw_materialsId); } if (!model.BaseCount.IsNullOrEmpty()) { delete.Where(p => p.BaseCount == model.BaseCount); } if (!model.additionalCount.IsNullOrEmpty()) { delete.Where(p => p.additionalCount == model.additionalCount); } if (!model.SKU.IsNullOrEmpty()) { delete.Where(p => p.SKU == model.SKU); } if (!model.Isadditional.IsNullOrEmpty()) { delete.Where(p => p.Isadditional == model.Isadditional); } } return(delete.GetDeleteResult(connection, transaction)); }
/// <summary> /// 根据模型删除数据 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool DeleteModel(Changestorage model = null, IDbConnection connection = null, IDbTransaction transaction = null) { var delete = new LambdaDelete <Changestorage>(); if (model != null) { if (!model.Id.IsNullOrEmpty()) { delete.Where(p => p.Id == model.Id); } if (!model.storageId.IsNullOrEmpty()) { delete.Where(p => p.storageId == model.storageId); } if (!model.ChangeTime.IsNullOrEmpty()) { delete.Where(p => p.ChangeTime == model.ChangeTime); } if (!model.ChangeType.IsNullOrEmpty()) { delete.Where(p => p.ChangeType == model.ChangeType); } if (!model.ChangeCount.IsNullOrEmpty()) { delete.Where(p => p.ChangeCount == model.ChangeCount); } if (!model.ChangeAfterCount.IsNullOrEmpty()) { delete.Where(p => p.ChangeAfterCount == model.ChangeAfterCount); } if (!model.ChangeContext.IsNullOrEmpty()) { delete.Where(p => p.ChangeContext == model.ChangeContext); } } return(delete.GetDeleteResult(connection, transaction)); }