/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Orderdetaildesign model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Orderdetaildesign>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.OrderDetailId.IsNullOrEmpty()) { update.Set(p => p.OrderDetailId == model.OrderDetailId); } if (!model.Content.IsNullOrEmpty()) { update.Set(p => p.Content == model.Content); } if (!model.PrintingPosition.IsNullOrEmpty()) { update.Set(p => p.PrintingPosition == model.PrintingPosition); } if (!model.Image.IsNullOrEmpty()) { update.Set(p => p.Image == model.Image); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Receive_Materials model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Receive_Materials>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.receiveId.IsNullOrEmpty()) { update.Set(p => p.receiveId == model.receiveId); } if (!model.raw_materialsId.IsNullOrEmpty()) { update.Set(p => p.raw_materialsId == model.raw_materialsId); } if (!model.BaseCount.IsNullOrEmpty()) { update.Set(p => p.BaseCount == model.BaseCount); } if (!model.additionalCount.IsNullOrEmpty()) { update.Set(p => p.additionalCount == model.additionalCount); } if (!model.SKU.IsNullOrEmpty()) { update.Set(p => p.SKU == model.SKU); } if (!model.Isadditional.IsNullOrEmpty()) { update.Set(p => p.Isadditional == model.Isadditional); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Message model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Message>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.MainTitle.IsNullOrEmpty()) { update.Set(p => p.MainTitle == model.MainTitle); } if (!model.Title.IsNullOrEmpty()) { update.Set(p => p.Title == model.Title); } if (!model.Content.IsNullOrEmpty()) { update.Set(p => p.Content == model.Content); } if (!model.MessageTime.IsNullOrEmpty()) { update.Set(p => p.MessageTime == model.MessageTime); } if (!model.IsDelete.IsNullOrEmpty()) { update.Set(p => p.IsDelete == model.IsDelete); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Commodity_Stage_Price model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Commodity_Stage_Price>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.CommodityId.IsNullOrEmpty()) { update.Set(p => p.CommodityId == model.CommodityId); } if (!model.StageAmount.IsNullOrEmpty()) { update.Set(p => p.StageAmount == model.StageAmount); } if (!model.StagePrice.IsNullOrEmpty()) { update.Set(p => p.StagePrice == model.StagePrice); } if (!model.DiscountRate.IsNullOrEmpty()) { update.Set(p => p.DiscountRate == model.DiscountRate); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Sales_Return model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Sales_Return>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.DetailId.IsNullOrEmpty()) { update.Set(p => p.DetailId == model.DetailId); } if (!model.ReturnText.IsNullOrEmpty()) { update.Set(p => p.ReturnText == model.ReturnText); } if (!model.ISRetuen.IsNullOrEmpty()) { update.Set(p => p.ISRetuen == model.ISRetuen); } if (!model.ReturnReason.IsNullOrEmpty()) { update.Set(p => p.ReturnReason == model.ReturnReason); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Address model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Address>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.UserId.IsNullOrEmpty()) { update.Set(p => p.UserId == model.UserId); } if (!model.ContactName.IsNullOrEmpty()) { update.Set(p => p.ContactName == model.ContactName); } if (!model.ContactPhone.IsNullOrEmpty()) { update.Set(p => p.ContactPhone == model.ContactPhone); } if (!model.AddrArea.IsNullOrEmpty()) { update.Set(p => p.AddrArea == model.AddrArea); } if (!model.AddrDetail.IsNullOrEmpty()) { update.Set(p => p.AddrDetail == model.AddrDetail); } if (!model.DefaultTime.IsNullOrEmpty()) { update.Set(p => p.DefaultTime == model.DefaultTime); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Materials_Colorinfo model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Materials_Colorinfo>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.MaterialsId.IsNullOrEmpty()) { update.Set(p => p.MaterialsId == model.MaterialsId); } if (!model.SKU.IsNullOrEmpty()) { update.Set(p => p.SKU == model.SKU); } if (!model.ColorId.IsNullOrEmpty()) { update.Set(p => p.ColorId == model.ColorId); } if (!model.MinStockNum.IsNullOrEmpty()) { update.Set(p => p.MinStockNum == model.MinStockNum); } if (!model.SKUImage.IsNullOrEmpty()) { update.Set(p => p.SKUImage == model.SKUImage); } if (!model.PositionInfo.IsNullOrEmpty()) { update.Set(p => p.PositionInfo == model.PositionInfo); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Commrecommend model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Commrecommend>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.CommId.IsNullOrEmpty()) { update.Set(p => p.CommId == model.CommId); } if (!model.OrderID.IsNullOrEmpty()) { update.Set(p => p.OrderID == model.OrderID); } if (!model.FrontImage.IsNullOrEmpty()) { update.Set(p => p.FrontImage == model.FrontImage); } if (!model.AttrSpan.IsNullOrEmpty()) { update.Set(p => p.AttrSpan == model.AttrSpan); } if (!model.BehindImage.IsNullOrEmpty()) { update.Set(p => p.BehindImage == model.BehindImage); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Distribution model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Distribution>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.ProductionId.IsNullOrEmpty()) { update.Set(p => p.ProductionId == model.ProductionId); } if (!model.procedures.IsNullOrEmpty()) { update.Set(p => p.procedures == model.procedures); } if (!model.productionTime.IsNullOrEmpty()) { update.Set(p => p.productionTime == model.productionTime); } if (!model.productionMan.IsNullOrEmpty()) { update.Set(p => p.productionMan == model.productionMan); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Carousel_Image model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Carousel_Image>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.Image.IsNullOrEmpty()) { update.Set(p => p.Image == model.Image); } if (!model.OrderID.IsNullOrEmpty()) { update.Set(p => p.OrderID == model.OrderID); } if (!model.AUrl.IsNullOrEmpty()) { update.Set(p => p.AUrl == model.AUrl); } if (!model.IsCarousel.IsNullOrEmpty()) { update.Set(p => p.IsCarousel == model.IsCarousel); } if (!model.IsPC.IsNullOrEmpty()) { update.Set(p => p.IsPC == model.IsPC); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Storage model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Storage>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.WarehouseId.IsNullOrEmpty()) { update.Set(p => p.WarehouseId == model.WarehouseId); } if (!model.ProducerId.IsNullOrEmpty()) { update.Set(p => p.ProducerId == model.ProducerId); } if (!model.Raw_materialsId.IsNullOrEmpty()) { update.Set(p => p.Raw_materialsId == model.Raw_materialsId); } if (!model.stock.IsNullOrEmpty()) { update.Set(p => p.stock == model.stock); } if (!model.freeze_stock.IsNullOrEmpty()) { update.Set(p => p.freeze_stock == model.freeze_stock); } if (!model.Color.IsNullOrEmpty()) { update.Set(p => p.Color == model.Color); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Changestorage model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Changestorage>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.storageId.IsNullOrEmpty()) { update.Set(p => p.storageId == model.storageId); } if (!model.ChangeTime.IsNullOrEmpty()) { update.Set(p => p.ChangeTime == model.ChangeTime); } if (!model.ChangeType.IsNullOrEmpty()) { update.Set(p => p.ChangeType == model.ChangeType); } if (!model.ChangeCount.IsNullOrEmpty()) { update.Set(p => p.ChangeCount == model.ChangeCount); } if (!model.ChangeAfterCount.IsNullOrEmpty()) { update.Set(p => p.ChangeAfterCount == model.ChangeAfterCount); } if (!model.ChangeContext.IsNullOrEmpty()) { update.Set(p => p.ChangeContext == model.ChangeContext); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Colorinfo model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Colorinfo>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.StandardColor.IsNullOrEmpty()) { update.Set(p => p.StandardColor == model.StandardColor); } if (!model.ChinaDescribe.IsNullOrEmpty()) { update.Set(p => p.ChinaDescribe == model.ChinaDescribe); } if (!model.EngDescibe.IsNullOrEmpty()) { update.Set(p => p.EngDescibe == model.EngDescibe); } if (!model.ParentId.IsNullOrEmpty()) { update.Set(p => p.ParentId == model.ParentId); } if (!model.HtmlCode.IsNullOrEmpty()) { update.Set(p => p.HtmlCode == model.HtmlCode); } if (!model.IsDelete.IsNullOrEmpty()) { update.Set(p => p.IsDelete == model.IsDelete); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Reply model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Reply>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.CreateTime.IsNullOrEmpty()) { update.Set(p => p.CreateTime == model.CreateTime); } if (!model.Content.IsNullOrEmpty()) { update.Set(p => p.Content == model.Content); } if (!model.EvalinfoId.IsNullOrEmpty()) { update.Set(p => p.EvalinfoId == model.EvalinfoId); } if (!model.ImageList.IsNullOrEmpty()) { update.Set(p => p.ImageList == model.ImageList); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Deliver model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Deliver>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.buyerId.IsNullOrEmpty()) { update.Set(p => p.buyerId == model.buyerId); } if (!model.Raw_materialsId.IsNullOrEmpty()) { update.Set(p => p.Raw_materialsId == model.Raw_materialsId); } if (!model.ProducerId.IsNullOrEmpty()) { update.Set(p => p.ProducerId == model.ProducerId); } if (!model.buyerPrice.IsNullOrEmpty()) { update.Set(p => p.buyerPrice == model.buyerPrice); } if (!model.buyerCount.IsNullOrEmpty()) { update.Set(p => p.buyerCount == model.buyerCount); } if (!model.DeliverMoney.IsNullOrEmpty()) { update.Set(p => p.DeliverMoney == model.DeliverMoney); } if (!model.IsStatus.IsNullOrEmpty()) { update.Set(p => p.IsStatus == model.IsStatus); } if (!model.Color.IsNullOrEmpty()) { update.Set(p => p.Color == model.Color); } if (!model.DeliverCountext.IsNullOrEmpty()) { update.Set(p => p.DeliverCountext == model.DeliverCountext); } if (!model.DeliverSinglePerson.IsNullOrEmpty()) { update.Set(p => p.DeliverSinglePerson == model.DeliverSinglePerson); } if (!model.DeliverSingleTime.IsNullOrEmpty()) { update.Set(p => p.DeliverSingleTime == model.DeliverSingleTime); } if (!model.AlreadyQuantity.IsNullOrEmpty()) { update.Set(p => p.AlreadyQuantity == model.AlreadyQuantity); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 将这些id的isdelete设为true /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool DeleteByIds(List <string> ids, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Grade>(); update.Where(p => p.Id.In(ids)); update.Set(p => p.Image == ""); update.Set(p => p.IsDelete == true); return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 订单确定支付 /// </summary> /// <param name="OrderNo">订单号码</param> /// <returns>是否成功</returns> public bool OrderSurePay(string OrderNo) { var update = new LambdaUpdate <Order_Info>(); update.Where(p => p.OrderNo == OrderNo); update.Set(p => p.Status == 3); update.Set(p => p.PayType == 2); return(update.GetUpdateResult()); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Producerinvoice model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Producerinvoice>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.ProducerId.IsNullOrEmpty()) { update.Set(p => p.ProducerId == model.ProducerId); } if (!model.CompanyName.IsNullOrEmpty()) { update.Set(p => p.CompanyName == model.CompanyName); } if (!model.InvoiceNumber.IsNullOrEmpty()) { update.Set(p => p.InvoiceNumber == model.InvoiceNumber); } if (!model.InvoiceTime.IsNullOrEmpty()) { update.Set(p => p.InvoiceTime == model.InvoiceTime); } if (!model.InvoiceMoney.IsNullOrEmpty()) { update.Set(p => p.InvoiceMoney == model.InvoiceMoney); } if (!model.InvoiceIdentify.IsNullOrEmpty()) { update.Set(p => p.InvoiceIdentify == model.InvoiceIdentify); } if (!model.InvoicePhone.IsNullOrEmpty()) { update.Set(p => p.InvoicePhone == model.InvoicePhone); } if (!model.InvoiceAddress.IsNullOrEmpty()) { update.Set(p => p.InvoiceAddress == model.InvoiceAddress); } if (!model.InvoiceBank.IsNullOrEmpty()) { update.Set(p => p.InvoiceBank == model.InvoiceBank); } if (!model.InvoiceContext.IsNullOrEmpty()) { update.Set(p => p.InvoiceContext == model.InvoiceContext); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Invoice model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Invoice>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.UserId.IsNullOrEmpty()) { update.Set(p => p.UserId == model.UserId); } if (!model.OrderId.IsNullOrEmpty()) { update.Set(p => p.OrderId == model.OrderId); } if (!model.Title.IsNullOrEmpty()) { update.Set(p => p.Title == model.Title); } if (!model.DutyParagraph.IsNullOrEmpty()) { update.Set(p => p.DutyParagraph == model.DutyParagraph); } if (!model.TypeInvoice.IsNullOrEmpty()) { update.Set(p => p.TypeInvoice == model.TypeInvoice); } if (!model.InvoiceTime.IsNullOrEmpty()) { update.Set(p => p.InvoiceTime == model.InvoiceTime); } if (!model.MobliePhone.IsNullOrEmpty()) { update.Set(p => p.MobliePhone == model.MobliePhone); } if (!model.OpeningBank.IsNullOrEmpty()) { update.Set(p => p.OpeningBank == model.OpeningBank); } if (!model.BankAccount.IsNullOrEmpty()) { update.Set(p => p.BankAccount == model.BankAccount); } if (!model.Address.IsNullOrEmpty()) { update.Set(p => p.Address == model.Address); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Evaluate model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Evaluate>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.UserId.IsNullOrEmpty()) { update.Set(p => p.UserId == model.UserId); } if (!model.CommodityId.IsNullOrEmpty()) { update.Set(p => p.CommodityId == model.CommodityId); } if (!model.ImageList.IsNullOrEmpty()) { update.Set(p => p.ImageList == model.ImageList); } if (!model.CreateTime.IsNullOrEmpty()) { update.Set(p => p.CreateTime == model.CreateTime); } if (!model.Content.IsNullOrEmpty()) { update.Set(p => p.Content == model.Content); } if (!model.Start.IsNullOrEmpty()) { update.Set(p => p.Start == model.Start); } if (!model.FrontView.IsNullOrEmpty()) { update.Set(p => p.FrontView == model.FrontView); } if (!model.BackView.IsNullOrEmpty()) { update.Set(p => p.BackView == model.BackView); } if (!model.ParentId.IsNullOrEmpty()) { update.Set(p => p.ParentId == model.ParentId); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Platalink model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Platalink>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.Title.IsNullOrEmpty()) { update.Set(p => p.Title == model.Title); } if (!model.Content.IsNullOrEmpty()) { update.Set(p => p.Content == model.Content); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Erpuser model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Erpuser>(); if (!model.ErproleId.IsNullOrEmpty()) { update.Where(p => p.ErproleId == model.ErproleId); } if (!model.ErproleName.IsNullOrEmpty()) { update.Set(p => p.ErproleName == model.ErproleName); } if (!model.ERProlePower.IsNullOrEmpty()) { update.Set(p => p.ERProlePower == model.ERProlePower); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Warehouse model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Warehouse>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.Name.IsNullOrEmpty()) { update.Set(p => p.Name == model.Name); } if (!model.IsDelete.IsNullOrEmpty()) { update.Set(p => p.IsDelete == model.IsDelete); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(User_Like model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <User_Like>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.UserId.IsNullOrEmpty()) { update.Set(p => p.UserId == model.UserId); } if (!model.CommodityId.IsNullOrEmpty()) { update.Set(p => p.CommodityId == model.CommodityId); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Showgradeinfo model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Showgradeinfo>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.GradeId.IsNullOrEmpty()) { update.Set(p => p.GradeId == model.GradeId); } if (!model.OrderCount.IsNullOrEmpty()) { update.Set(p => p.OrderCount == model.OrderCount); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Hot_Search model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Hot_Search>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.SearchWord.IsNullOrEmpty()) { update.Set(p => p.SearchWord == model.SearchWord); } if (!model.Amount.IsNullOrEmpty()) { update.Set(p => p.Amount == model.Amount); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Grade_Attr model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Grade_Attr>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.GradeId.IsNullOrEmpty()) { update.Set(p => p.GradeId == model.GradeId); } if (!model.Content.IsNullOrEmpty()) { update.Set(p => p.Content == model.Content); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Grade model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Grade>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.Name.IsNullOrEmpty()) { update.Set(p => p.Name == model.Name); } if (!model.Image.IsNullOrEmpty()) { update.Set(p => p.Image == model.Image); } if (!model.BigImage.IsNullOrEmpty()) { update.Set(p => p.BigImage == model.BigImage); } if (!model.ParentId.IsNullOrEmpty()) { update.Set(p => p.ParentId == model.ParentId); } if (!model.HotGradeTime.IsNullOrEmpty()) { update.Set(p => p.HotGradeTime == model.HotGradeTime); } if (!model.GradeAttrName.IsNullOrEmpty()) { update.Set(p => p.GradeAttrName == model.GradeAttrName); } if (!model.IsDelete.IsNullOrEmpty()) { update.Set(p => p.IsDelete == model.IsDelete); } if (!model.IsScene.IsNullOrEmpty()) { update.Set(p => p.IsScene == model.IsScene); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Materials_Producer model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Materials_Producer>(); if (!model.Id.IsNullOrEmpty()) { update.Where(p => p.Id == model.Id); } if (!model.ProducerId.IsNullOrEmpty()) { update.Set(p => p.ProducerId == model.ProducerId); } if (!model.MaterialsId.IsNullOrEmpty()) { update.Set(p => p.MaterialsId == model.MaterialsId); } if (!model.FactoryNumber.IsNullOrEmpty()) { update.Set(p => p.FactoryNumber == model.FactoryNumber); } if (!model.PurchasePrice.IsNullOrEmpty()) { update.Set(p => p.PurchasePrice == model.PurchasePrice); } if (!model.QuotationDate.IsNullOrEmpty()) { update.Set(p => p.QuotationDate == model.QuotationDate); } if (!model.ProCycle.IsNullOrEmpty()) { update.Set(p => p.ProCycle == model.ProCycle); } if (!model.MinQuantity.IsNullOrEmpty()) { update.Set(p => p.MinQuantity == model.MinQuantity); } if (!model.PriceTag.IsNullOrEmpty()) { update.Set(p => p.PriceTag == model.PriceTag); } return(update.GetUpdateResult(connection, transaction)); }
/// <summary> /// 根据模型更新 /// </summary> /// <param name="model">模型</param> /// <param name="connection">连接</param> /// <param name="transaction">事务</param> /// <returns>是否成功</returns> public bool Update(Erploginuer model, IDbConnection connection = null, IDbTransaction transaction = null) { var update = new LambdaUpdate <Erploginuer>(); if (!model.erpLoginId.IsNullOrEmpty()) { update.Where(p => p.erpLoginId == model.erpLoginId); } if (!model.ErproleId.IsNullOrEmpty()) { update.Set(p => p.ErproleId == model.ErproleId); } if (!model.erpLoginName.IsNullOrEmpty()) { update.Set(p => p.erpLoginName == model.erpLoginName); } if (!model.erpLoginPwd.IsNullOrEmpty()) { update.Set(p => p.erpLoginPwd == model.erpLoginPwd); } return(update.GetUpdateResult(connection, transaction)); }