// 修改
public int UptOutLibrary(Model.OutLibrary a)
{
string sql = $"Update Warehouse Set WarehouseId='{a.WarehouseId}' , CommodityId='{a.CommodityId}', GoodNum='{a.GoodNum}'," +
$"OutDate='{a.OutDate}', OutNO='{a.OutNO}' where PutLibraryId='{a.PutLibraryId}' ";
return(DapperHelper.Execute(sql));
}
// 新增
public int AddOutLibrary(Model.OutLibrary a)
{
string sql = $"insert into Warehouse values (null,'{a.WarehouseId}', '{a.CommodityId}'," +
$" '{a.GoodNum}', '{a.OutDate}', '{a.OutNO}')";
return(DapperHelper.Execute(sql));
}
public int Update(Model.OutLibrary Model)
{
string sql = $"UPDATE OutLibrary SET WarehouseId={Model.WarehouseId},CommodityId={Model.CommodityId},GoodNum={Model.GoodNum},OutDate=NOW() WHERE PutLibraryId=({Model.PutLibraryId})";
return(DapperHelper.Execute(sql));
}
public int Insert(Model.OutLibrary Model)
{
string sql = $"INSERT INTO OutLibrary VALUES(NULL,{Model.WarehouseId},{Model.CommodityId},{Model.GoodNum},NOW(),'{Model.OutNO}')";
return(DapperHelper.Execute(sql));
}
