public int Update(Model.Delivery Model)
{
string sql = $"UPDATE Delivery SET DeliveryName='{Model.DeliveryName}',DeliveryPath='{Model.DeliveryPath}' WHERE DeliveryId={Model.DeliveryId}";
return(DapperHelper.Execute(sql));
}
// 修改
public int UptDelivery(Model.Delivery a)
{
string sql = $"Update PutLibrary Set UserId='{a.UserId}' , ColonelID='{a.ColonelID}', DeliveryPath='{a.DeliveryPath}'," +
$"DeliveryName='{a.DeliveryName}' where DeliveryId='{a.DeliveryId}' ";
return DapperHelper.Execute(sql);
}
public int Insert(Model.Delivery Model)
{
string sql = $"INSERT INTO Delivery VALUES(NULL,{Model.UserId},{Model.ColonelID},'{Model.DeliveryPath}','{Model.DeliveryName}')";
return(DapperHelper.Execute(sql));
}
