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