//修改
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));
}
