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