public bool Delete(SqlConnection conn, SqlTransaction trans, int storeOutOrderId) { DataSet storeOutGoodsDS = GetList(0, " StoreOutOrderId = " + storeOutOrderId + "", " Id desc"); if (storeOutGoodsDS != null) { StoreInGoods storeInGoodsDAL = new StoreInGoods(); StoreOutWaitingGoods storeOutWaitingGoodsDAL = new StoreOutWaitingGoods(); foreach (DataRow dr in storeOutGoodsDS.Tables[0].Rows) { storeInGoodsDAL.UpdateField(conn, trans, Convert.ToInt32(dr["StoreInGoodsId"]), "Count = Count + " + Convert.ToDecimal(dr["Count"]) + ""); storeOutWaitingGoodsDAL.UpdateField(conn, trans, Convert.ToInt32(dr["StoreOutWaitingGoodsId"]), " Status = 0 "); } StringBuilder strSql = new StringBuilder(); strSql.Append("delete from StoreOutGoods "); strSql.Append(" where StoreOutOrderId=@StoreOutOrderId"); SqlParameter[] parameters = { new SqlParameter("@StoreOutOrderId", SqlDbType.Int, 4) }; parameters[0].Value = storeOutOrderId; int rows = DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } } return(false); }
public bool Delete(SqlConnection conn, SqlTransaction trans, int storeOutOrderId) { DataSet storeOutGoodsDS = GetList(0, " StoreOutOrderId = " + storeOutOrderId + "", " Id desc"); if (storeOutGoodsDS != null) { StoreInGoods storeInGoodsDAL = new StoreInGoods(); StoreOutWaitingGoods storeOutWaitingGoodsDAL = new StoreOutWaitingGoods(); foreach (DataRow dr in storeOutGoodsDS.Tables[0].Rows) { storeInGoodsDAL.UpdateField(conn, trans, Convert.ToInt32(dr["StoreInGoodsId"]), "Count = Count + " + Convert.ToDecimal(dr["Count"]) + ""); storeOutWaitingGoodsDAL.UpdateField(conn, trans, Convert.ToInt32(dr["StoreOutWaitingGoodsId"]), " Status = 0 "); } StringBuilder strSql = new StringBuilder(); strSql.Append("delete from StoreOutGoods "); strSql.Append(" where StoreOutOrderId=@StoreOutOrderId"); SqlParameter[] parameters = { new SqlParameter("@StoreOutOrderId", SqlDbType.Int,4) }; parameters[0].Value = storeOutOrderId; int rows = DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } } return false; }