/// <summary> /// 审核/弃审入库 /// </summary> /// <param name="model"></param> /// <param name="t">真为入库,假为出库</param> public void InOrOut(Model.PackAmount model, bool t) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PackAmount set "); if (t) { strSql.Append("Amount=Amount+ @Amount "); } else { strSql.Append("Amount=Amount- @Amount"); } strSql.Append(" where (MListID=@MListID) And (DepartmentID=@DepartmentID) And (MeasureID=@MeasureID) And(PlanID=@PlanID)"); SqlParameter[] parameters = { new SqlParameter("@MListID", SqlDbType.Int, 4), new SqlParameter("@Amount", SqlDbType.Decimal, 9), new SqlParameter("@MeasureID", SqlDbType.Int, 4), new SqlParameter("@DepartmentID", SqlDbType.Int, 4), new SqlParameter("@PlanID", SqlDbType.Int, 4) }; parameters[0].Value = model.MListID; parameters[1].Value = model.Amount; parameters[2].Value = model.MeasureID; parameters[3].Value = model.DepartmentID; parameters[4].Value = model.PlanID; if (DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) == 0 && t) { Add(model); } }
/// <summary> /// 审核/弃审入库 /// </summary> /// <param name="model"></param> /// <param name="t">真为入库,假为出库</param> public void InOrOut(Model.PackAmount model, bool t) { dal.InOrOut(model, t); }