public int Put([FromBody] Inventorymove value)
{
return(dal.InventorymoveUpt(value));
}
//修改库存移动
public int InventorymoveUpt(Inventorymove Inventorymove)
{
string sql = string.Format("update Inventorymove set SourceStoragerackId='{0}',AimStoragerackId='{1}',Status='{2}',IsDel='{3}',Remark='{4}',CreateBy='{5}',CreateDate='{6}',ModifiedBy='{7}',ModifiedDate='{8}' where InventorymoveId='{9}')", Inventorymove.SourceStoragerackId, Inventorymove.AimStoragerackId, Inventorymove.Status, Inventorymove.IsDel, Inventorymove.Remark, Inventorymove.CreateBy, Inventorymove.CreateDate, Inventorymove.ModifiedBy, Inventorymove.ModifiedDate, Inventorymove.InventorymoveId);
return(DBHelper.ExecuteNonQuery(sql));
}
public int Post([FromBody] Inventorymove value)
{
return(dal.InventorymoveAdd(value));
}
//添加库存移动
public int InventorymoveAdd(Inventorymove Inventorymove)
{
string sql = string.Format("insert into Inventorymove values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')", Inventorymove.SourceStoragerackId, Inventorymove.AimStoragerackId, Inventorymove.Status, Inventorymove.IsDel, Inventorymove.Remark, Inventorymove.CreateBy, Inventorymove.CreateDate = DateTime.Now, Inventorymove.ModifiedBy, Inventorymove.ModifiedDate = DateTime.Now);
return(DBHelper.ExecuteNonQuery(sql));
}
