//修改
public int Upt(StockoutDetail m)
{
string sql = string.Format("update Stockoutdetail set PlanOutQty='{0}',ActOutQty='{1}',StoragerackId='{2}',AuditinId='{3}',AuditinTime='{4}',Remark='{5}',CreateBy='{6}',CreateDate='{7}',ModifiedBy='{8}',ModifiedDate='{9}' where StockInDetailId={10}", m.PlanOutQty, m.ActOutQty, m.StoragerackId, m.AuditinId, m.AuditinTime, m.Remark, m.CreateBy, m.CreateDate, m.ModifiedBy, m.ModifiedDate, m.StockInDetailId);
return(DBHelper.ExecuteNonQuery(sql));
}
//添加出库审核
public int Add(StockoutDetail m)
{
string sql = string.Format("insert into StockoutDetail values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}')", m.StockOutId, m.Status, m.PlanOutQty, m.ActOutQty, m.StoragerackId, m.AuditinId, m.AuditinTime, m.Remark, m.CreateBy, m.CreateDate, m.ModifiedBy, m.ModifiedDate);
return(DBHelper.ExecuteNonQuery(sql));
}
public int Putss(StockoutDetail stockoutDetail)
{
stockoutDetail.CreateDate = DateTime.Now;
return(dal.Upt(stockoutDetail));
}
public int Post([FromBody] StockoutDetail m)
{
m.Status = 0;
m.CreateDate = DateTime.Now;
return(dal.Add(m));
}
public static UInt32 Insert(StockoutDetail sod)
{
return(HelperDal <StockoutDetail> .Insert(sod, "SELECT * FROM stockout_detail WHERE som_id=0 AND prd_id=0"));
}
public static bool Update(StockoutDetail sod)
{
return(HelperDal <StockoutDetail> .Update(sod, "SELECT * FROM stockout_detail WHERE som_id=" + sod.som_id + " AND prd_id=" + sod.prd_id));
}