// 修改
public int UptPutLibrary(Model.PutLibrary a)
{
string sql = $"Update PutLibrary Set WarehouseId='{a.WarehouseId}' , CommodityId='{a.CommodityId}', GoodNum='{a.GoodNum}'," +
$"PutDate='{a.PutDate}', PutNO='{a.PutNO}' where PutLibraryId='{a.PutLibraryId}' ";
return(DapperHelper.Execute(sql));
}
public int Update(Model.PutLibrary Model)
{
string sql = $"UPDATE PutLibrary SET WarehouseId={Model.WarehouseId},CommodityId={Model.CommodityId},GoodNum={Model.GoodNum},PutDate=NOW() WHERE PutLibraryId=({Model.PutLibraryId})";
DapperHelper.Execute($"INSERT INTO Lognote VALUES(NULL,'修改ID为{Model.PutLibraryId}出库信息',NOW(),'出库表')");
return(DapperHelper.Execute(sql));
}
public int Insert(Model.PutLibrary Model)
{
string sql = $"INSERT INTO PutLibrary VALUES(NULL,{Model.WarehouseId},{Model.CommodityId},{Model.GoodNum},NOW(),'{Model.PutNO}')";
DapperHelper.Execute($"INSERT INTO Lognote VALUES(NULL,'添加单号为{Model.PutNO}的出库信息',NOW(),'出库表')");
return(DapperHelper.Execute(sql));
}
// 新增
public int AddPutLibrary(Model.PutLibrary a)
{
string sql = $"insert into PutLibrary values (null,'{a.WarehouseId}', '{a.CommodityId}','{a.GoodNum}', '{a.PutDate}', '{a.PutNO}')";
return(DapperHelper.Execute(sql));
}
public int Update(Model.PutLibrary Model)
{
throw new NotImplementedException();
}
public int Insert(Model.PutLibrary Model)
{
throw new NotImplementedException();
}