/// <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));
}
