//修改 public int Upt(Stockindetail m) { string sql = string.Format("update Stockindetail set PlanInQty='{0}',ActInQty='{1}',StoragerackId='{2}',AuditinId='{3}',AuditinTime='{4}',Remark='{5}',CreateBy='{6}',CreateDate='{7}',ModifiedBy='{8}',ModifiedDate='{9}' where StockInDetailId={10}", m.PlanInQty, m.ActInQty, m.StoragerackId, m.AuditinId, m.AuditinTime, m.Remark, m.CreateBy, m.CreateDate, m.ModifiedBy, m.ModifiedDate, m.StockInDetailId); return(DBHelper.ExecuteNonQuery(sql)); }
public int Puts(Stockindetail m) { m.CreateDate = DateTime.Now; return(dal.Upt(m)); }
//添加入库审核 public int Add(Stockindetail m) { string sql = string.Format("insert into Stockindetail values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", m.StockInId, m.Status, m.PlanInQty, m.ActInQty, m.StoragerackId, m.AuditinId, m.AuditinTime, m.Remark, m.CreateBy, m.CreateDate, m.ModifiedBy, m.ModifiedDate); return(DBHelper.ExecuteNonQuery(sql)); }
public int Post([FromBody] Stockindetail m) { m.Status = 0; m.CreateDate = DateTime.Now; return(dal.Add(m)); }